ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where fips = 39067 and state = "Ohio" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
60959 | 60959 | 2020-04-15 | Harrison | Ohio | 39067 | 1 | 0 |
63685 | 63685 | 2020-04-16 | Harrison | Ohio | 39067 | 1 | 0 |
66428 | 66428 | 2020-04-17 | Harrison | Ohio | 39067 | 2 | 0 |
69185 | 69185 | 2020-04-18 | Harrison | Ohio | 39067 | 2 | 0 |
71952 | 71952 | 2020-04-19 | Harrison | Ohio | 39067 | 2 | 0 |
74727 | 74727 | 2020-04-20 | Harrison | Ohio | 39067 | 2 | 0 |
77508 | 77508 | 2020-04-21 | Harrison | Ohio | 39067 | 2 | 0 |
80298 | 80298 | 2020-04-22 | Harrison | Ohio | 39067 | 2 | 0 |
83097 | 83097 | 2020-04-23 | Harrison | Ohio | 39067 | 2 | 0 |
85901 | 85901 | 2020-04-24 | Harrison | Ohio | 39067 | 2 | 0 |
88715 | 88715 | 2020-04-25 | Harrison | Ohio | 39067 | 2 | 0 |
91531 | 91531 | 2020-04-26 | Harrison | Ohio | 39067 | 4 | 0 |
94357 | 94357 | 2020-04-27 | Harrison | Ohio | 39067 | 4 | 0 |
97194 | 97194 | 2020-04-28 | Harrison | Ohio | 39067 | 4 | 0 |
100043 | 100043 | 2020-04-29 | Harrison | Ohio | 39067 | 4 | 0 |
102896 | 102896 | 2020-04-30 | Harrison | Ohio | 39067 | 4 | 0 |
105759 | 105759 | 2020-05-01 | Harrison | Ohio | 39067 | 4 | 0 |
108626 | 108626 | 2020-05-02 | Harrison | Ohio | 39067 | 5 | 0 |
111500 | 111500 | 2020-05-03 | Harrison | Ohio | 39067 | 6 | 0 |
114381 | 114381 | 2020-05-04 | Harrison | Ohio | 39067 | 6 | 0 |
117262 | 117262 | 2020-05-05 | Harrison | Ohio | 39067 | 6 | 0 |
120223 | 120223 | 2020-05-06 | Harrison | Ohio | 39067 | 6 | 0 |
123200 | 123200 | 2020-05-07 | Harrison | Ohio | 39067 | 6 | 0 |
126183 | 126183 | 2020-05-08 | Harrison | Ohio | 39067 | 6 | 0 |
129172 | 129172 | 2020-05-09 | Harrison | Ohio | 39067 | 6 | 0 |
132161 | 132161 | 2020-05-10 | Harrison | Ohio | 39067 | 6 | 0 |
135152 | 135152 | 2020-05-11 | Harrison | Ohio | 39067 | 6 | 0 |
138142 | 138142 | 2020-05-12 | Harrison | Ohio | 39067 | 7 | 0 |
141138 | 141138 | 2020-05-13 | Harrison | Ohio | 39067 | 8 | 0 |
144133 | 144133 | 2020-05-14 | Harrison | Ohio | 39067 | 8 | 0 |
147134 | 147134 | 2020-05-15 | Harrison | Ohio | 39067 | 9 | 0 |
150141 | 150141 | 2020-05-16 | Harrison | Ohio | 39067 | 9 | 0 |
153152 | 153152 | 2020-05-17 | Harrison | Ohio | 39067 | 9 | 0 |
156169 | 156169 | 2020-05-18 | Harrison | Ohio | 39067 | 9 | 0 |
159189 | 159189 | 2020-05-19 | Harrison | Ohio | 39067 | 10 | 0 |
162216 | 162216 | 2020-05-20 | Harrison | Ohio | 39067 | 10 | 0 |
165245 | 165245 | 2020-05-21 | Harrison | Ohio | 39067 | 10 | 0 |
168281 | 168281 | 2020-05-22 | Harrison | Ohio | 39067 | 10 | 0 |
171320 | 171320 | 2020-05-23 | Harrison | Ohio | 39067 | 10 | 0 |
174362 | 174362 | 2020-05-24 | Harrison | Ohio | 39067 | 10 | 0 |
177406 | 177406 | 2020-05-25 | Harrison | Ohio | 39067 | 10 | 0 |
180449 | 180449 | 2020-05-26 | Harrison | Ohio | 39067 | 10 | 0 |
183498 | 183498 | 2020-05-27 | Harrison | Ohio | 39067 | 10 | 0 |
186555 | 186555 | 2020-05-28 | Harrison | Ohio | 39067 | 10 | 0 |
189615 | 189615 | 2020-05-29 | Harrison | Ohio | 39067 | 10 | 0 |
192679 | 192679 | 2020-05-30 | Harrison | Ohio | 39067 | 10 | 0 |
195749 | 195749 | 2020-05-31 | Harrison | Ohio | 39067 | 10 | 0 |
198822 | 198822 | 2020-06-01 | Harrison | Ohio | 39067 | 10 | 0 |
201897 | 201897 | 2020-06-02 | Harrison | Ohio | 39067 | 10 | 0 |
204974 | 204974 | 2020-06-03 | Harrison | Ohio | 39067 | 10 | 0 |
208055 | 208055 | 2020-06-04 | Harrison | Ohio | 39067 | 10 | 0 |
211137 | 211137 | 2020-06-05 | Harrison | Ohio | 39067 | 10 | 0 |
214223 | 214223 | 2020-06-06 | Harrison | Ohio | 39067 | 10 | 0 |
217313 | 217313 | 2020-06-07 | Harrison | Ohio | 39067 | 10 | 0 |
220405 | 220405 | 2020-06-08 | Harrison | Ohio | 39067 | 10 | 0 |
223500 | 223500 | 2020-06-09 | Harrison | Ohio | 39067 | 10 | 0 |
226600 | 226600 | 2020-06-10 | Harrison | Ohio | 39067 | 10 | 0 |
229704 | 229704 | 2020-06-11 | Harrison | Ohio | 39067 | 10 | 0 |
232809 | 232809 | 2020-06-12 | Harrison | Ohio | 39067 | 10 | 0 |
235914 | 235914 | 2020-06-13 | Harrison | Ohio | 39067 | 10 | 0 |
239022 | 239022 | 2020-06-14 | Harrison | Ohio | 39067 | 10 | 0 |
242131 | 242131 | 2020-06-15 | Harrison | Ohio | 39067 | 10 | 0 |
245243 | 245243 | 2020-06-16 | Harrison | Ohio | 39067 | 11 | 0 |
248356 | 248356 | 2020-06-17 | Harrison | Ohio | 39067 | 11 | 0 |
251471 | 251471 | 2020-06-18 | Harrison | Ohio | 39067 | 11 | 0 |
254586 | 254586 | 2020-06-19 | Harrison | Ohio | 39067 | 11 | 0 |
257711 | 257711 | 2020-06-20 | Harrison | Ohio | 39067 | 11 | 1 |
260838 | 260838 | 2020-06-21 | Harrison | Ohio | 39067 | 11 | 1 |
263966 | 263966 | 2020-06-22 | Harrison | Ohio | 39067 | 11 | 1 |
267094 | 267094 | 2020-06-23 | Harrison | Ohio | 39067 | 11 | 1 |
270228 | 270228 | 2020-06-24 | Harrison | Ohio | 39067 | 12 | 1 |
273367 | 273367 | 2020-06-25 | Harrison | Ohio | 39067 | 12 | 1 |
276514 | 276514 | 2020-06-26 | Harrison | Ohio | 39067 | 12 | 1 |
279662 | 279662 | 2020-06-27 | Harrison | Ohio | 39067 | 12 | 1 |
282808 | 282808 | 2020-06-28 | Harrison | Ohio | 39067 | 12 | 1 |
285953 | 285953 | 2020-06-29 | Harrison | Ohio | 39067 | 12 | 1 |
289103 | 289103 | 2020-06-30 | Harrison | Ohio | 39067 | 12 | 1 |
292255 | 292255 | 2020-07-01 | Harrison | Ohio | 39067 | 12 | 1 |
295410 | 295410 | 2020-07-02 | Harrison | Ohio | 39067 | 12 | 1 |
298570 | 298570 | 2020-07-03 | Harrison | Ohio | 39067 | 12 | 1 |
301733 | 301733 | 2020-07-04 | Harrison | Ohio | 39067 | 12 | 1 |
304896 | 304896 | 2020-07-05 | Harrison | Ohio | 39067 | 12 | 1 |
308063 | 308063 | 2020-07-06 | Harrison | Ohio | 39067 | 12 | 1 |
311232 | 311232 | 2020-07-07 | Harrison | Ohio | 39067 | 12 | 1 |
314404 | 314404 | 2020-07-08 | Harrison | Ohio | 39067 | 12 | 1 |
317577 | 317577 | 2020-07-09 | Harrison | Ohio | 39067 | 12 | 1 |
320754 | 320754 | 2020-07-10 | Harrison | Ohio | 39067 | 12 | 1 |
323934 | 323934 | 2020-07-11 | Harrison | Ohio | 39067 | 13 | 1 |
327119 | 327119 | 2020-07-12 | Harrison | Ohio | 39067 | 14 | 1 |
330306 | 330306 | 2020-07-13 | Harrison | Ohio | 39067 | 13 | 1 |
333498 | 333498 | 2020-07-14 | Harrison | Ohio | 39067 | 13 | 1 |
336692 | 336692 | 2020-07-15 | Harrison | Ohio | 39067 | 13 | 1 |
339888 | 339888 | 2020-07-16 | Harrison | Ohio | 39067 | 16 | 1 |
343086 | 343086 | 2020-07-17 | Harrison | Ohio | 39067 | 16 | 1 |
346285 | 346285 | 2020-07-18 | Harrison | Ohio | 39067 | 16 | 1 |
349486 | 349486 | 2020-07-19 | Harrison | Ohio | 39067 | 16 | 1 |
352689 | 352689 | 2020-07-20 | Harrison | Ohio | 39067 | 16 | 1 |
355892 | 355892 | 2020-07-21 | Harrison | Ohio | 39067 | 14 | 1 |
359096 | 359096 | 2020-07-22 | Harrison | Ohio | 39067 | 14 | 1 |
362302 | 362302 | 2020-07-23 | Harrison | Ohio | 39067 | 15 | 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);