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/CBMikgFBVV95cUxNVWViNFBvMnRPMjFwY3huUVpud01XR1pldzdSeDVBQVFRM0pGMk5jMkJPOGpESkJ5SGl3V29PX3pIMGhmWjRjV0hGXzVUMHFWdXJ0RnBpX01SN2JZZk95SlZ0eXhILTFUV2ZqY08tQmtlWS1oQkU4MURhcTVDanpSeUxlUVVtQ1FIX0F4ejJTTHBGZw?oc=5","as_of":"2026-04-10T17:15:05.619769+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/CBMikgFBVV95cUxNVWViNFBvMnRPMjFwY3huUVpud01XR1pldzdSeDVBQVFRM0pGMk5jMkJPOGpESkJ5SGl3V29PX3pIMGhmWjRjV0hGXzVUMHFWdXJ0RnBpX01SN2JZZk95SlZ0eXhILTFUV2ZqY08tQmtlWS1oQkU4MURhcTVDanpSeUxlUVVtQ1FIX0F4ejJTTHBGZw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_2816706754d927ea","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-10T17:17:36.894595+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxNVWViNFBvMnRPMjFwY3huUVpud01XR1pldzdSeDVBQVFRM0pGMk5jMkJPOGpESkJ5SGl3V29PX3pIMGhmWjRjV0hGXzVUMHFWdXJ0RnBpX01SN2JZZk95SlZ0eXhILTFUV2ZqY08tQmtlWS1oQkU4MURhcTVDanpSeUxlUVVtQ1FIX0F4ejJTTHBGZw?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikgFBVV95cUxNVWViNFBvMnRPMjFwY3huUVpud01XR1pldzdSeDVBQVFRM0pGMk5jMkJPOGpESkJ5SGl3V29PX3pIMGhmWjRjV0hGXzVUMHFWdXJ0RnBpX01SN2JZZk95SlZ0eXhILTFUV2ZqY08tQmtlWS1oQkU4MURhcTVDanpSeUxlUVVtQ1FIX0F4ejJTTHBGZw?oc=5","source_event_id":"evt_d72389c6a911","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"6a89012b9ffcd766","published_at":"2026-04-10T16:10:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"person","name":"Melania Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"person","name":"Jeffrey Epstein","relevance":"high","symbol":"","type":"person"},{"asset_class":"group","name":"Survivors of Epstein\u2019s abuse","relevance":"high","symbol":"","type":"group"},{"asset_class":"media","name":"The Guardian","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is not the actual Guardian article content (it appears to be page styling/boilerplate), so details of the accusation, quotes, and context are not verifiable from the supplied text.","No specific date, location, or direct quote beyond the phrase \u201cshifting burden\u201d is included in the provided material.","The signal includes multiple other headlines/outlets in the source summary, but their specific claims are not provided in full, so they cannot be grounded beyond their mention."],"key_facts":["The Guardian headline states that survivors of Epstein\u2019s abuse accuse Melania Trump of \u201cshifting burden\u201d onto victims.","The provided source summary also references other outlets discussing Melania Trump\u2019s handling/response to the Epstein saga (e.g., CNN, New York Times, Variety, Fortune), but the only concrete, grounded claim in the provided text is the Guardian headline framing."],"numeric_claims":[],"primary_claim":"Survivors of Epstein\u2019s abuse accuse Melania Trump of \u201cshifting burden\u201d onto victims, according to The Guardian.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"The Guardian reports that survivors of Jeffrey Epstein\u2019s abuse accuse Melania Trump of \u201cshifting burden\u201d onto victims in relation to the Epstein saga. The dispute is framed as a public-relations/response issue that could keep the Epstein topic in the news near term.","topics":["Epstein abuse allegations","Melania Trump","victim blame","public statements","media coverage"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Survivors of Epstein\u2019s abuse accuse Melania Trump of \u2018shifting burden\u2019 onto victims The Guardian Jimmy Kimmel Salutes Melania\u2019s White House Surprise The New York Times Melania Trump tried to sweep the Epstein saga away, but she ended up reviving it CNN Jimmy Kimmel Calls Out Melania Trump and Jeffrey Epstein Photo variety.com Melania Trump in unusual White House statement: 'the lies linking me with the disgraceful Jeffrey Epstein need to end today' Fortune","title":"Survivors of Epstein\u2019s abuse accuse Melania Trump of \u2018shifting burden\u2019 onto victims - The Guardian","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_cb5e47bd08cf in signals