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

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