SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxNdWN6R1MtU0cwd1JRVkVVanl1UXpPdFFEWWpFZm9Wdi1rSzQxeXNOcDBMNHN2VmhxbnVUYWwzX1VSUzYzMXJ3MS1JOWlOMFNFYXRXMXg4S0pRMXB0SXNROFBSd1RPVlZiMnBkbUg0UTV2cjVaNGtaanU1OVFWUWNRbGtlNFZTUnh5ZmUwTFFiSDBKSFg0SlQ5WWhYNzlIdUxpRWNFdHh3VW55UEtBN05ReXV2Tno0ajFNVnRWSWtkWkc?oc=5","as_of":"2026-04-09T00:58:23.725978+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxNdWN6R1MtU0cwd1JRVkVVanl1UXpPdFFEWWpFZm9Wdi1rSzQxeXNOcDBMNHN2VmhxbnVUYWwzX1VSUzYzMXJ3MS1JOWlOMFNFYXRXMXg4S0pRMXB0SXNROFBSd1RPVlZiMnBkbUg0UTV2cjVaNGtaanU1OVFWUWNRbGtlNFZTUnh5ZmUwTFFiSDBKSFg0SlQ5WWhYNzlIdUxpRWNFdHh3VW55UEtBN05ReXV2Tno0ajFNVnRWSWtkWkc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4db7ac758546b038","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-09T22:21:37.238810+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxNdWN6R1MtU0cwd1JRVkVVanl1UXpPdFFEWWpFZm9Wdi1rSzQxeXNOcDBMNHN2VmhxbnVUYWwzX1VSUzYzMXJ3MS1JOWlOMFNFYXRXMXg4S0pRMXB0SXNROFBSd1RPVlZiMnBkbUg0UTV2cjVaNGtaanU1OVFWUWNRbGtlNFZTUnh5ZmUwTFFiSDBKSFg0SlQ5WWhYNzlIdUxpRWNFdHh3VW55UEtBN05ReXV2Tno0ajFNVnRWSWtkWkc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"justice.gov","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwAFBVV95cUxNdWN6R1MtU0cwd1JRVkVVanl1UXpPdFFEWWpFZm9Wdi1rSzQxeXNOcDBMNHN2VmhxbnVUYWwzX1VSUzYzMXJ3MS1JOWlOMFNFYXRXMXg4S0pRMXB0SXNROFBSd1RPVlZiMnBkbUg0UTV2cjVaNGtaanU1OVFWUWNRbGtlNFZTUnh5ZmUwTFFiSDBKSFg0SlQ5WWhYNzlIdUxpRWNFdHh3VW55UEtBN05ReXV2Tno0ajFNVnRWSWtkWkc?oc=5","source_event_id":"evt_6c5aace2c167","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"72759bfe1065c5e6","published_at":"2026-04-08T19:42:59+00:00","publisher_domain":"justice.gov","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"U.S. Department of Justice (DOJ)","relevance":"primary source","symbol":"","type":"government_agency"},{"asset_class":"person","name":"Former Army employee (name not provided in provided text)","relevance":"defendant","symbol":"","type":"individual"},{"asset_class":"government","name":"FBI","relevance":"investigating/arresting authority (per source summary)","symbol":"","type":"law_enforcement_agency"},{"asset_class":"infrastructure","name":"Fort Bragg","relevance":"location referenced in source summary","symbol":"","type":"military_base"},{"asset_class":"media","name":"CNN","relevance":"journalist outlet allegedly receiving leaked information","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"CBS News","relevance":"journalist outlet allegedly receiving leaked information","symbol":"","type":"media_outlet"},{"asset_class":"media","name":"The Hill","relevance":"journalist outlet referenced in source summary","symbol":"","type":"media_outlet"}],"event_type":"regulation","information_gaps":["The defendant\u2019s name is not present in the provided text.","Specific charges, statutes, and the alleged timeline/quantity/type of classified material are not included in the provided text.","The DOJ article\u2019s filing date and court jurisdiction are not provided.","Whether the DOJ alleges a specific journalist or multiple journalists is not fully verifiable from the provided excerpt (only outlet names are mentioned in the source summary)."],"key_facts":["DOJ states a former Army employee and top secret clearance holder was arrested and charged with leaking classified national defense information.","The source summary indicates the alleged leak was to journalists at CNN and CBS News (and also references The Hill).","The source summary indicates the individual was a former Fort Bragg employee.","The source summary indicates the FBI arrested the individual over the alleged leak."],"numeric_claims":[],"primary_claim":"The DOJ arrested and charged a former Army employee/top secret clearance holder with leaking classified national defense information to journalists.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"The U.S. Department of Justice says a former Army employee with a top secret clearance has been arrested and charged for allegedly leaking classified national defense information to journalists (CNN/CBS News).","topics":["classified information","national defense information","leaks","top secret clearance","FBI arrest","journalist contacts","criminal charges"]},"source":"Department of Justice (.gov)","source_domain":"justice.gov","source_url":"https://www.justice.gov","summary":"Former Army Employee and Top Secret Clearance Holder Arrested and Charged with Leaking Classified National Defense Information Department of Justice (.gov) Former Fort Bragg employee charged with leaking classified information to journalist CNN Ex-Army employee charged with leaking classified military information to reporter CBS News Ex-Army employee with top secret clearance charged with leaking information to journalist The Hill FBI Arrests Ex-Army Employee Over Alleged Leak to Journalist Bloomberg.com","title":"Former Army Employee and Top Secret Clearance Holder Arrested and Charged with Leaking Classified National Defense Information - Department of Justice (.gov)","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_7c38bb1acbee in signals