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/CBMirwFBVV95cUxNZHNVeWRhRGpwbFNKbno2bnRVMUdPcUlsNl85MkE4dWRlakJqUUlLOEhEaUFlWTk2RVRvZDNOcjcxMGdvRTRTOGlxZmxlV0JXQ3pYaVVCeDZDQkJyYTYzaG9mM2VoTVVpMGNHRVVmNkZIdGQxTGFBeFJvN1F4OFNKeDMxZy1VZFVQRUphZElzbkt6YnFjcHNBTVNESnRhUjVycHpZQ2xjUDZvVUZXOEJj?oc=5","as_of":"2026-04-09T11:22:55.169652+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/CBMirwFBVV95cUxNZHNVeWRhRGpwbFNKbno2bnRVMUdPcUlsNl85MkE4dWRlakJqUUlLOEhEaUFlWTk2RVRvZDNOcjcxMGdvRTRTOGlxZmxlV0JXQ3pYaVVCeDZDQkJyYTYzaG9mM2VoTVVpMGNHRVVmNkZIdGQxTGFBeFJvN1F4OFNKeDMxZy1VZFVQRUphZElzbkt6YnFjcHNBTVNESnRhUjVycHpZQ2xjUDZvVUZXOEJj?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3cc8162ce3a64b31","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-09T23:15:21.727026+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNZHNVeWRhRGpwbFNKbno2bnRVMUdPcUlsNl85MkE4dWRlakJqUUlLOEhEaUFlWTk2RVRvZDNOcjcxMGdvRTRTOGlxZmxlV0JXQ3pYaVVCeDZDQkJyYTYzaG9mM2VoTVVpMGNHRVVmNkZIdGQxTGFBeFJvN1F4OFNKeDMxZy1VZFVQRUphZElzbkt6YnFjcHNBTVNESnRhUjVycHpZQ2xjUDZvVUZXOEJj?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"reuters.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMirwFBVV95cUxNZHNVeWRhRGpwbFNKbno2bnRVMUdPcUlsNl85MkE4dWRlakJqUUlLOEhEaUFlWTk2RVRvZDNOcjcxMGdvRTRTOGlxZmxlV0JXQ3pYaVVCeDZDQkJyYTYzaG9mM2VoTVVpMGNHRVVmNkZIdGQxTGFBeFJvN1F4OFNKeDMxZy1VZFVQRUphZElzbkt6YnFjcHNBTVNESnRhUjVycHpZQ2xjUDZvVUZXOEJj?oc=5","source_event_id":"evt_268980104013","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"3b18407fb8cb90c7","published_at":"2026-04-09T07:48:38+00:00","publisher_domain":"reuters.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.74,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Spain","relevance":"directly affected by the action (condemnation and embassy reopening)","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Israel","relevance":"subject of Spain\u2019s condemnation (attacks on Lebanon)","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"targeted by the condemned Israeli attacks","symbol":"","type":"country"},{"asset_class":"geography","name":"Tehran","relevance":"location of Spain\u2019s reopened embassy","symbol":"","type":"city"},{"asset_class":"sovereign","name":"Iran","relevance":"Spain\u2019s embassy reopening is in Tehran (Iran)","symbol":"","type":"country"},{"asset_class":"media","name":"Reuters","relevance":"source of the headline claim","symbol":"","type":"news_agency"}],"event_type":"geopolitical_risk","information_gaps":["The exact date Spain reopened the Tehran embassy is not provided in the supplied text.","The specific wording/official channel of Spain\u2019s condemnation (e.g., ministry statement, UN forum) is not provided.","Whether Spain\u2019s embassy reopening is fully operational or symbolic is not specified.","The Reuters article\u2019s details on how this affects the US\u2013Iran ceasefire are not included in the provided excerpt; only a contextual claim is mentioned in the multi-source summary.","No direct market/financial impact details are present in the provided text."],"key_facts":["Reuters headline indicates Spain condemned Israeli attacks on Lebanon.","Reuters headline indicates Spain reopened its embassy in Tehran.","The provided source summary includes additional context that Israel\u2019s attacks on Lebanon could cripple a US\u2013Iran ceasefire (contextual, not fully detailed in the Reuters headline itself)."],"numeric_claims":[],"primary_claim":"Spain condemned Israeli attacks on Lebanon and reopened its embassy in Tehran, Reuters reported.","relevance_score":0.72,"sentiment":"mixed","source_quality":"high","summary":"Spain condemned Israeli attacks on Lebanon and reopened its embassy in Tehran, according to Reuters. The move signals heightened European diplomatic engagement amid escalating Israel\u2013Lebanon conflict and US\u2013Iran ceasefire concerns.","topics":["Spain foreign policy","Israel-Lebanon conflict","Iran diplomatic relations","embassy reopening","European diplomatic response","US-Iran ceasefire risk (context mentioned in provided summaries)"]},"source":"Reuters","source_domain":"reuters.com","source_url":"https://www.reuters.com","summary":"Spain condemns Israeli attacks on Lebanon, reopens Tehran embassy Reuters Why Israel\u2019s attacks on Lebanon could cripple US-Iran ceasefire Al Jazeera Israeli military says it has killed nephew of Hezbollah chief Naim Qassem Reuters 'Such carnage defies belief': Lebanon, crushed by Israeli bombs, counts its dead Le Monde.fr Lebanon Mourns After Israeli Barrage Kills More Than 200 People The New York Times","title":"Spain condemns Israeli attacks on Lebanon, reopens Tehran embassy - Reuters","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_eeb65482c1d0 in signals