ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 17105 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716546 | 1716546 | 2021-09-14 | Livingston | Illinois | 17105 | 5586 | 106 |
1713300 | 1713300 | 2021-09-13 | Livingston | Illinois | 17105 | 5559 | 106 |
1710053 | 1710053 | 2021-09-12 | Livingston | Illinois | 17105 | 5491 | 106 |
1706806 | 1706806 | 2021-09-11 | Livingston | Illinois | 17105 | 5491 | 106 |
1703558 | 1703558 | 2021-09-10 | Livingston | Illinois | 17105 | 5491 | 106 |
1700308 | 1700308 | 2021-09-09 | Livingston | Illinois | 17105 | 5459 | 106 |
1697059 | 1697059 | 2021-09-08 | Livingston | Illinois | 17105 | 5434 | 106 |
1693811 | 1693811 | 2021-09-07 | Livingston | Illinois | 17105 | 5411 | 106 |
1690562 | 1690562 | 2021-09-06 | Livingston | Illinois | 17105 | 5351 | 106 |
1687312 | 1687312 | 2021-09-05 | Livingston | Illinois | 17105 | 5351 | 106 |
1684062 | 1684062 | 2021-09-04 | Livingston | Illinois | 17105 | 5351 | 106 |
1680811 | 1680811 | 2021-09-03 | Livingston | Illinois | 17105 | 5351 | 106 |
1677563 | 1677563 | 2021-09-02 | Livingston | Illinois | 17105 | 5314 | 106 |
1674316 | 1674316 | 2021-09-01 | Livingston | Illinois | 17105 | 5293 | 106 |
1671067 | 1671067 | 2021-08-31 | Livingston | Illinois | 17105 | 5277 | 106 |
1667820 | 1667820 | 2021-08-30 | Livingston | Illinois | 17105 | 5249 | 106 |
1664573 | 1664573 | 2021-08-29 | Livingston | Illinois | 17105 | 5220 | 106 |
1661325 | 1661325 | 2021-08-28 | Livingston | Illinois | 17105 | 5220 | 106 |
1658077 | 1658077 | 2021-08-27 | Livingston | Illinois | 17105 | 5220 | 106 |
1654829 | 1654829 | 2021-08-26 | Livingston | Illinois | 17105 | 5203 | 106 |
1651582 | 1651582 | 2021-08-25 | Livingston | Illinois | 17105 | 5182 | 106 |
1648333 | 1648333 | 2021-08-24 | Livingston | Illinois | 17105 | 5168 | 106 |
1645085 | 1645085 | 2021-08-23 | Livingston | Illinois | 17105 | 5151 | 106 |
1641836 | 1641836 | 2021-08-22 | Livingston | Illinois | 17105 | 5126 | 106 |
1638586 | 1638586 | 2021-08-21 | Livingston | Illinois | 17105 | 5126 | 106 |
1635336 | 1635336 | 2021-08-20 | Livingston | Illinois | 17105 | 5126 | 106 |
1632086 | 1632086 | 2021-08-19 | Livingston | Illinois | 17105 | 5112 | 106 |
1628839 | 1628839 | 2021-08-18 | Livingston | Illinois | 17105 | 5101 | 106 |
1625592 | 1625592 | 2021-08-17 | Livingston | Illinois | 17105 | 5089 | 106 |
1622345 | 1622345 | 2021-08-16 | Livingston | Illinois | 17105 | 5071 | 107 |
1619098 | 1619098 | 2021-08-15 | Livingston | Illinois | 17105 | 5051 | 107 |
1615850 | 1615850 | 2021-08-14 | Livingston | Illinois | 17105 | 5051 | 107 |
1612601 | 1612601 | 2021-08-13 | Livingston | Illinois | 17105 | 5051 | 107 |
1609353 | 1609353 | 2021-08-12 | Livingston | Illinois | 17105 | 5045 | 107 |
1606104 | 1606104 | 2021-08-11 | Livingston | Illinois | 17105 | 5037 | 107 |
1602855 | 1602855 | 2021-08-10 | Livingston | Illinois | 17105 | 5028 | 107 |
1599606 | 1599606 | 2021-08-09 | Livingston | Illinois | 17105 | 5017 | 107 |
1596358 | 1596358 | 2021-08-08 | Livingston | Illinois | 17105 | 4999 | 107 |
1593109 | 1593109 | 2021-08-07 | Livingston | Illinois | 17105 | 4999 | 107 |
1589860 | 1589860 | 2021-08-06 | Livingston | Illinois | 17105 | 4999 | 107 |
1586611 | 1586611 | 2021-08-05 | Livingston | Illinois | 17105 | 4991 | 107 |
1583361 | 1583361 | 2021-08-04 | Livingston | Illinois | 17105 | 4987 | 107 |
1580111 | 1580111 | 2021-08-03 | Livingston | Illinois | 17105 | 4977 | 106 |
1576862 | 1576862 | 2021-08-02 | Livingston | Illinois | 17105 | 4960 | 106 |
1573614 | 1573614 | 2021-08-01 | Livingston | Illinois | 17105 | 4951 | 106 |
1570366 | 1570366 | 2021-07-31 | Livingston | Illinois | 17105 | 4951 | 106 |
1567118 | 1567118 | 2021-07-30 | Livingston | Illinois | 17105 | 4951 | 106 |
1563870 | 1563870 | 2021-07-29 | Livingston | Illinois | 17105 | 4946 | 106 |
1560622 | 1560622 | 2021-07-28 | Livingston | Illinois | 17105 | 4943 | 106 |
1557375 | 1557375 | 2021-07-27 | Livingston | Illinois | 17105 | 4941 | 105 |
1554128 | 1554128 | 2021-07-26 | Livingston | Illinois | 17105 | 4939 | 105 |
1550881 | 1550881 | 2021-07-25 | Livingston | Illinois | 17105 | 4931 | 104 |
1547634 | 1547634 | 2021-07-24 | Livingston | Illinois | 17105 | 4931 | 104 |
1544387 | 1544387 | 2021-07-23 | Livingston | Illinois | 17105 | 4931 | 104 |
1541139 | 1541139 | 2021-07-22 | Livingston | Illinois | 17105 | 4929 | 104 |
1537892 | 1537892 | 2021-07-21 | Livingston | Illinois | 17105 | 4924 | 104 |
1534644 | 1534644 | 2021-07-20 | Livingston | Illinois | 17105 | 4924 | 104 |
1531397 | 1531397 | 2021-07-19 | Livingston | Illinois | 17105 | 4922 | 104 |
1528150 | 1528150 | 2021-07-18 | Livingston | Illinois | 17105 | 4916 | 104 |
1524903 | 1524903 | 2021-07-17 | Livingston | Illinois | 17105 | 4916 | 104 |
1521655 | 1521655 | 2021-07-16 | Livingston | Illinois | 17105 | 4916 | 104 |
1518407 | 1518407 | 2021-07-15 | Livingston | Illinois | 17105 | 4916 | 104 |
1515160 | 1515160 | 2021-07-14 | Livingston | Illinois | 17105 | 4916 | 104 |
1511914 | 1511914 | 2021-07-13 | Livingston | Illinois | 17105 | 4917 | 104 |
1508667 | 1508667 | 2021-07-12 | Livingston | Illinois | 17105 | 4917 | 104 |
1505421 | 1505421 | 2021-07-11 | Livingston | Illinois | 17105 | 4910 | 104 |
1502175 | 1502175 | 2021-07-10 | Livingston | Illinois | 17105 | 4910 | 104 |
1498929 | 1498929 | 2021-07-09 | Livingston | Illinois | 17105 | 4910 | 104 |
1495682 | 1495682 | 2021-07-08 | Livingston | Illinois | 17105 | 4911 | 104 |
1492436 | 1492436 | 2021-07-07 | Livingston | Illinois | 17105 | 4910 | 104 |
1489189 | 1489189 | 2021-07-06 | Livingston | Illinois | 17105 | 4909 | 104 |
1485942 | 1485942 | 2021-07-05 | Livingston | Illinois | 17105 | 4908 | 104 |
1482696 | 1482696 | 2021-07-04 | Livingston | Illinois | 17105 | 4908 | 104 |
1479449 | 1479449 | 2021-07-03 | Livingston | Illinois | 17105 | 4908 | 104 |
1476203 | 1476203 | 2021-07-02 | Livingston | Illinois | 17105 | 4908 | 104 |
1472957 | 1472957 | 2021-07-01 | Livingston | Illinois | 17105 | 4908 | 103 |
1469711 | 1469711 | 2021-06-30 | Livingston | Illinois | 17105 | 4908 | 103 |
1466466 | 1466466 | 2021-06-29 | Livingston | Illinois | 17105 | 4907 | 103 |
1463221 | 1463221 | 2021-06-28 | Livingston | Illinois | 17105 | 4907 | 103 |
1459976 | 1459976 | 2021-06-27 | Livingston | Illinois | 17105 | 4903 | 103 |
1456731 | 1456731 | 2021-06-26 | Livingston | Illinois | 17105 | 4903 | 103 |
1453486 | 1453486 | 2021-06-25 | Livingston | Illinois | 17105 | 4903 | 103 |
1450240 | 1450240 | 2021-06-24 | Livingston | Illinois | 17105 | 4903 | 103 |
1446995 | 1446995 | 2021-06-23 | Livingston | Illinois | 17105 | 4902 | 103 |
1443750 | 1443750 | 2021-06-22 | Livingston | Illinois | 17105 | 4900 | 103 |
1440505 | 1440505 | 2021-06-21 | Livingston | Illinois | 17105 | 4899 | 103 |
1437258 | 1437258 | 2021-06-20 | Livingston | Illinois | 17105 | 4896 | 103 |
1434011 | 1434011 | 2021-06-19 | Livingston | Illinois | 17105 | 4896 | 103 |
1430765 | 1430765 | 2021-06-18 | Livingston | Illinois | 17105 | 4896 | 103 |
1427520 | 1427520 | 2021-06-17 | Livingston | Illinois | 17105 | 4897 | 103 |
1424275 | 1424275 | 2021-06-16 | Livingston | Illinois | 17105 | 4898 | 103 |
1421027 | 1421027 | 2021-06-15 | Livingston | Illinois | 17105 | 4896 | 103 |
1417782 | 1417782 | 2021-06-14 | Livingston | Illinois | 17105 | 4896 | 103 |
1414536 | 1414536 | 2021-06-13 | Livingston | Illinois | 17105 | 4896 | 103 |
1411291 | 1411291 | 2021-06-12 | Livingston | Illinois | 17105 | 4895 | 103 |
1408046 | 1408046 | 2021-06-11 | Livingston | Illinois | 17105 | 4894 | 103 |
1404800 | 1404800 | 2021-06-10 | Livingston | Illinois | 17105 | 4894 | 102 |
1401555 | 1401555 | 2021-06-09 | Livingston | Illinois | 17105 | 4892 | 102 |
1398310 | 1398310 | 2021-06-08 | Livingston | Illinois | 17105 | 4890 | 102 |
1395063 | 1395063 | 2021-06-07 | Livingston | Illinois | 17105 | 4890 | 102 |
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);