ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2021-10-08 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 1
- American Samoa 1
- Arizona 1
- Arkansas 1
- California 1
- Colorado 1
- Connecticut 1
- Delaware 1
- District of Columbia 1
- Florida 1
- Georgia 1
- Guam 1
- Hawaii 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Kansas 1
- Kentucky 1
- Louisiana 1
- Maine 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- Minnesota 1
- Mississippi 1
- Missouri 1
- Montana 1
- Nebraska 1
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
32151 | 32151 | 2021-10-08 | Alabama | 1 | 806560 | 14756 |
32152 | 32152 | 2021-10-08 | Alaska | 2 | 120496 | 574 |
32153 | 32153 | 2021-10-08 | American Samoa | 60 | 3 | 0 |
32154 | 32154 | 2021-10-08 | Arizona | 4 | 1114061 | 20319 |
32155 | 32155 | 2021-10-08 | Arkansas | 5 | 501518 | 7810 |
32156 | 32156 | 2021-10-08 | California | 6 | 4789773 | 70132 |
32157 | 32157 | 2021-10-08 | Colorado | 8 | 692082 | 7913 |
32158 | 32158 | 2021-10-08 | Connecticut | 9 | 394008 | 8667 |
32159 | 32159 | 2021-10-08 | Delaware | 10 | 136682 | 1997 |
32160 | 32160 | 2021-10-08 | District of Columbia | 11 | 62266 | 1182 |
32161 | 32161 | 2021-10-08 | Florida | 12 | 3601755 | 56667 |
32162 | 32162 | 2021-10-08 | Georgia | 13 | 1567598 | 26215 |
32163 | 32163 | 2021-10-08 | Guam | 66 | 17027 | 213 |
32164 | 32164 | 2021-10-08 | Hawaii | 15 | 78597 | 830 |
32165 | 32165 | 2021-10-08 | Idaho | 16 | 267711 | 3118 |
32166 | 32166 | 2021-10-08 | Illinois | 17 | 1655222 | 27965 |
32167 | 32167 | 2021-10-08 | Indiana | 18 | 985949 | 15982 |
32168 | 32168 | 2021-10-08 | Iowa | 19 | 461729 | 6654 |
32169 | 32169 | 2021-10-08 | Kansas | 20 | 418664 | 6146 |
32170 | 32170 | 2021-10-08 | Kentucky | 21 | 716455 | 9162 |
32171 | 32171 | 2021-10-08 | Louisiana | 22 | 747329 | 14173 |
32172 | 32172 | 2021-10-08 | Maine | 23 | 94348 | 1070 |
32173 | 32173 | 2021-10-08 | Maryland | 24 | 541857 | 10563 |
32174 | 32174 | 2021-10-08 | Massachusetts | 25 | 823485 | 18746 |
32175 | 32175 | 2021-10-08 | Michigan | 26 | 1186800 | 22683 |
32176 | 32176 | 2021-10-08 | Minnesota | 27 | 735759 | 8408 |
32177 | 32177 | 2021-10-08 | Mississippi | 28 | 494271 | 9811 |
32178 | 32178 | 2021-10-08 | Missouri | 29 | 848730 | 12396 |
32179 | 32179 | 2021-10-08 | Montana | 30 | 158851 | 2079 |
32180 | 32180 | 2021-10-08 | Nebraska | 31 | 271550 | 2845 |
32181 | 32181 | 2021-10-08 | Nevada | 32 | 436244 | 7285 |
32182 | 32182 | 2021-10-08 | New Hampshire | 33 | 124208 | 1497 |
32183 | 32183 | 2021-10-08 | New Jersey | 34 | 1168312 | 27570 |
32184 | 32184 | 2021-10-08 | New Mexico | 35 | 258943 | 4871 |
32185 | 32185 | 2021-10-08 | New York | 36 | 2464979 | 55203 |
32186 | 32186 | 2021-10-08 | North Carolina | 37 | 1427236 | 17121 |
32187 | 32187 | 2021-10-08 | North Dakota | 38 | 137160 | 1669 |
32188 | 32188 | 2021-10-08 | Northern Mariana Islands | 69 | 273 | 2 |
32189 | 32189 | 2021-10-08 | Ohio | 39 | 1458747 | 22819 |
32190 | 32190 | 2021-10-08 | Oklahoma | 40 | 622780 | 9213 |
32191 | 32191 | 2021-10-08 | Oregon | 41 | 341113 | 3982 |
32192 | 32192 | 2021-10-08 | Pennsylvania | 42 | 1469847 | 29907 |
32193 | 32193 | 2021-10-08 | Puerto Rico | 72 | 215895 | 3187 |
32194 | 32194 | 2021-10-08 | Rhode Island | 44 | 174570 | 2854 |
32195 | 32195 | 2021-10-08 | South Carolina | 45 | 874013 | 12929 |
32196 | 32196 | 2021-10-08 | South Dakota | 46 | 147820 | 2171 |
32197 | 32197 | 2021-10-08 | Tennessee | 47 | 1220612 | 15428 |
32198 | 32198 | 2021-10-08 | Texas | 48 | 4123946 | 67659 |
32199 | 32199 | 2021-10-08 | Utah | 49 | 520291 | 2994 |
32200 | 32200 | 2021-10-08 | Vermont | 50 | 35204 | 332 |
32201 | 32201 | 2021-10-08 | Virgin Islands | 78 | 6925 | 73 |
32202 | 32202 | 2021-10-08 | Virginia | 51 | 888159 | 13075 |
32203 | 32203 | 2021-10-08 | Washington | 53 | 680744 | 8068 |
32204 | 32204 | 2021-10-08 | West Virginia | 54 | 250800 | 3935 |
32205 | 32205 | 2021-10-08 | Wisconsin | 55 | 835193 | 9006 |
32206 | 32206 | 2021-10-08 | Wyoming | 56 | 94303 | 1041 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );