security_snapshot
4 rows
This data as json, CSV (advanced)
| days_back ▼ | refreshed_at | fw_asn_json | source_summary_json |
|---|---|---|---|
| 1 | 2026-07-21T20:43:43Z | [{"asn": "11427", "asn_desc": "Charter Communications Inc", "country": "US", "n": 8101, "most_recent": "2026-07-21T20:25:04Z"}, {"asn": "62744", "asn_desc": "Quintex Alliance Consulting", "country": "… | [{"source": "bc:systemlog", "severity": "errors", "n": 53}, {"source": "authnet:transaction", "severity": "warning", "n": 4}, {"source": "authnet:transaction:detail", "severity": "warning", "n": 4}, {… |
| 7 | 2026-07-21T20:43:43Z | [{"asn": "11427", "asn_desc": "Charter Communications Inc", "country": "US", "n": 56366, "most_recent": "2026-07-21T20:25:04Z"}, {"asn": "60729", "asn_desc": "Stiftung Erneuerbare Freiheit", "country"… | [{"source": "authnet:transaction", "severity": "warning", "n": 273}, {"source": "authnet:transaction:detail", "severity": "warning", "n": 273}, {"source": "bc:systemlog", "severity": "errors", "n": 19… |
| 30 | 2026-07-21T20:43:43Z | [{"asn": "11427", "asn_desc": "Charter Communications Inc", "country": "US", "n": 68749, "most_recent": "2026-07-21T20:25:04Z"}, {"asn": "60729", "asn_desc": "Stiftung Erneuerbare Freiheit", "country"… | [{"source": "authnet:transaction", "severity": "warning", "n": 1316}, {"source": "authnet:transaction:detail", "severity": "warning", "n": 1316}, {"source": "bc:systemlog", "severity": "errors", "n": … |
| 90 | 2026-07-21T20:43:43Z | [{"asn": "11427", "asn_desc": "Charter Communications Inc", "country": "US", "n": 68755, "most_recent": "2026-07-21T20:25:04Z"}, {"asn": "8075", "asn_desc": "Microsoft Corporation", "country": "US", "… | [{"source": "cloudflare:state_diff", "severity": "warn", "n": 6660}, {"source": "authnet:transaction", "severity": "warning", "n": 4691}, {"source": "authnet:transaction:detail", "severity": "warning"… |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE security_snapshot (
days_back INTEGER PRIMARY KEY,
refreshed_at TEXT NOT NULL,
fw_asn_json TEXT NOT NULL,
source_summary_json TEXT NOT NULL
);