@benn
Bennett Stancil
-
Published NYC Taxis - Trip Origins, After Dark
WITH trips AS ( SELECT taxi.hack_lice...21,22,23,0,1,2,3,4,5) GROUP BY 1 ORDER BY 1 -
Published NYC Taxis - Trip Origins, Black Only
WITH trips AS ( SELECT taxi.hack_lice...black_percent <= .2)) GROUP BY 1 ORDER BY 1 -
Published NYC Taxis - Dropoffs by Non-White Percent, at Night
SELECT ROUND(non_white_percent*20)/20 AS perc...,3,4,5,6,7 ) a GROUP BY 1 ORDER BY 1 -
Published NYC Taxis - Pickups by Non-White Percent, at Night
SELECT ROUND(non_white_percent*20)/20 AS perc...,3,4,5,6,7 ) a GROUP BY 1 ORDER BY 1 -
Published NYC Taxi - Dropoffs by Black Population Size
SELECT ROUND(black_percent*20)/20 AS percent_... ) a GROUP BY 1 ORDER BY 1 LIMIT 100 -
Published NYC Taxi - Pickups by Black Population Size
SELECT ROUND(black_percent*20)/20 AS percent_... ) a GROUP BY 1 ORDER BY 1 LIMIT 100 -
Published Funding Shares by Sector
Shows investments by sector as a percent of total dollar investment that year. Only sho... -
Published NYC Taxis - Dropoff Rates
SELECT ROUND(non_white_percent*20)/20 AS perc...,2,3,4,5,6 ) a GROUP BY 1 ORDER BY 1 -
Published NYC taxi - Pickup race
SELECT ROUND({{race}}*20)*5 AS racial_concent...re, two_or_more] ] {% endform %} -
Published NYC taxi - income buckts
SELECT pct, COUNT(*) AS trips, ...tude < -73 ) a GROUP BY 1 ORDER BY 1 -
Published NYC cabs - race
SELECT ROUND(pickup_pct * 20)/20::FLOAT AS ra...tude < -73 ) a GROUP BY 1 ORDER BY 1 -
Published NY Map - single cab
Map of NY -
Published NY Map - dot map
Map of NY -
Published NY Map
Map of NY -
Published NY Map - Census Tract
Map of NY -
Published Cohorted Retention Curves
Displays retention cohorting users by days since install. By lining up users from thei... -
Published Sour Patch Kids and the Mode Team
We eat a lot of Sour Patch Kids at Mode. You'd think we'd be better at knowing what the... -
Published Region Report
Full blog post available here: http://blog.modeanalytics.com/where-americans-think-they... -
Published test
SELECT a.investor_permalink, a.investo...Y 1,2 HAVING COUNT(a.person_permalink) >= 10 -
Published 10 Years of U.S. Pro Sports
This graphic shows a calendar of all MLB, NBA, NFL, and NHL games since 2005.