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/CBMilwFBVV95cUxQaTFoM3d4NU5jNkFOeFM4SVJwWnRpR1prZkpFaG9yVzRncXh2WGt3QllfcTRwX2UydEY4UHhZQTFuUW1kZ0t3UzJCYzRXc1hXWFlHQmxuM2syQjBSZ3RUTkZOOTlxT01CM2JwTkpjci00Z0RZLXp5U3JtSk5Ebk1IUHNJREJsZVhCS2JNVzBCNXhSYjBlQ2Vr?oc=5","as_of":"2026-04-08T06:36:00.134051+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/CBMilwFBVV95cUxQaTFoM3d4NU5jNkFOeFM4SVJwWnRpR1prZkpFaG9yVzRncXh2WGt3QllfcTRwX2UydEY4UHhZQTFuUW1kZ0t3UzJCYzRXc1hXWFlHQmxuM2syQjBSZ3RUTkZOOTlxT01CM2JwTkpjci00Z0RZLXp5U3JtSk5Ebk1IUHNJREJsZVhCS2JNVzBCNXhSYjBlQ2Vr?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7d0a882a54202a0d","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-08T06:36:16.555118+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilwFBVV95cUxQaTFoM3d4NU5jNkFOeFM4SVJwWnRpR1prZkpFaG9yVzRncXh2WGt3QllfcTRwX2UydEY4UHhZQTFuUW1kZ0t3UzJCYzRXc1hXWFlHQmxuM2syQjBSZ3RUTkZOOTlxT01CM2JwTkpjci00Z0RZLXp5U3JtSk5Ebk1IUHNJREJsZVhCS2JNVzBCNXhSYjBlQ2Vr?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/CBMilwFBVV95cUxQaTFoM3d4NU5jNkFOeFM4SVJwWnRpR1prZkpFaG9yVzRncXh2WGt3QllfcTRwX2UydEY4UHhZQTFuUW1kZ0t3UzJCYzRXc1hXWFlHQmxuM2syQjBSZ3RUTkZOOTlxT01CM2JwTkpjci00Z0RZLXp5U3JtSk5Ebk1IUHNJREJsZVhCS2JNVzBCNXhSYjBlQ2Vr?oc=5","source_event_id":"evt_8d3b292c77a3","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a37d29243c2fa9f2","published_at":"2026-04-07T17:30:00+00:00","publisher_domain":"fool.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.72,"dates_mentioned":["this year"],"entities":[{"asset_class":"","name":"The Motley Fool","relevance":"high","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The alternative action implied by \u201cDo this instead\u201d is not present in the provided text.","No specific assets/tickers are mentioned in the provided headline text.","No market data, forecasts, or probability estimates are included in the provided text."],"key_facts":["Headline: \u201cWorried About a Stock Market Crash This Year? Don't Try Timing the Market, Do This Instead - The Motley Fool.\u201d","The headline explicitly references concern about a stock market crash \u201cthis year.\u201d","The headline advises against \u201ctiming the market.\u201d","The headline implies an alternative action (\u201cDo this instead\u201d), but the alternative is not specified in the provided text."],"numeric_claims":[],"primary_claim":"The article headline claims that if you\u2019re worried about a stock market crash this year, you should not try timing the market and should instead do something else.","relevance_score":0.35,"sentiment":"mixed","source_quality":"high","summary":"The Motley Fool headline addresses investor concern about a potential stock market crash this year and argues against trying to time the market. It suggests an alternative approach (\u201cdo this instead\u201d), but the provided text does not include the alternative details.","topics":["stock market crash","market timing","investor behavior","risk management"]},"source":"The Motley Fool","source_domain":"fool.com","source_url":"https://www.fool.com","summary":"","tickers":[],"title":"Worried About a Stock Market Crash This Year? Don't Try Timing the Market, Do This Instead - 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_06262f5fea7c in signals