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

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