ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Washington 272
- Illinois 268
- California 267
- Arizona 266
- Massachusetts 260
- Wisconsin 257
- Texas 250
- Nebraska 244
- Utah 237
- Oregon 233
- Florida 231
- New York 231
- Rhode Island 231
- Georgia 230
- New Hampshire 230
- North Carolina 229
- New Jersey 228
- Tennessee 228
- Colorado 227
- Maryland 227
- Nevada 227
- Hawaii 226
- Indiana 226
- Kentucky 226
- Minnesota 226
- Oklahoma 226
- Pennsylvania 226
- South Carolina 226
- Vermont 226
- Virginia 226
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
12655 | 12655 | 2020-10-18 | Tennessee | 47 | 225126 | 2884 |
12656 | 12656 | 2020-10-18 | Texas | 48 | 869376 | 17541 |
12657 | 12657 | 2020-10-18 | Utah | 49 | 94394 | 544 |
12658 | 12658 | 2020-10-18 | Vermont | 50 | 1937 | 58 |
12659 | 12659 | 2020-10-18 | Virgin Islands | 78 | 1335 | 21 |
12660 | 12660 | 2020-10-18 | Virginia | 51 | 166138 | 3433 |
12661 | 12661 | 2020-10-18 | Washington | 53 | 102403 | 2339 |
12662 | 12662 | 2020-10-18 | West Virginia | 54 | 20081 | 399 |
12663 | 12663 | 2020-10-18 | Wisconsin | 55 | 175652 | 1588 |
12664 | 12664 | 2020-10-18 | Wyoming | 56 | 9025 | 57 |
12555 | 12555 | 2020-10-17 | Alabama | 1 | 171662 | 2788 |
12556 | 12556 | 2020-10-17 | Alaska | 2 | 11710 | 63 |
12557 | 12557 | 2020-10-17 | Arizona | 4 | 230412 | 5824 |
12558 | 12558 | 2020-10-17 | Arkansas | 5 | 98422 | 1684 |
12559 | 12559 | 2020-10-17 | California | 6 | 876258 | 16940 |
12560 | 12560 | 2020-10-17 | Colorado | 8 | 84804 | 2199 |
12561 | 12561 | 2020-10-17 | Connecticut | 9 | 62830 | 4542 |
12562 | 12562 | 2020-10-17 | Delaware | 10 | 22942 | 664 |
12563 | 12563 | 2020-10-17 | District of Columbia | 11 | 16334 | 641 |
12564 | 12564 | 2020-10-17 | Florida | 12 | 752473 | 15916 |
12565 | 12565 | 2020-10-17 | Georgia | 13 | 347468 | 7429 |
12566 | 12566 | 2020-10-17 | Guam | 66 | 4507 | 64 |
12567 | 12567 | 2020-10-17 | Hawaii | 15 | 14101 | 185 |
12568 | 12568 | 2020-10-17 | Idaho | 16 | 52582 | 532 |
12569 | 12569 | 2020-10-17 | Illinois | 17 | 344787 | 9474 |
12570 | 12570 | 2020-10-17 | Indiana | 18 | 148400 | 3918 |
12571 | 12571 | 2020-10-17 | Iowa | 19 | 106698 | 1528 |
12572 | 12572 | 2020-10-17 | Kansas | 20 | 72616 | 859 |
12573 | 12573 | 2020-10-17 | Kentucky | 21 | 88823 | 1363 |
12574 | 12574 | 2020-10-17 | Louisiana | 22 | 177726 | 5727 |
12575 | 12575 | 2020-10-17 | Maine | 23 | 5913 | 146 |
12576 | 12576 | 2020-10-17 | Maryland | 24 | 135463 | 4036 |
12577 | 12577 | 2020-10-17 | Massachusetts | 25 | 142930 | 9723 |
12578 | 12578 | 2020-10-17 | Michigan | 26 | 159259 | 7323 |
12579 | 12579 | 2020-10-17 | Minnesota | 27 | 121143 | 2270 |
12580 | 12580 | 2020-10-17 | Mississippi | 28 | 110006 | 3171 |
12581 | 12581 | 2020-10-17 | Missouri | 29 | 160654 | 2645 |
12582 | 12582 | 2020-10-17 | Montana | 30 | 22284 | 240 |
12583 | 12583 | 2020-10-17 | Nebraska | 31 | 57334 | 557 |
12584 | 12584 | 2020-10-17 | Nevada | 32 | 89848 | 1709 |
12585 | 12585 | 2020-10-17 | New Hampshire | 33 | 9625 | 466 |
12586 | 12586 | 2020-10-17 | New Jersey | 34 | 220527 | 16204 |
12587 | 12587 | 2020-10-17 | New Mexico | 35 | 36343 | 929 |
12588 | 12588 | 2020-10-17 | New York | 36 | 487626 | 32959 |
12589 | 12589 | 2020-10-17 | North Carolina | 37 | 244020 | 3955 |
12590 | 12590 | 2020-10-17 | North Dakota | 38 | 31266 | 404 |
12591 | 12591 | 2020-10-17 | Northern Mariana Islands | 69 | 86 | 2 |
12592 | 12592 | 2020-10-17 | Ohio | 39 | 180225 | 5067 |
12593 | 12593 | 2020-10-17 | Oklahoma | 40 | 106503 | 1168 |
12594 | 12594 | 2020-10-17 | Oregon | 41 | 39316 | 622 |
12595 | 12595 | 2020-10-17 | Pennsylvania | 42 | 185670 | 8535 |
12596 | 12596 | 2020-10-17 | Puerto Rico | 72 | 56650 | 761 |
12597 | 12597 | 2020-10-17 | Rhode Island | 44 | 27691 | 1152 |
12598 | 12598 | 2020-10-17 | South Carolina | 45 | 163214 | 3637 |
12599 | 12599 | 2020-10-17 | South Dakota | 46 | 32611 | 315 |
12600 | 12600 | 2020-10-17 | Tennessee | 47 | 222608 | 2875 |
12601 | 12601 | 2020-10-17 | Texas | 48 | 863993 | 17518 |
12602 | 12602 | 2020-10-17 | Utah | 49 | 93297 | 541 |
12603 | 12603 | 2020-10-17 | Vermont | 50 | 1926 | 58 |
12604 | 12604 | 2020-10-17 | Virgin Islands | 78 | 1335 | 21 |
12605 | 12605 | 2020-10-17 | Virginia | 51 | 165238 | 3422 |
12606 | 12606 | 2020-10-17 | Washington | 53 | 102054 | 2339 |
12607 | 12607 | 2020-10-17 | West Virginia | 54 | 19801 | 399 |
12608 | 12608 | 2020-10-17 | Wisconsin | 55 | 175652 | 1588 |
12609 | 12609 | 2020-10-17 | Wyoming | 56 | 8816 | 57 |
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 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );