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-07T23:23:54.391414+00:00","dedupe_key":"signal_enriched:discovery_ipo_delta:ea92209a204a52c3","evidence_event_ids":["evt_e07404e7bb11"],"signal_type":"discovery_ipo_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxNTV9FbWQ3UXptMXJMVXJ4Y0x0dEEwOURJN0JOSzlqb1VLX2drUTRMSnNPdkRkNTlhRzIzR1h0aDlJaVVQMDl5d3NWT1NaSC1UR0hnV2JrYjBaMnMtSUVNWTQwOW1SRVMtTEdOdEdKN01qb25GUFp4R2o3aFh2N1FKOXNVUFBWX054Z0NqMEFlbk04Ml95M1FYV0F0ZzBkak84Y0FSdXlkNDd6bGpGckV6VUh5RXVqZ0hMVXRHemxPQ2VnaWRwTmFYZzdDMUxCZFFad3M1VEVDMEdXMVJ6TE9lNGJGSkE?oc=5","as_of":"2026-04-07T23:23:54.391414+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/CBMi5AFBVV95cUxNTV9FbWQ3UXptMXJMVXJ4Y0x0dEEwOURJN0JOSzlqb1VLX2drUTRMSnNPdkRkNTlhRzIzR1h0aDlJaVVQMDl5d3NWT1NaSC1UR0hnV2JrYjBaMnMtSUVNWTQwOW1SRVMtTEdOdEdKN01qb25GUFp4R2o3aFh2N1FKOXNVUFBWX054Z0NqMEFlbk04Ml95M1FYV0F0ZzBkak84Y0FSdXlkNDd6bGpGckV6VUh5RXVqZ0hMVXRHemxPQ2VnaWRwTmFYZzdDMUxCZFFad3M1VEVDMEdXMVJ6TE9lNGJGSkE?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_9323cd8f34e73a1e","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-08T01:06:14.218327+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxNTV9FbWQ3UXptMXJMVXJ4Y0x0dEEwOURJN0JOSzlqb1VLX2drUTRMSnNPdkRkNTlhRzIzR1h0aDlJaVVQMDl5d3NWT1NaSC1UR0hnV2JrYjBaMnMtSUVNWTQwOW1SRVMtTEdOdEdKN01qb25GUFp4R2o3aFh2N1FKOXNVUFBWX054Z0NqMEFlbk04Ml95M1FYV0F0ZzBkak84Y0FSdXlkNDd6bGpGckV6VUh5RXVqZ0hMVXRHemxPQ2VnaWRwTmFYZzdDMUxCZFFad3M1VEVDMEdXMVJ6TE9lNGJGSkE?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"gstatic.com","publisher_resolution":"canonical_aggregator_unresolved","requested_url":"https://news.google.com/rss/articles/CBMi5AFBVV95cUxNTV9FbWQ3UXptMXJMVXJ4Y0x0dEEwOURJN0JOSzlqb1VLX2drUTRMSnNPdkRkNTlhRzIzR1h0aDlJaVVQMDl5d3NWT1NaSC1UR0hnV2JrYjBaMnMtSUVNWTQwOW1SRVMtTEdOdEdKN01qb25GUFp4R2o3aFh2N1FKOXNVUFBWX054Z0NqMEFlbk04Ml95M1FYV0F0ZzBkak84Y0FSdXlkNDd6bGpGckV6VUh5RXVqZ0hMVXRHemxPQ2VnaWRwTmFYZzdDMUxCZFFad3M1VEVDMEdXMVJ6TE9lNGJGSkE?oc=5","source_event_id":"evt_e07404e7bb11","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"76f32e0038025323","kind":"ipo_calendar","published_at":"2026-04-07T05:07:22+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.7,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"National Healthcare Properties","relevance":"primary","symbol":"","type":"company"},{"asset_class":"media","name":"McKnight's Senior Living","relevance":"supporting","symbol":"","type":"publisher"}],"event_type":"listing","information_gaps":["No IPO date, offering size, pricing range, underwriters, or exchange listing details are present in the provided text.","No specific demographic metrics or senior living growth figures are included in the provided text.","The cleaned article text contains only CSS/HTML styling and does not include the substantive article content beyond the headline/summary provided in the prompt."],"key_facts":["The signal headline states that National Healthcare Properties is seeking to tap into favorable demographics and senior living growth potential via an IPO.","The provided source summary repeats the same claim and attributes it to McKnight's Senior Living."],"numeric_claims":[],"primary_claim":"National Healthcare Properties\u2019 IPO is intended to leverage favorable demographics and senior living growth potential.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"National Healthcare Properties is pursuing an IPO, with the stated rationale tied to favorable demographics and expected growth in senior living. The source is McKnight's Senior Living.","topics":["IPO","senior living","demographics","healthcare real estate"]},"source":"McKnight's Senior Living","source_domain":"gstatic.com","summary":"National Healthcare Properties IPO seeks to tap into favorable demographics, senior living growth potential McKnight's Senior Living","tickers":[],"title":"National Healthcare Properties IPO seeks to tap into favorable demographics, senior living growth potential - McKnight's Senior Living","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 2974 in events