ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
98 rows where cases = 24 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
543009 | 543009 | 2020-09-17 | Noble | Ohio | 39121 | 24 | 0 |
539773 | 539773 | 2020-09-16 | Noble | Ohio | 39121 | 24 | 0 |
410532 | 410532 | 2020-08-07 | Harrison | Ohio | 39067 | 24 | 1 |
394462 | 394462 | 2020-08-02 | Meigs | Ohio | 39105 | 24 | 0 |
343079 | 343079 | 2020-07-17 | Gallia | Ohio | 39053 | 24 | 1 |
343134 | 343134 | 2020-07-17 | Vinton | Ohio | 39163 | 24 | 2 |
339881 | 339881 | 2020-07-16 | Gallia | Ohio | 39053 | 24 | 1 |
339936 | 339936 | 2020-07-16 | Vinton | Ohio | 39163 | 24 | 2 |
336685 | 336685 | 2020-07-15 | Gallia | Ohio | 39053 | 24 | 1 |
336740 | 336740 | 2020-07-15 | Vinton | Ohio | 39163 | 24 | 2 |
317544 | 317544 | 2020-07-09 | Adams | Ohio | 39001 | 24 | 1 |
314371 | 314371 | 2020-07-08 | Adams | Ohio | 39001 | 24 | 1 |
314436 | 314436 | 2020-07-08 | Pike | Ohio | 39131 | 24 | 0 |
311199 | 311199 | 2020-07-07 | Adams | Ohio | 39001 | 24 | 1 |
311238 | 311238 | 2020-07-07 | Jackson | Ohio | 39079 | 24 | 0 |
311264 | 311264 | 2020-07-07 | Pike | Ohio | 39131 | 24 | 0 |
308030 | 308030 | 2020-07-06 | Adams | Ohio | 39001 | 24 | 1 |
289150 | 289150 | 2020-06-30 | Van Wert | Ohio | 39161 | 24 | 0 |
276515 | 276515 | 2020-06-26 | Henry | Ohio | 39069 | 24 | 0 |
257682 | 257682 | 2020-06-20 | Athens | Ohio | 39009 | 24 | 1 |
254557 | 254557 | 2020-06-19 | Athens | Ohio | 39009 | 24 | 1 |
251442 | 251442 | 2020-06-18 | Athens | Ohio | 39009 | 24 | 1 |
248327 | 248327 | 2020-06-17 | Athens | Ohio | 39009 | 24 | 1 |
248386 | 248386 | 2020-06-17 | Perry | Ohio | 39127 | 24 | 1 |
245273 | 245273 | 2020-06-16 | Perry | Ohio | 39127 | 24 | 1 |
220374 | 220374 | 2020-06-08 | Ashland | Ohio | 39005 | 24 | 0 |
217282 | 217282 | 2020-06-07 | Ashland | Ohio | 39005 | 24 | 0 |
214192 | 214192 | 2020-06-06 | Ashland | Ohio | 39005 | 24 | 0 |
205014 | 205014 | 2020-06-03 | Seneca | Ohio | 39147 | 24 | 2 |
189623 | 189623 | 2020-05-29 | Knox | Ohio | 39083 | 24 | 1 |
177388 | 177388 | 2020-05-25 | Coshocton | Ohio | 39031 | 24 | 0 |
174336 | 174336 | 2020-05-24 | Brown | Ohio | 39015 | 24 | 1 |
174344 | 174344 | 2020-05-24 | Coshocton | Ohio | 39031 | 24 | 0 |
171294 | 171294 | 2020-05-23 | Brown | Ohio | 39015 | 24 | 1 |
171302 | 171302 | 2020-05-23 | Coshocton | Ohio | 39031 | 24 | 0 |
168255 | 168255 | 2020-05-22 | Brown | Ohio | 39015 | 24 | 1 |
159201 | 159201 | 2020-05-19 | Logan | Ohio | 39091 | 24 | 0 |
156181 | 156181 | 2020-05-18 | Logan | Ohio | 39091 | 24 | 0 |
153148 | 153148 | 2020-05-17 | Guernsey | Ohio | 39059 | 24 | 0 |
150117 | 150117 | 2020-05-16 | Carroll | Ohio | 39019 | 24 | 2 |
150137 | 150137 | 2020-05-16 | Guernsey | Ohio | 39059 | 24 | 0 |
150153 | 150153 | 2020-05-16 | Logan | Ohio | 39091 | 24 | 0 |
147110 | 147110 | 2020-05-15 | Carroll | Ohio | 39019 | 24 | 2 |
147146 | 147146 | 2020-05-15 | Logan | Ohio | 39091 | 24 | 0 |
144109 | 144109 | 2020-05-14 | Carroll | Ohio | 39019 | 24 | 2 |
141114 | 141114 | 2020-05-13 | Carroll | Ohio | 39019 | 24 | 2 |
138118 | 138118 | 2020-05-12 | Carroll | Ohio | 39019 | 24 | 2 |
135128 | 135128 | 2020-05-11 | Carroll | Ohio | 39019 | 24 | 1 |
129182 | 129182 | 2020-05-09 | Lawrence | Ohio | 39087 | 24 | 0 |
126193 | 126193 | 2020-05-08 | Lawrence | Ohio | 39087 | 24 | 0 |
126209 | 126209 | 2020-05-08 | Muskingum | Ohio | 39119 | 24 | 0 |
123210 | 123210 | 2020-05-07 | Lawrence | Ohio | 39087 | 24 | 0 |
120233 | 120233 | 2020-05-06 | Lawrence | Ohio | 39087 | 24 | 0 |
120277 | 120277 | 2020-05-06 | Wyandot | Ohio | 39175 | 24 | 2 |
117272 | 117272 | 2020-05-05 | Lawrence | Ohio | 39087 | 24 | 0 |
117316 | 117316 | 2020-05-05 | Wyandot | Ohio | 39175 | 24 | 2 |
114391 | 114391 | 2020-05-04 | Lawrence | Ohio | 39087 | 24 | 0 |
114435 | 114435 | 2020-05-04 | Wyandot | Ohio | 39175 | 24 | 2 |
111492 | 111492 | 2020-05-03 | Fulton | Ohio | 39051 | 24 | 0 |
111546 | 111546 | 2020-05-03 | Union | Ohio | 39159 | 24 | 0 |
111554 | 111554 | 2020-05-03 | Wyandot | Ohio | 39175 | 24 | 2 |
108618 | 108618 | 2020-05-02 | Fulton | Ohio | 39051 | 24 | 0 |
108680 | 108680 | 2020-05-02 | Wyandot | Ohio | 39175 | 24 | 2 |
105751 | 105751 | 2020-05-01 | Fulton | Ohio | 39051 | 24 | 0 |
105769 | 105769 | 2020-05-01 | Lawrence | Ohio | 39087 | 24 | 0 |
105813 | 105813 | 2020-05-01 | Wyandot | Ohio | 39175 | 24 | 2 |
102906 | 102906 | 2020-04-30 | Lawrence | Ohio | 39087 | 24 | 0 |
102950 | 102950 | 2020-04-30 | Wyandot | Ohio | 39175 | 24 | 2 |
100042 | 100042 | 2020-04-29 | Hardin | Ohio | 39065 | 24 | 0 |
100053 | 100053 | 2020-04-29 | Lawrence | Ohio | 39087 | 24 | 0 |
97193 | 97193 | 2020-04-28 | Hardin | Ohio | 39065 | 24 | 0 |
97204 | 97204 | 2020-04-28 | Lawrence | Ohio | 39087 | 24 | 0 |
97248 | 97248 | 2020-04-28 | Wyandot | Ohio | 39175 | 24 | 2 |
94367 | 94367 | 2020-04-27 | Lawrence | Ohio | 39087 | 24 | 0 |
94410 | 94410 | 2020-04-27 | Wyandot | Ohio | 39175 | 24 | 2 |
91584 | 91584 | 2020-04-26 | Wyandot | Ohio | 39175 | 24 | 2 |
88768 | 88768 | 2020-04-25 | Wyandot | Ohio | 39175 | 24 | 2 |
85954 | 85954 | 2020-04-24 | Wyandot | Ohio | 39175 | 24 | 2 |
83102 | 83102 | 2020-04-23 | Huron | Ohio | 39077 | 24 | 1 |
80333 | 80333 | 2020-04-22 | Putnam | Ohio | 39137 | 24 | 2 |
77533 | 77533 | 2020-04-21 | Morrow | Ohio | 39117 | 24 | 0 |
74761 | 74761 | 2020-04-20 | Preble | Ohio | 39135 | 24 | 1 |
66435 | 66435 | 2020-04-17 | Jefferson | Ohio | 39081 | 24 | 0 |
63692 | 63692 | 2020-04-16 | Jefferson | Ohio | 39081 | 24 | 0 |
60966 | 60966 | 2020-04-15 | Jefferson | Ohio | 39081 | 24 | 0 |
58251 | 58251 | 2020-04-14 | Jefferson | Ohio | 39081 | 24 | 0 |
58259 | 58259 | 2020-04-14 | Madison | Ohio | 39097 | 24 | 3 |
55550 | 55550 | 2020-04-13 | Jefferson | Ohio | 39081 | 24 | 0 |
55558 | 55558 | 2020-04-13 | Madison | Ohio | 39097 | 24 | 3 |
52866 | 52866 | 2020-04-12 | Jefferson | Ohio | 39081 | 24 | 0 |
50157 | 50157 | 2020-04-11 | Ashtabula | Ohio | 39007 | 24 | 0 |
50182 | 50182 | 2020-04-11 | Greene | Ohio | 39057 | 24 | 1 |
47500 | 47500 | 2020-04-10 | Allen | Ohio | 39003 | 24 | 1 |
47571 | 47571 | 2020-04-10 | Shelby | Ohio | 39149 | 24 | 0 |
23170 | 23170 | 2020-03-31 | Geauga | Ohio | 39055 | 24 | 0 |
13497 | 13497 | 2020-03-26 | Medina | Ohio | 39103 | 24 | 0 |
9119 | 9119 | 2020-03-23 | Lorain | Ohio | 39093 | 24 | 0 |
3064 | 3064 | 2020-03-16 | Cuyahoga | Ohio | 39035 | 24 | 0 |
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);