ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 364 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Ohio · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2065674 | 2065674 | 2021-12-30 | Allen | Ohio | 39003 | 20826 | 364 |
2062424 | 2062424 | 2021-12-29 | Allen | Ohio | 39003 | 20713 | 364 |
2059174 | 2059174 | 2021-12-28 | Allen | Ohio | 39003 | 20598 | 364 |
2055925 | 2055925 | 2021-12-27 | Allen | Ohio | 39003 | 20525 | 364 |
2052676 | 2052676 | 2021-12-26 | Allen | Ohio | 39003 | 20484 | 364 |
2049426 | 2049426 | 2021-12-25 | Allen | Ohio | 39003 | 20403 | 364 |
2046176 | 2046176 | 2021-12-24 | Allen | Ohio | 39003 | 20403 | 364 |
2033245 | 2033245 | 2021-12-20 | Richland | Ohio | 39139 | 22621 | 364 |
2029995 | 2029995 | 2021-12-19 | Richland | Ohio | 39139 | 22574 | 364 |
2026744 | 2026744 | 2021-12-18 | Richland | Ohio | 39139 | 22504 | 364 |
2023493 | 2023493 | 2021-12-17 | Richland | Ohio | 39139 | 22414 | 364 |
1942185 | 1942185 | 2021-11-22 | Greene | Ohio | 39057 | 23715 | 364 |
1938935 | 1938935 | 2021-11-21 | Greene | Ohio | 39057 | 23667 | 364 |
1935685 | 1935685 | 2021-11-20 | Greene | Ohio | 39057 | 23649 | 364 |
1932435 | 1932435 | 2021-11-19 | Greene | Ohio | 39057 | 23579 | 364 |
1873923 | 1873923 | 2021-11-01 | Clark | Ohio | 39023 | 20214 | 364 |
1870674 | 1870674 | 2021-10-31 | Clark | Ohio | 39023 | 20185 | 364 |
1867425 | 1867425 | 2021-10-30 | Clark | Ohio | 39023 | 20155 | 364 |
1864176 | 1864176 | 2021-10-29 | Clark | Ohio | 39023 | 20094 | 364 |
1029646 | 1029646 | 2021-02-14 | Lorain | Ohio | 39093 | 21213 | 364 |
1026399 | 1026399 | 2021-02-13 | Lorain | Ohio | 39093 | 21152 | 364 |
588351 | 588351 | 2020-10-01 | Lucas | Ohio | 39095 | 7429 | 364 |
585111 | 585111 | 2020-09-30 | Lucas | Ohio | 39095 | 7401 | 364 |
581871 | 581871 | 2020-09-29 | Lucas | Ohio | 39095 | 7377 | 364 |
578631 | 578631 | 2020-09-28 | Lucas | Ohio | 39095 | 7343 | 364 |
575390 | 575390 | 2020-09-27 | Lucas | Ohio | 39095 | 7322 | 364 |
572146 | 572146 | 2020-09-26 | Lucas | Ohio | 39095 | 7303 | 364 |
568904 | 568904 | 2020-09-25 | Lucas | Ohio | 39095 | 7280 | 364 |
565663 | 565663 | 2020-09-24 | Lucas | Ohio | 39095 | 7230 | 364 |
289087 | 289087 | 2020-06-30 | Cuyahoga | Ohio | 39035 | 6831 | 364 |
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);