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/CBMimwFBVV95cUxOSXE0Mms3REZuVnZIbkFFUEtPemR2UlVTa2hNTXFDeHV4RUxfUVR5SmM4Y1ZZYlNmdkVId3lPQzVMRlhqWm1raTBfakgyNVdOT3o4WlVQdGZ2a0RGOER1cGFsLWh1T0xQc3plXzhId0o2MkVEQTNITklHcDJ6bWxxOFlxS29jMllLZlZPYU5aQWw3ZWRHQWFiQ01MMA?oc=5","as_of":"2026-04-08T01:58:44.367035+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/CBMimwFBVV95cUxOSXE0Mms3REZuVnZIbkFFUEtPemR2UlVTa2hNTXFDeHV4RUxfUVR5SmM4Y1ZZYlNmdkVId3lPQzVMRlhqWm1raTBfakgyNVdOT3o4WlVQdGZ2a0RGOER1cGFsLWh1T0xQc3plXzhId0o2MkVEQTNITklHcDJ6bWxxOFlxS29jMllLZlZPYU5aQWw3ZWRHQWFiQ01MMA?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_4524adcb819cb1f8","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-08T02:00:23.020450+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOSXE0Mms3REZuVnZIbkFFUEtPemR2UlVTa2hNTXFDeHV4RUxfUVR5SmM4Y1ZZYlNmdkVId3lPQzVMRlhqWm1raTBfakgyNVdOT3o4WlVQdGZ2a0RGOER1cGFsLWh1T0xQc3plXzhId0o2MkVEQTNITklHcDJ6bWxxOFlxS29jMllLZlZPYU5aQWw3ZWRHQWFiQ01MMA?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"pewresearch.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimwFBVV95cUxOSXE0Mms3REZuVnZIbkFFUEtPemR2UlVTa2hNTXFDeHV4RUxfUVR5SmM4Y1ZZYlNmdkVId3lPQzVMRlhqWm1raTBfakgyNVdOT3o4WlVQdGZ2a0RGOER1cGFsLWh1T0xQc3plXzhId0o2MkVEQTNITklHcDJ6bWxxOFlxS29jMllLZlZPYU5aQWw3ZWRHQWFiQ01MMA?oc=5","source_event_id":"evt_0514c299f052","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"928744987f6e03d7","published_at":"2026-04-07T17:53:20+00:00","publisher_domain":"pewresearch.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Pew Research Center","relevance":"high","symbol":"","type":"research_organization"},{"asset_class":"other","name":"Americans (U.S. public)","relevance":"high","symbol":"","type":"population_group"},{"asset_class":"other","name":"Iran war (U.S. public concern context)","relevance":"medium","symbol":"","type":"geopolitical_event"},{"asset_class":"other","name":"Strait of Hormuz","relevance":"medium","symbol":"","type":"geographic_chokepoint"},{"asset_class":"other","name":"J.P. Morgan analysts","relevance":"low","symbol":"","type":"financial_institution_analysts"}],"event_type":"macro_policy","information_gaps":["The provided cleaned article text appears to be mostly page styling/HTML and does not contain the actual Pew Research findings; only the headline and the external source summary are available.","The exact Pew survey question wording, sample size, and percentage breakdown are not present in the provided content.","Near-term timing details (exact dates for \u201cthis week\u201d) are not included in the provided text; only a general reference is present in the source summary."],"key_facts":["Pew Research Center headline states that gas prices are Americans\u2019 top concern in the Iran war context.","Source summary includes claims that gas prices could rise sharply if the Strait of Hormuz remains shut (attributed to J.P. Morgan analysts).","Source summary includes additional media references about potential near-term gas price increases (e.g., CNN Analyst; Minnesota; \u201cthis week\u201d)."],"numeric_claims":[{"label":"Potential gasoline price level","value":"$5 a gallon (conditional; per J.P. Morgan analysts in source summary)"}],"primary_claim":"Pew Research Center found that gas prices are Americans\u2019 top concern in the context of the Iran war.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Pew Research Center reports that Americans\u2019 top concern regarding the Iran war is gas prices. The broader coverage suggests near-term risk of higher gasoline costs if tensions disrupt oil flows (e.g., Strait of Hormuz).","topics":["gas prices","consumer sentiment","Iran war","oil market risk","Strait of Hormuz","energy costs"]},"source":"Pew Research Center","source_domain":"pewresearch.org","source_url":"https://www.pewresearch.org","summary":"Gas Prices Are Americans\u2019 Top Concern in Iran War Pew Research Center \u2018Through the roof\u2019: This county has the highest average gas price in America CNN Analyst warns of \u2018hefty\u2019 gas price increase this week in Minnesota Bring Me The News Drive slower, go electric, don't drive at all? Americans weigh options for saving gas NPR Gas prices could soon breach $5 a gallon if Strait of Hormuz remains shut, J.P. Morgan analysts say CBS News","title":"Gas Prices Are Americans\u2019 Top Concern in Iran War - Pew Research Center","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_07b25fbcc478 in signals