us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-13
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
2270 | 2270 | 2020-04-13 | Alabama | 1 | 3805 | 104 |
2271 | 2271 | 2020-04-13 | Alaska | 2 | 275 | 6 |
2272 | 2272 | 2020-04-13 | Arizona | 4 | 3702 | 122 |
2273 | 2273 | 2020-04-13 | Arkansas | 5 | 1475 | 30 |
2274 | 2274 | 2020-04-13 | California | 6 | 24334 | 725 |
2275 | 2275 | 2020-04-13 | Colorado | 8 | 7691 | 308 |
2276 | 2276 | 2020-04-13 | Connecticut | 9 | 13381 | 602 |
2277 | 2277 | 2020-04-13 | Delaware | 10 | 1761 | 41 |
2278 | 2278 | 2020-04-13 | District of Columbia | 11 | 1955 | 52 |
2279 | 2279 | 2020-04-13 | Florida | 12 | 21011 | 498 |
2280 | 2280 | 2020-04-13 | Georgia | 13 | 13125 | 479 |
2281 | 2281 | 2020-04-13 | Guam | 66 | 719 | 6 |
2282 | 2282 | 2020-04-13 | Hawaii | 15 | 502 | 9 |
2283 | 2283 | 2020-04-13 | Idaho | 16 | 1499 | 33 |
2284 | 2284 | 2020-04-13 | Illinois | 17 | 22025 | 800 |
2285 | 2285 | 2020-04-13 | Indiana | 18 | 8300 | 414 |
2286 | 2286 | 2020-04-13 | Iowa | 19 | 1710 | 44 |
2287 | 2287 | 2020-04-13 | Kansas | 20 | 1384 | 63 |
2288 | 2288 | 2020-04-13 | Kentucky | 21 | 2048 | 106 |
2289 | 2289 | 2020-04-13 | Louisiana | 22 | 21016 | 884 |
2290 | 2290 | 2020-04-13 | Maine | 23 | 698 | 19 |
2291 | 2291 | 2020-04-13 | Maryland | 24 | 8936 | 262 |
2292 | 2292 | 2020-04-13 | Massachusetts | 25 | 26867 | 844 |
2293 | 2293 | 2020-04-13 | Michigan | 26 | 25490 | 1603 |
2294 | 2294 | 2020-04-13 | Minnesota | 27 | 1650 | 70 |
2295 | 2295 | 2020-04-13 | Mississippi | 28 | 2942 | 98 |
2296 | 2296 | 2020-04-13 | Missouri | 29 | 4388 | 136 |
2297 | 2297 | 2020-04-13 | Montana | 30 | 394 | 7 |
2298 | 2298 | 2020-04-13 | Nebraska | 31 | 870 | 19 |
2299 | 2299 | 2020-04-13 | Nevada | 32 | 3036 | 114 |
2300 | 2300 | 2020-04-13 | New Hampshire | 33 | 1020 | 23 |
2301 | 2301 | 2020-04-13 | New Jersey | 34 | 64584 | 2443 |
2302 | 2302 | 2020-04-13 | New Mexico | 35 | 1345 | 31 |
2303 | 2303 | 2020-04-13 | New York | 36 | 197973 | 12998 |
2304 | 2304 | 2020-04-13 | North Carolina | 37 | 4788 | 91 |
2305 | 2305 | 2020-04-13 | North Dakota | 38 | 331 | 9 |
2306 | 2306 | 2020-04-13 | Northern Mariana Islands | 69 | 11 | 2 |
2307 | 2307 | 2020-04-13 | Ohio | 39 | 6975 | 274 |
2308 | 2308 | 2020-04-13 | Oklahoma | 40 | 2069 | 98 |
2309 | 2309 | 2020-04-13 | Oregon | 41 | 1584 | 53 |
2310 | 2310 | 2020-04-13 | Pennsylvania | 42 | 24295 | 563 |
2311 | 2311 | 2020-04-13 | Puerto Rico | 72 | 903 | 45 |
2312 | 2312 | 2020-04-13 | Rhode Island | 44 | 2976 | 73 |
2313 | 2313 | 2020-04-13 | South Carolina | 45 | 3439 | 87 |
2314 | 2314 | 2020-04-13 | South Dakota | 46 | 867 | 6 |
2315 | 2315 | 2020-04-13 | Tennessee | 47 | 5483 | 114 |
2316 | 2316 | 2020-04-13 | Texas | 48 | 14487 | 320 |
2317 | 2317 | 2020-04-13 | Utah | 49 | 2368 | 18 |
2318 | 2318 | 2020-04-13 | Vermont | 50 | 748 | 27 |
2319 | 2319 | 2020-04-13 | Virgin Islands | 78 | 51 | 1 |
2320 | 2320 | 2020-04-13 | Virginia | 51 | 5746 | 149 |
2321 | 2321 | 2020-04-13 | Washington | 53 | 10547 | 525 |
2322 | 2322 | 2020-04-13 | West Virginia | 54 | 638 | 9 |
2323 | 2323 | 2020-04-13 | Wisconsin | 55 | 3428 | 155 |
2324 | 2324 | 2020-04-13 | Wyoming | 56 | 373 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );