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-10-10 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 |
---|---|---|---|---|---|---|
52703 | 52703 | 2022-10-10 | Alabama | 1 | 1526381 | 20473 |
52704 | 52704 | 2022-10-10 | Alaska | 2 | 297176 | 1350 |
52705 | 52705 | 2022-10-10 | American Samoa | 60 | 8244 | 34 |
52706 | 52706 | 2022-10-10 | Arizona | 4 | 2275235 | 31406 |
52707 | 52707 | 2022-10-10 | Arkansas | 5 | 954177 | 12321 |
52708 | 52708 | 2022-10-10 | California | 6 | 11290889 | 96244 |
52709 | 52709 | 2022-10-10 | Colorado | 8 | 1667452 | 13541 |
52710 | 52710 | 2022-10-10 | Connecticut | 9 | 902374 | 11385 |
52711 | 52711 | 2022-10-10 | Delaware | 10 | 310450 | 3112 |
52712 | 52712 | 2022-10-10 | District of Columbia | 11 | 168678 | 1392 |
52713 | 52713 | 2022-10-10 | Florida | 12 | 7129245 | 81661 |
52714 | 52714 | 2022-10-10 | Georgia | 13 | 2825163 | 38808 |
52715 | 52715 | 2022-10-10 | Guam | 66 | 59616 | 402 |
52716 | 52716 | 2022-10-10 | Hawaii | 15 | 348570 | 1691 |
52717 | 52717 | 2022-10-10 | Idaho | 16 | 497106 | 5190 |
52718 | 52718 | 2022-10-10 | Illinois | 17 | 3780406 | 39777 |
52719 | 52719 | 2022-10-10 | Indiana | 18 | 1925645 | 24748 |
52720 | 52720 | 2022-10-10 | Iowa | 19 | 857944 | 10097 |
52721 | 52721 | 2022-10-10 | Kansas | 20 | 880654 | 9590 |
52722 | 52722 | 2022-10-10 | Kentucky | 21 | 1609141 | 17111 |
52723 | 52723 | 2022-10-10 | Louisiana | 22 | 1457916 | 18112 |
52724 | 52724 | 2022-10-10 | Maine | 23 | 291984 | 2611 |
52725 | 52725 | 2022-10-10 | Maryland | 24 | 1254937 | 15423 |
52726 | 52726 | 2022-10-10 | Massachusetts | 25 | 2060884 | 21771 |
52727 | 52727 | 2022-10-10 | Michigan | 26 | 2849047 | 38767 |
52728 | 52728 | 2022-10-10 | Minnesota | 27 | 1670765 | 13695 |
52729 | 52729 | 2022-10-10 | Mississippi | 28 | 929079 | 12928 |
52730 | 52730 | 2022-10-10 | Missouri | 29 | 1673684 | 21719 |
52731 | 52731 | 2022-10-10 | Montana | 30 | 311995 | 3555 |
52732 | 52732 | 2022-10-10 | Nebraska | 31 | 538494 | 4551 |
52733 | 52733 | 2022-10-10 | Nevada | 32 | 848770 | 11521 |
52734 | 52734 | 2022-10-10 | New Hampshire | 33 | 351929 | 2709 |
52735 | 52735 | 2022-10-10 | New Jersey | 34 | 2759767 | 34791 |
52736 | 52736 | 2022-10-10 | New Mexico | 35 | 620306 | 8597 |
52737 | 52737 | 2022-10-10 | New York | 36 | 6145553 | 71257 |
52738 | 52738 | 2022-10-10 | North Carolina | 37 | 3210837 | 26862 |
52739 | 52739 | 2022-10-10 | North Dakota | 38 | 270288 | 2422 |
52740 | 52740 | 2022-10-10 | Northern Mariana Islands | 69 | 13171 | 40 |
52741 | 52741 | 2022-10-10 | Ohio | 39 | 3153743 | 39950 |
52742 | 52742 | 2022-10-10 | Oklahoma | 40 | 1200650 | 14884 |
52743 | 52743 | 2022-10-10 | Oregon | 41 | 899013 | 8590 |
52744 | 52744 | 2022-10-10 | Pennsylvania | 42 | 3267569 | 47323 |
52745 | 52745 | 2022-10-10 | Puerto Rico | 72 | 997185 | 5183 |
52746 | 52746 | 2022-10-10 | Rhode Island | 44 | 427242 | 3674 |
52747 | 52747 | 2022-10-10 | South Carolina | 45 | 1712281 | 18390 |
52748 | 52748 | 2022-10-10 | South Dakota | 46 | 262213 | 3033 |
52749 | 52749 | 2022-10-10 | Tennessee | 47 | 2285845 | 27627 |
52750 | 52750 | 2022-10-10 | Texas | 48 | 7889760 | 91068 |
52751 | 52751 | 2022-10-10 | Utah | 49 | 1040427 | 5028 |
52752 | 52752 | 2022-10-10 | Vermont | 50 | 143049 | 728 |
52753 | 52753 | 2022-10-10 | Virgin Islands | 78 | 23207 | 123 |
52754 | 52754 | 2022-10-10 | Virginia | 51 | 2098414 | 21973 |
52755 | 52755 | 2022-10-10 | Washington | 53 | 1824762 | 14432 |
52756 | 52756 | 2022-10-10 | West Virginia | 54 | 602461 | 7450 |
52757 | 52757 | 2022-10-10 | Wisconsin | 55 | 1873754 | 15303 |
52758 | 52758 | 2022-10-10 | Wyoming | 56 | 177165 | 1899 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );