ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2021-09-08 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Alabama 1
- Alaska 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
30485 | 30485 | 2021-09-08 | Alabama | 1 | 732151 | 12488 |
30486 | 30486 | 2021-09-08 | Alaska | 2 | 92891 | 439 |
30487 | 30487 | 2021-09-08 | Arizona | 4 | 1037012 | 19079 |
30488 | 30488 | 2021-09-08 | Arkansas | 5 | 467496 | 7142 |
30489 | 30489 | 2021-09-08 | California | 6 | 4545832 | 66722 |
30490 | 30490 | 2021-09-08 | Colorado | 8 | 634191 | 7420 |
30491 | 30491 | 2021-09-08 | Connecticut | 9 | 377682 | 8415 |
30492 | 30492 | 2021-09-08 | Delaware | 10 | 122956 | 1894 |
30493 | 30493 | 2021-09-08 | District of Columbia | 11 | 56694 | 1163 |
30494 | 30494 | 2021-09-08 | Florida | 12 | 3378772 | 46977 |
30495 | 30495 | 2021-09-08 | Georgia | 13 | 1436172 | 22639 |
30496 | 30496 | 2021-09-08 | Guam | 66 | 12788 | 155 |
30497 | 30497 | 2021-09-08 | Hawaii | 15 | 66925 | 623 |
30498 | 30498 | 2021-09-08 | Idaho | 16 | 229679 | 2427 |
30499 | 30499 | 2021-09-08 | Illinois | 17 | 1558768 | 26769 |
30500 | 30500 | 2021-09-08 | Indiana | 18 | 892733 | 14709 |
30501 | 30501 | 2021-09-08 | Iowa | 19 | 417152 | 6337 |
30502 | 30502 | 2021-09-08 | Kansas | 20 | 383933 | 5717 |
30503 | 30503 | 2021-09-08 | Kentucky | 21 | 613121 | 8001 |
30504 | 30504 | 2021-09-08 | Louisiana | 22 | 705498 | 12915 |
30505 | 30505 | 2021-09-08 | Maine | 23 | 78803 | 946 |
30506 | 30506 | 2021-09-08 | Maryland | 24 | 505781 | 10115 |
30507 | 30507 | 2021-09-08 | Massachusetts | 25 | 772742 | 18314 |
30508 | 30508 | 2021-09-08 | Michigan | 26 | 1079294 | 21745 |
30509 | 30509 | 2021-09-08 | Minnesota | 27 | 663341 | 7958 |
30510 | 30510 | 2021-09-08 | Mississippi | 28 | 455282 | 8787 |
30511 | 30511 | 2021-09-08 | Missouri | 29 | 792710 | 11503 |
30512 | 30512 | 2021-09-08 | Montana | 30 | 131877 | 1828 |
30513 | 30513 | 2021-09-08 | Nebraska | 31 | 250264 | 2602 |
30514 | 30514 | 2021-09-08 | Nevada | 32 | 399234 | 6637 |
30515 | 30515 | 2021-09-08 | New Hampshire | 33 | 110256 | 1431 |
30516 | 30516 | 2021-09-08 | New Jersey | 34 | 1108291 | 27007 |
30517 | 30517 | 2021-09-08 | New Mexico | 35 | 238430 | 4579 |
30518 | 30518 | 2021-09-08 | New York | 36 | 2310837 | 54088 |
30519 | 30519 | 2021-09-08 | North Carolina | 37 | 1269208 | 14925 |
30520 | 30520 | 2021-09-08 | North Dakota | 38 | 120634 | 1599 |
30521 | 30521 | 2021-09-08 | Northern Mariana Islands | 69 | 249 | 2 |
30522 | 30522 | 2021-09-08 | Ohio | 39 | 1268841 | 21020 |
30523 | 30523 | 2021-09-08 | Oklahoma | 40 | 572223 | 8208 |
30524 | 30524 | 2021-09-08 | Oregon | 41 | 291978 | 3382 |
30525 | 30525 | 2021-09-08 | Pennsylvania | 42 | 1329111 | 28446 |
30526 | 30526 | 2021-09-08 | Puerto Rico | 72 | 208425 | 2949 |
30527 | 30527 | 2021-09-08 | Rhode Island | 44 | 165083 | 2782 |
30528 | 30528 | 2021-09-08 | South Carolina | 45 | 776342 | 10996 |
30529 | 30529 | 2021-09-08 | South Dakota | 46 | 135538 | 2077 |
30530 | 30530 | 2021-09-08 | Tennessee | 47 | 1090264 | 13693 |
30531 | 30531 | 2021-09-08 | Texas | 48 | 3752776 | 59090 |
30532 | 30532 | 2021-09-08 | Utah | 49 | 475709 | 2693 |
30533 | 30533 | 2021-09-08 | Vermont | 50 | 29436 | 282 |
30534 | 30534 | 2021-09-08 | Virgin Islands | 78 | 6102 | 63 |
30535 | 30535 | 2021-09-08 | Virginia | 51 | 793396 | 11977 |
30536 | 30536 | 2021-09-08 | Washington | 53 | 592468 | 6856 |
30537 | 30537 | 2021-09-08 | West Virginia | 54 | 201660 | 3169 |
30538 | 30538 | 2021-09-08 | Wisconsin | 55 | 749241 | 8557 |
30539 | 30539 | 2021-09-08 | Wyoming | 56 | 79297 | 879 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );