ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Chambers" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712655 | 1712655 | 2021-09-13 | Chambers | Alabama | 1017 | 5084 | 127 |
1709408 | 1709408 | 2021-09-12 | Chambers | Alabama | 1017 | 5062 | 127 |
1706161 | 1706161 | 2021-09-11 | Chambers | Alabama | 1017 | 5052 | 127 |
1702913 | 1702913 | 2021-09-10 | Chambers | Alabama | 1017 | 5019 | 127 |
1699663 | 1699663 | 2021-09-09 | Chambers | Alabama | 1017 | 4994 | 127 |
1696414 | 1696414 | 2021-09-08 | Chambers | Alabama | 1017 | 4960 | 127 |
1693166 | 1693166 | 2021-09-07 | Chambers | Alabama | 1017 | 4930 | 127 |
1689917 | 1689917 | 2021-09-06 | Chambers | Alabama | 1017 | 4905 | 127 |
1686667 | 1686667 | 2021-09-05 | Chambers | Alabama | 1017 | 4888 | 127 |
1683417 | 1683417 | 2021-09-04 | Chambers | Alabama | 1017 | 4871 | 127 |
1680166 | 1680166 | 2021-09-03 | Chambers | Alabama | 1017 | 4840 | 127 |
1676918 | 1676918 | 2021-09-02 | Chambers | Alabama | 1017 | 4807 | 127 |
1673671 | 1673671 | 2021-09-01 | Chambers | Alabama | 1017 | 4768 | 127 |
1670423 | 1670423 | 2021-08-31 | Chambers | Alabama | 1017 | 4732 | 127 |
1667176 | 1667176 | 2021-08-30 | Chambers | Alabama | 1017 | 4672 | 127 |
1663928 | 1663928 | 2021-08-29 | Chambers | Alabama | 1017 | 4642 | 127 |
1660680 | 1660680 | 2021-08-28 | Chambers | Alabama | 1017 | 4619 | 127 |
1657432 | 1657432 | 2021-08-27 | Chambers | Alabama | 1017 | 4575 | 127 |
1654184 | 1654184 | 2021-08-26 | Chambers | Alabama | 1017 | 4540 | 127 |
1650938 | 1650938 | 2021-08-25 | Chambers | Alabama | 1017 | 4500 | 126 |
1647689 | 1647689 | 2021-08-24 | Chambers | Alabama | 1017 | 4500 | 126 |
1644440 | 1644440 | 2021-08-23 | Chambers | Alabama | 1017 | 4500 | 126 |
1641190 | 1641190 | 2021-08-22 | Chambers | Alabama | 1017 | 4488 | 126 |
1637940 | 1637940 | 2021-08-21 | Chambers | Alabama | 1017 | 4448 | 126 |
1634690 | 1634690 | 2021-08-20 | Chambers | Alabama | 1017 | 4415 | 126 |
1631442 | 1631442 | 2021-08-19 | Chambers | Alabama | 1017 | 4376 | 126 |
1628195 | 1628195 | 2021-08-18 | Chambers | Alabama | 1017 | 4351 | 126 |
1624948 | 1624948 | 2021-08-17 | Chambers | Alabama | 1017 | 4322 | 125 |
1621701 | 1621701 | 2021-08-16 | Chambers | Alabama | 1017 | 4284 | 125 |
1618453 | 1618453 | 2021-08-15 | Chambers | Alabama | 1017 | 4263 | 125 |
1615205 | 1615205 | 2021-08-14 | Chambers | Alabama | 1017 | 4225 | 125 |
1611956 | 1611956 | 2021-08-13 | Chambers | Alabama | 1017 | 4225 | 125 |
1608709 | 1608709 | 2021-08-12 | Chambers | Alabama | 1017 | 4209 | 125 |
1605460 | 1605460 | 2021-08-11 | Chambers | Alabama | 1017 | 4181 | 125 |
1602210 | 1602210 | 2021-08-10 | Chambers | Alabama | 1017 | 4151 | 125 |
1598962 | 1598962 | 2021-08-09 | Chambers | Alabama | 1017 | 4119 | 125 |
1595713 | 1595713 | 2021-08-08 | Chambers | Alabama | 1017 | 4088 | 125 |
1592464 | 1592464 | 2021-08-07 | Chambers | Alabama | 1017 | 4088 | 125 |
1589215 | 1589215 | 2021-08-06 | Chambers | Alabama | 1017 | 4058 | 125 |
1585966 | 1585966 | 2021-08-05 | Chambers | Alabama | 1017 | 4033 | 125 |
1582716 | 1582716 | 2021-08-04 | Chambers | Alabama | 1017 | 4007 | 125 |
1579466 | 1579466 | 2021-08-03 | Chambers | Alabama | 1017 | 3987 | 125 |
1576218 | 1576218 | 2021-08-02 | Chambers | Alabama | 1017 | 3968 | 125 |
1572970 | 1572970 | 2021-08-01 | Chambers | Alabama | 1017 | 3949 | 125 |
1569722 | 1569722 | 2021-07-31 | Chambers | Alabama | 1017 | 3936 | 125 |
1566474 | 1566474 | 2021-07-30 | Chambers | Alabama | 1017 | 3915 | 125 |
1563226 | 1563226 | 2021-07-29 | Chambers | Alabama | 1017 | 3915 | 125 |
1559978 | 1559978 | 2021-07-28 | Chambers | Alabama | 1017 | 3898 | 125 |
1556731 | 1556731 | 2021-07-27 | Chambers | Alabama | 1017 | 3880 | 125 |
1553484 | 1553484 | 2021-07-26 | Chambers | Alabama | 1017 | 3857 | 125 |
1550237 | 1550237 | 2021-07-25 | Chambers | Alabama | 1017 | 3852 | 125 |
1546990 | 1546990 | 2021-07-24 | Chambers | Alabama | 1017 | 3842 | 125 |
1543743 | 1543743 | 2021-07-23 | Chambers | Alabama | 1017 | 3829 | 125 |
1540495 | 1540495 | 2021-07-22 | Chambers | Alabama | 1017 | 3813 | 124 |
1537248 | 1537248 | 2021-07-21 | Chambers | Alabama | 1017 | 3805 | 124 |
1534000 | 1534000 | 2021-07-20 | Chambers | Alabama | 1017 | 3801 | 124 |
1530753 | 1530753 | 2021-07-19 | Chambers | Alabama | 1017 | 3789 | 124 |
1527506 | 1527506 | 2021-07-18 | Chambers | Alabama | 1017 | 3786 | 124 |
1524259 | 1524259 | 2021-07-17 | Chambers | Alabama | 1017 | 3784 | 124 |
1521011 | 1521011 | 2021-07-16 | Chambers | Alabama | 1017 | 3781 | 124 |
1517763 | 1517763 | 2021-07-15 | Chambers | Alabama | 1017 | 3776 | 124 |
1514516 | 1514516 | 2021-07-14 | Chambers | Alabama | 1017 | 3773 | 124 |
1511270 | 1511270 | 2021-07-13 | Chambers | Alabama | 1017 | 3763 | 123 |
1508023 | 1508023 | 2021-07-12 | Chambers | Alabama | 1017 | 3763 | 123 |
1504777 | 1504777 | 2021-07-11 | Chambers | Alabama | 1017 | 3760 | 123 |
1501531 | 1501531 | 2021-07-10 | Chambers | Alabama | 1017 | 3760 | 123 |
1498285 | 1498285 | 2021-07-09 | Chambers | Alabama | 1017 | 3757 | 123 |
1495038 | 1495038 | 2021-07-08 | Chambers | Alabama | 1017 | 3751 | 123 |
1491791 | 1491791 | 2021-07-07 | Chambers | Alabama | 1017 | 3751 | 123 |
1488544 | 1488544 | 2021-07-06 | Chambers | Alabama | 1017 | 3738 | 123 |
1485297 | 1485297 | 2021-07-05 | Chambers | Alabama | 1017 | 3738 | 123 |
1482051 | 1482051 | 2021-07-04 | Chambers | Alabama | 1017 | 3738 | 123 |
1478804 | 1478804 | 2021-07-03 | Chambers | Alabama | 1017 | 3738 | 123 |
1475558 | 1475558 | 2021-07-02 | Chambers | Alabama | 1017 | 3738 | 123 |
1472312 | 1472312 | 2021-07-01 | Chambers | Alabama | 1017 | 3736 | 123 |
1469067 | 1469067 | 2021-06-30 | Chambers | Alabama | 1017 | 3736 | 123 |
1465822 | 1465822 | 2021-06-29 | Chambers | Alabama | 1017 | 3734 | 124 |
1462577 | 1462577 | 2021-06-28 | Chambers | Alabama | 1017 | 3734 | 124 |
1459332 | 1459332 | 2021-06-27 | Chambers | Alabama | 1017 | 3733 | 124 |
1456087 | 1456087 | 2021-06-26 | Chambers | Alabama | 1017 | 3733 | 124 |
1452842 | 1452842 | 2021-06-25 | Chambers | Alabama | 1017 | 3733 | 124 |
1449596 | 1449596 | 2021-06-24 | Chambers | Alabama | 1017 | 3731 | 124 |
1446351 | 1446351 | 2021-06-23 | Chambers | Alabama | 1017 | 3731 | 124 |
1443106 | 1443106 | 2021-06-22 | Chambers | Alabama | 1017 | 3728 | 124 |
1439861 | 1439861 | 2021-06-21 | Chambers | Alabama | 1017 | 3728 | 124 |
1436614 | 1436614 | 2021-06-20 | Chambers | Alabama | 1017 | 3728 | 124 |
1433367 | 1433367 | 2021-06-19 | Chambers | Alabama | 1017 | 3728 | 124 |
1430121 | 1430121 | 2021-06-18 | Chambers | Alabama | 1017 | 3728 | 124 |
1426876 | 1426876 | 2021-06-17 | Chambers | Alabama | 1017 | 3726 | 124 |
1423630 | 1423630 | 2021-06-16 | Chambers | Alabama | 1017 | 3726 | 124 |
1420383 | 1420383 | 2021-06-15 | Chambers | Alabama | 1017 | 3724 | 123 |
1417138 | 1417138 | 2021-06-14 | Chambers | Alabama | 1017 | 3723 | 123 |
1413892 | 1413892 | 2021-06-13 | Chambers | Alabama | 1017 | 3715 | 123 |
1410647 | 1410647 | 2021-06-12 | Chambers | Alabama | 1017 | 3715 | 123 |
1407402 | 1407402 | 2021-06-11 | Chambers | Alabama | 1017 | 3715 | 123 |
1404156 | 1404156 | 2021-06-10 | Chambers | Alabama | 1017 | 3716 | 124 |
1400911 | 1400911 | 2021-06-09 | Chambers | Alabama | 1017 | 3709 | 124 |
1397666 | 1397666 | 2021-06-08 | Chambers | Alabama | 1017 | 3709 | 124 |
1394419 | 1394419 | 2021-06-07 | Chambers | Alabama | 1017 | 3704 | 124 |
1391174 | 1391174 | 2021-06-06 | Chambers | Alabama | 1017 | 3696 | 124 |
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);