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 2020-09-09 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 55
- 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
- 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 ▼ |
---|---|---|---|---|---|---|
10501 | 10501 | 2020-09-09 | Northern Mariana Islands | 69 | 59 | 2 |
10514 | 10514 | 2020-09-09 | Virgin Islands | 78 | 1197 | 18 |
10476 | 10476 | 2020-09-09 | Guam | 66 | 2727 | 21 |
10466 | 10466 | 2020-09-09 | Alaska | 2 | 6735 | 39 |
10519 | 10519 | 2020-09-09 | Wyoming | 56 | 4151 | 42 |
10513 | 10513 | 2020-09-09 | Vermont | 50 | 1656 | 58 |
10477 | 10477 | 2020-09-09 | Hawaii | 15 | 10228 | 90 |
10492 | 10492 | 2020-09-09 | Montana | 30 | 8499 | 122 |
10485 | 10485 | 2020-09-09 | Maine | 23 | 4734 | 134 |
10500 | 10500 | 2020-09-09 | North Dakota | 38 | 14114 | 161 |
10509 | 10509 | 2020-09-09 | South Dakota | 46 | 15571 | 173 |
10517 | 10517 | 2020-09-09 | West Virginia | 54 | 11808 | 254 |
10478 | 10478 | 2020-09-09 | Idaho | 16 | 34707 | 406 |
10512 | 10512 | 2020-09-09 | Utah | 49 | 55730 | 428 |
10495 | 10495 | 2020-09-09 | New Hampshire | 33 | 7517 | 433 |
10493 | 10493 | 2020-09-09 | Nebraska | 31 | 36917 | 434 |
10482 | 10482 | 2020-09-09 | Kansas | 20 | 48389 | 497 |
10504 | 10504 | 2020-09-09 | Oregon | 41 | 28474 | 499 |
10506 | 10506 | 2020-09-09 | Puerto Rico | 72 | 35507 | 500 |
10472 | 10472 | 2020-09-09 | Delaware | 10 | 18308 | 609 |
10473 | 10473 | 2020-09-09 | District of Columbia | 11 | 14387 | 615 |
10497 | 10497 | 2020-09-09 | New Mexico | 35 | 26268 | 813 |
10503 | 10503 | 2020-09-09 | Oklahoma | 40 | 65929 | 863 |
10468 | 10468 | 2020-09-09 | Arkansas | 5 | 67255 | 928 |
10483 | 10483 | 2020-09-09 | Kentucky | 21 | 57518 | 1058 |
10507 | 10507 | 2020-09-09 | Rhode Island | 44 | 22676 | 1062 |
10518 | 10518 | 2020-09-09 | Wisconsin | 55 | 88643 | 1193 |
10481 | 10481 | 2020-09-09 | Iowa | 19 | 71594 | 1204 |
10494 | 10494 | 2020-09-09 | Nevada | 32 | 72317 | 1414 |
10491 | 10491 | 2020-09-09 | Missouri | 29 | 98446 | 1755 |
10510 | 10510 | 2020-09-09 | Tennessee | 47 | 164032 | 1908 |
10489 | 10489 | 2020-09-09 | Minnesota | 27 | 81920 | 1921 |
10470 | 10470 | 2020-09-09 | Colorado | 8 | 60291 | 1984 |
10516 | 10516 | 2020-09-09 | Washington | 53 | 81528 | 2066 |
10465 | 10465 | 2020-09-09 | Alabama | 1 | 134417 | 2285 |
10490 | 10490 | 2020-09-09 | Mississippi | 28 | 87805 | 2623 |
10515 | 10515 | 2020-09-09 | Virginia | 51 | 129289 | 2697 |
10508 | 10508 | 2020-09-09 | South Carolina | 45 | 126213 | 2942 |
10499 | 10499 | 2020-09-09 | North Carolina | 37 | 180061 | 2990 |
10480 | 10480 | 2020-09-09 | Indiana | 18 | 103641 | 3397 |
10486 | 10486 | 2020-09-09 | Maryland | 24 | 114070 | 3816 |
10502 | 10502 | 2020-09-09 | Ohio | 39 | 132965 | 4324 |
10471 | 10471 | 2020-09-09 | Connecticut | 9 | 53871 | 4474 |
10484 | 10484 | 2020-09-09 | Louisiana | 22 | 155890 | 5140 |
10467 | 10467 | 2020-09-09 | Arizona | 4 | 206548 | 5253 |
10475 | 10475 | 2020-09-09 | Georgia | 13 | 270624 | 5987 |
10488 | 10488 | 2020-09-09 | Michigan | 26 | 119952 | 6889 |
10505 | 10505 | 2020-09-09 | Pennsylvania | 42 | 146058 | 7882 |
10479 | 10479 | 2020-09-09 | Illinois | 17 | 256614 | 8457 |
10487 | 10487 | 2020-09-09 | Massachusetts | 25 | 123143 | 9146 |
10474 | 10474 | 2020-09-09 | Florida | 12 | 652140 | 12114 |
10511 | 10511 | 2020-09-09 | Texas | 48 | 675149 | 13986 |
10469 | 10469 | 2020-09-09 | California | 6 | 749197 | 13990 |
10496 | 10496 | 2020-09-09 | New Jersey | 34 | 196779 | 16009 |
10498 | 10498 | 2020-09-09 | New York | 36 | 445881 | 32611 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );