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-09T13:30:33.001204+00:00","dedupe_key":"signal_enriched:news_delta:65c7f5713f75434e","evidence_event_ids":["evt_81a1d8abe996"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxQaGNyX1c4UVA2bk44ZzJwbDhlc29PZ3NXdXRSTUlOVzNQVUZqTmtVVUJMS2x3aS1NMFZOdmx4c2dWU1lhVnFiUldVa3Q0ZGRaWHFyVG1sN2phdVVTNUZnMzFvTjktYzlpRXloUktLNG1zODVuNXNTQlpMdUo2Sm9vaUg5ZWZQLV9zUGJLc3lmbWM1QQ?oc=5","as_of":"2026-04-09T13:30:33.001204+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/CBMikgFBVV95cUxQaGNyX1c4UVA2bk44ZzJwbDhlc29PZ3NXdXRSTUlOVzNQVUZqTmtVVUJMS2x3aS1NMFZOdmx4c2dWU1lhVnFiUldVa3Q0ZGRaWHFyVG1sN2phdVVTNUZnMzFvTjktYzlpRXloUktLNG1zODVuNXNTQlpMdUo2Sm9vaUg5ZWZQLV9zUGJLc3lmbWM1QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_707b41754c798e29","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-09T23:30:54.307857+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxQaGNyX1c4UVA2bk44ZzJwbDhlc29PZ3NXdXRSTUlOVzNQVUZqTmtVVUJMS2x3aS1NMFZOdmx4c2dWU1lhVnFiUldVa3Q0ZGRaWHFyVG1sN2phdVVTNUZnMzFvTjktYzlpRXloUktLNG1zODVuNXNTQlpMdUo2Sm9vaUg5ZWZQLV9zUGJLc3lmbWM1QQ?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/CBMikgFBVV95cUxQaGNyX1c4UVA2bk44ZzJwbDhlc29PZ3NXdXRSTUlOVzNQVUZqTmtVVUJMS2x3aS1NMFZOdmx4c2dWU1lhVnFiUldVa3Q0ZGRaWHFyVG1sN2phdVVTNUZnMzFvTjktYzlpRXloUktLNG1zODVuNXNTQlpMdUo2Sm9vaUg5ZWZQLV9zUGJLc3lmbWM1QQ?oc=5","source_event_id":"evt_81a1d8abe996","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1f0da5a9506d891d","published_at":"2026-04-09T09:00:46+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"ICE (U.S. Immigration and Customs Enforcement)","relevance":"high","symbol":"","type":"government_agency"},{"asset_class":"media","name":"New York Times","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"geography","name":"Pennsylvania town (unnamed in provided text)","relevance":"high","symbol":"","type":"location"},{"asset_class":"government","name":"DHS (U.S. Department of Homeland Security)","relevance":"medium","symbol":"","type":"government_agency"},{"asset_class":"geography","name":"Georgia (ICE facilities development referenced in source summary)","relevance":"medium","symbol":"","type":"location"},{"asset_class":"geography","name":"Maryland (planned facility referenced in source summary)","relevance":"low","symbol":"","type":"location"}],"event_type":"conflict","information_gaps":["The specific Pennsylvania town name, the proposed facility/warehouse address, and the timeline for the ICE detention center are not present in the provided text.","The provided text does not state whether the Pennsylvania plan is paused, approved, or under review\u2014only that locals are venting/protesting.","No quantitative details are provided (e.g., number of protesters, expected detainee capacity, or project cost).","The relationship between the Pennsylvania protest and any DHS pause decision is not explicitly stated in the provided excerpt."],"key_facts":["A planned ICE detention center is the subject of local protests in a deep-red Pennsylvania town (NYT headline).","The provided source summary indicates other U.S. communities have responded to plans to convert warehouses into immigration detention centers (AP context).","The provided source summary indicates DHS paused development of ICE facilities in Georgia (WABE/USA Today context).","The provided source summary indicates a planned Maryland immigration detention facility was paused (ABC context)."],"numeric_claims":[],"primary_claim":"Locals in a deep-red Pennsylvania town are protesting a planned ICE detention center.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"The New York Times reports local backlash in a strongly Republican (\"deep red\") Pennsylvania community against plans to convert a facility into an ICE detention center. The broader coverage context highlights similar local controversies over ICE detention/warehouse conversions and notes DHS actions to pause some ICE facility development.","topics":["immigration detention","ICE facilities","local community protests","federal vs local government tensions","warehouse conversion controversy"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"In a Deep Red Town In Pennsylvania, Locals Vent Over a Planned ICE Detention Center The New York Times How US communities have responded to plans to convert warehouses into immigration detention centers AP News Protesters rally against planned Maryland immigration detention facility that's now paused ABC News DHS to pause development of ICE facilities in Georgia. What we know USA Today Controversies around Georgia immigration warehouses illustrate tensions between local and federal government WABE","title":"In a Deep Red Town In Pennsylvania, Locals Vent Over a Planned ICE Detention Center - The New York Times","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 10129 in events