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

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