us-states

Table actions

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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-02 · 55 ✖
Link rowid ▼ date state fips cases deaths
1665 1665 2020-04-02 Alabama 1 1270 32
1666 1666 2020-04-02 Alaska 2 146 2
1667 1667 2020-04-02 Arizona 4 1600 35
1668 1668 2020-04-02 Arkansas 5 683 12
1669 1669 2020-04-02 California 6 11190 247
1670 1670 2020-04-02 Colorado 8 3728 96
1671 1671 2020-04-02 Connecticut 9 3824 112
1672 1672 2020-04-02 Delaware 10 393 12
1673 1673 2020-04-02 District of Columbia 11 653 12
1674 1674 2020-04-02 Florida 12 9000 144
1675 1675 2020-04-02 Georgia 13 5444 176
1676 1676 2020-04-02 Guam 66 152 3
1677 1677 2020-04-02 Hawaii 15 283 2
1678 1678 2020-04-02 Idaho 16 891 9
1679 1679 2020-04-02 Illinois 17 7695 165
1680 1680 2020-04-02 Indiana 18 3056 94
1681 1681 2020-04-02 Iowa 19 614 11
1682 1682 2020-04-02 Kansas 20 554 14
1683 1683 2020-04-02 Kentucky 21 747 34
1684 1684 2020-04-02 Louisiana 22 9152 310
1685 1685 2020-04-02 Maine 23 376 7
1686 1686 2020-04-02 Maryland 24 2331 36
1687 1687 2020-04-02 Massachusetts 25 8966 154
1688 1688 2020-04-02 Michigan 26 10791 417
1689 1689 2020-04-02 Minnesota 27 742 18
1690 1690 2020-04-02 Mississippi 28 1177 26
1691 1691 2020-04-02 Missouri 29 1834 28
1692 1692 2020-04-02 Montana 30 241 5
1693 1693 2020-04-02 Nebraska 31 273 6
1694 1694 2020-04-02 Nevada 32 1458 38
1695 1695 2020-04-02 New Hampshire 33 479 5
1696 1696 2020-04-02 New Jersey 34 25590 539
1697 1697 2020-04-02 New Mexico 35 403 7
1698 1698 2020-04-02 New York 36 93360 2963
1699 1699 2020-04-02 North Carolina 37 1858 17
1700 1700 2020-04-02 North Dakota 38 159 3
1701 1701 2020-04-02 Northern Mariana Islands 69 8 1
1702 1702 2020-04-02 Ohio 39 2903 81
1703 1703 2020-04-02 Oklahoma 40 879 34
1704 1704 2020-04-02 Oregon 41 827 21
1705 1705 2020-04-02 Pennsylvania 42 7021 91
1706 1706 2020-04-02 Puerto Rico 72 316 12
1707 1707 2020-04-02 Rhode Island 44 657 12
1708 1708 2020-04-02 South Carolina 45 1554 31
1709 1709 2020-04-02 South Dakota 46 165 2
1710 1710 2020-04-02 Tennessee 47 2868 32
1711 1711 2020-04-02 Texas 48 4952 80
1712 1712 2020-04-02 Utah 49 1077 7
1713 1713 2020-04-02 Vermont 50 338 17
1714 1714 2020-04-02 Virgin Islands 78 37 0
1715 1715 2020-04-02 Virginia 51 1706 18
1716 1716 2020-04-02 Washington 53 6586 272
1717 1717 2020-04-02 West Virginia 54 217 2
1718 1718 2020-04-02 Wisconsin 55 1730 37
1719 1719 2020-04-02 Wyoming 56 154 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
);