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-11T10:31:21.405407+00:00","dedupe_key":"signal_enriched:news_delta:5411ed23c7f3dde3","evidence_event_ids":["evt_969fe1106cac"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxPd0dWRk9oQnBrbnlLbXdlS1Fxek5FRVZyYWhpZzVOX0M4d2NtVWlkRmVHaU9YZkRRMkxCbVY4aU9ESWxQZXV1THRSQy16ZUlnUk5lUkRWb3llQksxM3A3VldBTDRMN1NFcEZLcHBIZU8zSE5ZU3NIX00wT05WaEhCbjN6VUtWQXNYX21JRVh2N3k?oc=5","as_of":"2026-04-11T10:31:21.405407+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/CBMikAFBVV95cUxPd0dWRk9oQnBrbnlLbXdlS1Fxek5FRVZyYWhpZzVOX0M4d2NtVWlkRmVHaU9YZkRRMkxCbVY4aU9ESWxQZXV1THRSQy16ZUlnUk5lUkRWb3llQksxM3A3VldBTDRMN1NFcEZLcHBIZU8zSE5ZU3NIX00wT05WaEhCbjN6VUtWQXNYX21JRVh2N3k?oc=5","article_chars":0,"article_truncated":false,"blocked_reason":null,"candidate_id":"sc_cf621059e5ed2687","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-11T18:02:15.887146+00:00","extraction_method":"none","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxPd0dWRk9oQnBrbnlLbXdlS1Fxek5FRVZyYWhpZzVOX0M4d2NtVWlkRmVHaU9YZkRRMkxCbVY4aU9ESWxQZXV1THRSQy16ZUlnUk5lUkRWb3llQksxM3A3VldBTDRMN1NFcEZLcHBIZU8zSE5ZU3NIX00wT05WaEhCbjN6VUtWQXNYX21JRVh2N3k?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"irei.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMikAFBVV95cUxPd0dWRk9oQnBrbnlLbXdlS1Fxek5FRVZyYWhpZzVOX0M4d2NtVWlkRmVHaU9YZkRRMkxCbVY4aU9ESWxQZXV1THRSQy16ZUlnUk5lUkRWb3llQksxM3A3VldBTDRMN1NFcEZLcHBIZU8zSE5ZU3NIX00wT05WaEhCbjN6VUtWQXNYX21JRVh2N3k?oc=5","source_event_id":"evt_969fe1106cac","source_quality":"empty","status_code":200,"version":"signal_enrichment_v2"},"fp":"9deaa12ea328f841","published_at":"2026-04-11T10:20:44+00:00","publisher_domain":"irei.com","signal_understanding":{"analysis_basis":"headline_and_summary","claim_confidence":0.6,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Institutional Real Estate, Inc.","relevance":"source/issuer of the view","symbol":"","type":"company"},{"asset_class":"real_estate","name":"European residential markets","relevance":"subject of the claim","symbol":"","type":"market"}],"event_type":"other","information_gaps":["No article body text is available, so there are no details on what \u201cresilient\u201d means (e.g., prices, sales volumes, rents, vacancy rates).","No near-term catalyst timing is provided.","No countries/cities within Europe are specified.","No data, forecasts, or assumptions are included.","No tradable asset tickers or specific securities are mentioned."],"key_facts":["Provided headline/source summary: \u201cEuropean residential markets to remain resilient - Institutional Real Estate, Inc.\u201d"],"numeric_claims":[],"primary_claim":"European residential markets are expected to remain resilient.","relevance_score":0.35,"sentiment":"positive","source_quality":"unknown","summary":"The headline states that European residential real estate markets are expected to remain resilient, per Institutional Real Estate, Inc. No additional details, timing, or supporting metrics are provided in the supplied text.","topics":["European residential real estate","market resilience"]},"source":"Institutional Real Estate, Inc.","source_domain":"irei.com","source_url":"https://irei.com","summary":"European residential markets to remain resilient Institutional Real Estate, Inc.","title":"European residential markets to remain resilient - Institutional Real Estate, Inc.","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 23947 in events