ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Summit" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1487425 | 1487425 | 2021-07-05 | Summit | Ohio | 39153 | 48541 | 1010 |
1484178 | 1484178 | 2021-07-04 | Summit | Ohio | 39153 | 48533 | 1010 |
1480932 | 1480932 | 2021-07-03 | Summit | Ohio | 39153 | 48533 | 1010 |
1477685 | 1477685 | 2021-07-02 | Summit | Ohio | 39153 | 48526 | 1010 |
1474439 | 1474439 | 2021-07-01 | Summit | Ohio | 39153 | 48520 | 1008 |
1471193 | 1471193 | 2021-06-30 | Summit | Ohio | 39153 | 48510 | 1008 |
1467948 | 1467948 | 2021-06-29 | Summit | Ohio | 39153 | 48503 | 1008 |
1464703 | 1464703 | 2021-06-28 | Summit | Ohio | 39153 | 48497 | 1007 |
1461458 | 1461458 | 2021-06-27 | Summit | Ohio | 39153 | 48491 | 1007 |
1458213 | 1458213 | 2021-06-26 | Summit | Ohio | 39153 | 48487 | 1007 |
1454968 | 1454968 | 2021-06-25 | Summit | Ohio | 39153 | 48477 | 1007 |
1451723 | 1451723 | 2021-06-24 | Summit | Ohio | 39153 | 48463 | 1006 |
1448477 | 1448477 | 2021-06-23 | Summit | Ohio | 39153 | 48455 | 1006 |
1445232 | 1445232 | 2021-06-22 | Summit | Ohio | 39153 | 48443 | 1006 |
1441987 | 1441987 | 2021-06-21 | Summit | Ohio | 39153 | 48440 | 1001 |
1438742 | 1438742 | 2021-06-20 | Summit | Ohio | 39153 | 48435 | 1001 |
1435495 | 1435495 | 2021-06-19 | Summit | Ohio | 39153 | 48427 | 1001 |
1432248 | 1432248 | 2021-06-18 | Summit | Ohio | 39153 | 48415 | 1001 |
1429002 | 1429002 | 2021-06-17 | Summit | Ohio | 39153 | 48395 | 999 |
1425757 | 1425757 | 2021-06-16 | Summit | Ohio | 39153 | 48381 | 999 |
1422510 | 1422510 | 2021-06-15 | Summit | Ohio | 39153 | 48370 | 999 |
1419264 | 1419264 | 2021-06-14 | Summit | Ohio | 39153 | 48356 | 999 |
1416019 | 1416019 | 2021-06-13 | Summit | Ohio | 39153 | 48339 | 999 |
1412773 | 1412773 | 2021-06-12 | Summit | Ohio | 39153 | 48327 | 999 |
1409528 | 1409528 | 2021-06-11 | Summit | Ohio | 39153 | 48319 | 999 |
1406283 | 1406283 | 2021-06-10 | Summit | Ohio | 39153 | 48306 | 995 |
1403037 | 1403037 | 2021-06-09 | Summit | Ohio | 39153 | 48294 | 995 |
1399792 | 1399792 | 2021-06-08 | Summit | Ohio | 39153 | 48273 | 995 |
1396547 | 1396547 | 2021-06-07 | Summit | Ohio | 39153 | 48265 | 991 |
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);