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/CBMiiAJBVV95cUxQNDAtLXdrajdfeEVZR2cyMTdBMEJWRFFlNndVZGc3ck4yeXIydThaX0lWbmFFUmdjMkE0ekE0MkJIbDE5UmdwNWt2bXNmT012RWwtdU5XVGZHYU1Va0U5TUVuQllBal9vWEtBMXltYTRrTVhkdFBkc25KdG10R2oyTnhPWklfZ3ZHU3lJSEJxX0hhTUI2SGJKRWV2X2h1TW94UlJTT0prd0FNcTAxUDJVRl93MVRNeHg1V1NscjdrVTJZaVJ6MWpnUFJncTBUN2JDTFNHSmVpWmVieGxYdHhNSU1BcktOb0ZhazdhbTBLc3ZfamFKVkdDcW5SRHpiRW8zRHl3MFk2Wmw?oc=5","as_of":"2026-04-07T14:17:34.739209+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/CBMiiAJBVV95cUxQNDAtLXdrajdfeEVZR2cyMTdBMEJWRFFlNndVZGc3ck4yeXIydThaX0lWbmFFUmdjMkE0ekE0MkJIbDE5UmdwNWt2bXNmT012RWwtdU5XVGZHYU1Va0U5TUVuQllBal9vWEtBMXltYTRrTVhkdFBkc25KdG10R2oyTnhPWklfZ3ZHU3lJSEJxX0hhTUI2SGJKRWV2X2h1TW94UlJTT0prd0FNcTAxUDJVRl93MVRNeHg1V1NscjdrVTJZaVJ6MWpnUFJncTBUN2JDTFNHSmVpWmVieGxYdHhNSU1BcktOb0ZhazdhbTBLc3ZfamFKVkdDcW5SRHpiRW8zRHl3MFk2Wmw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_cb770c2fbef2c4af","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-07T20:02:01.130956+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAJBVV95cUxQNDAtLXdrajdfeEVZR2cyMTdBMEJWRFFlNndVZGc3ck4yeXIydThaX0lWbmFFUmdjMkE0ekE0MkJIbDE5UmdwNWt2bXNmT012RWwtdU5XVGZHYU1Va0U5TUVuQllBal9vWEtBMXltYTRrTVhkdFBkc25KdG10R2oyTnhPWklfZ3ZHU3lJSEJxX0hhTUI2SGJKRWV2X2h1TW94UlJTT0prd0FNcTAxUDJVRl93MVRNeHg1V1NscjdrVTJZaVJ6MWpnUFJncTBUN2JDTFNHSmVpWmVieGxYdHhNSU1BcktOb0ZhazdhbTBLc3ZfamFKVkdDcW5SRHpiRW8zRHl3MFk2Wmw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiiAJBVV95cUxQNDAtLXdrajdfeEVZR2cyMTdBMEJWRFFlNndVZGc3ck4yeXIydThaX0lWbmFFUmdjMkE0ekE0MkJIbDE5UmdwNWt2bXNmT012RWwtdU5XVGZHYU1Va0U5TUVuQllBal9vWEtBMXltYTRrTVhkdFBkc25KdG10R2oyTnhPWklfZ3ZHU3lJSEJxX0hhTUI2SGJKRWV2X2h1TW94UlJTT0prd0FNcTAxUDJVRl93MVRNeHg1V1NscjdrVTJZaVJ6MWpnUFJncTBUN2JDTFNHSmVpWmVieGxYdHhNSU1BcktOb0ZhazdhbTBLc3ZfamFKVkdDcW5SRHpiRW8zRHl3MFk2Wmw?oc=5","source_event_id":"evt_9a74d1ad9ec1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a00225cb7c4f8486","published_at":"2026-04-07T09:58:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"Department of Homeland Security","relevance":"affected by the shutdown","symbol":"DHS","type":"government"},{"asset_class":"political","name":"Mike Johnson","relevance":"House Speaker facing dissent","symbol":"N/A","type":"individual"},{"asset_class":"political","name":"Republican Party","relevance":"internal conflict over funding","symbol":"N/A","type":"political party"}],"event_type":"regulation","information_gaps":["Details on the specific funding deal being contested","Potential impacts of the shutdown on DHS operations","Timeline for resolution of the funding conflict"],"key_facts":["DHS shutdown has lasted eight weeks","Mike Johnson is facing a revolt from Republicans over funding"],"numeric_claims":[],"primary_claim":"The DHS shutdown has entered its eighth week amid Republican discord over funding.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"The DHS shutdown has now lasted eight weeks, with House Speaker Mike Johnson facing internal dissent from Republicans regarding a funding deal.","topics":["DHS shutdown","Republican Party","government funding"]},"source":"theguardian.com","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"DHS shutdown enters eighth week as Mike Johnson faces Republican revolt over funding deal \u2013 live theguardian.com Democrats Insist They Won the Shutdown Fight. Some Aren't So Sure Time Magazine House Republicans kvetch anew about DHS funding plan Politico Inside Johnson and Thune\u2019s clash over DHS \u2014 and how Trump burned them both ms.now You Gotta Hand It to Chuck Schumer This Time The American Prospect","title":"DHS shutdown enters eighth week as Mike Johnson faces Republican revolt over funding deal \u2013 live - theguardian.com","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_62f68bc040cd in signals