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/CBMiY0FVX3lxTE9pT1M0bmhNQm1vUU53Nmx2NDc3dllfY21XLTRLeFdESHVJaFNEUFRwZncxLV9rS295ZWlQV1lzczJ4bjNYR0M1MTF5QlJPVHZKbmJuTlg0eGw4Y0hmQWt4eXJ2b9IBaEFVX3lxTE92WWZ2M0ZWYThfaVZNaExJdlVKeUxIZ3dsYVJ4c1I1MTV1YkdESzlCbk90S0ZnNEpKOElFRm5WMWQxbFZYVDlrZWxORUN1T1JRYzBEd1Q1WGNCYnNYOVVpOTBIUlcyazVW?oc=5","as_of":"2026-04-09T22:16:09.138971+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/CBMiY0FVX3lxTE9pT1M0bmhNQm1vUU53Nmx2NDc3dllfY21XLTRLeFdESHVJaFNEUFRwZncxLV9rS295ZWlQV1lzczJ4bjNYR0M1MTF5QlJPVHZKbmJuTlg0eGw4Y0hmQWt4eXJ2b9IBaEFVX3lxTE92WWZ2M0ZWYThfaVZNaExJdlVKeUxIZ3dsYVJ4c1I1MTV1YkdESzlCbk90S0ZnNEpKOElFRm5WMWQxbFZYVDlrZWxORUN1T1JRYzBEd1Q1WGNCYnNYOVVpOTBIUlcyazVW?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_e7da6782afe6776d","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-10T00:42:22.668115+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiY0FVX3lxTE9pT1M0bmhNQm1vUU53Nmx2NDc3dllfY21XLTRLeFdESHVJaFNEUFRwZncxLV9rS295ZWlQV1lzczJ4bjNYR0M1MTF5QlJPVHZKbmJuTlg0eGw4Y0hmQWt4eXJ2b9IBaEFVX3lxTE92WWZ2M0ZWYThfaVZNaExJdlVKeUxIZ3dsYVJ4c1I1MTV1YkdESzlCbk90S0ZnNEpKOElFRm5WMWQxbFZYVDlrZWxORUN1T1JRYzBEd1Q1WGNCYnNYOVVpOTBIUlcyazVW?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cnbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiY0FVX3lxTE9pT1M0bmhNQm1vUU53Nmx2NDc3dllfY21XLTRLeFdESHVJaFNEUFRwZncxLV9rS295ZWlQV1lzczJ4bjNYR0M1MTF5QlJPVHZKbmJuTlg0eGw4Y0hmQWt4eXJ2b9IBaEFVX3lxTE92WWZ2M0ZWYThfaVZNaExJdlVKeUxIZ3dsYVJ4c1I1MTV1YkdESzlCbk90S0ZnNEpKOElFRm5WMWQxbFZYVDlrZWxORUN1T1JRYzBEd1Q1WGNCYnNYOVVpOTBIUlcyazVW?oc=5","source_event_id":"evt_846ddd008d59","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"d2b58dffc6d9d597","published_at":"2026-04-09T15:00:43+00:00","publisher_domain":"cnbc.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["2030","next four years (relative; exact date not specified)"],"entities":[{"asset_class":"equity","name":"Kia","relevance":"high","symbol":"","type":"company"},{"asset_class":"vehicle","name":"Toyota Tacoma","relevance":"medium","symbol":"","type":"vehicle_model"},{"asset_class":"vehicle","name":"Ford Ranger","relevance":"medium","symbol":"","type":"vehicle_model"},{"asset_class":"media","name":"CNBC","relevance":"low","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["The cleaned article text provided contains no readable content about the announcement; extraction is therefore based on the headline and the supplied source summary rather than the full article body.","Unclear whether the \u201cby 2030\u201d refers to the first model year, full sales start, or a broader program announcement.","Unclear which specific powertrain/trim(s) will be included in the 2030 U.S. launch (the summary mentions a body-on-frame hybrid, but linkage to the 2030 timing is not fully specified).","No production volume, pricing, or manufacturing location details are included in the provided material."],"key_facts":["CNBC headline states Kia plans to launch a U.S. pickup truck by 2030.","The plan is described as a midsize pickup for North America.","The competitive framing names Toyota Tacoma and Ford Ranger as targets/rivals.","Additional context in the provided source summary indicates Kia is developing a body-on-frame hybrid truck for the U.S. within the next four years (timing detail beyond the 2030 launch)."],"numeric_claims":[{"label":"Launch timing (U.S. pickup)","value":"by 2030"},{"label":"Hybrid truck timing (U.S.)","value":"within the next four years (relative to article publication; exact year not specified)"}],"primary_claim":"Kia plans to launch a U.S. pickup truck by 2030.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"Kia says it plans to launch a U.S. midsize pickup truck by 2030, targeting the North American market with a body-on-frame design. The move is positioned as competitive pressure against established rivals like Toyota Tacoma and Ford Ranger.","topics":["automotive","pickup_trucks","product_launch","North_America","competition"]},"source":"CNBC","source_domain":"cnbc.com","source_url":"https://www.cnbc.com","summary":"Kia plans to launch U.S. pickup truck by 2030 CNBC Kia unveils midsize pickup plan for North America in pursuit of Toyota Tacoma and Ford Ranger Automotive News Kia Confirms a New Body-on-Frame Hybrid Truck Is Coming to America within the Next Four Years Car and Driver Kia Puts Toyota Tacoma On Notice, Plans To Sell 90,000 Hybrid Trucks A Year The Autopian Kia Announces Body-on-Frame Midsize Pickup Truck Coming to the U.S. to Fight Tacoma and Ranger Autoblog","title":"Kia plans to launch U.S. pickup truck by 2030 - CNBC","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_9509c165047b in signals