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/CBMiogFBVV95cUxNRmZ4UFBoYjIzamwtb2JjVWNzOFc3RnhfV0tjd1NKMGFKeDhTMnIteVRUTVhRV0JlaG0wT1dIcmxuWnUxRU5SWUNERVotbEMzXzV6Xy1SWG9GeHBONVptbUVheHo3M0pfNlhXMFM5WVM3Yl9yRVVZcS1OelZVNm9MS21DWk1ERktsT1FRZUF6eTZ4VXdKT3pTdy1yODE0amJ0eWc?oc=5","as_of":"2026-04-09T15:01:33.470291+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/CBMiogFBVV95cUxNRmZ4UFBoYjIzamwtb2JjVWNzOFc3RnhfV0tjd1NKMGFKeDhTMnIteVRUTVhRV0JlaG0wT1dIcmxuWnUxRU5SWUNERVotbEMzXzV6Xy1SWG9GeHBONVptbUVheHo3M0pfNlhXMFM5WVM3Yl9yRVVZcS1OelZVNm9MS21DWk1ERktsT1FRZUF6eTZ4VXdKT3pTdy1yODE0amJ0eWc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_8f3a00e8614e516e","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:38:24.575907+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxNRmZ4UFBoYjIzamwtb2JjVWNzOFc3RnhfV0tjd1NKMGFKeDhTMnIteVRUTVhRV0JlaG0wT1dIcmxuWnUxRU5SWUNERVotbEMzXzV6Xy1SWG9GeHBONVptbUVheHo3M0pfNlhXMFM5WVM3Yl9yRVVZcS1OelZVNm9MS21DWk1ERktsT1FRZUF6eTZ4VXdKT3pTdy1yODE0amJ0eWc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"investors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiogFBVV95cUxNRmZ4UFBoYjIzamwtb2JjVWNzOFc3RnhfV0tjd1NKMGFKeDhTMnIteVRUTVhRV0JlaG0wT1dIcmxuWnUxRU5SWUNERVotbEMzXzV6Xy1SWG9GeHBONVptbUVheHo3M0pfNlhXMFM5WVM3Yl9yRVVZcS1OelZVNm9MS21DWk1ERktsT1FRZUF6eTZ4VXdKT3pTdy1yODE0amJ0eWc?oc=5","source_event_id":"evt_4202bdfc1999","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6756720fae319fdf","published_at":"2026-04-09T13:48:00+00:00","publisher_domain":"investors.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"Dividend stocks (unspecified)","relevance":"high","symbol":"","type":"sector_or_asset_group"},{"asset_class":"media","name":"Investor's Business Daily","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"merger_acquisition","information_gaps":["The specific companies/stocks involved in the $1.7 billion merger are not named in the provided text.","No ticker symbols are provided for the \u201cThis One\u201d that \u201crockets.\u201d","No timing details (announcement date, expected close date) are provided.","No terms of the merger (cash/stock consideration, premium, structure) are provided beyond the deal size."],"key_facts":["The headline states there is a merger involving dividend stocks.","The deal size is stated as $1.7 billion.","The headline states that \u201cThis One Rockets,\u201d implying a sharp positive move for a specific stock (stock name not provided in the provided text)."],"numeric_claims":[{"label":"deal_size_usd","value":"1.7 billion"}],"primary_claim":"A $1.7 billion deal involves dividend stocks merging, and one of the stocks \u201crockets\u201d (per the headline).","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Investor's Business Daily reports that dividend stocks are involved in a $1.7 billion merger deal, and highlights one stock that is described as sharply rising.","topics":["merger","dividend stocks","deal size","stock price surge"]},"source":"Investor's Business Daily","source_domain":"investors.com","source_url":"https://www.investors.com","summary":"Dividend Stocks Merge In $1.7 Billion Deal; This One Rockets Investor's Business Daily","title":"Dividend Stocks Merge In $1.7 Billion Deal; This One Rockets - Investor's Business Daily","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_26182a27d614 in signals