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/CBMirAFBVV95cUxPZkpmeVI1cllFRllTNEF6N282eGtHSllzNWpxWEVjY1UyX2pRbVM4UXcwX29SYlk4dnJ5TnBwcTFwOW5nX0JCRzFkTldiUGktMmJnT2R2OW5NT2txUHRKOU8tTXktcDQ0clVOUUIwMDRPZ05nTVVPVlQ1eFZxSmkzWnFOLUV1dGVSTGxMX2NPbTFWWHh4TjZlRnB5UkFaS2xtZVh5RXpRNlFnRlZr?oc=5","as_of":"2026-04-08T09:38:01.125988+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/CBMirAFBVV95cUxPZkpmeVI1cllFRllTNEF6N282eGtHSllzNWpxWEVjY1UyX2pRbVM4UXcwX29SYlk4dnJ5TnBwcTFwOW5nX0JCRzFkTldiUGktMmJnT2R2OW5NT2txUHRKOU8tTXktcDQ0clVOUUIwMDRPZ05nTVVPVlQ1eFZxSmkzWnFOLUV1dGVSTGxMX2NPbTFWWHh4TjZlRnB5UkFaS2xtZVh5RXpRNlFnRlZr?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_efcc5ce9478efae4","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:38:46.202632+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPZkpmeVI1cllFRllTNEF6N282eGtHSllzNWpxWEVjY1UyX2pRbVM4UXcwX29SYlk4dnJ5TnBwcTFwOW5nX0JCRzFkTldiUGktMmJnT2R2OW5NT2txUHRKOU8tTXktcDQ0clVOUUIwMDRPZ05nTVVPVlQ1eFZxSmkzWnFOLUV1dGVSTGxMX2NPbTFWWHh4TjZlRnB5UkFaS2xtZVh5RXpRNlFnRlZr?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"abc7chicago.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPZkpmeVI1cllFRllTNEF6N282eGtHSllzNWpxWEVjY1UyX2pRbVM4UXcwX29SYlk4dnJ5TnBwcTFwOW5nX0JCRzFkTldiUGktMmJnT2R2OW5NT2txUHRKOU8tTXktcDQ0clVOUUIwMDRPZ05nTVVPVlQ1eFZxSmkzWnFOLUV1dGVSTGxMX2NPbTFWWHh4TjZlRnB5UkFaS2xtZVh5RXpRNlFnRlZr?oc=5","source_event_id":"evt_c5a6d1590d9e","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"0d46e67e7351afbc","published_at":"2026-04-08T00:27:21+00:00","publisher_domain":"abc7chicago.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":["last year (relative; exact date not provided in the signal)"],"entities":[{"asset_class":"equity/none","name":"Steve \u201cMongo\u201d McMichael","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"none","name":"Chicago Bears","relevance":"team associated with the subject","symbol":"","type":"sports_team"},{"asset_class":"none","name":"ABC7 Chicago","relevance":"source of the headline signal","symbol":"","type":"media_outlet"}],"event_type":"other","information_gaps":["The cleaned article text provided is not actually the article content (it appears to be page styling/HTML boilerplate), so specific details from ABC7 beyond the headline cannot be verified here.","Whether ABC7 explicitly states \u201cstage 3\u201d CTE is not confirmed from the provided headline-only text.","The methodology/source of the CTE diagnosis (e.g., specific researchers/study) is not included in the provided signal content.","Exact date of death and date of diagnosis announcement are not specified in the provided text."],"key_facts":["Steve \u201cMongo\u201d McMichael is reported to have been diagnosed posthumously with CTE.","The diagnosis is described as being revealed after his death (he died last year per the provided source summary).","Some of the provided source summary indicates his family announced he had stage 3 CTE (uncertain whether ABC7 specifically states stage 3 or whether it comes from other outlets in the summary)."],"numeric_claims":[{"label":"CTE stage","value":"3 (reported in source summary; not confirmed as stated in ABC7 headline text)"}],"primary_claim":"Steve \u201cMongo\u201d McMichael was diagnosed posthumously with CTE (reported by ABC7 Chicago).","relevance_score":0.45,"sentiment":"negative","source_quality":"high","summary":"ABC7 Chicago reports that Steve \u201cMongo\u201d McMichael, a late Chicago Bears Hall of Famer, was diagnosed posthumously with chronic traumatic encephalopathy (CTE). The diagnosis is described as being revealed after his death and attributed to findings reported by researchers and/or his family.","topics":["CTE","sports concussion/brain injury","posthumous medical diagnosis","Chicago Bears","NFL legacy"]},"source":"ABC7 Chicago","source_domain":"abc7chicago.com","source_url":"https://abc7chicago.com","summary":"Chicago Bears legend Steve 'Mongo' McMichael diagnosed posthumously with CTE ABC7 Chicago Bears icon Steve McMichael diagnosed with CTE year after death ESPN Super Bowl champion Steve McMichael, who died last year, revealed to have CTE Fox News Steve McMichael\u2019s family announces that he had stage 3 CTE NBC Sports Steve McMichael, late Bears great and Hall of Famer, had CTE, researchers find - The Athletic The New York Times","title":"Chicago Bears legend Steve 'Mongo' McMichael diagnosed posthumously with CTE - ABC7 Chicago","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_1d7a87807605 in signals