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-08T12:48:26.737983+00:00","dedupe_key":"signal_enriched:news_delta:ee01fcc0f51a44b8","evidence_event_ids":["evt_d9b06fda1e86"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPcmRZZmpjMW1TdXZNV3lmMk5wS1lDdklWQXNCZjQzMGtwOEs0WUNjaE52N2luNTFJYUVrQi1tME5rV1g0ZWhYVVVPeEdfX1RzRkRFS2dONWVSU0dxY0pTT3U0YlhxSUJHY2ZZSEIwcUg0VW5YTHdmNXk3dFVaaUNMM3U3RzE?oc=5","as_of":"2026-04-08T12:48:26.737983+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/CBMihAFBVV95cUxPcmRZZmpjMW1TdXZNV3lmMk5wS1lDdklWQXNCZjQzMGtwOEs0WUNjaE52N2luNTFJYUVrQi1tME5rV1g0ZWhYVVVPeEdfX1RzRkRFS2dONWVSU0dxY0pTT3U0YlhxSUJHY2ZZSEIwcUg0VW5YTHdmNXk3dFVaaUNMM3U3RzE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_337cbbc2f2bf0cc0","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-08T12:48:50.342780+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPcmRZZmpjMW1TdXZNV3lmMk5wS1lDdklWQXNCZjQzMGtwOEs0WUNjaE52N2luNTFJYUVrQi1tME5rV1g0ZWhYVVVPeEdfX1RzRkRFS2dONWVSU0dxY0pTT3U0YlhxSUJHY2ZZSEIwcUg0VW5YTHdmNXk3dFVaaUNMM3U3RzE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"washingtonpost.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMihAFBVV95cUxPcmRZZmpjMW1TdXZNV3lmMk5wS1lDdklWQXNCZjQzMGtwOEs0WUNjaE52N2luNTFJYUVrQi1tME5rV1g0ZWhYVVVPeEdfX1RzRkRFS2dONWVSU0dxY0pTT3U0YlhxSUJHY2ZZSEIwcUg0VW5YTHdmNXk3dFVaaUNMM3U3RzE?oc=5","source_event_id":"evt_d9b06fda1e86","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"4bba52c31639f2ab","published_at":"2026-04-08T11:32:13+00:00","publisher_domain":"washingtonpost.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"media","name":"The Washington Post","relevance":"high","symbol":"","type":"publisher"},{"asset_class":"media","name":"Virginia Tech News","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"Seattle Times","relevance":"medium","symbol":"","type":"publisher"},{"asset_class":"media","name":"Post and Courier","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"media","name":"The Spec","relevance":"low","symbol":"","type":"publisher"},{"asset_class":"education","name":"Virginia Tech","relevance":"medium","symbol":"","type":"institution"}],"event_type":"other","information_gaps":["The cleaned article text provided contains only page styling/HTML/CSS, not the actual article content; therefore, specific mechanisms, study details, or expert quotes are not verifiable from the supplied text.","No specific \u201cspringtime activity\u201d details (e.g., duration, type of gardening, target population) are present in the provided excerpt.","No evidence level (study vs. expert opinion) or quantified outcomes are included in the provided material."],"key_facts":["Headline from The Washington Post states that a simple springtime activity may help keep you mentally sharp.","The provided source summary describes \u201cgarden therapy\u201d and suggests getting hands dirty is beneficial.","Other included snippets (Seattle Times, Post and Courier Opinion, The Spec, Virginia Tech News) also frame spring gardening as good for the brain/healthy aging."],"numeric_claims":[],"primary_claim":"Spring gardening/yard work can help keep people mentally sharp (supporting cognitive/mental sharpness).","relevance_score":0.18,"sentiment":"positive","source_quality":"high","summary":"The Washington Post highlights that a simple springtime activity\u2014spring gardening/yard work\u2014may help keep people mentally sharp. The piece frames gardening as beneficial for cognitive/mental health, consistent with other cited outlets\u2019 \u201cgarden therapy\u201d themes.","topics":["mental health","cognitive sharpness","spring gardening","yard work","healthy aging","garden therapy"]},"source":"The Washington Post","source_domain":"washingtonpost.com","source_url":"https://www.washingtonpost.com","summary":"This simple springtime activity may help keep you mentally sharp The Washington Post Garden therapy: Why getting your hands dirty is the best \u2018medicine\u2019 The Seattle Times AIKEN MASTER GARDENERS: Yard work can have physical, mental benefits Post and Courier Opinion | Why spring gardening is a great activity for healthy aging The Spec Spring is good for your brain, expert says Virginia Tech News","title":"This simple springtime activity may help keep you mentally sharp - The Washington Post","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 6482 in events