SQLite Web: event

id

Primary key. TEXT

event_id

TEXT NOT NULL

watcher_id

TEXT

signal_type

TEXT NOT NULL

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

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_69fe702fa6b9 in signals