Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published Title 2 comments

SELECT DATE_TRUNC('day',month_day_year_of_dat...rality_comments fcc GROUP BY 1 ORDER BY 1
Published FCC All the Variables

SELECT msa.geo_id_2, msa.msa_name, ... ) isp ON isp.cbsa_code = msa.geo_id_2
Published FCC Comments by Sex

SELECT CASE WHEN male + female = 0 THEN 'no m...AND f.sex = 'female' ORDER BY zip ) x
Published FCC Dot Map over time

SELECT x.msa_name, x.id, x.popu..._2 = zip.cbsa_code GROUP BY 1,2,3 ) x
Published Testing

Shows the current top Hacker news posts. Data provided via Kimono Labs, updated once an...
Published FCC by Voting Record

SELECT fcc.msa_name, fcc.population, ... vote.cbsa_code ORDER BY fcc.population DESC
Published FCC by Metro Region

SELECT msa.msa_name, msa.bachelors_or_...a_code GROUP BY 1,2,3,4,5,6 ORDER BY 7 DESC
Published MSA Dots - Form Letters

SELECT msa.msa_name, msa.population, ... zip.cbsa_code GROUP BY 1,2 ORDER BY 2 DESC
Published FCC Comments by Day - Circles

SELECT DATE_TRUNC('day',month_day_year_of_dat...ality_comments GROUP BY 1,2 ORDER BY 3 DESC
Published FCC Comments by Day - Stacked bar

SELECT DATE_TRUNC('week',month_day_year_of_da...t_neutrality_comments GROUP BY 1 ORDER BY 1
Published FCC Comments Over Time - Stacked area

SELECT DATE_TRUNC('day',month_day_year_of_dat...t_neutrality_comments GROUP BY 1 ORDER BY 1
Published FCC Scatter

SELECT ctyname AS county_name, state, ... GROUP BY 1,2,3,4 ) z ORDER BY 6 DESC
Published FCC County Map via zip

SELECT ctyname AS county_name, county_...0 GROUP BY 1,2,3 ) z ORDER BY 5 DESC
Published comment map

SELECT c.county_code, d.popestimate201...nty = c.county_code::INT % 1000 GROUP BY 1,2
Published Cohorted Churn Analysis

This query shows an example of how to do churn analysis. The example presented here sho...
Published Making a Map - Step 3

Adding the map!
Published Making a Map - Step 2

Adding state codes.
Published Making a Map - Step 1

Aggregating your data.
Published Kimono - Top Hacker News

Shows the current top Hacker news posts. Data provided via Kimono Labs, updated once an...
Published State Codes

State names, abbreviations, and numeric codes.