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/CBMigwFBVV95cUxQU29Zenp0OFJ6NjlZcGJkblIxS09wQ0k5VVhWOHo4ZC1aVVFTRW1zMWtXNEhMVF9udVMtdFZxTURLVE5WZlFERWwtTXBwOC1oRnE5cU5KSTRRWXJGcWhRYjU0MVo1NHVJOUYxU0h4N1k5eG03X0JGd2Q5UHB2Qmp0TkRrTQ?oc=5","as_of":"2026-04-09T06:04:20.736017+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/CBMigwFBVV95cUxQU29Zenp0OFJ6NjlZcGJkblIxS09wQ0k5VVhWOHo4ZC1aVVFTRW1zMWtXNEhMVF9udVMtdFZxTURLVE5WZlFERWwtTXBwOC1oRnE5cU5KSTRRWXJGcWhRYjU0MVo1NHVJOUYxU0h4N1k5eG03X0JGd2Q5UHB2Qmp0TkRrTQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c08039bf8ab636bb","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-09T22:44:49.274143+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxQU29Zenp0OFJ6NjlZcGJkblIxS09wQ0k5VVhWOHo4ZC1aVVFTRW1zMWtXNEhMVF9udVMtdFZxTURLVE5WZlFERWwtTXBwOC1oRnE5cU5KSTRRWXJGcWhRYjU0MVo1NHVJOUYxU0h4N1k5eG03X0JGd2Q5UHB2Qmp0TkRrTQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"ew.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMigwFBVV95cUxQU29Zenp0OFJ6NjlZcGJkblIxS09wQ0k5VVhWOHo4ZC1aVVFTRW1zMWtXNEhMVF9udVMtdFZxTURLVE5WZlFERWwtTXBwOC1oRnE5cU5KSTRRWXJGcWhRYjU0MVo1NHVJOUYxU0h4N1k5eG03X0JGd2Q5UHB2Qmp0TkRrTQ?oc=5","source_event_id":"evt_4ae72894be7a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"1bb4f7c047e99b95","published_at":"2026-04-09T02:24:31+00:00","publisher_domain":"ew.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"person","name":"Michael Patrick","relevance":"primary subject","symbol":"","type":"person"},{"asset_class":"media","name":"Entertainment Weekly","relevance":"source of headline","symbol":"","type":"publisher"},{"asset_class":"media","name":"RTE.ie","relevance":"additional outlet cited in source summary","symbol":"","type":"publisher"},{"asset_class":"media","name":"BBC","relevance":"additional outlet cited in source summary","symbol":"","type":"publisher"},{"asset_class":"media","name":"People.com","relevance":"additional outlet cited in source summary","symbol":"","type":"publisher"},{"asset_class":"media","name":"10tv.com","relevance":"additional outlet cited in source summary","symbol":"","type":"publisher"},{"asset_class":"entertainment","name":"Game of Thrones","relevance":"noted for actor\u2019s role/association","symbol":"","type":"work"},{"asset_class":"entertainment","name":"Krypton","relevance":"noted for actor\u2019s role/association","symbol":"","type":"work"},{"asset_class":"entertainment","name":"Richard III","relevance":"role mentioned in source summary","symbol":"","type":"work"},{"asset_class":"health","name":"MND","relevance":"condition referenced in source summary","symbol":"","type":"medical_condition"}],"event_type":"other","information_gaps":["The cleaned article text provided appears to be mostly unrelated page markup; specific details (e.g., date/time of death, cause of death, exact role names in Game of Thrones) are not present in the provided text.","The exact Game of Thrones character/episode(s) are not specified in the provided headline/summary.","The specific MND-related details (diagnosis timing, severity, statements from family/representatives) are not included in the provided content.","No explicit publication date is included in the provided material."],"key_facts":["Michael Patrick is described as an Irish actor known for Shakespeare roles and for Game of Thrones.","He died at age 35 (as stated in the headline and repeated in the provided source summary).","The provided source summary indicates tributes and references that he had MND.","The provided source summary also states he played Richard III in a wheelchair."],"numeric_claims":[{"label":"age_at_death","value":"35"}],"primary_claim":"Michael Patrick, an Irish actor known for Shakespeare roles and Game of Thrones, died at age 35.","relevance_score":0.35,"sentiment":"negative","source_quality":"high","summary":"Entertainment Weekly reports that Irish actor Michael Patrick, known for Shakespeare roles and appearances in Game of Thrones, has died at age 35. Multiple outlets cited in the provided source summary also reference tributes and his diagnosis with MND.","topics":["celebrity death","Irish actor","Game of Thrones","Krypton","MND","tributes"]},"source":"Entertainment Weekly","source_domain":"ew.com","source_url":"https://ew.com","summary":"Michael Patrick, Irish actor known for Shakespeare roles and Game of Thrones , dies at 35 Entertainment Weekly Death announced of actor Michael Patrick RTE.ie 'Titan of a man' - tributes to actor with MND who played Richard III in wheelchair BBC Michael Patrick, Irish actor with roles in 'Game of Thrones,' 'Krypton,' has died at 35 10tv.com 'Game of Thrones' Actor Michael Patrick Dies at 35 People.com","title":"Michael Patrick, Irish actor known for Shakespeare roles and Game of Thrones , dies at 35 - Entertainment Weekly","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_0b01820724c1 in signals