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/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

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_6cbc33d9cc0b in signals