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-04T06:14:43.153682+00:00","dedupe_key":"signal_enriched:news_delta:743c0154afca4df1","evidence_event_ids":["evt_43841aa854f8"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTFA1LWU4RllBeU1Wc3dKSGM2eVowM3VTbkpWRXFSQ0dZeVozVjV5akd5Tzg5S0g0d3hTWnpRZ1NSc3NCR0tIT1pvOGhRZEhuLVVfeE9lb19sOHk5aDVZZG16Z3lmLUdYay1FeFNKYWJoTEZhbThBUlZ6NjdR?oc=5","as_of":"2026-04-04T06:14:43.153682+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTFA1LWU4RllBeU1Wc3dKSGM2eVowM3VTbkpWRXFSQ0dZeVozVjV5akd5Tzg5S0g0d3hTWnpRZ1NSc3NCR0tIT1pvOGhRZEhuLVVfeE9lb19sOHk5aDVZZG16Z3lmLUdYay1FeFNKYWJoTEZhbThBUlZ6NjdR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_7e8d43645216424c","canonical_host":"gstatic.com","canonical_is_aggregator":true,"canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-04T06:15:09.676542+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTFA1LWU4RllBeU1Wc3dKSGM2eVowM3VTbkpWRXFSQ0dZeVozVjV5akd5Tzg5S0g0d3hTWnpRZ1NSc3NCR0tIT1pvOGhRZEhuLVVfeE9lb19sOHk5aDVZZG16Z3lmLUdYay1FeFNKYWJoTEZhbThBUlZ6NjdR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiekFVX3lxTFA1LWU4RllBeU1Wc3dKSGM2eVowM3VTbkpWRXFSQ0dZeVozVjV5akd5Tzg5S0g0d3hTWnpRZ1NSc3NCR0tIT1pvOGhRZEhuLVVfeE9lb19sOHk5aDVZZG16Z3lmLUdYay1FeFNKYWJoTEZhbThBUlZ6NjdR?oc=5","source_event_id":"evt_43841aa854f8","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"69eb4292c5e2f7aa","published_at":"2026-04-03T23:45:53+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"N/A","name":"ICE","relevance":"high","symbol":"N/A","type":"government agency"},{"asset_class":"N/A","name":"Texas Migrant Detention Center","relevance":"high","symbol":"N/A","type":"facility"}],"event_type":"regulation","information_gaps":["Details on the specific nature of the violations are not provided.","No information on potential actions or consequences following the report."],"key_facts":["ICE detention deaths are at a record pace.","The Texas facility is the largest U.S. migrant detention camp.","49 violations were cited in the inspection report."],"numeric_claims":[{"label":"number of violations","value":"49"}],"primary_claim":"ICE inspectors found 49 violations of detention standards at the largest U.S. migrant detention camp in Texas.","relevance_score":0.85,"sentiment":"negative","source_quality":"high","summary":"A recent ICE review has uncovered numerous violations at a Texas migrant detention center, raising concerns about safety and conditions.","topics":["immigration","detention standards","human rights"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"ICE Review Finds Dozens of Violations at Texas Migrant Detention Center The New York Times ICE detention deaths are on a record pace. One Texas facility bears the brunt NPR Inspection finds 49 violations of detention standards at largest US migrant detention camp Reuters Inspectors find dozens of safety violations at largest ICE detention center ABC News El Paso ICE facility cited for multiple violations in inspection report ktsm.com","title":"ICE Review Finds Dozens of Violations at Texas Migrant Detention Center - The New York Times","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.oxG97B1aM4g.L.X.O/am=GAINAAAADpgFBhSA/d=1/ed=1/rs=ALs0n2NIOoQVrXz084DJfdUjsCb77BvT5g/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 11980 in events