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-09-19 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 |
---|---|---|---|---|---|---|
11015 | 11015 | 2020-09-19 | Alabama | 1 | 144164 | 2437 |
11016 | 11016 | 2020-09-19 | Alaska | 2 | 7613 | 42 |
11017 | 11017 | 2020-09-19 | Arizona | 4 | 213551 | 5471 |
11018 | 11018 | 2020-09-19 | Arkansas | 5 | 75160 | 1181 |
11019 | 11019 | 2020-09-19 | California | 6 | 785077 | 15023 |
11020 | 11020 | 2020-09-19 | Colorado | 8 | 64694 | 2022 |
11021 | 11021 | 2020-09-19 | Connecticut | 9 | 55527 | 4492 |
11022 | 11022 | 2020-09-19 | Delaware | 10 | 19449 | 621 |
11023 | 11023 | 2020-09-19 | District of Columbia | 11 | 14902 | 619 |
11024 | 11024 | 2020-09-19 | Florida | 12 | 681225 | 13286 |
11025 | 11025 | 2020-09-19 | Georgia | 13 | 288059 | 6450 |
11026 | 11026 | 2020-09-19 | Guam | 66 | 3043 | 35 |
11027 | 11027 | 2020-09-19 | Hawaii | 15 | 11457 | 119 |
11028 | 11028 | 2020-09-19 | Idaho | 16 | 37624 | 441 |
11029 | 11029 | 2020-09-19 | Illinois | 17 | 276057 | 8688 |
11030 | 11030 | 2020-09-19 | Indiana | 18 | 112982 | 3503 |
11031 | 11031 | 2020-09-19 | Iowa | 19 | 79785 | 1265 |
11032 | 11032 | 2020-09-19 | Kansas | 20 | 53420 | 596 |
11033 | 11033 | 2020-09-19 | Kentucky | 21 | 65068 | 1137 |
11034 | 11034 | 2020-09-19 | Louisiana | 22 | 161322 | 5340 |
11035 | 11035 | 2020-09-19 | Maine | 23 | 5035 | 139 |
11036 | 11036 | 2020-09-19 | Maryland | 24 | 120107 | 3876 |
11037 | 11037 | 2020-09-19 | Massachusetts | 25 | 127181 | 9295 |
11038 | 11038 | 2020-09-19 | Michigan | 26 | 128112 | 6970 |
11039 | 11039 | 2020-09-19 | Minnesota | 27 | 88773 | 2015 |
11040 | 11040 | 2020-09-19 | Mississippi | 28 | 93087 | 2809 |
11041 | 11041 | 2020-09-19 | Missouri | 29 | 113794 | 1905 |
11042 | 11042 | 2020-09-19 | Montana | 30 | 10193 | 156 |
11043 | 11043 | 2020-09-19 | Nebraska | 31 | 40797 | 457 |
11044 | 11044 | 2020-09-19 | Nevada | 32 | 75524 | 1528 |
11045 | 11045 | 2020-09-19 | New Hampshire | 33 | 7920 | 438 |
11046 | 11046 | 2020-09-19 | New Jersey | 34 | 201100 | 16064 |
11047 | 11047 | 2020-09-19 | New Mexico | 35 | 27512 | 847 |
11048 | 11048 | 2020-09-19 | New York | 36 | 453747 | 32679 |
11049 | 11049 | 2020-09-19 | North Carolina | 37 | 192751 | 3260 |
11050 | 11050 | 2020-09-19 | North Dakota | 38 | 17610 | 195 |
11051 | 11051 | 2020-09-19 | Northern Mariana Islands | 69 | 68 | 2 |
11052 | 11052 | 2020-09-19 | Ohio | 39 | 143547 | 4612 |
11053 | 11053 | 2020-09-19 | Oklahoma | 40 | 75804 | 943 |
11054 | 11054 | 2020-09-19 | Oregon | 41 | 30600 | 527 |
11055 | 11055 | 2020-09-19 | Pennsylvania | 42 | 154261 | 8028 |
11056 | 11056 | 2020-09-19 | Puerto Rico | 72 | 40993 | 605 |
11057 | 11057 | 2020-09-19 | Rhode Island | 44 | 23620 | 1088 |
11058 | 11058 | 2020-09-19 | South Carolina | 45 | 137240 | 3188 |
11059 | 11059 | 2020-09-19 | South Dakota | 46 | 18444 | 200 |
11060 | 11060 | 2020-09-19 | Tennessee | 47 | 179017 | 2193 |
11061 | 11061 | 2020-09-19 | Texas | 48 | 716914 | 15124 |
11062 | 11062 | 2020-09-19 | Utah | 49 | 62893 | 440 |
11063 | 11063 | 2020-09-19 | Vermont | 50 | 1710 | 58 |
11064 | 11064 | 2020-09-19 | Virgin Islands | 78 | 1257 | 19 |
11065 | 11065 | 2020-09-19 | Virginia | 51 | 139655 | 2990 |
11066 | 11066 | 2020-09-19 | Washington | 53 | 85886 | 2130 |
11067 | 11067 | 2020-09-19 | West Virginia | 54 | 13874 | 308 |
11068 | 11068 | 2020-09-19 | Wisconsin | 55 | 105609 | 1249 |
11069 | 11069 | 2020-09-19 | Wyoming | 56 | 4780 | 49 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );