us-states
Data source: Big Local News · About: big-local-datasette
55 rows where "date" is on date 2020-03-30
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | date | state | fips | cases | deaths |
---|---|---|---|---|---|---|
1500 | 1500 | 2020-03-30 | Alabama | 1 | 947 | 11 |
1501 | 1501 | 2020-03-30 | Alaska | 2 | 120 | 2 |
1502 | 1502 | 2020-03-30 | Arizona | 4 | 1169 | 20 |
1503 | 1503 | 2020-03-30 | Arkansas | 5 | 508 | 7 |
1504 | 1504 | 2020-03-30 | California | 6 | 7421 | 147 |
1505 | 1505 | 2020-03-30 | Colorado | 8 | 2628 | 51 |
1506 | 1506 | 2020-03-30 | Connecticut | 9 | 2571 | 36 |
1507 | 1507 | 2020-03-30 | Delaware | 10 | 264 | 7 |
1508 | 1508 | 2020-03-30 | District of Columbia | 11 | 401 | 9 |
1509 | 1509 | 2020-03-30 | Florida | 12 | 5695 | 72 |
1510 | 1510 | 2020-03-30 | Georgia | 13 | 3032 | 103 |
1511 | 1511 | 2020-03-30 | Guam | 66 | 60 | 1 |
1512 | 1512 | 2020-03-30 | Hawaii | 15 | 204 | 0 |
1513 | 1513 | 2020-03-30 | Idaho | 16 | 415 | 7 |
1514 | 1514 | 2020-03-30 | Illinois | 17 | 5070 | 84 |
1515 | 1515 | 2020-03-30 | Indiana | 18 | 1797 | 44 |
1516 | 1516 | 2020-03-30 | Iowa | 19 | 424 | 6 |
1517 | 1517 | 2020-03-30 | Kansas | 20 | 374 | 9 |
1518 | 1518 | 2020-03-30 | Kentucky | 21 | 480 | 11 |
1519 | 1519 | 2020-03-30 | Louisiana | 22 | 4024 | 186 |
1520 | 1520 | 2020-03-30 | Maine | 23 | 275 | 3 |
1521 | 1521 | 2020-03-30 | Maryland | 24 | 1415 | 15 |
1522 | 1522 | 2020-03-30 | Massachusetts | 25 | 5752 | 56 |
1523 | 1523 | 2020-03-30 | Michigan | 26 | 6508 | 197 |
1524 | 1524 | 2020-03-30 | Minnesota | 27 | 576 | 10 |
1525 | 1525 | 2020-03-30 | Mississippi | 28 | 848 | 16 |
1526 | 1526 | 2020-03-30 | Missouri | 29 | 1049 | 13 |
1527 | 1527 | 2020-03-30 | Montana | 30 | 177 | 4 |
1528 | 1528 | 2020-03-30 | Nebraska | 31 | 185 | 3 |
1529 | 1529 | 2020-03-30 | Nevada | 32 | 1044 | 18 |
1530 | 1530 | 2020-03-30 | New Hampshire | 33 | 314 | 3 |
1531 | 1531 | 2020-03-30 | New Jersey | 34 | 16636 | 199 |
1532 | 1532 | 2020-03-30 | New Mexico | 35 | 282 | 4 |
1533 | 1533 | 2020-03-30 | New York | 36 | 67504 | 1512 |
1534 | 1534 | 2020-03-30 | North Carolina | 37 | 1303 | 6 |
1535 | 1535 | 2020-03-30 | North Dakota | 38 | 109 | 3 |
1536 | 1536 | 2020-03-30 | Northern Mariana Islands | 69 | 2 | 0 |
1537 | 1537 | 2020-03-30 | Ohio | 39 | 1933 | 40 |
1538 | 1538 | 2020-03-30 | Oklahoma | 40 | 481 | 17 |
1539 | 1539 | 2020-03-30 | Oregon | 41 | 607 | 16 |
1540 | 1540 | 2020-03-30 | Pennsylvania | 42 | 4156 | 48 |
1541 | 1541 | 2020-03-30 | Puerto Rico | 72 | 174 | 6 |
1542 | 1542 | 2020-03-30 | Rhode Island | 44 | 408 | 4 |
1543 | 1543 | 2020-03-30 | South Carolina | 45 | 925 | 18 |
1544 | 1544 | 2020-03-30 | South Dakota | 46 | 100 | 1 |
1545 | 1545 | 2020-03-30 | Tennessee | 47 | 1721 | 13 |
1546 | 1546 | 2020-03-30 | Texas | 48 | 3065 | 46 |
1547 | 1547 | 2020-03-30 | Utah | 49 | 806 | 4 |
1548 | 1548 | 2020-03-30 | Vermont | 50 | 256 | 12 |
1549 | 1549 | 2020-03-30 | Virgin Islands | 78 | 30 | 0 |
1550 | 1550 | 2020-03-30 | Virginia | 51 | 1020 | 26 |
1551 | 1551 | 2020-03-30 | Washington | 53 | 5180 | 221 |
1552 | 1552 | 2020-03-30 | West Virginia | 54 | 145 | 1 |
1553 | 1553 | 2020-03-30 | Wisconsin | 55 | 1269 | 20 |
1554 | 1554 | 2020-03-30 | Wyoming | 56 | 96 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );