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-06-02 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 |
---|---|---|---|---|---|---|
45423 | 45423 | 2022-06-02 | Alabama | 1 | 1317029 | 19664 |
45424 | 45424 | 2022-06-02 | Alaska | 2 | 260440 | 1246 |
45425 | 45425 | 2022-06-02 | American Samoa | 60 | 6192 | 31 |
45426 | 45426 | 2022-06-02 | Arizona | 4 | 2062669 | 30332 |
45427 | 45427 | 2022-06-02 | Arkansas | 5 | 844463 | 11492 |
45428 | 45428 | 2022-06-02 | California | 6 | 9623352 | 91590 |
45429 | 45429 | 2022-06-02 | Colorado | 8 | 1458419 | 12758 |
45430 | 45430 | 2022-06-02 | Connecticut | 9 | 810849 | 10972 |
45431 | 45431 | 2022-06-02 | Delaware | 10 | 277187 | 2959 |
45432 | 45432 | 2022-06-02 | District of Columbia | 11 | 150495 | 1346 |
45433 | 45433 | 2022-06-02 | Florida | 12 | 6182874 | 74588 |
45434 | 45434 | 2022-06-02 | Georgia | 13 | 2499711 | 36758 |
45435 | 45435 | 2022-06-02 | Guam | 66 | 50231 | 365 |
45436 | 45436 | 2022-06-02 | Hawaii | 15 | 275631 | 1454 |
45437 | 45437 | 2022-06-02 | Idaho | 16 | 452240 | 4944 |
45438 | 45438 | 2022-06-02 | Illinois | 17 | 3318938 | 38171 |
45439 | 45439 | 2022-06-02 | Indiana | 18 | 1735581 | 23712 |
45440 | 45440 | 2022-06-02 | Iowa | 19 | 780447 | 9603 |
45441 | 45441 | 2022-06-02 | Kansas | 20 | 789939 | 8959 |
45442 | 45442 | 2022-06-02 | Kentucky | 21 | 1367986 | 15945 |
45443 | 45443 | 2022-06-02 | Louisiana | 22 | 1263204 | 17337 |
45444 | 45444 | 2022-06-02 | Maine | 23 | 263714 | 2351 |
45445 | 45445 | 2022-06-02 | Maryland | 24 | 1093681 | 14620 |
45446 | 45446 | 2022-06-02 | Massachusetts | 25 | 1876130 | 20651 |
45447 | 45447 | 2022-06-02 | Michigan | 26 | 2547366 | 36407 |
45448 | 45448 | 2022-06-02 | Minnesota | 27 | 1514070 | 12959 |
45449 | 45449 | 2022-06-02 | Mississippi | 28 | 809810 | 12470 |
45450 | 45450 | 2022-06-02 | Missouri | 29 | 1473063 | 20755 |
45451 | 45451 | 2022-06-02 | Montana | 30 | 278145 | 3401 |
45452 | 45452 | 2022-06-02 | Nebraska | 31 | 488110 | 4294 |
45453 | 45453 | 2022-06-02 | Nevada | 32 | 742260 | 10896 |
45454 | 45454 | 2022-06-02 | New Hampshire | 33 | 326295 | 2542 |
45455 | 45455 | 2022-06-02 | New Jersey | 34 | 2402892 | 33742 |
45456 | 45456 | 2022-06-02 | New Mexico | 35 | 537552 | 7805 |
45457 | 45457 | 2022-06-02 | New York | 36 | 5439906 | 68413 |
45458 | 45458 | 2022-06-02 | North Carolina | 37 | 2773939 | 24663 |
45459 | 45459 | 2022-06-02 | North Dakota | 38 | 244938 | 2330 |
45460 | 45460 | 2022-06-02 | Northern Mariana Islands | 69 | 11366 | 34 |
45461 | 45461 | 2022-06-02 | Ohio | 39 | 2780653 | 38657 |
45462 | 45462 | 2022-06-02 | Oklahoma | 40 | 1052091 | 14437 |
45463 | 45463 | 2022-06-02 | Oregon | 41 | 769081 | 7644 |
45464 | 45464 | 2022-06-02 | Pennsylvania | 42 | 2932186 | 45254 |
45465 | 45465 | 2022-06-02 | Puerto Rico | 72 | 709298 | 4380 |
45466 | 45466 | 2022-06-02 | Rhode Island | 44 | 393888 | 3580 |
45467 | 45467 | 2022-06-02 | South Carolina | 45 | 1504967 | 17907 |
45468 | 45468 | 2022-06-02 | South Dakota | 46 | 240357 | 2928 |
45469 | 45469 | 2022-06-02 | Tennessee | 47 | 2015991 | 26214 |
45470 | 45470 | 2022-06-02 | Texas | 48 | 6880508 | 88580 |
45471 | 45471 | 2022-06-02 | Utah | 49 | 954938 | 4781 |
45472 | 45472 | 2022-06-02 | Vermont | 50 | 132676 | 670 |
45473 | 45473 | 2022-06-02 | Virgin Islands | 78 | 19971 | 113 |
45474 | 45474 | 2022-06-02 | Virginia | 51 | 1793644 | 20410 |
45475 | 45475 | 2022-06-02 | Washington | 53 | 1583906 | 12992 |
45476 | 45476 | 2022-06-02 | West Virginia | 54 | 517249 | 6971 |
45477 | 45477 | 2022-06-02 | Wisconsin | 55 | 1680403 | 14637 |
45478 | 45478 | 2022-06-02 | Wyoming | 56 | 158472 | 1820 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );