There are two tables of data in this dataset to download in the folder Dataset. The other table is created in the query file CongressQueryProject.sql (first statement in the file)
This folder contains data behind the story We’ve Never Seen Congressional Resignations Like This Before.
congressional_resignations.csv contains information about the 615 members of Congress who resigned or were removed from office from March 4, 1901 (the first day of the 57th Congress) through January 15, 2018, including the resigning member’s party and district, the date they resigned, the reason for their resignation and the source of the information about their resignation.
The reasons are categorized as follows:
| Code | Category |
|---|---|
X |
Unwanted sexual contact |
A |
Consensual sex scandals |
B |
Other scandals |
C |
Other office |
D |
Private sector |
E |
Health/family |
F |
Other |
G |
Left early |
H |
Military service |
I |
Election overturned |
congress-age.csv has an entry for every member of congress who served at any point during a particular congress between January 1947 and Februrary 2014.
House membership data is from the @unitedstates project, with Congress meeting numbers added using code from GovTrack:
- https://github.com/unitedstates/congress-legislators
- https://github.com/govtrack/govtrack.us-web/blob/master/us.py#L93
Senate membership data is mostly from the New York Times Congress API combined with birthdays from @unitedstates. (It does not include the birthday of Sen. Elmer Thomas.)
In addition, I added an incumbent field to each record.