ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "St. Clair" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716580 | 1716580 | 2021-09-14 | St. Clair | Illinois | 17163 | 38221 | 600 |
1713334 | 1713334 | 2021-09-13 | St. Clair | Illinois | 17163 | 38221 | 599 |
1710087 | 1710087 | 2021-09-12 | St. Clair | Illinois | 17163 | 38023 | 596 |
1706840 | 1706840 | 2021-09-11 | St. Clair | Illinois | 17163 | 38023 | 596 |
1703592 | 1703592 | 2021-09-10 | St. Clair | Illinois | 17163 | 38023 | 596 |
1700342 | 1700342 | 2021-09-09 | St. Clair | Illinois | 17163 | 37886 | 595 |
1697093 | 1697093 | 2021-09-08 | St. Clair | Illinois | 17163 | 37799 | 595 |
1693845 | 1693845 | 2021-09-07 | St. Clair | Illinois | 17163 | 37682 | 595 |
1690596 | 1690596 | 2021-09-06 | St. Clair | Illinois | 17163 | 37402 | 593 |
1687346 | 1687346 | 2021-09-05 | St. Clair | Illinois | 17163 | 37402 | 593 |
1684096 | 1684096 | 2021-09-04 | St. Clair | Illinois | 17163 | 37402 | 593 |
1680845 | 1680845 | 2021-09-03 | St. Clair | Illinois | 17163 | 37402 | 593 |
1677597 | 1677597 | 2021-09-02 | St. Clair | Illinois | 17163 | 37266 | 593 |
1674350 | 1674350 | 2021-09-01 | St. Clair | Illinois | 17163 | 37142 | 592 |
1671101 | 1671101 | 2021-08-31 | St. Clair | Illinois | 17163 | 36980 | 591 |
1667854 | 1667854 | 2021-08-30 | St. Clair | Illinois | 17163 | 36884 | 590 |
1664607 | 1664607 | 2021-08-29 | St. Clair | Illinois | 17163 | 36477 | 587 |
1661359 | 1661359 | 2021-08-28 | St. Clair | Illinois | 17163 | 36477 | 587 |
1658111 | 1658111 | 2021-08-27 | St. Clair | Illinois | 17163 | 36477 | 587 |
1654863 | 1654863 | 2021-08-26 | St. Clair | Illinois | 17163 | 36477 | 587 |
1651616 | 1651616 | 2021-08-25 | St. Clair | Illinois | 17163 | 36385 | 586 |
1648367 | 1648367 | 2021-08-24 | St. Clair | Illinois | 17163 | 36161 | 585 |
1645119 | 1645119 | 2021-08-23 | St. Clair | Illinois | 17163 | 36161 | 584 |
1641870 | 1641870 | 2021-08-22 | St. Clair | Illinois | 17163 | 35874 | 583 |
1638620 | 1638620 | 2021-08-21 | St. Clair | Illinois | 17163 | 35874 | 583 |
1635370 | 1635370 | 2021-08-20 | St. Clair | Illinois | 17163 | 35874 | 583 |
1632120 | 1632120 | 2021-08-19 | St. Clair | Illinois | 17163 | 35706 | 582 |
1628873 | 1628873 | 2021-08-18 | St. Clair | Illinois | 17163 | 35612 | 580 |
1625626 | 1625626 | 2021-08-17 | St. Clair | Illinois | 17163 | 35454 | 578 |
1622379 | 1622379 | 2021-08-16 | St. Clair | Illinois | 17163 | 35355 | 576 |
1619132 | 1619132 | 2021-08-15 | St. Clair | Illinois | 17163 | 35020 | 576 |
1615884 | 1615884 | 2021-08-14 | St. Clair | Illinois | 17163 | 35020 | 576 |
1612635 | 1612635 | 2021-08-13 | St. Clair | Illinois | 17163 | 35020 | 576 |
1609387 | 1609387 | 2021-08-12 | St. Clair | Illinois | 17163 | 34929 | 576 |
1606138 | 1606138 | 2021-08-11 | St. Clair | Illinois | 17163 | 34755 | 576 |
1602889 | 1602889 | 2021-08-10 | St. Clair | Illinois | 17163 | 34645 | 576 |
1599640 | 1599640 | 2021-08-09 | St. Clair | Illinois | 17163 | 34566 | 576 |
1596392 | 1596392 | 2021-08-08 | St. Clair | Illinois | 17163 | 34263 | 574 |
1593143 | 1593143 | 2021-08-07 | St. Clair | Illinois | 17163 | 34263 | 574 |
1589894 | 1589894 | 2021-08-06 | St. Clair | Illinois | 17163 | 34263 | 574 |
1586645 | 1586645 | 2021-08-05 | St. Clair | Illinois | 17163 | 34117 | 574 |
1583395 | 1583395 | 2021-08-04 | St. Clair | Illinois | 17163 | 33976 | 572 |
1580145 | 1580145 | 2021-08-03 | St. Clair | Illinois | 17163 | 33221 | 571 |
1576896 | 1576896 | 2021-08-02 | St. Clair | Illinois | 17163 | 33221 | 571 |
1573648 | 1573648 | 2021-08-01 | St. Clair | Illinois | 17163 | 33221 | 571 |
1570400 | 1570400 | 2021-07-31 | St. Clair | Illinois | 17163 | 33221 | 571 |
1567152 | 1567152 | 2021-07-30 | St. Clair | Illinois | 17163 | 33221 | 571 |
1563904 | 1563904 | 2021-07-29 | St. Clair | Illinois | 17163 | 33221 | 570 |
1560656 | 1560656 | 2021-07-28 | St. Clair | Illinois | 17163 | 33221 | 570 |
1557409 | 1557409 | 2021-07-27 | St. Clair | Illinois | 17163 | 33003 | 570 |
1554162 | 1554162 | 2021-07-26 | St. Clair | Illinois | 17163 | 33003 | 570 |
1550915 | 1550915 | 2021-07-25 | St. Clair | Illinois | 17163 | 32588 | 570 |
1547668 | 1547668 | 2021-07-24 | St. Clair | Illinois | 17163 | 32588 | 570 |
1544421 | 1544421 | 2021-07-23 | St. Clair | Illinois | 17163 | 32588 | 570 |
1541173 | 1541173 | 2021-07-22 | St. Clair | Illinois | 17163 | 32588 | 570 |
1537926 | 1537926 | 2021-07-21 | St. Clair | Illinois | 17163 | 32588 | 570 |
1534678 | 1534678 | 2021-07-20 | St. Clair | Illinois | 17163 | 32171 | 570 |
1531431 | 1531431 | 2021-07-19 | St. Clair | Illinois | 17163 | 32171 | 570 |
1528184 | 1528184 | 2021-07-18 | St. Clair | Illinois | 17163 | 32171 | 566 |
1524937 | 1524937 | 2021-07-17 | St. Clair | Illinois | 17163 | 32171 | 566 |
1521689 | 1521689 | 2021-07-16 | St. Clair | Illinois | 17163 | 32171 | 566 |
1518441 | 1518441 | 2021-07-15 | St. Clair | Illinois | 17163 | 32171 | 565 |
1515194 | 1515194 | 2021-07-14 | St. Clair | Illinois | 17163 | 32171 | 565 |
1511948 | 1511948 | 2021-07-13 | St. Clair | Illinois | 17163 | 31822 | 565 |
1508701 | 1508701 | 2021-07-12 | St. Clair | Illinois | 17163 | 31822 | 565 |
1505455 | 1505455 | 2021-07-11 | St. Clair | Illinois | 17163 | 31822 | 564 |
1502209 | 1502209 | 2021-07-10 | St. Clair | Illinois | 17163 | 31822 | 564 |
1498963 | 1498963 | 2021-07-09 | St. Clair | Illinois | 17163 | 31822 | 564 |
1495716 | 1495716 | 2021-07-08 | St. Clair | Illinois | 17163 | 31822 | 564 |
1492470 | 1492470 | 2021-07-07 | St. Clair | Illinois | 17163 | 31822 | 564 |
1489223 | 1489223 | 2021-07-06 | St. Clair | Illinois | 17163 | 31603 | 564 |
1485976 | 1485976 | 2021-07-05 | St. Clair | Illinois | 17163 | 31603 | 563 |
1482730 | 1482730 | 2021-07-04 | St. Clair | Illinois | 17163 | 31603 | 563 |
1479483 | 1479483 | 2021-07-03 | St. Clair | Illinois | 17163 | 31603 | 563 |
1476237 | 1476237 | 2021-07-02 | St. Clair | Illinois | 17163 | 31603 | 563 |
1472991 | 1472991 | 2021-07-01 | St. Clair | Illinois | 17163 | 31603 | 563 |
1469745 | 1469745 | 2021-06-30 | St. Clair | Illinois | 17163 | 31603 | 563 |
1466500 | 1466500 | 2021-06-29 | St. Clair | Illinois | 17163 | 31406 | 563 |
1463255 | 1463255 | 2021-06-28 | St. Clair | Illinois | 17163 | 31406 | 563 |
1460010 | 1460010 | 2021-06-27 | St. Clair | Illinois | 17163 | 31406 | 563 |
1456765 | 1456765 | 2021-06-26 | St. Clair | Illinois | 17163 | 31406 | 563 |
1453520 | 1453520 | 2021-06-25 | St. Clair | Illinois | 17163 | 31406 | 563 |
1450274 | 1450274 | 2021-06-24 | St. Clair | Illinois | 17163 | 31406 | 563 |
1447029 | 1447029 | 2021-06-23 | St. Clair | Illinois | 17163 | 31406 | 563 |
1443784 | 1443784 | 2021-06-22 | St. Clair | Illinois | 17163 | 31315 | 563 |
1440539 | 1440539 | 2021-06-21 | St. Clair | Illinois | 17163 | 31315 | 563 |
1437292 | 1437292 | 2021-06-20 | St. Clair | Illinois | 17163 | 31315 | 563 |
1434045 | 1434045 | 2021-06-19 | St. Clair | Illinois | 17163 | 31315 | 563 |
1430799 | 1430799 | 2021-06-18 | St. Clair | Illinois | 17163 | 31315 | 563 |
1427554 | 1427554 | 2021-06-17 | St. Clair | Illinois | 17163 | 31315 | 563 |
1424309 | 1424309 | 2021-06-16 | St. Clair | Illinois | 17163 | 31315 | 563 |
1421061 | 1421061 | 2021-06-15 | St. Clair | Illinois | 17163 | 31263 | 563 |
1417816 | 1417816 | 2021-06-14 | St. Clair | Illinois | 17163 | 31263 | 563 |
1414570 | 1414570 | 2021-06-13 | St. Clair | Illinois | 17163 | 31263 | 563 |
1411325 | 1411325 | 2021-06-12 | St. Clair | Illinois | 17163 | 31263 | 563 |
1408080 | 1408080 | 2021-06-11 | St. Clair | Illinois | 17163 | 31263 | 563 |
1404834 | 1404834 | 2021-06-10 | St. Clair | Illinois | 17163 | 31251 | 563 |
1401589 | 1401589 | 2021-06-09 | St. Clair | Illinois | 17163 | 31235 | 563 |
1398344 | 1398344 | 2021-06-08 | St. Clair | Illinois | 17163 | 31226 | 563 |
1395097 | 1395097 | 2021-06-07 | St. Clair | Illinois | 17163 | 31216 | 563 |
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);