Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published Retention Model (Adjustable)

Shows retention rates by how often a user takes an action in their first week. Red user...
Published District to Zip Code lookups

SELECT * FROM benn.congressional_district_zipcode_lookup ORDER BY 1,2
Published Accessing data in the presentation

SELECT * FROM benn.fake_fact_events
Published FCC Zip

SELECT fcc.*, rep.alignment AS rep_ali...r = 'senate' AND sen2.seniority = 'junior'
Published Activities at State and National Parks - Old

An interactive map exploring the activities at all state and national parks in the Unit...
Published Untitled Query

SELECT * FROM benn.nfl_touchdowns
Published Common Table Expression Example

An example of how to use CTEs on fake event data.
Published Demo Report

SELECT DATE_TRUNC('day',occurred_at) AS day, ...benn.fake_fact_events GROUP BY 1 ORDER BY 1
Published Comments by Rep Alignment

SELECT fcc.geography, CASE WHEN alignm... = 'house' ORDER BY comments_per_capita DESC
Published Untitled Query

SELECT * FROM benn.nfl_touchdowns
Published Zipcode dots

SELECT zip.zipcode, lat, long, ... ON zip.zipcode = fcc.zip GROUP BY 1,2,3,4
Published Oscar Example

SELECT c.cast_id, c.cast_name, ...UNT(DISTINCT m.film_id) >= 3 ORDER BY 5 DESC
Published working fcc

SELECT fcc.*, CASE WHEN rep.alignment ...r = 'senate' AND sen2.seniority = 'junior'
Published test

SELECT * FROM benn.fake_fact_events
Published what

SELECT fcc.*, rep.alignment AS rep_ali...r = 'senate' AND sen2.seniority = 'junior'
Published Parameter Example

SELECT user_id, COUNT(*) AS events F... type: text default: "1,2" {% endform %}
Published fb td

SELECT tds.season, w.week_number, ...a') AND tds.season >= 2000 GROUP BY 1,2,3
Published dot td

SELECT tds.season, tds.date, p.... ON p.player_id = tds.player_id ORDER BY 2
Published FCC Comment Congressional Map

Congressional Districts by Comments-per-Capita. Data sources: Bayes Impact (FCC comment...
Published Geo Test

SELECT 1