As a way to simplify learning new SQL syntax, this is a very simple, very small database of people who just go by their first names, and live in a world in which they own pets and homes.

Selected demographic data, including population by ethnicity and wealth, for U.S. states, places, and congressional districts. Note that the places table doesn’t have complete data.

Earthquakes within contiguous United States, from 1995 through 2015, that have a magnitude of at least 3.0 as measured by the U.S. Geological Survey

A single-table, flattened version of the health department’s food inspection data. This is what Yelp uses to tie health scores to business listings.

The most popular last names and their racial breakdowns as catalogued by the U.S. Census in 2000.

Officer-involved shootings as disclosed by the Dallas Police Department. Includes separate tables for officer and subject/suspect information.

Inmates currently on Florida’s death row, with basic biographical information.

Anonymized salary and benefits information for city officials in San Mateo, Santa Clara, and San Francisco counties, as released by the California state controller.

Incidents reported to the San Francisco Police Department from 2012 through 2015.

The San Francisco Dept. of Public Health’s database of eateries, inspections of those eateries, and violations found during the inspections.

Baby names as recorded for Social Security Number applications, counted by sex, nationwide, from 1980 through 2015.

Baby names as recorded for Social Security Number applications, counted by sex, for each state and nationwide, for 2015. Similar to the nationwide 1980 to 2015 data, but just for 2015. However, you can use it to compare name popularity across states.

A database containing geospatial information, as well as SAT average scores and Free-or-Reduced-Price Meal eligibility data, for California schools.

This dataset is a transformation of the data in the 2015 Social Security babyname dataset. Instead of having a M and F entry for Leslie, this dataset has one entry for every name, with two additional fields that specify what that name’s majority gender is (and by how much).

This is a useful dataset for joining on other tables with names to get a gender calculation. This dataset includes name data for each state and nationwide.

This database contains a copy of the Gendered Baby Names 2015 dataset (just nationwide, not each state), as well as a hand-copied spreadsheet I made of the Hollywood Reporter’s 100 Most Powerful People in Entertainment feature. Useful for an exercise in learning real-world messy JOINs.