home / public

reports

1 row where domain_id = 2741 sorted by checked_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

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 ▲
2d02a98a-b1aa-4507-9795-ef0471ed87fb 2741 2741 https://frontend.uat.kommunal.dgstage.se/ https://authentik.kommunal.open-public.org/if/flow/default-authentication-flow/?next=%2Fapplication%2Fo%2Fauthorize%2F%3Fclient_id%3DWAHVh8OlI12zbkeVZ08w0HQenyyFTvGw2IIvSJvU%26redirect_uri%3Dhttps%253A%252F%252Ffrontend.uat.kommunal.dgstage.se%252Foutpost.goauthentik.io%252Fcallback%253FX-authentik-auth-callback%253Dtrue%26response_type%3Dcode%26scope%3Dprofile%2Bopenid%2Bentitlements%2Bemail%2Bak_proxy%26state%3DeyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnb2F1dGhlbnRpay5pby9vdXRwb3N0L1dBSFZoOE9sSTEyemJrZVZaMDh3MEhRZW55eUZUdkd3MklJdlNKdlUiLCJzaWQiOiJMVFIzM0o3QVNBU1NNWVROWUNPUkVHUzNIUlE1UFhOR0pKVU1YRkFRQVZXRjNOSFpYQVBBIiwic3RhdGUiOiJXRmt2dTlvWlp5YnlfM0JzRXF2NlFzTWdRTmlIMXl3dDNRWklGclgtZmlBIiwicmVkaXJlY3QiOiJodHRwczovL2Zyb250ZW5kLnVhdC5rb21tdW5hbC5kZ3N0YWdlLnNlLyJ9.Fr0HvZtrxG9AfAGF59J3lFwVD3R2aDSCGhfqHjZN3lM 200 212.237.145.120:443 12269 52 12321 80 2 1 0 none 1781012716463

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