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

55 rows where "date" is on date 2020-09-16 sorted by date descending

✎ View and edit SQL

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

Link rowid date ▲ state fips cases deaths
10850 10850 2020-09-16 Alabama 1 141087 2392
10851 10851 2020-09-16 Alaska 2 7308 41
10852 10852 2020-09-16 Arizona 4 209911 5376
10853 10853 2020-09-16 Arkansas 5 72219 1157
10854 10854 2020-09-16 California 6 773319 14716
10855 10855 2020-09-16 Colorado 8 63068 2010
10856 10856 2020-09-16 Connecticut 9 55166 4487
10857 10857 2020-09-16 Delaware 10 19234 619
10858 10858 2020-09-16 District of Columbia 11 14743 617
10859 10859 2020-09-16 Florida 12 671193 12938
10860 10860 2020-09-16 Georgia 13 282363 6276
10861 10861 2020-09-16 Guam 66 2982 29
10862 10862 2020-09-16 Hawaii 15 11052 102
10863 10863 2020-09-16 Idaho 16 36594 430
10864 10864 2020-09-16 Illinois 17 269282 8622
10865 10865 2020-09-16 Indiana 18 110025 3472
10866 10866 2020-09-16 Iowa 19 76680 1248
10867 10867 2020-09-16 Kansas 20 51829 586
10868 10868 2020-09-16 Kentucky 21 62723 1118
10869 10869 2020-09-16 Louisiana 22 159865 5294
10870 10870 2020-09-16 Maine 23 4941 138
10871 10871 2020-09-16 Maryland 24 118387 3855
10872 10872 2020-09-16 Massachusetts 25 125699 9245
10873 10873 2020-09-16 Michigan 26 125782 6944
10874 10874 2020-09-16 Minnesota 27 85865 1985
10875 10875 2020-09-16 Mississippi 28 91234 2756
10876 10876 2020-09-16 Missouri 29 108997 1844
10877 10877 2020-09-16 Montana 30 9487 141
10878 10878 2020-09-16 Nebraska 31 39419 455
10879 10879 2020-09-16 Nevada 32 74377 1496
10880 10880 2020-09-16 New Hampshire 33 7780 438
10881 10881 2020-09-16 New Jersey 34 199583 16054
10882 10882 2020-09-16 New Mexico 35 27041 832
10883 10883 2020-09-16 New York 36 451078 32662
10884 10884 2020-09-16 North Carolina 37 188800 3176
10885 10885 2020-09-16 North Dakota 38 16336 180
10886 10886 2020-09-16 Northern Mariana Islands 69 61 2
10887 10887 2020-09-16 Ohio 39 140518 4555
10888 10888 2020-09-16 Oklahoma 40 72284 924
10889 10889 2020-09-16 Oregon 41 29856 521
10890 10890 2020-09-16 Pennsylvania 42 151889 7963
10891 10891 2020-09-16 Puerto Rico 72 38284 570
10892 10892 2020-09-16 Rhode Island 44 23358 1081
10893 10893 2020-09-16 South Carolina 45 134122 3132
10894 10894 2020-09-16 South Dakota 46 17291 192
10895 10895 2020-09-16 Tennessee 47 174400 2127
10896 10896 2020-09-16 Texas 48 706034 14803
10897 10897 2020-09-16 Utah 49 59770 437
10898 10898 2020-09-16 Vermont 50 1702 58
10899 10899 2020-09-16 Virgin Islands 78 1232 19
10900 10900 2020-09-16 Virginia 51 136359 2884
10901 10901 2020-09-16 Washington 53 84714 2113
10902 10902 2020-09-16 West Virginia 54 13196 290
10903 10903 2020-09-16 Wisconsin 55 98501 1238
10904 10904 2020-09-16 Wyoming 56 4566 46

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
);