us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-14
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
2325 | 2325 | 2020-04-14 | Alabama | 1 | 3953 | 114 |
2326 | 2326 | 2020-04-14 | Alaska | 2 | 283 | 7 |
2327 | 2327 | 2020-04-14 | Arizona | 4 | 3806 | 131 |
2328 | 2328 | 2020-04-14 | Arkansas | 5 | 1498 | 32 |
2329 | 2329 | 2020-04-14 | California | 6 | 25758 | 778 |
2330 | 2330 | 2020-04-14 | Colorado | 8 | 7941 | 329 |
2331 | 2331 | 2020-04-14 | Connecticut | 9 | 13989 | 671 |
2332 | 2332 | 2020-04-14 | Delaware | 10 | 1926 | 43 |
2333 | 2333 | 2020-04-14 | District of Columbia | 11 | 2058 | 67 |
2334 | 2334 | 2020-04-14 | Florida | 12 | 21620 | 570 |
2335 | 2335 | 2020-04-14 | Georgia | 13 | 13913 | 517 |
2336 | 2336 | 2020-04-14 | Guam | 66 | 721 | 6 |
2337 | 2337 | 2020-04-14 | Hawaii | 15 | 511 | 9 |
2338 | 2338 | 2020-04-14 | Idaho | 16 | 1538 | 39 |
2339 | 2339 | 2020-04-14 | Illinois | 17 | 23247 | 878 |
2340 | 2340 | 2020-04-14 | Indiana | 18 | 8598 | 458 |
2341 | 2341 | 2020-04-14 | Iowa | 19 | 1899 | 44 |
2342 | 2342 | 2020-04-14 | Kansas | 20 | 1440 | 69 |
2343 | 2343 | 2020-04-14 | Kentucky | 21 | 2210 | 115 |
2344 | 2344 | 2020-04-14 | Louisiana | 22 | 21518 | 1013 |
2345 | 2345 | 2020-04-14 | Maine | 23 | 734 | 20 |
2346 | 2346 | 2020-04-14 | Maryland | 24 | 9472 | 302 |
2347 | 2347 | 2020-04-14 | Massachusetts | 25 | 28163 | 957 |
2348 | 2348 | 2020-04-14 | Michigan | 26 | 26845 | 1767 |
2349 | 2349 | 2020-04-14 | Minnesota | 27 | 1695 | 79 |
2350 | 2350 | 2020-04-14 | Mississippi | 28 | 3087 | 111 |
2351 | 2351 | 2020-04-14 | Missouri | 29 | 4686 | 151 |
2352 | 2352 | 2020-04-14 | Montana | 30 | 399 | 7 |
2353 | 2353 | 2020-04-14 | Nebraska | 31 | 930 | 21 |
2354 | 2354 | 2020-04-14 | Nevada | 32 | 3137 | 130 |
2355 | 2355 | 2020-04-14 | New Hampshire | 33 | 1091 | 27 |
2356 | 2356 | 2020-04-14 | New Jersey | 34 | 68824 | 2805 |
2357 | 2357 | 2020-04-14 | New Mexico | 35 | 1407 | 36 |
2358 | 2358 | 2020-04-14 | New York | 36 | 205375 | 14001 |
2359 | 2359 | 2020-04-14 | North Carolina | 37 | 4992 | 116 |
2360 | 2360 | 2020-04-14 | North Dakota | 38 | 341 | 9 |
2361 | 2361 | 2020-04-14 | Northern Mariana Islands | 69 | 13 | 2 |
2362 | 2362 | 2020-04-14 | Ohio | 39 | 7280 | 324 |
2363 | 2363 | 2020-04-14 | Oklahoma | 40 | 2184 | 109 |
2364 | 2364 | 2020-04-14 | Oregon | 41 | 1633 | 55 |
2365 | 2365 | 2020-04-14 | Pennsylvania | 42 | 25591 | 746 |
2366 | 2366 | 2020-04-14 | Puerto Rico | 72 | 923 | 45 |
2367 | 2367 | 2020-04-14 | Rhode Island | 44 | 3251 | 80 |
2368 | 2368 | 2020-04-14 | South Carolina | 45 | 3553 | 97 |
2369 | 2369 | 2020-04-14 | South Dakota | 46 | 987 | 6 |
2370 | 2370 | 2020-04-14 | Tennessee | 47 | 5654 | 123 |
2371 | 2371 | 2020-04-14 | Texas | 48 | 15303 | 365 |
2372 | 2372 | 2020-04-14 | Utah | 49 | 2420 | 19 |
2373 | 2373 | 2020-04-14 | Vermont | 50 | 752 | 28 |
2374 | 2374 | 2020-04-14 | Virgin Islands | 78 | 51 | 1 |
2375 | 2375 | 2020-04-14 | Virginia | 51 | 6173 | 154 |
2376 | 2376 | 2020-04-14 | Washington | 53 | 10711 | 552 |
2377 | 2377 | 2020-04-14 | West Virginia | 54 | 697 | 10 |
2378 | 2378 | 2020-04-14 | Wisconsin | 55 | 3555 | 172 |
2379 | 2379 | 2020-04-14 | 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 );