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/CBMiuAFBVV95cUxNLTRpeWMxOGdHRVh6RVREc1RNdlhpYlNXS1l1M0J1UzAtMDlQNV9wRVgyVDFjWDVQMGs5aXZTcWNLRWVLVGZiLVdwUWx3OGNJUGk4NVdmdFd1VWdNS2MwcmQ2LXVSSzdNTEcybmlXLXI4WTlaSm9GN0FSQzJlVTZYZXExZGJPTnBvUVAzSDBCVVllR1ktR2pjbnJBVjYwcjVlUUgxcUFsRXBUeU1FUUIwQzc4Vm11Q25P?oc=5","as_of":"2026-04-09T09:02:14.749192+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/CBMiuAFBVV95cUxNLTRpeWMxOGdHRVh6RVREc1RNdlhpYlNXS1l1M0J1UzAtMDlQNV9wRVgyVDFjWDVQMGs5aXZTcWNLRWVLVGZiLVdwUWx3OGNJUGk4NVdmdFd1VWdNS2MwcmQ2LXVSSzdNTEcybmlXLXI4WTlaSm9GN0FSQzJlVTZYZXExZGJPTnBvUVAzSDBCVVllR1ktR2pjbnJBVjYwcjVlUUgxcUFsRXBUeU1FUUIwQzc4Vm11Q25P?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9063322f5e812643","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:57:42.629488+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxNLTRpeWMxOGdHRVh6RVREc1RNdlhpYlNXS1l1M0J1UzAtMDlQNV9wRVgyVDFjWDVQMGs5aXZTcWNLRWVLVGZiLVdwUWx3OGNJUGk4NVdmdFd1VWdNS2MwcmQ2LXVSSzdNTEcybmlXLXI4WTlaSm9GN0FSQzJlVTZYZXExZGJPTnBvUVAzSDBCVVllR1ktR2pjbnJBVjYwcjVlUUgxcUFsRXBUeU1FUUIwQzc4Vm11Q25P?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"politico.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiuAFBVV95cUxNLTRpeWMxOGdHRVh6RVREc1RNdlhpYlNXS1l1M0J1UzAtMDlQNV9wRVgyVDFjWDVQMGs5aXZTcWNLRWVLVGZiLVdwUWx3OGNJUGk4NVdmdFd1VWdNS2MwcmQ2LXVSSzdNTEcybmlXLXI4WTlaSm9GN0FSQzJlVTZYZXExZGJPTnBvUVAzSDBCVVllR1ktR2pjbnJBVjYwcjVlUUgxcUFsRXBUeU1FUUIwQzc4Vm11Q25P?oc=5","source_event_id":"evt_180d30ee1dea","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c8c16e773c193a4b","published_at":"2026-04-09T03:15:12+00:00","publisher_domain":"politico.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Army veteran (suspected leaker)","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Delta Force","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"Fort Bragg","relevance":"medium","symbol":"","type":"location"},{"asset_class":"other","name":"FBI","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"Fox News journalist","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"Politico","relevance":"low","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The article text provided is not actually the news content (it appears to be page styling/HTML), so details like the veteran\u2019s name, specific charges, dates, and the exact nature of the tactics disclosed are not available here.","No information is provided on whether the veteran has entered a plea or the status of the case beyond being charged/arrested.","No near-term timing (e.g., court date) is included in the provided material."],"key_facts":["Politico headline states an Army veteran was charged with disclosing classified Delta Force tactics.","The provided source summary indicates the person was a former Fort Bragg employee.","The provided source summary indicates the FBI arrested the suspected leaker over an alleged classified leak to a journalist (Fox News mentioned).","The alleged disclosure involved classified military information/tactics related to Delta Force."],"numeric_claims":[],"primary_claim":"An Army veteran was charged with disclosing classified Delta Force tactics to a journalist.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Politico reports that an Army veteran (a former Fort Bragg employee) has been charged with disclosing classified Delta Force tactics to a journalist. The alleged leak is tied to an FBI arrest of the suspected leaker.","topics":["classified information","Delta Force tactics","leak investigation","FBI arrest","military security","journalism"]},"source":"Politico","source_domain":"politico.com","source_url":"https://www.politico.com","summary":"Army veteran charged with disclosing classified Delta Force tactics Politico Former Fort Bragg employee charged with leaking classified military information to journalist Fox News FBI arrests suspected leaker of downed fighter jet over Iran The Center Square FBI arrests ex-Fort Bragg employee over alleged classified leak to journalist The Guardian US Army veteran charged with leaking classified information to journalist Reuters","title":"Army veteran charged with disclosing classified Delta Force tactics - Politico","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_823cbd4cc322 in signals