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-09-24 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 56
- 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
- Nevada 1
- New Hampshire 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- North Dakota 1
- Northern Mariana Islands 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- Rhode Island 1
- South Carolina 1
- South Dakota 1
- Tennessee 1
- Texas 1
- Utah 1
- Vermont 1
- Virgin Islands 1
- Virginia 1
- Washington 1
- West Virginia 1
- Wisconsin 1
- Wyoming 1
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
31367 | 31367 | 2021-09-24 | Alabama | 1 | 784484 | 13921 |
31368 | 31368 | 2021-09-24 | Alaska | 2 | 106888 | 515 |
31369 | 31369 | 2021-09-24 | American Samoa | 60 | 1 | 0 |
31370 | 31370 | 2021-09-24 | Arizona | 4 | 1078874 | 19737 |
31371 | 31371 | 2021-09-24 | Arkansas | 5 | 491221 | 7561 |
31372 | 31372 | 2021-09-24 | California | 6 | 4694673 | 68710 |
31373 | 31373 | 2021-09-24 | Colorado | 8 | 664010 | 7648 |
31374 | 31374 | 2021-09-24 | Connecticut | 9 | 387733 | 8501 |
31375 | 31375 | 2021-09-24 | Delaware | 10 | 130444 | 1942 |
31376 | 31376 | 2021-09-24 | District of Columbia | 11 | 60205 | 1172 |
31377 | 31377 | 2021-09-24 | Florida | 12 | 3539272 | 53580 |
31378 | 31378 | 2021-09-24 | Georgia | 13 | 1523763 | 24632 |
31379 | 31379 | 2021-09-24 | Guam | 66 | 15217 | 185 |
31380 | 31380 | 2021-09-24 | Hawaii | 15 | 74997 | 744 |
31381 | 31381 | 2021-09-24 | Idaho | 16 | 249805 | 2754 |
31382 | 31382 | 2021-09-24 | Illinois | 17 | 1617236 | 27440 |
31383 | 31383 | 2021-09-24 | Indiana | 18 | 951308 | 15377 |
31384 | 31384 | 2021-09-24 | Iowa | 19 | 441183 | 6482 |
31385 | 31385 | 2021-09-24 | Kansas | 20 | 405495 | 6005 |
31386 | 31386 | 2021-09-24 | Kentucky | 21 | 678902 | 8574 |
31387 | 31387 | 2021-09-24 | Louisiana | 22 | 734524 | 13741 |
31388 | 31388 | 2021-09-24 | Maine | 23 | 86586 | 1009 |
31389 | 31389 | 2021-09-24 | Maryland | 24 | 525351 | 10362 |
31390 | 31390 | 2021-09-24 | Massachusetts | 25 | 802829 | 18541 |
31391 | 31391 | 2021-09-24 | Michigan | 26 | 1130659 | 22196 |
31392 | 31392 | 2021-09-24 | Minnesota | 27 | 697275 | 8169 |
31393 | 31393 | 2021-09-24 | Mississippi | 28 | 482902 | 9425 |
31394 | 31394 | 2021-09-24 | Missouri | 29 | 827467 | 12010 |
31395 | 31395 | 2021-09-24 | Montana | 30 | 146183 | 1948 |
31396 | 31396 | 2021-09-24 | Nebraska | 31 | 262475 | 2649 |
31397 | 31397 | 2021-09-24 | Nevada | 32 | 416496 | 7015 |
31398 | 31398 | 2021-09-24 | New Hampshire | 33 | 117454 | 1472 |
31399 | 31399 | 2021-09-24 | New Jersey | 34 | 1143855 | 27307 |
31400 | 31400 | 2021-09-24 | New Mexico | 35 | 248788 | 4751 |
31401 | 31401 | 2021-09-24 | New York | 36 | 2395880 | 54702 |
31402 | 31402 | 2021-09-24 | North Carolina | 37 | 1371147 | 16126 |
31403 | 31403 | 2021-09-24 | North Dakota | 38 | 128586 | 1631 |
31404 | 31404 | 2021-09-24 | Northern Mariana Islands | 69 | 265 | 2 |
31405 | 31405 | 2021-09-24 | Ohio | 39 | 1380370 | 21820 |
31406 | 31406 | 2021-09-24 | Oklahoma | 40 | 604391 | 8715 |
31407 | 31407 | 2021-09-24 | Oregon | 41 | 320990 | 3682 |
31408 | 31408 | 2021-09-24 | Pennsylvania | 42 | 1402826 | 29064 |
31409 | 31409 | 2021-09-24 | Puerto Rico | 72 | 213640 | 3117 |
31410 | 31410 | 2021-09-24 | Rhode Island | 44 | 170700 | 2823 |
31411 | 31411 | 2021-09-24 | South Carolina | 45 | 841600 | 12080 |
31412 | 31412 | 2021-09-24 | South Dakota | 46 | 142800 | 2125 |
31413 | 31413 | 2021-09-24 | Tennessee | 47 | 1181691 | 14707 |
31414 | 31414 | 2021-09-24 | Texas | 48 | 3999392 | 64016 |
31415 | 31415 | 2021-09-24 | Utah | 49 | 500792 | 2869 |
31416 | 31416 | 2021-09-24 | Vermont | 50 | 32610 | 304 |
31417 | 31417 | 2021-09-24 | Virgin Islands | 78 | 6557 | 69 |
31418 | 31418 | 2021-09-24 | Virginia | 51 | 849865 | 12511 |
31419 | 31419 | 2021-09-24 | Washington | 53 | 643183 | 7537 |
31420 | 31420 | 2021-09-24 | West Virginia | 54 | 231668 | 3523 |
31421 | 31421 | 2021-09-24 | Wisconsin | 55 | 793981 | 8794 |
31422 | 31422 | 2021-09-24 | Wyoming | 56 | 87866 | 955 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );