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-21T01:39:14.218814+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:9f9454ec5ad2ad48","evidence_event_ids":["evt_ae92d7e3de11"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/hogs-close-mixed-front-month-gains","as_of":"2026-04-21T01:39:14.218814+00:00","canonical_url":"https://www.barchart.com/story/news/1410603/hogs-close-mixed-with-front-month-gains","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/hogs-close-mixed-front-month-gains","article_chars":1476,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_29416370e50207d9","canonical_host":"barchart.com","canonical_is_aggregator":false,"canonical_url":"https://www.barchart.com/story/news/1410603/hogs-close-mixed-with-front-month-gains","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-21T23:30:00.446791+00:00","extraction_method":"trafilatura","fetched_description":"Lean hog futures saw gains of 10 to 82 cents in the front months on Monday, with deferreds steady to 27 cents lower. USDA\u2019s national base hog price was reported at $92.13 on Monday afternoon, up $1.85 from the previous day. The CME Lean Hog Index was down 15 cents...","fetched_title":"Hogs Close Mixed, with Front Month Gains | Nasdaq","final_url":"https://www.nasdaq.com/articles/hogs-close-mixed-front-month-gains","html_truncated":false,"paywall_likely":false,"publisher_domain":"barchart.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/hogs-close-mixed-front-month-gains","source_event_id":"evt_ae92d7e3de11","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"05cf127175078658","kind":"new_listings","published_at":"2026-04-21T00:07:06+00:00","publisher_domain":"barchart.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":["Monday","April 16"],"entities":[{"asset_class":"commodity_futures","name":"Lean hog futures (front months)","relevance":"high","symbol":"","type":"market"},{"asset_class":"commodity_futures","name":"Lean hog futures (deferred months)","relevance":"high","symbol":"","type":"market"},{"asset_class":"commodity_indicator","name":"USDA national base hog price","relevance":"high","symbol":"","type":"indicator"},{"asset_class":"commodity_indicator","name":"CME Lean Hog Index","relevance":"high","symbol":"","type":"indicator"},{"asset_class":"commodity_indicator","name":"USDA pork carcass cutout value","relevance":"medium","symbol":"","type":"indicator"},{"asset_class":"commodity_futures","name":"May 26 Hogs","relevance":"medium","symbol":"","type":"futures_contract"},{"asset_class":"commodity_futures","name":"Jun 26 Hogs","relevance":"medium","symbol":"","type":"futures_contract"},{"asset_class":"commodity_futures","name":"Jul 26 Hogs","relevance":"medium","symbol":"","type":"futures_contract"},{"asset_class":"commodity_statistic","name":"USDA federally inspected hog slaughter","relevance":"medium","symbol":"","type":"statistic"}],"event_type":"price_action","information_gaps":["No standardized ticker symbols for the specific hog futures contracts are provided in the text.","The article does not specify which deferred months were down by 27 cents (only the range/extent is stated).","The CME Lean Hog Index date is given as April 16, but the relationship to the Monday described is not fully explained in the text.","No details are provided on the magnitude of gains/losses for each individual front-month contract beyond the overall 10 to 82 cents range and the listed May/Jun/Jul settlements."],"key_facts":["Front-month lean hog futures gained 10 to 82 cents on Monday.","Deferred lean hog futures were steady to 27 cents lower.","USDA national base hog price was $92.13 on Monday afternoon, up $1.85 from the previous day.","CME Lean Hog Index was down 15 cents on April 16, at $90.51.","USDA pork carcass cutout value (Monday PM report) increased $1.00 to $100.20 per cwt.","Butt and rib primals were the only reported lower.","USDA estimated Monday\u2019s federally inspected hog slaughter at 492,000 head.","The slaughter figure was even with the previous week and 149,980 head above the same week last year.","May 26 Hogs closed at $94.225, up $0.825.","Jun 26 Hogs closed at $101.725, up $0.675.","Jul 26 Hogs closed at $104.000, up $0.325."],"numeric_claims":[{"label":"Front-month gains (cents)","value":"10 to 82"},{"label":"Deferred change (cents)","value":"steady to 27 lower"},{"label":"USDA national base hog price ($)","value":"92.13"},{"label":"USDA base hog price change ($)","value":"up 1.85"},{"label":"CME Lean Hog Index ($)","value":"90.51"},{"label":"CME Lean Hog Index change ($)","value":"down 0.15"},{"label":"USDA pork carcass cutout value ($/cwt)","value":"100.20"},{"label":"Cutout value change ($/cwt)","value":"up 1.00"},{"label":"Federally inspected hog slaughter (head)","value":"492,000"},{"label":"May 26 Hogs close ($)","value":"94.225"},{"label":"May 26 Hogs change ($)","value":"up 0.825"},{"label":"Jun 26 Hogs close ($)","value":"101.725"},{"label":"Jun 26 Hogs change ($)","value":"up 0.675"},{"label":"Jul 26 Hogs close ($)","value":"104.000"},{"label":"Jul 26 Hogs change ($)","value":"up 0.325"}],"primary_claim":"Front-month lean hog futures gained 10 to 82 cents on Monday, while deferreds were steady to 27 cents lower.","relevance_score":0.62,"sentiment":"mixed","source_quality":"medium","summary":"Lean hog futures rose in the front months on Monday (up 10 to 82 cents), while deferred contracts were mostly steady to lower (down up to 27 cents). USDA\u2019s national base hog price increased to $92.13, and the CME Lean Hog Index fell to $90.51 on April 16.","topics":["lean hog futures","USDA base hog price","CME Lean Hog Index","pork carcass cutout value","hog slaughter","futures settlement prices"]},"source":"Nasdaq Stocks","source_domain":"barchart.com","summary":"Lean hog futures saw gains of 10 to 82 cents in the front months on Monday, with deferreds steady to 27 cents lower. USDA\u2019s national base hog price was reported at $92.13 on Monday afternoon, up $1.85 from the previous day. The CME Lean Hog Index was down 15 cents...","tickers":[],"title":"Hogs Close Mixed, with Front Month Gains","url":"https://www.barchart.com/story/news/1410603/hogs-close-mixed-with-front-month-gains"}}

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