@benn
Bennett Stancil
-
Published Home run example 1
SELECT * FROM benn.home_run_distance WHERE...'2013-04-06','2012-05-02') AND inning >= 9 -
Published Crunchbase Example 1
Shows funding rounds by industry in 2014. -
Published Days all leagues are active
This graphic shows a calendar of all MLB, NBA, NFL, and NHL games since 1970. -
Published test
SELECT a.date, a.nhl_count + a.nba_cou... GROUP BY 1 ) a ORDER BY 2 DESC -
Published Active Leagues by Day
Number of leagues active that day, out of NHL, NBA, MLB, and NFL. -
Published 30 Years of U.S. Pro Sports
This graphic shows a calendar of all MLB, NBA, NFL, and NHL games since 2005. -
Published test
SELECT * FROM benn.home_run_distance -
Published chart test
SELECT company_id, COUNT(*) AS users, ...nsion_users GROUP BY 1 ORDER BY 1 LIMIT 10 -
Published Mapping Home Runs (Highlighting "Lucky" HRs)
A graphic exploring the flights of 40,000 home runs over the last 7 years. Source: ESPN... -
Published Home Runs
SELECT *, ROW_NUMBER() OVER () AS id ... [2007,2007] ] {% endform %} -
Published Do VCs Have an Age Bias? (Only A Rounds)
What age founder do different VCs prefer? -
Published Founder Age by Industry
SELECT a.market, COUNT(a.person_permal...erson_permalink) >= 10 ORDER BY 3 LIMIT 100 -
Published NYC Taxis - White Population and Income
Shows the relationship between the percent of a Census tract's population that is white... -
Published NYC Taxis - Trip Origins
Shows the median number of dropoffs per 1000 people by Census tract. Census tracts are ... -
Published NYC Taxis - Dropoffs by Non-White Percent
Shows the median number of dropoffs per 1000 people by Census tract. Census tracts are ... -
Published NYC Taxis - Pickups by Non-White Percent
Shows the median number of pickups per 1000 people by Census tract. Census tracts are g... -
Published NYC Taxis - Map
Plots 50,000 random pickups from June 18, 2013. Pickups are colored by the racial compo... -
Published NYC Taxis - Time until next pickup
Shows dropoff timestamp, and timestamp of next pickup. Note that there are trips that b... -
Published NYC Taxis - Distance Collinearity
Shows the relationship between the size of tracts' non-white population and their dista... -
Published NYC Taxis - Model Inputs
Tract-by-tract characteristics, for simple regression model. Only includes tracts in Ne...