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 2021-01-23 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- 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
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
17945 | 17945 | 2021-01-23 | Alabama | 1 | 439442 | 6657 |
17946 | 17946 | 2021-01-23 | Alaska | 2 | 52820 | 250 |
17947 | 17947 | 2021-01-23 | Arizona | 4 | 717593 | 12170 |
17948 | 17948 | 2021-01-23 | Arkansas | 5 | 282995 | 4563 |
17949 | 17949 | 2021-01-23 | California | 6 | 3164386 | 36818 |
17950 | 17950 | 2021-01-23 | Colorado | 8 | 386432 | 5561 |
17951 | 17951 | 2021-01-23 | Connecticut | 9 | 237815 | 6819 |
17952 | 17952 | 2021-01-23 | Delaware | 10 | 73915 | 1036 |
17953 | 17953 | 2021-01-23 | District of Columbia | 11 | 35077 | 870 |
17954 | 17954 | 2021-01-23 | Florida | 12 | 1639906 | 25163 |
17955 | 17955 | 2021-01-23 | Georgia | 13 | 838057 | 12834 |
17956 | 17956 | 2021-01-23 | Guam | 66 | 8516 | 129 |
17957 | 17957 | 2021-01-23 | Hawaii | 15 | 24950 | 333 |
17958 | 17958 | 2021-01-23 | Idaho | 16 | 159406 | 1670 |
17959 | 17959 | 2021-01-23 | Illinois | 17 | 1101037 | 20645 |
17960 | 17960 | 2021-01-23 | Indiana | 18 | 611600 | 9693 |
17961 | 17961 | 2021-01-23 | Iowa | 19 | 312625 | 4486 |
17962 | 17962 | 2021-01-23 | Kansas | 20 | 269611 | 3598 |
17963 | 17963 | 2021-01-23 | Kentucky | 21 | 348040 | 3657 |
17964 | 17964 | 2021-01-23 | Louisiana | 22 | 380255 | 8483 |
17965 | 17965 | 2021-01-23 | Maine | 23 | 36598 | 544 |
17966 | 17966 | 2021-01-23 | Maryland | 24 | 339482 | 6837 |
17967 | 17967 | 2021-01-23 | Massachusetts | 25 | 496093 | 14064 |
17968 | 17968 | 2021-01-23 | Michigan | 26 | 594666 | 15170 |
17969 | 17969 | 2021-01-23 | Minnesota | 27 | 453876 | 6131 |
17970 | 17970 | 2021-01-23 | Mississippi | 28 | 263023 | 5752 |
17971 | 17971 | 2021-01-23 | Missouri | 29 | 485926 | 6949 |
17972 | 17972 | 2021-01-23 | Montana | 30 | 91448 | 1142 |
17973 | 17973 | 2021-01-23 | Nebraska | 31 | 187974 | 1966 |
17974 | 17974 | 2021-01-23 | Nevada | 32 | 269928 | 4017 |
17975 | 17975 | 2021-01-23 | New Hampshire | 33 | 61576 | 981 |
17976 | 17976 | 2021-01-23 | New Jersey | 34 | 657536 | 20934 |
17977 | 17977 | 2021-01-23 | New Mexico | 35 | 168579 | 3117 |
17978 | 17978 | 2021-01-23 | New York | 36 | 1323569 | 41694 |
17979 | 17979 | 2021-01-23 | North Carolina | 37 | 713300 | 8623 |
17980 | 17980 | 2021-01-23 | North Dakota | 38 | 96745 | 1436 |
17981 | 17981 | 2021-01-23 | Northern Mariana Islands | 69 | 129 | 2 |
17982 | 17982 | 2021-01-23 | Ohio | 39 | 859841 | 10680 |
17983 | 17983 | 2021-01-23 | Oklahoma | 40 | 370149 | 3231 |
17984 | 17984 | 2021-01-23 | Oregon | 41 | 137600 | 1882 |
17985 | 17985 | 2021-01-23 | Pennsylvania | 42 | 805272 | 20526 |
17986 | 17986 | 2021-01-23 | Puerto Rico | 72 | 123688 | 1771 |
17987 | 17987 | 2021-01-23 | Rhode Island | 44 | 109735 | 2083 |
17988 | 17988 | 2021-01-23 | South Carolina | 45 | 413789 | 6479 |
17989 | 17989 | 2021-01-23 | South Dakota | 46 | 106963 | 1696 |
17990 | 17990 | 2021-01-23 | Tennessee | 47 | 692048 | 8736 |
17991 | 17991 | 2021-01-23 | Texas | 48 | 2240136 | 34859 |
17992 | 17992 | 2021-01-23 | Utah | 49 | 334889 | 1582 |
17993 | 17993 | 2021-01-23 | Vermont | 50 | 10908 | 170 |
17994 | 17994 | 2021-01-23 | Virgin Islands | 78 | 2341 | 24 |
17995 | 17995 | 2021-01-23 | Virginia | 51 | 468655 | 6079 |
17996 | 17996 | 2021-01-23 | Washington | 53 | 304107 | 4182 |
17997 | 17997 | 2021-01-23 | West Virginia | 54 | 114752 | 1872 |
17998 | 17998 | 2021-01-23 | Wisconsin | 55 | 580003 | 6187 |
17999 | 17999 | 2021-01-23 | Wyoming | 56 | 50583 | 571 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );