ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "St. Clair" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712705 | 1712705 | 2021-09-13 | St. Clair | Alabama | 1115 | 14539 | 267 |
1709458 | 1709458 | 2021-09-12 | St. Clair | Alabama | 1115 | 14465 | 267 |
1706211 | 1706211 | 2021-09-11 | St. Clair | Alabama | 1115 | 14416 | 267 |
1702963 | 1702963 | 2021-09-10 | St. Clair | Alabama | 1115 | 14295 | 266 |
1699713 | 1699713 | 2021-09-09 | St. Clair | Alabama | 1115 | 14218 | 263 |
1696464 | 1696464 | 2021-09-08 | St. Clair | Alabama | 1115 | 14098 | 263 |
1693216 | 1693216 | 2021-09-07 | St. Clair | Alabama | 1115 | 13934 | 261 |
1689967 | 1689967 | 2021-09-06 | St. Clair | Alabama | 1115 | 13880 | 261 |
1686717 | 1686717 | 2021-09-05 | St. Clair | Alabama | 1115 | 13810 | 261 |
1683467 | 1683467 | 2021-09-04 | St. Clair | Alabama | 1115 | 13732 | 261 |
1680216 | 1680216 | 2021-09-03 | St. Clair | Alabama | 1115 | 13594 | 261 |
1676968 | 1676968 | 2021-09-02 | St. Clair | Alabama | 1115 | 13460 | 260 |
1673721 | 1673721 | 2021-09-01 | St. Clair | Alabama | 1115 | 13321 | 259 |
1670473 | 1670473 | 2021-08-31 | St. Clair | Alabama | 1115 | 13231 | 259 |
1667226 | 1667226 | 2021-08-30 | St. Clair | Alabama | 1115 | 13065 | 258 |
1663978 | 1663978 | 2021-08-29 | St. Clair | Alabama | 1115 | 13012 | 258 |
1660730 | 1660730 | 2021-08-28 | St. Clair | Alabama | 1115 | 12941 | 258 |
1657482 | 1657482 | 2021-08-27 | St. Clair | Alabama | 1115 | 12822 | 257 |
1654234 | 1654234 | 2021-08-26 | St. Clair | Alabama | 1115 | 12699 | 256 |
1650988 | 1650988 | 2021-08-25 | St. Clair | Alabama | 1115 | 12385 | 255 |
1647739 | 1647739 | 2021-08-24 | St. Clair | Alabama | 1115 | 12385 | 255 |
1644490 | 1644490 | 2021-08-23 | St. Clair | Alabama | 1115 | 12385 | 255 |
1641240 | 1641240 | 2021-08-22 | St. Clair | Alabama | 1115 | 12347 | 255 |
1637990 | 1637990 | 2021-08-21 | St. Clair | Alabama | 1115 | 12273 | 255 |
1634740 | 1634740 | 2021-08-20 | St. Clair | Alabama | 1115 | 12111 | 255 |
1631492 | 1631492 | 2021-08-19 | St. Clair | Alabama | 1115 | 12043 | 254 |
1628245 | 1628245 | 2021-08-18 | St. Clair | Alabama | 1115 | 11930 | 254 |
1624998 | 1624998 | 2021-08-17 | St. Clair | Alabama | 1115 | 11801 | 253 |
1621751 | 1621751 | 2021-08-16 | St. Clair | Alabama | 1115 | 11672 | 253 |
1618503 | 1618503 | 2021-08-15 | St. Clair | Alabama | 1115 | 11617 | 253 |
1615255 | 1615255 | 2021-08-14 | St. Clair | Alabama | 1115 | 11479 | 252 |
1612006 | 1612006 | 2021-08-13 | St. Clair | Alabama | 1115 | 11479 | 252 |
1608759 | 1608759 | 2021-08-12 | St. Clair | Alabama | 1115 | 11409 | 252 |
1605510 | 1605510 | 2021-08-11 | St. Clair | Alabama | 1115 | 11340 | 252 |
1602260 | 1602260 | 2021-08-10 | St. Clair | Alabama | 1115 | 11267 | 252 |
1599012 | 1599012 | 2021-08-09 | St. Clair | Alabama | 1115 | 11205 | 252 |
1595763 | 1595763 | 2021-08-08 | St. Clair | Alabama | 1115 | 11116 | 252 |
1592514 | 1592514 | 2021-08-07 | St. Clair | Alabama | 1115 | 11116 | 252 |
1589265 | 1589265 | 2021-08-06 | St. Clair | Alabama | 1115 | 11035 | 252 |
1586016 | 1586016 | 2021-08-05 | St. Clair | Alabama | 1115 | 10974 | 252 |
1582766 | 1582766 | 2021-08-04 | St. Clair | Alabama | 1115 | 10903 | 252 |
1579516 | 1579516 | 2021-08-03 | St. Clair | Alabama | 1115 | 10852 | 252 |
1576268 | 1576268 | 2021-08-02 | St. Clair | Alabama | 1115 | 10793 | 252 |
1573020 | 1573020 | 2021-08-01 | St. Clair | Alabama | 1115 | 10763 | 252 |
1569772 | 1569772 | 2021-07-31 | St. Clair | Alabama | 1115 | 10737 | 252 |
1566524 | 1566524 | 2021-07-30 | St. Clair | Alabama | 1115 | 10658 | 251 |
1563276 | 1563276 | 2021-07-29 | St. Clair | Alabama | 1115 | 10658 | 251 |
1560028 | 1560028 | 2021-07-28 | St. Clair | Alabama | 1115 | 10617 | 252 |
1556781 | 1556781 | 2021-07-27 | St. Clair | Alabama | 1115 | 10587 | 250 |
1553534 | 1553534 | 2021-07-26 | St. Clair | Alabama | 1115 | 10541 | 251 |
1550287 | 1550287 | 2021-07-25 | St. Clair | Alabama | 1115 | 10521 | 251 |
1547040 | 1547040 | 2021-07-24 | St. Clair | Alabama | 1115 | 10500 | 251 |
1543793 | 1543793 | 2021-07-23 | St. Clair | Alabama | 1115 | 10469 | 251 |
1540545 | 1540545 | 2021-07-22 | St. Clair | Alabama | 1115 | 10449 | 251 |
1537298 | 1537298 | 2021-07-21 | St. Clair | Alabama | 1115 | 10427 | 251 |
1534050 | 1534050 | 2021-07-20 | St. Clair | Alabama | 1115 | 10397 | 251 |
1530803 | 1530803 | 2021-07-19 | St. Clair | Alabama | 1115 | 10345 | 251 |
1527556 | 1527556 | 2021-07-18 | St. Clair | Alabama | 1115 | 10332 | 251 |
1524309 | 1524309 | 2021-07-17 | St. Clair | Alabama | 1115 | 10324 | 251 |
1521061 | 1521061 | 2021-07-16 | St. Clair | Alabama | 1115 | 10311 | 251 |
1517813 | 1517813 | 2021-07-15 | St. Clair | Alabama | 1115 | 10276 | 251 |
1514566 | 1514566 | 2021-07-14 | St. Clair | Alabama | 1115 | 10261 | 251 |
1511320 | 1511320 | 2021-07-13 | St. Clair | Alabama | 1115 | 10254 | 250 |
1508073 | 1508073 | 2021-07-12 | St. Clair | Alabama | 1115 | 10254 | 250 |
1504827 | 1504827 | 2021-07-11 | St. Clair | Alabama | 1115 | 10249 | 250 |
1501581 | 1501581 | 2021-07-10 | St. Clair | Alabama | 1115 | 10249 | 250 |
1498335 | 1498335 | 2021-07-09 | St. Clair | Alabama | 1115 | 10243 | 250 |
1495088 | 1495088 | 2021-07-08 | St. Clair | Alabama | 1115 | 10229 | 250 |
1491841 | 1491841 | 2021-07-07 | St. Clair | Alabama | 1115 | 10229 | 250 |
1488594 | 1488594 | 2021-07-06 | St. Clair | Alabama | 1115 | 10205 | 250 |
1485347 | 1485347 | 2021-07-05 | St. Clair | Alabama | 1115 | 10205 | 250 |
1482101 | 1482101 | 2021-07-04 | St. Clair | Alabama | 1115 | 10205 | 250 |
1478854 | 1478854 | 2021-07-03 | St. Clair | Alabama | 1115 | 10205 | 250 |
1475608 | 1475608 | 2021-07-02 | St. Clair | Alabama | 1115 | 10205 | 250 |
1472362 | 1472362 | 2021-07-01 | St. Clair | Alabama | 1115 | 10201 | 250 |
1469117 | 1469117 | 2021-06-30 | St. Clair | Alabama | 1115 | 10201 | 250 |
1465872 | 1465872 | 2021-06-29 | St. Clair | Alabama | 1115 | 10192 | 251 |
1462627 | 1462627 | 2021-06-28 | St. Clair | Alabama | 1115 | 10192 | 251 |
1459382 | 1459382 | 2021-06-27 | St. Clair | Alabama | 1115 | 10186 | 251 |
1456137 | 1456137 | 2021-06-26 | St. Clair | Alabama | 1115 | 10186 | 251 |
1452892 | 1452892 | 2021-06-25 | St. Clair | Alabama | 1115 | 10186 | 251 |
1449646 | 1449646 | 2021-06-24 | St. Clair | Alabama | 1115 | 10166 | 251 |
1446401 | 1446401 | 2021-06-23 | St. Clair | Alabama | 1115 | 10166 | 251 |
1443156 | 1443156 | 2021-06-22 | St. Clair | Alabama | 1115 | 10161 | 251 |
1439911 | 1439911 | 2021-06-21 | St. Clair | Alabama | 1115 | 10161 | 251 |
1436664 | 1436664 | 2021-06-20 | St. Clair | Alabama | 1115 | 10162 | 251 |
1433417 | 1433417 | 2021-06-19 | St. Clair | Alabama | 1115 | 10162 | 251 |
1430171 | 1430171 | 2021-06-18 | St. Clair | Alabama | 1115 | 10162 | 251 |
1426926 | 1426926 | 2021-06-17 | St. Clair | Alabama | 1115 | 10160 | 251 |
1423680 | 1423680 | 2021-06-16 | St. Clair | Alabama | 1115 | 10160 | 251 |
1420433 | 1420433 | 2021-06-15 | St. Clair | Alabama | 1115 | 10158 | 250 |
1417188 | 1417188 | 2021-06-14 | St. Clair | Alabama | 1115 | 10155 | 250 |
1413942 | 1413942 | 2021-06-13 | St. Clair | Alabama | 1115 | 10146 | 250 |
1410697 | 1410697 | 2021-06-12 | St. Clair | Alabama | 1115 | 10146 | 250 |
1407452 | 1407452 | 2021-06-11 | St. Clair | Alabama | 1115 | 10146 | 250 |
1404206 | 1404206 | 2021-06-10 | St. Clair | Alabama | 1115 | 10142 | 250 |
1400961 | 1400961 | 2021-06-09 | St. Clair | Alabama | 1115 | 10138 | 250 |
1397716 | 1397716 | 2021-06-08 | St. Clair | Alabama | 1115 | 10133 | 249 |
1394469 | 1394469 | 2021-06-07 | St. Clair | Alabama | 1115 | 10125 | 249 |
1391224 | 1391224 | 2021-06-06 | St. Clair | Alabama | 1115 | 10107 | 247 |
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);