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-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 |
---|---|---|---|---|---|---|
30375 | 30375 | 2021-09-06 | Alabama | 1 | 724688 | 12416 |
30376 | 30376 | 2021-09-06 | Alaska | 2 | 89927 | 431 |
30377 | 30377 | 2021-09-06 | Arizona | 4 | 1032808 | 18999 |
30378 | 30378 | 2021-09-06 | Arkansas | 5 | 464732 | 7070 |
30379 | 30379 | 2021-09-06 | California | 6 | 4525630 | 66496 |
30380 | 30380 | 2021-09-06 | Colorado | 8 | 630178 | 7397 |
30381 | 30381 | 2021-09-06 | Connecticut | 9 | 375135 | 8394 |
30382 | 30382 | 2021-09-06 | Delaware | 10 | 122370 | 1891 |
30383 | 30383 | 2021-09-06 | District of Columbia | 11 | 55918 | 1162 |
30384 | 30384 | 2021-09-06 | Florida | 12 | 3308916 | 46324 |
30385 | 30385 | 2021-09-06 | Georgia | 13 | 1401865 | 22373 |
30386 | 30386 | 2021-09-06 | Guam | 66 | 12262 | 152 |
30387 | 30387 | 2021-09-06 | Hawaii | 15 | 66057 | 623 |
30388 | 30388 | 2021-09-06 | Idaho | 16 | 225604 | 2380 |
30389 | 30389 | 2021-09-06 | Illinois | 17 | 1542870 | 26614 |
30390 | 30390 | 2021-09-06 | Indiana | 18 | 876850 | 14570 |
30391 | 30391 | 2021-09-06 | Iowa | 19 | 411577 | 6307 |
30392 | 30392 | 2021-09-06 | Kansas | 20 | 378244 | 5659 |
30393 | 30393 | 2021-09-06 | Kentucky | 21 | 596598 | 7910 |
30394 | 30394 | 2021-09-06 | Louisiana | 22 | 696900 | 12707 |
30395 | 30395 | 2021-09-06 | Maine | 23 | 78071 | 940 |
30396 | 30396 | 2021-09-06 | Maryland | 24 | 504285 | 10087 |
30397 | 30397 | 2021-09-06 | Massachusetts | 25 | 765584 | 18286 |
30398 | 30398 | 2021-09-06 | Michigan | 26 | 1069258 | 21657 |
30399 | 30399 | 2021-09-06 | Minnesota | 27 | 655511 | 7937 |
30400 | 30400 | 2021-09-06 | Mississippi | 28 | 452644 | 8664 |
30401 | 30401 | 2021-09-06 | Missouri | 29 | 788286 | 11358 |
30402 | 30402 | 2021-09-06 | Montana | 30 | 129607 | 1811 |
30403 | 30403 | 2021-09-06 | Nebraska | 31 | 248980 | 2599 |
30404 | 30404 | 2021-09-06 | Nevada | 32 | 394595 | 6583 |
30405 | 30405 | 2021-09-06 | New Hampshire | 33 | 108713 | 1426 |
30406 | 30406 | 2021-09-06 | New Jersey | 34 | 1104439 | 26952 |
30407 | 30407 | 2021-09-06 | New Mexico | 35 | 235390 | 4554 |
30408 | 30408 | 2021-09-06 | New York | 36 | 2305126 | 54037 |
30409 | 30409 | 2021-09-06 | North Carolina | 37 | 1239293 | 14726 |
30410 | 30410 | 2021-09-06 | North Dakota | 38 | 119724 | 1596 |
30411 | 30411 | 2021-09-06 | Northern Mariana Islands | 69 | 248 | 2 |
30412 | 30412 | 2021-09-06 | Ohio | 39 | 1257142 | 20947 |
30413 | 30413 | 2021-09-06 | Oklahoma | 40 | 560850 | 8001 |
30414 | 30414 | 2021-09-06 | Oregon | 41 | 283873 | 3281 |
30415 | 30415 | 2021-09-06 | Pennsylvania | 42 | 1322184 | 28398 |
30416 | 30416 | 2021-09-06 | Puerto Rico | 72 | 208005 | 2923 |
30417 | 30417 | 2021-09-06 | Rhode Island | 44 | 163742 | 2773 |
30418 | 30418 | 2021-09-06 | South Carolina | 45 | 769402 | 10945 |
30419 | 30419 | 2021-09-06 | South Dakota | 46 | 133855 | 2072 |
30420 | 30420 | 2021-09-06 | Tennessee | 47 | 1051599 | 13522 |
30421 | 30421 | 2021-09-06 | Texas | 48 | 3700956 | 58619 |
30422 | 30422 | 2021-09-06 | Utah | 49 | 469510 | 2658 |
30423 | 30423 | 2021-09-06 | Vermont | 50 | 29125 | 282 |
30424 | 30424 | 2021-09-06 | Virgin Islands | 78 | 5961 | 57 |
30425 | 30425 | 2021-09-06 | Virginia | 51 | 786910 | 11929 |
30426 | 30426 | 2021-09-06 | Washington | 53 | 577902 | 6749 |
30427 | 30427 | 2021-09-06 | West Virginia | 54 | 199300 | 3148 |
30428 | 30428 | 2021-09-06 | Wisconsin | 55 | 745837 | 8536 |
30429 | 30429 | 2021-09-06 | 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 );