ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
84 rows where cases = 27 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 |
---|---|---|---|---|---|---|---|
562435 | 562435 | 2020-09-23 | Noble | Ohio | 39121 | 27 | 0 |
559198 | 559198 | 2020-09-22 | Noble | Ohio | 39121 | 27 | 0 |
555961 | 555961 | 2020-09-21 | Noble | Ohio | 39121 | 27 | 0 |
552724 | 552724 | 2020-09-20 | Noble | Ohio | 39121 | 27 | 0 |
449222 | 449222 | 2020-08-19 | Harrison | Ohio | 39067 | 27 | 1 |
445994 | 445994 | 2020-08-18 | Harrison | Ohio | 39067 | 27 | 1 |
378406 | 378406 | 2020-07-28 | Vinton | Ohio | 39163 | 27 | 2 |
320760 | 320760 | 2020-07-10 | Jackson | Ohio | 39079 | 27 | 0 |
320786 | 320786 | 2020-07-10 | Pike | Ohio | 39131 | 27 | 0 |
317583 | 317583 | 2020-07-09 | Jackson | Ohio | 39079 | 27 | 0 |
317606 | 317606 | 2020-07-09 | Paulding | Ohio | 39125 | 27 | 0 |
317609 | 317609 | 2020-07-09 | Pike | Ohio | 39131 | 27 | 0 |
295458 | 295458 | 2020-07-02 | Van Wert | Ohio | 39161 | 27 | 0 |
292302 | 292302 | 2020-07-01 | Van Wert | Ohio | 39161 | 27 | 0 |
282809 | 282809 | 2020-06-28 | Henry | Ohio | 39069 | 27 | 0 |
267133 | 267133 | 2020-06-23 | Scioto | Ohio | 39145 | 27 | 0 |
220445 | 220445 | 2020-06-08 | Seneca | Ohio | 39147 | 27 | 2 |
217353 | 217353 | 2020-06-07 | Seneca | Ohio | 39147 | 27 | 2 |
214263 | 214263 | 2020-06-06 | Seneca | Ohio | 39147 | 27 | 2 |
192656 | 192656 | 2020-05-30 | Champaign | Ohio | 39021 | 27 | 1 |
189592 | 189592 | 2020-05-29 | Champaign | Ohio | 39021 | 27 | 1 |
186532 | 186532 | 2020-05-28 | Champaign | Ohio | 39021 | 27 | 1 |
183475 | 183475 | 2020-05-27 | Champaign | Ohio | 39021 | 27 | 1 |
180426 | 180426 | 2020-05-26 | Champaign | Ohio | 39021 | 27 | 1 |
177410 | 177410 | 2020-05-25 | Holmes | Ohio | 39075 | 27 | 1 |
165255 | 165255 | 2020-05-21 | Lawrence | Ohio | 39087 | 27 | 0 |
159199 | 159199 | 2020-05-19 | Lawrence | Ohio | 39087 | 27 | 0 |
156155 | 156155 | 2020-05-18 | Defiance | Ohio | 39039 | 27 | 1 |
156179 | 156179 | 2020-05-18 | Lawrence | Ohio | 39087 | 27 | 0 |
153162 | 153162 | 2020-05-17 | Lawrence | Ohio | 39087 | 27 | 0 |
150151 | 150151 | 2020-05-16 | Lawrence | Ohio | 39087 | 27 | 0 |
147144 | 147144 | 2020-05-15 | Lawrence | Ohio | 39087 | 27 | 0 |
144123 | 144123 | 2020-05-14 | Fayette | Ohio | 39047 | 27 | 0 |
144143 | 144143 | 2020-05-14 | Lawrence | Ohio | 39087 | 27 | 0 |
144187 | 144187 | 2020-05-14 | Wyandot | Ohio | 39175 | 27 | 2 |
141128 | 141128 | 2020-05-13 | Fayette | Ohio | 39047 | 27 | 0 |
141192 | 141192 | 2020-05-13 | Wyandot | Ohio | 39175 | 27 | 2 |
138132 | 138132 | 2020-05-12 | Fayette | Ohio | 39047 | 27 | 0 |
138196 | 138196 | 2020-05-12 | Wyandot | Ohio | 39175 | 27 | 2 |
135142 | 135142 | 2020-05-11 | Fayette | Ohio | 39047 | 27 | 0 |
135178 | 135178 | 2020-05-11 | Muskingum | Ohio | 39119 | 27 | 0 |
135206 | 135206 | 2020-05-11 | Wyandot | Ohio | 39175 | 27 | 2 |
132151 | 132151 | 2020-05-10 | Fayette | Ohio | 39047 | 27 | 0 |
132215 | 132215 | 2020-05-10 | Wyandot | Ohio | 39175 | 27 | 2 |
129162 | 129162 | 2020-05-09 | Fayette | Ohio | 39047 | 27 | 0 |
129171 | 129171 | 2020-05-09 | Hardin | Ohio | 39065 | 27 | 0 |
129226 | 129226 | 2020-05-09 | Wyandot | Ohio | 39175 | 27 | 2 |
126182 | 126182 | 2020-05-08 | Hardin | Ohio | 39065 | 27 | 0 |
126217 | 126217 | 2020-05-08 | Preble | Ohio | 39135 | 27 | 1 |
123234 | 123234 | 2020-05-07 | Preble | Ohio | 39135 | 27 | 1 |
120257 | 120257 | 2020-05-06 | Preble | Ohio | 39135 | 27 | 1 |
117296 | 117296 | 2020-05-05 | Preble | Ohio | 39135 | 27 | 1 |
114415 | 114415 | 2020-05-04 | Preble | Ohio | 39135 | 27 | 1 |
111534 | 111534 | 2020-05-03 | Preble | Ohio | 39135 | 27 | 1 |
108660 | 108660 | 2020-05-02 | Preble | Ohio | 39135 | 27 | 1 |
105793 | 105793 | 2020-05-01 | Preble | Ohio | 39135 | 27 | 1 |
102930 | 102930 | 2020-04-30 | Preble | Ohio | 39135 | 27 | 1 |
102934 | 102934 | 2020-04-30 | Sandusky | Ohio | 39143 | 27 | 5 |
100077 | 100077 | 2020-04-29 | Preble | Ohio | 39135 | 27 | 2 |
88695 | 88695 | 2020-04-25 | Clinton | Ohio | 39027 | 27 | 0 |
88720 | 88720 | 2020-04-25 | Huron | Ohio | 39077 | 27 | 1 |
88766 | 88766 | 2020-04-25 | Williams | Ohio | 39171 | 27 | 1 |
85881 | 85881 | 2020-04-24 | Clinton | Ohio | 39027 | 27 | 0 |
83077 | 83077 | 2020-04-23 | Clinton | Ohio | 39027 | 27 | 0 |
71980 | 71980 | 2020-04-19 | Ottawa | Ohio | 39123 | 27 | 0 |
69173 | 69173 | 2020-04-18 | Erie | Ohio | 39043 | 27 | 1 |
69213 | 69213 | 2020-04-18 | Ottawa | Ohio | 39123 | 27 | 0 |
66426 | 66426 | 2020-04-17 | Hancock | Ohio | 39063 | 27 | 1 |
66443 | 66443 | 2020-04-17 | Madison | Ohio | 39097 | 27 | 3 |
61000 | 61000 | 2020-04-15 | Shelby | Ohio | 39149 | 27 | 0 |
58285 | 58285 | 2020-04-14 | Shelby | Ohio | 39149 | 27 | 0 |
55584 | 55584 | 2020-04-13 | Shelby | Ohio | 39149 | 27 | 0 |
52900 | 52900 | 2020-04-12 | Shelby | Ohio | 39149 | 27 | 0 |
52904 | 52904 | 2020-04-12 | Tuscarawas | Ohio | 39157 | 27 | 0 |
50155 | 50155 | 2020-04-11 | Allen | Ohio | 39003 | 27 | 1 |
44951 | 44951 | 2020-04-09 | Richland | Ohio | 39139 | 27 | 1 |
42311 | 42311 | 2020-04-08 | Clermont | Ohio | 39025 | 27 | 1 |
39818 | 39818 | 2020-04-07 | Washington | Ohio | 39167 | 27 | 0 |
37236 | 37236 | 2020-04-06 | Clermont | Ohio | 39025 | 27 | 1 |
37282 | 37282 | 2020-04-06 | Pickaway | Ohio | 39129 | 27 | 0 |
18975 | 18975 | 2020-03-29 | Butler | Ohio | 39017 | 27 | 0 |
19019 | 19019 | 2020-03-29 | Portage | Ohio | 39133 | 27 | 0 |
17092 | 17092 | 2020-03-28 | Trumbull | Ohio | 39155 | 27 | 2 |
15226 | 15226 | 2020-03-27 | Lake | Ohio | 39085 | 27 | 1 |
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);