SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-10T22:35:37.598360+00:00","dedupe_key":"signal_enriched:market_headline_delta:c25939e8acd253ce","evidence_event_ids":["evt_23f2e61a3ce2"],"signal_type":"market_headline_delta","source":"market_ingestor","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 20404 in events