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-09T20:18:41.024016+00:00","dedupe_key":"signal_enriched:news_delta:308982ac29a96c07","evidence_event_ids":["evt_c927c346055c"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPN3M1YU5aYXBqT2NhbGhsX3VvOVRjbGVUODhUZ3ZscGVSRjFKcVVvUDczUzhxY0NBeWIzd2twaFBzcFFwYlUtdFZHamR4WHVkcG83eEl2NUN1Vno4OUxiYlFJR3k0dEtsZk80NVdQWlBjNWQ0T3V4UGVxUTNTRjBOb3dXYWxVeUsySlhlMVNhaWZ5WkRiS3otbXN5UGh3dmluSlA4UkJBOWF6dlJW?oc=5","as_of":"2026-04-09T20:18:41.024016+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/CBMirAFBVV95cUxPN3M1YU5aYXBqT2NhbGhsX3VvOVRjbGVUODhUZ3ZscGVSRjFKcVVvUDczUzhxY0NBeWIzd2twaFBzcFFwYlUtdFZHamR4WHVkcG83eEl2NUN1Vno4OUxiYlFJR3k0dEtsZk80NVdQWlBjNWQ0T3V4UGVxUTNTRjBOb3dXYWxVeUsySlhlMVNhaWZ5WkRiS3otbXN5UGh3dmluSlA4UkJBOWF6dlJW?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_017a8c265063df6f","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-10T00:27:32.487460+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMirAFBVV95cUxPN3M1YU5aYXBqT2NhbGhsX3VvOVRjbGVUODhUZ3ZscGVSRjFKcVVvUDczUzhxY0NBeWIzd2twaFBzcFFwYlUtdFZHamR4WHVkcG83eEl2NUN1Vno4OUxiYlFJR3k0dEtsZk80NVdQWlBjNWQ0T3V4UGVxUTNTRjBOb3dXYWxVeUsySlhlMVNhaWZ5WkRiS3otbXN5UGh3dmluSlA4UkJBOWF6dlJW?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/CBMirAFBVV95cUxPN3M1YU5aYXBqT2NhbGhsX3VvOVRjbGVUODhUZ3ZscGVSRjFKcVVvUDczUzhxY0NBeWIzd2twaFBzcFFwYlUtdFZHamR4WHVkcG83eEl2NUN1Vno4OUxiYlFJR3k0dEtsZk80NVdQWlBjNWQ0T3V4UGVxUTNTRjBOb3dXYWxVeUsySlhlMVNhaWZ5WkRiS3otbXN5UGh3dmluSlA4UkJBOWF6dlJW?oc=5","source_event_id":"evt_c927c346055c","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"ae8e800226851411","published_at":"2026-04-09T18:01:00+00:00","publisher_domain":"theguardian.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"biological_species","name":"Wild chimpanzees","relevance":"primary subject of the report","symbol":"","type":"species"},{"asset_class":"biological_group","name":"Two chimp groups/factions","relevance":"entities between which coordinated attacks occur","symbol":"","type":"group"},{"asset_class":"media","name":"The Guardian","relevance":"source of the headline signal","symbol":"","type":"publisher"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only CSS/HTML styling and no readable article content, so the specific details (location, study/method, exact duration, and evidence) cannot be verified from the supplied text.","The \u201c8 years\u201d duration appears in the user-provided source summary/snippets (e.g., National Geographic) but is not confirmable from the Guardian headline alone.","No information is provided here about the geographic site, researchers, dataset, or publication details behind the claim."],"key_facts":["The Guardian headline describes chimpanzees as waging a \u201ccivil war.\u201d","The headline states there were coordinated attacks between two groups/factions.","The provided multi-source context (headline snippets) indicates the conflict has been ongoing for about 8 years (uncertain whether this specific Guardian article states the same duration)."],"numeric_claims":[{"label":"duration","value":"~8 years (from provided context snippets; not confirmed in the cleaned article text)"}],"primary_claim":"Wild chimpanzees have been recorded waging a coordinated \u201ccivil war\u201d between two groups, involving coordinated attacks.","relevance_score":0.35,"sentiment":"neutral","source_quality":"high","summary":"The Guardian reports that wild chimpanzees have been observed engaging in coordinated, group-on-group violence described as a \u201ccivil war.\u201d The reporting indicates this infighting has persisted for years, with attacks between two groups.","topics":["wildlife behavior","chimpanzee infighting","intergroup conflict","coordinated attacks","animal warfare"]},"source":"The Guardian","source_domain":"theguardian.com","source_url":"https://www.theguardian.com","summary":"Wild chimpanzees recorded waging \u2018civil war\u2019 with coordinated attacks between two groups The Guardian Why these chimps have been at war for 8 years National Geographic Infants torn from mothers, testicles ripped off: Study describes vicious chimpanzee infighting NBC News Ugandan chimps split into two factions, then killed rivals Ars Technica These Chimps Began the Bloodiest \u2018War\u2019 on Record. No One Knows Why. The New York Times","title":"Wild chimpanzees recorded waging \u2018civil war\u2019 with coordinated attacks between two groups - The Guardian","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

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 11207 in events