Course Project - Developing Data Products

Bryan Scheiderer
October 30, 2016

View Historical Missouri Census Data

The shiny application will allow the user to view historical census data for the State of Missouri. The population data was collected from the decennial census reports from 1900 through 2010.

The application allows the user to control which decennial census date to use to create a map of the State of Missouri with each of the 114 counties plus the City of St. Louis shown individually on the map. The application can also be animated if the user selects this option, which will loop the map through all 12 of the census reports.

The Dataset

The data for the project was collected from the U.S. Census Bureau: http://www.census.gov/data.html

and the Missouri Census Data Center: http://mcdc.missouri.edu/trends/historical.shtml

The data set includes the county name (114 counties plus the City of St. Louis), 'fips' code for each county, and population data for 12 years (1900 - 2010).

    county  fips X1900 X1910 X1920 X1930 X1940 X1950 X1960 X1970 X1980
1    Adair 29001 21728 22700 21404 19436 20246 20105 20105 22472 24870
2   Andrew 29003 17332 15282 14075 13469 13015 11062 11062 11913 13980
3 Atchison 29005 16501 13604 13008 13421 12897  9213  9213  9240  8605
4  Audrain 29007 21160 21687 20589 22077 22673 26079 26079 25362 26458
5    Barry 29009 25532 23869 23473 22803 23546 18921 18921 19597 24408
6   Barton 29011 18253 16747 16879 14560 14148 11113 11113 10431 11292
  X1990 X2000 X2010
1 24577 24977 25607
2 14632 16492 17291
3  7457  6430  5685
4 23599 25853 25529
5 27547 34010 35597
6 11312 12541 12402

External Links

Here is this link to the shiny application at shinyapps.io: https://bdscheiderer.shinyapps.io/mopopulation/

Here is the link to the github.com repository with the ui.R, server.R, and data files: https://github.com/bdscheiderer/developingdataproducts/tree/gh-pages/mopopulation

Example Missouri Population Map (2010 Census Data)

This is an example of the type of 'choropleth' map that will be generated by the shiny application:

plot of chunk unnamed-chunk-2