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-11T12:53:26.568302+00:00","dedupe_key":"signal_enriched:news_delta:0881aca7b55bbf7e","evidence_event_ids":["evt_63340ce43b4a"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPdE96bHdNSjdvMTgxNXJXQ28yandyeGhzSWxlMmJiZjI5cnA4VG91UzU2MmFVWVNOZjZ5cEFuMm9zMS0yQVU4d1M0djd2Smw0TDVaWU1SWlRCTEJTOVU4RGpWVVpTNlhhOFQ4UW5fRWNSVjN5aTFES21aYnBRcTNQX2txcExuUXpFelVzaE9R?oc=5","as_of":"2026-04-11T12:53:26.568302+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/CBMijgFBVV95cUxPdE96bHdNSjdvMTgxNXJXQ28yandyeGhzSWxlMmJiZjI5cnA4VG91UzU2MmFVWVNOZjZ5cEFuMm9zMS0yQVU4d1M0djd2Smw0TDVaWU1SWlRCTEJTOVU4RGpWVVpTNlhhOFQ4UW5fRWNSVjN5aTFES21aYnBRcTNQX2txcExuUXpFelVzaE9R?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_0ab5dbaef74389d6","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-11T20:08:00.122867+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPdE96bHdNSjdvMTgxNXJXQ28yandyeGhzSWxlMmJiZjI5cnA4VG91UzU2MmFVWVNOZjZ5cEFuMm9zMS0yQVU4d1M0djd2Smw0TDVaWU1SWlRCTEJTOVU4RGpWVVpTNlhhOFQ4UW5fRWNSVjN5aTFES21aYnBRcTNQX2txcExuUXpFelVzaE9R?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"npr.org","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMijgFBVV95cUxPdE96bHdNSjdvMTgxNXJXQ28yandyeGhzSWxlMmJiZjI5cnA4VG91UzU2MmFVWVNOZjZ5cEFuMm9zMS0yQVU4d1M0djd2Smw0TDVaWU1SWlRCTEJTOVU4RGpWVVpTNlhhOFQ4UW5fRWNSVjN5aTFES21aYnBRcTNQX2txcExuUXpFelVzaE9R?oc=5","source_event_id":"evt_63340ce43b4a","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"7a74bba86bed85a3","published_at":"2026-04-11T11:00:00+00:00","publisher_domain":"npr.org","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.62,"dates_mentioned":[],"entities":[{"asset_class":"","name":"NPR","relevance":"primary source mentioned","symbol":"","type":"media_outlet"},{"asset_class":"","name":"Gastroenterologist","relevance":"subject of the tips","symbol":"","type":"person_role"}],"event_type":"other","information_gaps":["No article body text is provided, so the specific tips, medical claims, and any quoted guidance are unknown.","No dates, locations, or named gastroenterologist are included in the provided text.","No tradable assets, companies, or economic/market impacts are mentioned in the supplied signal."],"key_facts":["Headline references NPR.","Topic is gut troubles and bathroom habits.","A gastroenterologist provides tips to achieve \u201cpoophoria.\u201d"],"numeric_claims":[],"primary_claim":"NPR features a gastroenterologist providing tips to help people with gut troubles achieve \u201cpoophoria.\u201d","relevance_score":0.05,"sentiment":"neutral","source_quality":"unknown","summary":"The NPR headline discusses a gastroenterologist offering tips aimed at improving bowel habits and achieving a term described as \u201cpoophoria.\u201d No market or company-specific developments are provided in the supplied text.","topics":["gastroenterology","bowel habits","gut health","patient tips","media coverage"]},"source":"NPR","source_domain":"npr.org","source_url":"https://www.npr.org","summary":"Gut troubles? This gastroenterologist has tips to help you achieve 'poophoria' NPR Are your bathroom habits normal? Harvard Gazette The 3 Ps of pooping may help you heal your gut and enjoy your life CNN Trouble pooping on vacation? You\u2019re not alone, and here\u2019s how to fix that WHYY Poo like a pro! - 7 Apr 2026 - Closer UK Magazine Readly | All magazines - one magazine app subscription","title":"Gut troubles? This gastroenterologist has tips to help you achieve 'poophoria' - NPR","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 24396 in events