ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Shelby" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712704 | 1712704 | 2021-09-13 | Shelby | Alabama | 1117 | 34429 | 280 |
1709457 | 1709457 | 2021-09-12 | Shelby | Alabama | 1117 | 34306 | 280 |
1706210 | 1706210 | 2021-09-11 | Shelby | Alabama | 1117 | 34222 | 280 |
1702962 | 1702962 | 2021-09-10 | Shelby | Alabama | 1117 | 34013 | 280 |
1699712 | 1699712 | 2021-09-09 | Shelby | Alabama | 1117 | 33849 | 279 |
1696463 | 1696463 | 2021-09-08 | Shelby | Alabama | 1117 | 33642 | 278 |
1693215 | 1693215 | 2021-09-07 | Shelby | Alabama | 1117 | 33473 | 276 |
1689966 | 1689966 | 2021-09-06 | Shelby | Alabama | 1117 | 33355 | 276 |
1686716 | 1686716 | 2021-09-05 | Shelby | Alabama | 1117 | 33200 | 276 |
1683466 | 1683466 | 2021-09-04 | Shelby | Alabama | 1117 | 33044 | 276 |
1680215 | 1680215 | 2021-09-03 | Shelby | Alabama | 1117 | 32818 | 276 |
1676967 | 1676967 | 2021-09-02 | Shelby | Alabama | 1117 | 32623 | 276 |
1673720 | 1673720 | 2021-09-01 | Shelby | Alabama | 1117 | 32350 | 275 |
1670472 | 1670472 | 2021-08-31 | Shelby | Alabama | 1117 | 32121 | 276 |
1667225 | 1667225 | 2021-08-30 | Shelby | Alabama | 1117 | 31907 | 276 |
1663977 | 1663977 | 2021-08-29 | Shelby | Alabama | 1117 | 31769 | 276 |
1660729 | 1660729 | 2021-08-28 | Shelby | Alabama | 1117 | 31616 | 276 |
1657481 | 1657481 | 2021-08-27 | Shelby | Alabama | 1117 | 31209 | 275 |
1654233 | 1654233 | 2021-08-26 | Shelby | Alabama | 1117 | 30999 | 274 |
1650987 | 1650987 | 2021-08-25 | Shelby | Alabama | 1117 | 30521 | 272 |
1647738 | 1647738 | 2021-08-24 | Shelby | Alabama | 1117 | 30521 | 272 |
1644489 | 1644489 | 2021-08-23 | Shelby | Alabama | 1117 | 30521 | 272 |
1641239 | 1641239 | 2021-08-22 | Shelby | Alabama | 1117 | 30403 | 272 |
1637989 | 1637989 | 2021-08-21 | Shelby | Alabama | 1117 | 30267 | 272 |
1634739 | 1634739 | 2021-08-20 | Shelby | Alabama | 1117 | 29987 | 271 |
1631491 | 1631491 | 2021-08-19 | Shelby | Alabama | 1117 | 29850 | 270 |
1628244 | 1628244 | 2021-08-18 | Shelby | Alabama | 1117 | 29718 | 269 |
1624997 | 1624997 | 2021-08-17 | Shelby | Alabama | 1117 | 29561 | 269 |
1621750 | 1621750 | 2021-08-16 | Shelby | Alabama | 1117 | 29401 | 267 |
1618502 | 1618502 | 2021-08-15 | Shelby | Alabama | 1117 | 29284 | 267 |
1615254 | 1615254 | 2021-08-14 | Shelby | Alabama | 1117 | 28898 | 267 |
1612005 | 1612005 | 2021-08-13 | Shelby | Alabama | 1117 | 28898 | 267 |
1608758 | 1608758 | 2021-08-12 | Shelby | Alabama | 1117 | 28764 | 267 |
1605509 | 1605509 | 2021-08-11 | Shelby | Alabama | 1117 | 28595 | 266 |
1602259 | 1602259 | 2021-08-10 | Shelby | Alabama | 1117 | 28472 | 264 |
1599011 | 1599011 | 2021-08-09 | Shelby | Alabama | 1117 | 28336 | 263 |
1595762 | 1595762 | 2021-08-08 | Shelby | Alabama | 1117 | 28122 | 263 |
1592513 | 1592513 | 2021-08-07 | Shelby | Alabama | 1117 | 28122 | 263 |
1589264 | 1589264 | 2021-08-06 | Shelby | Alabama | 1117 | 27961 | 262 |
1586015 | 1586015 | 2021-08-05 | Shelby | Alabama | 1117 | 27810 | 261 |
1582765 | 1582765 | 2021-08-04 | Shelby | Alabama | 1117 | 27652 | 260 |
1579515 | 1579515 | 2021-08-03 | Shelby | Alabama | 1117 | 27501 | 259 |
1576267 | 1576267 | 2021-08-02 | Shelby | Alabama | 1117 | 27362 | 257 |
1573019 | 1573019 | 2021-08-01 | Shelby | Alabama | 1117 | 27280 | 257 |
1569771 | 1569771 | 2021-07-31 | Shelby | Alabama | 1117 | 27192 | 257 |
1566523 | 1566523 | 2021-07-30 | Shelby | Alabama | 1117 | 26983 | 256 |
1563275 | 1563275 | 2021-07-29 | Shelby | Alabama | 1117 | 26983 | 256 |
1560027 | 1560027 | 2021-07-28 | Shelby | Alabama | 1117 | 26873 | 256 |
1556780 | 1556780 | 2021-07-27 | Shelby | Alabama | 1117 | 26769 | 255 |
1553533 | 1553533 | 2021-07-26 | Shelby | Alabama | 1117 | 26671 | 255 |
1550286 | 1550286 | 2021-07-25 | Shelby | Alabama | 1117 | 26612 | 255 |
1547039 | 1547039 | 2021-07-24 | Shelby | Alabama | 1117 | 26527 | 255 |
1543792 | 1543792 | 2021-07-23 | Shelby | Alabama | 1117 | 26461 | 255 |
1540544 | 1540544 | 2021-07-22 | Shelby | Alabama | 1117 | 26409 | 255 |
1537297 | 1537297 | 2021-07-21 | Shelby | Alabama | 1117 | 26332 | 255 |
1534049 | 1534049 | 2021-07-20 | Shelby | Alabama | 1117 | 26270 | 255 |
1530802 | 1530802 | 2021-07-19 | Shelby | Alabama | 1117 | 26225 | 255 |
1527555 | 1527555 | 2021-07-18 | Shelby | Alabama | 1117 | 26194 | 255 |
1524308 | 1524308 | 2021-07-17 | Shelby | Alabama | 1117 | 26159 | 255 |
1521060 | 1521060 | 2021-07-16 | Shelby | Alabama | 1117 | 26122 | 255 |
1517812 | 1517812 | 2021-07-15 | Shelby | Alabama | 1117 | 26060 | 255 |
1514565 | 1514565 | 2021-07-14 | Shelby | Alabama | 1117 | 26024 | 255 |
1511319 | 1511319 | 2021-07-13 | Shelby | Alabama | 1117 | 25959 | 255 |
1508072 | 1508072 | 2021-07-12 | Shelby | Alabama | 1117 | 25959 | 255 |
1504826 | 1504826 | 2021-07-11 | Shelby | Alabama | 1117 | 25923 | 255 |
1501580 | 1501580 | 2021-07-10 | Shelby | Alabama | 1117 | 25923 | 255 |
1498334 | 1498334 | 2021-07-09 | Shelby | Alabama | 1117 | 25907 | 255 |
1495087 | 1495087 | 2021-07-08 | Shelby | Alabama | 1117 | 25847 | 255 |
1491840 | 1491840 | 2021-07-07 | Shelby | Alabama | 1117 | 25847 | 255 |
1488593 | 1488593 | 2021-07-06 | Shelby | Alabama | 1117 | 25745 | 255 |
1485346 | 1485346 | 2021-07-05 | Shelby | Alabama | 1117 | 25745 | 255 |
1482100 | 1482100 | 2021-07-04 | Shelby | Alabama | 1117 | 25745 | 255 |
1478853 | 1478853 | 2021-07-03 | Shelby | Alabama | 1117 | 25745 | 255 |
1475607 | 1475607 | 2021-07-02 | Shelby | Alabama | 1117 | 25745 | 255 |
1472361 | 1472361 | 2021-07-01 | Shelby | Alabama | 1117 | 25725 | 255 |
1469116 | 1469116 | 2021-06-30 | Shelby | Alabama | 1117 | 25725 | 255 |
1465871 | 1465871 | 2021-06-29 | Shelby | Alabama | 1117 | 25703 | 255 |
1462626 | 1462626 | 2021-06-28 | Shelby | Alabama | 1117 | 25703 | 255 |
1459381 | 1459381 | 2021-06-27 | Shelby | Alabama | 1117 | 25674 | 255 |
1456136 | 1456136 | 2021-06-26 | Shelby | Alabama | 1117 | 25674 | 255 |
1452891 | 1452891 | 2021-06-25 | Shelby | Alabama | 1117 | 25674 | 255 |
1449645 | 1449645 | 2021-06-24 | Shelby | Alabama | 1117 | 25638 | 255 |
1446400 | 1446400 | 2021-06-23 | Shelby | Alabama | 1117 | 25638 | 255 |
1443155 | 1443155 | 2021-06-22 | Shelby | Alabama | 1117 | 25626 | 254 |
1439910 | 1439910 | 2021-06-21 | Shelby | Alabama | 1117 | 25626 | 254 |
1436663 | 1436663 | 2021-06-20 | Shelby | Alabama | 1117 | 25607 | 254 |
1433416 | 1433416 | 2021-06-19 | Shelby | Alabama | 1117 | 25607 | 254 |
1430170 | 1430170 | 2021-06-18 | Shelby | Alabama | 1117 | 25607 | 254 |
1426925 | 1426925 | 2021-06-17 | Shelby | Alabama | 1117 | 25595 | 254 |
1423679 | 1423679 | 2021-06-16 | Shelby | Alabama | 1117 | 25595 | 254 |
1420432 | 1420432 | 2021-06-15 | Shelby | Alabama | 1117 | 25588 | 254 |
1417187 | 1417187 | 2021-06-14 | Shelby | Alabama | 1117 | 25580 | 254 |
1413941 | 1413941 | 2021-06-13 | Shelby | Alabama | 1117 | 25554 | 254 |
1410696 | 1410696 | 2021-06-12 | Shelby | Alabama | 1117 | 25554 | 254 |
1407451 | 1407451 | 2021-06-11 | Shelby | Alabama | 1117 | 25554 | 254 |
1404205 | 1404205 | 2021-06-10 | Shelby | Alabama | 1117 | 25554 | 254 |
1400960 | 1400960 | 2021-06-09 | Shelby | Alabama | 1117 | 25544 | 254 |
1397715 | 1397715 | 2021-06-08 | Shelby | Alabama | 1117 | 25533 | 254 |
1394468 | 1394468 | 2021-06-07 | Shelby | Alabama | 1117 | 25528 | 254 |
1391223 | 1391223 | 2021-06-06 | Shelby | Alabama | 1117 | 25485 | 254 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);