reports

3 rows where domain_id = 1593 sorted by checked_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: final_url

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 ▲
f39116aa-e2e4-4db5-8088-22a190d2abc2 1593 1593 https://www.nrm.se/ https://www.nrm.se/ 200 185.84.52.157:443 11401 5271 16672 75 2 1 0 none 1781012574533
d897fbcd-4506-4a03-89b0-3432fd24a50b 1593 1593 http://pollenrapporten.se/ https://www.nrm.se/natur--och-miljoovervakning/pollenovervakning/pollenrapporten 200 185.84.52.157:443 11362 5176 16538 68 4 1 0 none 1781012198320
41f168f3-c8bb-4ce9-9476-89ae91514de1 1593 1593 https://nrm.se/ https://www.nrm.se/ 200 185.84.52.157:443 11416 5045 16461 76 3 1 0 none 1780694317086

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);