us-states

Table actions

Data source: Big Local News · About: big-local-datasette

55 rows where "date" is on date 2020-04-04

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-04 · 55 ✖
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

CSV options: 

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);