home / public

reports

4 rows where domain_id = 11 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 ▲
a84e07d3-3060-4f5f-b2ee-83c91159f713 11 11 https://www.hoor.se/ https://www.hoor.se/ 200 194.54.164.188:443 11348 3204 14552 56 0 0 10 good 1781012320858
e19378ec-645d-487d-b321-3cce24224ce0 11 11 https://hoor.se/ https://www.hoor.se/ 200 194.54.164.188:443 11540 56 11596 58 0 0 10 good 1780684736277
6f5f283b-acce-4c7e-bf98-22ee66f6b63f 11 11 https://hoor.se/ https://www.hoor.se/ 200 194.54.164.188:443 11823 42 11865 59 0 0 10 good 1779174003054
b9097852-a8f4-4e80-9bab-87aab6118c57 11 11 https://hoor.se/ https://www.hoor.se/ 200 194.54.164.188:443 11544 44 11588 59 0 0     1778597707858

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 18.029ms