ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,561 rows where county = "Ashland" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
142122 | 142122 | 2020-05-13 | Ashland | Wisconsin | 55003 | 2 | 0 |
144102 | 144102 | 2020-05-14 | Ashland | Ohio | 39005 | 15 | 0 |
145119 | 145119 | 2020-05-14 | Ashland | Wisconsin | 55003 | 2 | 0 |
147103 | 147103 | 2020-05-15 | Ashland | Ohio | 39005 | 15 | 0 |
148122 | 148122 | 2020-05-15 | Ashland | Wisconsin | 55003 | 2 | 0 |
150110 | 150110 | 2020-05-16 | Ashland | Ohio | 39005 | 15 | 0 |
151131 | 151131 | 2020-05-16 | Ashland | Wisconsin | 55003 | 2 | 0 |
153121 | 153121 | 2020-05-17 | Ashland | Ohio | 39005 | 15 | 0 |
154143 | 154143 | 2020-05-17 | Ashland | Wisconsin | 55003 | 2 | 0 |
156138 | 156138 | 2020-05-18 | Ashland | Ohio | 39005 | 15 | 0 |
157159 | 157159 | 2020-05-18 | Ashland | Wisconsin | 55003 | 2 | 0 |
159158 | 159158 | 2020-05-19 | Ashland | Ohio | 39005 | 15 | 0 |
160183 | 160183 | 2020-05-19 | Ashland | Wisconsin | 55003 | 2 | 0 |
162185 | 162185 | 2020-05-20 | Ashland | Ohio | 39005 | 17 | 0 |
163211 | 163211 | 2020-05-20 | Ashland | Wisconsin | 55003 | 2 | 0 |
165214 | 165214 | 2020-05-21 | Ashland | Ohio | 39005 | 17 | 0 |
166240 | 166240 | 2020-05-21 | Ashland | Wisconsin | 55003 | 2 | 0 |
168250 | 168250 | 2020-05-22 | Ashland | Ohio | 39005 | 17 | 0 |
169276 | 169276 | 2020-05-22 | Ashland | Wisconsin | 55003 | 2 | 0 |
171289 | 171289 | 2020-05-23 | Ashland | Ohio | 39005 | 17 | 0 |
172317 | 172317 | 2020-05-23 | Ashland | Wisconsin | 55003 | 2 | 0 |
174331 | 174331 | 2020-05-24 | Ashland | Ohio | 39005 | 17 | 0 |
175360 | 175360 | 2020-05-24 | Ashland | Wisconsin | 55003 | 2 | 0 |
177375 | 177375 | 2020-05-25 | Ashland | Ohio | 39005 | 18 | 0 |
178405 | 178405 | 2020-05-25 | Ashland | Wisconsin | 55003 | 2 | 0 |
180418 | 180418 | 2020-05-26 | Ashland | Ohio | 39005 | 19 | 0 |
181449 | 181449 | 2020-05-26 | Ashland | Wisconsin | 55003 | 2 | 0 |
183467 | 183467 | 2020-05-27 | Ashland | Ohio | 39005 | 19 | 0 |
184500 | 184500 | 2020-05-27 | Ashland | Wisconsin | 55003 | 2 | 0 |
186524 | 186524 | 2020-05-28 | Ashland | Ohio | 39005 | 19 | 0 |
187557 | 187557 | 2020-05-28 | Ashland | Wisconsin | 55003 | 2 | 0 |
189584 | 189584 | 2020-05-29 | Ashland | Ohio | 39005 | 20 | 0 |
190621 | 190621 | 2020-05-29 | Ashland | Wisconsin | 55003 | 2 | 0 |
192648 | 192648 | 2020-05-30 | Ashland | Ohio | 39005 | 20 | 0 |
193687 | 193687 | 2020-05-30 | Ashland | Wisconsin | 55003 | 2 | 0 |
195718 | 195718 | 2020-05-31 | Ashland | Ohio | 39005 | 20 | 0 |
196757 | 196757 | 2020-05-31 | Ashland | Wisconsin | 55003 | 2 | 0 |
198791 | 198791 | 2020-06-01 | Ashland | Ohio | 39005 | 20 | 0 |
199830 | 199830 | 2020-06-01 | Ashland | Wisconsin | 55003 | 2 | 0 |
201866 | 201866 | 2020-06-02 | Ashland | Ohio | 39005 | 20 | 0 |
202906 | 202906 | 2020-06-02 | Ashland | Wisconsin | 55003 | 2 | 0 |
204943 | 204943 | 2020-06-03 | Ashland | Ohio | 39005 | 21 | 0 |
205985 | 205985 | 2020-06-03 | Ashland | Wisconsin | 55003 | 2 | 0 |
208024 | 208024 | 2020-06-04 | Ashland | Ohio | 39005 | 21 | 0 |
209067 | 209067 | 2020-06-04 | Ashland | Wisconsin | 55003 | 2 | 0 |
211106 | 211106 | 2020-06-05 | Ashland | Ohio | 39005 | 23 | 0 |
212152 | 212152 | 2020-06-05 | Ashland | Wisconsin | 55003 | 3 | 0 |
214192 | 214192 | 2020-06-06 | Ashland | Ohio | 39005 | 24 | 0 |
215239 | 215239 | 2020-06-06 | Ashland | Wisconsin | 55003 | 3 | 0 |
217282 | 217282 | 2020-06-07 | Ashland | Ohio | 39005 | 24 | 0 |
218329 | 218329 | 2020-06-07 | Ashland | Wisconsin | 55003 | 3 | 0 |
220374 | 220374 | 2020-06-08 | Ashland | Ohio | 39005 | 24 | 0 |
221421 | 221421 | 2020-06-08 | Ashland | Wisconsin | 55003 | 3 | 0 |
223469 | 223469 | 2020-06-09 | Ashland | Ohio | 39005 | 25 | 0 |
224517 | 224517 | 2020-06-09 | Ashland | Wisconsin | 55003 | 3 | 0 |
226569 | 226569 | 2020-06-10 | Ashland | Ohio | 39005 | 26 | 0 |
227617 | 227617 | 2020-06-10 | Ashland | Wisconsin | 55003 | 3 | 0 |
229673 | 229673 | 2020-06-11 | Ashland | Ohio | 39005 | 26 | 0 |
230721 | 230721 | 2020-06-11 | Ashland | Wisconsin | 55003 | 3 | 0 |
232778 | 232778 | 2020-06-12 | Ashland | Ohio | 39005 | 26 | 0 |
233826 | 233826 | 2020-06-12 | Ashland | Wisconsin | 55003 | 3 | 0 |
235883 | 235883 | 2020-06-13 | Ashland | Ohio | 39005 | 28 | 0 |
236933 | 236933 | 2020-06-13 | Ashland | Wisconsin | 55003 | 3 | 0 |
238991 | 238991 | 2020-06-14 | Ashland | Ohio | 39005 | 28 | 0 |
240041 | 240041 | 2020-06-14 | Ashland | Wisconsin | 55003 | 3 | 0 |
242100 | 242100 | 2020-06-15 | Ashland | Ohio | 39005 | 28 | 0 |
243152 | 243152 | 2020-06-15 | Ashland | Wisconsin | 55003 | 3 | 0 |
245212 | 245212 | 2020-06-16 | Ashland | Ohio | 39005 | 29 | 0 |
246265 | 246265 | 2020-06-16 | Ashland | Wisconsin | 55003 | 3 | 0 |
248325 | 248325 | 2020-06-17 | Ashland | Ohio | 39005 | 31 | 0 |
249377 | 249377 | 2020-06-17 | Ashland | Wisconsin | 55003 | 3 | 0 |
251440 | 251440 | 2020-06-18 | Ashland | Ohio | 39005 | 37 | 0 |
252492 | 252492 | 2020-06-18 | Ashland | Wisconsin | 55003 | 3 | 0 |
254555 | 254555 | 2020-06-19 | Ashland | Ohio | 39005 | 37 | 0 |
255611 | 255611 | 2020-06-19 | Ashland | Wisconsin | 55003 | 3 | 0 |
257680 | 257680 | 2020-06-20 | Ashland | Ohio | 39005 | 39 | 0 |
258738 | 258738 | 2020-06-20 | Ashland | Wisconsin | 55003 | 3 | 0 |
260807 | 260807 | 2020-06-21 | Ashland | Ohio | 39005 | 39 | 0 |
261865 | 261865 | 2020-06-21 | Ashland | Wisconsin | 55003 | 3 | 0 |
263935 | 263935 | 2020-06-22 | Ashland | Ohio | 39005 | 40 | 0 |
264994 | 264994 | 2020-06-22 | Ashland | Wisconsin | 55003 | 3 | 0 |
267063 | 267063 | 2020-06-23 | Ashland | Ohio | 39005 | 44 | 0 |
268123 | 268123 | 2020-06-23 | Ashland | Wisconsin | 55003 | 3 | 0 |
270197 | 270197 | 2020-06-24 | Ashland | Ohio | 39005 | 45 | 0 |
271257 | 271257 | 2020-06-24 | Ashland | Wisconsin | 55003 | 3 | 0 |
273336 | 273336 | 2020-06-25 | Ashland | Ohio | 39005 | 46 | 0 |
274397 | 274397 | 2020-06-25 | Ashland | Wisconsin | 55003 | 3 | 0 |
276483 | 276483 | 2020-06-26 | Ashland | Ohio | 39005 | 45 | 1 |
277545 | 277545 | 2020-06-26 | Ashland | Wisconsin | 55003 | 3 | 0 |
279631 | 279631 | 2020-06-27 | Ashland | Ohio | 39005 | 45 | 1 |
280693 | 280693 | 2020-06-27 | Ashland | Wisconsin | 55003 | 3 | 0 |
282777 | 282777 | 2020-06-28 | Ashland | Ohio | 39005 | 46 | 1 |
283839 | 283839 | 2020-06-28 | Ashland | Wisconsin | 55003 | 3 | 0 |
285922 | 285922 | 2020-06-29 | Ashland | Ohio | 39005 | 51 | 1 |
286985 | 286985 | 2020-06-29 | Ashland | Wisconsin | 55003 | 3 | 0 |
289072 | 289072 | 2020-06-30 | Ashland | Ohio | 39005 | 53 | 1 |
290135 | 290135 | 2020-06-30 | Ashland | Wisconsin | 55003 | 3 | 0 |
292224 | 292224 | 2020-07-01 | Ashland | Ohio | 39005 | 55 | 1 |
293288 | 293288 | 2020-07-01 | Ashland | Wisconsin | 55003 | 3 | 0 |
295379 | 295379 | 2020-07-02 | Ashland | Ohio | 39005 | 55 | 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);