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:1fcd724f7ecde732","evidence_event_ids":["evt_c7e14c07f623"],"signal_type":"discovery_ipo_delta","source":"discovery_ingestor","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxOQnhwa2NJVjlkVUUyeE82YUFsUm9wU1RxTXJRMWpyQmQtTE9Pd19aUXdJS1VoVzJvTmw5dFNkNllyaGViV1padnhBNFZZZVZfdktYX3BNOWVPa2ppa1ZJeEswYllwSjhXLVZxeFNod3JaZElMWnJTZWxpTFRlU0p1UmpYU0IxN0RPSXdVWGEyMjlJR1l3UmpyQ3lZdW_SAaIBQVVfeXFMTkNsRkg2cjdleUVzT2F1amg4UEN3SG9uZ0N1dEZXejJKU0Vmal9WM2lUQ0ZjeVFJQ200NHpSVEZGTUwzZ3hSLVktX2VRSmhLdF9zSUF0UjFTR1o5T3QzRHZtcFQyV01OVTdacFBGNi1WRGtvV2xhMzhCVEhfWmliZGNhdXRNNWZMN1RmZWxOcHo5OEhNaVBDc2FkWElkSHhvOTJn?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/CBMinAFBVV95cUxOQnhwa2NJVjlkVUUyeE82YUFsUm9wU1RxTXJRMWpyQmQtTE9Pd19aUXdJS1VoVzJvTmw5dFNkNllyaGViV1padnhBNFZZZVZfdktYX3BNOWVPa2ppa1ZJeEswYllwSjhXLVZxeFNod3JaZElMWnJTZWxpTFRlU0p1UmpYU0IxN0RPSXdVWGEyMjlJR1l3UmpyQ3lZdW_SAaIBQVVfeXFMTkNsRkg2cjdleUVzT2F1amg4UEN3SG9uZ0N1dEZXejJKU0Vmal9WM2lUQ0ZjeVFJQ200NHpSVEZGTUwzZ3hSLVktX2VRSmhLdF9zSUF0UjFTR1o5T3QzRHZtcFQyV01OVTdacFBGNi1WRGtvV2xhMzhCVEhfWmliZGNhdXRNNWZMN1RmZWxOcHo5OEhNaVBDc2FkWElkSHhvOTJn?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_3f78df0060fff4c9","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:03:27.009048+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMinAFBVV95cUxOQnhwa2NJVjlkVUUyeE82YUFsUm9wU1RxTXJRMWpyQmQtTE9Pd19aUXdJS1VoVzJvTmw5dFNkNllyaGViV1padnhBNFZZZVZfdktYX3BNOWVPa2ppa1ZJeEswYllwSjhXLVZxeFNod3JaZElMWnJTZWxpTFRlU0p1UmpYU0IxN0RPSXdVWGEyMjlJR1l3UmpyQ3lZdW_SAaIBQVVfeXFMTkNsRkg2cjdleUVzT2F1amg4UEN3SG9uZ0N1dEZXejJKU0Vmal9WM2lUQ0ZjeVFJQ200NHpSVEZGTUwzZ3hSLVktX2VRSmhLdF9zSUF0UjFTR1o5T3QzRHZtcFQyV01OVTdacFBGNi1WRGtvV2xhMzhCVEhfWmliZGNhdXRNNWZMN1RmZWxOcHo5OEhNaVBDc2FkWElkSHhvOTJn?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/CBMinAFBVV95cUxOQnhwa2NJVjlkVUUyeE82YUFsUm9wU1RxTXJRMWpyQmQtTE9Pd19aUXdJS1VoVzJvTmw5dFNkNllyaGViV1padnhBNFZZZVZfdktYX3BNOWVPa2ppa1ZJeEswYllwSjhXLVZxeFNod3JaZElMWnJTZWxpTFRlU0p1UmpYU0IxN0RPSXdVWGEyMjlJR1l3UmpyQ3lZdW_SAaIBQVVfeXFMTkNsRkg2cjdleUVzT2F1amg4UEN3SG9uZ0N1dEZXejJKU0Vmal9WM2lUQ0ZjeVFJQ200NHpSVEZGTUwzZ3hSLVktX2VRSmhLdF9zSUF0UjFTR1o5T3QzRHZtcFQyV01OVTdacFBGNi1WRGtvV2xhMzhCVEhfWmliZGNhdXRNNWZMN1RmZWxOcHo5OEhNaVBDc2FkWElkSHhvOTJn?oc=5","source_event_id":"evt_c7e14c07f623","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"81c1973e7a91ceba","kind":"ipo_calendar","published_at":"2026-04-07T19:09:16+00:00","publisher_domain":"gstatic.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.55,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"National Healthcare Properties","relevance":"primary","symbol":"","type":"company"}],"event_type":"listing","information_gaps":["The provided article text is not substantive (contains mostly CSS/HTML styling), so IPO specifics (e.g., expected ticker, offer size, pricing range, underwriters, filing date, exchange, or prospectus details) are not available.","No confirmation is provided in the cleaned text beyond the headline/signal statement.","No details on how senior housing demand is measured or which assets/segments will be targeted are included."],"key_facts":["National Healthcare Properties filed for a US IPO (per the provided headline/signal text).","The stated purpose is to tap senior housing demand (per the provided headline/signal text)."],"numeric_claims":[],"primary_claim":"National Healthcare Properties filed for a US IPO to tap senior housing demand.","relevance_score":0.62,"sentiment":"neutral","source_quality":"high","summary":"The signal states that National Healthcare Properties has filed for a US IPO to pursue demand in the senior housing sector. No additional IPO terms or filing details are present in the provided text.","topics":["US IPO filing","senior housing demand","healthcare real estate"]},"source":"Pulse 2.0","source_domain":"gstatic.com","summary":"National Healthcare Properties Files For US IPO To Tap Senior Housing Demand Pulse 2.0","tickers":[],"title":"National Healthcare Properties Files For US IPO To Tap Senior Housing Demand - Pulse 2.0","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 2898 in events