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/CBMiX0FVX3lxTFA3dzQyTndVQ1p4S0pnTXMwNGE4d01VUEtTQVpKU1NtOXFlc2gtSFVTT3ptc3F3Sjhia3BCc3J1elJ6NVd3a3hzS0Z5eV9HM1o2aXlxbWVyQ3dvalZ0Y2tF?oc=5","as_of":"2026-04-10T15:28:44.347861+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/CBMiX0FVX3lxTFA3dzQyTndVQ1p4S0pnTXMwNGE4d01VUEtTQVpKU1NtOXFlc2gtSFVTT3ptc3F3Sjhia3BCc3J1elJ6NVd3a3hzS0Z5eV9HM1o2aXlxbWVyQ3dvalZ0Y2tF?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_1473e3bdd8bf08fb","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-10T16:59:59.527497+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMiX0FVX3lxTFA3dzQyTndVQ1p4S0pnTXMwNGE4d01VUEtTQVpKU1NtOXFlc2gtSFVTT3ptc3F3Sjhia3BCc3J1elJ6NVd3a3hzS0Z5eV9HM1o2aXlxbWVyQ3dvalZ0Y2tF?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"nature.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMiX0FVX3lxTFA3dzQyTndVQ1p4S0pnTXMwNGE4d01VUEtTQVpKU1NtOXFlc2gtSFVTT3ptc3F3Sjhia3BCc3J1elJ6NVd3a3hzS0Z5eV9HM1o2aXlxbWVyQ3dvalZ0Y2tF?oc=5","source_event_id":"evt_06ababc41f4a","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"be8f4227b917438a","published_at":"2026-04-10T03:52:46+00:00","publisher_domain":"nature.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"biological","name":"Traded wildlife","relevance":"high","symbol":"","type":"population"},{"asset_class":"human_health","name":"Humans","relevance":"high","symbol":"","type":"population"},{"asset_class":"industry","name":"Wildlife trade","relevance":"high","symbol":"","type":"activity"},{"asset_class":"media","name":"Nature (publisher)","relevance":"medium","symbol":"","type":"publisher"}],"event_type":"geopolitical_risk","information_gaps":["The cleaned article text provided contains no substantive content from the Nature article (only page styling/HTML), so the extracted numeric claim is grounded only in the headline and the provided source summary list.","The study\u2019s sample size, geographic scope, pathogen types, and whether \u201calmost half\u201d refers to species, individual animals, or shipments are not specified in the provided text.","Near-term timing/catalysts (e.g., policy actions, outbreak dates) are not stated in the provided headline/summary."],"key_facts":["Nature headline reports that almost half of traded wildlife carry disease-causing pathogens.","Associated coverage (from the provided source summary list) states wildlife trafficked animals are more likely to share pathogens with humans.","Associated coverage (from the provided source summary list) frames wildlife trade as boosting the chance of animal-to-human disease jumping."],"numeric_claims":[{"label":"Share of traded wildlife carrying disease-causing pathogens","value":"Almost half"}],"primary_claim":"Almost half of traded wildlife carry disease-causing pathogens.","relevance_score":0.78,"sentiment":"negative","source_quality":"high","summary":"A Nature-reported study finds that nearly half of traded wildlife carry pathogens that can cause disease, implying the wildlife trade increases the risk of zoonotic disease outbreaks. The signal points to a public-health risk driven by animal trafficking and cross-species pathogen sharing.","topics":["zoonotic disease","wildlife trafficking","pathogens","public health risk","disease spillover"]},"source":"Nature","source_domain":"nature.com","source_url":"https://www.nature.com","summary":"Almost half of traded wildlife carry disease-causing pathogens Nature Here\u2019s how the wildlife trade is fueling disease outbreaks across the globe The Washington Post How bad for humans is wildlife trade? A new study has answers NPR Trafficked animals more likely to share pathogens with humans, says study Yahoo How the wildlife trade boosts the chance of a disease jumping from animals to humans Scientific American","title":"Almost half of traded wildlife carry disease-causing pathogens - Nature","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_b723891c2028 in signals