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-09T20:18:41.088446+00:00","dedupe_key":"signal_enriched:news_delta:e779ab1808c9d107","evidence_event_ids":["evt_c65d2c2ab31f"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi0AFBVV95cUxPcEdLSzBpRVhfcmtURG1raHczcjJiUV9ERnJoTVlxRUZDam9NZFJ5cFp0Z2F4UWR1VXBYRXB4eFI4M2EtcmdRN0hXOHN1OXJKYnFJN2JzdFd3ZFpoajVlanhlVDFrOW1SQnV4XzB0MzVqOGxJWWpNLUE2NjMtZi1wSG9PcVBDbzI4dTZyZHV2ZGxCLVVTLVdQYmpaVmFpcXJWVjVyYVNuei1OcGpVTVpxOXpYN3B0U1loeUV1VkR1TTRRdVBqT19zSU9BYXdjWjhm?oc=5","as_of":"2026-04-09T20:18:41.088446+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi0AFBVV95cUxPcEdLSzBpRVhfcmtURG1raHczcjJiUV9ERnJoTVlxRUZDam9NZFJ5cFp0Z2F4UWR1VXBYRXB4eFI4M2EtcmdRN0hXOHN1OXJKYnFJN2JzdFd3ZFpoajVlanhlVDFrOW1SQnV4XzB0MzVqOGxJWWpNLUE2NjMtZi1wSG9PcVBDbzI4dTZyZHV2ZGxCLVVTLVdQYmpaVmFpcXJWVjVyYVNuei1OcGpVTVpxOXpYN3B0U1loeUV1VkR1TTRRdVBqT19zSU9BYXdjWjhm?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_5053466632e06501","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-10T00:29:04.544512+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi0AFBVV95cUxPcEdLSzBpRVhfcmtURG1raHczcjJiUV9ERnJoTVlxRUZDam9NZFJ5cFp0Z2F4UWR1VXBYRXB4eFI4M2EtcmdRN0hXOHN1OXJKYnFJN2JzdFd3ZFpoajVlanhlVDFrOW1SQnV4XzB0MzVqOGxJWWpNLUE2NjMtZi1wSG9PcVBDbzI4dTZyZHV2ZGxCLVVTLVdQYmpaVmFpcXJWVjVyYVNuei1OcGpVTVpxOXpYN3B0U1loeUV1VkR1TTRRdVBqT19zSU9BYXdjWjhm?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi0AFBVV95cUxPcEdLSzBpRVhfcmtURG1raHczcjJiUV9ERnJoTVlxRUZDam9NZFJ5cFp0Z2F4UWR1VXBYRXB4eFI4M2EtcmdRN0hXOHN1OXJKYnFJN2JzdFd3ZFpoajVlanhlVDFrOW1SQnV4XzB0MzVqOGxJWWpNLUE2NjMtZi1wSG9PcVBDbzI4dTZyZHV2ZGxCLVVTLVdQYmpaVmFpcXJWVjVyYVNuei1OcGpVTVpxOXpYN3B0U1loeUV1VkR1TTRRdVBqT19zSU9BYXdjWjhm?oc=5","source_event_id":"evt_c65d2c2ab31f","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3d91300f316c64ea","published_at":"2026-04-09T17:01:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Argentina","relevance":"affected jurisdiction","symbol":"","type":"country"},{"asset_class":"political_leader","name":"Javier Milei","relevance":"bill sponsor/president","symbol":"","type":"person"},{"asset_class":"regulation","name":"glacier mining bill","relevance":"core policy change","symbol":"","type":"legislation"},{"asset_class":"civil_society","name":"environmental protesters","relevance":"opposition/response","symbol":"","type":"group"}],"event_type":"regulation","information_gaps":["The provided content does not specify the bill\u2019s exact provisions (e.g., what protections are removed/modified, permitting thresholds, or enforcement mechanisms).","No specific date of approval is included in the provided text.","No named companies or projects are identified in the provided text.","No quantified economic impact (e.g., expected investment amounts, production timelines) is included.","The provided text does not specify the scale/locations of protests or which environmental groups are involved."],"key_facts":["Argentina approved a bill associated with President Javier Milei that loosens glacier protections to enable mining activity in glacier regions.","The bill\u2019s approval occurred amid environmental protests.","Multiple outlets characterize the change as opening the door to a mining push and copper-related investment (details not provided in the provided text)."],"numeric_claims":[],"primary_claim":"Argentina approved Milei\u2019s glacier mining bill that loosens glacier protections amid environmental protests.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Argentina has approved President Javier Milei\u2019s glacier mining bill, easing protections for glaciers to enable mining activity, despite environmental protests. The near-term catalyst is the bill\u2019s immediate passage, which is expected to support copper/mining investment plans in glacier regions.","topics":["Argentina","glaciers","mining regulation","environmental protests","copper investment","policy reform"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Argentina approves Milei\u2019s glacier mining bill amid environmental protests The Guardian Argentina passes bill loosening protection of its glaciers BBC Argentina\u2019s Milei Eases Glacier Protections to Unlock Copper Investments WSJ Argentina\u2019s glacier law review opens door to mining push Financial Times Argentina passes reform to ease mining activity in glacier regions Reuters","title":"Argentina approves Milei\u2019s glacier mining bill amid environmental protests - The Guardian","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAIFAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2OYSmDAUDetpsORI83j3dpsv55GJQ/m=syndicationarticleview,_b,_tp"}}

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