ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Union" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718033 | 1718033 | 2021-09-14 | Union | Ohio | 39159 | 7004 | 49 |
1714785 | 1714785 | 2021-09-13 | Union | Ohio | 39159 | 6960 | 49 |
1711539 | 1711539 | 2021-09-12 | Union | Ohio | 39159 | 6934 | 49 |
1708292 | 1708292 | 2021-09-11 | Union | Ohio | 39159 | 6915 | 49 |
1705045 | 1705045 | 2021-09-10 | Union | Ohio | 39159 | 6877 | 49 |
1701795 | 1701795 | 2021-09-09 | Union | Ohio | 39159 | 6819 | 49 |
1698546 | 1698546 | 2021-09-08 | Union | Ohio | 39159 | 6753 | 49 |
1695298 | 1695298 | 2021-09-07 | Union | Ohio | 39159 | 6689 | 49 |
1692050 | 1692050 | 2021-09-06 | Union | Ohio | 39159 | 6674 | 49 |
1688801 | 1688801 | 2021-09-05 | Union | Ohio | 39159 | 6655 | 49 |
1685551 | 1685551 | 2021-09-04 | Union | Ohio | 39159 | 6625 | 49 |
1682300 | 1682300 | 2021-09-03 | Union | Ohio | 39159 | 6581 | 49 |
1679050 | 1679050 | 2021-09-02 | Union | Ohio | 39159 | 6526 | 49 |
1675802 | 1675802 | 2021-09-01 | Union | Ohio | 39159 | 6482 | 49 |
1672555 | 1672555 | 2021-08-31 | Union | Ohio | 39159 | 6423 | 49 |
1669307 | 1669307 | 2021-08-30 | Union | Ohio | 39159 | 6378 | 49 |
1666060 | 1666060 | 2021-08-29 | Union | Ohio | 39159 | 6366 | 49 |
1662812 | 1662812 | 2021-08-28 | Union | Ohio | 39159 | 6346 | 49 |
1659564 | 1659564 | 2021-08-27 | Union | Ohio | 39159 | 6314 | 49 |
1656315 | 1656315 | 2021-08-26 | Union | Ohio | 39159 | 6289 | 49 |
1653068 | 1653068 | 2021-08-25 | Union | Ohio | 39159 | 6249 | 49 |
1649821 | 1649821 | 2021-08-24 | Union | Ohio | 39159 | 6223 | 49 |
1646572 | 1646572 | 2021-08-23 | Union | Ohio | 39159 | 6185 | 49 |
1643323 | 1643323 | 2021-08-22 | Union | Ohio | 39159 | 6178 | 49 |
1640073 | 1640073 | 2021-08-21 | Union | Ohio | 39159 | 6170 | 49 |
1636823 | 1636823 | 2021-08-20 | Union | Ohio | 39159 | 6149 | 49 |
1633573 | 1633573 | 2021-08-19 | Union | Ohio | 39159 | 6137 | 49 |
1630326 | 1630326 | 2021-08-18 | Union | Ohio | 39159 | 6119 | 49 |
1627079 | 1627079 | 2021-08-17 | Union | Ohio | 39159 | 6105 | 49 |
1623832 | 1623832 | 2021-08-16 | Union | Ohio | 39159 | 6090 | 49 |
1620585 | 1620585 | 2021-08-15 | Union | Ohio | 39159 | 6072 | 49 |
1617337 | 1617337 | 2021-08-14 | Union | Ohio | 39159 | 6065 | 49 |
1614089 | 1614089 | 2021-08-13 | Union | Ohio | 39159 | 6059 | 49 |
1610840 | 1610840 | 2021-08-12 | Union | Ohio | 39159 | 6048 | 49 |
1607592 | 1607592 | 2021-08-11 | Union | Ohio | 39159 | 6031 | 49 |
1604343 | 1604343 | 2021-08-10 | Union | Ohio | 39159 | 6013 | 49 |
1601094 | 1601094 | 2021-08-09 | Union | Ohio | 39159 | 5998 | 49 |
1597846 | 1597846 | 2021-08-08 | Union | Ohio | 39159 | 5996 | 49 |
1594597 | 1594597 | 2021-08-07 | Union | Ohio | 39159 | 5992 | 49 |
1591348 | 1591348 | 2021-08-06 | Union | Ohio | 39159 | 5984 | 49 |
1588099 | 1588099 | 2021-08-05 | Union | Ohio | 39159 | 5973 | 49 |
1584849 | 1584849 | 2021-08-04 | Union | Ohio | 39159 | 5960 | 49 |
1581599 | 1581599 | 2021-08-03 | Union | Ohio | 39159 | 5951 | 49 |
1578350 | 1578350 | 2021-08-02 | Union | Ohio | 39159 | 5941 | 49 |
1575102 | 1575102 | 2021-08-01 | Union | Ohio | 39159 | 5934 | 49 |
1571854 | 1571854 | 2021-07-31 | Union | Ohio | 39159 | 5934 | 49 |
1568606 | 1568606 | 2021-07-30 | Union | Ohio | 39159 | 5927 | 49 |
1565358 | 1565358 | 2021-07-29 | Union | Ohio | 39159 | 5924 | 49 |
1562110 | 1562110 | 2021-07-28 | Union | Ohio | 39159 | 5916 | 49 |
1558862 | 1558862 | 2021-07-27 | Union | Ohio | 39159 | 5909 | 49 |
1555615 | 1555615 | 2021-07-26 | Union | Ohio | 39159 | 5904 | 49 |
1552368 | 1552368 | 2021-07-25 | Union | Ohio | 39159 | 5904 | 49 |
1549121 | 1549121 | 2021-07-24 | Union | Ohio | 39159 | 5903 | 49 |
1545874 | 1545874 | 2021-07-23 | Union | Ohio | 39159 | 5900 | 49 |
1542627 | 1542627 | 2021-07-22 | Union | Ohio | 39159 | 5895 | 49 |
1539379 | 1539379 | 2021-07-21 | Union | Ohio | 39159 | 5887 | 49 |
1536132 | 1536132 | 2021-07-20 | Union | Ohio | 39159 | 5886 | 49 |
1532884 | 1532884 | 2021-07-19 | Union | Ohio | 39159 | 5883 | 49 |
1529637 | 1529637 | 2021-07-18 | Union | Ohio | 39159 | 5882 | 49 |
1526390 | 1526390 | 2021-07-17 | Union | Ohio | 39159 | 5882 | 49 |
1523143 | 1523143 | 2021-07-16 | Union | Ohio | 39159 | 5880 | 49 |
1519895 | 1519895 | 2021-07-15 | Union | Ohio | 39159 | 5880 | 49 |
1516647 | 1516647 | 2021-07-14 | Union | Ohio | 39159 | 5878 | 49 |
1513400 | 1513400 | 2021-07-13 | Union | Ohio | 39159 | 5875 | 49 |
1510154 | 1510154 | 2021-07-12 | Union | Ohio | 39159 | 5870 | 49 |
1506907 | 1506907 | 2021-07-11 | Union | Ohio | 39159 | 5868 | 49 |
1503661 | 1503661 | 2021-07-10 | Union | Ohio | 39159 | 5867 | 49 |
1500415 | 1500415 | 2021-07-09 | Union | Ohio | 39159 | 5867 | 49 |
1497169 | 1497169 | 2021-07-08 | Union | Ohio | 39159 | 5866 | 49 |
1493922 | 1493922 | 2021-07-07 | Union | Ohio | 39159 | 5862 | 49 |
1490675 | 1490675 | 2021-07-06 | Union | Ohio | 39159 | 5859 | 49 |
1487428 | 1487428 | 2021-07-05 | Union | Ohio | 39159 | 5859 | 49 |
1484181 | 1484181 | 2021-07-04 | Union | Ohio | 39159 | 5859 | 49 |
1480935 | 1480935 | 2021-07-03 | Union | Ohio | 39159 | 5859 | 49 |
1477688 | 1477688 | 2021-07-02 | Union | Ohio | 39159 | 5856 | 49 |
1474442 | 1474442 | 2021-07-01 | Union | Ohio | 39159 | 5856 | 49 |
1471196 | 1471196 | 2021-06-30 | Union | Ohio | 39159 | 5855 | 49 |
1467951 | 1467951 | 2021-06-29 | Union | Ohio | 39159 | 5854 | 49 |
1464706 | 1464706 | 2021-06-28 | Union | Ohio | 39159 | 5853 | 49 |
1461461 | 1461461 | 2021-06-27 | Union | Ohio | 39159 | 5853 | 49 |
1458216 | 1458216 | 2021-06-26 | Union | Ohio | 39159 | 5853 | 49 |
1454971 | 1454971 | 2021-06-25 | Union | Ohio | 39159 | 5852 | 49 |
1451726 | 1451726 | 2021-06-24 | Union | Ohio | 39159 | 5850 | 49 |
1448480 | 1448480 | 2021-06-23 | Union | Ohio | 39159 | 5850 | 49 |
1445235 | 1445235 | 2021-06-22 | Union | Ohio | 39159 | 5848 | 49 |
1441990 | 1441990 | 2021-06-21 | Union | Ohio | 39159 | 5846 | 49 |
1438745 | 1438745 | 2021-06-20 | Union | Ohio | 39159 | 5846 | 49 |
1435498 | 1435498 | 2021-06-19 | Union | Ohio | 39159 | 5845 | 49 |
1432251 | 1432251 | 2021-06-18 | Union | Ohio | 39159 | 5846 | 49 |
1429005 | 1429005 | 2021-06-17 | Union | Ohio | 39159 | 5845 | 49 |
1425760 | 1425760 | 2021-06-16 | Union | Ohio | 39159 | 5844 | 49 |
1422513 | 1422513 | 2021-06-15 | Union | Ohio | 39159 | 5838 | 49 |
1419267 | 1419267 | 2021-06-14 | Union | Ohio | 39159 | 5838 | 49 |
1416022 | 1416022 | 2021-06-13 | Union | Ohio | 39159 | 5838 | 49 |
1412776 | 1412776 | 2021-06-12 | Union | Ohio | 39159 | 5835 | 49 |
1409531 | 1409531 | 2021-06-11 | Union | Ohio | 39159 | 5834 | 49 |
1406286 | 1406286 | 2021-06-10 | Union | Ohio | 39159 | 5833 | 49 |
1403040 | 1403040 | 2021-06-09 | Union | Ohio | 39159 | 5832 | 49 |
1399795 | 1399795 | 2021-06-08 | Union | Ohio | 39159 | 5832 | 49 |
1396550 | 1396550 | 2021-06-07 | Union | Ohio | 39159 | 5831 | 49 |
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);