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-07 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 |
---|---|---|---|---|---|---|
22015 | 22015 | 2021-04-07 | Alabama | 1 | 517452 | 10652 |
22016 | 22016 | 2021-04-07 | Alaska | 2 | 63785 | 299 |
22017 | 22017 | 2021-04-07 | Arizona | 4 | 846241 | 17025 |
22018 | 22018 | 2021-04-07 | Arkansas | 5 | 331505 | 5660 |
22019 | 22019 | 2021-04-07 | California | 6 | 3687758 | 59976 |
22020 | 22020 | 2021-04-07 | Colorado | 8 | 473913 | 6195 |
22021 | 22021 | 2021-04-07 | Connecticut | 9 | 318767 | 7935 |
22022 | 22022 | 2021-04-07 | Delaware | 10 | 97042 | 1567 |
22023 | 22023 | 2021-04-07 | District of Columbia | 11 | 45328 | 1076 |
22024 | 22024 | 2021-04-07 | Florida | 12 | 2096739 | 33821 |
22025 | 22025 | 2021-04-07 | Georgia | 13 | 1044399 | 18714 |
22026 | 22026 | 2021-04-07 | Guam | 66 | 8797 | 137 |
22027 | 22027 | 2021-04-07 | Hawaii | 15 | 30552 | 464 |
22028 | 22028 | 2021-04-07 | Idaho | 16 | 182661 | 1984 |
22029 | 22029 | 2021-04-07 | Illinois | 17 | 1269002 | 23702 |
22030 | 22030 | 2021-04-07 | Indiana | 18 | 696749 | 13099 |
22031 | 22031 | 2021-04-07 | Iowa | 19 | 354828 | 5836 |
22032 | 22032 | 2021-04-07 | Kansas | 20 | 306077 | 4932 |
22033 | 22033 | 2021-04-07 | Kentucky | 21 | 434238 | 6295 |
22034 | 22034 | 2021-04-07 | Louisiana | 22 | 447655 | 10185 |
22035 | 22035 | 2021-04-07 | Maine | 23 | 52677 | 747 |
22036 | 22036 | 2021-04-07 | Maryland | 24 | 420712 | 8389 |
22037 | 22037 | 2021-04-07 | Massachusetts | 25 | 650573 | 17358 |
22038 | 22038 | 2021-04-07 | Michigan | 26 | 793898 | 17362 |
22039 | 22039 | 2021-04-07 | Minnesota | 27 | 532736 | 6986 |
22040 | 22040 | 2021-04-07 | Mississippi | 28 | 306611 | 7077 |
22041 | 22041 | 2021-04-07 | Missouri | 29 | 592986 | 9001 |
22042 | 22042 | 2021-04-07 | Montana | 30 | 105660 | 1490 |
22043 | 22043 | 2021-04-07 | Nebraska | 31 | 212785 | 2289 |
22044 | 22044 | 2021-04-07 | Nevada | 32 | 305929 | 5308 |
22045 | 22045 | 2021-04-07 | New Hampshire | 33 | 86935 | 1250 |
22046 | 22046 | 2021-04-07 | New Jersey | 34 | 937979 | 24744 |
22047 | 22047 | 2021-04-07 | New Mexico | 35 | 192989 | 3965 |
22048 | 22048 | 2021-04-07 | New York | 36 | 1923414 | 50332 |
22049 | 22049 | 2021-04-07 | North Carolina | 37 | 926071 | 12235 |
22050 | 22050 | 2021-04-07 | North Dakota | 38 | 104198 | 1499 |
22051 | 22051 | 2021-04-07 | Northern Mariana Islands | 69 | 160 | 2 |
22052 | 22052 | 2021-04-07 | Ohio | 39 | 1030864 | 18741 |
22053 | 22053 | 2021-04-07 | Oklahoma | 40 | 441906 | 6669 |
22054 | 22054 | 2021-04-07 | Oregon | 41 | 168129 | 2446 |
22055 | 22055 | 2021-04-07 | Pennsylvania | 42 | 1060102 | 25342 |
22056 | 22056 | 2021-04-07 | Puerto Rico | 72 | 143848 | 2139 |
22057 | 22057 | 2021-04-07 | Rhode Island | 44 | 140025 | 2635 |
22058 | 22058 | 2021-04-07 | South Carolina | 45 | 558631 | 9213 |
22059 | 22059 | 2021-04-07 | South Dakota | 46 | 118975 | 1938 |
22060 | 22060 | 2021-04-07 | Tennessee | 47 | 805232 | 11875 |
22061 | 22061 | 2021-04-07 | Texas | 48 | 2811415 | 49076 |
22062 | 22062 | 2021-04-07 | Utah | 49 | 388486 | 2139 |
22063 | 22063 | 2021-04-07 | Vermont | 50 | 20442 | 230 |
22064 | 22064 | 2021-04-07 | Virgin Islands | 78 | 2945 | 26 |
22065 | 22065 | 2021-04-07 | Virginia | 51 | 629155 | 10415 |
22066 | 22066 | 2021-04-07 | Washington | 53 | 374402 | 5357 |
22067 | 22067 | 2021-04-07 | West Virginia | 54 | 144374 | 2722 |
22068 | 22068 | 2021-04-07 | Wisconsin | 55 | 641851 | 7357 |
22069 | 22069 | 2021-04-07 | Wyoming | 56 | 56700 | 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 );