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-10-05 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
31983 | 31983 | 2021-10-05 | Alabama | 1 | 802977 | 14542 |
31984 | 31984 | 2021-10-05 | Alaska | 2 | 117953 | 564 |
31985 | 31985 | 2021-10-05 | American Samoa | 60 | 3 | 0 |
31986 | 31986 | 2021-10-05 | Arizona | 4 | 1106789 | 20211 |
31987 | 31987 | 2021-10-05 | Arkansas | 5 | 499004 | 7775 |
31988 | 31988 | 2021-10-05 | California | 6 | 4769383 | 69652 |
31989 | 31989 | 2021-10-05 | Colorado | 8 | 684036 | 7822 |
31990 | 31990 | 2021-10-05 | Connecticut | 9 | 392574 | 8666 |
31991 | 31991 | 2021-10-05 | Delaware | 10 | 135267 | 1975 |
31992 | 31992 | 2021-10-05 | District of Columbia | 11 | 61863 | 1179 |
31993 | 31993 | 2021-10-05 | Florida | 12 | 3590400 | 55622 |
31994 | 31994 | 2021-10-05 | Georgia | 13 | 1557675 | 25732 |
31995 | 31995 | 2021-10-05 | Guam | 66 | 16434 | 205 |
31996 | 31996 | 2021-10-05 | Hawaii | 15 | 77963 | 808 |
31997 | 31997 | 2021-10-05 | Idaho | 16 | 263340 | 2994 |
31998 | 31998 | 2021-10-05 | Illinois | 17 | 1645978 | 27811 |
31999 | 31999 | 2021-10-05 | Indiana | 18 | 977567 | 15844 |
32000 | 32000 | 2021-10-05 | Iowa | 19 | 458908 | 6563 |
32001 | 32001 | 2021-10-05 | Kansas | 20 | 414129 | 6098 |
32002 | 32002 | 2021-10-05 | Kentucky | 21 | 708731 | 9011 |
32003 | 32003 | 2021-10-05 | Louisiana | 22 | 744651 | 14068 |
32004 | 32004 | 2021-10-05 | Maine | 23 | 92365 | 1036 |
32005 | 32005 | 2021-10-05 | Maryland | 24 | 538206 | 10512 |
32006 | 32006 | 2021-10-05 | Massachusetts | 25 | 818290 | 18680 |
32007 | 32007 | 2021-10-05 | Michigan | 26 | 1167278 | 22486 |
32008 | 32008 | 2021-10-05 | Minnesota | 27 | 725564 | 8316 |
32009 | 32009 | 2021-10-05 | Mississippi | 28 | 491724 | 9749 |
32010 | 32010 | 2021-10-05 | Missouri | 29 | 843678 | 12354 |
32011 | 32011 | 2021-10-05 | Montana | 30 | 154900 | 2048 |
32012 | 32012 | 2021-10-05 | Nebraska | 31 | 269138 | 2840 |
32013 | 32013 | 2021-10-05 | Nevada | 32 | 425143 | 7221 |
32014 | 32014 | 2021-10-05 | New Hampshire | 33 | 122450 | 1490 |
32015 | 32015 | 2021-10-05 | New Jersey | 34 | 1162526 | 27525 |
32016 | 32016 | 2021-10-05 | New Mexico | 35 | 256115 | 4832 |
32017 | 32017 | 2021-10-05 | New York | 36 | 2447269 | 55090 |
32018 | 32018 | 2021-10-05 | North Carolina | 37 | 1415881 | 16829 |
32019 | 32019 | 2021-10-05 | North Dakota | 38 | 134955 | 1656 |
32020 | 32020 | 2021-10-05 | Northern Mariana Islands | 69 | 272 | 2 |
32021 | 32021 | 2021-10-05 | Ohio | 39 | 1439490 | 22490 |
32022 | 32022 | 2021-10-05 | Oklahoma | 40 | 619738 | 8949 |
32023 | 32023 | 2021-10-05 | Oregon | 41 | 336598 | 3867 |
32024 | 32024 | 2021-10-05 | Pennsylvania | 42 | 1453387 | 29611 |
32025 | 32025 | 2021-10-05 | Puerto Rico | 72 | 215412 | 3172 |
32026 | 32026 | 2021-10-05 | Rhode Island | 44 | 173603 | 2845 |
32027 | 32027 | 2021-10-05 | South Carolina | 45 | 868574 | 12729 |
32028 | 32028 | 2021-10-05 | South Dakota | 46 | 146594 | 2161 |
32029 | 32029 | 2021-10-05 | Tennessee | 47 | 1212729 | 15277 |
32030 | 32030 | 2021-10-05 | Texas | 48 | 4095417 | 66638 |
32031 | 32031 | 2021-10-05 | Utah | 49 | 514873 | 2962 |
32032 | 32032 | 2021-10-05 | Vermont | 50 | 34505 | 323 |
32033 | 32033 | 2021-10-05 | Virgin Islands | 78 | 6841 | 72 |
32034 | 32034 | 2021-10-05 | Virginia | 51 | 878518 | 12955 |
32035 | 32035 | 2021-10-05 | Washington | 53 | 672888 | 7909 |
32036 | 32036 | 2021-10-05 | West Virginia | 54 | 246408 | 3774 |
32037 | 32037 | 2021-10-05 | Wisconsin | 55 | 825699 | 8960 |
32038 | 32038 | 2021-10-05 | Wyoming | 56 | 92517 | 1041 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );