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/CBMijgFBVV95cUxOMWQwcXlRY3lpSGdqX0FZTWhLWW81ek9xR0xJYlc4UkFqMkJKNzVCanhUbWtRZ19NcjBEWGhpemZicTZYNGh6TkQwUXl4d09qQ1BuLWR5MnlPZmtYY2FRZjBTdnlFOWhMcDlIcU0xSWtjN3EzRVppcllseXdKQjFZS0U2bnVTUHN3M1Ntc0pB?oc=5","as_of":"2026-04-12T07:02:57.668082+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/CBMijgFBVV95cUxOMWQwcXlRY3lpSGdqX0FZTWhLWW81ek9xR0xJYlc4UkFqMkJKNzVCanhUbWtRZ19NcjBEWGhpemZicTZYNGh6TkQwUXl4d09qQ1BuLWR5MnlPZmtYY2FRZjBTdnlFOWhMcDlIcU0xSWtjN3EzRVppcllseXdKQjFZS0U2bnVTUHN3M1Ntc0pB?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_2478e4c31432d1f8","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-12T07:03:19.455151+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxOMWQwcXlRY3lpSGdqX0FZTWhLWW81ek9xR0xJYlc4UkFqMkJKNzVCanhUbWtRZ19NcjBEWGhpemZicTZYNGh6TkQwUXl4d09qQ1BuLWR5MnlPZmtYY2FRZjBTdnlFOWhMcDlIcU0xSWtjN3EzRVppcllseXdKQjFZS0U2bnVTUHN3M1Ntc0pB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"sg.finance.yahoo.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxOMWQwcXlRY3lpSGdqX0FZTWhLWW81ek9xR0xJYlc4UkFqMkJKNzVCanhUbWtRZ19NcjBEWGhpemZicTZYNGh6TkQwUXl4d09qQ1BuLWR5MnlPZmtYY2FRZjBTdnlFOWhMcDlIcU0xSWtjN3EzRVppcllseXdKQjFZS0U2bnVTUHN3M1Ntc0pB?oc=5","source_event_id":"evt_6c5a2a5dc6d4","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"5c8340f5ff37f392","published_at":"2026-04-12T03:16:00+00:00","publisher_domain":"sg.finance.yahoo.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.4,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"DT Midstream","relevance":"high","symbol":"","type":"company"},{"asset_class":"commodity","name":"Natural gas","relevance":"medium","symbol":"","type":"commodity_sector"}],"event_type":"other","information_gaps":["No article body text is provided, so profitability, valuation, comparisons, and any supporting figures are unknown.","No ticker symbol for DT Midstream is provided in the provided text.","No indication is given whether the headline implies a trend continuation or reversal beyond the \u201cto buy now\u201d framing."],"key_facts":["Headline is from Yahoo Finance Singapore (sg.finance.yahoo.com).","Headline asks: \u201cIs DT Midstream the Most Profitable Natural Gas Stock to Buy Now?\u201d","No article text or supporting data is provided in the signal."],"numeric_claims":[],"primary_claim":"The headline presents a question implying DT Midstream may be the most profitable natural gas stock to buy now.","relevance_score":0.35,"sentiment":"neutral","source_quality":"unknown","summary":"The provided headline asks whether DT Midstream is the most profitable natural gas stock to buy now. No article details are available to confirm any specific claims or performance metrics.","topics":["stock picking","natural gas equities","profitability","investment recommendation framing"]},"source":"Yahoo Finance Singapore","source_domain":"sg.finance.yahoo.com","source_url":"https://sg.finance.yahoo.com","summary":"","tickers":[],"title":"Is DT Midstream the Most Profitable Natural Gas Stock to Buy Now? - Yahoo Finance Singapore","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_8b4f8d255ef8 in signals