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 2020-10-24 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 |
---|---|---|---|---|---|---|
12940 | 12940 | 2020-10-24 | Alabama | 1 | 183276 | 2866 |
12941 | 12941 | 2020-10-24 | Alaska | 2 | 13439 | 64 |
12942 | 12942 | 2020-10-24 | Arizona | 4 | 236898 | 5870 |
12943 | 12943 | 2020-10-24 | Arkansas | 5 | 105318 | 1797 |
12944 | 12944 | 2020-10-24 | California | 6 | 906645 | 17345 |
12945 | 12945 | 2020-10-24 | Colorado | 8 | 93989 | 2241 |
12946 | 12946 | 2020-10-24 | Connecticut | 9 | 66052 | 4577 |
12947 | 12947 | 2020-10-24 | Delaware | 10 | 23847 | 680 |
12948 | 12948 | 2020-10-24 | District of Columbia | 11 | 16706 | 642 |
12949 | 12949 | 2020-10-24 | Florida | 12 | 776243 | 16416 |
12950 | 12950 | 2020-10-24 | Georgia | 13 | 359001 | 7625 |
12951 | 12951 | 2020-10-24 | Guam | 66 | 5144 | 72 |
12952 | 12952 | 2020-10-24 | Hawaii | 15 | 14706 | 211 |
12953 | 12953 | 2020-10-24 | Idaho | 16 | 58964 | 573 |
12954 | 12954 | 2020-10-24 | Illinois | 17 | 376034 | 9765 |
12955 | 12955 | 2020-10-24 | Indiana | 18 | 162886 | 4118 |
12956 | 12956 | 2020-10-24 | Iowa | 19 | 114952 | 1634 |
12957 | 12957 | 2020-10-24 | Kansas | 20 | 78177 | 975 |
12958 | 12958 | 2020-10-24 | Kentucky | 21 | 97501 | 1469 |
12959 | 12959 | 2020-10-24 | Louisiana | 22 | 182603 | 5820 |
12960 | 12960 | 2020-10-24 | Maine | 23 | 6137 | 146 |
12961 | 12961 | 2020-10-24 | Maryland | 24 | 139859 | 4091 |
12962 | 12962 | 2020-10-24 | Massachusetts | 25 | 149488 | 9839 |
12963 | 12963 | 2020-10-24 | Michigan | 26 | 175385 | 7522 |
12964 | 12964 | 2020-10-24 | Minnesota | 27 | 132175 | 2381 |
12965 | 12965 | 2020-10-24 | Mississippi | 28 | 115088 | 3255 |
12966 | 12966 | 2020-10-24 | Missouri | 29 | 173746 | 2854 |
12967 | 12967 | 2020-10-24 | Montana | 30 | 27149 | 295 |
12968 | 12968 | 2020-10-24 | Nebraska | 31 | 63264 | 607 |
12969 | 12969 | 2020-10-24 | Nevada | 32 | 94935 | 1746 |
12970 | 12970 | 2020-10-24 | New Hampshire | 33 | 10238 | 473 |
12971 | 12971 | 2020-10-24 | New Jersey | 34 | 229128 | 16281 |
12972 | 12972 | 2020-10-24 | New Mexico | 35 | 41040 | 965 |
12973 | 12973 | 2020-10-24 | New York | 36 | 498568 | 33049 |
12974 | 12974 | 2020-10-24 | North Carolina | 37 | 258439 | 4170 |
12975 | 12975 | 2020-10-24 | North Dakota | 38 | 36879 | 453 |
12976 | 12976 | 2020-10-24 | Northern Mariana Islands | 69 | 88 | 2 |
12977 | 12977 | 2020-10-24 | Ohio | 39 | 195806 | 5206 |
12978 | 12978 | 2020-10-24 | Oklahoma | 40 | 115685 | 1245 |
12979 | 12979 | 2020-10-24 | Oregon | 41 | 41739 | 654 |
12980 | 12980 | 2020-10-24 | Pennsylvania | 42 | 197370 | 8721 |
12981 | 12981 | 2020-10-24 | Puerto Rico | 72 | 61280 | 794 |
12982 | 12982 | 2020-10-24 | Rhode Island | 44 | 30118 | 1177 |
12983 | 12983 | 2020-10-24 | South Carolina | 45 | 169341 | 3793 |
12984 | 12984 | 2020-10-24 | South Dakota | 46 | 38141 | 366 |
12985 | 12985 | 2020-10-24 | Tennessee | 47 | 240191 | 3067 |
12986 | 12986 | 2020-10-24 | Texas | 48 | 906657 | 17998 |
12987 | 12987 | 2020-10-24 | Utah | 49 | 103137 | 568 |
12988 | 12988 | 2020-10-24 | Vermont | 50 | 2043 | 58 |
12989 | 12989 | 2020-10-24 | Virgin Islands | 78 | 1346 | 21 |
12990 | 12990 | 2020-10-24 | Virginia | 51 | 172372 | 3578 |
12991 | 12991 | 2020-10-24 | Washington | 53 | 106772 | 2396 |
12992 | 12992 | 2020-10-24 | West Virginia | 54 | 21712 | 422 |
12993 | 12993 | 2020-10-24 | Wisconsin | 55 | 205139 | 1804 |
12994 | 12994 | 2020-10-24 | Wyoming | 56 | 10805 | 68 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );