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-09T23:03:22.859987+00:00","dedupe_key":"signal_enriched:news_delta:4f9d8c3f9fa0864b","evidence_event_ids":["evt_5bdc87bfe210"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMigwJBVV95cUxOMzl5Q0dfeU8tcVY0OUx4UzVMQnMxbTk2U3lCNGotZEU0MHlkcFdHRlVMd3Rva2ZpX1BSSW40bzFINHRXSms3WHJRMm1EYmNTVlJmajVkU2lLSHpjWUVWbXVkd0tnNTVYeDhKckhyUFlSaGhvSjRZYUlfVnJPMS1yYzJzY0QxS0drcDBUNV9iSkRia05nQ1dJLUpvZ0VTQ1Z0UnV5Mml3T1Z1RXFVaXVTOTdvUVZwNVItaVQyOElZVVp1el94YnZFREV6WUk3X1lYN3A5dFdkXzFTU3pmbWkxZVR2dDZXejJ3UWhyOW5GNFZvWGhJTThDUFdOUTA5QUFDZjhJ?oc=5","as_of":"2026-04-09T23:03:22.859987+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/CBMigwJBVV95cUxOMzl5Q0dfeU8tcVY0OUx4UzVMQnMxbTk2U3lCNGotZEU0MHlkcFdHRlVMd3Rva2ZpX1BSSW40bzFINHRXSms3WHJRMm1EYmNTVlJmajVkU2lLSHpjWUVWbXVkd0tnNTVYeDhKckhyUFlSaGhvSjRZYUlfVnJPMS1yYzJzY0QxS0drcDBUNV9iSkRia05nQ1dJLUpvZ0VTQ1Z0UnV5Mml3T1Z1RXFVaXVTOTdvUVZwNVItaVQyOElZVVp1el94YnZFREV6WUk3X1lYN3A5dFdkXzFTU3pmbWkxZVR2dDZXejJ3UWhyOW5GNFZvWGhJTThDUFdOUTA5QUFDZjhJ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_68c0c933ef309b9c","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:49:31.236587+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwJBVV95cUxOMzl5Q0dfeU8tcVY0OUx4UzVMQnMxbTk2U3lCNGotZEU0MHlkcFdHRlVMd3Rva2ZpX1BSSW40bzFINHRXSms3WHJRMm1EYmNTVlJmajVkU2lLSHpjWUVWbXVkd0tnNTVYeDhKckhyUFlSaGhvSjRZYUlfVnJPMS1yYzJzY0QxS0drcDBUNV9iSkRia05nQ1dJLUpvZ0VTQ1Z0UnV5Mml3T1Z1RXFVaXVTOTdvUVZwNVItaVQyOElZVVp1el94YnZFREV6WUk3X1lYN3A5dFdkXzFTU3pmbWkxZVR2dDZXejJ3UWhyOW5GNFZvWGhJTThDUFdOUTA5QUFDZjhJ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"journal-news.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwJBVV95cUxOMzl5Q0dfeU8tcVY0OUx4UzVMQnMxbTk2U3lCNGotZEU0MHlkcFdHRlVMd3Rva2ZpX1BSSW40bzFINHRXSms3WHJRMm1EYmNTVlJmajVkU2lLSHpjWUVWbXVkd0tnNTVYeDhKckhyUFlSaGhvSjRZYUlfVnJPMS1yYzJzY0QxS0drcDBUNV9iSkRia05nQ1dJLUpvZ0VTQ1Z0UnV5Mml3T1Z1RXFVaXVTOTdvUVZwNVItaVQyOElZVVp1el94YnZFREV6WUk3X1lYN3A5dFdkXzFTU3pmbWkxZVR2dDZXejJ3UWhyOW5GNFZvWGhJTThDUFdOUTA5QUFDZjhJ?oc=5","source_event_id":"evt_5bdc87bfe210","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c792cda6455f291e","published_at":"2026-04-09T18:10:54+00:00","publisher_domain":"journal-news.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"equities","name":"US stocks","relevance":"affected","symbol":"","type":"market"},{"asset_class":"commodity","name":"oil prices","relevance":"affected","symbol":"","type":"commodity"},{"asset_class":"geopolitical","name":"Iran","relevance":"related","symbol":"","type":"country"},{"asset_class":"geopolitical","name":"ceasefire with Iran","relevance":"catalyst","symbol":"","type":"event"}],"event_type":"geopolitical_risk","information_gaps":["Which specific US stock index(es) or sectors moved is not stated.","How much US stocks rose and how much oil prices trimmed gains is not provided.","No details are given on the timing or likelihood of the ceasefire beyond \u201chopes.\u201d","No information on the article\u2019s underlying data (e.g., intraday vs. daily move) is included in the provided text."],"key_facts":["US stocks swung higher.","Oil prices trimmed their gains.","The move is 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":"The headline reports that US stocks rose while oil prices gave back some gains, driven by hopes for a ceasefire with Iran.","topics":["ceasefire hopes","Iran","US equities","oil prices","market reaction"]},"source":"Journal-News.com","source_domain":"journal-news.com","source_url":"https://www.journal-news.com","summary":"US stocks swing higher and oil prices trim their gains on hopes for the ceasefire with Iran Journal-News.com","title":"US stocks swing higher and oil prices trim their gains on hopes for the ceasefire with Iran - Journal-News.com","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 11563 in events