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-28 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 |
---|---|---|---|---|---|---|
11510 | 11510 | 2020-09-28 | Alabama | 1 | 152983 | 2501 |
11511 | 11511 | 2020-09-28 | Alaska | 2 | 8477 | 52 |
11512 | 11512 | 2020-09-28 | Arizona | 4 | 217513 | 5624 |
11513 | 11513 | 2020-09-28 | Arkansas | 5 | 82049 | 1329 |
11514 | 11514 | 2020-09-28 | California | 6 | 814797 | 15641 |
11515 | 11515 | 2020-09-28 | Colorado | 8 | 69967 | 2052 |
11516 | 11516 | 2020-09-28 | Connecticut | 9 | 57147 | 4503 |
11517 | 11517 | 2020-09-28 | Delaware | 10 | 20389 | 634 |
11518 | 11518 | 2020-09-28 | District of Columbia | 11 | 15264 | 624 |
11519 | 11519 | 2020-09-28 | Florida | 12 | 701294 | 14036 |
11520 | 11520 | 2020-09-28 | Georgia | 13 | 298963 | 6803 |
11521 | 11521 | 2020-09-28 | Guam | 66 | 3255 | 40 |
11522 | 11522 | 2020-09-28 | Hawaii | 15 | 12351 | 131 |
11523 | 11523 | 2020-09-28 | Idaho | 16 | 41386 | 460 |
11524 | 11524 | 2020-09-28 | Illinois | 17 | 293169 | 8877 |
11525 | 11525 | 2020-09-28 | Indiana | 18 | 120581 | 3591 |
11526 | 11526 | 2020-09-28 | Iowa | 19 | 87256 | 1324 |
11527 | 11527 | 2020-09-28 | Kansas | 20 | 59793 | 641 |
11528 | 11528 | 2020-09-28 | Kentucky | 21 | 71003 | 1195 |
11529 | 11529 | 2020-09-28 | Louisiana | 22 | 166315 | 5480 |
11530 | 11530 | 2020-09-28 | Maine | 23 | 5300 | 140 |
11531 | 11531 | 2020-09-28 | Maryland | 24 | 124371 | 3938 |
11532 | 11532 | 2020-09-28 | Massachusetts | 25 | 131072 | 9415 |
11533 | 11533 | 2020-09-28 | Michigan | 26 | 135782 | 7052 |
11534 | 11534 | 2020-09-28 | Minnesota | 27 | 97690 | 2067 |
11535 | 11535 | 2020-09-28 | Mississippi | 28 | 97049 | 2921 |
11536 | 11536 | 2020-09-28 | Missouri | 29 | 127894 | 2132 |
11537 | 11537 | 2020-09-28 | Montana | 30 | 12538 | 174 |
11538 | 11538 | 2020-09-28 | Nebraska | 31 | 44578 | 487 |
11539 | 11539 | 2020-09-28 | Nevada | 32 | 79313 | 1586 |
11540 | 11540 | 2020-09-28 | New Hampshire | 33 | 8208 | 439 |
11541 | 11541 | 2020-09-28 | New Jersey | 34 | 205898 | 16107 |
11542 | 11542 | 2020-09-28 | New Mexico | 35 | 28985 | 873 |
11543 | 11543 | 2020-09-28 | New York | 36 | 461176 | 32737 |
11544 | 11544 | 2020-09-28 | North Carolina | 37 | 208497 | 3469 |
11545 | 11545 | 2020-09-28 | North Dakota | 38 | 20986 | 237 |
11546 | 11546 | 2020-09-28 | Northern Mariana Islands | 69 | 69 | 2 |
11547 | 11547 | 2020-09-28 | Ohio | 39 | 151802 | 4746 |
11548 | 11548 | 2020-09-28 | Oklahoma | 40 | 85194 | 1007 |
11549 | 11549 | 2020-09-28 | Oregon | 41 | 32995 | 549 |
11550 | 11550 | 2020-09-28 | Pennsylvania | 42 | 161642 | 8181 |
11551 | 11551 | 2020-09-28 | Puerto Rico | 72 | 47422 | 648 |
11552 | 11552 | 2020-09-28 | Rhode Island | 44 | 24424 | 1110 |
11553 | 11553 | 2020-09-28 | South Carolina | 45 | 146455 | 3337 |
11554 | 11554 | 2020-09-28 | South Dakota | 46 | 21738 | 218 |
11555 | 11555 | 2020-09-28 | Tennessee | 47 | 190991 | 2362 |
11556 | 11556 | 2020-09-28 | Texas | 48 | 773679 | 15898 |
11557 | 11557 | 2020-09-28 | Utah | 49 | 71442 | 453 |
11558 | 11558 | 2020-09-28 | Vermont | 50 | 1745 | 58 |
11559 | 11559 | 2020-09-28 | Virgin Islands | 78 | 1318 | 20 |
11560 | 11560 | 2020-09-28 | Virginia | 51 | 146593 | 3172 |
11561 | 11561 | 2020-09-28 | Washington | 53 | 90596 | 2199 |
11562 | 11562 | 2020-09-28 | West Virginia | 54 | 15512 | 337 |
11563 | 11563 | 2020-09-28 | Wisconsin | 55 | 124320 | 1293 |
11564 | 11564 | 2020-09-28 | Wyoming | 56 | 5754 | 50 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );