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-10-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 |
---|---|---|---|---|---|---|
12500 | 12500 | 2020-10-16 | Alabama | 1 | 170374 | 2786 |
12501 | 12501 | 2020-10-16 | Alaska | 2 | 11496 | 62 |
12502 | 12502 | 2020-10-16 | Arizona | 4 | 229508 | 5806 |
12503 | 12503 | 2020-10-16 | Arkansas | 5 | 97539 | 1665 |
12504 | 12504 | 2020-10-16 | California | 6 | 874102 | 16901 |
12505 | 12505 | 2020-10-16 | Colorado | 8 | 83712 | 2196 |
12506 | 12506 | 2020-10-16 | Connecticut | 9 | 62830 | 4542 |
12507 | 12507 | 2020-10-16 | Delaware | 10 | 22724 | 662 |
12508 | 12508 | 2020-10-16 | District of Columbia | 11 | 16255 | 641 |
12509 | 12509 | 2020-10-16 | Florida | 12 | 748429 | 15829 |
12510 | 12510 | 2020-10-16 | Georgia | 13 | 345879 | 7382 |
12511 | 12511 | 2020-10-16 | Guam | 66 | 4507 | 64 |
12512 | 12512 | 2020-10-16 | Hawaii | 15 | 14007 | 184 |
12513 | 12513 | 2020-10-16 | Idaho | 16 | 52234 | 529 |
12514 | 12514 | 2020-10-16 | Illinois | 17 | 341219 | 9447 |
12515 | 12515 | 2020-10-16 | Indiana | 18 | 145915 | 3887 |
12516 | 12516 | 2020-10-16 | Iowa | 19 | 105746 | 1524 |
12517 | 12517 | 2020-10-16 | Kansas | 20 | 72509 | 859 |
12518 | 12518 | 2020-10-16 | Kentucky | 21 | 87764 | 1349 |
12519 | 12519 | 2020-10-16 | Louisiana | 22 | 177726 | 5727 |
12520 | 12520 | 2020-10-16 | Maine | 23 | 5865 | 145 |
12521 | 12521 | 2020-10-16 | Maryland | 24 | 134822 | 4032 |
12522 | 12522 | 2020-10-16 | Massachusetts | 25 | 142346 | 9702 |
12523 | 12523 | 2020-10-16 | Michigan | 26 | 159144 | 7320 |
12524 | 12524 | 2020-10-16 | Minnesota | 27 | 119449 | 2265 |
12525 | 12525 | 2020-10-16 | Mississippi | 28 | 109255 | 3160 |
12526 | 12526 | 2020-10-16 | Missouri | 29 | 158764 | 2550 |
12527 | 12527 | 2020-10-16 | Montana | 30 | 21674 | 235 |
12528 | 12528 | 2020-10-16 | Nebraska | 31 | 56724 | 556 |
12529 | 12529 | 2020-10-16 | Nevada | 32 | 88832 | 1707 |
12530 | 12530 | 2020-10-16 | New Hampshire | 33 | 9514 | 465 |
12531 | 12531 | 2020-10-16 | New Jersey | 34 | 219593 | 16202 |
12532 | 12532 | 2020-10-16 | New Mexico | 35 | 35770 | 928 |
12533 | 12533 | 2020-10-16 | New York | 36 | 485838 | 32944 |
12534 | 12534 | 2020-10-16 | North Carolina | 37 | 242032 | 3938 |
12535 | 12535 | 2020-10-16 | North Dakota | 38 | 30522 | 393 |
12536 | 12536 | 2020-10-16 | Northern Mariana Islands | 69 | 80 | 2 |
12537 | 12537 | 2020-10-16 | Ohio | 39 | 177991 | 5054 |
12538 | 12538 | 2020-10-16 | Oklahoma | 40 | 105308 | 1154 |
12539 | 12539 | 2020-10-16 | Oregon | 41 | 38947 | 620 |
12540 | 12540 | 2020-10-16 | Pennsylvania | 42 | 184185 | 8524 |
12541 | 12541 | 2020-10-16 | Puerto Rico | 72 | 56412 | 758 |
12542 | 12542 | 2020-10-16 | Rhode Island | 44 | 27691 | 1152 |
12543 | 12543 | 2020-10-16 | South Carolina | 45 | 162253 | 3615 |
12544 | 12544 | 2020-10-16 | South Dakota | 46 | 31805 | 307 |
12545 | 12545 | 2020-10-16 | Tennessee | 47 | 220099 | 2847 |
12546 | 12546 | 2020-10-16 | Texas | 48 | 859567 | 17454 |
12547 | 12547 | 2020-10-16 | Utah | 49 | 91966 | 539 |
12548 | 12548 | 2020-10-16 | Vermont | 50 | 1915 | 58 |
12549 | 12549 | 2020-10-16 | Virgin Islands | 78 | 1329 | 21 |
12550 | 12550 | 2020-10-16 | Virginia | 51 | 164124 | 3408 |
12551 | 12551 | 2020-10-16 | Washington | 53 | 101533 | 2338 |
12552 | 12552 | 2020-10-16 | West Virginia | 54 | 19580 | 396 |
12553 | 12553 | 2020-10-16 | Wisconsin | 55 | 175652 | 1588 |
12554 | 12554 | 2020-10-16 | Wyoming | 56 | 8665 | 57 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );