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/CBMijgFBVV95cUxPb1RMcDRBaTExS2Qxd21GT2ttVXU4MElJRDA2V2VqWTdYdTVHbVZ0SmJHdlI3dVlkNGsxMVQ3N0F4SHpxLTNGMkFoU1dFd2ZHcWlvc01FYmpsQlRGbG5ON1VZQnVLcDZDUVhLNVZfOWNiR0hvNktrME12Q3VjQzdqa1E3V3lTSHU2eXZyRXhn?oc=5","as_of":"2026-04-10T16:36:01.675086+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/CBMijgFBVV95cUxPb1RMcDRBaTExS2Qxd21GT2ttVXU4MElJRDA2V2VqWTdYdTVHbVZ0SmJHdlI3dVlkNGsxMVQ3N0F4SHpxLTNGMkFoU1dFd2ZHcWlvc01FYmpsQlRGbG5ON1VZQnVLcDZDUVhLNVZfOWNiR0hvNktrME12Q3VjQzdqa1E3V3lTSHU2eXZyRXhn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_aa958bfa7dfebe7f","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:17:04.383739+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPb1RMcDRBaTExS2Qxd21GT2ttVXU4MElJRDA2V2VqWTdYdTVHbVZ0SmJHdlI3dVlkNGsxMVQ3N0F4SHpxLTNGMkFoU1dFd2ZHcWlvc01FYmpsQlRGbG5ON1VZQnVLcDZDUVhLNVZfOWNiR0hvNktrME12Q3VjQzdqa1E3V3lTSHU2eXZyRXhn?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPb1RMcDRBaTExS2Qxd21GT2ttVXU4MElJRDA2V2VqWTdYdTVHbVZ0SmJHdlI3dVlkNGsxMVQ3N0F4SHpxLTNGMkFoU1dFd2ZHcWlvc01FYmpsQlRGbG5ON1VZQnVLcDZDUVhLNVZfOWNiR0hvNktrME12Q3VjQzdqa1E3V3lTSHU2eXZyRXhn?oc=5","source_event_id":"evt_9c77b067df40","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"af5ced3211aa24a1","published_at":"2026-04-10T09:01:00+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"","name":"NPR","relevance":"primary_source","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Women","relevance":"affected_group","symbol":"","type":"demographic_group"},{"asset_class":"","name":"Men","relevance":"affected_group","symbol":"","type":"demographic_group"}],"event_type":"macro_policy","information_gaps":["No article body content is provided beyond styling/HTML, so the specific data source, time period, magnitude (e.g., percentages), and the explanation(s) for the gender difference are not available.","No geographic scope (e.g., U.S. vs. global) is stated in the provided text.","No near-term catalyst timing is provided in the headline/summary."],"key_facts":["Headline states: \u201cWomen are getting most of the new jobs.\u201d","Headline adds: \u201cWhat\u2019s going on with men?\u201d"],"numeric_claims":[],"primary_claim":"Women are getting most of the new jobs, while men are not receiving an equivalent share of new job gains, according to NPR.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"NPR reports that women are receiving most of the new jobs, and asks what is happening for men.","topics":["labor_market","employment","gender_gap","job_creation","workforce_demographics"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Women are getting most of the new jobs. What's going on with men? NPR View Full Coverage on Google News","title":"Women are getting most of the new jobs. What's going on with men? - NPR","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_e5af7677d191 in signals