us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-04-04
This data as json, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
1775 | 1775 | 2020-04-04 | Alabama | 1 | 1632 | 44 |
1776 | 1776 | 2020-04-04 | Alaska | 2 | 169 | 3 |
1777 | 1777 | 2020-04-04 | Arizona | 4 | 2019 | 53 |
1778 | 1778 | 2020-04-04 | Arkansas | 5 | 743 | 14 |
1779 | 1779 | 2020-04-04 | California | 6 | 13796 | 323 |
1780 | 1780 | 2020-04-04 | Colorado | 8 | 4574 | 126 |
1781 | 1781 | 2020-04-04 | Connecticut | 9 | 5276 | 165 |
1782 | 1782 | 2020-04-04 | Delaware | 10 | 593 | 14 |
1783 | 1783 | 2020-04-04 | District of Columbia | 11 | 902 | 21 |
1784 | 1784 | 2020-04-04 | Florida | 12 | 11537 | 194 |
1785 | 1785 | 2020-04-04 | Georgia | 13 | 6383 | 208 |
1786 | 1786 | 2020-04-04 | Guam | 66 | 223 | 4 |
1787 | 1787 | 2020-04-04 | Hawaii | 15 | 349 | 3 |
1788 | 1788 | 2020-04-04 | Idaho | 16 | 1076 | 10 |
1789 | 1789 | 2020-04-04 | Illinois | 17 | 10357 | 248 |
1790 | 1790 | 2020-04-04 | Indiana | 18 | 3975 | 136 |
1791 | 1791 | 2020-04-04 | Iowa | 19 | 786 | 11 |
1792 | 1792 | 2020-04-04 | Kansas | 20 | 702 | 21 |
1793 | 1793 | 2020-04-04 | Kentucky | 21 | 909 | 40 |
1794 | 1794 | 2020-04-04 | Louisiana | 22 | 12500 | 412 |
1795 | 1795 | 2020-04-04 | Maine | 23 | 456 | 10 |
1796 | 1796 | 2020-04-04 | Maryland | 24 | 3125 | 54 |
1797 | 1797 | 2020-04-04 | Massachusetts | 25 | 11736 | 216 |
1798 | 1798 | 2020-04-04 | Michigan | 26 | 14225 | 541 |
1799 | 1799 | 2020-04-04 | Minnesota | 27 | 865 | 24 |
1800 | 1800 | 2020-04-04 | Mississippi | 28 | 1455 | 35 |
1801 | 1801 | 2020-04-04 | Missouri | 29 | 2291 | 44 |
1802 | 1802 | 2020-04-04 | Montana | 30 | 281 | 6 |
1803 | 1803 | 2020-04-04 | Nebraska | 31 | 339 | 8 |
1804 | 1804 | 2020-04-04 | Nevada | 32 | 1758 | 46 |
1805 | 1805 | 2020-04-04 | New Hampshire | 33 | 621 | 9 |
1806 | 1806 | 2020-04-04 | New Jersey | 34 | 34124 | 847 |
1807 | 1807 | 2020-04-04 | New Mexico | 35 | 544 | 11 |
1808 | 1808 | 2020-04-04 | New York | 36 | 115963 | 4535 |
1809 | 1809 | 2020-04-04 | North Carolina | 37 | 2402 | 30 |
1810 | 1810 | 2020-04-04 | North Dakota | 38 | 186 | 3 |
1811 | 1811 | 2020-04-04 | Northern Mariana Islands | 69 | 8 | 1 |
1812 | 1812 | 2020-04-04 | Ohio | 39 | 3739 | 102 |
1813 | 1813 | 2020-04-04 | Oklahoma | 40 | 1159 | 42 |
1814 | 1814 | 2020-04-04 | Oregon | 41 | 1000 | 26 |
1815 | 1815 | 2020-04-04 | Pennsylvania | 42 | 10110 | 140 |
1816 | 1816 | 2020-04-04 | Puerto Rico | 72 | 452 | 18 |
1817 | 1817 | 2020-04-04 | Rhode Island | 44 | 806 | 17 |
1818 | 1818 | 2020-04-04 | South Carolina | 45 | 1917 | 40 |
1819 | 1819 | 2020-04-04 | South Dakota | 46 | 212 | 2 |
1820 | 1820 | 2020-04-04 | Tennessee | 47 | 3265 | 47 |
1821 | 1821 | 2020-04-04 | Texas | 48 | 6566 | 124 |
1822 | 1822 | 2020-04-04 | Utah | 49 | 1426 | 8 |
1823 | 1823 | 2020-04-04 | Vermont | 50 | 461 | 20 |
1824 | 1824 | 2020-04-04 | Virgin Islands | 78 | 42 | 0 |
1825 | 1825 | 2020-04-04 | Virginia | 51 | 2408 | 52 |
1826 | 1826 | 2020-04-04 | Washington | 53 | 7499 | 318 |
1827 | 1827 | 2020-04-04 | West Virginia | 54 | 282 | 2 |
1828 | 1828 | 2020-04-04 | Wisconsin | 55 | 2112 | 60 |
1829 | 1829 | 2020-04-04 | Wyoming | 56 | 189 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );