ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
157 rows where cases = 8 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 |
---|---|---|---|---|---|---|---|
279689 | 279689 | 2020-06-27 | Noble | Ohio | 39121 | 8 | 0 |
248375 | 248375 | 2020-06-17 | Meigs | Ohio | 39105 | 8 | 0 |
226647 | 226647 | 2020-06-10 | Van Wert | Ohio | 39161 | 8 | 0 |
223547 | 223547 | 2020-06-09 | Van Wert | Ohio | 39161 | 8 | 0 |
220452 | 220452 | 2020-06-08 | Van Wert | Ohio | 39161 | 8 | 0 |
217360 | 217360 | 2020-06-07 | Van Wert | Ohio | 39161 | 8 | 0 |
214270 | 214270 | 2020-06-06 | Van Wert | Ohio | 39161 | 8 | 0 |
211130 | 211130 | 2020-06-05 | Gallia | Ohio | 39053 | 8 | 1 |
208048 | 208048 | 2020-06-04 | Gallia | Ohio | 39053 | 8 | 1 |
204967 | 204967 | 2020-06-03 | Gallia | Ohio | 39053 | 8 | 1 |
201890 | 201890 | 2020-06-02 | Gallia | Ohio | 39053 | 8 | 1 |
201929 | 201929 | 2020-06-02 | Pike | Ohio | 39131 | 8 | 0 |
198815 | 198815 | 2020-06-01 | Gallia | Ohio | 39053 | 8 | 1 |
198854 | 198854 | 2020-06-01 | Pike | Ohio | 39131 | 8 | 0 |
195742 | 195742 | 2020-05-31 | Gallia | Ohio | 39053 | 8 | 1 |
186522 | 186522 | 2020-05-28 | Adams | Ohio | 39001 | 8 | 1 |
183465 | 183465 | 2020-05-27 | Adams | Ohio | 39001 | 8 | 1 |
180416 | 180416 | 2020-05-26 | Adams | Ohio | 39001 | 8 | 1 |
177373 | 177373 | 2020-05-25 | Adams | Ohio | 39001 | 8 | 1 |
174329 | 174329 | 2020-05-24 | Adams | Ohio | 39001 | 8 | 1 |
171287 | 171287 | 2020-05-23 | Adams | Ohio | 39001 | 8 | 1 |
168248 | 168248 | 2020-05-22 | Adams | Ohio | 39001 | 8 | 1 |
165212 | 165212 | 2020-05-21 | Adams | Ohio | 39001 | 8 | 1 |
162183 | 162183 | 2020-05-20 | Adams | Ohio | 39001 | 8 | 1 |
162209 | 162209 | 2020-05-20 | Gallia | Ohio | 39053 | 8 | 1 |
159156 | 159156 | 2020-05-19 | Adams | Ohio | 39001 | 8 | 1 |
156136 | 156136 | 2020-05-18 | Adams | Ohio | 39001 | 8 | 1 |
153119 | 153119 | 2020-05-17 | Adams | Ohio | 39001 | 8 | 0 |
153123 | 153123 | 2020-05-17 | Athens | Ohio | 39009 | 8 | 1 |
150108 | 150108 | 2020-05-16 | Adams | Ohio | 39001 | 8 | 0 |
150112 | 150112 | 2020-05-16 | Athens | Ohio | 39009 | 8 | 1 |
147101 | 147101 | 2020-05-15 | Adams | Ohio | 39001 | 8 | 0 |
147105 | 147105 | 2020-05-15 | Athens | Ohio | 39009 | 8 | 1 |
144133 | 144133 | 2020-05-14 | Harrison | Ohio | 39067 | 8 | 0 |
141138 | 141138 | 2020-05-13 | Harrison | Ohio | 39067 | 8 | 0 |
141142 | 141142 | 2020-05-13 | Holmes | Ohio | 39075 | 8 | 1 |
138146 | 138146 | 2020-05-12 | Holmes | Ohio | 39075 | 8 | 1 |
138148 | 138148 | 2020-05-12 | Jackson | Ohio | 39079 | 8 | 0 |
135156 | 135156 | 2020-05-11 | Holmes | Ohio | 39075 | 8 | 1 |
135158 | 135158 | 2020-05-11 | Jackson | Ohio | 39079 | 8 | 0 |
132162 | 132162 | 2020-05-10 | Henry | Ohio | 39069 | 8 | 0 |
132165 | 132165 | 2020-05-10 | Holmes | Ohio | 39075 | 8 | 1 |
132167 | 132167 | 2020-05-10 | Jackson | Ohio | 39079 | 8 | 0 |
129173 | 129173 | 2020-05-09 | Henry | Ohio | 39069 | 8 | 0 |
129194 | 129194 | 2020-05-09 | Monroe | Ohio | 39111 | 8 | 0 |
126184 | 126184 | 2020-05-08 | Henry | Ohio | 39069 | 8 | 0 |
126205 | 126205 | 2020-05-08 | Monroe | Ohio | 39111 | 8 | 0 |
126212 | 126212 | 2020-05-08 | Paulding | Ohio | 39125 | 8 | 0 |
123229 | 123229 | 2020-05-07 | Paulding | Ohio | 39125 | 8 | 0 |
120252 | 120252 | 2020-05-06 | Paulding | Ohio | 39125 | 8 | 0 |
120271 | 120271 | 2020-05-06 | Vinton | Ohio | 39163 | 8 | 0 |
117291 | 117291 | 2020-05-05 | Paulding | Ohio | 39125 | 8 | 0 |
117310 | 117310 | 2020-05-05 | Vinton | Ohio | 39163 | 8 | 0 |
114410 | 114410 | 2020-05-04 | Paulding | Ohio | 39125 | 8 | 0 |
111529 | 111529 | 2020-05-03 | Paulding | Ohio | 39125 | 8 | 0 |
108595 | 108595 | 2020-05-02 | Ashland | Ohio | 39005 | 8 | 0 |
108655 | 108655 | 2020-05-02 | Paulding | Ohio | 39125 | 8 | 0 |
105788 | 105788 | 2020-05-01 | Paulding | Ohio | 39125 | 8 | 0 |
102925 | 102925 | 2020-04-30 | Paulding | Ohio | 39125 | 8 | 0 |
100072 | 100072 | 2020-04-29 | Paulding | Ohio | 39125 | 8 | 0 |
100082 | 100082 | 2020-04-29 | Scioto | Ohio | 39145 | 8 | 0 |
97223 | 97223 | 2020-04-28 | Paulding | Ohio | 39125 | 8 | 0 |
94386 | 94386 | 2020-04-27 | Paulding | Ohio | 39125 | 8 | 0 |
91560 | 91560 | 2020-04-26 | Paulding | Ohio | 39125 | 8 | 0 |
88717 | 88717 | 2020-04-25 | Highland | Ohio | 39071 | 8 | 0 |
88744 | 88744 | 2020-04-25 | Paulding | Ohio | 39125 | 8 | 0 |
85878 | 85878 | 2020-04-24 | Champaign | Ohio | 39021 | 8 | 1 |
85903 | 85903 | 2020-04-24 | Highland | Ohio | 39071 | 8 | 0 |
85930 | 85930 | 2020-04-24 | Paulding | Ohio | 39125 | 8 | 0 |
83074 | 83074 | 2020-04-23 | Champaign | Ohio | 39021 | 8 | 1 |
83099 | 83099 | 2020-04-23 | Highland | Ohio | 39071 | 8 | 0 |
80300 | 80300 | 2020-04-22 | Highland | Ohio | 39071 | 8 | 0 |
80327 | 80327 | 2020-04-22 | Paulding | Ohio | 39125 | 8 | 0 |
77559 | 77559 | 2020-04-21 | Williams | Ohio | 39171 | 8 | 1 |
74704 | 74704 | 2020-04-20 | Champaign | Ohio | 39021 | 8 | 1 |
74778 | 74778 | 2020-04-20 | Williams | Ohio | 39171 | 8 | 1 |
71929 | 71929 | 2020-04-19 | Champaign | Ohio | 39021 | 8 | 1 |
71978 | 71978 | 2020-04-19 | Muskingum | Ohio | 39119 | 8 | 0 |
72003 | 72003 | 2020-04-19 | Williams | Ohio | 39171 | 8 | 1 |
69211 | 69211 | 2020-04-18 | Muskingum | Ohio | 39119 | 8 | 0 |
66402 | 66402 | 2020-04-17 | Brown | Ohio | 39015 | 8 | 1 |
66454 | 66454 | 2020-04-17 | Muskingum | Ohio | 39119 | 8 | 0 |
66458 | 66458 | 2020-04-17 | Perry | Ohio | 39127 | 8 | 0 |
63659 | 63659 | 2020-04-16 | Brown | Ohio | 39015 | 8 | 1 |
63697 | 63697 | 2020-04-16 | Logan | Ohio | 39091 | 8 | 0 |
63711 | 63711 | 2020-04-16 | Muskingum | Ohio | 39119 | 8 | 0 |
63715 | 63715 | 2020-04-16 | Perry | Ohio | 39127 | 8 | 0 |
60933 | 60933 | 2020-04-15 | Brown | Ohio | 39015 | 8 | 1 |
60951 | 60951 | 2020-04-15 | Fulton | Ohio | 39051 | 8 | 0 |
60971 | 60971 | 2020-04-15 | Logan | Ohio | 39091 | 8 | 0 |
60985 | 60985 | 2020-04-15 | Muskingum | Ohio | 39119 | 8 | 0 |
60989 | 60989 | 2020-04-15 | Perry | Ohio | 39127 | 8 | 0 |
58256 | 58256 | 2020-04-14 | Logan | Ohio | 39091 | 8 | 0 |
58270 | 58270 | 2020-04-14 | Muskingum | Ohio | 39119 | 8 | 0 |
58274 | 58274 | 2020-04-14 | Perry | Ohio | 39127 | 8 | 0 |
55537 | 55537 | 2020-04-13 | Gallia | Ohio | 39053 | 8 | 1 |
55543 | 55543 | 2020-04-13 | Hardin | Ohio | 39065 | 8 | 0 |
55555 | 55555 | 2020-04-13 | Logan | Ohio | 39091 | 8 | 0 |
55569 | 55569 | 2020-04-13 | Muskingum | Ohio | 39119 | 8 | 0 |
55573 | 55573 | 2020-04-13 | Perry | Ohio | 39127 | 8 | 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);