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/CBMiiAFBVV95cUxPVnoxaGtUZ0VGMk5kYWZ1VmtoRFh1QWNTV0RBWHJmVUtXcEhQZUo2Qm5jUGRDazhPTGdWaW5NbExkYkZ0S25YLVlMZXc3QklxRHZVYU5YR2V5WHVXMHZuVThDenNWSDFWblRfNFl2UndrYVVIYjJBd2M3bXdDSWZucVFqVFZ6eEJR?oc=5","as_of":"2026-04-10T13:38:20.432182+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/CBMiiAFBVV95cUxPVnoxaGtUZ0VGMk5kYWZ1VmtoRFh1QWNTV0RBWHJmVUtXcEhQZUo2Qm5jUGRDazhPTGdWaW5NbExkYkZ0S25YLVlMZXc3QklxRHZVYU5YR2V5WHVXMHZuVThDenNWSDFWblRfNFl2UndrYVVIYjJBd2M3bXdDSWZucVFqVFZ6eEJR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9afbc1ccc361ffe2","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-10T13:39:20.464622+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiiAFBVV95cUxPVnoxaGtUZ0VGMk5kYWZ1VmtoRFh1QWNTV0RBWHJmVUtXcEhQZUo2Qm5jUGRDazhPTGdWaW5NbExkYkZ0S25YLVlMZXc3QklxRHZVYU5YR2V5WHVXMHZuVThDenNWSDFWblRfNFl2UndrYVVIYjJBd2M3bXdDSWZucVFqVFZ6eEJR?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/CBMiiAFBVV95cUxPVnoxaGtUZ0VGMk5kYWZ1VmtoRFh1QWNTV0RBWHJmVUtXcEhQZUo2Qm5jUGRDazhPTGdWaW5NbExkYkZ0S25YLVlMZXc3QklxRHZVYU5YR2V5WHVXMHZuVThDenNWSDFWblRfNFl2UndrYVVIYjJBd2M3bXdDSWZucVFqVFZ6eEJR?oc=5","source_event_id":"evt_229956ece864","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"604a1710da315658","published_at":"2026-04-10T09:05:07+00:00","publisher_domain":"nytimes.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":["7 April"],"entities":[{"asset_class":"sovereign","name":"Lebanon","relevance":"high","symbol":"","type":"country"},{"asset_class":"other","name":"Israeli forces","relevance":"medium","symbol":"","type":"actor"},{"asset_class":"other","name":"Lebanese displaced people","relevance":"high","symbol":"","type":"population"},{"asset_class":"sovereign","name":"Russia","relevance":"low","symbol":"","type":"country"},{"asset_class":"sovereign","name":"China","relevance":"low","symbol":"","type":"country"},{"asset_class":"other","name":"United Nations (UN)","relevance":"low","symbol":"","type":"institution"}],"event_type":"conflict","information_gaps":["The cleaned article text appears to be mostly unrelated page styling/HTML and does not contain the substantive NYT content; extraction relies on the provided source summary and headline only.","Specific details (e.g., casualty figures, shelter locations, which sectarian groups, and the exact UN resolution text) are not included in the provided signal.","Near-term catalyst timing is inferred from \u201crising\u201d tensions and civil-war warning, but no explicit timeline beyond \u201c7 April\u201d is given."],"key_facts":["The New York Times headline describes Lebanon as being \u201cuprooted by war.\u201d","The provided source summary states that humanitarian and economic pressures in Lebanon are growing.","The source summary states that displaced Lebanese face uncertainty and sectarian tensions.","The source summary states that in Lebanon\u2019s shelters, not everyone is welcome.","The source summary states that sectarian tensions are rising and includes a warning about heading toward civil war if people do not stand united.","The source summary states that displaced Lebanese were forced from their homes by Israeli bombing (as described in the Washington Post/NBC News excerpts).","The source summary also mentions that Russia and China vetoed a UN resolution related to the Strait of Hormuz (contextual, not directly Lebanon-specific)."],"numeric_claims":[],"primary_claim":"Lebanon is being uprooted by war, with displaced Lebanese facing uncertainty and rising sectarian tensions amid growing humanitarian and economic pressures.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"The New York Times frames Lebanon as increasingly destabilized by war, with growing humanitarian and economic pressures and rising sectarian tensions affecting displaced people. The signal also references related reporting that shelters and communities are becoming less welcoming, raising near-term risks of further internal conflict.","topics":["Lebanon","war displacement","humanitarian crisis","economic pressure","sectarian tensions","civil war risk","shelters","Middle East conflict"]},"source":"The New York Times","source_domain":"nytimes.com","source_url":"https://www.nytimes.com","summary":"Lebanon: A Nation Uprooted by War The New York Times MIDDLE EAST LIVE 7 April: Humanitarian and economic pressures grow; Russia and China veto resolution on Strait of Hormuz UN News In Lebanon\u2019s shelters, not everyone is welcome The Washington Post Forced from their homes by Israeli bombing, displaced Lebanese face uncertainty and sectarian tensions NBC News In Lebanon, sectarian tensions rise: 'We must stand united or we are heading for civil war' Le Monde.fr","title":"Lebanon: A Nation Uprooted by War - 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_da3072cfc377 in signals