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-22T00:01:09.681092+00:00","dedupe_key":"signal_enriched:discovery_new_listings_delta:49d78ffc5c47a76f","evidence_event_ids":["evt_06a1460d3058"],"signal_type":"discovery_new_listings_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://www.nasdaq.com/articles/cotton-rally-extends-tuesday","as_of":"2026-04-22T00:01:09.681092+00:00","canonical_url":"https://www.barchart.com/story/news/1436014/cotton-rally-extends-to-tuesday","enrichment":{"aggregator_url":"https://www.nasdaq.com/articles/cotton-rally-extends-tuesday","article_chars":1448,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_5009a274f8dfe72f","canonical_host":"barchart.com","canonical_is_aggregator":false,"canonical_url":"https://www.barchart.com/story/news/1436014/cotton-rally-extends-to-tuesday","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-22T00:21:48.135538+00:00","extraction_method":"trafilatura","fetched_description":"Cotton futures posted 66 to 114 point gains across the board on Tuesday. The US dollar index was 0.278 higher at $98.185. Crude oil was up another $2.19 to $91.80 NASS Crop Progress data showed 11% of the US cotton crop planted as of April 19, which was 1 percentage...","fetched_title":"Cotton Rally Extends to Tuesday | Nasdaq","final_url":"https://www.nasdaq.com/articles/cotton-rally-extends-tuesday","html_truncated":false,"paywall_likely":false,"publisher_domain":"barchart.com","publisher_resolution":"canonical_url","requested_url":"https://www.nasdaq.com/articles/cotton-rally-extends-tuesday","source_event_id":"evt_06a1460d3058","source_quality":"medium","status_code":200,"version":"signal_enrichment_v2"},"fp":"ab4fa2d17591a187","kind":"new_listings","published_at":"2026-04-21T23:54:22+00:00","publisher_domain":"barchart.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["Tuesday","April 19","5-year average","Monday","4/20","April 20","Thursday","May 26","Jul 26","Dec 26"],"entities":[{"asset_class":"commodity_futures","name":"Cotton futures (May 26)","relevance":"high","symbol":"CT=F (May 26)","type":"commodity_futures_contract"},{"asset_class":"commodity_futures","name":"Cotton futures (Jul 26)","relevance":"high","symbol":"CT=F (Jul 26)","type":"commodity_futures_contract"},{"asset_class":"commodity_futures","name":"Cotton futures (Dec 26)","relevance":"high","symbol":"CT=F (Dec 26)","type":"commodity_futures_contract"},{"asset_class":"currency_index","name":"US Dollar Index","relevance":"medium","symbol":"DXY","type":"currency_index"},{"asset_class":"commodity_futures","name":"Crude oil","relevance":"medium","symbol":"CL=F","type":"commodity"},{"asset_class":"data_series","name":"NASS Crop Progress","relevance":"medium","symbol":"","type":"government_data_series"},{"asset_class":"commodity_index","name":"Cotlook A Index","relevance":"medium","symbol":"","type":"commodity_price_index"},{"asset_class":"commodity_inventory","name":"ICE certified cotton stocks","relevance":"medium","symbol":"","type":"inventory_metric"},{"asset_class":"commodity_price_metric","name":"Adjusted World Price","relevance":"medium","symbol":"","type":"commodity_price_metric"},{"asset_class":"market_reporting","name":"The Seam","relevance":"low","symbol":"","type":"sales_reporting"}],"event_type":"price_action","information_gaps":["The signal type guidance mentions new listings delta, but the provided text contains no explicit information about new listings or listing changes.","The article does not specify the exact date corresponding to \u201cTuesday\u201d or \u201cThursday\u201d beyond relative references.","No contract symbols are explicitly provided for the cotton futures; only month-year labels (May 26, Jul 26, Dec 26) are given.","The Seam and Cotlook A Index are referenced, but the article does not define their methodology or geographic scope in the provided text."],"key_facts":["Cotton futures posted 66 to 114 point gains across the board on Tuesday.","US dollar index was 0.278 higher at $98.185.","Crude oil was up another $2.19 to $91.80.","NASS Crop Progress reported 11% of the US cotton crop planted as of April 19, which was 1 percentage point ahead of the 5-year average of 10%.","All 15 major states were at or ahead of average, except LA and VA; TX matched the normal pace at 16%.","The Seam showed 64 bales sold on Monday at an average of 65.98 cents/lb.","Cotlook A Index was 175 points higher on 4/20 at 89.10 cents.","ICE certified cotton stocks were steady on April 20 at 164,967 bales.","Adjusted World Price was up another 287 points on Thursday at 61.61 cents/lb.","May 26 cotton closed at 78.26, up 66 points.","Jul 26 cotton closed at 80.86, up 82 points.","Dec 26 cotton closed at 81.79, up 103 points."],"numeric_claims":[{"label":"Cotton futures gains (points)","value":"66 to 114"},{"label":"US dollar index change","value":"+0.278"},{"label":"US dollar index level","value":"98.185"},{"label":"Crude oil change","value":"+2.19"},{"label":"Crude oil level","value":"91.80"},{"label":"US cotton crop planted (as of Apr 19)","value":"11%"},{"label":"5-year average planted","value":"10%"},{"label":"Difference vs 5-year average","value":"+1 percentage point"},{"label":"TX cotton planting pace","value":"16%"},{"label":"The Seam bales sold (Monday)","value":"64"},{"label":"The Seam average price (cents/lb)","value":"65.98"},{"label":"Cotlook A Index change (points)","value":"+175"},{"label":"Cotlook A Index level (cents)","value":"89.10"},{"label":"ICE certified cotton stocks (bales)","value":"164,967"},{"label":"Adjusted World Price change (points)","value":"+287"},{"label":"Adjusted World Price level (cents/lb)","value":"61.61"},{"label":"May 26 cotton close","value":"78.26"},{"label":"May 26 cotton change (points)","value":"+66"},{"label":"Jul 26 cotton close","value":"80.86"},{"label":"Jul 26 cotton change (points)","value":"+82"},{"label":"Dec 26 cotton close","value":"81.79"},{"label":"Dec 26 cotton change (points)","value":"+103"}],"primary_claim":"Cotton futures posted 66 to 114 point gains across the board on Tuesday.","relevance_score":0.62,"sentiment":"positive","source_quality":"medium","summary":"Cotton futures rose across the board on Tuesday, extending the rally into Tuesday. The article also reports higher US dollar and crude oil prices, and provides USDA NASS planting progress and several cotton market pricing/stock metrics.","topics":["cotton futures","commodity rally","US dollar index","crude oil","USDA NASS crop progress","cotton planting progress","cotton pricing indices","cotton stocks","world price metrics"]},"source":"Nasdaq Stocks","source_domain":"barchart.com","summary":"Cotton futures posted 66 to 114 point gains across the board on Tuesday. The US dollar index was 0.278 higher at $98.185. Crude oil was up another $2.19 to $91.80 NASS Crop Progress data showed 11% of the US cotton crop planted as of April 19, which was 1 percentage...","tickers":[],"title":"Cotton Rally Extends to Tuesday","url":"https://www.barchart.com/story/news/1436014/cotton-rally-extends-to-tuesday"}}

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