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-09T22:16:09.068620+00:00","dedupe_key":"signal_enriched:news_delta:dab95c392beb4031","evidence_event_ids":["evt_e3232140c893"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi-wFBVV95cUxQLUZkV0V5NVFibHRVdTl4SEdUd0xtTENDR2pabEFMUmJ0YTVaRjBTdXljOHZJVW5fOTFwZW83UG1OeC1JV0lHLVV4WHZXVkQwd2ZJbUFPa2x0LTk0TGsyWkFrdkJveHdUazc5SGkxWHBKM3V4aTc1OUF4cS05eXpaTWt4eFBkdnNuNndxS3ByTkxYeWhYSmRmbTNMMzBLTXdTbXBtc0R0QlJmTEg3ZlRrQUUyZWF0V3dBUHpIV2xqSkloaTA1NFVqcEgxRzlHbjBXS3prTjFDazFnWHNhZC1rLXl3S3NPd0lRNk5iM2JfRFRUY3Fjc2V5aVhlUQ?oc=5","as_of":"2026-04-09T22:16:09.068620+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/CBMi-wFBVV95cUxQLUZkV0V5NVFibHRVdTl4SEdUd0xtTENDR2pabEFMUmJ0YTVaRjBTdXljOHZJVW5fOTFwZW83UG1OeC1JV0lHLVV4WHZXVkQwd2ZJbUFPa2x0LTk0TGsyWkFrdkJveHdUazc5SGkxWHBKM3V4aTc1OUF4cS05eXpaTWt4eFBkdnNuNndxS3ByTkxYeWhYSmRmbTNMMzBLTXdTbXBtc0R0QlJmTEg3ZlRrQUUyZWF0V3dBUHpIV2xqSkloaTA1NFVqcEgxRzlHbjBXS3prTjFDazFnWHNhZC1rLXl3S3NPd0lRNk5iM2JfRFRUY3Fjc2V5aVhlUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1f6749ff43e811ec","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:03.206540+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi-wFBVV95cUxQLUZkV0V5NVFibHRVdTl4SEdUd0xtTENDR2pabEFMUmJ0YTVaRjBTdXljOHZJVW5fOTFwZW83UG1OeC1JV0lHLVV4WHZXVkQwd2ZJbUFPa2x0LTk0TGsyWkFrdkJveHdUazc5SGkxWHBKM3V4aTc1OUF4cS05eXpaTWt4eFBkdnNuNndxS3ByTkxYeWhYSmRmbTNMMzBLTXdTbXBtc0R0QlJmTEg3ZlRrQUUyZWF0V3dBUHpIV2xqSkloaTA1NFVqcEgxRzlHbjBXS3prTjFDazFnWHNhZC1rLXl3S3NPd0lRNk5iM2JfRFRUY3Fjc2V5aVhlUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"2news.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi-wFBVV95cUxQLUZkV0V5NVFibHRVdTl4SEdUd0xtTENDR2pabEFMUmJ0YTVaRjBTdXljOHZJVW5fOTFwZW83UG1OeC1JV0lHLVV4WHZXVkQwd2ZJbUFPa2x0LTk0TGsyWkFrdkJveHdUazc5SGkxWHBKM3V4aTc1OUF4cS05eXpaTWt4eFBkdnNuNndxS3ByTkxYeWhYSmRmbTNMMzBLTXdTbXBtc0R0QlJmTEg3ZlRrQUUyZWF0V3dBUHpIV2xqSkloaTA1NFVqcEgxRzlHbjBXS3prTjFDazFnWHNhZC1rLXl3S3NPd0lRNk5iM2JfRFRUY3Fjc2V5aVhlUQ?oc=5","source_event_id":"evt_e3232140c893","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"53f0f158671e1710","published_at":"2026-04-09T18:10:54+00:00","publisher_domain":"2news.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"equity_index","name":"US stocks","relevance":"affected","symbol":"","type":"market"},{"asset_class":"commodity","name":"Oil prices","relevance":"affected","symbol":"","type":"commodity"},{"asset_class":"sovereign","name":"Iran","relevance":"related_to_ceasefire","symbol":"","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["No specific index names (e.g., S&P 500, Dow, Nasdaq) are provided.","No magnitude of the stock or oil moves is provided.","No details on the ceasefire development (who proposed it, timing, or whether talks are confirmed) are provided.","No timeframe for the market swing (intraday vs. multi-day) is provided."],"key_facts":["US stocks swung higher.","Oil prices trimmed their gains.","The move was attributed to hopes for a ceasefire with Iran."],"numeric_claims":[],"primary_claim":"US stocks swung higher and oil prices trimmed their gains on hopes for a ceasefire with Iran.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"US stocks moved higher while oil prices gave back some of their gains, driven by hopes for a ceasefire with Iran.","topics":["ceasefire hopes","Iran","US equities","oil prices","market reaction"]},"source":"KTVN","source_domain":"2news.com","source_url":"https://www.2news.com","summary":"US stocks swing higher and oil prices trim their gains on hopes for the ceasefire with Iran | National News | 2news.com KTVN","title":"US stocks swing higher and oil prices trim their gains on hopes for the ceasefire with Iran | National News | 2news.com - KTVN","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 11462 in events