One of the real interests in this project is to see how wage patterns, as a surrogate for income patterns, changed over time. The QCEW site provides data from 2003 to 2012. In this recipe, we will look at the overall average annual pay by county for each of these years and create an animation that displays the changes in the pay pattern over this period.
For this recipe, we need to download the annual data for the years 2003 to 2011 from the BLS website, at
http://www.bls.gov/cew/datatoc.htm
. You will need to download the files corresponding to these years for the QCEW NIACS-based data files in the column CSVs Single Files-Annual Averages
. Store these files (which are compressed .zip
files) in the same location as the zipped 2012 data that you downloaded at the beginning of this project. Don't unzip them! You must also download and install the choroplethr
package using install.packages('chloroplethr')
, if you haven't already done...