us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-18 sorted by fips
This data as json, copyable, CSV (advanced)
Link | rowid | date | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|
2545 | 2545 | 2020-04-18 | Alabama | 1 | 4723 | 147 |
2546 | 2546 | 2020-04-18 | Alaska | 2 | 312 | 7 |
2547 | 2547 | 2020-04-18 | Arizona | 4 | 4719 | 181 |
2548 | 2548 | 2020-04-18 | Arkansas | 5 | 1777 | 38 |
2549 | 2549 | 2020-04-18 | California | 6 | 30829 | 1146 |
2550 | 2550 | 2020-04-18 | Colorado | 8 | 9433 | 409 |
2551 | 2551 | 2020-04-18 | Connecticut | 9 | 17550 | 1086 |
2552 | 2552 | 2020-04-18 | Delaware | 10 | 2538 | 67 |
2553 | 2553 | 2020-04-18 | District of Columbia | 11 | 2666 | 91 |
2554 | 2554 | 2020-04-18 | Florida | 12 | 25484 | 747 |
2555 | 2555 | 2020-04-18 | Georgia | 13 | 17014 | 670 |
2557 | 2557 | 2020-04-18 | Hawaii | 15 | 568 | 9 |
2558 | 2558 | 2020-04-18 | Idaho | 16 | 1668 | 44 |
2559 | 2559 | 2020-04-18 | Illinois | 17 | 29160 | 1272 |
2560 | 2560 | 2020-04-18 | Indiana | 18 | 10730 | 633 |
2561 | 2561 | 2020-04-18 | Iowa | 19 | 2513 | 74 |
2562 | 2562 | 2020-04-18 | Kansas | 20 | 1820 | 86 |
2563 | 2563 | 2020-04-18 | Kentucky | 21 | 2707 | 145 |
2564 | 2564 | 2020-04-18 | Louisiana | 22 | 23580 | 1267 |
2565 | 2565 | 2020-04-18 | Maine | 23 | 847 | 32 |
2566 | 2566 | 2020-04-18 | Maryland | 24 | 12379 | 534 |
2567 | 2567 | 2020-04-18 | Massachusetts | 25 | 36372 | 1560 |
2568 | 2568 | 2020-04-18 | Michigan | 26 | 30718 | 2307 |
2569 | 2569 | 2020-04-18 | Minnesota | 27 | 2213 | 121 |
2570 | 2570 | 2020-04-18 | Mississippi | 28 | 3974 | 152 |
2571 | 2571 | 2020-04-18 | Missouri | 29 | 5517 | 194 |
2572 | 2572 | 2020-04-18 | Montana | 30 | 426 | 10 |
2573 | 2573 | 2020-04-18 | Nebraska | 31 | 1348 | 28 |
2574 | 2574 | 2020-04-18 | Nevada | 32 | 3626 | 155 |
2575 | 2575 | 2020-04-18 | New Hampshire | 33 | 1342 | 38 |
2576 | 2576 | 2020-04-18 | New Jersey | 34 | 81420 | 4070 |
2577 | 2577 | 2020-04-18 | New Mexico | 35 | 1798 | 53 |
2578 | 2578 | 2020-04-18 | New York | 36 | 240542 | 17141 |
2579 | 2579 | 2020-04-18 | North Carolina | 37 | 6140 | 175 |
2580 | 2580 | 2020-04-18 | North Dakota | 38 | 528 | 9 |
2582 | 2582 | 2020-04-18 | Ohio | 39 | 10222 | 451 |
2583 | 2583 | 2020-04-18 | Oklahoma | 40 | 2570 | 139 |
2584 | 2584 | 2020-04-18 | Oregon | 41 | 1844 | 72 |
2585 | 2585 | 2020-04-18 | Pennsylvania | 42 | 31742 | 1150 |
2587 | 2587 | 2020-04-18 | Rhode Island | 44 | 4491 | 137 |
2588 | 2588 | 2020-04-18 | South Carolina | 45 | 4246 | 119 |
2589 | 2589 | 2020-04-18 | South Dakota | 46 | 1541 | 7 |
2590 | 2590 | 2020-04-18 | Tennessee | 47 | 6624 | 148 |
2591 | 2591 | 2020-04-18 | Texas | 48 | 18927 | 487 |
2592 | 2592 | 2020-04-18 | Utah | 49 | 2942 | 25 |
2593 | 2593 | 2020-04-18 | Vermont | 50 | 803 | 36 |
2595 | 2595 | 2020-04-18 | Virginia | 51 | 8053 | 258 |
2596 | 2596 | 2020-04-18 | Washington | 53 | 11850 | 629 |
2597 | 2597 | 2020-04-18 | West Virginia | 54 | 825 | 18 |
2598 | 2598 | 2020-04-18 | Wisconsin | 55 | 4199 | 212 |
2599 | 2599 | 2020-04-18 | Wyoming | 56 | 412 | 2 |
2556 | 2556 | 2020-04-18 | Guam | 66 | 805 | 6 |
2581 | 2581 | 2020-04-18 | Northern Mariana Islands | 69 | 14 | 2 |
2586 | 2586 | 2020-04-18 | Puerto Rico | 72 | 1118 | 60 |
2594 | 2594 | 2020-04-18 | Virgin Islands | 78 | 53 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );