ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39153 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812255 | 1812255 | 2021-10-13 | Summit | Ohio | 39153 | 60299 | 1088 |
1809006 | 1809006 | 2021-10-12 | Summit | Ohio | 39153 | 60084 | 1088 |
1805756 | 1805756 | 2021-10-11 | Summit | Ohio | 39153 | 59900 | 1083 |
1802506 | 1802506 | 2021-10-10 | Summit | Ohio | 39153 | 59760 | 1083 |
1799257 | 1799257 | 2021-10-09 | Summit | Ohio | 39153 | 59515 | 1083 |
1796008 | 1796008 | 2021-10-08 | Summit | Ohio | 39153 | 59401 | 1083 |
1792759 | 1792759 | 2021-10-07 | Summit | Ohio | 39153 | 59139 | 1075 |
1789510 | 1789510 | 2021-10-06 | Summit | Ohio | 39153 | 58914 | 1075 |
1786262 | 1786262 | 2021-10-05 | Summit | Ohio | 39153 | 58699 | 1075 |
1783013 | 1783013 | 2021-10-04 | Summit | Ohio | 39153 | 58506 | 1067 |
1779764 | 1779764 | 2021-10-03 | Summit | Ohio | 39153 | 58348 | 1067 |
1776514 | 1776514 | 2021-10-02 | Summit | Ohio | 39153 | 58208 | 1067 |
1773264 | 1773264 | 2021-10-01 | Summit | Ohio | 39153 | 57993 | 1067 |
1770014 | 1770014 | 2021-09-30 | Summit | Ohio | 39153 | 57761 | 1061 |
1766765 | 1766765 | 2021-09-29 | Summit | Ohio | 39153 | 57562 | 1061 |
1763516 | 1763516 | 2021-09-28 | Summit | Ohio | 39153 | 57360 | 1061 |
1760267 | 1760267 | 2021-09-27 | Summit | Ohio | 39153 | 57166 | 1051 |
1757019 | 1757019 | 2021-09-26 | Summit | Ohio | 39153 | 56998 | 1051 |
1753771 | 1753771 | 2021-09-25 | Summit | Ohio | 39153 | 56845 | 1051 |
1750523 | 1750523 | 2021-09-24 | Summit | Ohio | 39153 | 56639 | 1051 |
1747273 | 1747273 | 2021-09-23 | Summit | Ohio | 39153 | 56442 | 1047 |
1744024 | 1744024 | 2021-09-22 | Summit | Ohio | 39153 | 56209 | 1047 |
1740775 | 1740775 | 2021-09-21 | Summit | Ohio | 39153 | 56008 | 1047 |
1737526 | 1737526 | 2021-09-20 | Summit | Ohio | 39153 | 55828 | 1045 |
1734276 | 1734276 | 2021-09-19 | Summit | Ohio | 39153 | 55657 | 1045 |
1731026 | 1731026 | 2021-09-18 | Summit | Ohio | 39153 | 55514 | 1045 |
1727776 | 1727776 | 2021-09-17 | Summit | Ohio | 39153 | 55309 | 1045 |
1724527 | 1724527 | 2021-09-16 | Summit | Ohio | 39153 | 55073 | 1041 |
1721278 | 1721278 | 2021-09-15 | Summit | Ohio | 39153 | 54853 | 1041 |
1718030 | 1718030 | 2021-09-14 | Summit | Ohio | 39153 | 54635 | 1041 |
1714782 | 1714782 | 2021-09-13 | Summit | Ohio | 39153 | 54415 | 1039 |
1711536 | 1711536 | 2021-09-12 | Summit | Ohio | 39153 | 54281 | 1039 |
1708289 | 1708289 | 2021-09-11 | Summit | Ohio | 39153 | 54140 | 1039 |
1705042 | 1705042 | 2021-09-10 | Summit | Ohio | 39153 | 53899 | 1039 |
1701792 | 1701792 | 2021-09-09 | Summit | Ohio | 39153 | 53671 | 1037 |
1698543 | 1698543 | 2021-09-08 | Summit | Ohio | 39153 | 53451 | 1037 |
1695295 | 1695295 | 2021-09-07 | Summit | Ohio | 39153 | 53261 | 1037 |
1692047 | 1692047 | 2021-09-06 | Summit | Ohio | 39153 | 53049 | 1035 |
1688798 | 1688798 | 2021-09-05 | Summit | Ohio | 39153 | 52944 | 1035 |
1685548 | 1685548 | 2021-09-04 | Summit | Ohio | 39153 | 52809 | 1035 |
1682297 | 1682297 | 2021-09-03 | Summit | Ohio | 39153 | 52600 | 1035 |
1679047 | 1679047 | 2021-09-02 | Summit | Ohio | 39153 | 52429 | 1033 |
1675799 | 1675799 | 2021-09-01 | Summit | Ohio | 39153 | 52260 | 1033 |
1672552 | 1672552 | 2021-08-31 | Summit | Ohio | 39153 | 52099 | 1033 |
1669304 | 1669304 | 2021-08-30 | Summit | Ohio | 39153 | 51930 | 1029 |
1666057 | 1666057 | 2021-08-29 | Summit | Ohio | 39153 | 51791 | 1029 |
1662809 | 1662809 | 2021-08-28 | Summit | Ohio | 39153 | 51666 | 1029 |
1659561 | 1659561 | 2021-08-27 | Summit | Ohio | 39153 | 51483 | 1029 |
1656312 | 1656312 | 2021-08-26 | Summit | Ohio | 39153 | 51326 | 1027 |
1653065 | 1653065 | 2021-08-25 | Summit | Ohio | 39153 | 51146 | 1027 |
1649818 | 1649818 | 2021-08-24 | Summit | Ohio | 39153 | 51025 | 1027 |
1646569 | 1646569 | 2021-08-23 | Summit | Ohio | 39153 | 50908 | 1026 |
1643320 | 1643320 | 2021-08-22 | Summit | Ohio | 39153 | 50822 | 1026 |
1640070 | 1640070 | 2021-08-21 | Summit | Ohio | 39153 | 50736 | 1026 |
1636820 | 1636820 | 2021-08-20 | Summit | Ohio | 39153 | 50631 | 1026 |
1633570 | 1633570 | 2021-08-19 | Summit | Ohio | 39153 | 50535 | 1023 |
1630323 | 1630323 | 2021-08-18 | Summit | Ohio | 39153 | 50416 | 1023 |
1627076 | 1627076 | 2021-08-17 | Summit | Ohio | 39153 | 50326 | 1023 |
1623829 | 1623829 | 2021-08-16 | Summit | Ohio | 39153 | 50232 | 1022 |
1620582 | 1620582 | 2021-08-15 | Summit | Ohio | 39153 | 50171 | 1022 |
1617334 | 1617334 | 2021-08-14 | Summit | Ohio | 39153 | 50110 | 1022 |
1614086 | 1614086 | 2021-08-13 | Summit | Ohio | 39153 | 50018 | 1022 |
1610837 | 1610837 | 2021-08-12 | Summit | Ohio | 39153 | 49909 | 1021 |
1607589 | 1607589 | 2021-08-11 | Summit | Ohio | 39153 | 49797 | 1021 |
1604340 | 1604340 | 2021-08-10 | Summit | Ohio | 39153 | 49663 | 1021 |
1601091 | 1601091 | 2021-08-09 | Summit | Ohio | 39153 | 49566 | 1019 |
1597843 | 1597843 | 2021-08-08 | Summit | Ohio | 39153 | 49505 | 1019 |
1594594 | 1594594 | 2021-08-07 | Summit | Ohio | 39153 | 49458 | 1019 |
1591345 | 1591345 | 2021-08-06 | Summit | Ohio | 39153 | 49365 | 1019 |
1588096 | 1588096 | 2021-08-05 | Summit | Ohio | 39153 | 49316 | 1018 |
1584846 | 1584846 | 2021-08-04 | Summit | Ohio | 39153 | 49254 | 1018 |
1581596 | 1581596 | 2021-08-03 | Summit | Ohio | 39153 | 49189 | 1018 |
1578347 | 1578347 | 2021-08-02 | Summit | Ohio | 39153 | 49132 | 1014 |
1575099 | 1575099 | 2021-08-01 | Summit | Ohio | 39153 | 49102 | 1014 |
1571851 | 1571851 | 2021-07-31 | Summit | Ohio | 39153 | 49077 | 1014 |
1568603 | 1568603 | 2021-07-30 | Summit | Ohio | 39153 | 49027 | 1014 |
1565355 | 1565355 | 2021-07-29 | Summit | Ohio | 39153 | 48984 | 1014 |
1562107 | 1562107 | 2021-07-28 | Summit | Ohio | 39153 | 48938 | 1014 |
1558859 | 1558859 | 2021-07-27 | Summit | Ohio | 39153 | 48902 | 1014 |
1555612 | 1555612 | 2021-07-26 | Summit | Ohio | 39153 | 48858 | 1014 |
1552365 | 1552365 | 2021-07-25 | Summit | Ohio | 39153 | 48843 | 1014 |
1549118 | 1549118 | 2021-07-24 | Summit | Ohio | 39153 | 48821 | 1014 |
1545871 | 1545871 | 2021-07-23 | Summit | Ohio | 39153 | 48791 | 1014 |
1542624 | 1542624 | 2021-07-22 | Summit | Ohio | 39153 | 48773 | 1013 |
1539376 | 1539376 | 2021-07-21 | Summit | Ohio | 39153 | 48752 | 1013 |
1536129 | 1536129 | 2021-07-20 | Summit | Ohio | 39153 | 48733 | 1013 |
1532881 | 1532881 | 2021-07-19 | Summit | Ohio | 39153 | 48719 | 1013 |
1529634 | 1529634 | 2021-07-18 | Summit | Ohio | 39153 | 48699 | 1013 |
1526387 | 1526387 | 2021-07-17 | Summit | Ohio | 39153 | 48689 | 1013 |
1523140 | 1523140 | 2021-07-16 | Summit | Ohio | 39153 | 48679 | 1013 |
1519892 | 1519892 | 2021-07-15 | Summit | Ohio | 39153 | 48660 | 1011 |
1516644 | 1516644 | 2021-07-14 | Summit | Ohio | 39153 | 48641 | 1011 |
1513397 | 1513397 | 2021-07-13 | Summit | Ohio | 39153 | 48620 | 1011 |
1510151 | 1510151 | 2021-07-12 | Summit | Ohio | 39153 | 48603 | 1011 |
1506904 | 1506904 | 2021-07-11 | Summit | Ohio | 39153 | 48596 | 1011 |
1503658 | 1503658 | 2021-07-10 | Summit | Ohio | 39153 | 48592 | 1011 |
1500412 | 1500412 | 2021-07-09 | Summit | Ohio | 39153 | 48584 | 1011 |
1497166 | 1497166 | 2021-07-08 | Summit | Ohio | 39153 | 48573 | 1011 |
1493919 | 1493919 | 2021-07-07 | Summit | Ohio | 39153 | 48559 | 1011 |
1490672 | 1490672 | 2021-07-06 | Summit | Ohio | 39153 | 48546 | 1010 |
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);