Tuesday, December 6


Spreadsheet-Made Data Visualizations That Are Relatively Simple and Absolutely Effective
A non-comprehensive list of examples of powerful data storytelling in the wild that (likely) originated with a spreadsheet.
Carto, Political Boundaries, SQL, and Guns and Coffee
Using Carto and SQL Joins to make a choropleth of Starbucks and gunshops by zip code


In class tutorial:

Carto, SQL, and Political shapefiles

Things to download for Carto work:

Copy-and-paste the following URLs (from this subset of data) and import into your Carto Dataset maker:

Later on in the lesson, we will use this lookup table, which I name us_state_codes, to join the shapefile and congressmembers data together. It's going to feel like an annoyingly elaborate detail, but that's because we live in a world where the Census shapefile doesn't use postal abbreviations (e.g. CA), and the Congressmembers datafile doesn't use FIPS code 06

The key thing in uploading this file to Carto is that, in the Connect Dataset pop-up, you should uncheck the box in the lower-left corner corner to prevent Carto from auto-converting text strings into numbers. We want our fips column to be '06' and not the integer 6: