SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-09T09:02:14.749192+00:00","dedupe_key":"signal_enriched:news_delta:6694fc27adf4e720","evidence_event_ids":["evt_180d30ee1dea"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

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

event_store.db — events

Update row 9428 in events