ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where county = "Greene" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1794502 | 1794502 | 2021-10-08 | Greene | Illinois | 17061 | 2033 | 53 |
1791254 | 1791254 | 2021-10-07 | Greene | Illinois | 17061 | 2026 | 53 |
1788005 | 1788005 | 2021-10-06 | Greene | Illinois | 17061 | 2021 | 53 |
1784756 | 1784756 | 2021-10-05 | Greene | Illinois | 17061 | 2021 | 53 |
1781507 | 1781507 | 2021-10-04 | Greene | Illinois | 17061 | 2020 | 53 |
1778257 | 1778257 | 2021-10-03 | Greene | Illinois | 17061 | 2018 | 53 |
1775007 | 1775007 | 2021-10-02 | Greene | Illinois | 17061 | 2018 | 53 |
1771757 | 1771757 | 2021-10-01 | Greene | Illinois | 17061 | 2018 | 53 |
1768508 | 1768508 | 2021-09-30 | Greene | Illinois | 17061 | 2018 | 52 |
1765259 | 1765259 | 2021-09-29 | Greene | Illinois | 17061 | 2014 | 52 |
1762010 | 1762010 | 2021-09-28 | Greene | Illinois | 17061 | 2011 | 52 |
1758762 | 1758762 | 2021-09-27 | Greene | Illinois | 17061 | 2009 | 52 |
1755514 | 1755514 | 2021-09-26 | Greene | Illinois | 17061 | 2009 | 52 |
1752266 | 1752266 | 2021-09-25 | Greene | Illinois | 17061 | 2009 | 52 |
1749017 | 1749017 | 2021-09-24 | Greene | Illinois | 17061 | 2009 | 52 |
1745767 | 1745767 | 2021-09-23 | Greene | Illinois | 17061 | 2009 | 52 |
1742518 | 1742518 | 2021-09-22 | Greene | Illinois | 17061 | 2007 | 52 |
1739269 | 1739269 | 2021-09-21 | Greene | Illinois | 17061 | 2003 | 52 |
1736020 | 1736020 | 2021-09-20 | Greene | Illinois | 17061 | 2002 | 52 |
1732770 | 1732770 | 2021-09-19 | Greene | Illinois | 17061 | 1993 | 52 |
1729520 | 1729520 | 2021-09-18 | Greene | Illinois | 17061 | 1993 | 52 |
1726270 | 1726270 | 2021-09-17 | Greene | Illinois | 17061 | 1993 | 52 |
1723021 | 1723021 | 2021-09-16 | Greene | Illinois | 17061 | 1989 | 51 |
1719772 | 1719772 | 2021-09-15 | Greene | Illinois | 17061 | 1977 | 51 |
1716524 | 1716524 | 2021-09-14 | Greene | Illinois | 17061 | 1962 | 50 |
1713278 | 1713278 | 2021-09-13 | Greene | Illinois | 17061 | 1945 | 50 |
1710031 | 1710031 | 2021-09-12 | Greene | Illinois | 17061 | 1929 | 50 |
1706784 | 1706784 | 2021-09-11 | Greene | Illinois | 17061 | 1929 | 50 |
1703536 | 1703536 | 2021-09-10 | Greene | Illinois | 17061 | 1929 | 50 |
1700286 | 1700286 | 2021-09-09 | Greene | Illinois | 17061 | 1917 | 50 |
1697037 | 1697037 | 2021-09-08 | Greene | Illinois | 17061 | 1906 | 49 |
1693789 | 1693789 | 2021-09-07 | Greene | Illinois | 17061 | 1899 | 49 |
1690540 | 1690540 | 2021-09-06 | Greene | Illinois | 17061 | 1876 | 49 |
1687290 | 1687290 | 2021-09-05 | Greene | Illinois | 17061 | 1876 | 49 |
1684040 | 1684040 | 2021-09-04 | Greene | Illinois | 17061 | 1876 | 49 |
1680789 | 1680789 | 2021-09-03 | Greene | Illinois | 17061 | 1876 | 49 |
1677541 | 1677541 | 2021-09-02 | Greene | Illinois | 17061 | 1865 | 49 |
1674294 | 1674294 | 2021-09-01 | Greene | Illinois | 17061 | 1852 | 49 |
1671045 | 1671045 | 2021-08-31 | Greene | Illinois | 17061 | 1840 | 49 |
1667798 | 1667798 | 2021-08-30 | Greene | Illinois | 17061 | 1828 | 49 |
1664551 | 1664551 | 2021-08-29 | Greene | Illinois | 17061 | 1799 | 48 |
1661303 | 1661303 | 2021-08-28 | Greene | Illinois | 17061 | 1799 | 48 |
1658055 | 1658055 | 2021-08-27 | Greene | Illinois | 17061 | 1799 | 48 |
1654807 | 1654807 | 2021-08-26 | Greene | Illinois | 17061 | 1775 | 48 |
1651560 | 1651560 | 2021-08-25 | Greene | Illinois | 17061 | 1757 | 48 |
1648311 | 1648311 | 2021-08-24 | Greene | Illinois | 17061 | 1746 | 48 |
1645063 | 1645063 | 2021-08-23 | Greene | Illinois | 17061 | 1737 | 48 |
1641814 | 1641814 | 2021-08-22 | Greene | Illinois | 17061 | 1725 | 48 |
1638564 | 1638564 | 2021-08-21 | Greene | Illinois | 17061 | 1725 | 48 |
1635314 | 1635314 | 2021-08-20 | Greene | Illinois | 17061 | 1725 | 48 |
1632064 | 1632064 | 2021-08-19 | Greene | Illinois | 17061 | 1709 | 48 |
1628817 | 1628817 | 2021-08-18 | Greene | Illinois | 17061 | 1702 | 48 |
1625570 | 1625570 | 2021-08-17 | Greene | Illinois | 17061 | 1685 | 48 |
1622323 | 1622323 | 2021-08-16 | Greene | Illinois | 17061 | 1672 | 48 |
1619076 | 1619076 | 2021-08-15 | Greene | Illinois | 17061 | 1651 | 48 |
1615828 | 1615828 | 2021-08-14 | Greene | Illinois | 17061 | 1651 | 48 |
1612579 | 1612579 | 2021-08-13 | Greene | Illinois | 17061 | 1651 | 48 |
1609331 | 1609331 | 2021-08-12 | Greene | Illinois | 17061 | 1651 | 48 |
1606082 | 1606082 | 2021-08-11 | Greene | Illinois | 17061 | 1647 | 48 |
1602833 | 1602833 | 2021-08-10 | Greene | Illinois | 17061 | 1637 | 48 |
1599584 | 1599584 | 2021-08-09 | Greene | Illinois | 17061 | 1625 | 48 |
1596336 | 1596336 | 2021-08-08 | Greene | Illinois | 17061 | 1602 | 48 |
1593087 | 1593087 | 2021-08-07 | Greene | Illinois | 17061 | 1602 | 48 |
1589838 | 1589838 | 2021-08-06 | Greene | Illinois | 17061 | 1602 | 48 |
1586589 | 1586589 | 2021-08-05 | Greene | Illinois | 17061 | 1590 | 47 |
1583339 | 1583339 | 2021-08-04 | Greene | Illinois | 17061 | 1588 | 47 |
1580089 | 1580089 | 2021-08-03 | Greene | Illinois | 17061 | 1580 | 47 |
1576840 | 1576840 | 2021-08-02 | Greene | Illinois | 17061 | 1568 | 47 |
1573592 | 1573592 | 2021-08-01 | Greene | Illinois | 17061 | 1557 | 47 |
1570344 | 1570344 | 2021-07-31 | Greene | Illinois | 17061 | 1557 | 47 |
1567096 | 1567096 | 2021-07-30 | Greene | Illinois | 17061 | 1557 | 47 |
1563848 | 1563848 | 2021-07-29 | Greene | Illinois | 17061 | 1548 | 47 |
1560600 | 1560600 | 2021-07-28 | Greene | Illinois | 17061 | 1535 | 47 |
1557353 | 1557353 | 2021-07-27 | Greene | Illinois | 17061 | 1528 | 47 |
1554106 | 1554106 | 2021-07-26 | Greene | Illinois | 17061 | 1526 | 47 |
1550859 | 1550859 | 2021-07-25 | Greene | Illinois | 17061 | 1514 | 47 |
1547612 | 1547612 | 2021-07-24 | Greene | Illinois | 17061 | 1514 | 47 |
1544365 | 1544365 | 2021-07-23 | Greene | Illinois | 17061 | 1514 | 47 |
1541117 | 1541117 | 2021-07-22 | Greene | Illinois | 17061 | 1507 | 47 |
1537870 | 1537870 | 2021-07-21 | Greene | Illinois | 17061 | 1494 | 47 |
1534622 | 1534622 | 2021-07-20 | Greene | Illinois | 17061 | 1492 | 47 |
1531375 | 1531375 | 2021-07-19 | Greene | Illinois | 17061 | 1489 | 47 |
1528128 | 1528128 | 2021-07-18 | Greene | Illinois | 17061 | 1484 | 47 |
1524881 | 1524881 | 2021-07-17 | Greene | Illinois | 17061 | 1484 | 47 |
1521633 | 1521633 | 2021-07-16 | Greene | Illinois | 17061 | 1484 | 47 |
1518385 | 1518385 | 2021-07-15 | Greene | Illinois | 17061 | 1478 | 47 |
1515138 | 1515138 | 2021-07-14 | Greene | Illinois | 17061 | 1474 | 47 |
1511892 | 1511892 | 2021-07-13 | Greene | Illinois | 17061 | 1470 | 47 |
1508645 | 1508645 | 2021-07-12 | Greene | Illinois | 17061 | 1465 | 47 |
1505399 | 1505399 | 2021-07-11 | Greene | Illinois | 17061 | 1461 | 47 |
1502153 | 1502153 | 2021-07-10 | Greene | Illinois | 17061 | 1461 | 47 |
1498907 | 1498907 | 2021-07-09 | Greene | Illinois | 17061 | 1461 | 47 |
1495660 | 1495660 | 2021-07-08 | Greene | Illinois | 17061 | 1460 | 47 |
1492414 | 1492414 | 2021-07-07 | Greene | Illinois | 17061 | 1459 | 47 |
1489167 | 1489167 | 2021-07-06 | Greene | Illinois | 17061 | 1460 | 47 |
1485920 | 1485920 | 2021-07-05 | Greene | Illinois | 17061 | 1457 | 47 |
1482674 | 1482674 | 2021-07-04 | Greene | Illinois | 17061 | 1457 | 47 |
1479427 | 1479427 | 2021-07-03 | Greene | Illinois | 17061 | 1457 | 47 |
1476181 | 1476181 | 2021-07-02 | Greene | Illinois | 17061 | 1457 | 47 |
1472935 | 1472935 | 2021-07-01 | Greene | Illinois | 17061 | 1457 | 47 |
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);