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 56
- Washington 642
- Illinois 638
- California 637
- Arizona 636
- Massachusetts 630
- Wisconsin 627
- Texas 620
- Nebraska 614
- Utah 607
- Oregon 604
- New York 602
- Rhode Island 602
- Florida 601
- Georgia 600
- New Hampshire 600
- North Carolina 600
- New Jersey 599
- Tennessee 598
- Colorado 597
- Maryland 597
- Nevada 597
- Oklahoma 597
- Pennsylvania 597
- South Carolina 597
- Hawaii 596
- Indiana 596
- Kentucky 596
- Minnesota 596
- Vermont 596
- Virginia 596
- District of Columbia 595
- Kansas 595
- Missouri 595
- Connecticut 594
- Iowa 594
- Ohio 594
- Louisiana 593
- South Dakota 593
- Michigan 592
- New Mexico 592
- North Dakota 592
- Wyoming 592
- Arkansas 591
- Delaware 591
- Mississippi 591
- Alaska 590
- Maine 590
- Puerto Rico 590
- Alabama 589
- Idaho 589
- Montana 589
- Virgin Islands 589
- Guam 587
- West Virginia 586
- Northern Mariana Islands 575
- American Samoa 31
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
33023 | 33023 | 2021-10-23 | New Jersey | 34 | 1188709 | 27848 |
33024 | 33024 | 2021-10-23 | New Mexico | 35 | 268891 | 4989 |
33025 | 33025 | 2021-10-23 | New York | 36 | 2529266 | 55732 |
33026 | 33026 | 2021-10-23 | North Carolina | 37 | 1465671 | 17783 |
33027 | 33027 | 2021-10-23 | North Dakota | 38 | 144594 | 1753 |
33028 | 33028 | 2021-10-23 | Northern Mariana Islands | 69 | 290 | 3 |
33029 | 33029 | 2021-10-23 | Ohio | 39 | 1519304 | 23955 |
33030 | 33030 | 2021-10-23 | Oklahoma | 40 | 638957 | 10540 |
33031 | 33031 | 2021-10-23 | Oregon | 41 | 357526 | 4284 |
33032 | 33032 | 2021-10-23 | Pennsylvania | 42 | 1534882 | 30964 |
33033 | 33033 | 2021-10-23 | Puerto Rico | 72 | 217623 | 3220 |
33034 | 33034 | 2021-10-23 | Rhode Island | 44 | 177998 | 2872 |
33035 | 33035 | 2021-10-23 | South Carolina | 45 | 891072 | 13472 |
33036 | 33036 | 2021-10-23 | South Dakota | 46 | 152308 | 2218 |
33037 | 33037 | 2021-10-23 | Tennessee | 47 | 1243433 | 16025 |
33038 | 33038 | 2021-10-23 | Texas | 48 | 4201408 | 70531 |
33039 | 33039 | 2021-10-23 | Utah | 49 | 539002 | 3128 |
33040 | 33040 | 2021-10-23 | Vermont | 50 | 38573 | 351 |
33041 | 33041 | 2021-10-23 | Virgin Islands | 78 | 7126 | 78 |
33042 | 33042 | 2021-10-23 | Virginia | 51 | 914755 | 13668 |
33043 | 33043 | 2021-10-23 | Washington | 53 | 713011 | 8501 |
33044 | 33044 | 2021-10-23 | West Virginia | 54 | 265879 | 4263 |
33045 | 33045 | 2021-10-23 | Wisconsin | 55 | 867697 | 9259 |
33046 | 33046 | 2021-10-23 | Wyoming | 56 | 100174 | 1149 |
32935 | 32935 | 2021-10-22 | Alabama | 1 | 818652 | 15378 |
32936 | 32936 | 2021-10-22 | Alaska | 2 | 132393 | 680 |
32937 | 32937 | 2021-10-22 | American Samoa | 60 | 4 | 0 |
32938 | 32938 | 2021-10-22 | Arizona | 4 | 1145196 | 20826 |
32939 | 32939 | 2021-10-22 | Arkansas | 5 | 509559 | 8255 |
32940 | 32940 | 2021-10-22 | California | 6 | 4867059 | 71504 |
32941 | 32941 | 2021-10-22 | Colorado | 8 | 724074 | 8202 |
32942 | 32942 | 2021-10-22 | Connecticut | 9 | 400226 | 8739 |
32943 | 32943 | 2021-10-22 | Delaware | 10 | 141717 | 2045 |
32944 | 32944 | 2021-10-22 | District of Columbia | 11 | 63588 | 1186 |
32945 | 32945 | 2021-10-22 | Florida | 12 | 3635126 | 58803 |
32946 | 32946 | 2021-10-22 | Georgia | 13 | 1589477 | 27513 |
32947 | 32947 | 2021-10-22 | Guam | 66 | 18441 | 228 |
32948 | 32948 | 2021-10-22 | Hawaii | 15 | 80399 | 880 |
32949 | 32949 | 2021-10-22 | Idaho | 16 | 284346 | 3404 |
32950 | 32950 | 2021-10-22 | Illinois | 17 | 1686159 | 28414 |
32951 | 32951 | 2021-10-22 | Indiana | 18 | 1011223 | 16470 |
32952 | 32952 | 2021-10-22 | Iowa | 19 | 476713 | 6848 |
32953 | 32953 | 2021-10-22 | Kansas | 20 | 429760 | 6238 |
32954 | 32954 | 2021-10-22 | Kentucky | 21 | 740285 | 9663 |
32955 | 32955 | 2021-10-22 | Louisiana | 22 | 755631 | 14462 |
32956 | 32956 | 2021-10-22 | Maine | 23 | 100382 | 1115 |
32957 | 32957 | 2021-10-22 | Maryland | 24 | 554687 | 10785 |
32958 | 32958 | 2021-10-22 | Massachusetts | 25 | 842652 | 18911 |
32959 | 32959 | 2021-10-22 | Michigan | 26 | 1244670 | 23286 |
32960 | 32960 | 2021-10-22 | Minnesota | 27 | 770370 | 8661 |
32961 | 32961 | 2021-10-22 | Mississippi | 28 | 501097 | 9990 |
32962 | 32962 | 2021-10-22 | Missouri | 29 | 863696 | 12668 |
32963 | 32963 | 2021-10-22 | Montana | 30 | 170756 | 2247 |
32964 | 32964 | 2021-10-22 | Nebraska | 31 | 279799 | 2938 |
32965 | 32965 | 2021-10-22 | Nevada | 32 | 445677 | 7523 |
32966 | 32966 | 2021-10-22 | New Hampshire | 33 | 131790 | 1543 |
32967 | 32967 | 2021-10-22 | New Jersey | 34 | 1187569 | 27828 |
32968 | 32968 | 2021-10-22 | New Mexico | 35 | 268891 | 4989 |
32969 | 32969 | 2021-10-22 | New York | 36 | 2525802 | 55702 |
32970 | 32970 | 2021-10-22 | North Carolina | 37 | 1465638 | 17783 |
32971 | 32971 | 2021-10-22 | North Dakota | 38 | 144123 | 1749 |
32972 | 32972 | 2021-10-22 | Northern Mariana Islands | 69 | 290 | 3 |
32973 | 32973 | 2021-10-22 | Ohio | 39 | 1515838 | 23955 |
32974 | 32974 | 2021-10-22 | Oklahoma | 40 | 638957 | 10540 |
32975 | 32975 | 2021-10-22 | Oregon | 41 | 357526 | 4284 |
32976 | 32976 | 2021-10-22 | Pennsylvania | 42 | 1530309 | 30903 |
32977 | 32977 | 2021-10-22 | Puerto Rico | 72 | 217493 | 3219 |
32978 | 32978 | 2021-10-22 | Rhode Island | 44 | 177998 | 2872 |
32979 | 32979 | 2021-10-22 | South Carolina | 45 | 891072 | 13472 |
32980 | 32980 | 2021-10-22 | South Dakota | 46 | 152308 | 2218 |
32981 | 32981 | 2021-10-22 | Tennessee | 47 | 1243433 | 16025 |
32982 | 32982 | 2021-10-22 | Texas | 48 | 4198500 | 70355 |
32983 | 32983 | 2021-10-22 | Utah | 49 | 539002 | 3128 |
32984 | 32984 | 2021-10-22 | Vermont | 50 | 38320 | 351 |
32985 | 32985 | 2021-10-22 | Virgin Islands | 78 | 7126 | 78 |
32986 | 32986 | 2021-10-22 | Virginia | 51 | 914755 | 13668 |
32987 | 32987 | 2021-10-22 | Washington | 53 | 713011 | 8501 |
32988 | 32988 | 2021-10-22 | West Virginia | 54 | 265006 | 4263 |
32989 | 32989 | 2021-10-22 | Wisconsin | 55 | 867697 | 9259 |
32990 | 32990 | 2021-10-22 | Wyoming | 56 | 100174 | 1149 |
32879 | 32879 | 2021-10-21 | Alabama | 1 | 817054 | 15320 |
32880 | 32880 | 2021-10-21 | Alaska | 2 | 131547 | 674 |
32881 | 32881 | 2021-10-21 | American Samoa | 60 | 3 | 0 |
32882 | 32882 | 2021-10-21 | Arizona | 4 | 1142122 | 20776 |
32883 | 32883 | 2021-10-21 | Arkansas | 5 | 508937 | 8237 |
32884 | 32884 | 2021-10-21 | California | 6 | 4860797 | 71369 |
32885 | 32885 | 2021-10-21 | Colorado | 8 | 721073 | 8174 |
32886 | 32886 | 2021-10-21 | Connecticut | 9 | 399773 | 8721 |
32887 | 32887 | 2021-10-21 | Delaware | 10 | 141323 | 2045 |
32888 | 32888 | 2021-10-21 | District of Columbia | 11 | 63474 | 1186 |
32889 | 32889 | 2021-10-21 | Florida | 12 | 3633097 | 58608 |
32890 | 32890 | 2021-10-21 | Georgia | 13 | 1587865 | 27356 |
32891 | 32891 | 2021-10-21 | Guam | 66 | 18348 | 227 |
32892 | 32892 | 2021-10-21 | Hawaii | 15 | 80281 | 877 |
32893 | 32893 | 2021-10-21 | Idaho | 16 | 282865 | 3378 |
32894 | 32894 | 2021-10-21 | Illinois | 17 | 1683225 | 28382 |
32895 | 32895 | 2021-10-21 | Indiana | 18 | 1009338 | 16449 |
32896 | 32896 | 2021-10-21 | Iowa | 19 | 476713 | 6848 |
32897 | 32897 | 2021-10-21 | Kansas | 20 | 428023 | 6214 |
32898 | 32898 | 2021-10-21 | Kentucky | 21 | 738717 | 9637 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );