ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Shelby" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812253 | 1812253 | 2021-10-13 | Shelby | Ohio | 39149 | 6318 | 109 |
1809004 | 1809004 | 2021-10-12 | Shelby | Ohio | 39149 | 6289 | 109 |
1805754 | 1805754 | 2021-10-11 | Shelby | Ohio | 39149 | 6266 | 109 |
1802504 | 1802504 | 2021-10-10 | Shelby | Ohio | 39149 | 6253 | 109 |
1799255 | 1799255 | 2021-10-09 | Shelby | Ohio | 39149 | 6242 | 109 |
1796006 | 1796006 | 2021-10-08 | Shelby | Ohio | 39149 | 6231 | 109 |
1792757 | 1792757 | 2021-10-07 | Shelby | Ohio | 39149 | 6202 | 107 |
1789508 | 1789508 | 2021-10-06 | Shelby | Ohio | 39149 | 6179 | 107 |
1786260 | 1786260 | 2021-10-05 | Shelby | Ohio | 39149 | 6138 | 107 |
1783011 | 1783011 | 2021-10-04 | Shelby | Ohio | 39149 | 6110 | 106 |
1779762 | 1779762 | 2021-10-03 | Shelby | Ohio | 39149 | 6071 | 106 |
1776512 | 1776512 | 2021-10-02 | Shelby | Ohio | 39149 | 6058 | 106 |
1773262 | 1773262 | 2021-10-01 | Shelby | Ohio | 39149 | 6023 | 106 |
1770012 | 1770012 | 2021-09-30 | Shelby | Ohio | 39149 | 6002 | 105 |
1766763 | 1766763 | 2021-09-29 | Shelby | Ohio | 39149 | 5973 | 105 |
1763514 | 1763514 | 2021-09-28 | Shelby | Ohio | 39149 | 5935 | 105 |
1760265 | 1760265 | 2021-09-27 | Shelby | Ohio | 39149 | 5867 | 104 |
1757017 | 1757017 | 2021-09-26 | Shelby | Ohio | 39149 | 5845 | 104 |
1753769 | 1753769 | 2021-09-25 | Shelby | Ohio | 39149 | 5820 | 104 |
1750521 | 1750521 | 2021-09-24 | Shelby | Ohio | 39149 | 5796 | 104 |
1747271 | 1747271 | 2021-09-23 | Shelby | Ohio | 39149 | 5774 | 101 |
1744022 | 1744022 | 2021-09-22 | Shelby | Ohio | 39149 | 5727 | 101 |
1740773 | 1740773 | 2021-09-21 | Shelby | Ohio | 39149 | 5704 | 101 |
1737524 | 1737524 | 2021-09-20 | Shelby | Ohio | 39149 | 5681 | 101 |
1734274 | 1734274 | 2021-09-19 | Shelby | Ohio | 39149 | 5668 | 101 |
1731024 | 1731024 | 2021-09-18 | Shelby | Ohio | 39149 | 5654 | 101 |
1727774 | 1727774 | 2021-09-17 | Shelby | Ohio | 39149 | 5628 | 101 |
1724525 | 1724525 | 2021-09-16 | Shelby | Ohio | 39149 | 5592 | 99 |
1721276 | 1721276 | 2021-09-15 | Shelby | Ohio | 39149 | 5557 | 99 |
1718028 | 1718028 | 2021-09-14 | Shelby | Ohio | 39149 | 5533 | 99 |
1714780 | 1714780 | 2021-09-13 | Shelby | Ohio | 39149 | 5515 | 98 |
1711534 | 1711534 | 2021-09-12 | Shelby | Ohio | 39149 | 5489 | 98 |
1708287 | 1708287 | 2021-09-11 | Shelby | Ohio | 39149 | 5478 | 98 |
1705040 | 1705040 | 2021-09-10 | Shelby | Ohio | 39149 | 5440 | 98 |
1701790 | 1701790 | 2021-09-09 | Shelby | Ohio | 39149 | 5413 | 98 |
1698541 | 1698541 | 2021-09-08 | Shelby | Ohio | 39149 | 5386 | 98 |
1695293 | 1695293 | 2021-09-07 | Shelby | Ohio | 39149 | 5361 | 98 |
1692045 | 1692045 | 2021-09-06 | Shelby | Ohio | 39149 | 5349 | 98 |
1688796 | 1688796 | 2021-09-05 | Shelby | Ohio | 39149 | 5347 | 98 |
1685546 | 1685546 | 2021-09-04 | Shelby | Ohio | 39149 | 5336 | 98 |
1682295 | 1682295 | 2021-09-03 | Shelby | Ohio | 39149 | 5322 | 98 |
1679045 | 1679045 | 2021-09-02 | Shelby | Ohio | 39149 | 5299 | 98 |
1675797 | 1675797 | 2021-09-01 | Shelby | Ohio | 39149 | 5272 | 98 |
1672550 | 1672550 | 2021-08-31 | Shelby | Ohio | 39149 | 5256 | 98 |
1669302 | 1669302 | 2021-08-30 | Shelby | Ohio | 39149 | 5225 | 98 |
1666055 | 1666055 | 2021-08-29 | Shelby | Ohio | 39149 | 5215 | 98 |
1662807 | 1662807 | 2021-08-28 | Shelby | Ohio | 39149 | 5202 | 98 |
1659559 | 1659559 | 2021-08-27 | Shelby | Ohio | 39149 | 5189 | 98 |
1656310 | 1656310 | 2021-08-26 | Shelby | Ohio | 39149 | 5171 | 98 |
1653063 | 1653063 | 2021-08-25 | Shelby | Ohio | 39149 | 5137 | 98 |
1649816 | 1649816 | 2021-08-24 | Shelby | Ohio | 39149 | 5122 | 98 |
1646567 | 1646567 | 2021-08-23 | Shelby | Ohio | 39149 | 5114 | 98 |
1643318 | 1643318 | 2021-08-22 | Shelby | Ohio | 39149 | 5101 | 98 |
1640068 | 1640068 | 2021-08-21 | Shelby | Ohio | 39149 | 5092 | 98 |
1636818 | 1636818 | 2021-08-20 | Shelby | Ohio | 39149 | 5081 | 98 |
1633568 | 1633568 | 2021-08-19 | Shelby | Ohio | 39149 | 5063 | 98 |
1630321 | 1630321 | 2021-08-18 | Shelby | Ohio | 39149 | 5044 | 98 |
1627074 | 1627074 | 2021-08-17 | Shelby | Ohio | 39149 | 5024 | 98 |
1623827 | 1623827 | 2021-08-16 | Shelby | Ohio | 39149 | 5009 | 98 |
1620580 | 1620580 | 2021-08-15 | Shelby | Ohio | 39149 | 5002 | 98 |
1617332 | 1617332 | 2021-08-14 | Shelby | Ohio | 39149 | 4996 | 98 |
1614084 | 1614084 | 2021-08-13 | Shelby | Ohio | 39149 | 4982 | 98 |
1610835 | 1610835 | 2021-08-12 | Shelby | Ohio | 39149 | 4981 | 98 |
1607587 | 1607587 | 2021-08-11 | Shelby | Ohio | 39149 | 4972 | 98 |
1604338 | 1604338 | 2021-08-10 | Shelby | Ohio | 39149 | 4953 | 98 |
1601089 | 1601089 | 2021-08-09 | Shelby | Ohio | 39149 | 4941 | 98 |
1597841 | 1597841 | 2021-08-08 | Shelby | Ohio | 39149 | 4932 | 98 |
1594592 | 1594592 | 2021-08-07 | Shelby | Ohio | 39149 | 4928 | 98 |
1591343 | 1591343 | 2021-08-06 | Shelby | Ohio | 39149 | 4912 | 98 |
1588094 | 1588094 | 2021-08-05 | Shelby | Ohio | 39149 | 4902 | 98 |
1584844 | 1584844 | 2021-08-04 | Shelby | Ohio | 39149 | 4887 | 98 |
1581594 | 1581594 | 2021-08-03 | Shelby | Ohio | 39149 | 4877 | 98 |
1578345 | 1578345 | 2021-08-02 | Shelby | Ohio | 39149 | 4867 | 97 |
1575097 | 1575097 | 2021-08-01 | Shelby | Ohio | 39149 | 4860 | 97 |
1571849 | 1571849 | 2021-07-31 | Shelby | Ohio | 39149 | 4856 | 97 |
1568601 | 1568601 | 2021-07-30 | Shelby | Ohio | 39149 | 4850 | 97 |
1565353 | 1565353 | 2021-07-29 | Shelby | Ohio | 39149 | 4846 | 97 |
1562105 | 1562105 | 2021-07-28 | Shelby | Ohio | 39149 | 4843 | 97 |
1558857 | 1558857 | 2021-07-27 | Shelby | Ohio | 39149 | 4827 | 97 |
1555610 | 1555610 | 2021-07-26 | Shelby | Ohio | 39149 | 4812 | 97 |
1552363 | 1552363 | 2021-07-25 | Shelby | Ohio | 39149 | 4809 | 97 |
1549116 | 1549116 | 2021-07-24 | Shelby | Ohio | 39149 | 4805 | 97 |
1545869 | 1545869 | 2021-07-23 | Shelby | Ohio | 39149 | 4804 | 97 |
1542622 | 1542622 | 2021-07-22 | Shelby | Ohio | 39149 | 4800 | 97 |
1539374 | 1539374 | 2021-07-21 | Shelby | Ohio | 39149 | 4798 | 97 |
1536127 | 1536127 | 2021-07-20 | Shelby | Ohio | 39149 | 4797 | 97 |
1532879 | 1532879 | 2021-07-19 | Shelby | Ohio | 39149 | 4795 | 97 |
1529632 | 1529632 | 2021-07-18 | Shelby | Ohio | 39149 | 4795 | 97 |
1526385 | 1526385 | 2021-07-17 | Shelby | Ohio | 39149 | 4795 | 97 |
1523138 | 1523138 | 2021-07-16 | Shelby | Ohio | 39149 | 4794 | 97 |
1519890 | 1519890 | 2021-07-15 | Shelby | Ohio | 39149 | 4793 | 97 |
1516642 | 1516642 | 2021-07-14 | Shelby | Ohio | 39149 | 4792 | 97 |
1513395 | 1513395 | 2021-07-13 | Shelby | Ohio | 39149 | 4791 | 97 |
1510149 | 1510149 | 2021-07-12 | Shelby | Ohio | 39149 | 4790 | 97 |
1506902 | 1506902 | 2021-07-11 | Shelby | Ohio | 39149 | 4787 | 97 |
1503656 | 1503656 | 2021-07-10 | Shelby | Ohio | 39149 | 4787 | 97 |
1500410 | 1500410 | 2021-07-09 | Shelby | Ohio | 39149 | 4787 | 97 |
1497164 | 1497164 | 2021-07-08 | Shelby | Ohio | 39149 | 4786 | 97 |
1493917 | 1493917 | 2021-07-07 | Shelby | Ohio | 39149 | 4786 | 97 |
1490670 | 1490670 | 2021-07-06 | Shelby | Ohio | 39149 | 4784 | 96 |
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);