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/CBMipwFBVV95cUxNNFlLVUhaQjl6cGZEM3VZSFB3UnV5QzhEQVlQOFlQWmUtNmRENVM1Y2U1REYzTzZQU1c2LUllRFhGb0dFbkdLcEVTTmtfQlFNbWhndU0yR0tMREN3VVFtWjhCVjBoVl9GR1RXSl9HMlQ0OEF5dUcwRUo0c0o0SExBU21SSDZ3RFRlS0NnSDdFOHFONUhmZm1UamwxWVUwUFJQem5wUUVGZw?oc=5","as_of":"2026-04-10T02:12:57.312441+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/CBMipwFBVV95cUxNNFlLVUhaQjl6cGZEM3VZSFB3UnV5QzhEQVlQOFlQWmUtNmRENVM1Y2U1REYzTzZQU1c2LUllRFhGb0dFbkdLcEVTTmtfQlFNbWhndU0yR0tMREN3VVFtWjhCVjBoVl9GR1RXSl9HMlQ0OEF5dUcwRUo0c0o0SExBU21SSDZ3RFRlS0NnSDdFOHFONUhmZm1UamwxWVUwUFJQem5wUUVGZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2aa1efccb1add021","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-10T02:13:54.242502+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxNNFlLVUhaQjl6cGZEM3VZSFB3UnV5QzhEQVlQOFlQWmUtNmRENVM1Y2U1REYzTzZQU1c2LUllRFhGb0dFbkdLcEVTTmtfQlFNbWhndU0yR0tMREN3VVFtWjhCVjBoVl9GR1RXSl9HMlQ0OEF5dUcwRUo0c0o0SExBU21SSDZ3RFRlS0NnSDdFOHFONUhmZm1UamwxWVUwUFJQem5wUUVGZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"on3.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMipwFBVV95cUxNNFlLVUhaQjl6cGZEM3VZSFB3UnV5QzhEQVlQOFlQWmUtNmRENVM1Y2U1REYzTzZQU1c2LUllRFhGb0dFbkdLcEVTTmtfQlFNbWhndU0yR0tMREN3VVFtWjhCVjBoVl9GR1RXSl9HMlQ0OEF5dUcwRUo0c0o0SExBU21SSDZ3RFRlS0NnSDdFOHFONUhmZm1UamwxWVUwUFJQem5wUUVGZw?oc=5","source_event_id":"evt_0b45cc60ad30","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"c5cb9e0ac8aa9ffc","published_at":"2026-04-09T23:01:17+00:00","publisher_domain":"on3.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sports","name":"Michigan Wolverines men\u2019s basketball","relevance":"high","symbol":"","type":"sports_team"},{"asset_class":"sports_player","name":"J.P. Estrella","relevance":"high","symbol":"","type":"athlete"},{"asset_class":"sports","name":"Tennessee Volunteers men\u2019s basketball","relevance":"high","symbol":"","type":"sports_team"}],"event_type":"listing","information_gaps":["The cleaned article text provided is mostly page styling/boilerplate; the actual body content confirming details (e.g., official announcement date, scholarship/eligibility specifics) is not present in the supplied text.","The signal does not specify Estrella\u2019s position, class year, or statistical impact; only the transfer/landing claim is supported by the headline and summary.","\u201cSEC transfer\u201d is asserted by the headline, but the provided text does not explicitly define the term or confirm conference affiliation beyond the Tennessee reference."],"key_facts":["On3 headline indicates Michigan \u201clands\u201d J.P. Estrella as an SEC transfer out of the Transfer Portal.","The source summary repeatedly references Tennessee transfer J.P. Estrella and Michigan\u2019s addition.","The article framing suggests this addition occurs shortly after Michigan\u2019s reported pursuit/interest (timing relative to \u201cdays after\u201d is mentioned in the provided source summary)."],"numeric_claims":[],"primary_claim":"Michigan landed Tennessee transfer J.P. Estrella (SEC transfer) out of the Transfer Portal.","relevance_score":0.72,"sentiment":"positive","source_quality":"high","summary":"Michigan has reportedly secured SEC transfer J.P. Estrella from Tennessee, described as a coveted portal addition. The move is positioned as a near-term roster catalyst for Michigan men\u2019s basketball.","topics":["college basketball","transfer portal","NCAA roster moves","Michigan basketball","Tennessee basketball","J.P. Estrella"]},"source":"On3","source_domain":"on3.com","source_url":"https://www.on3.com","summary":"Michigan lands coveted SEC transfer out of Transfer Portal On3 Michigan lands coveted Tennessee transfer J.P. Estrella ESPN Michigan basketball lands Tennessee transfer J.P. Estrella days after title Detroit Free Press Michigan basketball lands Vols transfer J.P. Estrella Wolverines Wire Predicting Michigan\u2019s next 2 portal pickups after Dusty May\u2019s J.P Estrella addition GBMWolverine","title":"Michigan lands coveted SEC transfer out of Transfer Portal - On3","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_b431c6dc089e in signals