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 2022-01-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 |
---|---|---|---|---|---|---|
37303 | 37303 | 2022-01-08 | Alabama | 1 | 966180 | 16624 |
37304 | 37304 | 2022-01-08 | Alaska | 2 | 164255 | 956 |
37305 | 37305 | 2022-01-08 | American Samoa | 60 | 11 | 0 |
37306 | 37306 | 2022-01-08 | Arizona | 4 | 1461633 | 24704 |
37307 | 37307 | 2022-01-08 | Arkansas | 5 | 613014 | 9314 |
37308 | 37308 | 2022-01-08 | California | 6 | 6037652 | 77248 |
37309 | 37309 | 2022-01-08 | Colorado | 8 | 996960 | 10635 |
37310 | 37310 | 2022-01-08 | Connecticut | 9 | 573711 | 9377 |
37311 | 37311 | 2022-01-08 | Delaware | 10 | 202236 | 2365 |
37312 | 37312 | 2022-01-08 | District of Columbia | 11 | 110040 | 1227 |
37313 | 37313 | 2022-01-08 | Florida | 12 | 4633077 | 62688 |
37314 | 37314 | 2022-01-08 | Georgia | 13 | 1925143 | 30478 |
37315 | 37315 | 2022-01-08 | Guam | 66 | 21563 | 275 |
37316 | 37316 | 2022-01-08 | Hawaii | 15 | 134753 | 1099 |
37317 | 37317 | 2022-01-08 | Idaho | 16 | 327509 | 4238 |
37318 | 37318 | 2022-01-08 | Illinois | 17 | 2386672 | 31660 |
37319 | 37319 | 2022-01-08 | Indiana | 18 | 1333147 | 19614 |
37320 | 37320 | 2022-01-08 | Iowa | 19 | 608000 | 8019 |
37321 | 37321 | 2022-01-08 | Kansas | 20 | 566401 | 7124 |
37322 | 37322 | 2022-01-08 | Kentucky | 21 | 925307 | 12390 |
37323 | 37323 | 2022-01-08 | Louisiana | 22 | 908428 | 15054 |
37324 | 37324 | 2022-01-08 | Maine | 23 | 153376 | 1603 |
37325 | 37325 | 2022-01-08 | Maryland | 24 | 813929 | 12158 |
37326 | 37326 | 2022-01-08 | Massachusetts | 25 | 1279928 | 20568 |
37327 | 37327 | 2022-01-08 | Michigan | 26 | 1850791 | 29920 |
37328 | 37328 | 2022-01-08 | Minnesota | 27 | 1064205 | 10906 |
37329 | 37329 | 2022-01-08 | Mississippi | 28 | 586547 | 10527 |
37330 | 37330 | 2022-01-08 | Missouri | 29 | 1107462 | 16510 |
37331 | 37331 | 2022-01-08 | Montana | 30 | 203192 | 2918 |
37332 | 37332 | 2022-01-08 | Nebraska | 31 | 355928 | 3468 |
37333 | 37333 | 2022-01-08 | Nevada | 32 | 528892 | 8510 |
37334 | 37334 | 2022-01-08 | New Hampshire | 33 | 214572 | 2019 |
37335 | 37335 | 2022-01-08 | New Jersey | 34 | 1815163 | 29444 |
37336 | 37336 | 2022-01-08 | New Mexico | 35 | 369113 | 5985 |
37337 | 37337 | 2022-01-08 | New York | 36 | 4057084 | 59913 |
37338 | 37338 | 2022-01-08 | North Carolina | 37 | 1812902 | 19629 |
37339 | 37339 | 2022-01-08 | North Dakota | 38 | 181621 | 2074 |
37340 | 37340 | 2022-01-08 | Northern Mariana Islands | 69 | 3598 | 19 |
37341 | 37341 | 2022-01-08 | Ohio | 39 | 2170139 | 30072 |
37342 | 37342 | 2022-01-08 | Oklahoma | 40 | 737593 | 11647 |
37343 | 37343 | 2022-01-08 | Oregon | 41 | 459700 | 5761 |
37344 | 37344 | 2022-01-08 | Pennsylvania | 42 | 2240549 | 37642 |
37345 | 37345 | 2022-01-08 | Puerto Rico | 72 | 380339 | 3361 |
37346 | 37346 | 2022-01-08 | Rhode Island | 44 | 266066 | 3121 |
37347 | 37347 | 2022-01-08 | South Carolina | 45 | 1048252 | 14746 |
37348 | 37348 | 2022-01-08 | South Dakota | 46 | 189411 | 2522 |
37349 | 37349 | 2022-01-08 | Tennessee | 47 | 1480651 | 20853 |
37350 | 37350 | 2022-01-08 | Texas | 48 | 4996914 | 76770 |
37351 | 37351 | 2022-01-08 | Utah | 49 | 682182 | 3887 |
37352 | 37352 | 2022-01-08 | Vermont | 50 | 76421 | 483 |
37353 | 37353 | 2022-01-08 | Virgin Islands | 78 | 11160 | 89 |
37354 | 37354 | 2022-01-08 | Virginia | 51 | 1221036 | 15651 |
37355 | 37355 | 2022-01-08 | Washington | 53 | 935391 | 10067 |
37356 | 37356 | 2022-01-08 | West Virginia | 54 | 355872 | 5421 |
37357 | 37357 | 2022-01-08 | Wisconsin | 55 | 1186069 | 11402 |
37358 | 37358 | 2022-01-08 | Wyoming | 56 | 119857 | 1572 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );