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-07T23:39:52.399450+00:00","dedupe_key":"signal_enriched:news_delta:694fd8f94a2b2eea","evidence_event_ids":["evt_e8fd29dd2ec6"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxPRU1FbW81ZHFXX3l3R0Y2cW15Um1rd1RFMUllUzlxS3ZSNzQwMmRaUkhJRVNNd0JoVExWcFhPSGNUTVZBa0pzcVJYUUtPS2NUVm1rMUg1RkJ4cm1PSVRBcUhDdkJGck0yelB0UExyVjdhMUg0Z08xX2FrNUJUVUVidnBNZVRTcGc?oc=5","as_of":"2026-04-07T23:39:52.399450+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/CBMihwFBVV95cUxPRU1FbW81ZHFXX3l3R0Y2cW15Um1rd1RFMUllUzlxS3ZSNzQwMmRaUkhJRVNNd0JoVExWcFhPSGNUTVZBa0pzcVJYUUtPS2NUVm1rMUg1RkJ4cm1PSVRBcUhDdkJGck0yelB0UExyVjdhMUg0Z08xX2FrNUJUVUVidnBNZVRTcGc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_142754650cc58cb2","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-08T00:39:24.706902+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxPRU1FbW81ZHFXX3l3R0Y2cW15Um1rd1RFMUllUzlxS3ZSNzQwMmRaUkhJRVNNd0JoVExWcFhPSGNUTVZBa0pzcVJYUUtPS2NUVm1rMUg1RkJ4cm1PSVRBcUhDdkJGck0yelB0UExyVjdhMUg0Z08xX2FrNUJUVUVidnBNZVRTcGc?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxPRU1FbW81ZHFXX3l3R0Y2cW15Um1rd1RFMUllUzlxS3ZSNzQwMmRaUkhJRVNNd0JoVExWcFhPSGNUTVZBa0pzcVJYUUtPS2NUVm1rMUg1RkJ4cm1PSVRBcUhDdkJGck0yelB0UExyVjdhMUg0Z08xX2FrNUJUVUVidnBNZVRTcGc?oc=5","source_event_id":"evt_e8fd29dd2ec6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"21e630a48b719276","published_at":"2026-04-07T16:00:00+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Americans (drivers/households)","relevance":"primary audience","symbol":"","type":"group"},{"asset_class":"other","name":"NPR","relevance":"source","symbol":"","type":"media_outlet"}],"event_type":"macro_policy","information_gaps":["No specific NPR survey methodology, sample size, or percentages are included in the provided material.","No details are provided on which states/counties or which demographic groups are most affected within the NPR piece.","No timing is given for when the discussed options/policies would take effect (near-term catalyst is implied by current gas prices, not explicitly stated).","The article text provided appears to be mostly HTML/CSS and does not contain the substantive article content needed for further grounded extraction."],"key_facts":["The NPR headline frames a debate over options to save gas: drive slower, go electric, or not drive at all.","The provided source summary indicates gas prices are a major concern for Americans and are above $4 per gallon in many places (context from other cited outlets).","The signal does not provide specific policy actions or quantified survey results from the NPR article itself in the provided text."],"numeric_claims":[{"label":"Gas price level (context from provided summaries)","value":"above $4/gallon"}],"primary_claim":"Americans are weighing options such as driving slower, going electric, or not driving at all to save gas amid high gasoline prices.","relevance_score":0.55,"sentiment":"mixed","source_quality":"high","summary":"NPR reports that Americans are debating multiple strategies to reduce gasoline use and costs, including driving less, driving slower, switching to electric vehicles, or not driving at all. The discussion is framed around elevated gas prices and the near-term pressure on household budgets.","topics":["gasoline prices","consumer behavior","electric vehicles","driving habits","energy transition"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Drive slower, go electric, don't drive at all? Americans weigh options for saving gas NPR \u2018Through the roof\u2019: This county has the highest average gas price in America CNN Gas prices concern Americans most amid Iran war: Pew survey The Hill With gas prices above $4, drivers across the country grapple with higher costs: \u201cI have to spend it\u2014there\u2019s no other way\u201d CNBC Iowa drivers feel pain at the pump as Iran War fuels price surge KCCI","title":"Drive slower, go electric, don't drive at all? Americans weigh options for saving gas - NPR","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 2385 in events