reports

3 rows where domain_id = 2407 sorted by checked_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: server

id domain_id input_url final_url http_status server page_load_ms consent_phase_ms total_ms responses_count cookies_count local_storage_count analytics_score analytics_verdict checked_at ▲
6f40bdd7-ccb2-4201-a940-98fb89092076 2407 2407 http://mcf.se/ https://www.mcf.se/ 200 95.100.107.164:443 11879 6083 17962 32 0 0 10 good 1781013897935
ec6ef9ad-4f4e-4fa9-9dae-7671b7dc0194 2407 2407 https://www.msb.se/ https://www.mcf.se/ 200 95.100.107.164:443 12057 5979 18036 32 0 0 10 good 1781013201673
b89b7f69-914d-4a60-a411-adfcb7f6187f 2407 2407 https://mcf.se/ https://www.mcf.se/ 200 95.100.155.160:443 11949 5073 17022 32 0 0 10 good 1780752918606

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE reports (
  id                  TEXT    PRIMARY KEY,
  domain_id           INTEGER NOT NULL REFERENCES domains(id),
  input_url           TEXT    NOT NULL,
  final_url           TEXT    NOT NULL,
  http_status         INTEGER NOT NULL,
  server              TEXT,
  page_load_ms        INTEGER,
  consent_phase_ms    INTEGER,
  total_ms            INTEGER,
  responses_count     INTEGER,
  cookies_count       INTEGER,
  local_storage_count INTEGER,
  analytics_score     INTEGER,
  analytics_verdict   TEXT,
  checked_at          INTEGER NOT NULL
);
CREATE INDEX idx_reports_domain_checked ON reports(domain_id, checked_at DESC);