ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
260 rows where deaths = 53 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Guernsey 42
- Noble 25
- Wyandot 17
- Jackson 16
- Champaign 11
- Erie 10
- Ashtabula 8
- Fayette 7
- Gallia 7
- Geauga 7
- Harrison 7
- Trumbull 7
- Darke 6
- Jefferson 5
- Sandusky 5
- Adams 4
- Athens 4
- Clermont 4
- Columbiana 4
- Fairfield 4
- Monroe 4
- Scioto 4
- Union 4
- Allen 3
- Brown 3
- Lawrence 3
- Madison 3
- Meigs 3
- Montgomery 3
- Ross 3
- …
state 1
- Ohio · 260 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2247886 | 2247886 | 2022-02-24 | Vinton | Ohio | 39163 | 2878 | 53 |
2244635 | 2244635 | 2022-02-23 | Vinton | Ohio | 39163 | 2877 | 53 |
2241384 | 2241384 | 2022-02-22 | Vinton | Ohio | 39163 | 2874 | 53 |
2238111 | 2238111 | 2022-02-21 | Noble | Ohio | 39121 | 3162 | 53 |
2234860 | 2234860 | 2022-02-20 | Noble | Ohio | 39121 | 3160 | 53 |
2231609 | 2231609 | 2022-02-19 | Noble | Ohio | 39121 | 3160 | 53 |
2228358 | 2228358 | 2022-02-18 | Noble | Ohio | 39121 | 3158 | 53 |
2225107 | 2225107 | 2022-02-17 | Noble | Ohio | 39121 | 3156 | 53 |
2221856 | 2221856 | 2022-02-16 | Noble | Ohio | 39121 | 3153 | 53 |
2218605 | 2218605 | 2022-02-15 | Noble | Ohio | 39121 | 3149 | 53 |
2215354 | 2215354 | 2022-02-14 | Noble | Ohio | 39121 | 3141 | 53 |
2212103 | 2212103 | 2022-02-13 | Noble | Ohio | 39121 | 3140 | 53 |
2208850 | 2208850 | 2022-02-12 | Noble | Ohio | 39121 | 3139 | 53 |
2205597 | 2205597 | 2022-02-11 | Noble | Ohio | 39121 | 3136 | 53 |
2202344 | 2202344 | 2022-02-10 | Noble | Ohio | 39121 | 3132 | 53 |
2199090 | 2199090 | 2022-02-09 | Noble | Ohio | 39121 | 3128 | 53 |
2195836 | 2195836 | 2022-02-08 | Noble | Ohio | 39121 | 3128 | 53 |
2192582 | 2192582 | 2022-02-07 | Noble | Ohio | 39121 | 3123 | 53 |
2189328 | 2189328 | 2022-02-06 | Noble | Ohio | 39121 | 3121 | 53 |
2186075 | 2186075 | 2022-02-05 | Noble | Ohio | 39121 | 3120 | 53 |
2182823 | 2182823 | 2022-02-04 | Noble | Ohio | 39121 | 3119 | 53 |
2179571 | 2179571 | 2022-02-03 | Noble | Ohio | 39121 | 3117 | 53 |
2176320 | 2176320 | 2022-02-02 | Noble | Ohio | 39121 | 3110 | 53 |
2173066 | 2173066 | 2022-02-01 | Noble | Ohio | 39121 | 3094 | 53 |
2169814 | 2169814 | 2022-01-31 | Noble | Ohio | 39121 | 3070 | 53 |
2166559 | 2166559 | 2022-01-30 | Noble | Ohio | 39121 | 3068 | 53 |
2163304 | 2163304 | 2022-01-29 | Noble | Ohio | 39121 | 3063 | 53 |
2160049 | 2160049 | 2022-01-28 | Noble | Ohio | 39121 | 3059 | 53 |
1987698 | 1987698 | 2021-12-06 | Harrison | Ohio | 39067 | 2169 | 53 |
1984448 | 1984448 | 2021-12-05 | Harrison | Ohio | 39067 | 2152 | 53 |
1981198 | 1981198 | 2021-12-04 | Harrison | Ohio | 39067 | 2146 | 53 |
1977948 | 1977948 | 2021-12-03 | Harrison | Ohio | 39067 | 2131 | 53 |
1974698 | 1974698 | 2021-12-02 | Harrison | Ohio | 39067 | 2109 | 53 |
1971449 | 1971449 | 2021-12-01 | Harrison | Ohio | 39067 | 2090 | 53 |
1968199 | 1968199 | 2021-11-30 | Harrison | Ohio | 39067 | 2069 | 53 |
1860968 | 1860968 | 2021-10-28 | Meigs | Ohio | 39105 | 2708 | 53 |
1857719 | 1857719 | 2021-10-27 | Meigs | Ohio | 39105 | 2693 | 53 |
1854470 | 1854470 | 2021-10-26 | Meigs | Ohio | 39105 | 2685 | 53 |
1828478 | 1828478 | 2021-10-18 | Monroe | Ohio | 39111 | 2129 | 53 |
1825229 | 1825229 | 2021-10-17 | Monroe | Ohio | 39111 | 2122 | 53 |
1821980 | 1821980 | 2021-10-16 | Monroe | Ohio | 39111 | 2121 | 53 |
1818731 | 1818731 | 2021-10-15 | Monroe | Ohio | 39111 | 2105 | 53 |
1783016 | 1783016 | 2021-10-04 | Union | Ohio | 39159 | 7759 | 53 |
1779767 | 1779767 | 2021-10-03 | Union | Ohio | 39159 | 7729 | 53 |
1776517 | 1776517 | 2021-10-02 | Union | Ohio | 39159 | 7719 | 53 |
1773267 | 1773267 | 2021-10-01 | Union | Ohio | 39159 | 7681 | 53 |
1760214 | 1760214 | 2021-09-27 | Fayette | Ohio | 39047 | 3852 | 53 |
1756966 | 1756966 | 2021-09-26 | Fayette | Ohio | 39047 | 3850 | 53 |
1753718 | 1753718 | 2021-09-25 | Fayette | Ohio | 39047 | 3837 | 53 |
1750470 | 1750470 | 2021-09-24 | Fayette | Ohio | 39047 | 3817 | 53 |
1747220 | 1747220 | 2021-09-23 | Fayette | Ohio | 39047 | 3784 | 53 |
1743971 | 1743971 | 2021-09-22 | Fayette | Ohio | 39047 | 3758 | 53 |
1740722 | 1740722 | 2021-09-21 | Fayette | Ohio | 39047 | 3737 | 53 |
1691997 | 1691997 | 2021-09-06 | Gallia | Ohio | 39053 | 3051 | 53 |
1688748 | 1688748 | 2021-09-05 | Gallia | Ohio | 39053 | 3033 | 53 |
1685498 | 1685498 | 2021-09-04 | Gallia | Ohio | 39053 | 3017 | 53 |
1682247 | 1682247 | 2021-09-03 | Gallia | Ohio | 39053 | 3001 | 53 |
1678997 | 1678997 | 2021-09-02 | Gallia | Ohio | 39053 | 2982 | 53 |
1675749 | 1675749 | 2021-09-01 | Gallia | Ohio | 39053 | 2961 | 53 |
1672502 | 1672502 | 2021-08-31 | Gallia | Ohio | 39053 | 2921 | 53 |
1441940 | 1441940 | 2021-06-21 | Guernsey | Ohio | 39059 | 3251 | 53 |
1438695 | 1438695 | 2021-06-20 | Guernsey | Ohio | 39059 | 3249 | 53 |
1435448 | 1435448 | 2021-06-19 | Guernsey | Ohio | 39059 | 3249 | 53 |
1432201 | 1432201 | 2021-06-18 | Guernsey | Ohio | 39059 | 3249 | 53 |
1428955 | 1428955 | 2021-06-17 | Guernsey | Ohio | 39059 | 3248 | 53 |
1425710 | 1425710 | 2021-06-16 | Guernsey | Ohio | 39059 | 3250 | 53 |
1422463 | 1422463 | 2021-06-15 | Guernsey | Ohio | 39059 | 3245 | 53 |
1419217 | 1419217 | 2021-06-14 | Guernsey | Ohio | 39059 | 3242 | 53 |
1415972 | 1415972 | 2021-06-13 | Guernsey | Ohio | 39059 | 3241 | 53 |
1412726 | 1412726 | 2021-06-12 | Guernsey | Ohio | 39059 | 3241 | 53 |
1409481 | 1409481 | 2021-06-11 | Guernsey | Ohio | 39059 | 3240 | 53 |
1406236 | 1406236 | 2021-06-10 | Guernsey | Ohio | 39059 | 3239 | 53 |
1402990 | 1402990 | 2021-06-09 | Guernsey | Ohio | 39059 | 3235 | 53 |
1399745 | 1399745 | 2021-06-08 | Guernsey | Ohio | 39059 | 3234 | 53 |
1396500 | 1396500 | 2021-06-07 | Guernsey | Ohio | 39059 | 3228 | 53 |
1393253 | 1393253 | 2021-06-06 | Guernsey | Ohio | 39059 | 3227 | 53 |
1390008 | 1390008 | 2021-06-05 | Guernsey | Ohio | 39059 | 3227 | 53 |
1386763 | 1386763 | 2021-06-04 | Guernsey | Ohio | 39059 | 3224 | 53 |
1377037 | 1377037 | 2021-06-01 | Jackson | Ohio | 39079 | 3160 | 53 |
1373791 | 1373791 | 2021-05-31 | Jackson | Ohio | 39079 | 3159 | 53 |
1370546 | 1370546 | 2021-05-30 | Jackson | Ohio | 39079 | 3159 | 53 |
1367300 | 1367300 | 2021-05-29 | Jackson | Ohio | 39079 | 3159 | 53 |
1364054 | 1364054 | 2021-05-28 | Jackson | Ohio | 39079 | 3158 | 53 |
1360798 | 1360798 | 2021-05-27 | Guernsey | Ohio | 39059 | 3211 | 53 |
1360808 | 1360808 | 2021-05-27 | Jackson | Ohio | 39079 | 3157 | 53 |
1357552 | 1357552 | 2021-05-26 | Guernsey | Ohio | 39059 | 3208 | 53 |
1357562 | 1357562 | 2021-05-26 | Jackson | Ohio | 39079 | 3156 | 53 |
1354306 | 1354306 | 2021-05-25 | Guernsey | Ohio | 39059 | 3207 | 53 |
1354316 | 1354316 | 2021-05-25 | Jackson | Ohio | 39079 | 3152 | 53 |
1351060 | 1351060 | 2021-05-24 | Guernsey | Ohio | 39059 | 3206 | 53 |
1347814 | 1347814 | 2021-05-23 | Guernsey | Ohio | 39059 | 3200 | 53 |
1344566 | 1344566 | 2021-05-22 | Guernsey | Ohio | 39059 | 3199 | 53 |
1341318 | 1341318 | 2021-05-21 | Guernsey | Ohio | 39059 | 3199 | 53 |
1338070 | 1338070 | 2021-05-20 | Guernsey | Ohio | 39059 | 3196 | 53 |
1334823 | 1334823 | 2021-05-19 | Guernsey | Ohio | 39059 | 3187 | 53 |
1331576 | 1331576 | 2021-05-18 | Guernsey | Ohio | 39059 | 3180 | 53 |
1328300 | 1328300 | 2021-05-17 | Adams | Ohio | 39001 | 2400 | 53 |
1328329 | 1328329 | 2021-05-17 | Guernsey | Ohio | 39059 | 3176 | 53 |
1325054 | 1325054 | 2021-05-16 | Adams | Ohio | 39001 | 2400 | 53 |
1325083 | 1325083 | 2021-05-16 | Guernsey | Ohio | 39059 | 3173 | 53 |
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);