us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-15
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
2380 | 2380 | 2020-04-15 | Alabama | 1 | 4241 | 123 |
2381 | 2381 | 2020-04-15 | Alaska | 2 | 291 | 7 |
2382 | 2382 | 2020-04-15 | Arizona | 4 | 3962 | 142 |
2383 | 2383 | 2020-04-15 | Arkansas | 5 | 1599 | 34 |
2384 | 2384 | 2020-04-15 | California | 6 | 27107 | 885 |
2385 | 2385 | 2020-04-15 | Colorado | 8 | 8280 | 355 |
2386 | 2386 | 2020-04-15 | Connecticut | 9 | 14755 | 868 |
2387 | 2387 | 2020-04-15 | Delaware | 10 | 2014 | 46 |
2388 | 2388 | 2020-04-15 | District of Columbia | 11 | 2197 | 72 |
2389 | 2389 | 2020-04-15 | Florida | 12 | 22526 | 613 |
2390 | 2390 | 2020-04-15 | Georgia | 13 | 14583 | 569 |
2391 | 2391 | 2020-04-15 | Guam | 66 | 750 | 6 |
2392 | 2392 | 2020-04-15 | Hawaii | 15 | 524 | 9 |
2393 | 2393 | 2020-04-15 | Idaho | 16 | 1587 | 41 |
2394 | 2394 | 2020-04-15 | Illinois | 17 | 24593 | 958 |
2395 | 2395 | 2020-04-15 | Indiana | 18 | 9030 | 511 |
2396 | 2396 | 2020-04-15 | Iowa | 19 | 1995 | 53 |
2397 | 2397 | 2020-04-15 | Kansas | 20 | 1503 | 76 |
2398 | 2398 | 2020-04-15 | Kentucky | 21 | 2295 | 124 |
2399 | 2399 | 2020-04-15 | Louisiana | 22 | 21951 | 1103 |
2400 | 2400 | 2020-04-15 | Maine | 23 | 770 | 24 |
2401 | 2401 | 2020-04-15 | Maryland | 24 | 10096 | 413 |
2402 | 2402 | 2020-04-15 | Massachusetts | 25 | 29918 | 1108 |
2403 | 2403 | 2020-04-15 | Michigan | 26 | 27894 | 1920 |
2404 | 2404 | 2020-04-15 | Minnesota | 27 | 1809 | 87 |
2405 | 2405 | 2020-04-15 | Mississippi | 28 | 3360 | 122 |
2406 | 2406 | 2020-04-15 | Missouri | 29 | 4895 | 164 |
2407 | 2407 | 2020-04-15 | Montana | 30 | 404 | 7 |
2408 | 2408 | 2020-04-15 | Nebraska | 31 | 994 | 22 |
2409 | 2409 | 2020-04-15 | Nevada | 32 | 3212 | 137 |
2410 | 2410 | 2020-04-15 | New Hampshire | 33 | 1139 | 32 |
2411 | 2411 | 2020-04-15 | New Jersey | 34 | 71030 | 3156 |
2412 | 2412 | 2020-04-15 | New Mexico | 35 | 1484 | 36 |
2413 | 2413 | 2020-04-15 | New York | 36 | 217130 | 14937 |
2414 | 2414 | 2020-04-15 | North Carolina | 37 | 5123 | 128 |
2415 | 2415 | 2020-04-15 | North Dakota | 38 | 365 | 9 |
2416 | 2416 | 2020-04-15 | Northern Mariana Islands | 69 | 13 | 2 |
2417 | 2417 | 2020-04-15 | Ohio | 39 | 7791 | 361 |
2418 | 2418 | 2020-04-15 | Oklahoma | 40 | 2263 | 123 |
2419 | 2419 | 2020-04-15 | Oregon | 41 | 1663 | 58 |
2420 | 2420 | 2020-04-15 | Pennsylvania | 42 | 26804 | 833 |
2421 | 2421 | 2020-04-15 | Puerto Rico | 72 | 974 | 51 |
2422 | 2422 | 2020-04-15 | Rhode Island | 44 | 3529 | 87 |
2423 | 2423 | 2020-04-15 | South Carolina | 45 | 3656 | 107 |
2424 | 2424 | 2020-04-15 | South Dakota | 46 | 1168 | 6 |
2425 | 2425 | 2020-04-15 | Tennessee | 47 | 5864 | 135 |
2426 | 2426 | 2020-04-15 | Texas | 48 | 16106 | 395 |
2427 | 2427 | 2020-04-15 | Utah | 49 | 2549 | 20 |
2428 | 2428 | 2020-04-15 | Vermont | 50 | 759 | 29 |
2429 | 2429 | 2020-04-15 | Virgin Islands | 78 | 51 | 1 |
2430 | 2430 | 2020-04-15 | Virginia | 51 | 6502 | 195 |
2431 | 2431 | 2020-04-15 | Washington | 53 | 10806 | 572 |
2432 | 2432 | 2020-04-15 | West Virginia | 54 | 725 | 12 |
2433 | 2433 | 2020-04-15 | Wisconsin | 55 | 3721 | 184 |
2434 | 2434 | 2020-04-15 | Wyoming | 56 | 392 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );