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/CBMiggFBVV95cUxPenZ2SWVvUzEyY3U5V1BEY05rZ3BLMU5hYnFIdk9qVEpxV1Y3Z19Qb3hMMno4dkN4OWtaYnhvOWZwNU14Z1VOTFp2RzRoTWVnQ0Y0NmRaU3NIOVRGQk10TDlFQzI4d05VZnNXSTR1TWpnOFdVcGVKbndKY1loOHMwelZB?oc=5","as_of":"2026-04-10T10:50:51.924398+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/CBMiggFBVV95cUxPenZ2SWVvUzEyY3U5V1BEY05rZ3BLMU5hYnFIdk9qVEpxV1Y3Z19Qb3hMMno4dkN4OWtaYnhvOWZwNU14Z1VOTFp2RzRoTWVnQ0Y0NmRaU3NIOVRGQk10TDlFQzI4d05VZnNXSTR1TWpnOFdVcGVKbndKY1loOHMwelZB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9324eb3e43ab94ee","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-10T10:51:24.204358+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiggFBVV95cUxPenZ2SWVvUzEyY3U5V1BEY05rZ3BLMU5hYnFIdk9qVEpxV1Y3Z19Qb3hMMno4dkN4OWtaYnhvOWZwNU14Z1VOTFp2RzRoTWVnQ0Y0NmRaU3NIOVRGQk10TDlFQzI4d05VZnNXSTR1TWpnOFdVcGVKbndKY1loOHMwelZB?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/CBMiggFBVV95cUxPenZ2SWVvUzEyY3U5V1BEY05rZ3BLMU5hYnFIdk9qVEpxV1Y3Z19Qb3hMMno4dkN4OWtaYnhvOWZwNU14Z1VOTFp2RzRoTWVnQ0Y0NmRaU3NIOVRGQk10TDlFQzI4d05VZnNXSTR1TWpnOFdVcGVKbndKY1loOHMwelZB?oc=5","source_event_id":"evt_fe4204fd4135","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1014e8dae1af1980","published_at":"2026-04-10T09:02:11+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"n/a","name":"Donald Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"n/a","name":"H-1B visa program","relevance":"high","symbol":"","type":"policy_program"},{"asset_class":"n/a","name":"Employers (unspecified)","relevance":"high","symbol":"","type":"group"},{"asset_class":"equity","name":"Walmart","relevance":"medium","symbol":"WMT","type":"company"},{"asset_class":"n/a","name":"White House","relevance":"medium","symbol":"","type":"government_body"}],"event_type":"regulation","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual NYT article content, so the specific mechanism of how employers are \u201clocked out\u201d is not verifiable from the provided text.","No effective date, implementation timeline, or which employer categories are excluded is included in the provided material.","The $100,000 fee and \u201cwage-weighted H-1B lottery\u201d are mentioned only in the external source summaries; the exact policy details are not present in the provided NYT text.","Near-term catalyst timing (e.g., when filings/lottery outcomes will reflect the changes) is not specified in the provided content."],"key_facts":["The New York Times headline states that Trump\u2019s changes lock some employers out of the H-1B visa program.","Business Insider coverage (in the provided source summary) says Walmart\u2019s H-1B filings fell by more than half after Trump\u2019s visa shake-up.","CBS News coverage (in the provided source summary) says the White House\u2019s $100,000 H-1B visa fee is impacting America\u2019s ability to attract global talent.","The Times of India commentary (in the provided source summary) references a new $100k H-1B fee and a wage-weighted H-1B lottery that could sideline U.S. start-ups."],"numeric_claims":[{"label":"H-1B fee","value":"$100,000"},{"label":"Change in Walmart H-1B filings","value":"fell by more than half"}],"primary_claim":"Trump\u2019s changes to the H-1B visa program are locking some employers out of the program.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"The New York Times reports that Trump\u2019s changes to the H-1B visa program are preventing some employers from participating. Related coverage suggests the changes\u2014especially a higher H-1B fee\u2014have already reduced H-1B filings, with near-term effects on hiring plans for foreign talent.","topics":["H-1B","immigration policy","employer eligibility","visa fees","workforce/talent acquisition"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Trump\u2019s Changes Lock Some Employers Out of H-1B Visa Program The New York Times Walmart's H-1B filings fell by more than half in the wake of Trump's visa shake-up Business Insider How the White House's $100,000 H-1B visa fee is impacting America's ability to attract global talent CBS News 'Indians are the new oil, coal, or gas': Immigration agency founder says new H-1B fee is America's loss, Fox's Laura Ingraham reacts The Times of India Commentary: New $100k Fee and Wage-Weighted H-1B Lottery Could Sideline U.S. Start-Ups VisaHQ","title":"Trump\u2019s Changes Lock Some Employers Out of H-1B Visa Program - 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_7f8067ed8ba5 in signals