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/CBMiywFBVV95cUxObTIzS25Wam51TTVwajk4Mko5MkFSbEhEUDd5UW9yaGdsUGRIYkZkQTVHTlJBR1g4Y3RUN1o4ZEd5NDl4TkpjbVFDXzlZUXdFNm9FNGpZZTVVenhMSElnejNOeUtSYmpYb1RJRjNqWGYtRHgtbjctWXB0S1BvOUVqaGdPZ005cloyUnMyTlJXcFJxYlJnUFdWOWtSeUtIRV9NekdDQnNDd3BsZDFsX19saFdxVU5YaFVOWkRNM1d1UE9YUFZZY3dlTkNOQdIB0AFBVV95cUxPUzllQzMyQnhZQkc5QW5Qdnd2QUtkX2JxWUstYW15UDBfc1ZDTVctZWMwM3BJcWFWSFRyd1M5cTg2SjFxcUR6THBvLWppQ3h2c0t5c09oRE1xVmFwY0FhU2hLUElYSFpkNTJGWG1GTEtGTTRZc3R5dWZuU0M0aVVWeFdhdElJS19nUkNsVUpBVmdQSDV5S1BYV096Tk1Xb1pGeFM2S3p4Y1ZYSGYyYU1PeXB1X285QlRCU0o2NEtUM1JWVnR1VjRfeGFNNkxBeDh4?oc=5","as_of":"2026-04-10T12:07:33.031900+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/CBMiywFBVV95cUxObTIzS25Wam51TTVwajk4Mko5MkFSbEhEUDd5UW9yaGdsUGRIYkZkQTVHTlJBR1g4Y3RUN1o4ZEd5NDl4TkpjbVFDXzlZUXdFNm9FNGpZZTVVenhMSElnejNOeUtSYmpYb1RJRjNqWGYtRHgtbjctWXB0S1BvOUVqaGdPZ005cloyUnMyTlJXcFJxYlJnUFdWOWtSeUtIRV9NekdDQnNDd3BsZDFsX19saFdxVU5YaFVOWkRNM1d1UE9YUFZZY3dlTkNOQdIB0AFBVV95cUxPUzllQzMyQnhZQkc5QW5Qdnd2QUtkX2JxWUstYW15UDBfc1ZDTVctZWMwM3BJcWFWSFRyd1M5cTg2SjFxcUR6THBvLWppQ3h2c0t5c09oRE1xVmFwY0FhU2hLUElYSFpkNTJGWG1GTEtGTTRZc3R5dWZuU0M0aVVWeFdhdElJS19nUkNsVUpBVmdQSDV5S1BYV096Tk1Xb1pGeFM2S3p4Y1ZYSGYyYU1PeXB1X285QlRCU0o2NEtUM1JWVnR1VjRfeGFNNkxBeDh4?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_131bece7648e203a","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-10T12:08:49.761114+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiywFBVV95cUxObTIzS25Wam51TTVwajk4Mko5MkFSbEhEUDd5UW9yaGdsUGRIYkZkQTVHTlJBR1g4Y3RUN1o4ZEd5NDl4TkpjbVFDXzlZUXdFNm9FNGpZZTVVenhMSElnejNOeUtSYmpYb1RJRjNqWGYtRHgtbjctWXB0S1BvOUVqaGdPZ005cloyUnMyTlJXcFJxYlJnUFdWOWtSeUtIRV9NekdDQnNDd3BsZDFsX19saFdxVU5YaFVOWkRNM1d1UE9YUFZZY3dlTkNOQdIB0AFBVV95cUxPUzllQzMyQnhZQkc5QW5Qdnd2QUtkX2JxWUstYW15UDBfc1ZDTVctZWMwM3BJcWFWSFRyd1M5cTg2SjFxcUR6THBvLWppQ3h2c0t5c09oRE1xVmFwY0FhU2hLUElYSFpkNTJGWG1GTEtGTTRZc3R5dWZuU0M0aVVWeFdhdElJS19nUkNsVUpBVmdQSDV5S1BYV096Tk1Xb1pGeFM2S3p4Y1ZYSGYyYU1PeXB1X285QlRCU0o2NEtUM1JWVnR1VjRfeGFNNkxBeDh4?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"timesofisrael.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiywFBVV95cUxObTIzS25Wam51TTVwajk4Mko5MkFSbEhEUDd5UW9yaGdsUGRIYkZkQTVHTlJBR1g4Y3RUN1o4ZEd5NDl4TkpjbVFDXzlZUXdFNm9FNGpZZTVVenhMSElnejNOeUtSYmpYb1RJRjNqWGYtRHgtbjctWXB0S1BvOUVqaGdPZ005cloyUnMyTlJXcFJxYlJnUFdWOWtSeUtIRV9NekdDQnNDd3BsZDFsX19saFdxVU5YaFVOWkRNM1d1UE9YUFZZY3dlTkNOQdIB0AFBVV95cUxPUzllQzMyQnhZQkc5QW5Qdnd2QUtkX2JxWUstYW15UDBfc1ZDTVctZWMwM3BJcWFWSFRyd1M5cTg2SjFxcUR6THBvLWppQ3h2c0t5c09oRE1xVmFwY0FhU2hLUElYSFpkNTJGWG1GTEtGTTRZc3R5dWZuU0M0aVVWeFdhdElJS19nUkNsVUpBVmdQSDV5S1BYV096Tk1Xb1pGeFM2S3p4Y1ZYSGYyYU1PeXB1X285QlRCU0o2NEtUM1JWVnR1VjRfeGFNNkxBeDh4?oc=5","source_event_id":"evt_e60a979f8b84","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"f79b07146d87bff2","published_at":"2026-04-10T01:52:21+00:00","publisher_domain":"timesofisrael.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["Wednesday"],"entities":[{"asset_class":"none","name":"Israel Defense Forces (IDF)","relevance":"direct actor","symbol":"","type":"military"},{"asset_class":"none","name":"Hezbollah","relevance":"implied target/linked actor","symbol":"","type":"militant group"},{"asset_class":"none","name":"Beirut","relevance":"location of strikes","symbol":"","type":"city"},{"asset_class":"none","name":"Naim Qassem","relevance":"named in source summary as Hezbollah chief (context)","symbol":"","type":"person"},{"asset_class":"none","name":"United States","relevance":"mentioned in source summary via truce talks context","symbol":"","type":"country"},{"asset_class":"none","name":"Iran","relevance":"mentioned in source summary via truce talks context","symbol":"","type":"country"}],"event_type":"conflict","information_gaps":["The cleaned article text provided contains no readable content about the strikes; extraction is based on the headline and the provided source summary only.","Specific neighborhoods in Beirut are not listed in the provided headline text (only described generally as commercial and upscale seafront).","No casualty figures, weapon types, or damage assessments are included in the provided text.","Whether the strikes were intended for Hezbollah assets or were primarily civilian/commercial impact is not specified in the provided headline text.","Near-term catalyst timing beyond 'Wednesday' is not determinable from the provided excerpt."],"key_facts":["The report states that IDF strikes occurred in Beirut on Wednesday.","The targeted/affected areas are described as commercial areas and upscale (\"tony\") seafront neighborhoods.","The headline ties the strikes to Wednesday specifically."],"numeric_claims":[],"primary_claim":"IDF strikes hit commercial areas and upscale seafront neighborhoods of Beirut on Wednesday.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"The Times of Israel reports that IDF strikes hit commercial areas and upscale seafront neighborhoods in Beirut on Wednesday. The action is framed as part of ongoing Israel\u2013Hezbollah conflict amid broader Iran-war related diplomatic timing.","topics":["Israel\u2013Lebanon conflict","IDF strikes","Beirut","Hezbollah","civilian/commercial impact","diplomatic timing (US-Iran truce talks context)"]},"source":"The Times of Israel","source_domain":"timesofisrael.com","source_url":"https://www.timesofisrael.com","summary":"Commercial areas, tony seafront neighborhoods of Beirut hit in IDF strikes Wednesday The Times of Israel Iran war live: Israel attacks Lebanon again on eve of US-Iran truce talks Al Jazeera Israeli military says it has killed Hezbollah chief Naim Qassem Reuters India Says Deeply Concerned by Reports of Civilian Casualties in Lebanon U.S. News & World Report Iran War Live Updates: Israel Strikes Hezbollah as Lebanon Impasse Threatens Cease-Fire The New York Times","title":"Commercial areas, tony seafront neighborhoods of Beirut hit in IDF strikes Wednesday - The Times of Israel","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_7c2c389abc50 in signals