ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 39059 and state = "Ohio" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
27633 | 27633 | 2020-04-02 | Guernsey | Ohio | 39059 | 1 | 0 |
29962 | 29962 | 2020-04-03 | Guernsey | Ohio | 39059 | 1 | 0 |
32351 | 32351 | 2020-04-04 | Guernsey | Ohio | 39059 | 1 | 0 |
34784 | 34784 | 2020-04-05 | Guernsey | Ohio | 39059 | 1 | 0 |
37253 | 37253 | 2020-04-06 | Guernsey | Ohio | 39059 | 1 | 0 |
39770 | 39770 | 2020-04-07 | Guernsey | Ohio | 39059 | 1 | 0 |
42328 | 42328 | 2020-04-08 | Guernsey | Ohio | 39059 | 2 | 0 |
44913 | 44913 | 2020-04-09 | Guernsey | Ohio | 39059 | 4 | 0 |
47528 | 47528 | 2020-04-10 | Guernsey | Ohio | 39059 | 5 | 0 |
50183 | 50183 | 2020-04-11 | Guernsey | Ohio | 39059 | 5 | 0 |
52856 | 52856 | 2020-04-12 | Guernsey | Ohio | 39059 | 6 | 0 |
55540 | 55540 | 2020-04-13 | Guernsey | Ohio | 39059 | 6 | 0 |
58241 | 58241 | 2020-04-14 | Guernsey | Ohio | 39059 | 7 | 0 |
60955 | 60955 | 2020-04-15 | Guernsey | Ohio | 39059 | 10 | 0 |
63681 | 63681 | 2020-04-16 | Guernsey | Ohio | 39059 | 10 | 0 |
66424 | 66424 | 2020-04-17 | Guernsey | Ohio | 39059 | 10 | 0 |
69181 | 69181 | 2020-04-18 | Guernsey | Ohio | 39059 | 10 | 0 |
71948 | 71948 | 2020-04-19 | Guernsey | Ohio | 39059 | 11 | 0 |
74723 | 74723 | 2020-04-20 | Guernsey | Ohio | 39059 | 12 | 0 |
77504 | 77504 | 2020-04-21 | Guernsey | Ohio | 39059 | 12 | 0 |
80294 | 80294 | 2020-04-22 | Guernsey | Ohio | 39059 | 15 | 0 |
83093 | 83093 | 2020-04-23 | Guernsey | Ohio | 39059 | 15 | 0 |
85897 | 85897 | 2020-04-24 | Guernsey | Ohio | 39059 | 15 | 0 |
88711 | 88711 | 2020-04-25 | Guernsey | Ohio | 39059 | 15 | 0 |
91527 | 91527 | 2020-04-26 | Guernsey | Ohio | 39059 | 15 | 0 |
94353 | 94353 | 2020-04-27 | Guernsey | Ohio | 39059 | 15 | 0 |
97190 | 97190 | 2020-04-28 | Guernsey | Ohio | 39059 | 15 | 0 |
100039 | 100039 | 2020-04-29 | Guernsey | Ohio | 39059 | 15 | 0 |
102892 | 102892 | 2020-04-30 | Guernsey | Ohio | 39059 | 15 | 0 |
105755 | 105755 | 2020-05-01 | Guernsey | Ohio | 39059 | 15 | 0 |
108622 | 108622 | 2020-05-02 | Guernsey | Ohio | 39059 | 16 | 0 |
111496 | 111496 | 2020-05-03 | Guernsey | Ohio | 39059 | 19 | 0 |
114377 | 114377 | 2020-05-04 | Guernsey | Ohio | 39059 | 19 | 0 |
117258 | 117258 | 2020-05-05 | Guernsey | Ohio | 39059 | 19 | 0 |
120219 | 120219 | 2020-05-06 | Guernsey | Ohio | 39059 | 20 | 0 |
123196 | 123196 | 2020-05-07 | Guernsey | Ohio | 39059 | 20 | 0 |
126179 | 126179 | 2020-05-08 | Guernsey | Ohio | 39059 | 20 | 0 |
129168 | 129168 | 2020-05-09 | Guernsey | Ohio | 39059 | 21 | 0 |
132157 | 132157 | 2020-05-10 | Guernsey | Ohio | 39059 | 21 | 0 |
135148 | 135148 | 2020-05-11 | Guernsey | Ohio | 39059 | 21 | 0 |
138138 | 138138 | 2020-05-12 | Guernsey | Ohio | 39059 | 21 | 0 |
141134 | 141134 | 2020-05-13 | Guernsey | Ohio | 39059 | 21 | 0 |
144129 | 144129 | 2020-05-14 | Guernsey | Ohio | 39059 | 22 | 0 |
147130 | 147130 | 2020-05-15 | Guernsey | Ohio | 39059 | 22 | 0 |
150137 | 150137 | 2020-05-16 | Guernsey | Ohio | 39059 | 24 | 0 |
153148 | 153148 | 2020-05-17 | Guernsey | Ohio | 39059 | 24 | 0 |
156165 | 156165 | 2020-05-18 | Guernsey | Ohio | 39059 | 25 | 0 |
159185 | 159185 | 2020-05-19 | Guernsey | Ohio | 39059 | 26 | 0 |
162212 | 162212 | 2020-05-20 | Guernsey | Ohio | 39059 | 28 | 0 |
165241 | 165241 | 2020-05-21 | Guernsey | Ohio | 39059 | 29 | 0 |
168277 | 168277 | 2020-05-22 | Guernsey | Ohio | 39059 | 29 | 0 |
171316 | 171316 | 2020-05-23 | Guernsey | Ohio | 39059 | 30 | 0 |
174358 | 174358 | 2020-05-24 | Guernsey | Ohio | 39059 | 31 | 0 |
177402 | 177402 | 2020-05-25 | Guernsey | Ohio | 39059 | 31 | 0 |
180445 | 180445 | 2020-05-26 | Guernsey | Ohio | 39059 | 32 | 0 |
183494 | 183494 | 2020-05-27 | Guernsey | Ohio | 39059 | 33 | 0 |
186551 | 186551 | 2020-05-28 | Guernsey | Ohio | 39059 | 34 | 0 |
189611 | 189611 | 2020-05-29 | Guernsey | Ohio | 39059 | 34 | 0 |
192675 | 192675 | 2020-05-30 | Guernsey | Ohio | 39059 | 35 | 1 |
195745 | 195745 | 2020-05-31 | Guernsey | Ohio | 39059 | 35 | 1 |
198818 | 198818 | 2020-06-01 | Guernsey | Ohio | 39059 | 36 | 1 |
201893 | 201893 | 2020-06-02 | Guernsey | Ohio | 39059 | 36 | 2 |
204970 | 204970 | 2020-06-03 | Guernsey | Ohio | 39059 | 36 | 2 |
208051 | 208051 | 2020-06-04 | Guernsey | Ohio | 39059 | 38 | 2 |
211133 | 211133 | 2020-06-05 | Guernsey | Ohio | 39059 | 38 | 2 |
214219 | 214219 | 2020-06-06 | Guernsey | Ohio | 39059 | 41 | 2 |
217309 | 217309 | 2020-06-07 | Guernsey | Ohio | 39059 | 42 | 2 |
220401 | 220401 | 2020-06-08 | Guernsey | Ohio | 39059 | 43 | 2 |
223496 | 223496 | 2020-06-09 | Guernsey | Ohio | 39059 | 44 | 2 |
226596 | 226596 | 2020-06-10 | Guernsey | Ohio | 39059 | 44 | 2 |
229700 | 229700 | 2020-06-11 | Guernsey | Ohio | 39059 | 44 | 2 |
232805 | 232805 | 2020-06-12 | Guernsey | Ohio | 39059 | 44 | 3 |
235910 | 235910 | 2020-06-13 | Guernsey | Ohio | 39059 | 44 | 3 |
239018 | 239018 | 2020-06-14 | Guernsey | Ohio | 39059 | 44 | 3 |
242127 | 242127 | 2020-06-15 | Guernsey | Ohio | 39059 | 44 | 3 |
245239 | 245239 | 2020-06-16 | Guernsey | Ohio | 39059 | 44 | 3 |
248352 | 248352 | 2020-06-17 | Guernsey | Ohio | 39059 | 44 | 3 |
251467 | 251467 | 2020-06-18 | Guernsey | Ohio | 39059 | 44 | 3 |
254582 | 254582 | 2020-06-19 | Guernsey | Ohio | 39059 | 44 | 3 |
257707 | 257707 | 2020-06-20 | Guernsey | Ohio | 39059 | 44 | 3 |
260834 | 260834 | 2020-06-21 | Guernsey | Ohio | 39059 | 45 | 3 |
263962 | 263962 | 2020-06-22 | Guernsey | Ohio | 39059 | 46 | 3 |
267090 | 267090 | 2020-06-23 | Guernsey | Ohio | 39059 | 46 | 3 |
270224 | 270224 | 2020-06-24 | Guernsey | Ohio | 39059 | 47 | 3 |
273363 | 273363 | 2020-06-25 | Guernsey | Ohio | 39059 | 49 | 3 |
276510 | 276510 | 2020-06-26 | Guernsey | Ohio | 39059 | 51 | 3 |
279658 | 279658 | 2020-06-27 | Guernsey | Ohio | 39059 | 51 | 3 |
282804 | 282804 | 2020-06-28 | Guernsey | Ohio | 39059 | 58 | 3 |
285949 | 285949 | 2020-06-29 | Guernsey | Ohio | 39059 | 59 | 3 |
289099 | 289099 | 2020-06-30 | Guernsey | Ohio | 39059 | 59 | 3 |
292251 | 292251 | 2020-07-01 | Guernsey | Ohio | 39059 | 60 | 3 |
295406 | 295406 | 2020-07-02 | Guernsey | Ohio | 39059 | 60 | 3 |
298566 | 298566 | 2020-07-03 | Guernsey | Ohio | 39059 | 67 | 3 |
301729 | 301729 | 2020-07-04 | Guernsey | Ohio | 39059 | 68 | 3 |
304892 | 304892 | 2020-07-05 | Guernsey | Ohio | 39059 | 70 | 3 |
308059 | 308059 | 2020-07-06 | Guernsey | Ohio | 39059 | 74 | 3 |
311228 | 311228 | 2020-07-07 | Guernsey | Ohio | 39059 | 74 | 3 |
314400 | 314400 | 2020-07-08 | Guernsey | Ohio | 39059 | 76 | 3 |
317573 | 317573 | 2020-07-09 | Guernsey | Ohio | 39059 | 76 | 3 |
320750 | 320750 | 2020-07-10 | Guernsey | Ohio | 39059 | 79 | 3 |
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);