Saturday, July 12, 2014

US Education Data

I spent three frustrating days trying to find data that one would think would be readily available--any kind of education data to compare states going back before 1980.   In fact, I had a hard time finding a good way to compare states prior to a decade or so ago, since standard metrics have changed multiple times.  Even contacting federal education data centers, I was given disappointing answers.  While I thought the Census factfinder web site would be a reasonable resource, their education data only goes back to 2005, prior to which it becomes very much more sparse.  While other resources for education exist on the Census site, much of the pre-1990s data is simply poorly scanned pdf files from the original paper Census books!!  Below is data that I collected for a separate research project (time-series analysis of variables related to political polarization)--I post it simply for anybody else for whom it may prove useful, without having to manually enter page after page of pdf-scanned census data from a different book for each year.  The top table is the original data that I compiled, while the 2nd table contains mostly interpolated data for my other research project.  The easiest data for me to gather consistently was the percent of the population that had a bachelor's degree or higher. Note that Washington DC and Louisiana are not in this dataset--they are absent from the polarization comparison data I was using (but present in the original education data). Due to the limitations of the "blogger" web site, the table likely will look awkward, extending far into the border on the right-hand side of the screen (at least it does on my Chrome browser).

ORIGINAL DATA1970197719801981198519871989199019941998200020022004200520062009
Alabama7.812.211.615.715.220.61922.722.321.420.822
Alaska14.121.123.42324.824.224.725.625.527.227.726.6
Arizona12.617.422.220.319.921.923.526.32825.524.525.6
Arkansas6.710.814.813.312.416.216.718.318.818.91918.9
California13.415.719.621.324.723.526.423.424.726.426.627.931.729.529.829.9
Colorado14.923272728.53432.735.735.535.536.435.9
Connecticut13.720.727.527.22731.431.432.634.5353635.6
Delaware13.117.519.421.421.925.12529.526.927.526.228.7
Florida10.31114.914.816.619.719.818.32122.522.325.72625.127.225.3
Georgia9.212.514.618.41719.118.219.324.520.724.32527.627.228.127.5
Hawaii1420.323.922.924.32426.226.826.627.932.329.6
Idaho1015.817.117.721.820.321.720.923.823.325.123.9
Illinois10.314.516.217.520.220.221.12123.525.826.127.327.429.231.230.6
Indiana8.39.912.510.915.213.313.815.61517.719.423.721.121.221.922.5
Iowa9.113.917.116.919.320.321.223.124.323.824.725.1
Kansas11.41722.321.122.728.525.829.13028.231.629.5
Kentucky7.211.114.913.616.820.117.121.62119.320.221
Maine8.414.418.518.821.219.222.923.824.225.726.926.9
Maryland13.920.427.426.52631.831.437.635.234.635.735.7
Massachusetts12.614201926.126.528.127.230.13133.234.336.736.940.438.2
Michigan9.410.614.315.316.116.517.317.419.122.121.822.524.424.726.124.6
Minnesota11.117.421.521.826.33127.430.532.530.633.531.5
Mississippi8.112.315.614.719.819.516.920.920.118.721.119.6
Missouri913.113.91515.117.921.617.821.322.421.626.728.12424.325.2
Montana1117.521.119.824.323.924.423.625.526.425.127.4
Nebraska9.615.519.718.921.120.923.727.124.827.227.227.4
Nevada10.814.417.215.316.920.618.222.124.520.720.821.8
NewHampshire10.918.223.524.426.226.628.730.135.431.832.132
NewJersey11.813.418.317.921.723.325.724.928.130.129.831.434.634.235.634.5
NewMexico12.717.620.620.424.123.123.525.425.125.126.725.3
NewYork11.913.617.917.822.123.222.823.125.126.827.428.830.631.232.232.4
NorthCarolina8.510.913.216.717.216.618.317.41923.322.522.423.425.125.626.5
NorthDakota8.414.822.218.119.922.52225.325.225.428.725.8
Ohio9.310.913.713.916.11517.61719.821.521.124.524.623.223.324.1
Oklahoma1015.117.117.820.320.520.320.422.922.522.922.7
Oregon11.817.920.220.624.527.725.127.125.927.728.329.2
Pennsylvania8.79.413.614.614.617.218.617.919.522.122.426.125.325.726.626.4
RhodeIsland9.415.420.221.323.927.825.630.127.229.330.930.5
SouthCarolina913.416.616.61821.320.423.324.922.922.624.3
SouthDakota8.61418.417.217.321.821.523.625.524.725.325.1
Tennessee7.912.615.71616.216.919.621.524.321.82223
Texas10.912.816.917.319.819.821.720.320.823.323.226.224.525.225.525.5
Utah1419.924.222.322.827.626.126.830.827.82728.5
Vermont11.51926.724.327.727.129.430.834.232.53433.1
Virginia12.314.319.119.223.123.527.324.526.430.329.534.633.133.232.134
Washington12.71924.122.925.128.127.728.329.93031.431
WestVirginia6.810.411.112.311.416.314.815.915.31715.917.3
Wisconsin9.814.818.917.720.922.322.424.725.62524.625.7
Wyoming11.817.221.918.816.819.821.9 19.622.523.220.823.8


