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/CBMihwFBVV95cUxNX0xtV1I3dFVJTGwzYkNMZTlKNEd3ZFlXQS1MZ3JReFVjbUtVV0VmX2tDZjh4aDhOeVh4TFhPb2lKTXZBb0RleDBVNHlOVUIzdV8zZG5vb0d0c3N0eE9aR3JjWHpSd2JnckY2YmJ0TzhhLURGLVIyb2RmbG9zUl9PSGdOdVBfN1XSAYwBQVVfeXFMTXZ0VnI2Z0xSR2ZtRWllbXFZZG56Uy1SYnR4czF1TUVSV2NGNG9CMlBVMU9RVmZnUjdsZVFLSkRTRmluVkJTUnlGSTktcmtWYVRmSElta0lTYm9Idzk4c0lRckcyTmFrZ2VKcjFibUZHbk4wbG1PSklkRGlhN2F1TUM1LVowQU1aQUNlb1Y?oc=5","as_of":"2026-04-09T16:31:19.639478+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/CBMihwFBVV95cUxNX0xtV1I3dFVJTGwzYkNMZTlKNEd3ZFlXQS1MZ3JReFVjbUtVV0VmX2tDZjh4aDhOeVh4TFhPb2lKTXZBb0RleDBVNHlOVUIzdV8zZG5vb0d0c3N0eE9aR3JjWHpSd2JnckY2YmJ0TzhhLURGLVIyb2RmbG9zUl9PSGdOdVBfN1XSAYwBQVVfeXFMTXZ0VnI2Z0xSR2ZtRWllbXFZZG56Uy1SYnR4czF1TUVSV2NGNG9CMlBVMU9RVmZnUjdsZVFLSkRTRmluVkJTUnlGSTktcmtWYVRmSElta0lTYm9Idzk4c0lRckcyTmFrZ2VKcjFibUZHbk4wbG1PSklkRGlhN2F1TUM1LVowQU1aQUNlb1Y?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e2be3f9bcb8ead35","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:58:09.165744+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxNX0xtV1I3dFVJTGwzYkNMZTlKNEd3ZFlXQS1MZ3JReFVjbUtVV0VmX2tDZjh4aDhOeVh4TFhPb2lKTXZBb0RleDBVNHlOVUIzdV8zZG5vb0d0c3N0eE9aR3JjWHpSd2JnckY2YmJ0TzhhLURGLVIyb2RmbG9zUl9PSGdOdVBfN1XSAYwBQVVfeXFMTXZ0VnI2Z0xSR2ZtRWllbXFZZG56Uy1SYnR4czF1TUVSV2NGNG9CMlBVMU9RVmZnUjdsZVFLSkRTRmluVkJTUnlGSTktcmtWYVRmSElta0lTYm9Idzk4c0lRckcyTmFrZ2VKcjFibUZHbk4wbG1PSklkRGlhN2F1TUM1LVowQU1aQUNlb1Y?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbsnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxNX0xtV1I3dFVJTGwzYkNMZTlKNEd3ZFlXQS1MZ3JReFVjbUtVV0VmX2tDZjh4aDhOeVh4TFhPb2lKTXZBb0RleDBVNHlOVUIzdV8zZG5vb0d0c3N0eE9aR3JjWHpSd2JnckY2YmJ0TzhhLURGLVIyb2RmbG9zUl9PSGdOdVBfN1XSAYwBQVVfeXFMTXZ0VnI2Z0xSR2ZtRWllbXFZZG56Uy1SYnR4czF1TUVSV2NGNG9CMlBVMU9RVmZnUjdsZVFLSkRTRmluVkJTUnlGSTktcmtWYVRmSElta0lTYm9Idzk4c0lRckcyTmFrZ2VKcjFibUZHbk4wbG1PSklkRGlhN2F1TUM1LVowQU1aQUNlb1Y?oc=5","source_event_id":"evt_3a997b92176d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"94ab3c99802313d7","published_at":"2026-04-09T15:15:23+00:00","publisher_domain":"cbsnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["February"],"entities":[{"asset_class":"media","name":"CBS News","relevance":"primary source of the headline signal","symbol":"","type":"publisher"},{"asset_class":"geopolitical_risk","name":"Iran war","relevance":"key driver cited for reversing inflation cooling","symbol":"","type":"geopolitical event"},{"asset_class":"macro","name":"U.S. Federal Reserve (Fed)","relevance":"policy stance referenced as being affected by inflation trajectory","symbol":"","type":"institution"},{"asset_class":"macro_indicator","name":"U.S. inflation (core inflation / PCE)","relevance":"the metric whose direction is claimed to change","symbol":"","type":"economic indicator"}],"event_type":"geopolitical_risk","information_gaps":["The provided text does not specify which exact inflation measure would return to \u201c2024 levels\u201d (e.g., core CPI vs core PCE vs headline PCE).","No details are given on the mechanism linking the Iran war to inflation (e.g., oil prices, shipping costs, supply disruptions).","No timing window is specified for when inflation would rise back toward 2024 levels.","No magnitude (how much) or probability estimate is provided for the \u201cpush back\u201d claim."],"key_facts":["CBS News headline states inflation was cooling but the Iran war could push inflation back to 2024 levels.","Source summary indicates core inflation was 3% in February (as expected) based on a key Fed gauge.","Source summary indicates U.S. PCE inflation picks up in February (Reuters/CNBC referenced in the provided summary).","Source summary indicates consumer spending remained solid, keeping the Fed\u2019s interest-rate stance on hold (Yahoo Finance referenced in the provided summary)."],"numeric_claims":[{"label":"Core inflation (February)","value":"3%"}],"primary_claim":"The Iran war could push U.S. inflation back toward 2024 levels despite recent cooling.","relevance_score":0.74,"sentiment":"mixed","source_quality":"high","summary":"CBS News reports that while inflation had been cooling, an Iran-related war risk could reverse that progress and lift inflation back toward 2024 levels. The near-term catalyst implied is the escalation/impact of the Iran war on prices and inflation expectations.","topics":["inflation","U.S. monetary policy","Fed rate stance","geopolitical risk","Iran war","inflation expectations"]},"source":"CBS News","source_domain":"cbsnews.com","source_url":"https://www.cbsnews.com","summary":"Inflation was cooling. Now the Iran war could push it back to 2024 levels. CBS News Core inflation was 3% in February, as expected, key Fed gauge shows CNBC US PCE inflation picks up in February; consumer spending solid Reuters How the Iran war affects Americans' inflation expectations Axios Inflation stayed heated in February, keeping Fed's interest rate stance on hold Yahoo Finance","title":"Inflation was cooling. Now the Iran war could push it back to 2024 levels. - CBS News","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_c469339ad73a in signals