Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published Retrosheet - Run Differential

Shows relationship between run differential in wins in first 30 games and final win total
Published Box Plot Example

SELECT category, AVG(CASE WHEN tile = ... ) a GROUP BY 1 HAVING COUNT(*) > 250
Published NCAA Check - Chart 1

FiveThirtyEight's predictions and results
Published Billboard - Chance of Return By Number of Songs in Debut Year

SELECT --(z.start_position - ((z.start_positi... ) z GROUP BY 1 ORDER BY 1 LIMIT 100
Published Billboard - Number of Songs by Artists Appearing 5+ Times

SELECT COUNT(z.song_name) AS all_songs, ...s.artist GROUP BY 1,2,3 ) z LIMIT 100
Published By Previous Experience - Companies

SELECT CASE WHEN z.previous_companies > 3 THE... ) z GROUP BY 1 ORDER BY 1 LIMIT 100
Published Company Success by Experience and Age

SELECT ROUND(z.age/5)*5 AS age, AVG(CA... 20 AND ROUND(z.age/5)*5 <= 55 ORDER BY 1
Published disasters

SELECT * FROM benn.global_natural_disasters_2
Published Avg Age of Nominees

SELECT year, AVG(CASE WHEN category = ... a WHERE a.age < 100 GROUP BY 1 ORDER BY 1
Published U.S. Insurance Coverage

SELECT * FROM benn.insurance_data_trim
Published Time to First Nomination

SELECT x.first_nom - x.first_appearance AS ti...irst_appearance >= 0 GROUP BY 1 ORDER BY 1
Published Founder Age

SELECT CASE WHEN ROUND(age/5)*5 > 55 THEN 55 ....age <= 100 GROUP BY 1 ORDER BY 1 LIMIT 100
Published San Francisco Map

Map of San Francisco, with points plotted on map. Includes hovers and allow for points ...
Published Team Penalties

SELECT * FROM benn.nfl_penalties
Published benn!

SELECT team, wins_b + wins_a AS wins, ...s_b AS losses FROM benn.playoff_results_viz
Published Billboard - Chance of Return by Time Absent

--- WHAAAT IS GONNA HAPPPPEN SELECT CASE WHE... ) x GROUP BY 1,2 ORDER BY 1,2 LIMIT 100
Published Playoff Records

SELECT * FROM benn.playoff_results_viz ORD...['Loses', 'loss_a + loss_b']] {% endform %}
Published SNAP Map

SELECT * FROM benn.snap_vote
Published Billboard - Chance of Return By Debut Position

SELECT (z.first_rank - ((z.first_rank::INT - ... ) z GROUP BY 1 ORDER BY 1 LIMIT 100
Published Billboard - Artists by Number of Years They Appear

SELECT y.years, COUNT(y.artist) AS art... ) y GROUP BY 1 ORDER BY 1 LIMIT 100