us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-01 sorted by fips
This data as json, copyable, CSV (advanced)
Link | rowid | date | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|
1610 | 1610 | 2020-04-01 | Alabama | 1 | 1108 | 28 |
1611 | 1611 | 2020-04-01 | Alaska | 2 | 143 | 2 |
1612 | 1612 | 2020-04-01 | Arizona | 4 | 1413 | 29 |
1613 | 1613 | 2020-04-01 | Arkansas | 5 | 624 | 10 |
1614 | 1614 | 2020-04-01 | California | 6 | 9857 | 212 |
1615 | 1615 | 2020-04-01 | Colorado | 8 | 3346 | 80 |
1616 | 1616 | 2020-04-01 | Connecticut | 9 | 3557 | 85 |
1617 | 1617 | 2020-04-01 | Delaware | 10 | 368 | 11 |
1618 | 1618 | 2020-04-01 | District of Columbia | 11 | 586 | 11 |
1619 | 1619 | 2020-04-01 | Florida | 12 | 7769 | 100 |
1620 | 1620 | 2020-04-01 | Georgia | 13 | 4747 | 154 |
1622 | 1622 | 2020-04-01 | Hawaii | 15 | 258 | 1 |
1623 | 1623 | 2020-04-01 | Idaho | 16 | 669 | 9 |
1624 | 1624 | 2020-04-01 | Illinois | 17 | 6978 | 146 |
1625 | 1625 | 2020-04-01 | Indiana | 18 | 2578 | 80 |
1626 | 1626 | 2020-04-01 | Iowa | 19 | 549 | 9 |
1627 | 1627 | 2020-04-01 | Kansas | 20 | 489 | 11 |
1628 | 1628 | 2020-04-01 | Kentucky | 21 | 674 | 20 |
1629 | 1629 | 2020-04-01 | Louisiana | 22 | 6424 | 275 |
1630 | 1630 | 2020-04-01 | Maine | 23 | 344 | 7 |
1631 | 1631 | 2020-04-01 | Maryland | 24 | 1985 | 33 |
1632 | 1632 | 2020-04-01 | Massachusetts | 25 | 7738 | 122 |
1633 | 1633 | 2020-04-01 | Michigan | 26 | 9292 | 336 |
1634 | 1634 | 2020-04-01 | Minnesota | 27 | 689 | 17 |
1635 | 1635 | 2020-04-01 | Mississippi | 28 | 1073 | 22 |
1636 | 1636 | 2020-04-01 | Missouri | 29 | 1580 | 21 |
1637 | 1637 | 2020-04-01 | Montana | 30 | 219 | 5 |
1638 | 1638 | 2020-04-01 | Nebraska | 31 | 249 | 5 |
1639 | 1639 | 2020-04-01 | Nevada | 32 | 1279 | 32 |
1640 | 1640 | 2020-04-01 | New Hampshire | 33 | 415 | 4 |
1641 | 1641 | 2020-04-01 | New Jersey | 34 | 22255 | 355 |
1642 | 1642 | 2020-04-01 | New Mexico | 35 | 363 | 6 |
1643 | 1643 | 2020-04-01 | New York | 36 | 84364 | 2415 |
1644 | 1644 | 2020-04-01 | North Carolina | 37 | 1591 | 11 |
1645 | 1645 | 2020-04-01 | North Dakota | 38 | 147 | 3 |
1647 | 1647 | 2020-04-01 | Ohio | 39 | 2548 | 65 |
1648 | 1648 | 2020-04-01 | Oklahoma | 40 | 719 | 30 |
1649 | 1649 | 2020-04-01 | Oregon | 41 | 737 | 19 |
1650 | 1650 | 2020-04-01 | Pennsylvania | 42 | 5805 | 78 |
1652 | 1652 | 2020-04-01 | Rhode Island | 44 | 566 | 10 |
1653 | 1653 | 2020-04-01 | South Carolina | 45 | 1293 | 26 |
1654 | 1654 | 2020-04-01 | South Dakota | 46 | 129 | 1 |
1655 | 1655 | 2020-04-01 | Tennessee | 47 | 2689 | 23 |
1656 | 1656 | 2020-04-01 | Texas | 48 | 4402 | 65 |
1657 | 1657 | 2020-04-01 | Utah | 49 | 1012 | 7 |
1658 | 1658 | 2020-04-01 | Vermont | 50 | 321 | 16 |
1660 | 1660 | 2020-04-01 | Virginia | 51 | 1511 | 18 |
1661 | 1661 | 2020-04-01 | Washington | 53 | 5589 | 250 |
1662 | 1662 | 2020-04-01 | West Virginia | 54 | 191 | 2 |
1663 | 1663 | 2020-04-01 | Wisconsin | 55 | 1552 | 33 |
1664 | 1664 | 2020-04-01 | Wyoming | 56 | 138 | 0 |
1621 | 1621 | 2020-04-01 | Guam | 66 | 147 | 3 |
1646 | 1646 | 2020-04-01 | Northern Mariana Islands | 69 | 6 | 1 |
1651 | 1651 | 2020-04-01 | Puerto Rico | 72 | 286 | 11 |
1659 | 1659 | 2020-04-01 | Virgin Islands | 78 | 30 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );