ny_times_us_states

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

18,054 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid date ▲ state fips cases deaths
18000 18000 2021-01-24 Alabama 1 441170 6660
18001 18001 2021-01-24 Alaska 2 52982 250
18002 18002 2021-01-24 Arizona 4 722574 12238
18003 18003 2021-01-24 Arkansas 5 284066 4606
18004 18004 2021-01-24 California 6 3185612 37118
18005 18005 2021-01-24 Colorado 8 387960 5588
18006 18006 2021-01-24 Connecticut 9 237815 6819
18007 18007 2021-01-24 Delaware 10 74575 1041
18008 18008 2021-01-24 District of Columbia 11 35301 872
18009 18009 2021-01-24 Florida 12 1649441 25292
18010 18010 2021-01-24 Georgia 13 842798 12838
18011 18011 2021-01-24 Guam 66 8516 129
18012 18012 2021-01-24 Hawaii 15 25093 339
18013 18013 2021-01-24 Idaho 16 159581 1671
18014 18014 2021-01-24 Illinois 17 1104206 20680
18015 18015 2021-01-24 Indiana 18 614120 9716
18016 18016 2021-01-24 Iowa 19 313140 4487
18017 18017 2021-01-24 Kansas 20 269611 3598
18018 18018 2021-01-24 Kentucky 21 349194 3687
18019 18019 2021-01-24 Louisiana 22 383862 8565
18020 18020 2021-01-24 Maine 23 36598 544
18021 18021 2021-01-24 Maryland 24 341666 6865
18022 18022 2021-01-24 Massachusetts 25 500037 14133
18023 18023 2021-01-24 Michigan 26 595354 15170
18024 18024 2021-01-24 Minnesota 27 455057 6163
18025 18025 2021-01-24 Mississippi 28 264219 5772
18026 18026 2021-01-24 Missouri 29 481970 6956
18027 18027 2021-01-24 Montana 30 91662 1152
18028 18028 2021-01-24 Nebraska 31 187407 1954
18029 18029 2021-01-24 Nevada 32 271029 4027
18030 18030 2021-01-24 New Hampshire 33 62337 987
18031 18031 2021-01-24 New Jersey 34 662808 20951
18032 18032 2021-01-24 New Mexico 35 169205 3147
18033 18033 2021-01-24 New York 36 1335952 41889
18034 18034 2021-01-24 North Carolina 37 720580 8739
18035 18035 2021-01-24 North Dakota 38 96842 1436
18036 18036 2021-01-24 Northern Mariana Islands 69 129 2
18037 18037 2021-01-24 Ohio 39 864322 10711
18038 18038 2021-01-24 Oklahoma 40 373090 3279
18039 18039 2021-01-24 Oregon 41 138168 1885
18040 18040 2021-01-24 Pennsylvania 42 808951 20609
18041 18041 2021-01-24 Puerto Rico 72 124643 1773
18042 18042 2021-01-24 Rhode Island 44 109735 2083
18043 18043 2021-01-24 South Carolina 45 418325 6547
18044 18044 2021-01-24 South Dakota 46 107148 1705
18045 18045 2021-01-24 Tennessee 47 694381 8776
18046 18046 2021-01-24 Texas 48 2249959 35050
18047 18047 2021-01-24 Utah 49 336405 1595
18048 18048 2021-01-24 Vermont 50 11033 170
18049 18049 2021-01-24 Virgin Islands 78 2341 24
18050 18050 2021-01-24 Virginia 51 472447 6078
18051 18051 2021-01-24 Washington 53 304523 4182
18052 18052 2021-01-24 West Virginia 54 115307 1895
18053 18053 2021-01-24 Wisconsin 55 581377 6193
18054 18054 2021-01-24 Wyoming 56 50898 571
17945 17945 2021-01-23 Alabama 1 439442 6657
17946 17946 2021-01-23 Alaska 2 52820 250
17947 17947 2021-01-23 Arizona 4 717593 12170
17948 17948 2021-01-23 Arkansas 5 282995 4563
17949 17949 2021-01-23 California 6 3163932 36818
17950 17950 2021-01-23 Colorado 8 386432 5561
17951 17951 2021-01-23 Connecticut 9 237815 6819
17952 17952 2021-01-23 Delaware 10 73915 1036
17953 17953 2021-01-23 District of Columbia 11 35077 870
17954 17954 2021-01-23 Florida 12 1639906 25163
17955 17955 2021-01-23 Georgia 13 838057 12834
17956 17956 2021-01-23 Guam 66 8516 129
17957 17957 2021-01-23 Hawaii 15 24950 333
17958 17958 2021-01-23 Idaho 16 159406 1670
17959 17959 2021-01-23 Illinois 17 1101037 20645
17960 17960 2021-01-23 Indiana 18 611600 9693
17961 17961 2021-01-23 Iowa 19 312625 4486
17962 17962 2021-01-23 Kansas 20 269611 3598
17963 17963 2021-01-23 Kentucky 21 348040 3657
17964 17964 2021-01-23 Louisiana 22 380255 8483
17965 17965 2021-01-23 Maine 23 36598 544
17966 17966 2021-01-23 Maryland 24 339482 6837
17967 17967 2021-01-23 Massachusetts 25 496093 14064
17968 17968 2021-01-23 Michigan 26 595320 15170
17969 17969 2021-01-23 Minnesota 27 453876 6131
17970 17970 2021-01-23 Mississippi 28 263023 5752
17971 17971 2021-01-23 Missouri 29 480183 6949
17972 17972 2021-01-23 Montana 30 91448 1142
17973 17973 2021-01-23 Nebraska 31 187135 1954
17974 17974 2021-01-23 Nevada 32 269928 4017
17975 17975 2021-01-23 New Hampshire 33 61576 981
17976 17976 2021-01-23 New Jersey 34 657536 20934
17977 17977 2021-01-23 New Mexico 35 168579 3117
17978 17978 2021-01-23 New York 36 1323569 41694
17979 17979 2021-01-23 North Carolina 37 715283 8623
17980 17980 2021-01-23 North Dakota 38 96745 1436
17981 17981 2021-01-23 Northern Mariana Islands 69 129 2
17982 17982 2021-01-23 Ohio 39 859841 10680
17983 17983 2021-01-23 Oklahoma 40 370149 3231
17984 17984 2021-01-23 Oregon 41 137600 1882
17985 17985 2021-01-23 Pennsylvania 42 805272 20526
17986 17986 2021-01-23 Puerto Rico 72 123688 1771
17987 17987 2021-01-23 Rhode Island 44 109735 2083
17988 17988 2021-01-23 South Carolina 45 413789 6479
17989 17989 2021-01-23 South Dakota 46 106963 1696

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);