home / public

reports

7 rows where domain_id = 181 sorted by checked_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: input_url, responses_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 ▲
c7ceaa79-5c5b-472e-bf78-2ae07a1d1f2b 181 181 https://www.akademssr.se/ https://akademssr.se/ 200 188.126.67.5:443 11813 5940 17753 78 0 2 10 good 1781012489981
d817fbd0-bc8c-4b0b-a058-109208716fc3 181 181 https://akademssr.se/ https://akademssr.se/ 200 188.126.67.5:443 12305 5970 18275 77 0 2 10 good 1780913311866
49398508-dbb7-4276-9f48-50614acac889 181 181 https://akademssr.se/ https://akademssr.se/ 200 188.126.67.5:443 12062 5130 17192 77 0 2 10 good 1780905963243
b094c445-41f1-4d3d-a4cc-77c95551f5d3 181 181 https://akademssr.se/ https://akademssr.se/ 200 188.126.67.5:443 11990 5095 17085 77 0 2 10 good 1780904249036
12a2323f-cd2e-427d-9db3-ca10d3dff999 181 181 https://akademssr.se/ https://akademssr.se/ 200 188.126.67.5:443 11674 5128 16802 77 0 2 10 good 1780684753575
00d37209-f451-4a34-82e4-81190fd40101 181 181 https://akademssr.se/ https://akademssr.se/ 200 188.126.67.5:443 11551 5099 16650 77 0 2 10 good 1780495062048
eb205ceb-a9ae-4a9a-8bac-ac7a14e40092 181 181 https://akademssr.se/ https://akademssr.se/ 200 188.126.67.5:443 11565 5104 16669 77 0 2 10 good 1780406039587

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);
Powered by Datasette · Queries took 36.883ms