ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
69,101 rows where state = "Ohio" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 39035 796
- 39151 794
- 39155 793
- 39013 791
- 39017 791
- 39049 791
- 39093 791
- 39153 791
- 39157 791
- 39095 790
- 39103 790
- 39055 789
- 39031 788
- 39037 788
- 39085 788
- 39099 788
- 39005 787
- 39023 787
- 39041 787
- 39077 787
- 39109 787
- 39061 786
- 39113 786
- 39139 786
- 39007 785
- 39029 785
- 39101 785
- 39159 785
- 39165 785
- 39025 784
- …
county >30
- Cuyahoga 796
- Stark 794
- Trumbull 793
- Belmont 791
- Butler 791
- Franklin 791
- Lorain 791
- Summit 791
- Tuscarawas 791
- Lucas 790
- Medina 790
- Geauga 789
- Coshocton 788
- Darke 788
- Lake 788
- Mahoning 788
- Ashland 787
- Clark 787
- Delaware 787
- Huron 787
- Miami 787
- Hamilton 786
- Montgomery 786
- Richland 786
- Ashtabula 785
- Columbiana 785
- Marion 785
- Union 785
- Warren 785
- Clermont 784
- …
state 1
- Ohio · 69,001 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1416023 | 1416023 | 2021-06-13 | Unknown | Ohio | 0 | 3 | |
1419268 | 1419268 | 2021-06-14 | Unknown | Ohio | 0 | 3 | |
1422514 | 1422514 | 2021-06-15 | Unknown | Ohio | 0 | 3 | |
1425761 | 1425761 | 2021-06-16 | Unknown | Ohio | 0 | 3 | |
1429006 | 1429006 | 2021-06-17 | Unknown | Ohio | 0 | 3 | |
1432252 | 1432252 | 2021-06-18 | Unknown | Ohio | 0 | 3 | |
1435499 | 1435499 | 2021-06-19 | Unknown | Ohio | 0 | 3 | |
1438746 | 1438746 | 2021-06-20 | Unknown | Ohio | 0 | 3 | |
1441991 | 1441991 | 2021-06-21 | Unknown | Ohio | 0 | 3 | |
1445236 | 1445236 | 2021-06-22 | Unknown | Ohio | 0 | 3 | |
1448481 | 1448481 | 2021-06-23 | Unknown | Ohio | 0 | 3 | |
1451727 | 1451727 | 2021-06-24 | Unknown | Ohio | 0 | 3 | |
1454972 | 1454972 | 2021-06-25 | Unknown | Ohio | 0 | 3 | |
1458217 | 1458217 | 2021-06-26 | Unknown | Ohio | 0 | 3 | |
1461462 | 1461462 | 2021-06-27 | Unknown | Ohio | 0 | 3 | |
1464707 | 1464707 | 2021-06-28 | Unknown | Ohio | 0 | 3 | |
1467952 | 1467952 | 2021-06-29 | Unknown | Ohio | 0 | 3 | |
1471197 | 1471197 | 2021-06-30 | Unknown | Ohio | 0 | 3 | |
1474443 | 1474443 | 2021-07-01 | Unknown | Ohio | 0 | 3 | |
1477689 | 1477689 | 2021-07-02 | Unknown | Ohio | 0 | 3 | |
1480936 | 1480936 | 2021-07-03 | Unknown | Ohio | 0 | 3 | |
1484182 | 1484182 | 2021-07-04 | Unknown | Ohio | 0 | 3 | |
1487429 | 1487429 | 2021-07-05 | Unknown | Ohio | 0 | 3 | |
1490676 | 1490676 | 2021-07-06 | Unknown | Ohio | 0 | 3 | |
1493923 | 1493923 | 2021-07-07 | Unknown | Ohio | 0 | 3 | |
1497170 | 1497170 | 2021-07-08 | Unknown | Ohio | 0 | 3 | |
1500416 | 1500416 | 2021-07-09 | Unknown | Ohio | 0 | 3 | |
1503662 | 1503662 | 2021-07-10 | Unknown | Ohio | 0 | 3 | |
1506908 | 1506908 | 2021-07-11 | Unknown | Ohio | 0 | 3 | |
1510155 | 1510155 | 2021-07-12 | Unknown | Ohio | 0 | 3 | |
1513401 | 1513401 | 2021-07-13 | Unknown | Ohio | 0 | 3 | |
1516648 | 1516648 | 2021-07-14 | Unknown | Ohio | 0 | 3 | |
1519896 | 1519896 | 2021-07-15 | Unknown | Ohio | 0 | 3 | |
1523144 | 1523144 | 2021-07-16 | Unknown | Ohio | 0 | 3 | |
1526391 | 1526391 | 2021-07-17 | Unknown | Ohio | 0 | 3 | |
1529638 | 1529638 | 2021-07-18 | Unknown | Ohio | 0 | 3 | |
1532885 | 1532885 | 2021-07-19 | Unknown | Ohio | 0 | 3 | |
1536133 | 1536133 | 2021-07-20 | Unknown | Ohio | 0 | 3 | |
1539380 | 1539380 | 2021-07-21 | Unknown | Ohio | 0 | 3 | |
1542628 | 1542628 | 2021-07-22 | Unknown | Ohio | 0 | 3 | |
1545875 | 1545875 | 2021-07-23 | Unknown | Ohio | 0 | 3 | |
1549122 | 1549122 | 2021-07-24 | Unknown | Ohio | 0 | 3 | |
1552369 | 1552369 | 2021-07-25 | Unknown | Ohio | 0 | 3 | |
1555616 | 1555616 | 2021-07-26 | Unknown | Ohio | 0 | 3 | |
1558863 | 1558863 | 2021-07-27 | Unknown | Ohio | 0 | 4 | |
1562111 | 1562111 | 2021-07-28 | Unknown | Ohio | 0 | 4 | |
1565359 | 1565359 | 2021-07-29 | Unknown | Ohio | 0 | 4 | |
1568607 | 1568607 | 2021-07-30 | Unknown | Ohio | 0 | 4 | |
1571855 | 1571855 | 2021-07-31 | Unknown | Ohio | 0 | 4 | |
1575103 | 1575103 | 2021-08-01 | Unknown | Ohio | 0 | 4 | |
1578351 | 1578351 | 2021-08-02 | Unknown | Ohio | 0 | 4 | |
1581600 | 1581600 | 2021-08-03 | Unknown | Ohio | 0 | 4 | |
1584850 | 1584850 | 2021-08-04 | Unknown | Ohio | 0 | 4 | |
1588100 | 1588100 | 2021-08-05 | Unknown | Ohio | 0 | 4 | |
1591349 | 1591349 | 2021-08-06 | Unknown | Ohio | 0 | 4 | |
1594598 | 1594598 | 2021-08-07 | Unknown | Ohio | 0 | 4 | |
1597847 | 1597847 | 2021-08-08 | Unknown | Ohio | 0 | 4 | |
1601095 | 1601095 | 2021-08-09 | Unknown | Ohio | 0 | 4 | |
1604344 | 1604344 | 2021-08-10 | Unknown | Ohio | 0 | 5 | |
1607593 | 1607593 | 2021-08-11 | Unknown | Ohio | 0 | 5 | |
1610841 | 1610841 | 2021-08-12 | Unknown | Ohio | 0 | 5 | |
1614090 | 1614090 | 2021-08-13 | Unknown | Ohio | 0 | 5 | |
1617338 | 1617338 | 2021-08-14 | Unknown | Ohio | 0 | 5 | |
1620586 | 1620586 | 2021-08-15 | Unknown | Ohio | 0 | 5 | |
1623833 | 1623833 | 2021-08-16 | Unknown | Ohio | 0 | 5 | |
1627080 | 1627080 | 2021-08-17 | Unknown | Ohio | 0 | 5 | |
1630327 | 1630327 | 2021-08-18 | Unknown | Ohio | 0 | 5 | |
1633574 | 1633574 | 2021-08-19 | Unknown | Ohio | 0 | 5 | |
1636824 | 1636824 | 2021-08-20 | Unknown | Ohio | 0 | 5 | |
1640074 | 1640074 | 2021-08-21 | Unknown | Ohio | 0 | 5 | |
1643324 | 1643324 | 2021-08-22 | Unknown | Ohio | 0 | 5 | |
1646573 | 1646573 | 2021-08-23 | Unknown | Ohio | 0 | 5 | |
1649822 | 1649822 | 2021-08-24 | Unknown | Ohio | 0 | 5 | |
1653069 | 1653069 | 2021-08-25 | Unknown | Ohio | 0 | 5 | |
1656316 | 1656316 | 2021-08-26 | Unknown | Ohio | 0 | 5 | |
1659565 | 1659565 | 2021-08-27 | Unknown | Ohio | 0 | 5 | |
1662813 | 1662813 | 2021-08-28 | Unknown | Ohio | 0 | 5 | |
1666061 | 1666061 | 2021-08-29 | Unknown | Ohio | 0 | 5 | |
1669308 | 1669308 | 2021-08-30 | Unknown | Ohio | 0 | 5 | |
1672556 | 1672556 | 2021-08-31 | Unknown | Ohio | 0 | 5 | |
1675803 | 1675803 | 2021-09-01 | Unknown | Ohio | 0 | 5 | |
1679051 | 1679051 | 2021-09-02 | Unknown | Ohio | 0 | 5 | |
1682301 | 1682301 | 2021-09-03 | Unknown | Ohio | 0 | 5 | |
1685552 | 1685552 | 2021-09-04 | Unknown | Ohio | 0 | 5 | |
1688802 | 1688802 | 2021-09-05 | Unknown | Ohio | 0 | 5 | |
1692051 | 1692051 | 2021-09-06 | Unknown | Ohio | 0 | 5 | |
1695299 | 1695299 | 2021-09-07 | Unknown | Ohio | 0 | 5 | |
1698547 | 1698547 | 2021-09-08 | Unknown | Ohio | 0 | 5 | |
1701796 | 1701796 | 2021-09-09 | Unknown | Ohio | 0 | 5 | |
1705046 | 1705046 | 2021-09-10 | Unknown | Ohio | 0 | 5 | |
1708293 | 1708293 | 2021-09-11 | Unknown | Ohio | 0 | 5 | |
1711540 | 1711540 | 2021-09-12 | Unknown | Ohio | 0 | 5 | |
1714786 | 1714786 | 2021-09-13 | Unknown | Ohio | 0 | 5 | |
1718034 | 1718034 | 2021-09-14 | Unknown | Ohio | 0 | 5 | |
1721282 | 1721282 | 2021-09-15 | Unknown | Ohio | 0 | 5 | |
1724531 | 1724531 | 2021-09-16 | Unknown | Ohio | 0 | 5 | |
1727780 | 1727780 | 2021-09-17 | Unknown | Ohio | 0 | 5 | |
1731030 | 1731030 | 2021-09-18 | Unknown | Ohio | 0 | 5 | |
1734280 | 1734280 | 2021-09-19 | Unknown | Ohio | 0 | 5 | |
1737530 | 1737530 | 2021-09-20 | Unknown | Ohio | 0 | 5 |
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);