ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
250 rows where deaths = 99 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 |
---|---|---|---|---|---|---|---|
2335695 | 2335695 | 2022-03-23 | Union | Ohio | 39159 | 15557 | 99 |
2332441 | 2332441 | 2022-03-22 | Union | Ohio | 39159 | 15557 | 99 |
2329188 | 2329188 | 2022-03-21 | Union | Ohio | 39159 | 15557 | 99 |
2325936 | 2325936 | 2022-03-20 | Union | Ohio | 39159 | 15557 | 99 |
2322683 | 2322683 | 2022-03-19 | Union | Ohio | 39159 | 15557 | 99 |
2319429 | 2319429 | 2022-03-18 | Union | Ohio | 39159 | 15557 | 99 |
2316175 | 2316175 | 2022-03-17 | Union | Ohio | 39159 | 15557 | 99 |
2312922 | 2312922 | 2022-03-16 | Union | Ohio | 39159 | 15535 | 99 |
2309669 | 2309669 | 2022-03-15 | Union | Ohio | 39159 | 15535 | 99 |
2306416 | 2306416 | 2022-03-14 | Union | Ohio | 39159 | 15535 | 99 |
2303165 | 2303165 | 2022-03-13 | Union | Ohio | 39159 | 15535 | 99 |
2299913 | 2299913 | 2022-03-12 | Union | Ohio | 39159 | 15534 | 99 |
2296661 | 2296661 | 2022-03-11 | Union | Ohio | 39159 | 15529 | 99 |
2293388 | 2293388 | 2022-03-10 | Morrow | Ohio | 39117 | 7723 | 99 |
2290136 | 2290136 | 2022-03-09 | Morrow | Ohio | 39117 | 7721 | 99 |
2286884 | 2286884 | 2022-03-08 | Morrow | Ohio | 39117 | 7718 | 99 |
2283632 | 2283632 | 2022-03-07 | Morrow | Ohio | 39117 | 7716 | 99 |
2280380 | 2280380 | 2022-03-06 | Morrow | Ohio | 39117 | 7714 | 99 |
2277127 | 2277127 | 2022-03-05 | Morrow | Ohio | 39117 | 7710 | 99 |
2273874 | 2273874 | 2022-03-04 | Morrow | Ohio | 39117 | 7711 | 99 |
2179534 | 2179534 | 2022-02-03 | Fayette | Ohio | 39047 | 7581 | 99 |
2176283 | 2176283 | 2022-02-02 | Fayette | Ohio | 39047 | 7562 | 99 |
2173029 | 2173029 | 2022-02-01 | Fayette | Ohio | 39047 | 7530 | 99 |
2065683 | 2065683 | 2021-12-30 | Champaign | Ohio | 39021 | 6536 | 99 |
2065721 | 2065721 | 2021-12-30 | Madison | Ohio | 39097 | 7159 | 99 |
2062433 | 2062433 | 2021-12-29 | Champaign | Ohio | 39021 | 6490 | 99 |
2062471 | 2062471 | 2021-12-29 | Madison | Ohio | 39097 | 7101 | 99 |
2059183 | 2059183 | 2021-12-28 | Champaign | Ohio | 39021 | 6446 | 99 |
2059221 | 2059221 | 2021-12-28 | Madison | Ohio | 39097 | 7031 | 99 |
2055972 | 2055972 | 2021-12-27 | Madison | Ohio | 39097 | 6988 | 99 |
2052723 | 2052723 | 2021-12-26 | Madison | Ohio | 39097 | 6975 | 99 |
2049473 | 2049473 | 2021-12-25 | Madison | Ohio | 39097 | 6952 | 99 |
2046223 | 2046223 | 2021-12-24 | Madison | Ohio | 39097 | 6952 | 99 |
2020177 | 2020177 | 2021-12-16 | Athens | Ohio | 39009 | 8644 | 99 |
2016926 | 2016926 | 2021-12-15 | Athens | Ohio | 39009 | 8613 | 99 |
2013676 | 2013676 | 2021-12-14 | Athens | Ohio | 39009 | 8591 | 99 |
1987751 | 1987751 | 2021-12-06 | Williams | Ohio | 39171 | 6552 | 99 |
1984501 | 1984501 | 2021-12-05 | Williams | Ohio | 39171 | 6538 | 99 |
1981251 | 1981251 | 2021-12-04 | Williams | Ohio | 39171 | 6529 | 99 |
1978001 | 1978001 | 2021-12-03 | Williams | Ohio | 39171 | 6500 | 99 |
1974697 | 1974697 | 2021-12-02 | Hardin | Ohio | 39065 | 4859 | 99 |
1974726 | 1974726 | 2021-12-02 | Ottawa | Ohio | 39123 | 5619 | 99 |
1974751 | 1974751 | 2021-12-02 | Williams | Ohio | 39171 | 6451 | 99 |
1971448 | 1971448 | 2021-12-01 | Hardin | Ohio | 39065 | 4834 | 99 |
1971477 | 1971477 | 2021-12-01 | Ottawa | Ohio | 39123 | 5575 | 99 |
1971502 | 1971502 | 2021-12-01 | Williams | Ohio | 39171 | 6404 | 99 |
1968198 | 1968198 | 2021-11-30 | Hardin | Ohio | 39065 | 4806 | 99 |
1968227 | 1968227 | 2021-11-30 | Ottawa | Ohio | 39123 | 5554 | 99 |
1968252 | 1968252 | 2021-11-30 | Williams | Ohio | 39171 | 6358 | 99 |
1964947 | 1964947 | 2021-11-29 | Hardin | Ohio | 39065 | 4778 | 99 |
1964976 | 1964976 | 2021-11-29 | Ottawa | Ohio | 39123 | 5535 | 99 |
1961695 | 1961695 | 2021-11-28 | Hardin | Ohio | 39065 | 4759 | 99 |
1961724 | 1961724 | 2021-11-28 | Ottawa | Ohio | 39123 | 5509 | 99 |
1958444 | 1958444 | 2021-11-27 | Hardin | Ohio | 39065 | 4753 | 99 |
1958473 | 1958473 | 2021-11-27 | Ottawa | Ohio | 39123 | 5495 | 99 |
1955193 | 1955193 | 2021-11-26 | Hardin | Ohio | 39065 | 4733 | 99 |
1955222 | 1955222 | 2021-11-26 | Ottawa | Ohio | 39123 | 5483 | 99 |
1896666 | 1896666 | 2021-11-08 | Brown | Ohio | 39015 | 6642 | 99 |
1893416 | 1893416 | 2021-11-07 | Brown | Ohio | 39015 | 6632 | 99 |
1890166 | 1890166 | 2021-11-06 | Brown | Ohio | 39015 | 6609 | 99 |
1886916 | 1886916 | 2021-11-05 | Brown | Ohio | 39015 | 6603 | 99 |
1883659 | 1883659 | 2021-11-04 | Adams | Ohio | 39001 | 4265 | 99 |
1883666 | 1883666 | 2021-11-04 | Brown | Ohio | 39015 | 6582 | 99 |
1880410 | 1880410 | 2021-11-03 | Adams | Ohio | 39001 | 4258 | 99 |
1880417 | 1880417 | 2021-11-03 | Brown | Ohio | 39015 | 6565 | 99 |
1877161 | 1877161 | 2021-11-02 | Adams | Ohio | 39001 | 4246 | 99 |
1877168 | 1877168 | 2021-11-02 | Brown | Ohio | 39015 | 6543 | 99 |
1873937 | 1873937 | 2021-11-01 | Fulton | Ohio | 39051 | 6165 | 99 |
1870688 | 1870688 | 2021-10-31 | Fulton | Ohio | 39051 | 6150 | 99 |
1867439 | 1867439 | 2021-10-30 | Fulton | Ohio | 39051 | 6145 | 99 |
1864190 | 1864190 | 2021-10-29 | Fulton | Ohio | 39051 | 6117 | 99 |
1860921 | 1860921 | 2021-10-28 | Auglaize | Ohio | 39011 | 6892 | 99 |
1857672 | 1857672 | 2021-10-27 | Auglaize | Ohio | 39011 | 6868 | 99 |
1854423 | 1854423 | 2021-10-26 | Auglaize | Ohio | 39011 | 6845 | 99 |
1851174 | 1851174 | 2021-10-25 | Auglaize | Ohio | 39011 | 6817 | 99 |
1851204 | 1851204 | 2021-10-25 | Highland | Ohio | 39071 | 6028 | 99 |
1847924 | 1847924 | 2021-10-24 | Auglaize | Ohio | 39011 | 6807 | 99 |
1847954 | 1847954 | 2021-10-24 | Highland | Ohio | 39071 | 6017 | 99 |
1844674 | 1844674 | 2021-10-23 | Auglaize | Ohio | 39011 | 6797 | 99 |
1844704 | 1844704 | 2021-10-23 | Highland | Ohio | 39071 | 6004 | 99 |
1841424 | 1841424 | 2021-10-22 | Auglaize | Ohio | 39011 | 6786 | 99 |
1841454 | 1841454 | 2021-10-22 | Highland | Ohio | 39071 | 5993 | 99 |
1838205 | 1838205 | 2021-10-21 | Highland | Ohio | 39071 | 5968 | 99 |
1834956 | 1834956 | 2021-10-20 | Highland | Ohio | 39071 | 5946 | 99 |
1831707 | 1831707 | 2021-10-19 | Highland | Ohio | 39071 | 5921 | 99 |
1828458 | 1828458 | 2021-10-18 | Highland | Ohio | 39071 | 5900 | 99 |
1825209 | 1825209 | 2021-10-17 | Highland | Ohio | 39071 | 5885 | 99 |
1821960 | 1821960 | 2021-10-16 | Highland | Ohio | 39071 | 5871 | 99 |
1818711 | 1818711 | 2021-10-15 | Highland | Ohio | 39071 | 5858 | 99 |
1815462 | 1815462 | 2021-10-14 | Highland | Ohio | 39071 | 5850 | 99 |
1812214 | 1812214 | 2021-10-13 | Highland | Ohio | 39071 | 5836 | 99 |
1808965 | 1808965 | 2021-10-12 | Highland | Ohio | 39071 | 5811 | 99 |
1805715 | 1805715 | 2021-10-11 | Highland | Ohio | 39071 | 5793 | 99 |
1802465 | 1802465 | 2021-10-10 | Highland | Ohio | 39071 | 5783 | 99 |
1799216 | 1799216 | 2021-10-09 | Highland | Ohio | 39071 | 5761 | 99 |
1795967 | 1795967 | 2021-10-08 | Highland | Ohio | 39071 | 5748 | 99 |
1724525 | 1724525 | 2021-09-16 | Shelby | Ohio | 39149 | 5592 | 99 |
1721276 | 1721276 | 2021-09-15 | Shelby | Ohio | 39149 | 5557 | 99 |
1718028 | 1718028 | 2021-09-14 | Shelby | Ohio | 39149 | 5533 | 99 |
1646512 | 1646512 | 2021-08-23 | Defiance | Ohio | 39039 | 4710 | 99 |
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);