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/CBMiWkFVX3lxTE05cVlxcm5JMHVoaUxtZHZEejljSGZJaGhMbVktUGQyaERzeUp2SmRhOFBoSEY5T2tEMkEwbGhQdXFlNjQxMXFLbDlUVEtlR1RhNXJFYmhBVmhtUQ?oc=5","as_of":"2026-04-10T13:08:04.511011+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/CBMiWkFVX3lxTE05cVlxcm5JMHVoaUxtZHZEejljSGZJaGhMbVktUGQyaERzeUp2SmRhOFBoSEY5T2tEMkEwbGhQdXFlNjQxMXFLbDlUVEtlR1RhNXJFYmhBVmhtUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_ad21944d247a0e6b","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-10T13:08:43.854898+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE05cVlxcm5JMHVoaUxtZHZEejljSGZJaGhMbVktUGQyaERzeUp2SmRhOFBoSEY5T2tEMkEwbGhQdXFlNjQxMXFLbDlUVEtlR1RhNXJFYmhBVmhtUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"bbc.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiWkFVX3lxTE05cVlxcm5JMHVoaUxtZHZEejljSGZJaGhMbVktUGQyaERzeUp2SmRhOFBoSEY5T2tEMkEwbGhQdXFlNjQxMXFLbDlUVEtlR1RhNXJFYmhBVmhtUQ?oc=5","source_event_id":"evt_531594650fe6","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"9725a58c878e3b50","published_at":"2026-04-10T11:19:39+00:00","publisher_domain":"bbc.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"other","name":"BAFTA","relevance":"high","symbol":"","type":"organization"},{"asset_class":"other","name":"BBC","relevance":"high","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"John Davidson","relevance":"high","symbol":"","type":"person"},{"asset_class":"other","name":"BAFTA Film Awards","relevance":"medium","symbol":"","type":"event"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only HTML/CSS and does not include the actual BBC narrative content; extraction is therefore based on the headline and the provided source summary rather than the full article body.","Specific details of what BAFTA\u2019s duty-of-care failure consisted of (e.g., exact procedural lapse) are not present in the provided text.","No timing/catalyst window is specified in the provided headline/summary (e.g., when the review was completed or when changes will be implemented).","The exact wording of the review\u2019s conclusions (beyond phrases quoted in the source summary) is not verifiable from the provided article text."],"key_facts":["BBC headline states a review found BAFTA fell short in its duty of care when a racial slur was shouted.","The incident is described as occurring during John Davidson\u2019s Tourette\u2019s outburst.","The review reportedly found \u201cstructural weaknesses\u201d in BAFTA\u2019s awards planning and crisis procedures.","The review reportedly found no \u201cmalicious intent.\u201d","BAFTA is reported (in the provided source summary) to have apologized \u201cunreservedly\u201d to Black and disabled communities."],"numeric_claims":[],"primary_claim":"A review found BAFTA failed in its duty of care when a racial slur was shouted during John Davidson\u2019s Tourette\u2019s outburst, and it cited structural weaknesses in awards planning/crisis procedures without finding malicious intent.","relevance_score":0.42,"sentiment":"negative","source_quality":"high","summary":"A BBC report says a review found BAFTA fell short of its duty of care after a racial slur was shouted during John Davidson\u2019s Tourette\u2019s outburst at the BAFTA Film Awards. The review reportedly identified structural weaknesses in BAFTA\u2019s planning and crisis procedures, while stating there was no malicious intent.","topics":["duty of care","racial slur","Tourette\u2019s outburst","crisis procedures","awards planning","apology","structural weaknesses","review findings"]},"source":"BBC","source_domain":"bbc.com","source_url":"https://www.bbc.com","summary":"Bafta fell short in duty of care when racial slur was shouted, review finds BBC Bafta apologises for events surrounding John Davidson\u2019s Tourette\u2019s outburst The Guardian BBC upholds complaints over racial slur in Baftas broadcast BBC BAFTA Apologizes \u201cUnreservedly\u201d To Black & Disabled Communities For Racial Slur Debacle After Review Finds \u201cNumber Of Structural Weaknesses\u201d In Its Awards Planning Deadline BAFTA Film Awards Review of Tourette\u2019s Fiasco Finds \u201cWeaknesses\u201d in Planning and Crisis Procedures, But No \u201cMalicious Intent\u201d The Hollywood Reporter","title":"Bafta fell short in duty of care when racial slur was shouted, review finds - BBC","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_59dbb8778816 in signals