reports

3 rows where domain_id = 15 sorted by checked_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: input_url, cookies_count

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 ▲
b43fe516-dd29-4fd7-89f5-7e78687dffbd 15 15 http://www.billerud.com/ https://www.billerud.com/ 200 172.64.154.31:443 13337 5024 18361 111 9 0 10 good 1781012703937
6ed6cbac-44e6-4996-997c-51c64a56c121 15 15 https://billerud.com/ https://www.billerud.com/ 200 172.64.154.31:443 13240 5051 18291 113 9 0 7 warn 1780737683025
f50d6586-5451-4f45-b865-7506a9e7e630 15 15 https://billerud.com/ https://www.billerud.com/ 200 172.64.154.31:443 12960 5064 18024 107 8 0     1778598247807

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