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/CBMipgFBVV95cUxQZHBzaUNOUzJ1T1Bmai11MUNvVnRpZmdHYWpLeC13MjN0eEtSM0hIa2w5bmhveGVyaWlFTW8zYldIRXpWSW14XzhqZmI2bmFNZk92Y1BTX2J5VkE2T19xTi1pOU10bmZJckVidzlteEFyRjh6aUFqNlBSS1IwclpiLU8zNFl4WGdid3hDaHpVS2diWFgyV0xOUzc2OGk0QmxUTjUzaWxn?oc=5","as_of":"2026-04-13T05:10:34.097141+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/CBMipgFBVV95cUxQZHBzaUNOUzJ1T1Bmai11MUNvVnRpZmdHYWpLeC13MjN0eEtSM0hIa2w5bmhveGVyaWlFTW8zYldIRXpWSW14XzhqZmI2bmFNZk92Y1BTX2J5VkE2T19xTi1pOU10bmZJckVidzlteEFyRjh6aUFqNlBSS1IwclpiLU8zNFl4WGdid3hDaHpVS2diWFgyV0xOUzc2OGk0QmxUTjUzaWxn?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_122d8f8492d58ddb","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-13T06:25:40.957306+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQZHBzaUNOUzJ1T1Bmai11MUNvVnRpZmdHYWpLeC13MjN0eEtSM0hIa2w5bmhveGVyaWlFTW8zYldIRXpWSW14XzhqZmI2bmFNZk92Y1BTX2J5VkE2T19xTi1pOU10bmZJckVidzlteEFyRjh6aUFqNlBSS1IwclpiLU8zNFl4WGdid3hDaHpVS2diWFgyV0xOUzc2OGk0QmxUTjUzaWxn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"wsj.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipgFBVV95cUxQZHBzaUNOUzJ1T1Bmai11MUNvVnRpZmdHYWpLeC13MjN0eEtSM0hIa2w5bmhveGVyaWlFTW8zYldIRXpWSW14XzhqZmI2bmFNZk92Y1BTX2J5VkE2T19xTi1pOU10bmZJckVidzlteEFyRjh6aUFqNlBSS1IwclpiLU8zNFl4WGdid3hDaHpVS2diWFgyV0xOUzc2OGk0QmxUTjUzaWxn?oc=5","source_event_id":"evt_ac9235001b67","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"ce30d330a49f3edd","published_at":"2026-04-13T02:16:00+00:00","publisher_domain":"wsj.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"McDonald\u2019s","relevance":"high","symbol":"MCD","type":"company"}],"event_type":"other","information_gaps":["No article body text is provided, so the planned rollout date/timing is unknown.","No details are provided on which energy drink brands/flavors or whether crafted sodas are proprietary or third-party.","No information is provided on geographic scope beyond \u201cU.S. menus.\u201d","No stated financial impact, pricing, or expected customer response is included in the provided text."],"key_facts":["The headline states McDonald\u2019s will add energy drinks and crafted sodas to menus.","The headline specifies this is for U.S. menus.","The information is attributed to an exclusive report by WSJ."],"numeric_claims":[],"primary_claim":"McDonald\u2019s will add energy drinks and crafted sodas to its U.S. menus, according to an exclusive WSJ report.","relevance_score":0.45,"sentiment":"mixed","source_quality":"unknown","summary":"WSJ reports that McDonald\u2019s plans to add energy drinks and crafted sodas to its U.S. menus. The specific timing and scope are not provided in the supplied text.","topics":["menu expansion","beverages","energy drinks","crafted sodas","U.S. market"]},"source":"WSJ","source_domain":"wsj.com","source_url":"https://www.wsj.com","summary":"Exclusive | McDonald\u2019s to Add Energy Drinks, Crafted Sodas to Menus WSJ McDonald's to add energy drinks, crafted sodas to menus, WSJ reports marketscreener.com McDonald's to add energy drinks, crafted sodas to US menus, WSJ reports Reuters McDonald\u2019s to Add Energy Drinks, Crafted Sodas to Menus, WSJ Reports U.S. News Money McDonald\u2019s to add energy drinks, crafted sodas to US menus, WSJ reports The Straits Times","title":"Exclusive | McDonald\u2019s to Add Energy Drinks, Crafted Sodas to Menus - WSJ","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_d3dfb18e322e in signals