ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 315 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Ohio · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1906452 | 1906452 | 2021-11-11 | Licking | Ohio | 39089 | 25081 | 315 |
1903203 | 1903203 | 2021-11-10 | Licking | Ohio | 39089 | 25018 | 315 |
1899953 | 1899953 | 2021-11-09 | Licking | Ohio | 39089 | 24945 | 315 |
1815439 | 1815439 | 2021-10-14 | Clermont | Ohio | 39025 | 27741 | 315 |
1812191 | 1812191 | 2021-10-13 | Clermont | Ohio | 39025 | 27626 | 315 |
1808942 | 1808942 | 2021-10-12 | Clermont | Ohio | 39025 | 27537 | 315 |
1669239 | 1669239 | 2021-08-30 | Clark | Ohio | 39023 | 15584 | 315 |
1665992 | 1665992 | 2021-08-29 | Clark | Ohio | 39023 | 15543 | 315 |
1662744 | 1662744 | 2021-08-28 | Clark | Ohio | 39023 | 15478 | 315 |
1659496 | 1659496 | 2021-08-27 | Clark | Ohio | 39023 | 15347 | 315 |
1656247 | 1656247 | 2021-08-26 | Clark | Ohio | 39023 | 15273 | 315 |
1653000 | 1653000 | 2021-08-25 | Clark | Ohio | 39023 | 15194 | 315 |
1649753 | 1649753 | 2021-08-24 | Clark | Ohio | 39023 | 15120 | 315 |
1646504 | 1646504 | 2021-08-23 | Clark | Ohio | 39023 | 15067 | 315 |
1643255 | 1643255 | 2021-08-22 | Clark | Ohio | 39023 | 15042 | 315 |
1640005 | 1640005 | 2021-08-21 | Clark | Ohio | 39023 | 15008 | 315 |
1636755 | 1636755 | 2021-08-20 | Clark | Ohio | 39023 | 14960 | 315 |
1633505 | 1633505 | 2021-08-19 | Clark | Ohio | 39023 | 14905 | 315 |
1630258 | 1630258 | 2021-08-18 | Clark | Ohio | 39023 | 14866 | 315 |
1627011 | 1627011 | 2021-08-17 | Clark | Ohio | 39023 | 14821 | 315 |
909566 | 909566 | 2021-01-08 | Mahoning | Ohio | 39099 | 15818 | 315 |
906321 | 906321 | 2021-01-07 | Mahoning | Ohio | 39099 | 15684 | 315 |
903075 | 903075 | 2021-01-06 | Mahoning | Ohio | 39099 | 15529 | 315 |
899830 | 899830 | 2021-01-05 | Mahoning | Ohio | 39099 | 15399 | 315 |
896585 | 896585 | 2021-01-04 | Mahoning | Ohio | 39099 | 15269 | 315 |
893339 | 893339 | 2021-01-03 | Mahoning | Ohio | 39099 | 15131 | 315 |
890093 | 890093 | 2021-01-02 | Mahoning | Ohio | 39099 | 15047 | 315 |
886846 | 886846 | 2021-01-01 | Mahoning | Ohio | 39099 | 14800 | 315 |
883601 | 883601 | 2020-12-31 | Mahoning | Ohio | 39099 | 14800 | 315 |
578614 | 578614 | 2020-09-28 | Hamilton | Ohio | 39061 | 13237 | 315 |
575373 | 575373 | 2020-09-27 | Hamilton | Ohio | 39061 | 13191 | 315 |
572129 | 572129 | 2020-09-26 | Hamilton | Ohio | 39061 | 13158 | 315 |
568887 | 568887 | 2020-09-25 | Hamilton | Ohio | 39061 | 13036 | 315 |
565646 | 565646 | 2020-09-24 | Hamilton | Ohio | 39061 | 12953 | 315 |
242115 | 242115 | 2020-06-15 | Cuyahoga | Ohio | 39035 | 5220 | 315 |
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);