ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
212 rows where deaths = 105 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501732 | 2501732 | 2022-05-13 | Wyandot | Ohio | 39175 | 5441 | 105 |
2498474 | 2498474 | 2022-05-12 | Wyandot | Ohio | 39175 | 5441 | 105 |
2495216 | 2495216 | 2022-05-11 | Wyandot | Ohio | 39175 | 5425 | 105 |
2491958 | 2491958 | 2022-05-10 | Wyandot | Ohio | 39175 | 5425 | 105 |
2488700 | 2488700 | 2022-05-09 | Wyandot | Ohio | 39175 | 5425 | 105 |
2485443 | 2485443 | 2022-05-08 | Wyandot | Ohio | 39175 | 5425 | 105 |
2482185 | 2482185 | 2022-05-07 | Wyandot | Ohio | 39175 | 5425 | 105 |
2478927 | 2478927 | 2022-05-06 | Wyandot | Ohio | 39175 | 5425 | 105 |
2475669 | 2475669 | 2022-05-05 | Wyandot | Ohio | 39175 | 5425 | 105 |
2472412 | 2472412 | 2022-05-04 | Wyandot | Ohio | 39175 | 5421 | 105 |
2469156 | 2469156 | 2022-05-03 | Wyandot | Ohio | 39175 | 5421 | 105 |
2465900 | 2465900 | 2022-05-02 | Wyandot | Ohio | 39175 | 5421 | 105 |
2462645 | 2462645 | 2022-05-01 | Wyandot | Ohio | 39175 | 5421 | 105 |
2459389 | 2459389 | 2022-04-30 | Wyandot | Ohio | 39175 | 5421 | 105 |
2456133 | 2456133 | 2022-04-29 | Wyandot | Ohio | 39175 | 5421 | 105 |
2452877 | 2452877 | 2022-04-28 | Wyandot | Ohio | 39175 | 5421 | 105 |
2449621 | 2449621 | 2022-04-27 | Wyandot | Ohio | 39175 | 5417 | 105 |
2446364 | 2446364 | 2022-04-26 | Wyandot | Ohio | 39175 | 5417 | 105 |
2443109 | 2443109 | 2022-04-25 | Wyandot | Ohio | 39175 | 5417 | 105 |
2439853 | 2439853 | 2022-04-24 | Wyandot | Ohio | 39175 | 5417 | 105 |
2436597 | 2436597 | 2022-04-23 | Wyandot | Ohio | 39175 | 5417 | 105 |
2433341 | 2433341 | 2022-04-22 | Wyandot | Ohio | 39175 | 5417 | 105 |
2430085 | 2430085 | 2022-04-21 | Wyandot | Ohio | 39175 | 5417 | 105 |
2426829 | 2426829 | 2022-04-20 | Wyandot | Ohio | 39175 | 5416 | 105 |
2423573 | 2423573 | 2022-04-19 | Wyandot | Ohio | 39175 | 5416 | 105 |
2420316 | 2420316 | 2022-04-18 | Wyandot | Ohio | 39175 | 5416 | 105 |
2417061 | 2417061 | 2022-04-17 | Wyandot | Ohio | 39175 | 5416 | 105 |
2413805 | 2413805 | 2022-04-16 | Wyandot | Ohio | 39175 | 5416 | 105 |
2410549 | 2410549 | 2022-04-15 | Wyandot | Ohio | 39175 | 5416 | 105 |
2407293 | 2407293 | 2022-04-14 | Wyandot | Ohio | 39175 | 5416 | 105 |
2404037 | 2404037 | 2022-04-13 | Wyandot | Ohio | 39175 | 5409 | 105 |
2400782 | 2400782 | 2022-04-12 | Wyandot | Ohio | 39175 | 5409 | 105 |
2397527 | 2397527 | 2022-04-11 | Wyandot | Ohio | 39175 | 5409 | 105 |
2394272 | 2394272 | 2022-04-10 | Wyandot | Ohio | 39175 | 5409 | 105 |
2391016 | 2391016 | 2022-04-09 | Wyandot | Ohio | 39175 | 5409 | 105 |
2387760 | 2387760 | 2022-04-08 | Wyandot | Ohio | 39175 | 5409 | 105 |
2384505 | 2384505 | 2022-04-07 | Wyandot | Ohio | 39175 | 5409 | 105 |
2215320 | 2215320 | 2022-02-14 | Gallia | Ohio | 39053 | 7170 | 105 |
2212069 | 2212069 | 2022-02-13 | Gallia | Ohio | 39053 | 7164 | 105 |
2208816 | 2208816 | 2022-02-12 | Gallia | Ohio | 39053 | 7159 | 105 |
2205563 | 2205563 | 2022-02-11 | Gallia | Ohio | 39053 | 7138 | 105 |
2202310 | 2202310 | 2022-02-10 | Gallia | Ohio | 39053 | 7113 | 105 |
2199056 | 2199056 | 2022-02-09 | Gallia | Ohio | 39053 | 7077 | 105 |
2195802 | 2195802 | 2022-02-08 | Gallia | Ohio | 39053 | 7022 | 105 |
2169763 | 2169763 | 2022-01-31 | Carroll | Ohio | 39019 | 5124 | 105 |
2169817 | 2169817 | 2022-01-31 | Perry | Ohio | 39127 | 7811 | 105 |
2166508 | 2166508 | 2022-01-30 | Carroll | Ohio | 39019 | 5114 | 105 |
2166562 | 2166562 | 2022-01-30 | Perry | Ohio | 39127 | 7791 | 105 |
2163253 | 2163253 | 2022-01-29 | Carroll | Ohio | 39019 | 5107 | 105 |
2163307 | 2163307 | 2022-01-29 | Perry | Ohio | 39127 | 7779 | 105 |
2159998 | 2159998 | 2022-01-28 | Carroll | Ohio | 39019 | 5098 | 105 |
2160052 | 2160052 | 2022-01-28 | Perry | Ohio | 39127 | 7750 | 105 |
2156770 | 2156770 | 2022-01-27 | Hocking | Ohio | 39073 | 6069 | 105 |
2153517 | 2153517 | 2022-01-26 | Hocking | Ohio | 39073 | 6007 | 105 |
2150265 | 2150265 | 2022-01-25 | Hocking | Ohio | 39073 | 5947 | 105 |
2147013 | 2147013 | 2022-01-24 | Hocking | Ohio | 39073 | 5918 | 105 |
2143759 | 2143759 | 2022-01-23 | Hocking | Ohio | 39073 | 5856 | 105 |
2140504 | 2140504 | 2022-01-22 | Hocking | Ohio | 39073 | 5835 | 105 |
2137248 | 2137248 | 2022-01-21 | Hocking | Ohio | 39073 | 5775 | 105 |
2111197 | 2111197 | 2022-01-13 | Athens | Ohio | 39009 | 10415 | 105 |
2107945 | 2107945 | 2022-01-12 | Athens | Ohio | 39009 | 10237 | 105 |
2104694 | 2104694 | 2022-01-11 | Athens | Ohio | 39009 | 9988 | 105 |
2101449 | 2101449 | 2022-01-10 | Champaign | Ohio | 39021 | 7002 | 105 |
2098198 | 2098198 | 2022-01-09 | Champaign | Ohio | 39021 | 6969 | 105 |
2094946 | 2094946 | 2022-01-08 | Champaign | Ohio | 39021 | 6910 | 105 |
2091694 | 2091694 | 2022-01-07 | Champaign | Ohio | 39021 | 6877 | 105 |
2033257 | 2033257 | 2021-12-20 | Van Wert | Ohio | 39161 | 4943 | 105 |
2030007 | 2030007 | 2021-12-19 | Van Wert | Ohio | 39161 | 4940 | 105 |
2026756 | 2026756 | 2021-12-18 | Van Wert | Ohio | 39161 | 4938 | 105 |
2023505 | 2023505 | 2021-12-17 | Van Wert | Ohio | 39161 | 4931 | 105 |
2020212 | 2020212 | 2021-12-16 | Jackson | Ohio | 39079 | 6078 | 105 |
2016961 | 2016961 | 2021-12-15 | Jackson | Ohio | 39079 | 6037 | 105 |
2013711 | 2013711 | 2021-12-14 | Jackson | Ohio | 39079 | 6024 | 105 |
1929169 | 1929169 | 2021-11-18 | Clinton | Ohio | 39027 | 6202 | 105 |
1925919 | 1925919 | 2021-11-17 | Clinton | Ohio | 39027 | 6185 | 105 |
1922669 | 1922669 | 2021-11-16 | Clinton | Ohio | 39027 | 6147 | 105 |
1919407 | 1919407 | 2021-11-15 | Adams | Ohio | 39001 | 4360 | 105 |
1919420 | 1919420 | 2021-11-15 | Clinton | Ohio | 39027 | 6124 | 105 |
1916157 | 1916157 | 2021-11-14 | Adams | Ohio | 39001 | 4352 | 105 |
1916170 | 1916170 | 2021-11-14 | Clinton | Ohio | 39027 | 6112 | 105 |
1912907 | 1912907 | 2021-11-13 | Adams | Ohio | 39001 | 4348 | 105 |
1912920 | 1912920 | 2021-11-13 | Clinton | Ohio | 39027 | 6101 | 105 |
1909657 | 1909657 | 2021-11-12 | Adams | Ohio | 39001 | 4345 | 105 |
1909670 | 1909670 | 2021-11-12 | Clinton | Ohio | 39027 | 6095 | 105 |
1883664 | 1883664 | 2021-11-04 | Auglaize | Ohio | 39011 | 7047 | 105 |
1880415 | 1880415 | 2021-11-03 | Auglaize | Ohio | 39011 | 7022 | 105 |
1877166 | 1877166 | 2021-11-02 | Auglaize | Ohio | 39011 | 6976 | 105 |
1873917 | 1873917 | 2021-11-01 | Auglaize | Ohio | 39011 | 6957 | 105 |
1870668 | 1870668 | 2021-10-31 | Auglaize | Ohio | 39011 | 6940 | 105 |
1867419 | 1867419 | 2021-10-30 | Auglaize | Ohio | 39011 | 6925 | 105 |
1864170 | 1864170 | 2021-10-29 | Auglaize | Ohio | 39011 | 6912 | 105 |
1860935 | 1860935 | 2021-10-28 | Defiance | Ohio | 39039 | 6329 | 105 |
1857686 | 1857686 | 2021-10-27 | Defiance | Ohio | 39039 | 6295 | 105 |
1854437 | 1854437 | 2021-10-26 | Defiance | Ohio | 39039 | 6268 | 105 |
1851188 | 1851188 | 2021-10-25 | Defiance | Ohio | 39039 | 6241 | 105 |
1847938 | 1847938 | 2021-10-24 | Defiance | Ohio | 39039 | 6234 | 105 |
1844688 | 1844688 | 2021-10-23 | Defiance | Ohio | 39039 | 6218 | 105 |
1841438 | 1841438 | 2021-10-22 | Defiance | Ohio | 39039 | 6192 | 105 |
1770012 | 1770012 | 2021-09-30 | Shelby | Ohio | 39149 | 6002 | 105 |
1766763 | 1766763 | 2021-09-29 | Shelby | Ohio | 39149 | 5973 | 105 |
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);