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/CBMivAJBVV95cUxOM0hBU2JBLUhOVDlHYV8xZTJQSmdSc1g3UmlNLWRTcGF3Ri01QVJlblNzbm0yUDgweTdNTllFR09OVmZQbVRfN0ZEWDJEbnE4TlRZR0RLRk9lbGpKTGtXN3dBdXdoN1YyYzYtYzZzR0tTSzkxcGxtMkRCOXh4X0txVUFPdjRXZlFZQmJvQVJoU3J0SGNvbGx4M3V0OHRBTFRBeG9odEdCOTB2QmlsVE5BclhVZkc1M2dEZ1EyNFRlYzd2Z0NvYm84NkhJd2tqRDdtX3lSWUpleEs0RldCcWYwNUs4VzBRWjExcElrR0hzWFJUYlFxM0ZnTzNRWVFlYnZTTDJGZ1pXNkZuNG9QT0Vlcmk0ZkZOQTdEeUxJVVl4TDF6RmJ2T0tkMDU3eEY0SE00OW9WNVhCaHh6bDBN?oc=5","as_of":"2026-04-08T09:53:09.629153+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/CBMivAJBVV95cUxOM0hBU2JBLUhOVDlHYV8xZTJQSmdSc1g3UmlNLWRTcGF3Ri01QVJlblNzbm0yUDgweTdNTllFR09OVmZQbVRfN0ZEWDJEbnE4TlRZR0RLRk9lbGpKTGtXN3dBdXdoN1YyYzYtYzZzR0tTSzkxcGxtMkRCOXh4X0txVUFPdjRXZlFZQmJvQVJoU3J0SGNvbGx4M3V0OHRBTFRBeG9odEdCOTB2QmlsVE5BclhVZkc1M2dEZ1EyNFRlYzd2Z0NvYm84NkhJd2tqRDdtX3lSWUpleEs0RldCcWYwNUs4VzBRWjExcElrR0hzWFJUYlFxM0ZnTzNRWVFlYnZTTDJGZ1pXNkZuNG9QT0Vlcmk0ZkZOQTdEeUxJVVl4TDF6RmJ2T0tkMDU3eEY0SE00OW9WNVhCaHh6bDBN?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2ed187c977caa1e0","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-08T09:53:51.931804+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMivAJBVV95cUxOM0hBU2JBLUhOVDlHYV8xZTJQSmdSc1g3UmlNLWRTcGF3Ri01QVJlblNzbm0yUDgweTdNTllFR09OVmZQbVRfN0ZEWDJEbnE4TlRZR0RLRk9lbGpKTGtXN3dBdXdoN1YyYzYtYzZzR0tTSzkxcGxtMkRCOXh4X0txVUFPdjRXZlFZQmJvQVJoU3J0SGNvbGx4M3V0OHRBTFRBeG9odEdCOTB2QmlsVE5BclhVZkc1M2dEZ1EyNFRlYzd2Z0NvYm84NkhJd2tqRDdtX3lSWUpleEs0RldCcWYwNUs4VzBRWjExcElrR0hzWFJUYlFxM0ZnTzNRWVFlYnZTTDJGZ1pXNkZuNG9QT0Vlcmk0ZkZOQTdEeUxJVVl4TDF6RmJ2T0tkMDU3eEY0SE00OW9WNVhCaHh6bDBN?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"247sports.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMivAJBVV95cUxOM0hBU2JBLUhOVDlHYV8xZTJQSmdSc1g3UmlNLWRTcGF3Ri01QVJlblNzbm0yUDgweTdNTllFR09OVmZQbVRfN0ZEWDJEbnE4TlRZR0RLRk9lbGpKTGtXN3dBdXdoN1YyYzYtYzZzR0tTSzkxcGxtMkRCOXh4X0txVUFPdjRXZlFZQmJvQVJoU3J0SGNvbGx4M3V0OHRBTFRBeG9odEdCOTB2QmlsVE5BclhVZkc1M2dEZ1EyNFRlYzd2Z0NvYm84NkhJd2tqRDdtX3lSWUpleEs0RldCcWYwNUs4VzBRWjExcElrR0hzWFJUYlFxM0ZnTzNRWVFlYnZTTDJGZ1pXNkZuNG9QT0Vlcmk0ZkZOQTdEeUxJVVl4TDF6RmJ2T0tkMDU3eEY0SE00OW9WNVhCaHh6bDBN?oc=5","source_event_id":"evt_3d918b97aae1","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"708af95f48216e11","published_at":"2026-04-07T19:59:05+00:00","publisher_domain":"247sports.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["2026"],"entities":[{"asset_class":"other","name":"Flory Bidunga","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Somto Cyril Acaden Lewis","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"Juke Harris","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"247Sports","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"ESPN","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"USA Today","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"On3","relevance":"medium","symbol":"","type":"organization"},{"asset_class":"other","name":"CBS Sports","relevance":"medium","symbol":"","type":"organization"}],"event_type":"listing","information_gaps":["No destination schools are stated in the provided text.","No specific timing (e.g., when bids are expected to be made/when players will enter) is included beyond the 2026 framing.","No ranking positions (e.g., top 10/top 20 exact order) are provided in the extracted content.","The provided article text appears to be largely non-content (CSS/HTML), so detailed claims from the article body cannot be verified here."],"key_facts":["The signal references a 247Sports article about the 2026 college basketball transfer portal.","The headline/summary explicitly names Flory Bidunga, Somto Cyril Acaden Lewis, and Juke Harris.","The source summary indicates the article is ranking top players to enter the transfer portal and references other outlets\u2019 transfer-portal rankings (ESPN, USA Today, On3, CBS Sports)."],"numeric_claims":[],"primary_claim":"The 247Sports transfer-portal intel/rankings for 2026 men\u2019s college basketball includes Flory Bidunga, Somto Cyril Acaden Lewis, and Juke Harris among the top players to enter the transfer portal.","relevance_score":0.55,"sentiment":"neutral","source_quality":"high","summary":"247Sports\u2019 transfer-portal coverage highlights specific 2026 men\u2019s college basketball players (Flory Bidunga, Somto Cyril Acaden Lewis, and Juke Harris) as part of its intel/rankings on who could enter the transfer portal. The provided text does not include the underlying details of bids, destinations, or timing beyond the existence of these players in the portal-ranking context.","topics":["college basketball","transfer portal","player rankings","2026 recruiting/roster movement"]},"source":"247Sports","source_domain":"247sports.com","source_url":"https://247sports.com","summary":"2026 College Basketball Transfer Portal: Intel on Flory Bidunga, Somto Cyril Acaden Lewis, Juke Harris 247Sports Ranking the top 20 men's basketball players to enter the transfer portal ESPN College basketball transfer portal rankings: Top 50 available players USA Today The teams to watch for the Transfer Portal's top 10 targets On3 Women's college basketball transfer portal rankings: The 20 best players set to change teams CBS Sports","title":"2026 College Basketball Transfer Portal: Intel on Flory Bidunga, Somto Cyril Acaden Lewis, Juke Harris - 247Sports","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_5424ed2a44b4 in signals