Macroeconomic data project
aural1018
DataProject2_Fall20211.xlsMetadata
| Data Projec 2 | ||
| Econ 2, Fall 2021 | ||
| Prof. Lint Barrage | ||
| Note: All data are as of September 2021 | ||
| State Data | ||
| Variable | Definition | Source |
| state | State Name | |
| minwage | Minimum wage (in dollars/hour) | BLS |
| union_pct | Percent of employed represented by labor union (percent) | BLS |
| UI_Duration | Unemployment insurance max. duration (in weeks) | CBPP |
| vaccination_dpc | Covid vaccination rates (number of first doses per capita) | Kaiser Family Foundation |
| unemployment_rate | Unemployment rate (percent) | BLS |
| covid_cpm | Daily new Covid infections per million people | Kaiser Family Foundation |
States_Data
| state | minwage | union_pct | UI_duration | vaccination_dpc | unemployment_rate | covid_cpm |
| Nebraska | $9.00 | 11 | 26 | 0.5960681313 | 2 | 271.4028541464 |
| Utah | $7.25 | 5 | 26 | 0.5854971831 | 2.4 | 320.0558719703 |
| Idaho | $7.25 | 6 | 21 | 0.4639279484 | 2.9 | 273.6075241991 |
| New Hampshire | $7.25 | 11 | 26 | 0.7042462169 | 2.9 | 45.6925373212 |
| South Dakota | $9.45 | 6 | 26 | 0.5905858184 | 2.9 | 457.6718361714 |
| Vermont | $10.96 | 14 | 26 | 0.7814475725 | 2.9 | 16.500784131 |
| Oklahoma | $7.25 | 8 | 26 | 0.5666741945 | 3 | 243.5988813543 |
| Alabama | $7.25 | 9 | 14 | 0.5277722465 | 3.1 | 206.8461609109 |
| Georgia | $7.25 | 7 | 26 | 0.5462562758 | 3.2 | 112.4848154503 |
| Montana | $8.75 | 13 | 28 | 0.545156893 | 3.3 | 321.7857549386 |
| North Dakota | $7.25 | 7 | 26 | 0.5112013579 | 3.5 | 537.4113126668 |
| Minnesota | $10.08 | 17 | 26 | 0.6354484138 | 3.7 | 180.8269678588 |
| Missouri | $10.30 | 10 | 20 | 0.5510385353 | 3.8 | 223.4280820744 |
| Virginia | $9.50 | 5 | 26 | 0.6841811183 | 3.8 | 99.1785986553 |
| Kansas | $7.25 | 11 | 16 | 0.6028086986 | 3.9 | 199.8859125537 |
| Wisconsin | $7.25 | 10 | 26 | 0.611272568 | 3.9 | 410.7661335802 |
| Arkansas | $11.00 | 6 | 16 | 0.5579111453 | 4 | 253.6573850031 |
| Indiana | $7.25 | 10 | 26 | 0.5234462771 | 4 | 161.8706409102 |
| Iowa | $7.25 | 9 | 26 | 0.5822113119 | 4 | 271.0778861452 |
| South Carolina | $7.25 | 4 | 20 | 0.5492861304 | 4.1 | 156.1615362966 |
| North Carolina | $7.25 | 4 | 13 | 0.5977604758 | 4.2 | 135.2455640203 |
| Kentucky | $7.25 | 9 | 26 | 0.6103568909 | 4.3 | 198.4317098658 |
| Tennessee | $7.25 | 5 | 26 | 0.5261764695 | 4.4 | 206.7506117989 |
| Wyoming | $7.25 | 9 | 26 | 0.4859512165 | 4.5 | 214.6556579797 |
| Michigan | $9.65 | 17 | 20 | 0.5755546425 | 4.6 | 100.6795799982 |
| West Virginia | $8.75 | 11 | 26 | 0.4851318393 | 4.6 | 98.6912483915 |
| Oregon | $12.75 | 17 | 26 | 0.6651433087 | 4.7 | 69.2139441409 |
| Maine | $12.15 | 17 | 26 | 0.7410337143 | 4.8 | 25.8174093351 |
| Florida | $10.00 | 8 | 19 | 0.665396282 | 4.9 | 108.9308694151 |
| Washington | $13.69 | 19 | 26 | 0.6696309874 | 4.9 | 71.3950371146 |
| Massachusetts | $13.50 | 13 | 30 | 0.7787237796 | 5.2 | 90.9749945591 |
| Rhode Island | $11.50 | 19 | 26 | 0.7591079579 | 5.2 | 134.4617307725 |
| Delaware | $9.25 | 10 | 26 | 0.6574940034 | 5.3 | 141.0028254129 |
| Ohio | $8.80 | 14 | 26 | 0.5449354955 | 5.4 | 99.7159293289 |
| Colorado | $12.32 | 8 | 26 | 0.6536907175 | 5.6 | 99.5473192045 |
| Texas | $7.25 | 6 | 26 | 0.5914001065 | 5.6 | 154.7400635755 |
| Arizona | $12.15 | 7 | 26 | 0.5848715088 | 5.7 | 68.5276848093 |
| Louisiana | $7.25 | 7 | 26 | 0.5210243949 | 5.8 | 111.3871152478 |
| Mississippi | $7.25 | 8 | 26 | 0.5065222096 | 5.8 | 175.9479787218 |
| Maryland | $11.00 | 14 | 26 | 0.7087340372 | 5.9 | 92.2609896615 |
| Pennsylvania | $7.25 | 15 | 26 | 0.7335262993 | 6.2 | 82.5074965822 |
| Alaska | $10.34 | 20 | 39 | 0.5765415957 | 6.3 | 194.2124684405 |
| Hawaii | $10.10 | 26 | 26 | 0.775143816 | 6.6 | 66.0977991565 |
| Connecticut | $13.00 | 18 | 39 | 0.7694743838 | 6.8 | 79.2399964625 |
| Illinois | $11.00 | 15 | 26 | 0.693123353 | 6.8 | 158.9555014254 |
| New Mexico | $10.50 | 9 | 39 | 0.7263273037 | 6.9 | 111.7046915903 |
| New Jersey | $12.00 | 18 | 39 | 0.7293291397 | 7.1 | 84.6299130845 |
| New York | $12.50 | 24 | 26 | 0.7236821691 | 7.1 | 68.4557904438 |
| California | $13.00 | 18 | 26 | 0.7250056759 | 7.5 | 83.4323542178 |
| Nevada | $8.75 | 15 | 26 | 0.6009739795 | 7.5 | 147.7616365361 |
