us-states

Table actions

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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-04-01 · 55 ✖
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
1621 1621 2020-04-01 Guam 66 147 3
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
1646 1646 2020-04-01 Northern Mariana Islands 69 6 1
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
1651 1651 2020-04-01 Puerto Rico 72 286 11
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
1659 1659 2020-04-01 Virgin Islands 78 30 0
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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