SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"created_at":"2026-04-08T10:39:13.240117+00:00","dedupe_key":"signal_enriched:news_delta:cbf5c8761bfcc9c8","evidence_event_ids":["evt_a06e0d40e806"],"signal_type":"news_headline_delta","source":"news_rss","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

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 5981 in events