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/CBMihwFBVV95cUxOTUljWm1yQ084T2hja1lURk5aczU2bS1WNG9qcEUwWHgwT1Q0bGRwLXFFWjRqaThQeHZBVEh2UWRQalkzY2lCTE5RbU9tSnlHTElDWEc5TDYzbXI5ZUFFMDVXMDVXUXhOdlBKSFE3SzdrbkVfZ1B6T2VUdG5rSk84YjZSLWNwRTg?oc=5","as_of":"2026-04-10T17:15:06.449588+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/CBMihwFBVV95cUxOTUljWm1yQ084T2hja1lURk5aczU2bS1WNG9qcEUwWHgwT1Q0bGRwLXFFWjRqaThQeHZBVEh2UWRQalkzY2lCTE5RbU9tSnlHTElDWEc5TDYzbXI5ZUFFMDVXMDVXUXhOdlBKSFE3SzdrbkVfZ1B6T2VUdG5rSk84YjZSLWNwRTg?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2bb6ec824c41c3e3","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-10T17:18:30.868484+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihwFBVV95cUxOTUljWm1yQ084T2hja1lURk5aczU2bS1WNG9qcEUwWHgwT1Q0bGRwLXFFWjRqaThQeHZBVEh2UWRQalkzY2lCTE5RbU9tSnlHTElDWEc5TDYzbXI5ZUFFMDVXMDVXUXhOdlBKSFE3SzdrbkVfZ1B6T2VUdG5rSk84YjZSLWNwRTg?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/CBMihwFBVV95cUxOTUljWm1yQ084T2hja1lURk5aczU2bS1WNG9qcEUwWHgwT1Q0bGRwLXFFWjRqaThQeHZBVEh2UWRQalkzY2lCTE5RbU9tSnlHTElDWEc5TDYzbXI5ZUFFMDVXMDVXUXhOdlBKSFE3SzdrbkVfZ1B6T2VUdG5rSk84YjZSLWNwRTg?oc=5","source_event_id":"evt_551f985bac1a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"2fd7db4ae8652443","published_at":"2026-04-10T09:03:38+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"government","name":"Federal Aviation Administration (FAA)","relevance":"primary actor proposing recruitment/hiring","symbol":"","type":"government_agency"},{"asset_class":"labor","name":"U.S. air traffic controller workforce","relevance":"shortage being addressed","symbol":"","type":"labor_market"},{"asset_class":"labor","name":"Gamers","relevance":"nontraditional recruitment target","symbol":"","type":"candidate_pool"}],"event_type":"supply_disruption","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual article content, so details beyond the headline and the provided source summary cannot be verified here.","The timeline for when gamer-focused recruitment would begin (and whether it is already underway) is not specified in the provided text.","The specific mechanism (e.g., training pipeline, partnerships, eligibility criteria) for recruiting gamers is not present in the provided content.","Whether the 2,300 figure is directly tied to the gamer recruitment initiative or to a broader staffing plan is not fully determinable from the provided material."],"key_facts":["The U.S. faces an air traffic controller shortage (as stated in the provided source summary).","The FAA is turning to gamers as part of the effort to fill the shortage (NYT headline).","A Reuters item in the provided source summary indicates the FAA proposes to hire 2,300 air traffic controllers in a budget request (numeric detail mentioned in the provided summary, not in the NYT headline itself)."],"numeric_claims":[{"label":"Proposed air traffic controller hires","value":"2,300"}],"primary_claim":"The FAA is turning to gamers to help fill the U.S. air traffic controller shortage.","relevance_score":0.72,"sentiment":"neutral","source_quality":"high","summary":"The FAA is responding to a U.S. air traffic controller shortage by recruiting from nontraditional sources, including gamers, as reported by The New York Times. The near-term catalyst is the FAA\u2019s hiring/implementation effort tied to its budget request.","topics":["air traffic control","FAA staffing","labor shortage","recruitment strategy","aviation operations"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"To Fill Air Traffic Controller Shortage, F.A.A. Turns to Gamers The New York Times The U.S. faces an air traffic controller shortage. It's turning to gamers for help. CBS News US Government Pitches Gamers a Career as Air Traffic Controllers Bloomberg.com Trump Goon Makes Alarming New Pitch to Solve Air Traffic Control Mess The Daily Beast FAA proposes to hire 2,300 air traffic controllers in budget request Reuters","title":"To Fill Air Traffic Controller Shortage, F.A.A. Turns to Gamers - 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_b6068543aeb6 in signals