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/CBMimAFBVV95cUxPY092YTB6Rkh6MFR1U3pZQlFZT05PZW5SdlNlZk9QTlV1Sl9pY2J2eGhOV1YwMUJNVHk3UXZVOHlyLWxwV3VCZFdndi01bnhTcmlMaWhYdEtmbDV0LVlpR245WUNwX3R4UVNHRUxIejlqY1Naa0g1aXF5azdKbk5BX2RPekJubkpOMWRDU2t6Wk1YSExCZDFTZg?oc=5","as_of":"2026-04-10T08:49:48.005503+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/CBMimAFBVV95cUxPY092YTB6Rkh6MFR1U3pZQlFZT05PZW5SdlNlZk9QTlV1Sl9pY2J2eGhOV1YwMUJNVHk3UXZVOHlyLWxwV3VCZFdndi01bnhTcmlMaWhYdEtmbDV0LVlpR245WUNwX3R4UVNHRUxIejlqY1Naa0g1aXF5azdKbk5BX2RPekJubkpOMWRDU2t6Wk1YSExCZDFTZg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ad214da61101eb97","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-10T08:50:12.100290+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPY092YTB6Rkh6MFR1U3pZQlFZT05PZW5SdlNlZk9QTlV1Sl9pY2J2eGhOV1YwMUJNVHk3UXZVOHlyLWxwV3VCZFdndi01bnhTcmlMaWhYdEtmbDV0LVlpR245WUNwX3R4UVNHRUxIejlqY1Naa0g1aXF5azdKbk5BX2RPekJubkpOMWRDU2t6Wk1YSExCZDFTZg?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"fool.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPY092YTB6Rkh6MFR1U3pZQlFZT05PZW5SdlNlZk9QTlV1Sl9pY2J2eGhOV1YwMUJNVHk3UXZVOHlyLWxwV3VCZFdndi01bnhTcmlMaWhYdEtmbDV0LVlpR245WUNwX3R4UVNHRUxIejlqY1Naa0g1aXF5azdKbk5BX2RPekJubkpOMWRDU2t6Wk1YSExCZDFTZg?oc=5","source_event_id":"evt_61b8a029ea85","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"12ab4645e923cf70","published_at":"2026-04-10T08:17:57+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"The Motley Fool","relevance":"source of the headline","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["Which three stocks are referenced (names and ticker symbols are not present).","Which billionaires are buying (names not present).","Whether the purchases are recent and the timing/catalyst window (not present).","Any supporting fundamentals/valuation metrics cited in the article (not present).","Whether the article references specific filings (e.g., 13F) or other evidence for \u201cbillionaires are buying\u201d (not present)."],"key_facts":["Headline: \u201c3 Stocks Billionaires Are Buying That You Should Too\u201d (The Motley Fool).","The provided text does not include the names or ticker symbols of the \u201c3 stocks.\u201d","The provided text does not include which billionaires are buying or the timing/size of purchases."],"numeric_claims":[],"primary_claim":"The article states that there are 3 stocks that billionaires are buying and that readers should consider buying them as well.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The Motley Fool headline claims that three stocks are being bought by billionaires and suggests investors \u201cshould too.\u201d No specific stock tickers or purchase details are provided in the provided text.","topics":["stock picking","billionaire holdings","investment advice"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"3 Stocks Billionaires Are Buying That You Should Too The Motley Fool","title":"3 Stocks Billionaires Are Buying That You Should Too - The Motley Fool","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_c9ba971b9404 in signals