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 975
- Illinois 971
- California 970
- Arizona 969
- Massachusetts 964
- Wisconsin 960
- Texas 953
- Nebraska 948
- Utah 940
- Oregon 937
- New York 935
- Rhode Island 935
- Florida 934
- New Hampshire 934
- Georgia 933
- North Carolina 933
- New Jersey 932
- Maryland 931
- Nevada 931
- Tennessee 931
- Colorado 930
- Kentucky 930
- Minnesota 930
- Oklahoma 930
- Pennsylvania 930
- South Carolina 930
- Hawaii 929
- Indiana 929
- Kansas 929
- Missouri 929
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
51656 | 51656 | 2022-09-21 | Iowa | 19 | 853840 | 10051 |
51657 | 51657 | 2022-09-21 | Kansas | 20 | 876232 | 9095 |
51658 | 51658 | 2022-09-21 | Kentucky | 21 | 1583653 | 16902 |
51659 | 51659 | 2022-09-21 | Louisiana | 22 | 1451304 | 17993 |
51660 | 51660 | 2022-09-21 | Maine | 23 | 287283 | 2569 |
51661 | 51661 | 2022-09-21 | Maryland | 24 | 1242937 | 15340 |
51662 | 51662 | 2022-09-21 | Massachusetts | 25 | 2030335 | 21588 |
51663 | 51663 | 2022-09-21 | Michigan | 26 | 2821489 | 38464 |
51664 | 51664 | 2022-09-21 | Minnesota | 27 | 1651999 | 13558 |
51665 | 51665 | 2022-09-21 | Mississippi | 28 | 925596 | 12879 |
51666 | 51666 | 2022-09-21 | Missouri | 29 | 1656666 | 21593 |
51667 | 51667 | 2022-09-21 | Montana | 30 | 308301 | 3513 |
51668 | 51668 | 2022-09-21 | Nebraska | 31 | 535877 | 4490 |
51669 | 51669 | 2022-09-21 | Nevada | 32 | 846668 | 11475 |
51670 | 51670 | 2022-09-21 | New Hampshire | 33 | 348102 | 2688 |
51671 | 51671 | 2022-09-21 | New Jersey | 34 | 2719359 | 34696 |
51672 | 51672 | 2022-09-21 | New Mexico | 35 | 616648 | 8536 |
51673 | 51673 | 2022-09-21 | New York | 36 | 6064374 | 70875 |
51674 | 51674 | 2022-09-21 | North Carolina | 37 | 3182775 | 26468 |
51675 | 51675 | 2022-09-21 | North Dakota | 38 | 267287 | 2411 |
51676 | 51676 | 2022-09-21 | Northern Mariana Islands | 69 | 13166 | 40 |
51677 | 51677 | 2022-09-21 | Ohio | 39 | 3117109 | 39675 |
51678 | 51678 | 2022-09-21 | Oklahoma | 40 | 1192446 | 14784 |
51679 | 51679 | 2022-09-21 | Oregon | 41 | 890507 | 8520 |
51680 | 51680 | 2022-09-21 | Pennsylvania | 42 | 3239298 | 47098 |
51681 | 51681 | 2022-09-21 | Puerto Rico | 72 | 981287 | 5085 |
51682 | 51682 | 2022-09-21 | Rhode Island | 44 | 421739 | 3661 |
51683 | 51683 | 2022-09-21 | South Carolina | 45 | 1703439 | 18331 |
51684 | 51684 | 2022-09-21 | South Dakota | 46 | 260639 | 3017 |
51685 | 51685 | 2022-09-21 | Tennessee | 47 | 2271764 | 27362 |
51686 | 51686 | 2022-09-21 | Texas | 48 | 7856339 | 90830 |
51687 | 51687 | 2022-09-21 | Utah | 49 | 1034893 | 5001 |
51688 | 51688 | 2022-09-21 | Vermont | 50 | 141840 | 719 |
51689 | 51689 | 2022-09-21 | Virgin Islands | 78 | 23083 | 123 |
51690 | 51690 | 2022-09-21 | Virginia | 51 | 2076914 | 21729 |
51691 | 51691 | 2022-09-21 | Washington | 53 | 1805951 | 14277 |
51692 | 51692 | 2022-09-21 | West Virginia | 54 | 597303 | 7379 |
51693 | 51693 | 2022-09-21 | Wisconsin | 55 | 1857343 | 15215 |
51694 | 51694 | 2022-09-21 | Wyoming | 56 | 176256 | 1891 |
51583 | 51583 | 2022-09-20 | Alabama | 1 | 1515969 | 20367 |
51584 | 51584 | 2022-09-20 | Alaska | 2 | 295121 | 1321 |
51585 | 51585 | 2022-09-20 | American Samoa | 60 | 8217 | 34 |
51586 | 51586 | 2022-09-20 | Arizona | 4 | 2264159 | 31244 |
51587 | 51587 | 2022-09-20 | Arkansas | 5 | 947211 | 12017 |
51588 | 51588 | 2022-09-20 | California | 6 | 11201464 | 95695 |
51589 | 51589 | 2022-09-20 | Colorado | 8 | 1654266 | 13455 |
51590 | 51590 | 2022-09-20 | Connecticut | 9 | 889661 | 11343 |
51591 | 51591 | 2022-09-20 | Delaware | 10 | 306522 | 3086 |
51592 | 51592 | 2022-09-20 | District of Columbia | 11 | 167796 | 1382 |
51593 | 51593 | 2022-09-20 | Florida | 12 | 7098315 | 80954 |
51594 | 51594 | 2022-09-20 | Georgia | 13 | 2809555 | 38468 |
51595 | 51595 | 2022-09-20 | Guam | 66 | 59399 | 396 |
51596 | 51596 | 2022-09-20 | Hawaii | 15 | 333547 | 1662 |
51597 | 51597 | 2022-09-20 | Idaho | 16 | 493705 | 5161 |
51598 | 51598 | 2022-09-20 | Illinois | 17 | 3746966 | 39576 |
51599 | 51599 | 2022-09-20 | Indiana | 18 | 1915905 | 24614 |
51600 | 51600 | 2022-09-20 | Iowa | 19 | 853064 | 9994 |
51601 | 51601 | 2022-09-20 | Kansas | 20 | 873734 | 9095 |
51602 | 51602 | 2022-09-20 | Kentucky | 21 | 1583626 | 16902 |
51603 | 51603 | 2022-09-20 | Louisiana | 22 | 1450613 | 17988 |
51604 | 51604 | 2022-09-20 | Maine | 23 | 287032 | 2569 |
51605 | 51605 | 2022-09-20 | Maryland | 24 | 1241973 | 15329 |
51606 | 51606 | 2022-09-20 | Massachusetts | 25 | 2030335 | 21588 |
51607 | 51607 | 2022-09-20 | Michigan | 26 | 2813107 | 38415 |
51608 | 51608 | 2022-09-20 | Minnesota | 27 | 1651999 | 13558 |
51609 | 51609 | 2022-09-20 | Mississippi | 28 | 925596 | 12879 |
51610 | 51610 | 2022-09-20 | Missouri | 29 | 1656056 | 21593 |
51611 | 51611 | 2022-09-20 | Montana | 30 | 308301 | 3513 |
51612 | 51612 | 2022-09-20 | Nebraska | 31 | 535595 | 4490 |
51613 | 51613 | 2022-09-20 | Nevada | 32 | 846133 | 11446 |
51614 | 51614 | 2022-09-20 | New Hampshire | 33 | 347953 | 2687 |
51615 | 51615 | 2022-09-20 | New Jersey | 34 | 2715620 | 34694 |
51616 | 51616 | 2022-09-20 | New Mexico | 35 | 616360 | 8526 |
51617 | 51617 | 2022-09-20 | New York | 36 | 6059413 | 70850 |
51618 | 51618 | 2022-09-20 | North Carolina | 37 | 3162491 | 26424 |
51619 | 51619 | 2022-09-20 | North Dakota | 38 | 267287 | 2411 |
51620 | 51620 | 2022-09-20 | Northern Mariana Islands | 69 | 13166 | 40 |
51621 | 51621 | 2022-09-20 | Ohio | 39 | 3117109 | 39675 |
51622 | 51622 | 2022-09-20 | Oklahoma | 40 | 1192446 | 14784 |
51623 | 51623 | 2022-09-20 | Oregon | 41 | 885963 | 8492 |
51624 | 51624 | 2022-09-20 | Pennsylvania | 42 | 3222783 | 46970 |
51625 | 51625 | 2022-09-20 | Puerto Rico | 72 | 981287 | 5077 |
51626 | 51626 | 2022-09-20 | Rhode Island | 44 | 421739 | 3661 |
51627 | 51627 | 2022-09-20 | South Carolina | 45 | 1703439 | 18331 |
51628 | 51628 | 2022-09-20 | South Dakota | 46 | 259683 | 3014 |
51629 | 51629 | 2022-09-20 | Tennessee | 47 | 2270672 | 27356 |
51630 | 51630 | 2022-09-20 | Texas | 48 | 7849650 | 90760 |
51631 | 51631 | 2022-09-20 | Utah | 49 | 1034893 | 5001 |
51632 | 51632 | 2022-09-20 | Vermont | 50 | 141282 | 715 |
51633 | 51633 | 2022-09-20 | Virgin Islands | 78 | 23083 | 123 |
51634 | 51634 | 2022-09-20 | Virginia | 51 | 2075283 | 21712 |
51635 | 51635 | 2022-09-20 | Washington | 53 | 1803850 | 14247 |
51636 | 51636 | 2022-09-20 | West Virginia | 54 | 596709 | 7370 |
51637 | 51637 | 2022-09-20 | Wisconsin | 55 | 1855835 | 15213 |
51638 | 51638 | 2022-09-20 | Wyoming | 56 | 176256 | 1891 |
51527 | 51527 | 2022-09-19 | Alabama | 1 | 1514795 | 20345 |
51528 | 51528 | 2022-09-19 | Alaska | 2 | 295121 | 1321 |
51529 | 51529 | 2022-09-19 | American Samoa | 60 | 8217 | 34 |
51530 | 51530 | 2022-09-19 | Arizona | 4 | 2264159 | 31244 |
51531 | 51531 | 2022-09-19 | Arkansas | 5 | 946576 | 11993 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );