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/CBMiwgFBVV95cUxPSVhXMS1LM2FUeEpLdHZBNzNKU2pxOHZxZ3FIOFJiZE8yLTdMX0c0WkJ5Um1nV1FsMUxJWlB6cjNBM3kxZ24wS2c2Q1RpWUFYbkFRb21LZ2hRQUwyN0gyeHZqZ0RBSDA2ZlR4SmJvazA5TXRtckUxWC1Wejg3N0pfWnV1MHFxRjRNX1VYM2NaaUFtbWtBX01LNmRKWmJxSHlDd1ZLQXQxeENSNnlUU0QyR29qc0sxU0VScnJzSTdscExZdw?oc=5","as_of":"2026-04-10T16:36:01.660861+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/CBMiwgFBVV95cUxPSVhXMS1LM2FUeEpLdHZBNzNKU2pxOHZxZ3FIOFJiZE8yLTdMX0c0WkJ5Um1nV1FsMUxJWlB6cjNBM3kxZ24wS2c2Q1RpWUFYbkFRb21LZ2hRQUwyN0gyeHZqZ0RBSDA2ZlR4SmJvazA5TXRtckUxWC1Wejg3N0pfWnV1MHFxRjRNX1VYM2NaaUFtbWtBX01LNmRKWmJxSHlDd1ZLQXQxeENSNnlUU0QyR29qc0sxU0VScnJzSTdscExZdw?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_212780c16792a73a","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:16:56.642641+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiwgFBVV95cUxPSVhXMS1LM2FUeEpLdHZBNzNKU2pxOHZxZ3FIOFJiZE8yLTdMX0c0WkJ5Um1nV1FsMUxJWlB6cjNBM3kxZ24wS2c2Q1RpWUFYbkFRb21LZ2hRQUwyN0gyeHZqZ0RBSDA2ZlR4SmJvazA5TXRtckUxWC1Wejg3N0pfWnV1MHFxRjRNX1VYM2NaaUFtbWtBX01LNmRKWmJxSHlDd1ZLQXQxeENSNnlUU0QyR29qc0sxU0VScnJzSTdscExZdw?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/CBMiwgFBVV95cUxPSVhXMS1LM2FUeEpLdHZBNzNKU2pxOHZxZ3FIOFJiZE8yLTdMX0c0WkJ5Um1nV1FsMUxJWlB6cjNBM3kxZ24wS2c2Q1RpWUFYbkFRb21LZ2hRQUwyN0gyeHZqZ0RBSDA2ZlR4SmJvazA5TXRtckUxWC1Wejg3N0pfWnV1MHFxRjRNX1VYM2NaaUFtbWtBX01LNmRKWmJxSHlDd1ZLQXQxeENSNnlUU0QyR29qc0sxU0VScnJzSTdscExZdw?oc=5","source_event_id":"evt_973a3e2d2726","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"5d9b2304ca70d367","published_at":"2026-04-10T10:23:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.66,"dates_mentioned":[],"entities":[{"asset_class":"equity/none","name":"Melania Trump","relevance":"high","symbol":"","type":"person"},{"asset_class":"none","name":"Epstein survivors","relevance":"high","symbol":"","type":"group"},{"asset_class":"media","name":"The Guardian","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"CNN","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"none","name":"Jimmy Kimmel","relevance":"low","symbol":"","type":"person"},{"asset_class":"media","name":"New York Times","relevance":"low","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["The cleaned article text provided is not usable for extracting specific quotes or the exact content of Melania Trump\u2019s statement (only headline-level context is available).","No date/time of the statement or the survivors\u2019 specific remarks is included in the provided text.","The precise mechanism of how the statement \u2018shifts burden\u2019 is not detailed in the provided material."],"key_facts":["The Guardian reports that Epstein survivors criticized Melania Trump after a surprise statement.","The criticism includes an allegation that Melania Trump was \u2018shifting burden\u2019 onto victims.","The coverage characterizes Melania Trump\u2019s handling/denial as reviving or refocusing attention on the Epstein saga."],"numeric_claims":[],"primary_claim":"Epstein survivors accused Melania Trump of \u2018shifting burden\u2019 onto victims after her surprise statement about the Epstein saga.","relevance_score":0.62,"sentiment":"negative","source_quality":"high","summary":"Epstein abuse survivors criticized Melania Trump following a surprise statement, arguing it effectively shifts attention or burden onto victims rather than addressing the underlying allegations. The development is framed as reviving focus on the Epstein saga within US politics.","topics":["Epstein scandal","US politics","survivor advocacy","Melania Trump","public statements","media coverage"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Epstein survivors criticise Melania Trump after surprise statement \u2013 US politics live The Guardian Melania Trump tried to sweep the Epstein saga away, but she ended up reviving it CNN 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 Opinion | Melania Trump\u2019s Epstein denial centers attention on the scandal \u2014 and her MS NOW","title":"Epstein survivors criticise Melania Trump after surprise statement \u2013 US politics live - 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_5143e1459cc8 in signals