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/CBMif0FVX3lxTE95RHJlV0R4LU9sc29pd1dZSDZYb2RYS29BTUxZVUZtZzJFVThKVjRPVllOWmNTREFiMlN2c05uN1Jka0tkbGZJc1ZqSGlTRnlvSU9DNkpMbDFKSVlkbk1jVXI3eVNSWTZPWk52YUJ0bFg1c3V0aktJWWxlZGFWSmM?oc=5","as_of":"2026-04-07T04:04:22.157934+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/CBMif0FVX3lxTE95RHJlV0R4LU9sc29pd1dZSDZYb2RYS29BTUxZVUZtZzJFVThKVjRPVllOWmNTREFiMlN2c05uN1Jka0tkbGZJc1ZqSGlTRnlvSU9DNkpMbDFKSVlkbk1jVXI3eVNSWTZPWk52YUJ0bFg1c3V0aktJWWxlZGFWSmM?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9fc32e15ba479ee4","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-07T17:20:58.953897+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE95RHJlV0R4LU9sc29pd1dZSDZYb2RYS29BTUxZVUZtZzJFVThKVjRPVllOWmNTREFiMlN2c05uN1Jka0tkbGZJc1ZqSGlTRnlvSU9DNkpMbDFKSVlkbk1jVXI3eVNSWTZPWk52YUJ0bFg1c3V0aktJWWxlZGFWSmM?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nytimes.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMif0FVX3lxTE95RHJlV0R4LU9sc29pd1dZSDZYb2RYS29BTUxZVUZtZzJFVThKVjRPVllOWmNTREFiMlN2c05uN1Jka0tkbGZJc1ZqSGlTRnlvSU9DNkpMbDFKSVlkbk1jVXI3eVNSWTZPWk52YUJ0bFg1c3V0aktJWWxlZGFWSmM?oc=5","source_event_id":"evt_aa40e33d1b26","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"a66587c643521fe8","published_at":"2026-04-06T23:38:58+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"military","name":"U.S. Airman","relevance":"directly involved in the rescue","symbol":"N/A","type":"person"},{"asset_class":"media","name":"Hegseth","relevance":"commentator making the comparison","symbol":"N/A","type":"person"}],"event_type":"other","information_gaps":["Details on the specific circumstances of the airman's rescue are not provided.","The broader implications of Hegseth's comparison are unclear."],"key_facts":["Two planes were destroyed by the U.S. during the rescue operation.","The U.S. set up an airfield inside Iran for the rescue.","The injured airman used a Boeing device to signal rescuers."],"numeric_claims":[],"primary_claim":"Hegseth likens the rescue of a U.S. airman to the resurrection of Jesus Christ.","relevance_score":0.7,"sentiment":"neutral","source_quality":"high","summary":"Hegseth draws a parallel between the Easter rescue of a U.S. airman and the resurrection of Jesus Christ, highlighting the significance of the event.","topics":["military rescue","religious symbolism","media commentary"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Hegseth Likens Easter Rescue of U.S. Airman to Resurrection of Jesus Christ The New York Times Two Planes Destroyed by U.S. During Rescue Operation WSJ Trump seizes on rescue of downed airman to recast unpopular Iran war Reuters The US set up an airfield inside Iran to rescue the F-15 airman. Marines just practiced building one Fortune Injured US Airman in Iran Used Boeing Device to Signal Rescuers Bloomberg.com","title":"Hegseth Likens Easter Rescue of U.S. Airman to Resurrection of Jesus Christ - The New York Times","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_7cf890fbcb8a in signals