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/CBMilgFBVV95cUxOWFdhaGhUMDVKRVVPU2M4cDUzVFlkX3o2OVB3YlNiUGVkbDNUN20zblJ5WWZXZVR4dVV3X3o0MkFLTU1oa20xb0Z1R2xzd0psWHgzcGhaN05hdzAxaTNUWC10ZjRYNmVFMGhPMVJacDhSeDFHRGJydldzdTJ2UGR1WU5WVzVNdm5leDM3MmlnX2dOVC16dkHSAZYBQVVfeXFMTlhXYWhoVDA1SkVVT1NjOHA1M1RZZF96NjlQd2JTYlBlZGwzVDdtM25SeVlmV2VUeHVVd196NDJBS01NaGttMW9GdUdsc3dKbFh4M3BoWjdOYXcwMWkzVFgtdGY0WDZlRTBoTzFSWnA4UngxR0RicnZXc3UydlBkdVlOVlc1TXZuZXgzNzJpZ19nTlQtenZB?oc=5","as_of":"2026-04-10T22:35:37.598360+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/CBMilgFBVV95cUxOWFdhaGhUMDVKRVVPU2M4cDUzVFlkX3o2OVB3YlNiUGVkbDNUN20zblJ5WWZXZVR4dVV3X3o0MkFLTU1oa20xb0Z1R2xzd0psWHgzcGhaN05hdzAxaTNUWC10ZjRYNmVFMGhPMVJacDhSeDFHRGJydldzdTJ2UGR1WU5WVzVNdm5leDM3MmlnX2dOVC16dkHSAZYBQVVfeXFMTlhXYWhoVDA1SkVVT1NjOHA1M1RZZF96NjlQd2JTYlBlZGwzVDdtM25SeVlmV2VUeHVVd196NDJBS01NaGttMW9GdUdsc3dKbFh4M3BoWjdOYXcwMWkzVFgtdGY0WDZlRTBoTzFSWnA4UngxR0RicnZXc3UydlBkdVlOVlc1TXZuZXgzNzJpZ19nTlQtenZB?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_11eda830bd8617b7","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-11T00:06:51.291887+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxOWFdhaGhUMDVKRVVPU2M4cDUzVFlkX3o2OVB3YlNiUGVkbDNUN20zblJ5WWZXZVR4dVV3X3o0MkFLTU1oa20xb0Z1R2xzd0psWHgzcGhaN05hdzAxaTNUWC10ZjRYNmVFMGhPMVJacDhSeDFHRGJydldzdTJ2UGR1WU5WVzVNdm5leDM3MmlnX2dOVC16dkHSAZYBQVVfeXFMTlhXYWhoVDA1SkVVT1NjOHA1M1RZZF96NjlQd2JTYlBlZGwzVDdtM25SeVlmV2VUeHVVd196NDJBS01NaGttMW9GdUdsc3dKbFh4M3BoWjdOYXcwMWkzVFgtdGY0WDZlRTBoTzFSWnA4UngxR0RicnZXc3UydlBkdVlOVlc1TXZuZXgzNzJpZ19nTlQtenZB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"greencarstocks.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMilgFBVV95cUxOWFdhaGhUMDVKRVVPU2M4cDUzVFlkX3o2OVB3YlNiUGVkbDNUN20zblJ5WWZXZVR4dVV3X3o0MkFLTU1oa20xb0Z1R2xzd0psWHgzcGhaN05hdzAxaTNUWC10ZjRYNmVFMGhPMVJacDhSeDFHRGJydldzdTJ2UGR1WU5WVzVNdm5leDM3MmlnX2dOVC16dkHSAZYBQVVfeXFMTlhXYWhoVDA1SkVVT1NjOHA1M1RZZF96NjlQd2JTYlBlZGwzVDdtM25SeVlmV2VUeHVVd196NDJBS01NaGttMW9GdUdsc3dKbFh4M3BoWjdOYXcwMWkzVFgtdGY0WDZlRTBoTzFSWnA4UngxR0RicnZXc3UydlBkdVlOVlc1TXZuZXgzNzJpZ19nTlQtenZB?oc=5","source_event_id":"evt_23f2e61a3ce2","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"849d86801c03fa79","published_at":"2026-04-10T13:40:55+00:00","publisher_domain":"greencarstocks.com","signal_understanding":{"analysis_basis":"headline_only","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Toyota bZ EV","relevance":"high","symbol":"","type":"company_product"},{"asset_class":"equity","name":"Tesla","relevance":"high","symbol":"TSLA","type":"company"}],"event_type":"price_action","information_gaps":["No article text is available to verify the claim or extract specifics (e.g., sales figures, market share, timelines).","No explicit mention of price movement, analyst actions, or regulatory events is provided beyond the competitive framing in the headline.","No additional tickers besides Tesla are explicitly provided; Toyota\u2019s bZ is a product name without a standardized symbol in the text."],"key_facts":["Headline states that Toyota\u2019s bZ EV is threatening Tesla\u2019s dominance in the US.","No article content, metrics, or dates are provided in the supplied text."],"numeric_claims":[],"primary_claim":"Toyota\u2019s bZ EV is threatening Tesla\u2019s dominance in the US.","relevance_score":0.45,"sentiment":"mixed","source_quality":"unknown","summary":"The headline claims Toyota\u2019s bZ EV is threatening Tesla\u2019s dominance in the US. No supporting details or data are provided in the supplied text.","topics":["US EV market competition","Tesla dominance","Toyota bZ EV"]},"source":"Green Car Stocks","source_domain":"greencarstocks.com","source_url":"https://www.greencarstocks.com","summary":"","tickers":[],"title":"Toyota\u2019s bZ EV is Threatening Tesla\u2019s Dominance in the US - Green Car Stocks","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_3500bdb8ef2d in signals