us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-19
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
2600 | 2600 | 2020-04-19 | Alabama | 1 | 4903 | 160 |
2601 | 2601 | 2020-04-19 | Alaska | 2 | 317 | 7 |
2602 | 2602 | 2020-04-19 | Arizona | 4 | 4929 | 188 |
2603 | 2603 | 2020-04-19 | Arkansas | 5 | 1781 | 39 |
2604 | 2604 | 2020-04-19 | California | 6 | 31544 | 1176 |
2605 | 2605 | 2020-04-19 | Colorado | 8 | 9730 | 421 |
2606 | 2606 | 2020-04-19 | Connecticut | 9 | 17962 | 1127 |
2607 | 2607 | 2020-04-19 | Delaware | 10 | 2538 | 67 |
2608 | 2608 | 2020-04-19 | District of Columbia | 11 | 2793 | 96 |
2609 | 2609 | 2020-04-19 | Florida | 12 | 26306 | 773 |
2610 | 2610 | 2020-04-19 | Georgia | 13 | 17619 | 682 |
2611 | 2611 | 2020-04-19 | Guam | 66 | 808 | 6 |
2612 | 2612 | 2020-04-19 | Hawaii | 15 | 574 | 10 |
2613 | 2613 | 2020-04-19 | Idaho | 16 | 1672 | 45 |
2614 | 2614 | 2020-04-19 | Illinois | 17 | 30357 | 1302 |
2615 | 2615 | 2020-04-19 | Indiana | 18 | 11301 | 652 |
2616 | 2616 | 2020-04-19 | Iowa | 19 | 2915 | 75 |
2617 | 2617 | 2020-04-19 | Kansas | 20 | 1897 | 94 |
2618 | 2618 | 2020-04-19 | Kentucky | 21 | 2960 | 149 |
2619 | 2619 | 2020-04-19 | Louisiana | 22 | 23928 | 1296 |
2620 | 2620 | 2020-04-19 | Maine | 23 | 867 | 34 |
2621 | 2621 | 2020-04-19 | Maryland | 24 | 12892 | 548 |
2622 | 2622 | 2020-04-19 | Massachusetts | 25 | 38077 | 1706 |
2623 | 2623 | 2020-04-19 | Michigan | 26 | 31349 | 2389 |
2624 | 2624 | 2020-04-19 | Minnesota | 27 | 2356 | 134 |
2625 | 2625 | 2020-04-19 | Mississippi | 28 | 4274 | 159 |
2626 | 2626 | 2020-04-19 | Missouri | 29 | 5667 | 196 |
2627 | 2627 | 2020-04-19 | Montana | 30 | 433 | 10 |
2628 | 2628 | 2020-04-19 | Nebraska | 31 | 1473 | 28 |
2629 | 2629 | 2020-04-19 | Nevada | 32 | 3710 | 158 |
2630 | 2630 | 2020-04-19 | New Hampshire | 33 | 1392 | 41 |
2631 | 2631 | 2020-04-19 | New Jersey | 34 | 85301 | 4202 |
2632 | 2632 | 2020-04-19 | New Mexico | 35 | 1845 | 55 |
2633 | 2633 | 2020-04-19 | New York | 36 | 246741 | 17793 |
2634 | 2634 | 2020-04-19 | North Carolina | 37 | 6493 | 183 |
2635 | 2635 | 2020-04-19 | North Dakota | 38 | 585 | 10 |
2636 | 2636 | 2020-04-19 | Northern Mariana Islands | 69 | 14 | 2 |
2637 | 2637 | 2020-04-19 | Ohio | 39 | 11602 | 471 |
2638 | 2638 | 2020-04-19 | Oklahoma | 40 | 2599 | 140 |
2639 | 2639 | 2020-04-19 | Oregon | 41 | 1910 | 74 |
2640 | 2640 | 2020-04-19 | Pennsylvania | 42 | 32992 | 1285 |
2641 | 2641 | 2020-04-19 | Puerto Rico | 72 | 1213 | 41 |
2642 | 2642 | 2020-04-19 | Rhode Island | 44 | 4706 | 150 |
2643 | 2643 | 2020-04-19 | South Carolina | 45 | 4377 | 120 |
2644 | 2644 | 2020-04-19 | South Dakota | 46 | 1635 | 7 |
2645 | 2645 | 2020-04-19 | Tennessee | 47 | 6824 | 151 |
2646 | 2646 | 2020-04-19 | Texas | 48 | 19441 | 503 |
2647 | 2647 | 2020-04-19 | Utah | 49 | 3071 | 27 |
2648 | 2648 | 2020-04-19 | Vermont | 50 | 812 | 36 |
2649 | 2649 | 2020-04-19 | Virgin Islands | 78 | 53 | 3 |
2650 | 2650 | 2020-04-19 | Virginia | 51 | 8536 | 277 |
2651 | 2651 | 2020-04-19 | Washington | 53 | 11864 | 637 |
2652 | 2652 | 2020-04-19 | West Virginia | 54 | 890 | 20 |
2653 | 2653 | 2020-04-19 | Wisconsin | 55 | 4346 | 222 |
2654 | 2654 | 2020-04-19 | Wyoming | 56 | 422 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );