Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published First Name of Nominees

SELECT LEFT(actor,1) AS first_letter_of_first...M benn.oscar_nominees GROUP BY 1 ORDER BY 1
Published asdf

SELECT y.variable, y.none, y.no... ) t ) x ) y ORDER BY 9 DESC
Published Success of Previous Companies

SELECT CASE WHEN z.companies_founded < 10 THE...01-01' ) z GROUP BY 1,2 ORDER BY 1,2
Published Previous Company Success

SELECT CASE WHEN previous_rounds IS NULL THEN... 1,2,3,4,5 ) z GROUP BY 1 ORDER BY 1
Published Above and Below Average Age

SELECT CASE WHEN category IN ('actor in a lea... ) a ) a GROUP BY 1 ORDER BY 1
Published Difference in Actual and Expected Age

SELECT ROUND((actual - expected)/4)*4 AS diff... WHERE a.year >= 1990 GROUP BY 1 ORDER BY 1
Published Winner Age Rank

SELECT CASE WHEN category IN ('actor in a lea...a ) a WHERE year >= 1990 GROUP BY 1
Published Oscar Career

SELECT --ROUND(first_year/10), AVG(CAS...BY 1,2 ) a --GROUP BY 1 --ORDER BY 1
Published Big result

SELECT b.base, y.group_name, CO...ear >= b.base - 9 GROUP BY 1,2 ORDER BY 2,1
Published jake_test

SELECT * FROM benn.playoff_results_viz
Published Age and Experience - Individual

SELECT CASE WHEN ROUND(age/10)*10 > 59 THEN 5....age <= 100 GROUP BY 1 ORDER BY 1 LIMIT 100
Published gradient

SELECT DATE_TRUNC('day',created_at) AS day, ....fake_dimension_users GROUP BY 1 ORDER BY 1
Published World Cup Groups

A visualization of World Cup groups, and how teams fare in "Groups of Death." Full blo...
Published NCAA Check - Chart 4

Comparison of models by game
Published NCAA Check - Chart 3

Comparison of model results
Published Rollup Example

SELECT drp.time_id, COUNT(*) FROM be...me_id <= '2014-04-01' GROUP BY 1 ORDER BY 1
Published D3 U.S. Map

Cloned from: "D3 U.S. Map" by @benn
Published Simple Event Concurrency

Event concurrency with fewer events
Published Sample Bar Chart

Simple d3 bar chart
Published Olympic Visualization

Graphic on the size of Olympians