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-04T16:49:24.241842+00:00","dedupe_key":"signal_enriched:opportunity_research_delta:ab12af87e0ae1d80","evidence_event_ids":["evt_524c50ae395a"],"signal_type":"opportunity_research_delta","source":"opportunity_research_ingestor","value":{"aggregator_url":"https://www.facebook.com/Reuters/posts/us-job-growth-rebounded-more-than-expected-in-march-as-a-strike-by-healthcare-wo/1510363317621062/","as_of":"2026-04-04T16:49:24.241842+00:00","canonical_url":"https://www.facebook.com/reel/2009407909974536/","enrichment":{"aggregator_url":"https://www.facebook.com/Reuters/posts/us-job-growth-rebounded-more-than-expected-in-march-as-a-strike-by-healthcare-wo/1510363317621062/","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_287aa65aaa3f9a03","canonical_host":"facebook.com","canonical_is_aggregator":false,"canonical_url":"https://www.facebook.com/reel/2009407909974536/","content_type":"text/html; charset=\"utf-8\"","enriched_at":"2026-04-04T17:10:58.638681+00:00","extraction_method":"heuristic","fetched_description":"US job growth rebounded more than expected in March as a strike by healthcare workers ended and temperatures warmed up, but downside risks for the labor...","fetched_title":"US job growth rebounded more than expected in March as a strike by healthcare workers ended and temperatures warmed up, but downside risks for the labor market are mounting from a war with Iran that has no clear end in sight https://reut.rs/4sQo9u5 | Reuters","final_url":"https://www.facebook.com/Reuters/videos/us-job-growth-accelerates-by-the-most-in-15-months-in-march/2009407909974536/","html_truncated":true,"paywall_likely":false,"publisher_domain":"facebook.com","publisher_resolution":"canonical_url","requested_url":"https://www.facebook.com/Reuters/posts/us-job-growth-rebounded-more-than-expected-in-march-as-a-strike-by-healthcare-wo/1510363317621062/","source_event_id":"evt_524c50ae395a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3f71742149271585","published_at":"","publisher_domain":"facebook.com","query":"us oil wti geopolitical risk sanctions production outage catalyst next 14 days","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":["March"],"entities":[{"asset_class":"labor","name":"US job market","relevance":"high","symbol":"","type":"economic"},{"asset_class":"political","name":"Iran","relevance":"high","symbol":"","type":"geopolitical"}],"event_type":"research","information_gaps":["Specific numeric data on job growth figures is not provided.","Details on the extent of job growth or specific sectors affected are missing."],"key_facts":["US job growth exceeded expectations in March.","A strike by healthcare workers ended contributing to job growth.","Downside risks are mounting from a war with Iran."],"numeric_claims":[],"primary_claim":"US job growth rebounded more than expected in March.","relevance_score":0.8,"sentiment":"mixed","source_quality":"high","summary":"US job growth in March exceeded expectations due to the end of a healthcare workers' strike and warmer temperatures, although risks from an ongoing war with Iran are increasing.","topics":["job growth","labor market","geopolitical risks"]},"snippet":"West Texas Intermediate crude was trading near $97 per barrel as Trump began his remarks, but climbed above $100 by the end of the address. Prices have reached ...","source":"web_search","source_domain":"facebook.com","summary":"West Texas Intermediate crude was trading near $97 per barrel as Trump began his remarks, but climbed above $100 by the end of the address. Prices have reached ...","title":"US job growth rebounded more than expected in March as a strike ...","url":"https://www.facebook.com/reel/2009407909974536/"}}

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