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/CBMiqwFBVV95cUxOTHp3MkZuRUJpVGpjRE1xSWJYSUs2bFBZRXZpVVJKcWFPaEdMbElpaFlUSWloZFQ3dkVXLWFTOVkydzhUMFRYa2xfR3dCaDJpeVllellzTW4xS2lsYzJhaW0wcnNaTk9XVFFibTJGZjdZOEtUNjEzOFQ3LTlLYlo2a3lFSUJFYXhjMlJwRlFpdllXUWZpZldGQkpBVkw1dU9DeXpLclFpQVJ0THM?oc=5","as_of":"2026-04-09T18:00:21.922929+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/CBMiqwFBVV95cUxOTHp3MkZuRUJpVGpjRE1xSWJYSUs2bFBZRXZpVVJKcWFPaEdMbElpaFlUSWloZFQ3dkVXLWFTOVkydzhUMFRYa2xfR3dCaDJpeVllellzTW4xS2lsYzJhaW0wcnNaTk9XVFFibTJGZjdZOEtUNjEzOFQ3LTlLYlo2a3lFSUJFYXhjMlJwRlFpdllXUWZpZldGQkpBVkw1dU9DeXpLclFpQVJ0THM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d094c9558213b0a0","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-10T00:11:20.614041+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxOTHp3MkZuRUJpVGpjRE1xSWJYSUs2bFBZRXZpVVJKcWFPaEdMbElpaFlUSWloZFQ3dkVXLWFTOVkydzhUMFRYa2xfR3dCaDJpeVllellzTW4xS2lsYzJhaW0wcnNaTk9XVFFibTJGZjdZOEtUNjEzOFQ3LTlLYlo2a3lFSUJFYXhjMlJwRlFpdllXUWZpZldGQkpBVkw1dU9DeXpLclFpQVJ0THM?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"michiganfarmnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxOTHp3MkZuRUJpVGpjRE1xSWJYSUs2bFBZRXZpVVJKcWFPaEdMbElpaFlUSWloZFQ3dkVXLWFTOVkydzhUMFRYa2xfR3dCaDJpeVllellzTW4xS2lsYzJhaW0wcnNaTk9XVFFibTJGZjdZOEtUNjEzOFQ3LTlLYlo2a3lFSUJFYXhjMlJwRlFpdllXUWZpZldGQkpBVkw1dU9DeXpLclFpQVJ0THM?oc=5","source_event_id":"evt_9abc5dcc49a2","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6982d2586231ee8e","published_at":"2026-04-09T17:43:12+00:00","publisher_domain":"michiganfarmnews.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.72,"dates_mentioned":["April"],"entities":[{"asset_class":"commodity/agriculture","name":"April WASDE","relevance":"central","symbol":"","type":"report"},{"asset_class":"macro/geopolitical","name":"Middle East conflict","relevance":"context for market behavior","symbol":"","type":"geopolitical_risk"}],"event_type":"macro_policy","information_gaps":["No specific WASDE figures, commodity impacts, or policy changes are provided in the supplied text.","No timing details beyond \u201cApril\u201d are given for when markets may react.","No named countries, commodities, or asset tickers are mentioned in the provided text.","The directionality of price impact (up/down) is not stated\u2014only that markets are muted and waiting."],"key_facts":["The headline references the April WASDE.","The headline states markets are \u201cmuted\u201d and are in a \u201cwait-and-see game.\u201d","The headline attributes this market posture to the Middle East conflict."],"numeric_claims":[],"primary_claim":"Markets are described as muted and taking a wait-and-see approach around the April WASDE release amid the Middle East conflict.","relevance_score":0.45,"sentiment":"neutral","source_quality":"high","summary":"The April WASDE report is being discussed as a catalyst that markets are approaching cautiously, with trading described as muted due to the ongoing Middle East conflict. The near-term posture is a wait-and-see stance rather than an immediate directional reaction.","topics":["WASDE","agricultural commodities","market sentiment","wait-and-see","Middle East conflict"]},"source":"Michigan Farm News","source_domain":"michiganfarmnews.com","source_url":"https://www.michiganfarmnews.com","summary":"April WASDE: Muted markets play wait-and-see game amid Middle East conflict Michigan Farm News","title":"April WASDE: Muted markets play wait-and-see game amid Middle East conflict - Michigan Farm 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_95fc57ec743a in signals