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-05-16 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 |
---|---|---|---|---|---|---|
24160 | 24160 | 2021-05-16 | Alabama | 1 | 540083 | 11038 |
24161 | 24161 | 2021-05-16 | Alaska | 2 | 68897 | 336 |
24162 | 24162 | 2021-05-16 | Arizona | 4 | 872978 | 17466 |
24163 | 24163 | 2021-05-16 | Arkansas | 5 | 338782 | 5794 |
24164 | 24164 | 2021-05-16 | California | 6 | 3769052 | 62681 |
24165 | 24165 | 2021-05-16 | Colorado | 8 | 534685 | 6591 |
24166 | 24166 | 2021-05-16 | Connecticut | 9 | 344977 | 8173 |
24167 | 24167 | 2021-05-16 | Delaware | 10 | 107007 | 1651 |
24168 | 24168 | 2021-05-16 | District of Columbia | 11 | 48545 | 1120 |
24169 | 24169 | 2021-05-16 | Florida | 12 | 2291996 | 36074 |
24170 | 24170 | 2021-05-16 | Georgia | 13 | 1090990 | 19860 |
24171 | 24171 | 2021-05-16 | Guam | 66 | 9060 | 140 |
24172 | 24172 | 2021-05-16 | Hawaii | 15 | 34180 | 489 |
24173 | 24173 | 2021-05-16 | Idaho | 16 | 189982 | 2071 |
24174 | 24174 | 2021-05-16 | Illinois | 17 | 1370094 | 24795 |
24175 | 24175 | 2021-05-16 | Indiana | 18 | 738790 | 13480 |
24176 | 24176 | 2021-05-16 | Iowa | 19 | 369368 | 6006 |
24177 | 24177 | 2021-05-16 | Kansas | 20 | 313776 | 5079 |
24178 | 24178 | 2021-05-16 | Kentucky | 21 | 455177 | 6829 |
24179 | 24179 | 2021-05-16 | Louisiana | 22 | 464833 | 10478 |
24180 | 24180 | 2021-05-16 | Maine | 23 | 65715 | 802 |
24181 | 24181 | 2021-05-16 | Maryland | 24 | 456196 | 8929 |
24182 | 24182 | 2021-05-16 | Massachusetts | 25 | 702039 | 17753 |
24183 | 24183 | 2021-05-16 | Michigan | 26 | 974436 | 19775 |
24184 | 24184 | 2021-05-16 | Minnesota | 27 | 594520 | 7389 |
24185 | 24185 | 2021-05-16 | Mississippi | 28 | 314710 | 7254 |
24186 | 24186 | 2021-05-16 | Missouri | 29 | 608962 | 9392 |
24187 | 24187 | 2021-05-16 | Montana | 30 | 110779 | 1598 |
24188 | 24188 | 2021-05-16 | Nebraska | 31 | 222335 | 2378 |
24189 | 24189 | 2021-05-16 | Nevada | 32 | 320539 | 5530 |
24190 | 24190 | 2021-05-16 | New Hampshire | 33 | 97676 | 1332 |
24191 | 24191 | 2021-05-16 | New Jersey | 34 | 1010759 | 25961 |
24192 | 24192 | 2021-05-16 | New Mexico | 35 | 200650 | 4115 |
24193 | 24193 | 2021-05-16 | New York | 36 | 2083649 | 52417 |
24194 | 24194 | 2021-05-16 | North Carolina | 37 | 990114 | 12885 |
24195 | 24195 | 2021-05-16 | North Dakota | 38 | 109134 | 1534 |
24196 | 24196 | 2021-05-16 | Northern Mariana Islands | 69 | 172 | 2 |
24197 | 24197 | 2021-05-16 | Ohio | 39 | 1090894 | 19528 |
24198 | 24198 | 2021-05-16 | Oklahoma | 40 | 450847 | 6878 |
24199 | 24199 | 2021-05-16 | Oregon | 41 | 195684 | 2602 |
24200 | 24200 | 2021-05-16 | Pennsylvania | 42 | 1190577 | 26869 |
24201 | 24201 | 2021-05-16 | Puerto Rico | 72 | 170270 | 2435 |
24202 | 24202 | 2021-05-16 | Rhode Island | 44 | 150385 | 2700 |
24203 | 24203 | 2021-05-16 | South Carolina | 45 | 588593 | 9653 |
24204 | 24204 | 2021-05-16 | South Dakota | 46 | 123644 | 1991 |
24205 | 24205 | 2021-05-16 | Tennessee | 47 | 842366 | 12213 |
24206 | 24206 | 2021-05-16 | Texas | 48 | 2924188 | 51105 |
24207 | 24207 | 2021-05-16 | Utah | 49 | 402634 | 2258 |
24208 | 24208 | 2021-05-16 | Vermont | 50 | 23883 | 252 |
24209 | 24209 | 2021-05-16 | Virgin Islands | 78 | 3267 | 27 |
24210 | 24210 | 2021-05-16 | Virginia | 51 | 670192 | 11018 |
24211 | 24211 | 2021-05-16 | Washington | 53 | 424581 | 5663 |
24212 | 24212 | 2021-05-16 | West Virginia | 54 | 158468 | 2761 |
24213 | 24213 | 2021-05-16 | Wisconsin | 55 | 669636 | 7712 |
24214 | 24214 | 2021-05-16 | Wyoming | 56 | 59079 | 712 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );