home / public

reports

13 rows where domain_id = 2787 sorted by checked_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: page_load_ms, 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 ▲
141447a9-aef3-43cb-bab7-e7d1820970b5 2787 2787 https://vard.skane.se/psykiatri-skane https://vard.skane.se/psykiatri-skane 200 80.239.254.34:443 11269 5205 16474 39 1 0 7 warn 1781014407549
d29b48ec-9107-44df-9a85-d2bd1c3bf5cd 2787 2787 https://vard.skane.se/habilitering-och-hjalpmedel https://vard.skane.se/habilitering-och-hjalpmedel 200 80.239.254.34:443 11289 5188 16477 38 1 0 7 warn 1781014390792
8403c676-9cba-4728-a639-f43d4bf8bbe8 2787 2787 https://vard.skane.se/en/skane-university-hospital https://vard.skane.se/en/skane-university-hospital 200 80.239.254.34:443 11251 5136 16387 41 1 0 7 warn 1781014374022
c082561a-6c59-40b7-a309-a6c4c097538d 2787 2787 https://vard.skane.se/skanes-universitetssjukhus-sus https://vard.skane.se/skanes-universitetssjukhus-sus 200 80.239.254.34:443 11351 5394 16745 41 1 0 7 warn 1781014357347
00930aae-2d61-4de2-9b61-8a95024778c0 2787 2787 https://vard.skane.se/lasarettet-i-ystad https://vard.skane.se/lasarettet-i-ystad 200 80.239.254.34:443 11340 5149 16489 38 1 0 7 warn 1781014340332
9cc5a63b-5157-4e7f-b7c3-be869e60a3e1 2787 2787 https://vard.skane.se/lasarettet-trelleborg https://vard.skane.se/lasarettet-trelleborg 200 80.239.254.34:443 11223 5135 16358 38 1 0 7 warn 1781014323548
0fa97b52-8aa8-4661-a9bc-ad4504274f97 2787 2787 https://vard.skane.se/lasarettet-i-landskrona https://vard.skane.se/lasarettet-i-landskrona 200 80.239.254.34:443 11367 5132 16499 38 1 0 7 warn 1781014306900
6982336f-2dc9-4fb7-a049-a9fbe99335e2 2787 2787 https://vard.skane.se/angelholms-sjukhus https://vard.skane.se/angelholms-sjukhus 200 80.239.254.34:443 11242 5124 16366 38 1 0 7 warn 1781014290114
7e88749f-e60c-4b39-9e28-478bd9c1eec8 2787 2787 https://vard.skane.se/hassleholms-sjukhus https://vard.skane.se/hassleholms-sjukhus 200 80.239.254.34:443 11253 5147 16400 38 1 0 7 warn 1781014273487
91ae24e1-257f-4c84-a21f-9a4b6ca60e9d 2787 2787 https://vard.skane.se/helsingborgs-lasarett https://vard.skane.se/helsingborgs-lasarett 200 80.239.254.34:443 11472 5128 16600 38 1 0 7 warn 1781014256824
d1ecf226-64bd-4038-ad58-23ede6c8a371 2787 2787 https://vard.skane.se/centralsjukhuset-kristianstad-csk https://vard.skane.se/centralsjukhuset-kristianstad-csk 200 80.239.254.34:443 11223 5131 16354 38 1 0 7 warn 1781014239952
75caadc7-52b6-48e7-90ae-beb6ca2f472e 2787 2787 https://vard.skane.se/primarvarden https://vard.skane.se/primarvarden 200 80.239.254.34:443 11312 5120 16432 35 1 0 7 warn 1781014223335
83f8c8d8-033e-445c-9bf4-b15db6338bea 2787 2787 https://vard.skane.se/ https://vard.skane.se/ 200 80.239.254.34:443 11267 5059 16326 29 1 0 7 warn 1781014189320

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