us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-03
This data as json, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
1720 | 1720 | 2020-04-03 | Alabama | 1 | 1535 | 38 |
1721 | 1721 | 2020-04-03 | Alaska | 2 | 156 | 2 |
1722 | 1722 | 2020-04-03 | Arizona | 4 | 1769 | 41 |
1723 | 1723 | 2020-04-03 | Arkansas | 5 | 738 | 12 |
1724 | 1724 | 2020-04-03 | California | 6 | 12569 | 282 |
1725 | 1725 | 2020-04-03 | Colorado | 8 | 4182 | 110 |
1726 | 1726 | 2020-04-03 | Connecticut | 9 | 4915 | 132 |
1727 | 1727 | 2020-04-03 | Delaware | 10 | 450 | 14 |
1728 | 1728 | 2020-04-03 | District of Columbia | 11 | 757 | 15 |
1729 | 1729 | 2020-04-03 | Florida | 12 | 10260 | 169 |
1730 | 1730 | 2020-04-03 | Georgia | 13 | 5967 | 198 |
1731 | 1731 | 2020-04-03 | Guam | 66 | 154 | 4 |
1732 | 1732 | 2020-04-03 | Hawaii | 15 | 317 | 3 |
1733 | 1733 | 2020-04-03 | Idaho | 16 | 1012 | 10 |
1734 | 1734 | 2020-04-03 | Illinois | 17 | 8904 | 212 |
1735 | 1735 | 2020-04-03 | Indiana | 18 | 3455 | 118 |
1736 | 1736 | 2020-04-03 | Iowa | 19 | 699 | 11 |
1737 | 1737 | 2020-04-03 | Kansas | 20 | 625 | 19 |
1738 | 1738 | 2020-04-03 | Kentucky | 21 | 762 | 34 |
1739 | 1739 | 2020-04-03 | Louisiana | 22 | 10299 | 370 |
1740 | 1740 | 2020-04-03 | Maine | 23 | 432 | 9 |
1741 | 1741 | 2020-04-03 | Maryland | 24 | 2758 | 42 |
1742 | 1742 | 2020-04-03 | Massachusetts | 25 | 10402 | 192 |
1743 | 1743 | 2020-04-03 | Michigan | 26 | 12669 | 478 |
1744 | 1744 | 2020-04-03 | Minnesota | 27 | 789 | 22 |
1745 | 1745 | 2020-04-03 | Mississippi | 28 | 1358 | 29 |
1746 | 1746 | 2020-04-03 | Missouri | 29 | 2113 | 36 |
1747 | 1747 | 2020-04-03 | Montana | 30 | 262 | 5 |
1748 | 1748 | 2020-04-03 | Nebraska | 31 | 297 | 6 |
1749 | 1749 | 2020-04-03 | Nevada | 32 | 1549 | 43 |
1750 | 1750 | 2020-04-03 | New Hampshire | 33 | 540 | 7 |
1751 | 1751 | 2020-04-03 | New Jersey | 34 | 29895 | 647 |
1752 | 1752 | 2020-04-03 | New Mexico | 35 | 495 | 10 |
1753 | 1753 | 2020-04-03 | New York | 36 | 103689 | 3716 |
1754 | 1754 | 2020-04-03 | North Carolina | 37 | 2093 | 23 |
1755 | 1755 | 2020-04-03 | North Dakota | 38 | 173 | 3 |
1756 | 1756 | 2020-04-03 | Northern Mariana Islands | 69 | 8 | 1 |
1757 | 1757 | 2020-04-03 | Ohio | 39 | 3312 | 91 |
1758 | 1758 | 2020-04-03 | Oklahoma | 40 | 989 | 38 |
1759 | 1759 | 2020-04-03 | Oregon | 41 | 899 | 22 |
1760 | 1760 | 2020-04-03 | Pennsylvania | 42 | 8420 | 102 |
1761 | 1761 | 2020-04-03 | Puerto Rico | 72 | 378 | 15 |
1762 | 1762 | 2020-04-03 | Rhode Island | 44 | 711 | 14 |
1763 | 1763 | 2020-04-03 | South Carolina | 45 | 1700 | 34 |
1764 | 1764 | 2020-04-03 | South Dakota | 46 | 187 | 2 |
1765 | 1765 | 2020-04-03 | Tennessee | 47 | 3032 | 38 |
1766 | 1766 | 2020-04-03 | Texas | 48 | 5773 | 98 |
1767 | 1767 | 2020-04-03 | Utah | 49 | 1248 | 7 |
1768 | 1768 | 2020-04-03 | Vermont | 50 | 389 | 17 |
1769 | 1769 | 2020-04-03 | Virgin Islands | 78 | 38 | 0 |
1770 | 1770 | 2020-04-03 | Virginia | 51 | 2011 | 46 |
1771 | 1771 | 2020-04-03 | Washington | 53 | 6967 | 293 |
1772 | 1772 | 2020-04-03 | West Virginia | 54 | 242 | 2 |
1773 | 1773 | 2020-04-03 | Wisconsin | 55 | 1916 | 50 |
1774 | 1774 | 2020-04-03 | Wyoming | 56 | 167 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );