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-08T06:36:01.363864+00:00","dedupe_key":"signal_enriched:news_delta:ce69310cb69867f6","evidence_event_ids":["evt_3ee0ce85261d"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPZkpmeVI1cllFRllTNEF6N282eGtHSllzNWpxWEVjY1UyX2pRbVM4UXcwX29SYlk4dnJ5TnBwcTFwOW5nX0JCRzFkTldiUGktMmJnT2R2OW5NT2txUHRKOU8tTXktcDQ0clVOUUIwMDRPZ05nTVVPVlQ1eFZxSmkzWnFOLUV1dGVSTGxMX2NPbTFWWHh4TjZlRnB5UkFaS2xtZVh5RXpRNlFnRlZr0gGyAUFVX3lxTE5ZRXI5ZHRwNFoxdExmYTNyZHNJZk5LeWpBTENmeGNCM3REUGFxZHQxRHBjVDFpY21mRTU2Rm03WFMzaVFCYnNZM2c5c2R2ci00YmJ5a2RnRDFkcEZLdG0xSjJSSExDRXhrb1pUUlJ4ZXY5OG43cnBxb3hvVGhaLTZWbnNxR2VEY0IyRmZTRUI5MXl0S3NXeXhEVEFENEF3WHBfZjhNQmxpR1VuUFdjNTAzcHc?oc=5","as_of":"2026-04-08T06:36:01.363864+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/CBMirAFBVV95cUxPZkpmeVI1cllFRllTNEF6N282eGtHSllzNWpxWEVjY1UyX2pRbVM4UXcwX29SYlk4dnJ5TnBwcTFwOW5nX0JCRzFkTldiUGktMmJnT2R2OW5NT2txUHRKOU8tTXktcDQ0clVOUUIwMDRPZ05nTVVPVlQ1eFZxSmkzWnFOLUV1dGVSTGxMX2NPbTFWWHh4TjZlRnB5UkFaS2xtZVh5RXpRNlFnRlZr0gGyAUFVX3lxTE5ZRXI5ZHRwNFoxdExmYTNyZHNJZk5LeWpBTENmeGNCM3REUGFxZHQxRHBjVDFpY21mRTU2Rm03WFMzaVFCYnNZM2c5c2R2ci00YmJ5a2RnRDFkcEZLdG0xSjJSSExDRXhrb1pUUlJ4ZXY5OG43cnBxb3hvVGhaLTZWbnNxR2VEY0IyRmZTRUI5MXl0S3NXeXhEVEFENEF3WHBfZjhNQmxpR1VuUFdjNTAzcHc?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_804b68bee74aa9ac","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-08T06:36:37.793233+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPZkpmeVI1cllFRllTNEF6N282eGtHSllzNWpxWEVjY1UyX2pRbVM4UXcwX29SYlk4dnJ5TnBwcTFwOW5nX0JCRzFkTldiUGktMmJnT2R2OW5NT2txUHRKOU8tTXktcDQ0clVOUUIwMDRPZ05nTVVPVlQ1eFZxSmkzWnFOLUV1dGVSTGxMX2NPbTFWWHh4TjZlRnB5UkFaS2xtZVh5RXpRNlFnRlZr0gGyAUFVX3lxTE5ZRXI5ZHRwNFoxdExmYTNyZHNJZk5LeWpBTENmeGNCM3REUGFxZHQxRHBjVDFpY21mRTU2Rm03WFMzaVFCYnNZM2c5c2R2ci00YmJ5a2RnRDFkcEZLdG0xSjJSSExDRXhrb1pUUlJ4ZXY5OG43cnBxb3hvVGhaLTZWbnNxR2VEY0IyRmZTRUI5MXl0S3NXeXhEVEFENEF3WHBfZjhNQmxpR1VuUFdjNTAzcHc?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/CBMirAFBVV95cUxPZkpmeVI1cllFRllTNEF6N282eGtHSllzNWpxWEVjY1UyX2pRbVM4UXcwX29SYlk4dnJ5TnBwcTFwOW5nX0JCRzFkTldiUGktMmJnT2R2OW5NT2txUHRKOU8tTXktcDQ0clVOUUIwMDRPZ05nTVVPVlQ1eFZxSmkzWnFOLUV1dGVSTGxMX2NPbTFWWHh4TjZlRnB5UkFaS2xtZVh5RXpRNlFnRlZr0gGyAUFVX3lxTE5ZRXI5ZHRwNFoxdExmYTNyZHNJZk5LeWpBTENmeGNCM3REUGFxZHQxRHBjVDFpY21mRTU2Rm03WFMzaVFCYnNZM2c5c2R2ci00YmJ5a2RnRDFkcEZLdG0xSjJSSExDRXhrb1pUUlJ4ZXY5OG43cnBxb3hvVGhaLTZWbnNxR2VEY0IyRmZTRUI5MXl0S3NXeXhEVEFENEF3WHBfZjhNQmxpR1VuUFdjNTAzcHc?oc=5","source_event_id":"evt_3ee0ce85261d","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6bb0d9ba4da6b3a6","published_at":"2026-04-08T00:27:21+00:00","publisher_domain":"abc7chicago.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"Steve \u201cMongo\u201d McMichael","relevance":"primary","symbol":"","type":"person"},{"asset_class":"equity","name":"Chicago Bears","relevance":"secondary","symbol":"CHI","type":"sports_team"},{"asset_class":"other","name":"ALS","relevance":"secondary","symbol":"","type":"medical_condition"},{"asset_class":"other","name":"CTE","relevance":"secondary","symbol":"","type":"medical_condition"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only page styling/HTML and does not include the actual article body; extraction is therefore based on the provided headline and source summary rather than the full article content.","The exact date of death and the date of the posthumous diagnosis announcement are not present in the provided text.","The specific evidence/method used for the CTE diagnosis (e.g., neuropathology details) is not included in the provided material."],"key_facts":["Steve \u201cMongo\u201d McMichael was diagnosed posthumously with CTE.","The diagnosis is described as stage 3 CTE (per the provided source summary).","McMichael died from complications related to ALS.","The report is attributed to abc7chicago.com."],"numeric_claims":[{"label":"CTE stage","value":"3"}],"primary_claim":"Steve \u201cMongo\u201d McMichael received a posthumous diagnosis of stage 3 CTE after dying of complications from ALS.","relevance_score":0.42,"sentiment":"negative","source_quality":"high","summary":"Chicago Bears legend Steve \u201cMongo\u201d McMichael was diagnosed posthumously with stage 3 CTE, according to his family, after he died from complications related to ALS.","topics":["posthumous medical diagnosis","CTE","ALS","NFL legacy","sports health research"]},"source":"abc7chicago.com","source_domain":"abc7chicago.com","source_url":"https://abc7chicago.com","summary":"Chicago Bears legend Steve 'Mongo' McMichael diagnosed posthumously with CTE after dying of complications from ALS abc7chicago.com 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 Chicago Bears HoFer Steve McMichael diagnosed with CTE year after death Yahoo Sports Steve McMichael\u2019s family announces that he had stage 3 CTE NBC Sports","title":"Chicago Bears legend Steve 'Mongo' McMichael diagnosed posthumously with CTE after dying of complications from ALS - abc7chicago.com","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 5062 in events