SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T11:09:50.802312+00:00","dedupe_key":"signal_enriched:news_delta:203e990da6a73f2c","evidence_event_ids":["evt_15cbf639449e"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxNV3NORGp2NWdWN25Ic0ZvZWhFWlV5QjA4Z0JUc1BGVk8ybVljYW0zRG9ua2dIOVBvZXdNZXRrUnBxMEEyR0p6cGRYV0swNVlPd0xybmNabnJaMmI5elJ1aVVURU5JUTk2NGdobFQxbFJXNFphdU9kVklJQU5WaDF0RDNUZDctMDBCV19WUUNFNW5WMlF3SzlDc1g1dWEyZ0s0WW42Rl9sejlIZ0hUZHRtXzJHNXFITVZuTGNOQUhXREk5QQ?oc=5","as_of":"2026-04-08T11:09:50.802312+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/CBMiwgFBVV95cUxNV3NORGp2NWdWN25Ic0ZvZWhFWlV5QjA4Z0JUc1BGVk8ybVljYW0zRG9ua2dIOVBvZXdNZXRrUnBxMEEyR0p6cGRYV0swNVlPd0xybmNabnJaMmI5elJ1aVVURU5JUTk2NGdobFQxbFJXNFphdU9kVklJQU5WaDF0RDNUZDctMDBCV19WUUNFNW5WMlF3SzlDc1g1dWEyZ0s0WW42Rl9sejlIZ0hUZHRtXzJHNXFITVZuTGNOQUhXREk5QQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_d0643e3172642303","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-08T11:10:44.691736+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxNV3NORGp2NWdWN25Ic0ZvZWhFWlV5QjA4Z0JUc1BGVk8ybVljYW0zRG9ua2dIOVBvZXdNZXRrUnBxMEEyR0p6cGRYV0swNVlPd0xybmNabnJaMmI5elJ1aVVURU5JUTk2NGdobFQxbFJXNFphdU9kVklJQU5WaDF0RDNUZDctMDBCV19WUUNFNW5WMlF3SzlDc1g1dWEyZ0s0WW42Rl9sejlIZ0hUZHRtXzJHNXFITVZuTGNOQUhXREk5QQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"cbssports.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxNV3NORGp2NWdWN25Ic0ZvZWhFWlV5QjA4Z0JUc1BGVk8ybVljYW0zRG9ua2dIOVBvZXdNZXRrUnBxMEEyR0p6cGRYV0swNVlPd0xybmNabnJaMmI5elJ1aVVURU5JUTk2NGdobFQxbFJXNFphdU9kVklJQU5WaDF0RDNUZDctMDBCV19WUUNFNW5WMlF3SzlDc1g1dWEyZ0s0WW42Rl9sejlIZ0hUZHRtXzJHNXFITVZuTGNOQUhXREk5QQ?oc=5","source_event_id":"evt_15cbf639449e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"81ecd7f9521804da","published_at":"2026-04-08T01:51:14+00:00","publisher_domain":"cbssports.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.66,"dates_mentioned":["Tuesday"],"entities":[{"asset_class":"media","name":"CBS Sports","relevance":"primary source of the headline","symbol":"","type":"publisher"},{"asset_class":"sports_event","name":"2026 college basketball transfer portal","relevance":"core subject","symbol":"","type":"event"},{"asset_class":"athlete","name":"Flory Bidunga","relevance":"named player in source summary","symbol":"","type":"athlete"},{"asset_class":"athlete","name":"Somto Cyril Acaden Lewis","relevance":"named player in source summary","symbol":"","type":"athlete"},{"asset_class":"athlete","name":"Juke Harris","relevance":"named player in source summary","symbol":"","type":"athlete"},{"asset_class":"media","name":"ESPN","relevance":"referenced via transfer portal tracker","symbol":"","type":"publisher"},{"asset_class":"sports_tool","name":"ACC transfer portal tracker","relevance":"referenced via team-by-team look","symbol":"","type":"tool"},{"asset_class":"media","name":"Syracuse.com","relevance":"referenced via transfer portal intel article","symbol":"","type":"publisher"},{"asset_class":"media","name":"247Sports","relevance":"referenced via transfer portal rankings","symbol":"","type":"publisher"},{"asset_class":"media","name":"USA Today","relevance":"referenced via transfer portal rankings","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["The provided article text is not actually present (only page styling/HTML), so specific details such as the number of entries, specific commitments, or exact ranking lists are not extractable from the cleaned text.","The exact year/season context of the transfer portal window (e.g., whether it is the standard NCAA transfer window) is not explicitly stated beyond \u201c2026\u201d and \u201cwindow opens on Tuesday.\u201d","No directional impact (e.g., which teams gain/lose players) can be determined from the provided text beyond the general expectation of portal activity."],"key_facts":["CBS Sports headline indicates live updates for the 2026 men\u2019s college basketball transfer portal as the window opens on Tuesday.","The coverage is described as including entries, commitments, and news.","The source summary indicates additional related coverage/rankings from ESPN, Syracuse.com, 247Sports, and USA Today.","The source summary specifically mentions \u201cIntel on Flory Bidunga, Somto Cyril Acaden Lewis, Juke Harris.\u201d"],"numeric_claims":[],"primary_claim":"The 2026 college basketball transfer portal window opens on Tuesday and CBS Sports will provide live updates on entries/commitments plus player rankings.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"CBS Sports is publishing live updates and rankings for the 2026 men\u2019s college basketball transfer portal as the window opens Tuesday, including entries and commitments.","topics":["college basketball","transfer portal","player entries","commitments","recruiting","rosters"]},"source":"CBS Sports","source_domain":"cbssports.com","source_url":"https://www.cbssports.com","summary":"2026 college basketball transfer portal: Live updates, entries, commitments, news as window opens on Tuesday CBS Sports Ranking the top 20 men's basketball players to enter the transfer portal ESPN ACC transfer portal tracker: A team-by-team look at who\u2019s in the portal Syracuse.com 2026 College Basketball Transfer Portal: Intel on Flory Bidunga, Somto Cyril Acaden Lewis, Juke Harris 247Sports College basketball transfer portal rankings: Top 50 available players usatoday.com","title":"2026 college basketball transfer portal: Live updates, entries, commitments, news as window opens on Tuesday - CBS Sports","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 6111 in events