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-12-07 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 |
---|---|---|---|---|---|---|
35511 | 35511 | 2021-12-07 | Alabama | 1 | 849409 | 16199 |
35512 | 35512 | 2021-12-07 | Alaska | 2 | 151539 | 859 |
35513 | 35513 | 2021-12-07 | American Samoa | 60 | 10 | 0 |
35514 | 35514 | 2021-12-07 | Arizona | 4 | 1298091 | 22761 |
35515 | 35515 | 2021-12-07 | Arkansas | 5 | 534590 | 8776 |
35516 | 35516 | 2021-12-07 | California | 6 | 5135147 | 75169 |
35517 | 35517 | 2021-12-07 | Colorado | 8 | 851958 | 9653 |
35518 | 35518 | 2021-12-07 | Connecticut | 9 | 432675 | 8945 |
35519 | 35519 | 2021-12-07 | Delaware | 10 | 157175 | 2203 |
35520 | 35520 | 2021-12-07 | District of Columbia | 11 | 68134 | 1197 |
35521 | 35521 | 2021-12-07 | Florida | 12 | 3704013 | 61789 |
35522 | 35522 | 2021-12-07 | Georgia | 13 | 1639068 | 29604 |
35523 | 35523 | 2021-12-07 | Guam | 66 | 20252 | 268 |
35524 | 35524 | 2021-12-07 | Hawaii | 15 | 85464 | 1030 |
35525 | 35525 | 2021-12-07 | Idaho | 16 | 310039 | 3996 |
35526 | 35526 | 2021-12-07 | Illinois | 17 | 1866099 | 29710 |
35527 | 35527 | 2021-12-07 | Indiana | 18 | 1138535 | 17829 |
35528 | 35528 | 2021-12-07 | Iowa | 19 | 538738 | 7445 |
35529 | 35529 | 2021-12-07 | Kansas | 20 | 478787 | 6775 |
35530 | 35530 | 2021-12-07 | Kentucky | 21 | 807316 | 11434 |
35531 | 35531 | 2021-12-07 | Louisiana | 22 | 774181 | 14844 |
35532 | 35532 | 2021-12-07 | Maine | 23 | 124098 | 1348 |
35533 | 35533 | 2021-12-07 | Maryland | 24 | 592912 | 11255 |
35534 | 35534 | 2021-12-07 | Massachusetts | 25 | 951969 | 19567 |
35535 | 35535 | 2021-12-07 | Michigan | 26 | 1532247 | 26207 |
35536 | 35536 | 2021-12-07 | Minnesota | 27 | 945569 | 9823 |
35537 | 35537 | 2021-12-07 | Mississippi | 28 | 517138 | 10306 |
35538 | 35538 | 2021-12-07 | Missouri | 29 | 941558 | 15653 |
35539 | 35539 | 2021-12-07 | Montana | 30 | 193218 | 2778 |
35540 | 35540 | 2021-12-07 | Nebraska | 31 | 317450 | 3202 |
35541 | 35541 | 2021-12-07 | Nevada | 32 | 475460 | 8126 |
35542 | 35542 | 2021-12-07 | New Hampshire | 33 | 170080 | 1757 |
35543 | 35543 | 2021-12-07 | New Jersey | 34 | 1279667 | 28494 |
35544 | 35544 | 2021-12-07 | New Mexico | 35 | 325272 | 5432 |
35545 | 35545 | 2021-12-07 | New York | 36 | 2796043 | 57396 |
35546 | 35546 | 2021-12-07 | North Carolina | 37 | 1555527 | 18890 |
35547 | 35547 | 2021-12-07 | North Dakota | 38 | 165414 | 1967 |
35548 | 35548 | 2021-12-07 | Northern Mariana Islands | 69 | 1182 | 3 |
35549 | 35549 | 2021-12-07 | Ohio | 39 | 1743801 | 27011 |
35550 | 35550 | 2021-12-07 | Oklahoma | 40 | 675733 | 11269 |
35551 | 35551 | 2021-12-07 | Oregon | 41 | 397421 | 5299 |
35552 | 35552 | 2021-12-07 | Pennsylvania | 42 | 1791030 | 34107 |
35553 | 35553 | 2021-12-07 | Puerto Rico | 72 | 222519 | 3274 |
35554 | 35554 | 2021-12-07 | Rhode Island | 44 | 198036 | 2949 |
35555 | 35555 | 2021-12-07 | South Carolina | 45 | 925629 | 14318 |
35556 | 35556 | 2021-12-07 | South Dakota | 46 | 169789 | 2375 |
35557 | 35557 | 2021-12-07 | Tennessee | 47 | 1299541 | 17495 |
35558 | 35558 | 2021-12-07 | Texas | 48 | 4352353 | 74589 |
35559 | 35559 | 2021-12-07 | Utah | 49 | 606666 | 3606 |
35560 | 35560 | 2021-12-07 | Vermont | 50 | 53431 | 419 |
35561 | 35561 | 2021-12-07 | Virgin Islands | 78 | 7569 | 87 |
35562 | 35562 | 2021-12-07 | Virginia | 51 | 985297 | 14798 |
35563 | 35563 | 2021-12-07 | Washington | 53 | 788853 | 9517 |
35564 | 35564 | 2021-12-07 | West Virginia | 54 | 302120 | 5021 |
35565 | 35565 | 2021-12-07 | Wisconsin | 55 | 998047 | 10138 |
35566 | 35566 | 2021-12-07 | Wyoming | 56 | 112368 | 1472 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );