us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-09
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
2050 | 2050 | 2020-04-09 | Alabama | 1 | 2838 | 78 |
2051 | 2051 | 2020-04-09 | Alaska | 2 | 233 | 5 |
2052 | 2052 | 2020-04-09 | Arizona | 4 | 3018 | 89 |
2053 | 2053 | 2020-04-09 | Arkansas | 5 | 1146 | 21 |
2054 | 2054 | 2020-04-09 | California | 6 | 20191 | 548 |
2055 | 2055 | 2020-04-09 | Colorado | 8 | 6202 | 227 |
2056 | 2056 | 2020-04-09 | Connecticut | 9 | 9784 | 380 |
2057 | 2057 | 2020-04-09 | Delaware | 10 | 1209 | 23 |
2058 | 2058 | 2020-04-09 | District of Columbia | 11 | 1523 | 32 |
2059 | 2059 | 2020-04-09 | Florida | 12 | 16819 | 370 |
2060 | 2060 | 2020-04-09 | Georgia | 13 | 10885 | 412 |
2061 | 2061 | 2020-04-09 | Guam | 66 | 542 | 4 |
2062 | 2062 | 2020-04-09 | Hawaii | 15 | 440 | 6 |
2063 | 2063 | 2020-04-09 | Idaho | 16 | 1366 | 24 |
2064 | 2064 | 2020-04-09 | Illinois | 17 | 16422 | 534 |
2065 | 2065 | 2020-04-09 | Indiana | 18 | 6400 | 295 |
2066 | 2066 | 2020-04-09 | Iowa | 19 | 1270 | 27 |
2067 | 2067 | 2020-04-09 | Kansas | 20 | 1116 | 42 |
2068 | 2068 | 2020-04-09 | Kentucky | 21 | 1525 | 84 |
2069 | 2069 | 2020-04-09 | Louisiana | 22 | 18283 | 702 |
2070 | 2070 | 2020-04-09 | Maine | 23 | 560 | 16 |
2071 | 2071 | 2020-04-09 | Maryland | 24 | 6185 | 139 |
2072 | 2072 | 2020-04-09 | Massachusetts | 25 | 18941 | 503 |
2073 | 2073 | 2020-04-09 | Michigan | 26 | 21375 | 1076 |
2074 | 2074 | 2020-04-09 | Minnesota | 27 | 1242 | 50 |
2075 | 2075 | 2020-04-09 | Mississippi | 28 | 2260 | 76 |
2076 | 2076 | 2020-04-09 | Missouri | 29 | 3539 | 94 |
2077 | 2077 | 2020-04-09 | Montana | 30 | 354 | 6 |
2078 | 2078 | 2020-04-09 | Nebraska | 31 | 594 | 15 |
2079 | 2079 | 2020-04-09 | Nevada | 32 | 2456 | 82 |
2080 | 2080 | 2020-04-09 | New Hampshire | 33 | 819 | 21 |
2081 | 2081 | 2020-04-09 | New Jersey | 34 | 51027 | 1700 |
2082 | 2082 | 2020-04-09 | New Mexico | 35 | 989 | 17 |
2083 | 2083 | 2020-04-09 | New York | 36 | 162036 | 9166 |
2084 | 2084 | 2020-04-09 | North Carolina | 37 | 3651 | 74 |
2085 | 2085 | 2020-04-09 | North Dakota | 38 | 269 | 5 |
2086 | 2086 | 2020-04-09 | Northern Mariana Islands | 69 | 11 | 2 |
2087 | 2087 | 2020-04-09 | Ohio | 39 | 5513 | 213 |
2088 | 2088 | 2020-04-09 | Oklahoma | 40 | 1683 | 80 |
2089 | 2089 | 2020-04-09 | Oregon | 41 | 1321 | 44 |
2090 | 2090 | 2020-04-09 | Pennsylvania | 42 | 18379 | 344 |
2091 | 2091 | 2020-04-09 | Puerto Rico | 72 | 683 | 33 |
2092 | 2092 | 2020-04-09 | Rhode Island | 44 | 1727 | 43 |
2093 | 2093 | 2020-04-09 | South Carolina | 45 | 2792 | 67 |
2094 | 2094 | 2020-04-09 | South Dakota | 46 | 447 | 6 |
2095 | 2095 | 2020-04-09 | Tennessee | 47 | 4456 | 95 |
2096 | 2096 | 2020-04-09 | Texas | 48 | 11372 | 228 |
2097 | 2097 | 2020-04-09 | Utah | 49 | 1980 | 13 |
2098 | 2098 | 2020-04-09 | Vermont | 50 | 628 | 23 |
2099 | 2099 | 2020-04-09 | Virgin Islands | 78 | 50 | 1 |
2100 | 2100 | 2020-04-09 | Virginia | 51 | 4041 | 109 |
2101 | 2101 | 2020-04-09 | Washington | 53 | 9609 | 456 |
2102 | 2102 | 2020-04-09 | West Virginia | 54 | 524 | 5 |
2103 | 2103 | 2020-04-09 | Wisconsin | 55 | 2885 | 116 |
2104 | 2104 | 2020-04-09 | Wyoming | 56 | 303 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );