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-06 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|
11950 | 11950 | 2020-10-06 | Alabama | 1 | 160477 | 2580 |
11951 | 11951 | 2020-10-06 | Alaska | 2 | 9656 | 54 |
11952 | 11952 | 2020-10-06 | Arizona | 4 | 221937 | 5713 |
11953 | 11953 | 2020-10-06 | Arkansas | 5 | 88071 | 1469 |
11954 | 11954 | 2020-10-06 | California | 6 | 840324 | 16251 |
11955 | 11955 | 2020-10-06 | Colorado | 8 | 74535 | 2094 |
11956 | 11956 | 2020-10-06 | Connecticut | 9 | 59241 | 4521 |
11957 | 11957 | 2020-10-06 | Delaware | 10 | 21466 | 646 |
11958 | 11958 | 2020-10-06 | District of Columbia | 11 | 15652 | 631 |
11959 | 11959 | 2020-10-06 | Florida | 12 | 720117 | 14766 |
11960 | 11960 | 2020-10-06 | Georgia | 13 | 329101 | 7062 |
11961 | 11961 | 2020-10-06 | Guam | 66 | 3787 | 56 |
11962 | 11962 | 2020-10-06 | Hawaii | 15 | 13090 | 159 |
11963 | 11963 | 2020-10-06 | Idaho | 16 | 45487 | 494 |
11964 | 11964 | 2020-10-06 | Illinois | 17 | 308990 | 9100 |
11965 | 11965 | 2020-10-06 | Indiana | 18 | 129281 | 3711 |
11966 | 11966 | 2020-10-06 | Iowa | 19 | 93909 | 1414 |
11967 | 11967 | 2020-10-06 | Kansas | 20 | 64077 | 706 |
11968 | 11968 | 2020-10-06 | Kentucky | 21 | 77741 | 1255 |
11969 | 11969 | 2020-10-06 | Louisiana | 22 | 170469 | 5592 |
11970 | 11970 | 2020-10-06 | Maine | 23 | 5565 | 142 |
11971 | 11971 | 2020-10-06 | Maryland | 24 | 128691 | 3967 |
11972 | 11972 | 2020-10-06 | Massachusetts | 25 | 135957 | 9538 |
11973 | 11973 | 2020-10-06 | Michigan | 26 | 143901 | 7163 |
11974 | 11974 | 2020-10-06 | Minnesota | 27 | 105793 | 2140 |
11975 | 11975 | 2020-10-06 | Mississippi | 28 | 101678 | 3027 |
11976 | 11976 | 2020-10-06 | Missouri | 29 | 139172 | 2258 |
11977 | 11977 | 2020-10-06 | Montana | 30 | 15633 | 192 |
11978 | 11978 | 2020-10-06 | Nebraska | 31 | 48757 | 511 |
11979 | 11979 | 2020-10-06 | Nevada | 32 | 83036 | 1630 |
11980 | 11980 | 2020-10-06 | New Hampshire | 33 | 8731 | 446 |
11981 | 11981 | 2020-10-06 | New Jersey | 34 | 211129 | 16147 |
11982 | 11982 | 2020-10-06 | New Mexico | 35 | 30947 | 894 |
11983 | 11983 | 2020-10-06 | New York | 36 | 471638 | 32836 |
11984 | 11984 | 2020-10-06 | North Carolina | 37 | 221438 | 3691 |
11985 | 11985 | 2020-10-06 | North Dakota | 38 | 24368 | 284 |
11986 | 11986 | 2020-10-06 | Northern Mariana Islands | 69 | 75 | 2 |
11987 | 11987 | 2020-10-06 | Ohio | 39 | 161299 | 4947 |
11988 | 11988 | 2020-10-06 | Oklahoma | 40 | 93346 | 1066 |
11989 | 11989 | 2020-10-06 | Oregon | 41 | 35347 | 581 |
11990 | 11990 | 2020-10-06 | Pennsylvania | 42 | 170255 | 8318 |
11991 | 11991 | 2020-10-06 | Puerto Rico | 72 | 51737 | 696 |
11992 | 11992 | 2020-10-06 | Rhode Island | 44 | 25596 | 1125 |
11993 | 11993 | 2020-10-06 | South Carolina | 45 | 152970 | 3471 |
11994 | 11994 | 2020-10-06 | South Dakota | 46 | 24876 | 248 |
11995 | 11995 | 2020-10-06 | Tennessee | 47 | 202257 | 2594 |
11996 | 11996 | 2020-10-06 | Texas | 48 | 811191 | 16622 |
11997 | 11997 | 2020-10-06 | Utah | 49 | 79449 | 489 |
11998 | 11998 | 2020-10-06 | Vermont | 50 | 1821 | 58 |
11999 | 11999 | 2020-10-06 | Virgin Islands | 78 | 1321 | 20 |
12000 | 12000 | 2020-10-06 | Virginia | 51 | 153182 | 3291 |
12001 | 12001 | 2020-10-06 | Washington | 53 | 94694 | 2261 |
12002 | 12002 | 2020-10-06 | West Virginia | 54 | 16936 | 364 |
12003 | 12003 | 2020-10-06 | Wisconsin | 55 | 143886 | 1410 |
12004 | 12004 | 2020-10-06 | Wyoming | 56 | 6770 | 53 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );