Tuesday, October 18
No homework for Thursday. Probably a bit of study work for Tuesday
Ignore the current homepage
The U.S. Census records such an incredible, intimidating volume of data points about American life that is is hard to know where to begin. This guide aims to explain how Census data is organized, how to find important and interesting data points, and how the data is distilled and displayed by journalism outlets.
This this first unit of SQL lessons, we cover the syntax and concepts to fetch, sort, and -- as we've done using spreadsheet functions -- transform data values.
In class work
From the data starterpacks page, please download the following SQLite databases: