us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-17
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
2490 | 2490 | 2020-04-17 | Alabama | 1 | 4572 | 151 |
2491 | 2491 | 2020-04-17 | Alaska | 2 | 307 | 7 |
2492 | 2492 | 2020-04-17 | Arizona | 4 | 4507 | 174 |
2493 | 2493 | 2020-04-17 | Arkansas | 5 | 1695 | 37 |
2494 | 2494 | 2020-04-17 | California | 6 | 29398 | 1050 |
2495 | 2495 | 2020-04-17 | Colorado | 8 | 9047 | 389 |
2496 | 2496 | 2020-04-17 | Connecticut | 9 | 16809 | 1036 |
2497 | 2497 | 2020-04-17 | Delaware | 10 | 2323 | 61 |
2498 | 2498 | 2020-04-17 | District of Columbia | 11 | 2476 | 86 |
2499 | 2499 | 2020-04-17 | Florida | 12 | 24745 | 725 |
2500 | 2500 | 2020-04-17 | Georgia | 13 | 16658 | 661 |
2501 | 2501 | 2020-04-17 | Guam | 66 | 796 | 6 |
2502 | 2502 | 2020-04-17 | Hawaii | 15 | 547 | 9 |
2503 | 2503 | 2020-04-17 | Idaho | 16 | 1655 | 43 |
2504 | 2504 | 2020-04-17 | Illinois | 17 | 27575 | 1142 |
2505 | 2505 | 2020-04-17 | Indiana | 18 | 10235 | 599 |
2506 | 2506 | 2020-04-17 | Iowa | 19 | 2332 | 64 |
2507 | 2507 | 2020-04-17 | Kansas | 20 | 1732 | 84 |
2508 | 2508 | 2020-04-17 | Kentucky | 21 | 2522 | 140 |
2509 | 2509 | 2020-04-17 | Louisiana | 22 | 23118 | 1213 |
2510 | 2510 | 2020-04-17 | Maine | 23 | 827 | 29 |
2511 | 2511 | 2020-04-17 | Maryland | 24 | 11641 | 494 |
2512 | 2512 | 2020-04-17 | Massachusetts | 25 | 34402 | 1404 |
2513 | 2513 | 2020-04-17 | Michigan | 26 | 29954 | 2227 |
2514 | 2514 | 2020-04-17 | Minnesota | 27 | 2071 | 111 |
2515 | 2515 | 2020-04-17 | Mississippi | 28 | 3793 | 140 |
2516 | 2516 | 2020-04-17 | Missouri | 29 | 5283 | 184 |
2517 | 2517 | 2020-04-17 | Montana | 30 | 422 | 8 |
2518 | 2518 | 2020-04-17 | Nebraska | 31 | 1216 | 24 |
2519 | 2519 | 2020-04-17 | Nevada | 32 | 3524 | 151 |
2520 | 2520 | 2020-04-17 | New Hampshire | 33 | 1287 | 37 |
2521 | 2521 | 2020-04-17 | New Jersey | 34 | 78467 | 3840 |
2522 | 2522 | 2020-04-17 | New Mexico | 35 | 1711 | 51 |
2523 | 2523 | 2020-04-17 | New York | 36 | 233293 | 16473 |
2524 | 2524 | 2020-04-17 | North Carolina | 37 | 5859 | 159 |
2525 | 2525 | 2020-04-17 | North Dakota | 38 | 439 | 9 |
2526 | 2526 | 2020-04-17 | Northern Mariana Islands | 69 | 14 | 2 |
2527 | 2527 | 2020-04-17 | Ohio | 39 | 9107 | 418 |
2528 | 2528 | 2020-04-17 | Oklahoma | 40 | 2465 | 136 |
2529 | 2529 | 2020-04-17 | Oregon | 41 | 1785 | 70 |
2530 | 2530 | 2020-04-17 | Pennsylvania | 42 | 30121 | 1027 |
2531 | 2531 | 2020-04-17 | Puerto Rico | 72 | 1068 | 58 |
2532 | 2532 | 2020-04-17 | Rhode Island | 44 | 4177 | 118 |
2533 | 2533 | 2020-04-17 | South Carolina | 45 | 4086 | 116 |
2534 | 2534 | 2020-04-17 | South Dakota | 46 | 1411 | 7 |
2535 | 2535 | 2020-04-17 | Tennessee | 47 | 6423 | 146 |
2536 | 2536 | 2020-04-17 | Texas | 48 | 18131 | 461 |
2537 | 2537 | 2020-04-17 | Utah | 49 | 2813 | 23 |
2538 | 2538 | 2020-04-17 | Vermont | 50 | 779 | 34 |
2539 | 2539 | 2020-04-17 | Virgin Islands | 78 | 53 | 3 |
2540 | 2540 | 2020-04-17 | Virginia | 51 | 7492 | 238 |
2541 | 2541 | 2020-04-17 | Washington | 53 | 11479 | 610 |
2542 | 2542 | 2020-04-17 | West Virginia | 54 | 776 | 16 |
2543 | 2543 | 2020-04-17 | Wisconsin | 55 | 4045 | 205 |
2544 | 2544 | 2020-04-17 | Wyoming | 56 | 401 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );