us-states

Table actions

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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-07 · 55 ✖
Link rowid ▼ date state fips cases deaths
1940 1940 2020-04-07 Alabama 1 2197 64
1941 1941 2020-04-07 Alaska 2 211 4
1942 1942 2020-04-07 Arizona 4 2577 77
1943 1943 2020-04-07 Arkansas 5 997 18
1944 1944 2020-04-07 California 6 17540 447
1945 1945 2020-04-07 Colorado 8 5429 179
1946 1946 2020-04-07 Connecticut 9 7781 277
1947 1947 2020-04-07 Delaware 10 928 16
1948 1948 2020-04-07 District of Columbia 11 1211 24
1949 1949 2020-04-07 Florida 12 14739 295
1950 1950 2020-04-07 Georgia 13 9156 348
1951 1951 2020-04-07 Guam 66 274 4
1952 1952 2020-04-07 Hawaii 15 408 5
1953 1953 2020-04-07 Idaho 16 1210 15
1954 1954 2020-04-07 Illinois 17 13549 384
1955 1955 2020-04-07 Indiana 18 5544 208
1956 1956 2020-04-07 Iowa 19 1048 26
1957 1957 2020-04-07 Kansas 20 905 30
1958 1958 2020-04-07 Kentucky 21 1289 66
1959 1959 2020-04-07 Louisiana 22 16284 582
1960 1960 2020-04-07 Maine 23 519 12
1961 1961 2020-04-07 Maryland 24 4371 104
1962 1962 2020-04-07 Massachusetts 25 15202 356
1963 1963 2020-04-07 Michigan 26 18851 845
1964 1964 2020-04-07 Minnesota 27 1069 34
1965 1965 2020-04-07 Mississippi 28 1915 59
1966 1966 2020-04-07 Missouri 29 3037 80
1967 1967 2020-04-07 Montana 30 319 6
1968 1968 2020-04-07 Nebraska 31 491 12
1969 1969 2020-04-07 Nevada 32 2101 60
1970 1970 2020-04-07 New Hampshire 33 747 13
1971 1971 2020-04-07 New Jersey 34 44416 1232
1972 1972 2020-04-07 New Mexico 35 794 13
1973 1973 2020-04-07 New York 36 141703 7185
1974 1974 2020-04-07 North Carolina 37 3220 50
1975 1975 2020-04-07 North Dakota 38 237 4
1976 1976 2020-04-07 Northern Mariana Islands 69 8 2
1977 1977 2020-04-07 Ohio 39 4783 167
1978 1978 2020-04-07 Oklahoma 40 1470 67
1979 1979 2020-04-07 Oregon 41 1181 33
1980 1980 2020-04-07 Pennsylvania 42 14582 241
1981 1981 2020-04-07 Puerto Rico 72 573 23
1982 1982 2020-04-07 Rhode Island 44 1229 30
1983 1983 2020-04-07 South Carolina 45 2417 51
1984 1984 2020-04-07 South Dakota 46 320 6
1985 1985 2020-04-07 Tennessee 47 4010 72
1986 1986 2020-04-07 Texas 48 8968 177
1987 1987 2020-04-07 Utah 49 1737 13
1988 1988 2020-04-07 Vermont 50 575 23
1989 1989 2020-04-07 Virgin Islands 78 45 1
1990 1990 2020-04-07 Virginia 51 3332 69
1991 1991 2020-04-07 Washington 53 8683 409
1992 1992 2020-04-07 West Virginia 54 413 4
1993 1993 2020-04-07 Wisconsin 55 2578 94
1994 1994 2020-04-07 Wyoming 56 221 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
);