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/CBMimAFBVV95cUxPUk00UEhDNW1LajdGSDRqdHE2dDFERXFjS0UyWUVXdEE2ZzBidGIwUzFQX180WnBLcEFTMl9MSzQ1bTZXMUkxSmJtSUVZVlFwT2QtMzJVVjg4UXA0ckZMdVc3MHk1cFRuRnVQUTNVOFVZdmxObFlEZXpPSzBkVDFVWE5BaHdkblFNamxCaWk2dzFoVmdadmJ5NQ?oc=5","as_of":"2026-04-08T23:28:56.166118+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/CBMimAFBVV95cUxPUk00UEhDNW1LajdGSDRqdHE2dDFERXFjS0UyWUVXdEE2ZzBidGIwUzFQX180WnBLcEFTMl9MSzQ1bTZXMUkxSmJtSUVZVlFwT2QtMzJVVjg4UXA0ckZMdVc3MHk1cFRuRnVQUTNVOFVZdmxObFlEZXpPSzBkVDFVWE5BaHdkblFNamxCaWk2dzFoVmdadmJ5NQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_836d08b9a6c2088f","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-09T22:17:32.537053+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxPUk00UEhDNW1LajdGSDRqdHE2dDFERXFjS0UyWUVXdEE2ZzBidGIwUzFQX180WnBLcEFTMl9MSzQ1bTZXMUkxSmJtSUVZVlFwT2QtMzJVVjg4UXA0ckZMdVc3MHk1cFRuRnVQUTNVOFVZdmxObFlEZXpPSzBkVDFVWE5BaHdkblFNamxCaWk2dzFoVmdadmJ5NQ?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/CBMimAFBVV95cUxPUk00UEhDNW1LajdGSDRqdHE2dDFERXFjS0UyWUVXdEE2ZzBidGIwUzFQX180WnBLcEFTMl9MSzQ1bTZXMUkxSmJtSUVZVlFwT2QtMzJVVjg4UXA0ckZMdVc3MHk1cFRuRnVQUTNVOFVZdmxObFlEZXpPSzBkVDFVWE5BaHdkblFNamxCaWk2dzFoVmdadmJ5NQ?oc=5","source_event_id":"evt_f75c15f267c8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"be30be7e6a0b79cb","published_at":"2026-04-08T23:01:31+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"fool.com","relevance":"source of the headline/article","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The two EV stocks\u2019 names and ticker symbols are not included in the provided text.","The article\u2019s rationale (e.g., financial metrics, catalysts, valuation arguments) is not present in the provided text.","No timing details for near-term catalysts are included in the provided text.","No information on whether the sector is out of favor due to specific events (earnings, regulation, macro, etc.) is provided."],"key_facts":["Headline states: \u201c2 Monster EV Stocks Worth Owning While the Sector Is Still Out of Favor.\u201d","Source summary repeats the same claim.","No specific stock tickers or company names are provided in the provided text."],"numeric_claims":[],"primary_claim":"There are two specific EV stocks described as \u201cworth owning\u201d despite the EV sector being \u201cstill out of favor.\u201d","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The fool.com article argues that two \u201cMonster EV\u201d stocks are worth owning while the EV sector remains out of favor.","topics":["electric vehicles","EV sector sentiment","stock picking"]},"source":"fool.com","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"2 Monster EV Stocks Worth Owning While the Sector Is Still Out of Favor fool.com","title":"2 Monster EV Stocks Worth Owning While the Sector Is Still Out of Favor - fool.com","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_07134142b63f in signals