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-09-04 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 |
---|---|---|---|---|---|---|
30265 | 30265 | 2021-09-04 | Alabama | 1 | 719280 | 12414 |
30266 | 30266 | 2021-09-04 | Alaska | 2 | 89927 | 431 |
30267 | 30267 | 2021-09-04 | Arizona | 4 | 1027359 | 18997 |
30268 | 30268 | 2021-09-04 | Arkansas | 5 | 462723 | 7038 |
30269 | 30269 | 2021-09-04 | California | 6 | 4508025 | 66388 |
30270 | 30270 | 2021-09-04 | Colorado | 8 | 625672 | 7370 |
30271 | 30271 | 2021-09-04 | Connecticut | 9 | 375135 | 8394 |
30272 | 30272 | 2021-09-04 | Delaware | 10 | 121744 | 1891 |
30273 | 30273 | 2021-09-04 | District of Columbia | 11 | 55918 | 1162 |
30274 | 30274 | 2021-09-04 | Florida | 12 | 3308916 | 46324 |
30275 | 30275 | 2021-09-04 | Georgia | 13 | 1401865 | 22373 |
30276 | 30276 | 2021-09-04 | Guam | 66 | 12168 | 152 |
30277 | 30277 | 2021-09-04 | Hawaii | 15 | 64597 | 611 |
30278 | 30278 | 2021-09-04 | Idaho | 16 | 225604 | 2380 |
30279 | 30279 | 2021-09-04 | Illinois | 17 | 1542870 | 26614 |
30280 | 30280 | 2021-09-04 | Indiana | 18 | 876850 | 14570 |
30281 | 30281 | 2021-09-04 | Iowa | 19 | 411577 | 6307 |
30282 | 30282 | 2021-09-04 | Kansas | 20 | 378244 | 5657 |
30283 | 30283 | 2021-09-04 | Kentucky | 21 | 595779 | 7910 |
30284 | 30284 | 2021-09-04 | Louisiana | 22 | 696900 | 12707 |
30285 | 30285 | 2021-09-04 | Maine | 23 | 78069 | 940 |
30286 | 30286 | 2021-09-04 | Maryland | 24 | 502453 | 10061 |
30287 | 30287 | 2021-09-04 | Massachusetts | 25 | 765584 | 18286 |
30288 | 30288 | 2021-09-04 | Michigan | 26 | 1069220 | 21657 |
30289 | 30289 | 2021-09-04 | Minnesota | 27 | 655511 | 7937 |
30290 | 30290 | 2021-09-04 | Mississippi | 28 | 446863 | 8540 |
30291 | 30291 | 2021-09-04 | Missouri | 29 | 786097 | 11348 |
30292 | 30292 | 2021-09-04 | Montana | 30 | 129607 | 1811 |
30293 | 30293 | 2021-09-04 | Nebraska | 31 | 247320 | 2599 |
30294 | 30294 | 2021-09-04 | Nevada | 32 | 394595 | 6583 |
30295 | 30295 | 2021-09-04 | New Hampshire | 33 | 108713 | 1426 |
30296 | 30296 | 2021-09-04 | New Jersey | 34 | 1100774 | 26942 |
30297 | 30297 | 2021-09-04 | New Mexico | 35 | 235390 | 4554 |
30298 | 30298 | 2021-09-04 | New York | 36 | 2294936 | 53965 |
30299 | 30299 | 2021-09-04 | North Carolina | 37 | 1239293 | 14726 |
30300 | 30300 | 2021-09-04 | North Dakota | 38 | 119383 | 1596 |
30301 | 30301 | 2021-09-04 | Northern Mariana Islands | 69 | 243 | 2 |
30302 | 30302 | 2021-09-04 | Ohio | 39 | 1247637 | 20947 |
30303 | 30303 | 2021-09-04 | Oklahoma | 40 | 560850 | 8001 |
30304 | 30304 | 2021-09-04 | Oregon | 41 | 283873 | 3281 |
30305 | 30305 | 2021-09-04 | Pennsylvania | 42 | 1316505 | 28380 |
30306 | 30306 | 2021-09-04 | Puerto Rico | 72 | 206914 | 2907 |
30307 | 30307 | 2021-09-04 | Rhode Island | 44 | 163742 | 2773 |
30308 | 30308 | 2021-09-04 | South Carolina | 45 | 752378 | 10781 |
30309 | 30309 | 2021-09-04 | South Dakota | 46 | 133855 | 2072 |
30310 | 30310 | 2021-09-04 | Tennessee | 47 | 1051363 | 13522 |
30311 | 30311 | 2021-09-04 | Texas | 48 | 3693335 | 58422 |
30312 | 30312 | 2021-09-04 | Utah | 49 | 469510 | 2658 |
30313 | 30313 | 2021-09-04 | Vermont | 50 | 28884 | 281 |
30314 | 30314 | 2021-09-04 | Virgin Islands | 78 | 5961 | 57 |
30315 | 30315 | 2021-09-04 | Virginia | 51 | 778167 | 11899 |
30316 | 30316 | 2021-09-04 | Washington | 53 | 577569 | 6749 |
30317 | 30317 | 2021-09-04 | West Virginia | 54 | 196484 | 3124 |
30318 | 30318 | 2021-09-04 | Wisconsin | 55 | 741412 | 8521 |
30319 | 30319 | 2021-09-04 | Wyoming | 56 | 77206 | 858 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );