ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Winnebago" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716595 | 1716595 | 2021-09-14 | Winnebago | Illinois | 17201 | 38343 | 569 |
1713349 | 1713349 | 2021-09-13 | Winnebago | Illinois | 17201 | 38245 | 569 |
1710102 | 1710102 | 2021-09-12 | Winnebago | Illinois | 17201 | 37991 | 566 |
1706855 | 1706855 | 2021-09-11 | Winnebago | Illinois | 17201 | 37991 | 566 |
1703607 | 1703607 | 2021-09-10 | Winnebago | Illinois | 17201 | 37991 | 566 |
1700357 | 1700357 | 2021-09-09 | Winnebago | Illinois | 17201 | 37844 | 565 |
1697108 | 1697108 | 2021-09-08 | Winnebago | Illinois | 17201 | 37714 | 565 |
1693860 | 1693860 | 2021-09-07 | Winnebago | Illinois | 17201 | 37653 | 565 |
1690611 | 1690611 | 2021-09-06 | Winnebago | Illinois | 17201 | 37384 | 565 |
1687361 | 1687361 | 2021-09-05 | Winnebago | Illinois | 17201 | 37384 | 565 |
1684111 | 1684111 | 2021-09-04 | Winnebago | Illinois | 17201 | 37384 | 565 |
1680860 | 1680860 | 2021-09-03 | Winnebago | Illinois | 17201 | 37384 | 565 |
1677612 | 1677612 | 2021-09-02 | Winnebago | Illinois | 17201 | 37270 | 564 |
1674365 | 1674365 | 2021-09-01 | Winnebago | Illinois | 17201 | 37155 | 564 |
1671116 | 1671116 | 2021-08-31 | Winnebago | Illinois | 17201 | 37042 | 564 |
1667869 | 1667869 | 2021-08-30 | Winnebago | Illinois | 17201 | 36958 | 563 |
1664622 | 1664622 | 2021-08-29 | Winnebago | Illinois | 17201 | 36727 | 562 |
1661374 | 1661374 | 2021-08-28 | Winnebago | Illinois | 17201 | 36727 | 562 |
1658126 | 1658126 | 2021-08-27 | Winnebago | Illinois | 17201 | 36727 | 562 |
1654878 | 1654878 | 2021-08-26 | Winnebago | Illinois | 17201 | 36625 | 562 |
1651631 | 1651631 | 2021-08-25 | Winnebago | Illinois | 17201 | 36518 | 561 |
1648382 | 1648382 | 2021-08-24 | Winnebago | Illinois | 17201 | 36433 | 561 |
1645134 | 1645134 | 2021-08-23 | Winnebago | Illinois | 17201 | 36341 | 561 |
1641885 | 1641885 | 2021-08-22 | Winnebago | Illinois | 17201 | 36161 | 560 |
1638635 | 1638635 | 2021-08-21 | Winnebago | Illinois | 17201 | 36161 | 560 |
1635385 | 1635385 | 2021-08-20 | Winnebago | Illinois | 17201 | 36161 | 560 |
1632135 | 1632135 | 2021-08-19 | Winnebago | Illinois | 17201 | 36088 | 560 |
1628888 | 1628888 | 2021-08-18 | Winnebago | Illinois | 17201 | 35994 | 559 |
1625641 | 1625641 | 2021-08-17 | Winnebago | Illinois | 17201 | 35906 | 559 |
1622394 | 1622394 | 2021-08-16 | Winnebago | Illinois | 17201 | 35855 | 559 |
1619147 | 1619147 | 2021-08-15 | Winnebago | Illinois | 17201 | 35699 | 556 |
1615899 | 1615899 | 2021-08-14 | Winnebago | Illinois | 17201 | 35699 | 556 |
1612650 | 1612650 | 2021-08-13 | Winnebago | Illinois | 17201 | 35699 | 556 |
1609402 | 1609402 | 2021-08-12 | Winnebago | Illinois | 17201 | 35588 | 556 |
1606153 | 1606153 | 2021-08-11 | Winnebago | Illinois | 17201 | 35516 | 555 |
1602904 | 1602904 | 2021-08-10 | Winnebago | Illinois | 17201 | 35440 | 555 |
1599655 | 1599655 | 2021-08-09 | Winnebago | Illinois | 17201 | 35392 | 555 |
1596407 | 1596407 | 2021-08-08 | Winnebago | Illinois | 17201 | 35218 | 555 |
1593158 | 1593158 | 2021-08-07 | Winnebago | Illinois | 17201 | 35218 | 555 |
1589909 | 1589909 | 2021-08-06 | Winnebago | Illinois | 17201 | 35218 | 555 |
1586660 | 1586660 | 2021-08-05 | Winnebago | Illinois | 17201 | 35149 | 555 |
1583410 | 1583410 | 2021-08-04 | Winnebago | Illinois | 17201 | 35091 | 555 |
1580160 | 1580160 | 2021-08-03 | Winnebago | Illinois | 17201 | 35016 | 555 |
1576911 | 1576911 | 2021-08-02 | Winnebago | Illinois | 17201 | 34950 | 555 |
1573663 | 1573663 | 2021-08-01 | Winnebago | Illinois | 17201 | 34822 | 554 |
1570415 | 1570415 | 2021-07-31 | Winnebago | Illinois | 17201 | 34822 | 554 |
1567167 | 1567167 | 2021-07-30 | Winnebago | Illinois | 17201 | 34822 | 554 |
1563919 | 1563919 | 2021-07-29 | Winnebago | Illinois | 17201 | 34763 | 554 |
1560671 | 1560671 | 2021-07-28 | Winnebago | Illinois | 17201 | 34719 | 554 |
1557424 | 1557424 | 2021-07-27 | Winnebago | Illinois | 17201 | 34671 | 554 |
1554177 | 1554177 | 2021-07-26 | Winnebago | Illinois | 17201 | 34649 | 554 |
1550930 | 1550930 | 2021-07-25 | Winnebago | Illinois | 17201 | 34589 | 553 |
1547683 | 1547683 | 2021-07-24 | Winnebago | Illinois | 17201 | 34589 | 553 |
1544436 | 1544436 | 2021-07-23 | Winnebago | Illinois | 17201 | 34589 | 553 |
1541188 | 1541188 | 2021-07-22 | Winnebago | Illinois | 17201 | 34538 | 553 |
1537941 | 1537941 | 2021-07-21 | Winnebago | Illinois | 17201 | 34492 | 553 |
1534693 | 1534693 | 2021-07-20 | Winnebago | Illinois | 17201 | 34462 | 552 |
1531446 | 1531446 | 2021-07-19 | Winnebago | Illinois | 17201 | 34433 | 552 |
1528199 | 1528199 | 2021-07-18 | Winnebago | Illinois | 17201 | 34377 | 550 |
1524952 | 1524952 | 2021-07-17 | Winnebago | Illinois | 17201 | 34377 | 550 |
1521704 | 1521704 | 2021-07-16 | Winnebago | Illinois | 17201 | 34377 | 550 |
1518456 | 1518456 | 2021-07-15 | Winnebago | Illinois | 17201 | 34367 | 549 |
1515209 | 1515209 | 2021-07-14 | Winnebago | Illinois | 17201 | 34352 | 548 |
1511963 | 1511963 | 2021-07-13 | Winnebago | Illinois | 17201 | 34340 | 547 |
1508716 | 1508716 | 2021-07-12 | Winnebago | Illinois | 17201 | 34332 | 547 |
1505470 | 1505470 | 2021-07-11 | Winnebago | Illinois | 17201 | 34298 | 545 |
1502224 | 1502224 | 2021-07-10 | Winnebago | Illinois | 17201 | 34298 | 545 |
1498978 | 1498978 | 2021-07-09 | Winnebago | Illinois | 17201 | 34298 | 545 |
1495731 | 1495731 | 2021-07-08 | Winnebago | Illinois | 17201 | 34293 | 545 |
1492485 | 1492485 | 2021-07-07 | Winnebago | Illinois | 17201 | 34271 | 545 |
1489238 | 1489238 | 2021-07-06 | Winnebago | Illinois | 17201 | 34262 | 545 |
1485991 | 1485991 | 2021-07-05 | Winnebago | Illinois | 17201 | 34231 | 544 |
1482745 | 1482745 | 2021-07-04 | Winnebago | Illinois | 17201 | 34231 | 544 |
1479498 | 1479498 | 2021-07-03 | Winnebago | Illinois | 17201 | 34231 | 544 |
1476252 | 1476252 | 2021-07-02 | Winnebago | Illinois | 17201 | 34231 | 544 |
1473006 | 1473006 | 2021-07-01 | Winnebago | Illinois | 17201 | 34205 | 541 |
1469760 | 1469760 | 2021-06-30 | Winnebago | Illinois | 17201 | 34193 | 540 |
1466515 | 1466515 | 2021-06-29 | Winnebago | Illinois | 17201 | 34182 | 540 |
1463270 | 1463270 | 2021-06-28 | Winnebago | Illinois | 17201 | 34182 | 540 |
1460025 | 1460025 | 2021-06-27 | Winnebago | Illinois | 17201 | 34160 | 538 |
1456780 | 1456780 | 2021-06-26 | Winnebago | Illinois | 17201 | 34160 | 538 |
1453535 | 1453535 | 2021-06-25 | Winnebago | Illinois | 17201 | 34160 | 538 |
1450289 | 1450289 | 2021-06-24 | Winnebago | Illinois | 17201 | 34157 | 538 |
1447044 | 1447044 | 2021-06-23 | Winnebago | Illinois | 17201 | 34146 | 538 |
1443799 | 1443799 | 2021-06-22 | Winnebago | Illinois | 17201 | 34143 | 537 |
1440554 | 1440554 | 2021-06-21 | Winnebago | Illinois | 17201 | 34140 | 537 |
1437307 | 1437307 | 2021-06-20 | Winnebago | Illinois | 17201 | 34106 | 536 |
1434060 | 1434060 | 2021-06-19 | Winnebago | Illinois | 17201 | 34106 | 536 |
1430814 | 1430814 | 2021-06-18 | Winnebago | Illinois | 17201 | 34106 | 536 |
1427569 | 1427569 | 2021-06-17 | Winnebago | Illinois | 17201 | 34096 | 534 |
1424324 | 1424324 | 2021-06-16 | Winnebago | Illinois | 17201 | 34083 | 533 |
1421076 | 1421076 | 2021-06-15 | Winnebago | Illinois | 17201 | 34070 | 531 |
1417831 | 1417831 | 2021-06-14 | Winnebago | Illinois | 17201 | 34064 | 531 |
1414585 | 1414585 | 2021-06-13 | Winnebago | Illinois | 17201 | 34053 | 530 |
1411340 | 1411340 | 2021-06-12 | Winnebago | Illinois | 17201 | 34040 | 530 |
1408095 | 1408095 | 2021-06-11 | Winnebago | Illinois | 17201 | 34022 | 530 |
1404849 | 1404849 | 2021-06-10 | Winnebago | Illinois | 17201 | 34010 | 530 |
1401604 | 1401604 | 2021-06-09 | Winnebago | Illinois | 17201 | 33993 | 530 |
1398359 | 1398359 | 2021-06-08 | Winnebago | Illinois | 17201 | 33991 | 529 |
1395112 | 1395112 | 2021-06-07 | Winnebago | Illinois | 17201 | 33984 | 529 |
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);