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-10T02:59:34.971159+00:00","dedupe_key":"signal_enriched:news_delta:2ad05bae088b492f","evidence_event_ids":["evt_24848b156811"],"signal_type":"news_headline_delta","source":"news_rss","value":{"aggregator_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxPZi11cmxCN0FETE51U0tYQkctRXJ1dC1Yc1hDWXlKYktpc0RjOERSck8zT1piN1RwUzBKTjBqdERXLXNRek1hOGx1WXJzTThXWTJ0YmhsdElnM0VSWTN3MG9RZjRucVQ0Y0c4ajBBT25ocFI0R2ptYXJjV2kyQUdVV3J4am9pbmhrVGFaaXpjOW13VTFPRHRhMDRR?oc=5","as_of":"2026-04-10T02:59:34.971159+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/CBMimgFBVV95cUxPZi11cmxCN0FETE51U0tYQkctRXJ1dC1Yc1hDWXlKYktpc0RjOERSck8zT1piN1RwUzBKTjBqdERXLXNRek1hOGx1WXJzTThXWTJ0YmhsdElnM0VSWTN3MG9RZjRucVQ0Y0c4ajBBT25ocFI0R2ptYXJjV2kyQUdVV3J4am9pbmhrVGFaaXpjOW13VTFPRHRhMDRR?oc=5","article_chars":5000,"article_truncated":true,"blocked_reason":null,"candidate_id":"sc_a78a29c827d6cf51","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-10T03:00:15.873190+00:00","extraction_method":"heuristic","fetched_description":"","fetched_title":"","final_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxPZi11cmxCN0FETE51U0tYQkctRXJ1dC1Yc1hDWXlKYktpc0RjOERSck8zT1piN1RwUzBKTjBqdERXLXNRek1hOGx1WXJzTThXWTJ0YmhsdElnM0VSWTN3MG9RZjRucVQ0Y0c4ajBBT25ocFI0R2ptYXJjV2kyQUdVV3J4am9pbmhrVGFaaXpjOW13VTFPRHRhMDRR?oc=5&hl=en-US&gl=US&ceid=US:en","html_truncated":true,"paywall_likely":false,"publisher_domain":"sfchronicle.com","publisher_resolution":"payload_source_domain","requested_url":"https://news.google.com/rss/articles/CBMimgFBVV95cUxPZi11cmxCN0FETE51U0tYQkctRXJ1dC1Yc1hDWXlKYktpc0RjOERSck8zT1piN1RwUzBKTjBqdERXLXNRek1hOGx1WXJzTThXWTJ0YmhsdElnM0VSWTN3MG9RZjRucVQ0Y0c4ajBBT25ocFI0R2ptYXJjV2kyQUdVV3J4am9pbmhrVGFaaXpjOW13VTFPRHRhMDRR?oc=5","source_event_id":"evt_24848b156811","source_quality":"high","status_code":200,"version":"signal_enrichment_v2"},"fp":"e07a51c4a6c2791a","published_at":"2026-04-09T20:04:08+00:00","publisher_domain":"sfchronicle.com","signal_understanding":{"analysis_basis":"article","claim_confidence":0.72,"dates_mentioned":[],"entities":[{"asset_class":"equity","name":"Philz Coffee","relevance":"high","symbol":"","type":"company"},{"asset_class":"other","name":"San Francisco Chronicle","relevance":"medium","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"KRON4","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"ABC7 San Francisco","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"Yahoo","relevance":"low","symbol":"","type":"media_outlet"},{"asset_class":"other","name":"The San Francisco Standard","relevance":"low","symbol":"","type":"media_outlet"}],"event_type":"other","information_gaps":["The cleaned article text provided is largely non-informative (CSS/boilerplate), so the extraction relies on the supplied source summary and headline rather than direct article content.","No specific timeline (e.g., when flags will be removed) is included in the provided text.","No stated rationale for removing Pride flags is included in the provided text.","No details on whether other flags will also be removed beyond the headline/source summary wording are provided."],"key_facts":["Philz Coffee is reported to be removing Pride flags from all caf\u00e9 locations.","The removal is confirmed by Philz Coffee\u2019s CEO (per the provided source summary).","The coverage frames the move as part of a broader controversy around Philz Coffee\u2019s recent ownership change (private equity purchase mentioned).","A private equity purchase price of $145M for Philz Coffee is mentioned in the provided source summary."],"numeric_claims":[{"label":"Private equity purchase price","value":"$145M"}],"primary_claim":"Philz Coffee will remove Pride flags from all of its caf\u00e9s.","relevance_score":0.62,"sentiment":"mixed","source_quality":"high","summary":"Bay Area coffee chain Philz Coffee says it will remove Pride flags from all of its caf\u00e9 locations. The decision is attributed to CEO confirmation and is being discussed in the context of recent ownership changes.","topics":["LGBTQ+ Pride","store signage","corporate policy","controversy","Bay Area retail"]},"source":"San Francisco Chronicle","source_domain":"sfchronicle.com","source_url":"https://www.sfchronicle.com","summary":"Bay Area institution Philz Coffee to remove Pride flags from all caf\u00e9s San Francisco Chronicle Philz Coffee CEO confirms Pride flags will be removed from stores KRON4 Bay Area-based Philz Coffee to remove Pride flags, all other flags from its locations ABC7 San Francisco San Francisco Chain Philz Coffee Is Getting Roasted for Banning Pride Flags Yahoo Private equity bought Philz for $145M. Now it wants Pride flags down The San Francisco Standard","title":"Bay Area institution Philz Coffee to remove Pride flags from all caf\u00e9s - San Francisco Chronicle","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 13231 in events