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/CBMi-gFBVV95cUxQbXNPa3lsbmtrQjNOY3VoWDdCeUlRdW5waXlUUG1EQ04wUjlaSzFlaDQxSzNYaWd0b2pCYzQ5YUp4UWtlc0N5NnBFYU0wX0pNc2ZrS1FCMDExWHR3ZFZ3VWxXMm9sT01nRmFnNFJCYkt3aFQ2U2ZuMlpOLXpyRU5aSTVFb0ROUlZTQXBReHlMenZrejhRTnN3Sk5fWjJjd2JrRzk0S21qUDNRTU9ycUxEUUx1M0ZwNDVXdnE4ZXl3cmZpZUU2WG9rcHlZMW5JU2ZfZTN0dGJ6Y0pncHVCNFZCS0FKZ1JILVB4ZXliRk80c3d6SWtVVnhVNzZB?oc=5","as_of":"2026-04-10T19:36:11.911811+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/CBMi-gFBVV95cUxQbXNPa3lsbmtrQjNOY3VoWDdCeUlRdW5waXlUUG1EQ04wUjlaSzFlaDQxSzNYaWd0b2pCYzQ5YUp4UWtlc0N5NnBFYU0wX0pNc2ZrS1FCMDExWHR3ZFZ3VWxXMm9sT01nRmFnNFJCYkt3aFQ2U2ZuMlpOLXpyRU5aSTVFb0ROUlZTQXBReHlMenZrejhRTnN3Sk5fWjJjd2JrRzk0S21qUDNRTU9ycUxEUUx1M0ZwNDVXdnE4ZXl3cmZpZUU2WG9rcHlZMW5JU2ZfZTN0dGJ6Y0pncHVCNFZCS0FKZ1JILVB4ZXliRk80c3d6SWtVVnhVNzZB?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_01299c49a735950e","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-10T20:15:16.237468+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi-gFBVV95cUxQbXNPa3lsbmtrQjNOY3VoWDdCeUlRdW5waXlUUG1EQ04wUjlaSzFlaDQxSzNYaWd0b2pCYzQ5YUp4UWtlc0N5NnBFYU0wX0pNc2ZrS1FCMDExWHR3ZFZ3VWxXMm9sT01nRmFnNFJCYkt3aFQ2U2ZuMlpOLXpyRU5aSTVFb0ROUlZTQXBReHlMenZrejhRTnN3Sk5fWjJjd2JrRzk0S21qUDNRTU9ycUxEUUx1M0ZwNDVXdnE4ZXl3cmZpZUU2WG9rcHlZMW5JU2ZfZTN0dGJ6Y0pncHVCNFZCS0FKZ1JILVB4ZXliRk80c3d6SWtVVnhVNzZB?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"elevenwarriors.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi-gFBVV95cUxQbXNPa3lsbmtrQjNOY3VoWDdCeUlRdW5waXlUUG1EQ04wUjlaSzFlaDQxSzNYaWd0b2pCYzQ5YUp4UWtlc0N5NnBFYU0wX0pNc2ZrS1FCMDExWHR3ZFZ3VWxXMm9sT01nRmFnNFJCYkt3aFQ2U2ZuMlpOLXpyRU5aSTVFb0ROUlZTQXBReHlMenZrejhRTnN3Sk5fWjJjd2JrRzk0S21qUDNRTU9ycUxEUUx1M0ZwNDVXdnE4ZXl3cmZpZUU2WG9rcHlZMW5JU2ZfZTN0dGJ6Y0pncHVCNFZCS0FKZ1JILVB4ZXliRk80c3d6SWtVVnhVNzZB?oc=5","source_event_id":"evt_fc4a982b0419","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"7401856f70dd87e5","published_at":"2026-04-10T17:01:54+00:00","publisher_domain":"elevenwarriors.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"college_basketball_player","name":"Justin Pippen","relevance":"primary","symbol":"","type":"person"},{"asset_class":"college_team","name":"Ohio State","relevance":"primary","symbol":"","type":"organization"},{"asset_class":"college_team","name":"Michigan","relevance":"secondary","symbol":"","type":"organization"},{"asset_class":"college_team","name":"Cal","relevance":"secondary","symbol":"","type":"organization"},{"asset_class":"public_figure","name":"Scottie Pippen","relevance":"secondary","symbol":"","type":"person"},{"asset_class":"sports_conference","name":"Big Ten Conference","relevance":"secondary","symbol":"","type":"organization"}],"event_type":"listing","information_gaps":["The provided text is largely styling/boilerplate and does not include the full article content; details such as commitment date, scholarship/eligibility specifics, and position designation (e.g., CG/guard) are not fully verifiable from the cleaned excerpt.","Near-term catalyst timing (e.g., when he will be eligible to play) is not stated in the provided content.","The exact source of the commitment confirmation (e.g., ESPN vs. team announcement) is not verifiable from the excerpt alone."],"key_facts":["Justin Pippen is described as a former Cal and Michigan Guard.","Justin Pippen is described as the son of Scottie Pippen.","Justin Pippen committed to Ohio State.","The reporting frames the commitment as a return to the Big Ten.","The reporting describes Justin Pippen as transferring from Michigan to Ohio State."],"numeric_claims":[],"primary_claim":"Justin Pippen has committed to Ohio State after transferring from Michigan.","relevance_score":0.62,"sentiment":"positive","source_quality":"high","summary":"Justin Pippen, a former Cal and Michigan Guard player and son of Scottie Pippen, has committed to Ohio State. The move is described as a transfer back to the Big Ten and a landing with a Michigan rival.","topics":["college basketball recruiting","transfer portal","Ohio State Buckeyes","Michigan Wolverines","Big Ten Conference","Justin Pippen"]},"source":"Eleven Warriors","source_domain":"elevenwarriors.com","source_url":"https://www.elevenwarriors.com","summary":"Former Cal and Michigan Guard Justin Pippen, Son of Scottie Pippen, Commits to Ohio State Eleven Warriors Cal G Justin Pippen returning to Big Ten, commits to Ohio State ESPN Former Michigan basketball player transferring to Ohio State after strong season ClickOnDetroit | WDIV Local 4 Justin Pippen commits to Ohio State: Son of Scottie Pippen, Cal CG returning to Big Ten CBS Sports Ex-Wolverine transferring to one of Michigan\u2019s rivals MLive.com","title":"Former Cal and Michigan Guard Justin Pippen, Son of Scottie Pippen, Commits to Ohio State - Eleven Warriors","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_d7569ac3e662 in signals