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/CBMimAFBVV95cUxOb0pXMTBYSEFsZzhoUERCLV9RZjRSdldxMU9lR0NSUkkwTk8wN3o0NHZhVTY3QW1xMWhXbWpFaVhtOGxxUVhFcTdyMC16YWxEcVdVOFdBQ0NZQ045Uk9RNmY3cm5XVXBWS0RaX0JhOHA0YVZMT25BMk9jd1VLUGV3MUtCXzRsNDc1RkRjMTQ1eTU2c3lMd1JocQ?oc=5","as_of":"2026-04-06T23:19:11.826449+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/CBMimAFBVV95cUxOb0pXMTBYSEFsZzhoUERCLV9RZjRSdldxMU9lR0NSUkkwTk8wN3o0NHZhVTY3QW1xMWhXbWpFaVhtOGxxUVhFcTdyMC16YWxEcVdVOFdBQ0NZQ045Uk9RNmY3cm5XVXBWS0RaX0JhOHA0YVZMT25BMk9jd1VLUGV3MUtCXzRsNDc1RkRjMTQ1eTU2c3lMd1JocQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_c57b206a2ed4019f","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-07T13:22:41.227602+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxOb0pXMTBYSEFsZzhoUERCLV9RZjRSdldxMU9lR0NSUkkwTk8wN3o0NHZhVTY3QW1xMWhXbWpFaVhtOGxxUVhFcTdyMC16YWxEcVdVOFdBQ0NZQ045Uk9RNmY3cm5XVXBWS0RaX0JhOHA0YVZMT25BMk9jd1VLUGV3MUtCXzRsNDc1RkRjMTQ1eTU2c3lMd1JocQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"apnews.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimAFBVV95cUxOb0pXMTBYSEFsZzhoUERCLV9RZjRSdldxMU9lR0NSUkkwTk8wN3o0NHZhVTY3QW1xMWhXbWpFaVhtOGxxUVhFcTdyMC16YWxEcVdVOFdBQ0NZQ045Uk9RNmY3cm5XVXBWS0RaX0JhOHA0YVZMT25BMk9jd1VLUGV3MUtCXzRsNDc1RkRjMTQ1eTU2c3lMd1JocQ?oc=5","source_event_id":"evt_35ccc835e5ff","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"65b409a4595be197","published_at":"2026-04-06T21:38:00+00:00","publisher_domain":"apnews.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.9,"dates_mentioned":[],"entities":[{"asset_class":"politics","name":"Trump","relevance":"high","symbol":"N/A","type":"person"},{"asset_class":"geopolitical","name":"Iran","relevance":"high","symbol":"N/A","type":"country"}],"event_type":"geopolitical_risk","information_gaps":["Details on the specific aircraft used in the rescue are not provided.","The exact timing of the rescue operation is unclear."],"key_facts":["The rescue operation involved dozens of aircraft.","Trump threatened to jail reporters for not revealing sources related to the Iran airman rescue."],"numeric_claims":[],"primary_claim":"The rescue operation for the US crew downed in Iran relied on dozens of aircraft and subterfuge, according to Trump.","relevance_score":0.8,"sentiment":"negative","source_quality":"high","summary":"Trump revealed that a risky rescue operation for a US crew downed in Iran involved extensive use of aircraft and subterfuge.","topics":["US-Iran relations","military operations","Trump administration"]},"source":"AP News","source_domain":"apnews.com","source_url":"https://apnews.com","summary":"Risky rescue of US crew downed in Iran relied on dozens of aircraft and subterfuge, Trump says AP News Trump threatens to jail reporters if they don\u2019t turn over Iran source The Washington Post Trump threatens jail for reporter who revealed Iran airman rescue KSL News When is Trump speaking today? Here's what time to watch news conference The News Journal Trump threatens to jail journalists in hunt to find leaker of Iran fighter jet story NBC News","title":"Risky rescue of US crew downed in Iran relied on dozens of aircraft and subterfuge, Trump says - AP News","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_07198d7a576c in signals