reports
1 row where domain_id = 2745 sorted by checked_at descending
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 ▲ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6597684d-f9d2-420f-800c-4d85b529f5e4 | 2745 2745 | https://eportal.billerud.com/ | https://eportal.billerud.com/en/login | 200 | 20.82.22.191:443 | 12610 | 44 | 12654 | 56 | 2 | 1 | 3 | bad | 1781012845043 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);