Queries ran in the past hour4,546
Datasets updated in the past hour
Vay provides a production-grade API that allows for scalable and extensible integrations. Because we factor out unnecessarily complexity, you can get started with the Vay API in seconds.
Create dynamically updating webpages powered by open data, without writing a single line of code.
SELECT COUNT(victim_race_0) AS agg, CASE WHEN victim_race_0 = 'W' THEN 'White' WHEN victim_race_0 = 'B' THEN 'Black' WHEN victim_race_0 = 'H' THEN 'Hispanic' ELSE 'Other' END AS victim_race FROM vay.`san-diego/hate-crimes/5c53fd7a.csv` WHERE `year` = 2019 GROUP BY victim_race, `year` ORDER BY agg desc