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-09T14:22:29.095669+00:00","dedupe_key":"signal_enriched:news_delta:d59d46f8e4b84f51","evidence_event_ids":["evt_34022b9b7096"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNSDF5eUtFT2xNRG12S1lxUS1SZy1WOURqMXFfX0hySGdzWktLTkJ6ZnR2dUZNd1JqMVhwUzVoYjZKX1R6cDMyeDM2ODFLM083T0pXYzJoaldwQWdid0hDdU5razgxc0dlQW1pUVE5a2tXbmJHak4wZjBzTUFTMGk1SjZlaG1FTVRNTVdnXzVRS2h1dFBvVEY1NTdFSGdycnZsLU5TTE9idXZWX3c?oc=5","as_of":"2026-04-09T14:22:29.095669+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/CBMiqwFBVV95cUxNSDF5eUtFT2xNRG12S1lxUS1SZy1WOURqMXFfX0hySGdzWktLTkJ6ZnR2dUZNd1JqMVhwUzVoYjZKX1R6cDMyeDM2ODFLM083T0pXYzJoaldwQWdid0hDdU5razgxc0dlQW1pUVE5a2tXbmJHak4wZjBzTUFTMGk1SjZlaG1FTVRNTVdnXzVRS2h1dFBvVEY1NTdFSGdycnZsLU5TTE9idXZWX3c?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d2ffcb291fc6eea4","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-09T23:32:28.478161+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNSDF5eUtFT2xNRG12S1lxUS1SZy1WOURqMXFfX0hySGdzWktLTkJ6ZnR2dUZNd1JqMVhwUzVoYjZKX1R6cDMyeDM2ODFLM083T0pXYzJoaldwQWdid0hDdU5razgxc0dlQW1pUVE5a2tXbmJHak4wZjBzTUFTMGk1SjZlaG1FTVRNTVdnXzVRS2h1dFBvVEY1NTdFSGdycnZsLU5TTE9idXZWX3c?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"post-gazette.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiqwFBVV95cUxNSDF5eUtFT2xNRG12S1lxUS1SZy1WOURqMXFfX0hySGdzWktLTkJ6ZnR2dUZNd1JqMVhwUzVoYjZKX1R6cDMyeDM2ODFLM083T0pXYzJoaldwQWdid0hDdU5razgxc0dlQW1pUVE5a2tXbmJHak4wZjBzTUFTMGk1SjZlaG1FTVRNTVdnXzVRS2h1dFBvVEY1NTdFSGdycnZsLU5TTE9idXZWX3c?oc=5","source_event_id":"evt_34022b9b7096","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"304a74a883db2563","published_at":"2026-04-09T14:04:25+00:00","publisher_domain":"post-gazette.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"commodity","name":"Oil prices","relevance":"direct","symbol":"WTI/Brent (unspecified)","type":"commodity"},{"asset_class":"equity_index","name":"Stocks","relevance":"direct","symbol":"(unspecified index)","type":"market"},{"asset_class":"geopolitical","name":"U.S.-Iran ceasefire","relevance":"causal driver (per headline)","symbol":"U.S.-Iran ceasefire","type":"geopolitical agreement"}],"event_type":"geopolitical_risk","information_gaps":["Which specific oil benchmark (WTI vs Brent) is referenced is not stated.","Which stock index or market segment is meant by \u201cstocks\u201d is not stated.","The headline does not provide timing (e.g., intraday vs multi-day) beyond the immediate market move.","The article text provided is not usable for additional details (it appears to be page styling/HTML boilerplate), so only the headline/summary facts are extracted."],"key_facts":["Oil prices are rising toward $100.","Stocks are slipping.","The move is attributed to doubts about the U.S.-Iran ceasefire."],"numeric_claims":[{"label":"Oil price level (target/nearby)","value":"$100"}],"primary_claim":"Oil prices are rising toward $100 as stocks slip on doubts about the U.S.-Iran ceasefire.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Oil prices are rising toward $100 while stocks are slipping amid doubts about the U.S.-Iran ceasefire.","topics":["oil prices","equities","U.S.-Iran ceasefire","market risk sentiment"]},"source":"Pittsburgh Post-Gazette","source_domain":"post-gazette.com","source_url":"https://www.post-gazette.com","summary":"Oil prices rise toward $100 as stocks slip on doubts about the U.S.-Iran ceasefire Pittsburgh Post-Gazette","title":"Oil prices rise toward $100 as stocks slip on doubts about the U.S.-Iran ceasefire - Pittsburgh Post-Gazette","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 10180 in events