us-states

Table actions

Data source: Big Local News · About: big-local-datasette

55 rows where "date" is on date 2020-04-06

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-06 · 55 ✖
Link rowid ▼ date state fips cases deaths
1885 1885 2020-04-06 Alabama 1 2005 53
1886 1886 2020-04-06 Alaska 2 189 4
1887 1887 2020-04-06 Arizona 4 2466 67
1888 1888 2020-04-06 Arkansas 5 927 16
1889 1889 2020-04-06 California 6 16361 386
1890 1890 2020-04-06 Colorado 8 5172 150
1891 1891 2020-04-06 Connecticut 9 6906 206
1892 1892 2020-04-06 Delaware 10 783 15
1893 1893 2020-04-06 District of Columbia 11 1097 24
1894 1894 2020-04-06 Florida 12 13621 253
1895 1895 2020-04-06 Georgia 13 7558 294
1896 1896 2020-04-06 Guam 66 266 4
1897 1897 2020-04-06 Hawaii 15 385 5
1898 1898 2020-04-06 Idaho 16 1170 13
1899 1899 2020-04-06 Illinois 17 12262 309
1900 1900 2020-04-06 Indiana 18 4986 171
1901 1901 2020-04-06 Iowa 19 946 25
1902 1902 2020-04-06 Kansas 20 854 25
1903 1903 2020-04-06 Kentucky 21 1057 52
1904 1904 2020-04-06 Louisiana 22 14867 512
1905 1905 2020-04-06 Maine 23 499 10
1906 1906 2020-04-06 Maryland 24 4045 92
1907 1907 2020-04-06 Massachusetts 25 13837 260
1908 1908 2020-04-06 Michigan 26 17129 727
1909 1909 2020-04-06 Minnesota 27 986 30
1910 1910 2020-04-06 Mississippi 28 1738 51
1911 1911 2020-04-06 Missouri 29 2722 56
1912 1912 2020-04-06 Montana 30 319 6
1913 1913 2020-04-06 Nebraska 31 438 10
1914 1914 2020-04-06 Nevada 32 1971 58
1915 1915 2020-04-06 New Hampshire 33 715 9
1916 1916 2020-04-06 New Jersey 34 41090 1005
1917 1917 2020-04-06 New Mexico 35 686 12
1918 1918 2020-04-06 New York 36 133389 6149
1919 1919 2020-04-06 North Carolina 37 2870 42
1920 1920 2020-04-06 North Dakota 38 225 3
1921 1921 2020-04-06 Northern Mariana Islands 69 8 1
1922 1922 2020-04-06 Ohio 39 4450 142
1923 1923 2020-04-06 Oklahoma 40 1326 51
1924 1924 2020-04-06 Oregon 41 1132 29
1925 1925 2020-04-06 Pennsylvania 42 13075 170
1926 1926 2020-04-06 Puerto Rico 72 513 21
1927 1927 2020-04-06 Rhode Island 44 1082 27
1928 1928 2020-04-06 South Carolina 45 2232 48
1929 1929 2020-04-06 South Dakota 46 288 4
1930 1930 2020-04-06 Tennessee 47 3753 65
1931 1931 2020-04-06 Texas 48 8150 159
1932 1932 2020-04-06 Utah 49 1662 13
1933 1933 2020-04-06 Vermont 50 543 23
1934 1934 2020-04-06 Virgin Islands 78 44 1
1935 1935 2020-04-06 Virginia 51 2877 54
1936 1936 2020-04-06 Washington 53 8385 383
1937 1937 2020-04-06 West Virginia 54 347 4
1938 1938 2020-04-06 Wisconsin 55 2440 83
1939 1939 2020-04-06 Wyoming 56 213 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);