You can find the basic video explaining the details here and the excellent ~40 minute explanation on the process here. This project is based on the details provided in the latter video. You can get the data files used in this project from CGP Grey's blog post.
This was created using R.
All data provided here as csv files were obtained from the CGP Grey's original spreadsheet. I cleaned the data up a little bit so that the files can be read easily.
-
census-apportionment.csv: Apportionment population and number of representatives by state based on the 2010 census taken on April 1, 2010. Apportionment population includes the resident population for the 50 states, as ascertained by the Twenty-Third Decennial Census under Title 13, United States Code, and counts of overseas U.S. military and federal civilian employees (and their dependents living with them) allocated to their home state, as reported by the employing federal agencies. The apportionment population excludes the population of the District of Columbia. -
current-population-estimate-by-state.csv: The current estimated population by state. -
census-and-current-population-estimate.csv: The census and annual estimates of the resident populations for major geographic areas and states in the United States from April 1, 2010 to July 1, 2018 released on December 2018 by U.S Census Bureau, Population Division. Note: The estimates are based on the 2010 Census and reflect changes to the April 1, 2010 population due to the Count Question Resolution program and geographic program revisions. See Geographic Terms and Definitions for a list of the states that are included in each region. All geographic boundaries for the 2018 population estimates series except statistical area delineations are as of January 1, 2018. For population estimates methodology statements, see here. -
census-priority-values.csv: The priority values for each state based on the 2010 census. -
work-check.csv: Not sure what this is. Sneaky little table. -
ca-vs-and-vs-ca-percentages.csv: Another sneaky table with percentages dangling without company. Probably used initially before creating the massive table. -
house-seats-table.csv: Probably a counter for simulation. Not really of much use for simulation by code -
population-in-numbers-percentages-and-percentiles.csv: This is the auxiliary table that contains population data and priority numbers. The fist two columns are percentages. -
house-and-electoral-college-rankings.csv: This is the main table used for all calculations in the second spreadsheet video. The versus columns are recorded as percentages.
- Plots of current population estimate overlaid on top of the map
- Visualization of the population growth over the last ten years based on census estimate
- Hovering on a state should provide additional information
- GIF/Video must pause
- Ability to select a single state or region to view population change
- Visualization of representation if seats were allocated simply based on population
- Visualization of representation based on the current system of allocation
- Visualization of priority values calculation?
- Visualization of win/losses over the course of simulations?
- Visualization of individual states' vs battles?
- District wise separation of population and separation for each state