us-states

Table actions

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

55 rows where "date" is on date 2020-03-31

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

date (date) ✖

  • 2020-03-31 · 55 ✖
Link rowid ▼ date state fips cases deaths
1555 1555 2020-03-31 Alabama 1 999 14
1556 1556 2020-03-31 Alaska 2 133 2
1557 1557 2020-03-31 Arizona 4 1298 24
1558 1558 2020-03-31 Arkansas 5 564 8
1559 1559 2020-03-31 California 6 8583 184
1560 1560 2020-03-31 Colorado 8 2990 69
1561 1561 2020-03-31 Connecticut 9 3128 69
1562 1562 2020-03-31 Delaware 10 319 10
1563 1563 2020-03-31 District of Columbia 11 495 9
1564 1564 2020-03-31 Florida 12 6742 85
1565 1565 2020-03-31 Georgia 13 4116 126
1566 1566 2020-03-31 Guam 66 139 2
1567 1567 2020-03-31 Hawaii 15 224 1
1568 1568 2020-03-31 Idaho 16 526 9
1569 1569 2020-03-31 Illinois 17 5992 107
1570 1570 2020-03-31 Indiana 18 2177 61
1571 1571 2020-03-31 Iowa 19 498 7
1572 1572 2020-03-31 Kansas 20 435 10
1573 1573 2020-03-31 Kentucky 21 590 18
1574 1574 2020-03-31 Louisiana 22 5237 240
1575 1575 2020-03-31 Maine 23 303 5
1576 1576 2020-03-31 Maryland 24 1662 18
1577 1577 2020-03-31 Massachusetts 25 6620 89
1578 1578 2020-03-31 Michigan 26 7629 264
1579 1579 2020-03-31 Minnesota 27 629 12
1580 1580 2020-03-31 Mississippi 28 937 20
1581 1581 2020-03-31 Missouri 29 1350 15
1582 1582 2020-03-31 Montana 30 198 5
1583 1583 2020-03-31 Nebraska 31 199 4
1584 1584 2020-03-31 Nevada 32 1113 26
1585 1585 2020-03-31 New Hampshire 33 367 3
1586 1586 2020-03-31 New Jersey 34 18696 267
1587 1587 2020-03-31 New Mexico 35 315 5
1588 1588 2020-03-31 New York 36 76211 1929
1589 1589 2020-03-31 North Carolina 37 1527 10
1590 1590 2020-03-31 North Dakota 38 126 3
1591 1591 2020-03-31 Northern Mariana Islands 69 2 0
1592 1592 2020-03-31 Ohio 39 2199 55
1593 1593 2020-03-31 Oklahoma 40 566 23
1594 1594 2020-03-31 Oregon 41 690 18
1595 1595 2020-03-31 Pennsylvania 42 4997 72
1596 1596 2020-03-31 Puerto Rico 72 239 8
1597 1597 2020-03-31 Rhode Island 44 488 8
1598 1598 2020-03-31 South Carolina 45 1083 22
1599 1599 2020-03-31 South Dakota 46 107 1
1600 1600 2020-03-31 Tennessee 47 2049 13
1601 1601 2020-03-31 Texas 48 3588 57
1602 1602 2020-03-31 Utah 49 887 5
1603 1603 2020-03-31 Vermont 50 293 13
1604 1604 2020-03-31 Virgin Islands 78 30 0
1605 1605 2020-03-31 Virginia 51 1249 27
1606 1606 2020-03-31 Washington 53 5293 226
1607 1607 2020-03-31 West Virginia 54 162 1
1608 1608 2020-03-31 Wisconsin 55 1351 25
1609 1609 2020-03-31 Wyoming 56 121 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
);