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-04-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 |
---|---|---|---|---|---|---|
21960 | 21960 | 2021-04-06 | Alabama | 1 | 517114 | 10652 |
21961 | 21961 | 2021-04-06 | Alaska | 2 | 63566 | 299 |
21962 | 21962 | 2021-04-06 | Arizona | 4 | 845488 | 16997 |
21963 | 21963 | 2021-04-06 | Arkansas | 5 | 331261 | 5653 |
21964 | 21964 | 2021-04-06 | California | 6 | 3685338 | 59874 |
21965 | 21965 | 2021-04-06 | Colorado | 8 | 472941 | 6194 |
21966 | 21966 | 2021-04-06 | Connecticut | 9 | 317729 | 7930 |
21967 | 21967 | 2021-04-06 | Delaware | 10 | 96806 | 1567 |
21968 | 21968 | 2021-04-06 | District of Columbia | 11 | 45234 | 1074 |
21969 | 21969 | 2021-04-06 | Florida | 12 | 2090854 | 33779 |
21970 | 21970 | 2021-04-06 | Georgia | 13 | 1042793 | 18651 |
21971 | 21971 | 2021-04-06 | Guam | 66 | 8794 | 137 |
21972 | 21972 | 2021-04-06 | Hawaii | 15 | 30479 | 464 |
21973 | 21973 | 2021-04-06 | Idaho | 16 | 182315 | 1977 |
21974 | 21974 | 2021-04-06 | Illinois | 17 | 1265309 | 23673 |
21975 | 21975 | 2021-04-06 | Indiana | 18 | 695532 | 13084 |
21976 | 21976 | 2021-04-06 | Iowa | 19 | 354557 | 5835 |
21977 | 21977 | 2021-04-06 | Kansas | 20 | 305508 | 4927 |
21978 | 21978 | 2021-04-06 | Kentucky | 21 | 433269 | 6278 |
21979 | 21979 | 2021-04-06 | Louisiana | 22 | 446955 | 10174 |
21980 | 21980 | 2021-04-06 | Maine | 23 | 52276 | 746 |
21981 | 21981 | 2021-04-06 | Maryland | 24 | 419241 | 8378 |
21982 | 21982 | 2021-04-06 | Massachusetts | 25 | 648023 | 17337 |
21983 | 21983 | 2021-04-06 | Michigan | 26 | 784542 | 17332 |
21984 | 21984 | 2021-04-06 | Minnesota | 27 | 530740 | 6967 |
21985 | 21985 | 2021-04-06 | Mississippi | 28 | 306341 | 7073 |
21986 | 21986 | 2021-04-06 | Missouri | 29 | 592195 | 8999 |
21987 | 21987 | 2021-04-06 | Montana | 30 | 105470 | 1477 |
21988 | 21988 | 2021-04-06 | Nebraska | 31 | 212257 | 2288 |
21989 | 21989 | 2021-04-06 | Nevada | 32 | 305655 | 5297 |
21990 | 21990 | 2021-04-06 | New Hampshire | 33 | 86510 | 1249 |
21991 | 21991 | 2021-04-06 | New Jersey | 34 | 933738 | 24700 |
21992 | 21992 | 2021-04-06 | New Mexico | 35 | 192773 | 3963 |
21993 | 21993 | 2021-04-06 | New York | 36 | 1916964 | 50239 |
21994 | 21994 | 2021-04-06 | North Carolina | 37 | 924682 | 12211 |
21995 | 21995 | 2021-04-06 | North Dakota | 38 | 104005 | 1499 |
21996 | 21996 | 2021-04-06 | Northern Mariana Islands | 69 | 159 | 2 |
21997 | 21997 | 2021-04-06 | Ohio | 39 | 1028800 | 18741 |
21998 | 21998 | 2021-04-06 | Oklahoma | 40 | 440142 | 4953 |
21999 | 21999 | 2021-04-06 | Oregon | 41 | 167685 | 2432 |
22000 | 22000 | 2021-04-06 | Pennsylvania | 42 | 1055498 | 25291 |
22001 | 22001 | 2021-04-06 | Puerto Rico | 72 | 143637 | 2136 |
22002 | 22002 | 2021-04-06 | Rhode Island | 44 | 139549 | 2632 |
22003 | 22003 | 2021-04-06 | South Carolina | 45 | 557803 | 9204 |
22004 | 22004 | 2021-04-06 | South Dakota | 46 | 118680 | 1938 |
22005 | 22005 | 2021-04-06 | Tennessee | 47 | 803916 | 11866 |
22006 | 22006 | 2021-04-06 | Texas | 48 | 2807504 | 48968 |
22007 | 22007 | 2021-04-06 | Utah | 49 | 387874 | 2137 |
22008 | 22008 | 2021-04-06 | Vermont | 50 | 20373 | 229 |
22009 | 22009 | 2021-04-06 | Virgin Islands | 78 | 2945 | 26 |
22010 | 22010 | 2021-04-06 | Virginia | 51 | 627605 | 10401 |
22011 | 22011 | 2021-04-06 | Washington | 53 | 373227 | 5350 |
22012 | 22012 | 2021-04-06 | West Virginia | 54 | 144010 | 2707 |
22013 | 22013 | 2021-04-06 | Wisconsin | 55 | 640913 | 7350 |
22014 | 22014 | 2021-04-06 | Wyoming | 56 | 56619 | 701 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );