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 940
- Illinois 936
- California 935
- Arizona 934
- Massachusetts 928
- Wisconsin 925
- Texas 918
- Nebraska 912
- Utah 905
- Oregon 901
- Florida 899
- New York 899
- Rhode Island 899
- Georgia 898
- New Hampshire 898
- North Carolina 897
- New Jersey 896
- Tennessee 896
- Colorado 895
- Maryland 895
- Nevada 895
- South Carolina 895
- Hawaii 894
- Indiana 894
- Kentucky 894
- Minnesota 894
- Oklahoma 894
- Pennsylvania 894
- Vermont 894
- Virginia 894
- …
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
49723 | 49723 | 2022-08-17 | South Carolina | 45 | 1650748 | 18227 |
49724 | 49724 | 2022-08-17 | South Dakota | 46 | 254670 | 2979 |
49725 | 49725 | 2022-08-17 | Tennessee | 47 | 2191688 | 26975 |
49726 | 49726 | 2022-08-17 | Texas | 48 | 7627988 | 89995 |
49727 | 49727 | 2022-08-17 | Utah | 49 | 1020399 | 4940 |
49728 | 49728 | 2022-08-17 | Vermont | 50 | 139226 | 702 |
49729 | 49729 | 2022-08-17 | Virgin Islands | 78 | 22278 | 122 |
49730 | 49730 | 2022-08-17 | Virginia | 51 | 2005336 | 21203 |
49731 | 49731 | 2022-08-17 | Washington | 53 | 1767315 | 13933 |
49732 | 49732 | 2022-08-17 | West Virginia | 54 | 571075 | 7223 |
49733 | 49733 | 2022-08-17 | Wisconsin | 55 | 1810758 | 14996 |
49734 | 49734 | 2022-08-17 | Wyoming | 56 | 173487 | 1871 |
49623 | 49623 | 2022-08-16 | Alabama | 1 | 1449812 | 20026 |
49624 | 49624 | 2022-08-16 | Alaska | 2 | 287355 | 1290 |
49625 | 49625 | 2022-08-16 | American Samoa | 60 | 7471 | 33 |
49626 | 49626 | 2022-08-16 | Arizona | 4 | 2224964 | 30901 |
49627 | 49627 | 2022-08-16 | Arkansas | 5 | 918576 | 11830 |
49628 | 49628 | 2022-08-16 | California | 6 | 10939491 | 94365 |
49629 | 49629 | 2022-08-16 | Colorado | 8 | 1624129 | 13295 |
49630 | 49630 | 2022-08-16 | Connecticut | 9 | 865798 | 11179 |
49631 | 49631 | 2022-08-16 | Delaware | 10 | 299218 | 3036 |
49632 | 49632 | 2022-08-16 | District of Columbia | 11 | 164589 | 1374 |
49633 | 49633 | 2022-08-16 | Florida | 12 | 6932972 | 78749 |
49634 | 49634 | 2022-08-16 | Georgia | 13 | 2723252 | 37780 |
49635 | 49635 | 2022-08-16 | Guam | 66 | 57882 | 388 |
49636 | 49636 | 2022-08-16 | Hawaii | 15 | 324519 | 1603 |
49637 | 49637 | 2022-08-16 | Idaho | 16 | 484727 | 5070 |
49638 | 49638 | 2022-08-16 | Illinois | 17 | 3639479 | 39128 |
49639 | 49639 | 2022-08-16 | Indiana | 18 | 1862813 | 24271 |
49640 | 49640 | 2022-08-16 | Iowa | 19 | 831610 | 9850 |
49641 | 49641 | 2022-08-16 | Kansas | 20 | 849014 | 8993 |
49642 | 49642 | 2022-08-16 | Kentucky | 21 | 1520996 | 16540 |
49643 | 49643 | 2022-08-16 | Louisiana | 22 | 1405348 | 17722 |
49644 | 49644 | 2022-08-16 | Maine | 23 | 279380 | 2495 |
49645 | 49645 | 2022-08-16 | Maryland | 24 | 1206043 | 15084 |
49646 | 49646 | 2022-08-16 | Massachusetts | 25 | 1987385 | 21285 |
49647 | 49647 | 2022-08-16 | Michigan | 26 | 2723880 | 37731 |
49648 | 49648 | 2022-08-16 | Minnesota | 27 | 1611246 | 13362 |
49649 | 49649 | 2022-08-16 | Mississippi | 28 | 896300 | 12733 |
49650 | 49650 | 2022-08-16 | Missouri | 29 | 1607734 | 21271 |
49651 | 49651 | 2022-08-16 | Montana | 30 | 300938 | 3481 |
49652 | 49652 | 2022-08-16 | Nebraska | 31 | 522491 | 4394 |
49653 | 49653 | 2022-08-16 | Nevada | 32 | 835790 | 11339 |
49654 | 49654 | 2022-08-16 | New Hampshire | 33 | 341680 | 2644 |
49655 | 49655 | 2022-08-16 | New Jersey | 34 | 2643340 | 34414 |
49656 | 49656 | 2022-08-16 | New Mexico | 35 | 603450 | 8323 |
49657 | 49657 | 2022-08-16 | New York | 36 | 5902192 | 70026 |
49658 | 49658 | 2022-08-16 | North Carolina | 37 | 3047969 | 25734 |
49659 | 49659 | 2022-08-16 | North Dakota | 38 | 261446 | 2374 |
49660 | 49660 | 2022-08-16 | Northern Mariana Islands | 69 | 12948 | 39 |
49661 | 49661 | 2022-08-16 | Ohio | 39 | 3002043 | 39220 |
49662 | 49662 | 2022-08-16 | Oklahoma | 40 | 1147408 | 14623 |
49663 | 49663 | 2022-08-16 | Oregon | 41 | 867919 | 8312 |
49664 | 49664 | 2022-08-16 | Pennsylvania | 42 | 3141175 | 46422 |
49665 | 49665 | 2022-08-16 | Puerto Rico | 72 | 926847 | 4870 |
49666 | 49666 | 2022-08-16 | Rhode Island | 44 | 413259 | 3632 |
49667 | 49667 | 2022-08-16 | South Carolina | 45 | 1650748 | 18227 |
49668 | 49668 | 2022-08-16 | South Dakota | 46 | 253232 | 2973 |
49669 | 49669 | 2022-08-16 | Tennessee | 47 | 2188455 | 26950 |
49670 | 49670 | 2022-08-16 | Texas | 48 | 7619185 | 89953 |
49671 | 49671 | 2022-08-16 | Utah | 49 | 1020399 | 4940 |
49672 | 49672 | 2022-08-16 | Vermont | 50 | 138779 | 699 |
49673 | 49673 | 2022-08-16 | Virgin Islands | 78 | 22196 | 122 |
49674 | 49674 | 2022-08-16 | Virginia | 51 | 2002553 | 21183 |
49675 | 49675 | 2022-08-16 | Washington | 53 | 1764789 | 13888 |
49676 | 49676 | 2022-08-16 | West Virginia | 54 | 570094 | 7206 |
49677 | 49677 | 2022-08-16 | Wisconsin | 55 | 1808708 | 14991 |
49678 | 49678 | 2022-08-16 | Wyoming | 56 | 173487 | 1871 |
49567 | 49567 | 2022-08-15 | Alabama | 1 | 1449812 | 20026 |
49568 | 49568 | 2022-08-15 | Alaska | 2 | 287355 | 1290 |
49569 | 49569 | 2022-08-15 | American Samoa | 60 | 7471 | 33 |
49570 | 49570 | 2022-08-15 | Arizona | 4 | 2224964 | 30901 |
49571 | 49571 | 2022-08-15 | Arkansas | 5 | 917523 | 11822 |
49572 | 49572 | 2022-08-15 | California | 6 | 10908539 | 94262 |
49573 | 49573 | 2022-08-15 | Colorado | 8 | 1622738 | 13293 |
49574 | 49574 | 2022-08-15 | Connecticut | 9 | 865196 | 11165 |
49575 | 49575 | 2022-08-15 | Delaware | 10 | 299087 | 3036 |
49576 | 49576 | 2022-08-15 | District of Columbia | 11 | 164373 | 1374 |
49577 | 49577 | 2022-08-15 | Florida | 12 | 6926031 | 78731 |
49578 | 49578 | 2022-08-15 | Georgia | 13 | 2723252 | 37780 |
49579 | 49579 | 2022-08-15 | Guam | 66 | 57773 | 387 |
49580 | 49580 | 2022-08-15 | Hawaii | 15 | 324519 | 1603 |
49581 | 49581 | 2022-08-15 | Idaho | 16 | 484709 | 5069 |
49582 | 49582 | 2022-08-15 | Illinois | 17 | 3635675 | 39119 |
49583 | 49583 | 2022-08-15 | Indiana | 18 | 1862813 | 24262 |
49584 | 49584 | 2022-08-15 | Iowa | 19 | 830079 | 9850 |
49585 | 49585 | 2022-08-15 | Kansas | 20 | 848977 | 8993 |
49586 | 49586 | 2022-08-15 | Kentucky | 21 | 1520706 | 16540 |
49587 | 49587 | 2022-08-15 | Louisiana | 22 | 1403404 | 17708 |
49588 | 49588 | 2022-08-15 | Maine | 23 | 278921 | 2493 |
49589 | 49589 | 2022-08-15 | Maryland | 24 | 1203149 | 15063 |
49590 | 49590 | 2022-08-15 | Massachusetts | 25 | 1987385 | 21285 |
49591 | 49591 | 2022-08-15 | Michigan | 26 | 2708622 | 37671 |
49592 | 49592 | 2022-08-15 | Minnesota | 27 | 1611246 | 13362 |
49593 | 49593 | 2022-08-15 | Mississippi | 28 | 894772 | 12729 |
49594 | 49594 | 2022-08-15 | Missouri | 29 | 1604707 | 21251 |
49595 | 49595 | 2022-08-15 | Montana | 30 | 300906 | 3481 |
49596 | 49596 | 2022-08-15 | Nebraska | 31 | 522491 | 4394 |
49597 | 49597 | 2022-08-15 | Nevada | 32 | 835365 | 11331 |
49598 | 49598 | 2022-08-15 | New Hampshire | 33 | 341568 | 2641 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );