ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
770 rows where county = "Adams" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387977 | 387977 | 2020-07-31 | Adams | Ohio | 39001 | 53 | 2 |
384760 | 384760 | 2020-07-30 | Adams | Ohio | 39001 | 53 | 2 |
381542 | 381542 | 2020-07-29 | Adams | Ohio | 39001 | 51 | 2 |
378325 | 378325 | 2020-07-28 | Adams | Ohio | 39001 | 48 | 2 |
375108 | 375108 | 2020-07-27 | Adams | Ohio | 39001 | 44 | 2 |
371896 | 371896 | 2020-07-26 | Adams | Ohio | 39001 | 42 | 2 |
368684 | 368684 | 2020-07-25 | Adams | Ohio | 39001 | 40 | 2 |
365475 | 365475 | 2020-07-24 | Adams | Ohio | 39001 | 40 | 2 |
362269 | 362269 | 2020-07-23 | Adams | Ohio | 39001 | 40 | 2 |
359063 | 359063 | 2020-07-22 | Adams | Ohio | 39001 | 39 | 2 |
355859 | 355859 | 2020-07-21 | Adams | Ohio | 39001 | 37 | 2 |
352656 | 352656 | 2020-07-20 | Adams | Ohio | 39001 | 35 | 2 |
349453 | 349453 | 2020-07-19 | Adams | Ohio | 39001 | 34 | 2 |
346252 | 346252 | 2020-07-18 | Adams | Ohio | 39001 | 32 | 2 |
343053 | 343053 | 2020-07-17 | Adams | Ohio | 39001 | 30 | 2 |
339855 | 339855 | 2020-07-16 | Adams | Ohio | 39001 | 30 | 2 |
336659 | 336659 | 2020-07-15 | Adams | Ohio | 39001 | 30 | 2 |
333465 | 333465 | 2020-07-14 | Adams | Ohio | 39001 | 28 | 2 |
330273 | 330273 | 2020-07-13 | Adams | Ohio | 39001 | 28 | 2 |
327086 | 327086 | 2020-07-12 | Adams | Ohio | 39001 | 26 | 1 |
323901 | 323901 | 2020-07-11 | Adams | Ohio | 39001 | 26 | 1 |
320721 | 320721 | 2020-07-10 | Adams | Ohio | 39001 | 25 | 1 |
317544 | 317544 | 2020-07-09 | Adams | Ohio | 39001 | 24 | 1 |
314371 | 314371 | 2020-07-08 | Adams | Ohio | 39001 | 24 | 1 |
311199 | 311199 | 2020-07-07 | Adams | Ohio | 39001 | 24 | 1 |
308030 | 308030 | 2020-07-06 | Adams | Ohio | 39001 | 24 | 1 |
304863 | 304863 | 2020-07-05 | Adams | Ohio | 39001 | 22 | 1 |
301700 | 301700 | 2020-07-04 | Adams | Ohio | 39001 | 23 | 1 |
298537 | 298537 | 2020-07-03 | Adams | Ohio | 39001 | 22 | 1 |
295377 | 295377 | 2020-07-02 | Adams | Ohio | 39001 | 21 | 1 |
292222 | 292222 | 2020-07-01 | Adams | Ohio | 39001 | 21 | 1 |
289070 | 289070 | 2020-06-30 | Adams | Ohio | 39001 | 21 | 1 |
285920 | 285920 | 2020-06-29 | Adams | Ohio | 39001 | 21 | 1 |
282775 | 282775 | 2020-06-28 | Adams | Ohio | 39001 | 20 | 1 |
279629 | 279629 | 2020-06-27 | Adams | Ohio | 39001 | 20 | 1 |
276481 | 276481 | 2020-06-26 | Adams | Ohio | 39001 | 20 | 1 |
273334 | 273334 | 2020-06-25 | Adams | Ohio | 39001 | 20 | 1 |
270195 | 270195 | 2020-06-24 | Adams | Ohio | 39001 | 19 | 1 |
267061 | 267061 | 2020-06-23 | Adams | Ohio | 39001 | 19 | 1 |
263933 | 263933 | 2020-06-22 | Adams | Ohio | 39001 | 19 | 1 |
260805 | 260805 | 2020-06-21 | Adams | Ohio | 39001 | 18 | 1 |
257678 | 257678 | 2020-06-20 | Adams | Ohio | 39001 | 18 | 1 |
254553 | 254553 | 2020-06-19 | Adams | Ohio | 39001 | 18 | 1 |
251438 | 251438 | 2020-06-18 | Adams | Ohio | 39001 | 18 | 1 |
248323 | 248323 | 2020-06-17 | Adams | Ohio | 39001 | 17 | 1 |
245210 | 245210 | 2020-06-16 | Adams | Ohio | 39001 | 17 | 1 |
242098 | 242098 | 2020-06-15 | Adams | Ohio | 39001 | 15 | 1 |
238989 | 238989 | 2020-06-14 | Adams | Ohio | 39001 | 15 | 1 |
235881 | 235881 | 2020-06-13 | Adams | Ohio | 39001 | 14 | 1 |
232776 | 232776 | 2020-06-12 | Adams | Ohio | 39001 | 12 | 1 |
229671 | 229671 | 2020-06-11 | Adams | Ohio | 39001 | 12 | 1 |
226567 | 226567 | 2020-06-10 | Adams | Ohio | 39001 | 12 | 1 |
223467 | 223467 | 2020-06-09 | Adams | Ohio | 39001 | 11 | 1 |
220372 | 220372 | 2020-06-08 | Adams | Ohio | 39001 | 11 | 1 |
217280 | 217280 | 2020-06-07 | Adams | Ohio | 39001 | 11 | 1 |
214190 | 214190 | 2020-06-06 | Adams | Ohio | 39001 | 11 | 1 |
211104 | 211104 | 2020-06-05 | Adams | Ohio | 39001 | 11 | 1 |
208022 | 208022 | 2020-06-04 | Adams | Ohio | 39001 | 11 | 1 |
204941 | 204941 | 2020-06-03 | Adams | Ohio | 39001 | 10 | 1 |
201864 | 201864 | 2020-06-02 | Adams | Ohio | 39001 | 10 | 1 |
198789 | 198789 | 2020-06-01 | Adams | Ohio | 39001 | 10 | 1 |
195716 | 195716 | 2020-05-31 | Adams | Ohio | 39001 | 10 | 1 |
192646 | 192646 | 2020-05-30 | Adams | Ohio | 39001 | 9 | 1 |
189582 | 189582 | 2020-05-29 | Adams | Ohio | 39001 | 9 | 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 |
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 |
150108 | 150108 | 2020-05-16 | Adams | Ohio | 39001 | 8 | 0 |
147101 | 147101 | 2020-05-15 | Adams | Ohio | 39001 | 8 | 0 |
144100 | 144100 | 2020-05-14 | Adams | Ohio | 39001 | 7 | 0 |
141105 | 141105 | 2020-05-13 | Adams | Ohio | 39001 | 6 | 0 |
138109 | 138109 | 2020-05-12 | Adams | Ohio | 39001 | 6 | 0 |
135119 | 135119 | 2020-05-11 | Adams | Ohio | 39001 | 6 | 0 |
132128 | 132128 | 2020-05-10 | Adams | Ohio | 39001 | 6 | 0 |
129139 | 129139 | 2020-05-09 | Adams | Ohio | 39001 | 6 | 0 |
126150 | 126150 | 2020-05-08 | Adams | Ohio | 39001 | 5 | 0 |
123167 | 123167 | 2020-05-07 | Adams | Ohio | 39001 | 5 | 0 |
120190 | 120190 | 2020-05-06 | Adams | Ohio | 39001 | 5 | 0 |
117229 | 117229 | 2020-05-05 | Adams | Ohio | 39001 | 5 | 0 |
114348 | 114348 | 2020-05-04 | Adams | Ohio | 39001 | 5 | 0 |
111467 | 111467 | 2020-05-03 | Adams | Ohio | 39001 | 5 | 0 |
108593 | 108593 | 2020-05-02 | Adams | Ohio | 39001 | 5 | 0 |
105726 | 105726 | 2020-05-01 | Adams | Ohio | 39001 | 5 | 0 |
102863 | 102863 | 2020-04-30 | Adams | Ohio | 39001 | 4 | 0 |
100010 | 100010 | 2020-04-29 | Adams | Ohio | 39001 | 5 | 0 |
97161 | 97161 | 2020-04-28 | Adams | Ohio | 39001 | 4 | 0 |
94324 | 94324 | 2020-04-27 | Adams | Ohio | 39001 | 4 | 0 |
91498 | 91498 | 2020-04-26 | Adams | Ohio | 39001 | 4 | 0 |
88682 | 88682 | 2020-04-25 | Adams | Ohio | 39001 | 4 | 0 |
85868 | 85868 | 2020-04-24 | Adams | Ohio | 39001 | 4 | 0 |
83064 | 83064 | 2020-04-23 | Adams | Ohio | 39001 | 4 | 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);