INTERPOLATED DATA1970.01972.01974.01976.01977.01978.01980.01981.01982.01983.01984.01985.01986.01987.01988.01989.01990.01992.019941996.01998200020022004200520062008 (est)20092010
Alabama7.88.28.79.19.310.812.221.015.810.513.316.016.016.013.811.615.715.515.217.920.619.022.722.321.420.821.222.024.8
Alaska14.114.114.014.014.017.621.121.516.110.816.121.522.022.523.023.423.023.924.824.524.224.725.625.527.227.727.326.624.5
Arizona12.613.213.714.314.616.017.415.411.67.714.421.019.017.019.622.220.320.119.920.921.923.526.328.025.524.524.925.623.7
Arkansas6.77.27.88.38.69.710.89.47.14.79.414.012.511.012.914.813.312.912.414.316.216.718.318.818.919.019.018.922.5
California13.414.114.715.415.717.719.621.316.010.717.724.724.123.525.026.423.424.124.725.626.426.627.931.729.529.829.829.930.7
Colorado14.916.418.019.520.321.723.027.020.313.519.625.726.427.027.027.027.027.828.531.334.032.735.735.535.536.436.235.936.1
Connecticut13.714.615.516.416.818.820.725.018.812.520.027.526.826.026.827.527.227.127.029.231.431.432.634.535.036.035.935.639.5
Delaware13.113.714.214.815.116.317.518.213.79.114.018.818.818.719.119.421.421.721.923.525.125.029.526.927.526.227.028.731.0
Florida10.310.510.710.911.013.014.914.811.17.412.016.618.219.719.819.818.319.721.021.822.522.325.726.025.127.226.625.325.6
Georgia9.210.111.112.012.513.614.618.413.89.213.117.018.119.118.718.219.321.924.522.620.724.325.027.627.228.127.927.527.9
Hawaii14.014.715.416.116.418.420.320.015.010.016.022.021.521.022.523.922.923.624.324.224.026.226.826.627.932.331.429.628.4
Idaho10.011.112.313.414.014.915.817.012.88.512.616.717.418.017.617.117.719.821.821.120.321.720.923.823.325.124.723.922.6
Illinois10.311.512.713.914.515.416.217.513.18.814.520.220.220.220.721.121.022.323.524.725.826.127.327.429.231.231.030.637.0
Indiana8.38.89.39.810.011.312.511.08.35.510.315.014.013.013.413.815.615.315.016.417.719.423.721.121.221.922.122.526.9
Iowa9.19.710.210.811.112.513.914.510.97.311.916.516.316.016.617.116.918.119.319.820.321.223.124.323.824.724.825.131.4
Kansas11.412.012.513.113.415.217.014.611.07.314.421.519.317.019.722.321.121.922.725.628.525.829.130.028.231.630.929.532.8
Kentucky7.27.68.08.48.69.911.19.47.14.79.915.013.011.013.014.913.615.216.818.520.117.121.621.019.320.220.521.024.7
Maine8.49.09.710.310.612.514.414.911.27.512.818.217.817.317.918.518.820.021.220.219.222.923.824.225.726.926.926.928.4
Maryland13.914.715.416.216.618.520.421.215.910.618.225.825.324.726.127.426.526.326.028.931.831.437.635.234.635.735.735.737.7
Massachusetts12.613.013.413.814.017.020.019.014.39.517.826.126.326.527.328.127.228.730.130.631.033.234.336.736.940.439.738.248.0
Michigan9.49.710.110.410.612.514.315.311.57.711.916.116.316.516.917.317.418.319.120.622.121.822.524.424.726.125.624.628.3
Minnesota11.111.812.513.213.615.517.417.813.48.915.121.220.820.320.921.521.824.126.328.731.027.430.532.530.633.532.831.537.5
Mississippi8.18.59.09.49.611.012.310.47.85.210.415.513.812.013.815.614.717.319.819.719.516.920.920.118.721.120.619.620.3
Missouri9.010.211.312.513.113.513.915.011.37.511.315.116.517.919.821.617.819.621.321.922.421.626.728.124.024.324.625.230.7
Montana11.011.812.613.413.815.717.518.013.59.014.319.519.118.819.921.119.822.124.324.123.924.423.625.526.425.125.927.430.9
Nebraska9.610.411.212.012.414.015.513.610.26.813.219.517.816.017.919.718.920.021.121.020.923.727.124.827.227.227.327.433.2
Nevada10.811.211.612.012.213.314.412.89.66.411.216.015.014.015.617.215.316.116.918.820.618.222.124.520.720.821.121.821.0
NewHampshire10.911.812.713.614.016.118.219.014.39.516.323.022.522.022.823.524.425.326.226.426.628.730.135.431.832.132.132.035.7
NewJersey11.812.312.713.213.415.918.317.913.49.015.321.722.523.324.525.724.926.528.129.130.129.831.434.634.235.635.234.541.2
NewMexico12.713.414.014.715.016.317.616.012.08.014.320.519.318.019.320.620.422.324.123.623.123.525.425.125.126.726.225.319.6
NewYork11.912.412.913.413.615.817.917.813.48.915.522.122.723.223.022.823.124.125.126.026.827.428.830.631.232.232.332.441.3
NorthCarolina8.59.29.910.610.912.113.216.712.58.412.817.216.916.617.518.317.418.219.021.223.322.522.423.425.125.625.926.528.7
NorthDakota8.49.19.810.510.812.814.812.29.26.113.120.017.515.018.622.218.119.019.921.222.522.025.325.225.428.727.725.835.5
Ohio9.39.810.210.710.912.313.713.910.47.011.516.115.615.016.317.617.018.419.820.721.521.124.524.623.223.323.624.129.3
Oklahoma10.010.911.912.813.314.215.117.012.88.512.416.317.218.017.617.117.819.120.320.420.520.320.422.922.522.922.822.723.3
Oregon11.813.014.215.416.017.017.920.015.010.014.719.320.221.020.620.220.622.624.526.127.725.127.125.927.728.328.629.229.5
Pennsylvania8.78.99.19.39.411.513.614.611.07.311.014.615.917.217.918.617.918.719.520.822.122.426.125.325.726.626.526.434.5
RhodeIsland9.410.010.711.311.613.515.415.811.97.913.619.218.818.319.320.221.322.623.925.927.825.630.127.229.330.930.830.535.6
SouthCarolina9.09.510.010.510.712.113.416.712.58.412.316.316.015.716.216.616.617.318.019.721.320.423.324.922.922.623.224.327.1
SouthDakota8.69.310.010.711.012.514.012.09.06.011.817.515.814.016.218.417.217.317.319.621.821.523.625.524.725.325.225.129.8
Tennessee7.98.59.29.810.111.412.613.510.16.811.115.515.315.015.415.716.016.116.216.616.919.621.524.321.822.022.323.026.7
Texas10.911.412.012.512.814.916.917.313.08.714.219.819.819.820.821.720.320.620.822.123.323.226.224.525.225.525.525.526.0
Utah14.014.715.416.116.418.219.920.015.010.016.022.021.521.022.624.222.322.622.825.227.626.126.830.827.827.027.528.528.5
Vermont11.512.413.414.314.816.919.016.212.28.116.825.522.319.022.926.724.326.027.727.427.129.430.834.232.534.033.733.134.3
Virginia12.312.913.414.014.316.719.119.214.49.616.423.123.323.525.427.324.525.526.428.430.329.534.633.133.232.132.734.037.5
Washington12.713.514.215.015.417.219.019.014.39.515.521.520.920.322.224.122.924.025.126.628.127.728.329.930.031.431.331.030.7
WestVirginia6.87.48.18.79.09.710.411.08.35.58.110.711.412.011.611.112.311.911.413.916.314.815.915.317.015.916.417.322.8
Wisconsin9.810.411.111.712.013.414.813.09.86.512.518.516.815.017.018.917.719.320.921.622.322.424.725.625.024.625.025.729.7
Wyoming11.812.413.113.714.015.617.215.011.37.514.020.518.817.019.521.918.817.816.818.319.821.919.622.523.220.821.823.825.0

No comments:

Post a Comment