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/CBMivgFBVV95cUxNVFNSOGgwVWR2WnV0NENHTHEwSjVZMGJNdmhiNnZoYkhKLXNiLWszRU1CWmdCZy1aWFR6UGs1VHUzLW9UVE9lWjV3dnlzMThzMjc4a1N0b2ZDQU81MXd6VkU1djlvemdFODc2YnpyQmlVT01UNVI0ZTBPblBSX0EtWEJVNkVOamtNNnFPU1U4NWJBTGNfa01YcGt2ZmFiSG9QSTFORFZOUTJWRFRiUE5PMV9nSURld2dpSjlwVHl3?oc=5","as_of":"2026-04-09T15:51:38.149335+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/CBMivgFBVV95cUxNVFNSOGgwVWR2WnV0NENHTHEwSjVZMGJNdmhiNnZoYkhKLXNiLWszRU1CWmdCZy1aWFR6UGs1VHUzLW9UVE9lWjV3dnlzMThzMjc4a1N0b2ZDQU81MXd6VkU1djlvemdFODc2YnpyQmlVT01UNVI0ZTBPblBSX0EtWEJVNkVOamtNNnFPU1U4NWJBTGNfa01YcGt2ZmFiSG9QSTFORFZOUTJWRFRiUE5PMV9nSURld2dpSjlwVHl3?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5a9df58e0439f786","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-09T23:47:16.462095+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxNVFNSOGgwVWR2WnV0NENHTHEwSjVZMGJNdmhiNnZoYkhKLXNiLWszRU1CWmdCZy1aWFR6UGs1VHUzLW9UVE9lWjV3dnlzMThzMjc4a1N0b2ZDQU81MXd6VkU1djlvemdFODc2YnpyQmlVT01UNVI0ZTBPblBSX0EtWEJVNkVOamtNNnFPU1U4NWJBTGNfa01YcGt2ZmFiSG9QSTFORFZOUTJWRFRiUE5PMV9nSURld2dpSjlwVHl3?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"marketwatch.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivgFBVV95cUxNVFNSOGgwVWR2WnV0NENHTHEwSjVZMGJNdmhiNnZoYkhKLXNiLWszRU1CWmdCZy1aWFR6UGs1VHUzLW9UVE9lWjV3dnlzMThzMjc4a1N0b2ZDQU81MXd6VkU1djlvemdFODc2YnpyQmlVT01UNVI0ZTBPblBSX0EtWEJVNkVOamtNNnFPU1U4NWJBTGNfa01YcGt2ZmFiSG9QSTFORFZOUTJWRFRiUE5PMV9nSURld2dpSjlwVHl3?oc=5","source_event_id":"evt_3ccfa5c0afec","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"96113452b069e835","published_at":"2026-04-09T12:34:00+00:00","publisher_domain":"marketwatch.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":["February"],"entities":[{"asset_class":"macro/FX-rate sensitivity","name":"United States PCE (Personal Consumption Expenditures) inflation","relevance":"central inflation measure referenced","symbol":"","type":"economic_indicator"},{"asset_class":"macro","name":"Fed (Federal Reserve)","relevance":"context for inflation gauge and policy implications","symbol":"","type":"institution"},{"asset_class":"geopolitical_risk","name":"Iran war","relevance":"catalyst expected to affect inflation trajectory","symbol":"","type":"geopolitical_event"},{"asset_class":"media","name":"MarketWatch","relevance":"source of the headline framing","symbol":"","type":"publisher"},{"asset_class":"media","name":"CNBC","relevance":"cited for PCE inflation picking up in February","symbol":"","type":"publisher"},{"asset_class":"media","name":"Reuters","relevance":"cited for inflation cooling prior to war","symbol":"","type":"publisher"},{"asset_class":"media","name":"CBS News","relevance":"cited for Iran war affecting inflation expectations","symbol":"","type":"publisher"},{"asset_class":"media","name":"Axios","relevance":"cited for inflation expectations impact","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided is largely HTML/CSS and does not include the substantive MarketWatch/CNBC/Reuters/CBS/Axios passages; numeric details beyond \u201ccore inflation was 3% in February\u201d are not verifiable from the provided text.","\u201cPCE price increases\u201d magnitude (e.g., month-over-month or year-over-year) is not included in the provided content.","\u201cBack to 2024 levels\u201d is not quantified (which metric/which level, and by when).","No explicit timing window for when the Iran-war-driven inflation effect would materialize is provided in the supplied text."],"key_facts":["The headline framing states inflation was getting worse before the Iran war.","The signal references PCE price increases as evidence of the worsening inflation trend.","It states core inflation was 3% in February (as expected), citing a \u201ckey Fed gauge.\u201d","It reports that U.S. PCE inflation picked up in February.","It contrasts prior cooling in inflation with the expectation that the Iran war could reverse the cooling trend.","It claims the Iran war could push inflation back to 2024 levels.","It suggests the Iran war could affect Americans\u2019 inflation expectations."],"numeric_claims":[{"label":"Core inflation (February)","value":"3%"}],"primary_claim":"U.S. PCE price increases show inflation was getting worse before the Iran war, and the Iran war could push inflation back to 2024 levels.","relevance_score":0.74,"sentiment":"mixed","source_quality":"high","summary":"The signal argues that U.S. inflation (as measured by PCE) was worsening before the Iran war, and that the Iran war could push inflation back toward 2024 levels. It cites February core inflation around 3% and reports that PCE inflation picked up in February.","topics":["inflation","PCE","core inflation","Federal Reserve","geopolitical risk","Iran war","inflation expectations"]},"source":"MarketWatch","source_domain":"marketwatch.com","source_url":"https://www.marketwatch.com","summary":"Inflation was getting worse before Iran war. PCE price increases show how much. MarketWatch Core inflation was 3% in February, as expected, key Fed gauge shows CNBC US PCE inflation picks up in February; consumer spending solid Reuters Inflation was cooling. Now the Iran war could push it back to 2024 levels. CBS News How the Iran war affects Americans' inflation expectations Axios","title":"Inflation was getting worse before Iran war. PCE price increases show how much. - MarketWatch","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_61d01075905b in signals