I need census data loaded into a spreadsheet for 16 states(Kentucky-North Carolina) for a 4-year span. I have 1 year loaded I just need the other 4 years.
2018 State Surveys 2018PovertyRaceHealth CareEducationBusinessHousingMedian Earnings StatesPopulation Median Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Alabama4,887,871$ 49,86117%24%53%8.6%4.3%26.7%67.7%5.6%10.0%31%34%9,958,400$ 68,970,623$ 58,564,96568%$ 147,900$ 788$ 35,854$ 49,210$ 7.25Alabama Alaska737,438$ 74,34611%14%60%12.6%7.2%3.4%64.4%32.2%12.6%28%28%21,077$ 152,392$ 10,474,27566%$ 276,100$ 1,177$ 49,020$ 61,226$ 9.84Alaska Arizona7,171,646$ 59,24614%20%56%9.0%31.6%4.7%78.0%17.3%10.6%24%39%139,134$ 106,431,260$ 84,716,54265%$ 241,100$ 1,036$ 40,311$ 47,854$ 10.50Arizona Arkansas3,013,825$ 47,06217%25%55%8.1%7.6%15.2%76.5%8.3%8.2%34%31%65,611$ 40,969,051$ 36,815,25666%$ 133,100$ 731$ 36,042$ 42,364$ 9.25Arkansas California39,557,045$ 75,27713%17%60%5.1%39.3%5.8%59.5%34.8%7.2%21%42%922,477$ 886,643,923$ 481,800,46155%$ 546,800$ 1,520$ 49,009$ 55,646$ 11.00California Colorado5,695,564$ 71,95310%12%65%8.4%21.7%4.2%84.1%12.8%7.5%21%50%165,264$ 120,398,734$ 67,815,20065%$ 373,300$ 1,289$ 46,498$ 56,377$ 10.20Colorado Connecticut 3,572,665$ 76,34810%14%62%5.8%16.5%11.0%75.2%13.8%5.3%27%48%89,416$ 94,658,647$ 51,632,46766%$ 277,400$ 1,171$ 55,155$ 65,948$ 10.10Connecticut Delaware967,171$ 64,80513%19%58%8.8%9.5%22.5%68.2%9.3%5.7%33%39%25,366$ 21,196,371$ 14,456,00171%$ 255,300$ 1,108$ 43,803$ 51,923$ 8.25Delaware Florida21,299,325$ 55,46214%20%55%8.5%26.1%16.0%74.6%9.4%13.0%29%40%546,218$ 363,336,322$ 273,867,14566%$ 230,600$ 1,182$ 37,821$ 44,520$ 8.25Florida Georgia10,519,475$ 58,75614%21%60%7.6%9.7%31.6%58.3%10.1%13.7%28%40%228,330$ 182,911,144$ 119,801,49564%$ 189,900$ 1,008$ 40,254$ 50,133$ 5.15Georgia Hawaii1,420,491$ 80,2129%12%60%9.6%10.7%2.0%24.3%73.6%4.1%27%45%32,350$ 22,892,445$ 18,901,74558%$ 631,700$ 1,613$ 42,584$ 51,413$ 10.10Hawaii Idaho1,754,208$ 55,58312%14%59%9.3%12.7%0.7%89.9%9.4%11.1%28%38%45,826$ 22,243,275$ 20,444,27871%$ 233,100$ 848$ 36,848$ 47,182$ 7.25Idaho Illinois12,741,080$ 65,03012%16%62%5.7%17.3%14.1%71.7%14.2%7.0%26%43%319,605$ 295,308,470$ 166,634,51466%$ 203,400$ 995$ 45,910$ 56,838$ 8.25Illinois Indiana 6,691,878$ 55,74613%18%61%7.4%7.1%9.5%82.8%7.7%8.3%33%36%146,078$ 117,009,032$ 85,857,96269%$ 147,300$ 820$ 38,031$ 50,774$ 7.25Indiana Iowa3,156,145$ 59,95511%14%65%7.6%6.1%3.6%90.2%6.2%4.7%31%41%81,563$ 56,930,435$ 44,905,62471%$ 152,000$ 777$ 40,353$ 51,488$ 7.25Iowa Kansas2,911,510$ 58,21812%15%63%8.2%12.0%5.9%84.0%10.0%8.8%25%43%74,884$ 51,016,318$ 38,276,46166%$ 159,400$ 840$ 40,045$ 50,872$ 7.25Kansas Kentucky4,468,402$ 50,24717%23%56%7.6%3.6%7.9%86.7%5.4%5.6%33%33%92,000$ 65,242,827$ 54,869,97867%$ 135,300$ 1,135$ 37,379$ 47,370$ 7.25Kantucky Louisiana4,659,978$ 47,90519%26%55%7.0%5.1%32.4%61.7%5.9%8.0%34%31%105,732$ 75,125,447$ 61,396,36466%$ 167,300$ 854$ 35,758$ 51,453$ 7.25Louisiana Maine1,338,404$ 55,60212%15%61%9.7%1.7%1.4%94.3%4.2%8.0%31%41%41,178$ 21,349,199$ 21,521,71471%$ 197,500$ 839$ 40,421$ 48,522$ 10.00Maine Maryland6,042,718$ 83,2429%12%64%7.8%10.4%30.0%54.7%15.3%6.0%24%48%138,480$ 121,952,023$ 76,379,70767%$ 324,800$ 1,371$ 53,421$ 62,167$ 10.10Maryland Massachusetts6,902,149$ 79,83510%12%64%5.3%12.3%7.8%77.3%14.8%2.8%23%52%177,631$ 204,747,200$ 92,915,38062%$ 400,700$ 1,295$ 55,942$ 67,147$ 11.00Massachusetts Michigan9,995,915$ 56,69714%19%58%6.8%5.2%13.8%78.3%7.9%5.4%29%39%220,412$ 183,192,569$ 119,302,04671%$ 162,500$ 861$ 41,205$ 52,332$ 9.25Michigan Minnesota 5,611,179$ 70,31510%12%67%6.8%5.5%6.6%82.5%10.9%4.4%24%48%150,115$ 137,135,936$ 78,898,18272%$ 235,400$ 969$ 46,861$ 56,809$ 9.86Minnesota Mississippi2,986,530$ 44,71720%28%52%7.2%2.9%………12.1%30%33%58,850$ 34,356,961$ 37,053,190…$ 123,300$ 777$ 33,530$ 44,495$ 7.25Mississippi Missouri6,126,452$ 54,47813%18%60%8.1%4.1%11.5%82.2%6.3%9.4%30%38%160,912$ 112,072,115$ 90,546,58167%$ 162,600$ 830$ 38,414$ 49,109$ 7.85Missouri Montana1,062,305$ 55,32813%16%61%10.2%3.9%0.5%88.6%10.9%8.2%28%41%37,626$ 14,542,766$ 15,623,57368%$ 249,200$ 811$ 36,741$ 48,037$ 8.30Montana Nebraska1,929,268$ 59,56611%13%66%8.1%11.1%4.7%86.4%9.0%8.3%26%43%54,265$ 37,715,004$ 30,470,71766%$ 161,800$ 830$ 40,156$ 50,286$ 9.00Nebraska Nevada3,034,392$ 58,64613%18%60%9.0%29.0%9.2%63.4%27.2%11.2%28%33%64,815$ 49,207,817$ 38,234,17057%$ 292,200$ 1,108$ 40,004$ 46,556$ 8.25Nevada New Hampshire1,356,458$ 74,9918%11%65%8.6%3.9%1.7%92.4%5.9%5.7%28%47%37,868$ 29,193,307$ 26,018,20171%$ 270,000$ 1,090$ 45,346$ 61,045$ 7.25New Hampshire New Jersey8,908,520$ 81,74010%14%63%4.4%20.6%13.6%66.9%19.5%7.4%26%47%231,974$ 214,757,817$ 133,665,72864%$ 344,000$ 1,336$ 52,383$ 66,532$ 8.60New Jersey New Mexico2,095,428$ 47,16920%26%52%9.1%49.1%2.2%76.5%21.4%9.5%26%36%43,771$ 25,029,224$ 25,179,27466%$ 174,400$ 830$ 35,683$ 42,673$ 7.50New Mexico New York19,542,209$ 67,84414%19%60%4.4%19.2%15.7%63.3%20.8%5.4%26%46%544,073$ 521,872,694$ 251,167,73654%$ 325,500$ 1,274$ 50,921$ 58,064$ 10.40New York North Carolina 10,383,620$ 53,85514%20%58%8.3%9.6%21.4%68.4%10.3%10.7%25%42%227,347$ 170,980,033$ 120,691,00765%$ 180,600$ 900$ 39,126$ 46,941$ 7.25North carolina North Dakota760,077$ 63,83711%10%67%7.8%3.6%3.4%85.7%10.8%7.3%26%45%24,601$ 15,816,748$ 15,519,81663%$ 198,700$ 808$ 40,582$ 55,608$ 7.25North Dakota Ohio$ 8.30Ohio Oklahoma$ 7.25Oklahoma Oregon$ 10.75Oregon Pennsylvania$ 7.25Pennsylvania Rhode Island$ 10.10Rhode Island South Carolina5,084,127$ 52,30615%23%56%9.2%5.7%26.6%67.0%6.4%10.5%88%39%105,959$ 69,050,740$ 58,093,82469%$ 170,800$ 892$ 36,720$ 46,080$ 7.25South Carolina South Dakota$ 8.85South Dakota Tennesse$ 7.25Tennesse Texas$ 7.25Texas Utah$ 7.25Utah Vermont$ 10.50Vermont Virginia $ 7.25Virginia Washington$ 11.50Washington West Virgina$ 8.75West Virgina Wisconsin$ 7.25Wisconsin Wyoming$ 5.15Wyoming United States 6525299.0857142961890.85714285710.12882857140.17342857140.59922857140.07877142860.12740.11391176470.74285294120.14341176470.08105714290.29462857140.4053428571439405.942857143130125967.68428683500330.82857140.6577647059242142.8571428571020.371428571442232.314285714352428.48.453 Referenceshttps://data.census.gov/cedsci/profile?q=United%20States&g=0100000US#https://www.dol.gov/agencies/whd/state/minimum-wage/history https://www.dol.gov/agencies/whd/state/minimum-wage/historyhttps://data.census.gov/cedsci/profile?q=United%20States&g=0100000US 2009 Column1Population Median Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Kentucky4,339,36710%3%8%86%3%29%35% Louisiana4,533,372 Maine1,328,361 Maryland5,773,552 Massachusetts6,547,629 Michigan9,883,640 Minnesota 5,303,925 Mississippi2,967,297 Missouri5,988,927 Montana989,415 Nebraska1,826,341 Nevada2,700,551 New Hampshire1,316,470 New Jersey8,791,894 New Mexico2,059,179 New York19,378,102 North Carolina 9,535,483 2017 Column1PopulationMedian Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina 2016 Column1PopulationMedian Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico 2015 Column1PopulationMedian Household IncomePoverty RateUnder 18Empolyment RateVeteransHispanic African AmericanWhite OtherUninsured Highschool GradHigher Education (Degree Holding)Total EmployersAnnual PayrollRetail SalesHomeownershipHousing Value Renter CostsFemaleMaleMinimum Wage (State Law) Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico