ny_times_us_states

⚠️ 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

8,979 rows sorted by date descending

View and edit SQL

Suggested facets: date (date)

Link rowid date ▲ state fips cases deaths
8925 2020-08-12 Alabama 1 104786 1882
8926 2020-08-12 Alaska 2 4653 25
8927 2020-08-12 Arizona 4 189522 4348
8928 2020-08-12 Arkansas 5 51114 573
8929 2020-08-12 California 6 595097 10808
8930 2020-08-12 Colorado 8 51847 1881
8931 2020-08-12 Connecticut 9 50706 4450
8932 2020-08-12 Delaware 10 15765 592
8933 2020-08-12 District of Columbia 11 12959 593
8934 2020-08-12 Florida 12 550893 8764
8935 2020-08-12 Georgia 13 209683 4360
8936 2020-08-12 Guam 66 1418 6
8937 2020-08-12 Hawaii 15 3935 37
8938 2020-08-12 Idaho 16 26280 251
8939 2020-08-12 Illinois 17 200586 7899
8940 2020-08-12 Indiana 18 78337 3086
8941 2020-08-12 Iowa 19 49973 953
8942 2020-08-12 Kansas 20 32969 396
8943 2020-08-12 Kentucky 21 38546 809
8944 2020-08-12 Louisiana 22 134427 4361
8945 2020-08-12 Maine 23 4070 126
8946 2020-08-12 Maryland 24 97959 3612
8947 2020-08-12 Massachusetts 25 122000 8769
8948 2020-08-12 Michigan 26 98825 6541
8949 2020-08-12 Minnesota 27 62349 1724
8950 2020-08-12 Mississippi 28 69374 1989
8951 2020-08-12 Missouri 29 63328 1407
8952 2020-08-12 Montana 30 5292 80
8953 2020-08-12 Nebraska 31 29244 359
8954 2020-08-12 Nevada 32 58132 999
8955 2020-08-12 New Hampshire 33 6887 420
8956 2020-08-12 New Jersey 34 187777 15885
8957 2020-08-12 New Mexico 35 22816 695
8958 2020-08-12 New York 36 427419 32384
8959 2020-08-12 North Carolina 37 139413 2277
8960 2020-08-12 North Dakota 38 7974 124
8961 2020-08-12 Northern Mariana Islands 69 49 2
8962 2020-08-12 Ohio 39 104248 3734
8963 2020-08-12 Oklahoma 40 45392 627
8964 2020-08-12 Oregon 41 22029 378
8965 2020-08-12 Pennsylvania 42 125965 7447
8966 2020-08-12 Puerto Rico 72 24074 295
8967 2020-08-12 Rhode Island 44 20129 1018
8968 2020-08-12 South Carolina 45 102974 2144
8969 2020-08-12 South Dakota 46 9815 147
8970 2020-08-12 Tennessee 47 123489 1274
8971 2020-08-12 Texas 48 529465 9638
8972 2020-08-12 Utah 49 45181 355
8973 2020-08-12 Vermont 50 1478 58
8974 2020-08-12 Virgin Islands 78 639 9
8975 2020-08-12 Virginia 51 102521 2352
8976 2020-08-12 Washington 53 67171 1789
8977 2020-08-12 West Virginia 54 8008 153
8978 2020-08-12 Wisconsin 55 66705 1022
8979 2020-08-12 Wyoming 56 3086 29
8870 2020-08-11 Alabama 1 103851 1847
8871 2020-08-11 Alaska 2 4587 24
8872 2020-08-11 Arizona 4 188780 4205
8873 2020-08-11 Arkansas 5 50411 566
8874 2020-08-11 California 6 586078 10654
8875 2020-08-11 Colorado 8 51487 1878
8876 2020-08-11 Connecticut 9 50684 4444
8877 2020-08-11 Delaware 10 15699 591
8878 2020-08-11 District of Columbia 11 12896 593
8879 2020-08-11 Florida 12 542784 8552
8880 2020-08-11 Georgia 13 205920 4255
8881 2020-08-11 Guam 66 1403 6
8882 2020-08-11 Hawaii 15 3733 35
8883 2020-08-11 Idaho 16 25767 248
8884 2020-08-11 Illinois 17 198919 7879
8885 2020-08-11 Indiana 18 77625 3069
8886 2020-08-11 Iowa 19 49521 946
8887 2020-08-11 Kansas 20 32174 388
8888 2020-08-11 Kentucky 21 37437 803
8889 2020-08-11 Louisiana 22 133243 4313
8890 2020-08-11 Maine 23 4050 126
8891 2020-08-11 Maryland 24 97403 3604
8892 2020-08-11 Massachusetts 25 121707 8751
8893 2020-08-11 Michigan 26 98361 6534
8894 2020-08-11 Minnesota 27 61880 1707
8895 2020-08-11 Mississippi 28 68293 1944
8896 2020-08-11 Missouri 29 61900 1402
8897 2020-08-11 Montana 30 5125 77
8898 2020-08-11 Nebraska 31 29030 357
8899 2020-08-11 Nevada 32 57608 982
8900 2020-08-11 New Hampshire 33 6861 419
8901 2020-08-11 New Jersey 34 187328 15890
8902 2020-08-11 New Mexico 35 22643 693
8903 2020-08-11 New York 36 426713 32372
8904 2020-08-11 North Carolina 37 138074 2238
8905 2020-08-11 North Dakota 38 7889 122
8906 2020-08-11 Northern Mariana Islands 69 49 2
8907 2020-08-11 Ohio 39 102826 3708
8908 2020-08-11 Oklahoma 40 44725 618
8909 2020-08-11 Oregon 41 21782 372
8910 2020-08-11 Pennsylvania 42 125061 7404
8911 2020-08-11 Puerto Rico 72 23403 287
8912 2020-08-11 Rhode Island 44 20053 1016
8913 2020-08-11 South Carolina 45 102130 2098
8914 2020-08-11 South Dakota 46 9713 146

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
);
Powered by Datasette · Query took 122.131ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette