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-04T21:19:57.051565+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:3e95399c7e99254f","evidence_event_ids":["evt_a39ce48913bb"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/dayton247now/posts/expert-weighs-where-oil-and-gas-prices-could-head-next-amid-escalating-iran-tens/1384157773745793/","as_of":"2026-04-04T21:19:57.051565+00:00","canonical_url":"https://www.facebook.com/dayton247now/posts/expert-weighs-where-oil-and-gas-prices-could-head-next-amid-escalating-iran-tens/1384157773745793/","enrichment":{"aggregator_url":"https://www.facebook.com/dayton247now/posts/expert-weighs-where-oil-and-gas-prices-could-head-next-amid-escalating-iran-tens/1384157773745793/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_00352c31298cf971","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/dayton247now/posts/expert-weighs-where-oil-and-gas-prices-could-head-next-amid-escalating-iran-tens/1384157773745793/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-05T05:02:53.031065+00:00","extraction_method":"heuristic","fetched_description":"Expert weighs where oil and gas prices could head next amid escalating Iran tensions","fetched_title":"Dayton 24/7 Now - Expert weighs where oil and gas prices...","final_url":"https://www.facebook.com/dayton247now/posts/expert-weighs-where-oil-and-gas-prices-could-head-next-amid-escalating-iran-tens/1384157773745793/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/dayton247now/posts/expert-weighs-where-oil-and-gas-prices-could-head-next-amid-escalating-iran-tens/1384157773745793/","source_event_id":"evt_a39ce48913bb","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"13418a6204fe1e49","published_at":"","publisher_domain":"facebook.com","query":"brent crude geopolitical risk sanctions production outage catalyst next 14 days","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"energy","name":"Brent crude","relevance":"high","symbol":"BRENT","type":"commodity"}],"event_type":"research","information_gaps":["Specific data points on the extent of the oil surplus are not provided."],"key_facts":["Global oil surplus is expected to lead to a price drop.","Disruptions in global markets are noted."],"numeric_claims":[],"primary_claim":"The anticipated price drop in oil and gas is primarily due to a global oil surplus.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"An expert discusses the potential for a drop in oil and gas prices due to a global oil surplus, which is causing disruptions in global markets.","topics":["oil prices","gas prices","global markets","oil surplus"]},"snippet":"The potential for disruption has rattled global markets, with Brent crude ... The anticipated price drop is primarily due to a global oil surplus, with production ...","source":"web_search","source_domain":"facebook.com","summary":"The potential for disruption has rattled global markets, with Brent crude ... The anticipated price drop is primarily due to a global oil surplus, with production ...","title":"Expert weighs where oil and gas prices could head next amid ...","url":"https://www.facebook.com/dayton247now/posts/expert-weighs-where-oil-and-gas-prices-could-head-next-amid-escalating-iran-tens/1384157773745793/"}}

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 18996 in events