SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

value

{"aggregator_url":"https://ag.purdue.edu/commercialag/home/paer-article/the-iran-conflict-and-global-food-security-why-the-burden-falls-hardest-on-the-worlds-most-vulnerable","as_of":"2026-04-03T19:18:05.772943+00:00","canonical_url":"https://ag.purdue.edu/commercialag/home/paer-article/the-iran-conflict-and-global-food-security-why-the-burden-falls-hardest-on-the-worlds-most-vulnerable/","enrichment":{"aggregator_url":"https://ag.purdue.edu/commercialag/home/paer-article/the-iran-conflict-and-global-food-security-why-the-burden-falls-hardest-on-the-worlds-most-vulnerable","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_61afa7bbe99e4888","canonical_host":"ag.purdue.edu","canonical_is_aggregator":false,"canonical_url":"https://ag.purdue.edu/commercialag/home/paer-article/the-iran-conflict-and-global-food-security-why-the-burden-falls-hardest-on-the-worlds-most-vulnerable/","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T01:19:06.997642+00:00","extraction_method":"heuristic","fetched_description":"The Iran conflict\u2019s energy shock is fundamentally regressive: it falls hardest on the countries and consumers least equipped to absorb it.","fetched_title":"The Iran Conflict and Global Food Security: Why the Burden Falls Hardest on the World's Most Vulnerable - Center for Commercial Agriculture","final_url":"https://ag.purdue.edu/commercialag/home/paer-article/the-iran-conflict-and-global-food-security-why-the-burden-falls-hardest-on-the-worlds-most-vulnerable","html_truncated":false,"paywall_likely":false,"publisher_domain":"ag.purdue.edu","publisher_resolution":"canonical_url","requested_url":"https://ag.purdue.edu/commercialag/home/paer-article/the-iran-conflict-and-global-food-security-why-the-burden-falls-hardest-on-the-worlds-most-vulnerable","source_event_id":"evt_b10207c03ef8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2628cc1ca6ad1c21","published_at":"","publisher_domain":"ag.purdue.edu","query":"EGY earnings are conflicting reports resolution primary sources","signal_understanding":{"analysis_basis":"article","claim_confidence":0.95,"dates_mentioned":["March 31, 2026"],"entities":[{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"IR","type":"country"},{"asset_class":"humanitarian aid","name":"World Food Programme (WFP)","relevance":"high","symbol":"WFP","type":"organization"}],"event_type":"macro_policy","information_gaps":["Specific data on the extent of price increases in low-income countries is not provided.","Details on the exact mechanisms of how the energy shock affects food prices are not fully explained."],"key_facts":["Low-income households spend approximately 52% of their income on food.","A 10% increase in food prices equates to a 5% income cut for low-income households.","Only 25% of wheat, 14% of corn, and 10% of rice production is traded internationally.","318 million people are at immediate risk of hunger due to rising prices."],"numeric_claims":[{"label":"Percentage of income spent on food by low-income households","value":"52%"},{"label":"Impact of 10% food price increase on income","value":"5% income cut"},{"label":"Percentage of wheat traded internationally","value":"25%"},{"label":"Percentage of corn traded internationally","value":"14%"},{"label":"Percentage of rice traded internationally","value":"10%"},{"label":"Number of people at risk of hunger","value":"318 million"}],"primary_claim":"The Iran conflict's energy shock raises food prices more severely in low- and middle-income countries than in high-income countries.","relevance_score":0.9,"sentiment":"negative","source_quality":"high","summary":"The Iran conflict's energy shock disproportionately impacts low-income countries, exacerbating food insecurity as these nations face higher food prices and reduced access to commodities compared to wealthier nations.","topics":["food security","energy shock","Iran conflict","global markets"]},"snippet":"The Iran conflict's energy shock is fundamentally regressive: it falls hardest on the countries and consumers least equipped to absorb it.","source":"web_search","source_domain":"ag.purdue.edu","summary":"The Iran conflict's energy shock is fundamentally regressive: it falls hardest on the countries and consumers least equipped to absorb it.","title":"The Iran Conflict and Global Food Security: Why the Burden Falls ...","url":"https://ag.purdue.edu/commercialag/home/paer-article/the-iran-conflict-and-global-food-security-why-the-burden-falls-hardest-on-the-worlds-most-vulnerable/"}

TEXT NOT NULL

threshold

TEXT

direction

TEXT

severity

TEXT

window

TEXT

source

TEXT NOT NULL

reason_trace

TEXT

dedupe_key

TEXT NOT NULL

throttle_s

INTEGER (default 0

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — signals

Update row sig_0d15a57ad6aa in signals