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-03T13:51:42.389356+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:87f0e45dea0aa143","evidence_event_ids":["evt_26bd30903016"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/cdlstrong/posts/-global-shortage-us-oversupply-at-the-same-time-week-ending-march-27us-crude-inv/936486742538510/","as_of":"2026-04-03T13:51:42.389356+00:00","canonical_url":"https://www.facebook.com/cdlstrong/posts/-global-shortage-us-oversupply-at-the-same-time-week-ending-march-27us-crude-inv/936486742538510/","enrichment":{"aggregator_url":"https://www.facebook.com/cdlstrong/posts/-global-shortage-us-oversupply-at-the-same-time-week-ending-march-27us-crude-inv/936486742538510/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_908e8e284b2bf14a","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/cdlstrong/posts/-global-shortage-us-oversupply-at-the-same-time-week-ending-march-27us-crude-inv/936486742538510/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-04T01:01:03.260259+00:00","extraction_method":"heuristic","fetched_description":"\ud83c\udf0d GLOBAL SHORTAGE \u2014 U.S. OVERSUPPLY AT THE SAME TIME \ud83d\udcca WEEK ENDING MARCH 27 U.S. crude inventories just jumped over 10 million barrels. Analysts expected a drop. Instead? \ud83d\udc49 A massive swing in...","fetched_title":"CDL Strong - \ud83c\udf0d GLOBAL SHORTAGE \u2014 U.S. OVERSUPPLY AT THE...","final_url":"https://www.facebook.com/cdlstrong/posts/-global-shortage-us-oversupply-at-the-same-time-week-ending-march-27us-crude-inv/936486742538510/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/cdlstrong/posts/-global-shortage-us-oversupply-at-the-same-time-week-ending-march-27us-crude-inv/936486742538510/","source_event_id":"evt_26bd30903016","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"321c3961fbe2b6d2","published_at":"","publisher_domain":"facebook.com","query":"us oil wti OPEC+ supply inventories refinery demand shipping disruption update","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["March 27"],"entities":[{"asset_class":"energy","name":"U.S. Crude Oil","relevance":"high","symbol":"CL","type":"commodity"}],"event_type":"supply_disruption","information_gaps":["No specific data on global shortage impact on prices or demand."],"key_facts":["U.S. crude inventories increased by over 10 million barrels.","Analysts expected a decrease in inventories."],"numeric_claims":[{"label":"Inventory Increase","value":"over 10 million barrels"},{"label":"Expected Change","value":"decrease"}],"primary_claim":"U.S. crude inventories jumped over 10 million barrels, against expectations of a drop.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"U.S. crude inventories increased by over 10 million barrels for the week ending March 27, contrary to analyst expectations of a decrease, indicating a potential oversupply amidst a global shortage.","topics":["crude oil","supply chain","inventory levels"]},"snippet":"GLOBAL SHORTAGE \u2014 U.S. OVERSUPPLY AT THE SAME TIME WEEK ENDING MARCH 27 U.S. crude inventories just jumped over 10 million barrels. Analysts expected a drop ...","source":"web_search","source_domain":"facebook.com","summary":"GLOBAL SHORTAGE \u2014 U.S. OVERSUPPLY AT THE SAME TIME WEEK ENDING MARCH 27 U.S. crude inventories just jumped over 10 million barrels. Analysts expected a drop ...","title":"GLOBAL SHORTAGE \u2014 U.S. OVERSUPPLY AT THE SAME TIME ...","url":"https://www.facebook.com/cdlstrong/posts/-global-shortage-us-oversupply-at-the-same-time-week-ending-march-27us-crude-inv/936486742538510/"}}

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