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/CBMid0FVX3lxTE12ZlBDUEJ0dkFaZ21ETlI5V3c4b2ZuM2xfZDR2WVI5RGJDNXJkVmpPTnZVVHR5YkxMTlRCdXlSaWR2cHZDWEFWYmdibFJVdmNVZENDNUJ2NmJaOGdXV1hpTzdWVVFndTJHNFlXTUhUR3hld3VEcGpr?oc=5","as_of":"2026-04-08T01:43:33.369124+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/CBMid0FVX3lxTE12ZlBDUEJ0dkFaZ21ETlI5V3c4b2ZuM2xfZDR2WVI5RGJDNXJkVmpPTnZVVHR5YkxMTlRCdXlSaWR2cHZDWEFWYmdibFJVdmNVZENDNUJ2NmJaOGdXV1hpTzdWVVFndTJHNFlXTUhUR3hld3VEcGpr?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_157db5aed80bfadf","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-08T01:43:58.455103+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMid0FVX3lxTE12ZlBDUEJ0dkFaZ21ETlI5V3c4b2ZuM2xfZDR2WVI5RGJDNXJkVmpPTnZVVHR5YkxMTlRCdXlSaWR2cHZDWEFWYmdibFJVdmNVZENDNUJ2NmJaOGdXV1hpTzdWVVFndTJHNFlXTUhUR3hld3VEcGpr?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/CBMid0FVX3lxTE12ZlBDUEJ0dkFaZ21ETlI5V3c4b2ZuM2xfZDR2WVI5RGJDNXJkVmpPTnZVVHR5YkxMTlRCdXlSaWR2cHZDWEFWYmdibFJVdmNVZENDNUJ2NmJaOGdXV1hpTzdWVVFndTJHNFlXTUhUR3hld3VEcGpr?oc=5","source_event_id":"evt_e7c2d18a3ca4","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"fc712119bea8de5e","published_at":"2026-04-07T22:55:44+00:00","publisher_domain":"axios.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"","name":"GOP dissenters","relevance":"affected","symbol":"","type":"political_group"},{"asset_class":"","name":"Donald Trump","relevance":"actor","symbol":"","type":"person"},{"asset_class":"","name":"Iran","relevance":"target","symbol":"","type":"country"},{"asset_class":"","name":"Axios","relevance":"source","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["No details are provided on who the GOP dissenters are (names, factions, or numbers).","No specifics are provided about the content, timing, or context of Trump\u2019s threat.","No information is provided on policy or action implications beyond the existence of dissent.","No near-term catalyst timing is stated in the provided text."],"key_facts":["Axios headline states that GOP dissenters are emerging on Trump\u2019s threat against Iranian \u201ccivilization.\u201d","The provided text does not include additional details beyond the headline/source summary."],"numeric_claims":[],"primary_claim":"GOP dissenters are emerging on Trump\u2019s threat against Iranian \u201ccivilization,\u201d according to Axios.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Axios reports that GOP dissenters are emerging in response to President Trump\u2019s threat against Iranian \u201ccivilization.\u201d The headline indicates internal Republican disagreement over the rhetoric toward Iran.","topics":["U.S. politics","Iran","Trump rhetoric","Republican Party dissent"]},"source":"Axios","source_domain":"axios.com","source_url":"https://www.axios.com","summary":"GOP dissenters emerge on Trump's threat against Iranian \"civilization\" Axios View Full Coverage on Google News","title":"GOP dissenters emerge on Trump's threat against Iranian \"civilization\" - Axios","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_dbc50628cee8 in signals