Skip to content

Instantly share code, notes, and snippets.

@SHewitt95

SHewitt95/Race_Education_Count.csv

Created April 4, 2016 13:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save SHewitt95/20b791d3c2e27a05ff98289f1b3195a9 to your computer and use it in GitHub Desktop.
Save SHewitt95/20b791d3c2e27a05ff98289f1b3195a9 to your computer and use it in GitHub Desktop.
Download ZIP
CSV Data for Project
Raw
Race_Education_Count.csv
Race 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
White, non-Hispanic 6709 6921 7004 7129 7228 7393 7200 7533 7894 7983 7663 7882 7189
Black, non-Hispanic 1182 1226 1196 1190 1201 1259 1291 1340 1311 1574 1611 1571 1578
Hispanic 899 931 979 1115 1221 1215 1182 1375 1338 1465 1814 2079 2403
Asian, non-Hispanic 631 707 789 682 692 684 657 651 640 756 807 729 883
Raw
Race_Education_Data_Male_Female.csv
Sex 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Male 32.6 33.6 33.7 34.3 34.7 35.3 34.1 35.5 37.0 38.4 38.3 39.1 37.6
Female 38.4 39.0 39.7 41.3 41.2 42.5 40.6 42.1 42.3 44.2 44.1 44.9 44.5
Raw
Race_Education_Data_Male_Female_Race.csv
Gender Race_Ethnicity 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Female Asian, non-Hispanic 52.8 58.9 61.9 60.4 57.7 58.8 58.3 56.8 63 65.2 65.8 60.3 60.4
Male Asian, non-Hispanic 59.0 63.7 59.9 62.2 63.5 63.1 58.4 57.7 55.3 65.2 61.3 59.9 59.3
Female Black, non-Hispanic 35.2 35.5 36.9 36 36.6 37.6 36.9 34 34.2 41.9 41.4 39.9 38.7
Male Black, non-Hispanic 25.1 26.7 26.3 28.2 26.5 28.2 28.1 32.2 29.7 33.2 35.2 34.0 33.9
Female Hispanic 25.4 26.1 24.4 29.4 28.2 29.5 27.6 33 28.9 31 36.1 39.4 41.7
Male Hispanic 18.5 17.4 16.2 18.3 21.7 20.7 20.0 20.7 23.0 24.2 27.9 31.0 33.5
Female White, non-Hispanic 41.3 41.9 42.8 44.5 45 46.1 44.1 45.7 46.9 47.7 46.1 47.1 46
Male White, non-Hispanic 36.2 37.2 38.9 38.5 38.4 39.4 37.9 39.6 41.7 42.3 40.6 42.4 38.3
Raw
Race_Education_Data_Total.csv
Years 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Total 35.5 36.3 36.7 37.8 38.0 38.9 37.3 38.8 39.6 41.3 41.2 42.0 41.0
Raw
Race_Gender_Education_Data.csv
Gender Race_ethnicity 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012
Female Asian, non-Hispanic 52.8 58.9 61.9 60.4 57.7 58.8 58.3 56.8 63 65.2 65.8 60.3 60.4
Female Black, non-Hispanic 35.2 35.5 36.9 36 36.6 37.6 36.9 34 34.2 41.9 41.4 39.9 38.7
Female Hispanic 25.4 26.1 24.4 29.4 28.2 29.5 27.6 33 28.9 31 36.1 39.4 41.7
Female White, non-Hispanic 41.3 41.9 42.8 44.5 45 46.1 44.1 45.7 46.9 47.7 46.1 47.1 46
Female Pacific Islander, non-Hispanic 0.0 0.0 0.0 34.5 57.6 65.8 25.8 37.3 32.1 35.6 28.5 42.7 40.3
Female American Indian/Alaska Native, non-Hispanic 20.5 24.1 26.9 15.6 28.1 29.5 35.9 34.5 24.3 20.8 36.6 24.4 27.6
Female Two or more races, non-Hispanic 0.0 0.0 0.0 43.3 33.4 46.7 38.5 41.6 48.7 41.0 35.8 46.0 43.6
Male Asian, non-Hispanic 59.0 63.7 59.9 62.2 63.5 63.1 58.4 57.7 55.3 65.2 61.3 59.9 59.3
Male Black, non-Hispanic 25.1 26.7 26.3 28.2 26.5 28.2 28.1 32.2 29.7 33.2 35.2 34.0 33.9
Male Hispanic 18.5 17.4 16.2 18.3 21.7 20.7 20.0 20.7 23.0 24.2 27.9 31.0 33.5
Male White, non-Hispanic 36.2 37.2 38.9 38.5 38.4 39.4 37.9 39.6 41.7 42.3 40.6 42.4 38.3
Male Pacific Islander, non-Hispanic 0.0 0.0 0.0 51.5 51.3 41.7 55.4 37.0 0.0 31.4 40.4 33.1 63.3
Male American Indian/Alaska Native, non-Hispanic 12.8 21.9 20.1 20.3 20.5 25.7 18.1 11.8 18.7 38.7 45.5 22.6 28.1
Male Two or more races, non-Hispanic 0.0 0.0 0.0 39.7 39.9 36.9 38.6 36.5 42.9 37.5 41.2 32.3 35.4
Raw
state_costs.csv
State cost_2year_0405 cost_2year_1112 cost_4year_0405 cost_4year_1112 percent_change_2year percent_change_4year
Alabama 3437.42 4235.99 5682.84 8451.90 23.23 48.73
Alaska 1.00 1.00 4328.28 5762.42 0.00 33.13
Arizona 1755.25 2272.22 5138.50 9966.72 29.45 93.96
Arkansas 2361.34 2813.08 5772.30 7028.99 19.13 21.77
California 1018.12 1182.06 5285.92 9436.43 16.10 78.52
Colorado 2794.80 3585.27 4703.78 8315.63 28.28 76.79
Connecticut 3031.69 3686.68 7983.69 9736.43 21.60 21.95
Delaware 2555.39 3259.91 8352.89 11026.24 27.57 32.01
District of Columbia 1.00 1.00 3175.33 7394.49 0.00 132.87
Florida 2242.89 3153.22 3848.20 5940.94 40.59 54.38
Georgia 2614.61 3301.11 4298.04 7709.28 26.26 79.37
Hawaii 1837.16 3132.09 4266.54 8839.58 70.49 107.18
Idaho 2265.57 2948.29 4524.85 6002.21 30.13 32.65
Illinois 2507.51 3329.63 8182.78 12285.42 32.79 50.14
Indiana 3255.98 3737.39 7367.53 8813.18 14.79 19.62
Iowa 3679.35 4342.68 6813.11 7988.16 18.03 17.25
Kansas 2226.51 2495.11 5345.14 7309.98 12.06 36.76
Kentucky 3490.35 4279.30 5640.00 8423.38 22.60 49.35
Louisiana 2189.97 2853.22 4453.03 5541.64 30.29 24.45
Maine 3269.84 3516.61 7057.56 9893.83 7.55 40.19
Maryland 3752.44 3916.97 8530.56 8409.65 4.38 -1.42
Massachusetts 4235.04 5088.47 8863.21 10737.86 20.15 21.15
Michigan 2513.81 3022.23 7930.77 11451.95 20.23 44.40
Minnesota 4781.90 5451.85 8143.72 10582.57 14.01 29.95
Mississippi 1948.04 2329.26 5028.87 5992.71 19.57 19.17
Missouri 2711.63 2890.19 7477.15 8118.09 6.58 8.57
Montana 2981.28 3226.11 5629.92 6212.43 8.21 10.35
Nebraska 2221.47 2631.38 5947.45 7295.19 18.45 22.66
Nevada 2003.48 2654.62 3621.39 6383.56 32.50 76.27
New Hampshire 5897.05 7102.94 10187.53 14262.92 20.45 40.00
New Jersey 3530.67 4342.68 10053.96 12707.96 23.00 26.40
New Mexico 1310.45 1583.48 4925.55 5741.29 20.83 16.56
New York 4122.89 4492.68 6234.74 6553.63 8.97 5.11
North Carolina 1505.76 2186.66 4493.35 6009.61 45.22 33.74
North Dakota 3780.16 4147.25 5803.80 7247.66 9.71 24.88
Ohio 4032.91 4175.77 10377.93 9980.45 3.54 -3.83
Oklahoma 2653.67 3194.42 4454.29 6413.14 20.38 43.98
Oregon 3607.53 4247.61 6578.74 8444.51 17.74 28.36
Pennsylvania 3613.93 4148.31 10394.18 12766.06 14.79 22.82
Puerto Rico 1.00 1.00 1479.30 2760.26 0.00 86.59
Rhode Island 2910.72 3883.16 7475.89 10578.35 33.41 41.50
South Carolina 3563.43 3926.47 8330.21 10939.62 10.19 31.32
South Dakota 3824.26 5221.57 5478.71 7175.82 36.54 30.98
Tennessee 2768.34 3752.18 5425.79 7574.07 35.54 39.59
Texas 1741.39 2154.97 6394.77 8506.83 23.75 33.03
Utah 2541.53 3187.03 4125.41 5598.69 25.40 35.71
Vermont 5947.45 6887.44 11067.04 13832.98 15.80 24.99
Virginia 2622.17 4207.46 7029.83 10072.35 60.46 43.28
Washington 3127.45 4028.94 6191.90 10029.04 28.83 61.97
West Virginia 2622.29 2859.55 4575.25 5847.99 9.05 27.82
Wisconsin 3661.71 4044.79 6574.96 8658.95 10.46 31.70
Wyoming 2124.45 2458.14 4086.35 4357.47 15.71 6.63
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment