Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published Signup Funnels

This report shows how to measure a simple signup funnel based on a year of sample signu...
Published The Age of Congressional Representatives

A map showing the average age of members of Congress by state.
Published Charting

SELECT * FROM ( SELECT DATE_TRUNC('day',dis...a_spending > 0 ANd republican_spending > 0
Published testing

SELECT l.county_code AS county_id, COU....recipient_city) GROUP BY 1 ORDER BY 2 DESC
Published line chart hovers

SELECT DATE_TRUNC('day',date) AS day, ...n.home_run_distance GROUP BY 1 ORDER BY 1
Published Crunchbase example 3

A county map of startup density
Published Holidays example 1

'Merica.
Published FiveThirtyEight example 1

7-1
Published UFO example 1

The first reported UFO sighting.
Published Crunchbase Example 2

A multi-platform technology based on a proprietary universal compression algorithm.
Published FEC Data example 4

Huh?
Published FEC Data example 2

Campaign spending at liquor stores.
Published FEC Data example 1

Herman Cain on Herman Cain.
Published FEC Data example 3

Fast food spending by candidate.
Published bar chart issue

SELECT hitter_team, hitter, inn... WHERE hitter_team IN ('OAK','ATL') LIMIT 5
Published Most Popular Days to Buy Marijuana by State

Measured by total volume of sales in oz. Data on transactions from Jan. 2012 to Oct. 20...
Published Marijuana example 1

SELECT * FROM benn.marijuana_transactions ...d = '2012-11-22' AND quantity = 'an ounce'
Published U.S. Sports Game example 2

SELECT * FROM benn.professional_sports_game...'Division' AND opponent = 'St. Louis Rams'
Published U.S. Sports Games example 1

SELECT * FROM benn.professional_sports_game...D opponent = 'CLE' AND date = '1995-10-28'
Published Holidays example 2

SELECT * FROM reference_lookups.holidays_b...WHERE holiday ILIKE 'second day of christmas'