ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 39017 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536484 | 536484 | 2020-09-15 | Butler | Ohio | 39017 | 5366 | 94 |
533248 | 533248 | 2020-09-14 | Butler | Ohio | 39017 | 5315 | 88 |
530013 | 530013 | 2020-09-13 | Butler | Ohio | 39017 | 5266 | 88 |
526776 | 526776 | 2020-09-12 | Butler | Ohio | 39017 | 5217 | 88 |
523540 | 523540 | 2020-09-11 | Butler | Ohio | 39017 | 5124 | 87 |
520304 | 520304 | 2020-09-10 | Butler | Ohio | 39017 | 5009 | 85 |
517068 | 517068 | 2020-09-09 | Butler | Ohio | 39017 | 4906 | 81 |
513833 | 513833 | 2020-09-08 | Butler | Ohio | 39017 | 4837 | 81 |
510600 | 510600 | 2020-09-07 | Butler | Ohio | 39017 | 4799 | 80 |
507367 | 507367 | 2020-09-06 | Butler | Ohio | 39017 | 4769 | 80 |
504135 | 504135 | 2020-09-05 | Butler | Ohio | 39017 | 4702 | 80 |
500901 | 500901 | 2020-09-04 | Butler | Ohio | 39017 | 4621 | 80 |
497667 | 497667 | 2020-09-03 | Butler | Ohio | 39017 | 4477 | 78 |
494434 | 494434 | 2020-09-02 | Butler | Ohio | 39017 | 4308 | 75 |
491200 | 491200 | 2020-09-01 | Butler | Ohio | 39017 | 4147 | 74 |
487967 | 487967 | 2020-08-31 | Butler | Ohio | 39017 | 4029 | 73 |
484734 | 484734 | 2020-08-30 | Butler | Ohio | 39017 | 3972 | 73 |
481499 | 481499 | 2020-08-29 | Butler | Ohio | 39017 | 3900 | 73 |
478265 | 478265 | 2020-08-28 | Butler | Ohio | 39017 | 3798 | 73 |
475032 | 475032 | 2020-08-27 | Butler | Ohio | 39017 | 3686 | 73 |
471798 | 471798 | 2020-08-26 | Butler | Ohio | 39017 | 3613 | 72 |
468566 | 468566 | 2020-08-25 | Butler | Ohio | 39017 | 3536 | 69 |
465338 | 465338 | 2020-08-24 | Butler | Ohio | 39017 | 3478 | 69 |
462109 | 462109 | 2020-08-23 | Butler | Ohio | 39017 | 3459 | 69 |
458881 | 458881 | 2020-08-22 | Butler | Ohio | 39017 | 3426 | 69 |
455653 | 455653 | 2020-08-21 | Butler | Ohio | 39017 | 3374 | 69 |
452425 | 452425 | 2020-08-20 | Butler | Ohio | 39017 | 3333 | 69 |
449197 | 449197 | 2020-08-19 | Butler | Ohio | 39017 | 3301 | 69 |
445969 | 445969 | 2020-08-18 | Butler | Ohio | 39017 | 3265 | 69 |
442743 | 442743 | 2020-08-17 | Butler | Ohio | 39017 | 3218 | 69 |
439516 | 439516 | 2020-08-16 | Butler | Ohio | 39017 | 3197 | 69 |
436291 | 436291 | 2020-08-15 | Butler | Ohio | 39017 | 3164 | 69 |
433065 | 433065 | 2020-08-14 | Butler | Ohio | 39017 | 3105 | 69 |
429839 | 429839 | 2020-08-13 | Butler | Ohio | 39017 | 3070 | 64 |
426614 | 426614 | 2020-08-12 | Butler | Ohio | 39017 | 3033 | 64 |
423391 | 423391 | 2020-08-11 | Butler | Ohio | 39017 | 2976 | 63 |
420168 | 420168 | 2020-08-10 | Butler | Ohio | 39017 | 2944 | 63 |
416948 | 416948 | 2020-08-09 | Butler | Ohio | 39017 | 2929 | 63 |
413727 | 413727 | 2020-08-08 | Butler | Ohio | 39017 | 2891 | 63 |
410507 | 410507 | 2020-08-07 | Butler | Ohio | 39017 | 2861 | 63 |
407287 | 407287 | 2020-08-06 | Butler | Ohio | 39017 | 2822 | 62 |
404068 | 404068 | 2020-08-05 | Butler | Ohio | 39017 | 2778 | 61 |
400850 | 400850 | 2020-08-04 | Butler | Ohio | 39017 | 2743 | 60 |
397635 | 397635 | 2020-08-03 | Butler | Ohio | 39017 | 2714 | 59 |
394418 | 394418 | 2020-08-02 | Butler | Ohio | 39017 | 2683 | 59 |
391202 | 391202 | 2020-08-01 | Butler | Ohio | 39017 | 2652 | 59 |
387985 | 387985 | 2020-07-31 | Butler | Ohio | 39017 | 2619 | 59 |
384768 | 384768 | 2020-07-30 | Butler | Ohio | 39017 | 2605 | 58 |
381550 | 381550 | 2020-07-29 | Butler | Ohio | 39017 | 2517 | 58 |
378333 | 378333 | 2020-07-28 | Butler | Ohio | 39017 | 2476 | 57 |
375116 | 375116 | 2020-07-27 | Butler | Ohio | 39017 | 2455 | 56 |
371904 | 371904 | 2020-07-26 | Butler | Ohio | 39017 | 2418 | 54 |
368692 | 368692 | 2020-07-25 | Butler | Ohio | 39017 | 2382 | 54 |
365483 | 365483 | 2020-07-24 | Butler | Ohio | 39017 | 2347 | 54 |
362277 | 362277 | 2020-07-23 | Butler | Ohio | 39017 | 2269 | 53 |
359071 | 359071 | 2020-07-22 | Butler | Ohio | 39017 | 2230 | 52 |
355867 | 355867 | 2020-07-21 | Butler | Ohio | 39017 | 2182 | 51 |
352664 | 352664 | 2020-07-20 | Butler | Ohio | 39017 | 2143 | 51 |
349461 | 349461 | 2020-07-19 | Butler | Ohio | 39017 | 2114 | 51 |
346260 | 346260 | 2020-07-18 | Butler | Ohio | 39017 | 2091 | 51 |
343061 | 343061 | 2020-07-17 | Butler | Ohio | 39017 | 2063 | 49 |
339863 | 339863 | 2020-07-16 | Butler | Ohio | 39017 | 2012 | 48 |
336667 | 336667 | 2020-07-15 | Butler | Ohio | 39017 | 1975 | 47 |
333473 | 333473 | 2020-07-14 | Butler | Ohio | 39017 | 1942 | 47 |
330281 | 330281 | 2020-07-13 | Butler | Ohio | 39017 | 1897 | 47 |
327094 | 327094 | 2020-07-12 | Butler | Ohio | 39017 | 1863 | 47 |
323909 | 323909 | 2020-07-11 | Butler | Ohio | 39017 | 1821 | 47 |
320729 | 320729 | 2020-07-10 | Butler | Ohio | 39017 | 1767 | 47 |
317552 | 317552 | 2020-07-09 | Butler | Ohio | 39017 | 1721 | 47 |
314379 | 314379 | 2020-07-08 | Butler | Ohio | 39017 | 1674 | 47 |
311207 | 311207 | 2020-07-07 | Butler | Ohio | 39017 | 1637 | 47 |
308038 | 308038 | 2020-07-06 | Butler | Ohio | 39017 | 1599 | 44 |
304871 | 304871 | 2020-07-05 | Butler | Ohio | 39017 | 1576 | 44 |
301708 | 301708 | 2020-07-04 | Butler | Ohio | 39017 | 1547 | 44 |
298545 | 298545 | 2020-07-03 | Butler | Ohio | 39017 | 1511 | 44 |
295385 | 295385 | 2020-07-02 | Butler | Ohio | 39017 | 1448 | 44 |
292230 | 292230 | 2020-07-01 | Butler | Ohio | 39017 | 1448 | 44 |
289078 | 289078 | 2020-06-30 | Butler | Ohio | 39017 | 1405 | 44 |
285928 | 285928 | 2020-06-29 | Butler | Ohio | 39017 | 1388 | 44 |
282783 | 282783 | 2020-06-28 | Butler | Ohio | 39017 | 1371 | 44 |
279637 | 279637 | 2020-06-27 | Butler | Ohio | 39017 | 1350 | 44 |
276489 | 276489 | 2020-06-26 | Butler | Ohio | 39017 | 1322 | 43 |
273342 | 273342 | 2020-06-25 | Butler | Ohio | 39017 | 1301 | 41 |
270203 | 270203 | 2020-06-24 | Butler | Ohio | 39017 | 1269 | 40 |
267069 | 267069 | 2020-06-23 | Butler | Ohio | 39017 | 1248 | 39 |
263941 | 263941 | 2020-06-22 | Butler | Ohio | 39017 | 1223 | 39 |
260813 | 260813 | 2020-06-21 | Butler | Ohio | 39017 | 1201 | 39 |
257686 | 257686 | 2020-06-20 | Butler | Ohio | 39017 | 1194 | 39 |
254561 | 254561 | 2020-06-19 | Butler | Ohio | 39017 | 1166 | 37 |
251446 | 251446 | 2020-06-18 | Butler | Ohio | 39017 | 1153 | 36 |
248331 | 248331 | 2020-06-17 | Butler | Ohio | 39017 | 1129 | 35 |
245218 | 245218 | 2020-06-16 | Butler | Ohio | 39017 | 1120 | 35 |
242106 | 242106 | 2020-06-15 | Butler | Ohio | 39017 | 1103 | 34 |
238997 | 238997 | 2020-06-14 | Butler | Ohio | 39017 | 1090 | 34 |
235889 | 235889 | 2020-06-13 | Butler | Ohio | 39017 | 1080 | 33 |
232784 | 232784 | 2020-06-12 | Butler | Ohio | 39017 | 1065 | 33 |
229679 | 229679 | 2020-06-11 | Butler | Ohio | 39017 | 1048 | 33 |
226575 | 226575 | 2020-06-10 | Butler | Ohio | 39017 | 1045 | 32 |
223475 | 223475 | 2020-06-09 | Butler | Ohio | 39017 | 1034 | 32 |
220380 | 220380 | 2020-06-08 | Butler | Ohio | 39017 | 1013 | 32 |
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);