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/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

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