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/CBMi_gFBVV95cUxQYkljSDlaTEpQRGdmdTlHR3ExdWJUdTF6LTNzNG9nczU1U2Eza3JnSUx4OXc4Y3RRaVNody1CWHROU3dNcE5WVnhTM0l3N0t4c19UTjRKUjh6T2ZIbG5uX0V0MmFIY2s4Rl8zTzFNVHZVLThiVHh5N3hsZ19WRW9Mc2E4cmJqVVdmNFdvT2sydW53NTJVblBaa2hYdVNuSGhZNG8xNEJ1bTVvaTRUQjNCOWw3RUMyLW9EM1pjSVZYNjR1UDl3cEViemg1XzdtbjlqTTg1TXNybjkyalpwUHdHeU90SEw1VjhkczVNblVwLW9FUDJIT2JWdXZvTUpjUQ?oc=5","as_of":"2026-04-08T10:39:13.240117+00:00","canonical_url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","enrichment":{"aggregator_url":"https://news.google.com/rss/articles/CBMi_gFBVV95cUxQYkljSDlaTEpQRGdmdTlHR3ExdWJUdTF6LTNzNG9nczU1U2Eza3JnSUx4OXc4Y3RRaVNody1CWHROU3dNcE5WVnhTM0l3N0t4c19UTjRKUjh6T2ZIbG5uX0V0MmFIY2s4Rl8zTzFNVHZVLThiVHh5N3hsZ19WRW9Mc2E4cmJqVVdmNFdvT2sydW53NTJVblBaa2hYdVNuSGhZNG8xNEJ1bTVvaTRUQjNCOWw3RUMyLW9EM1pjSVZYNjR1UDl3cEViemg1XzdtbjlqTTg1TXNybjkyalpwUHdHeU90SEw1VjhkczVNblVwLW9FUDJIT2JWdXZvTUpjUQ?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_0684902d1ae50a60","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=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/m=syndicationarticleview,_b,_tp","content_type":"text/html; charset=utf-8","enriched_at":"2026-04-08T10:39:40.079620+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi_gFBVV95cUxQYkljSDlaTEpQRGdmdTlHR3ExdWJUdTF6LTNzNG9nczU1U2Eza3JnSUx4OXc4Y3RRaVNody1CWHROU3dNcE5WVnhTM0l3N0t4c19UTjRKUjh6T2ZIbG5uX0V0MmFIY2s4Rl8zTzFNVHZVLThiVHh5N3hsZ19WRW9Mc2E4cmJqVVdmNFdvT2sydW53NTJVblBaa2hYdVNuSGhZNG8xNEJ1bTVvaTRUQjNCOWw3RUMyLW9EM1pjSVZYNjR1UDl3cEViemg1XzdtbjlqTTg1TXNybjkyalpwUHdHeU90SEw1VjhkczVNblVwLW9FUDJIT2JWdXZvTUpjUQ?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"theguardian.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMi_gFBVV95cUxQYkljSDlaTEpQRGdmdTlHR3ExdWJUdTF6LTNzNG9nczU1U2Eza3JnSUx4OXc4Y3RRaVNody1CWHROU3dNcE5WVnhTM0l3N0t4c19UTjRKUjh6T2ZIbG5uX0V0MmFIY2s4Rl8zTzFNVHZVLThiVHh5N3hsZ19WRW9Mc2E4cmJqVVdmNFdvT2sydW53NTJVblBaa2hYdVNuSGhZNG8xNEJ1bTVvaTRUQjNCOWw3RUMyLW9EM1pjSVZYNjR1UDl3cEViemg1XzdtbjlqTTg1TXNybjkyalpwUHdHeU90SEw1VjhkczVNblVwLW9FUDJIT2JWdXZvTUpjUQ?oc=5","source_event_id":"evt_a06e0d40e806","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"66b2a5fbc3d7811a","published_at":"2026-04-08T09:35:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.78,"dates_mentioned":[],"entities":[{"asset_class":"sovereign","name":"Israel","relevance":"directly making the ceasefire claim","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Iran","relevance":"ceasefire is described as an Iran war ceasefire","symbol":"","type":"country"},{"asset_class":"sovereign","name":"Lebanon","relevance":"explicitly excluded from the ceasefire per Israel","symbol":"","type":"country"},{"asset_class":"media","name":"The Guardian","relevance":"source of the headline and live coverage","symbol":"","type":"publisher"}],"event_type":"conflict","information_gaps":["No details are provided in the provided text about when the ceasefire was announced, who is enforcing it, or the specific terms.","No information is provided on the location, scale, or targets of the continuing air strikes.","No confirmation is provided in the provided text from Lebanon/Iran or from any third party about the ceasefire\u2019s scope."],"key_facts":["Headline states: Israel says an Iran war ceasefire doesn\u2019t include Lebanon.","Headline states: air strikes continue.","Coverage is described as \u201clive\u201d by The Guardian."],"numeric_claims":[],"primary_claim":"Israel stated that the Iran war ceasefire excludes Lebanon, and air strikes are continuing.","relevance_score":0.72,"sentiment":"negative","source_quality":"high","summary":"The Guardian reports that Israel says an Iran-related war ceasefire does not include Lebanon, while air strikes continue.","topics":["Middle East crisis","ceasefire","Israel-Iran conflict","Lebanon air strikes","air strikes continuation"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Middle East crisis live: Israel says Iran war ceasefire doesn\u2019t include Lebanon as air strikes continue The Guardian View Full Coverage on Google News","title":"Middle East crisis live: Israel says Iran war ceasefire doesn\u2019t include Lebanon as air strikes continue - The Guardian","url":"https://www.gstatic.com/_/mss/boq-dots/_/ss/k=boq-dots.DotsSplashUi_desktop_ms.OYgPNdDf9Nc.L.X.O/am=GAINAAAADpgFDCgAAQ/d=1/ed=1/rs=ALs0n2MABJgB0xD8Xegxuxy7eYXFqjyp-Q/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_e0ec70b380a3 in signals