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/CBMickFVX3lxTE4ya01BV1Vqd2g2VkhVQnBySXRldjJFUW53Z0hLTjdmT3ozV05YOXZ2VWo4SUZWc3M0eVh0VzB0ZnQ1LXBUaER0ekdTeUttUEdIS043V2VUcWdBcmptSDIxZFRZYUFuTGp3dVphY1MySDZwQQ?oc=5","as_of":"2026-04-03T16:26:12.084790+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMickFVX3lxTE4ya01BV1Vqd2g2VkhVQnBySXRldjJFUW53Z0hLTjdmT3ozV05YOXZ2VWo4SUZWc3M0eVh0VzB0ZnQ1LXBUaER0ekdTeUttUEdIS043V2VUcWdBcmptSDIxZFRZYUFuTGp3dVphY1MySDZwQQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_f42ab69589b0ee6f","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-03T22:45:31.523553+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMickFVX3lxTE4ya01BV1Vqd2g2VkhVQnBySXRldjJFUW53Z0hLTjdmT3ozV05YOXZ2VWo4SUZWc3M0eVh0VzB0ZnQ1LXBUaER0ekdTeUttUEdIS043V2VUcWdBcmptSDIxZFRZYUFuTGp3dVphY1MySDZwQQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"axios.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMickFVX3lxTE4ya01BV1Vqd2g2VkhVQnBySXRldjJFUW53Z0hLTjdmT3ozV05YOXZ2VWo4SUZWc3M0eVh0VzB0ZnQ1LXBUaER0ekdTeUttUEdIS043V2VUcWdBcmptSDIxZFRZYUFuTGp3dVphY1MySDZwQQ?oc=5","source_event_id":"evt_014f70176ce4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"8bbab76216e11a1d","published_at":"2026-04-03T12:07:53+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"politics","name":"Mike Johnson","relevance":"high","symbol":"","type":"person"},{"asset_class":"government","name":"Department of Homeland Security (DHS)","relevance":"high","symbol":"","type":"government agency"}],"event_type":"regulation","information_gaps":["Specific timing for the rescheduled vote is unclear.","Details on the internal Republican conflicts are not provided."],"key_facts":["Mike Johnson is the Speaker of the House.","The decision reflects internal Republican conflicts regarding funding priorities."],"numeric_claims":[],"primary_claim":"Mike Johnson will delay the vote to fund DHS.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Mike Johnson has decided to postpone a vote on funding the Department of Homeland Security (DHS), reflecting challenges in his leadership and the Republican strategy regarding the DHS shutdown.","topics":["DHS funding","government shutdown","Republican strategy"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"Mike Johnson will wait on holding a vote to fund DHS Axios Johnson Wavers on Ending the Shutdown, Reflecting His Weak Hold on Power The New York Times Republicans delay an end to DHS shutdown \u2014 and to Mike Johnson\u2019s misery ms.now 4/3/26\u2600\ufe0f AM: Punchbowl News House Republicans seek to fund ICE before passing Senate DHS bill, complicating plan to end shutdown thehill.com","title":"Mike Johnson will wait on holding a vote to fund DHS - Axios","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/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_4015bca3d136 in signals