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/CBMic0FVX3lxTE51ZnFnc0lkOFZuSkFzd1B5NVNWSUw4WU5qaDh4d3dtMjRMZXM0ZFVNNjFUb20yWXlJYkNFT1FqdGF5M0R5RV80bVNPTUhJaUNaZDVYOUZVVUxnTXRNZVo4d3BmX3d4UVFCQndxTkRpc2NoM1k?oc=5","as_of":"2026-04-10T01:40:59.026124+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/CBMic0FVX3lxTE51ZnFnc0lkOFZuSkFzd1B5NVNWSUw4WU5qaDh4d3dtMjRMZXM0ZFVNNjFUb20yWXlJYkNFT1FqdGF5M0R5RV80bVNPTUhJaUNaZDVYOUZVVUxnTXRNZVo4d3BmX3d4UVFCQndxTkRpc2NoM1k?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_16363f5ff88e398d","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-10T01:42:21.167057+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE51ZnFnc0lkOFZuSkFzd1B5NVNWSUw4WU5qaDh4d3dtMjRMZXM0ZFVNNjFUb20yWXlJYkNFT1FqdGF5M0R5RV80bVNPTUhJaUNaZDVYOUZVVUxnTXRNZVo4d3BmX3d4UVFCQndxTkRpc2NoM1k?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"carscoops.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMic0FVX3lxTE51ZnFnc0lkOFZuSkFzd1B5NVNWSUw4WU5qaDh4d3dtMjRMZXM0ZFVNNjFUb20yWXlJYkNFT1FqdGF5M0R5RV80bVNPTUhJaUNaZDVYOUZVVUxnTXRNZVo4d3BmX3d4UVFCQndxTkRpc2NoM1k?oc=5","source_event_id":"evt_e4787a758056","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"948670a9f7eeb20a","published_at":"2026-04-09T15:03:52+00:00","publisher_domain":"carscoops.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.55,"dates_mentioned":["2030"],"entities":[{"asset_class":"automaker","name":"Kia","relevance":"high","symbol":"","type":"company"},{"asset_class":"automotive_model","name":"Toyota Tacoma","relevance":"high","symbol":"","type":"vehicle_model"},{"asset_class":"automaker","name":"Toyota","relevance":"medium","symbol":"","type":"company"},{"asset_class":"automotive_model","name":"Ford Ranger","relevance":"medium","symbol":"","type":"vehicle_model"}],"event_type":"listing","information_gaps":["The provided article text is not actually present (only page CSS), so details about the specific powertrain(s) are not verifiable here.","No confirmation of whether the pickup will be ICE, hybrid, plug-in hybrid, or EREV in the provided excerpt; the headline implies powertrains Toyota doesn\u2019t offer, but the exact configuration is missing.","No production location, pricing, or model name is included in the provided content."],"key_facts":["Kia has a planned midsize pickup for North America intended to compete with the Toyota Tacoma and Ford Ranger.","The pickup is described as using powertrains that Toyota does not offer in America (exact powertrain types not specified in the provided text).","Kia\u2019s U.S. pickup launch is targeted for 2030."],"numeric_claims":[{"label":"U.S. pickup launch target year","value":"2030"}],"primary_claim":"Kia plans to launch a U.S. midsize pickup truck by 2030 to compete with the Toyota Tacoma, using powertrains Toyota doesn\u2019t offer in America.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Carscoops reports Kia plans a midsize pickup for North America aimed at competing with the Toyota Tacoma (and Ford Ranger), including powertrain options Toyota does not offer in America. The planned U.S. launch is targeted for 2030, with additional electrified variants referenced in related coverage.","topics":["midsize pickup trucks","North America","competitive strategy","powertrain electrification","Toyota Tacoma competition","Kia U.S. launch timeline"]},"source":"Carscoops","source_domain":"carscoops.com","source_url":"https://www.carscoops.com","summary":"Kia Is Coming For The Tacoma With Powertrains Toyota Doesn\u2019t Offer In America Carscoops Kia unveils midsize pickup plan for North America in pursuit of Toyota Tacoma and Ford Ranger Automotive News Kia plans to launch U.S. pickup truck by 2030 CNBC The 2027 Kia Telluride Hybrid Is Here. The SUV Will Get Even More Electric In 2029 With An EREV Option InsideEVs Kia's Upcoming U.S. EV Pickup Truck Will Also Be Available in EREV Form Road & Track","title":"Kia Is Coming For The Tacoma With Powertrains Toyota Doesn\u2019t Offer In America - Carscoops","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_ec0e9582f30f in signals