ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Butler" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636952 | 636952 | 2020-10-16 | Butler | Ohio | 39017 | 7654 | 119 |
633706 | 633706 | 2020-10-15 | Butler | Ohio | 39017 | 7549 | 118 |
630461 | 630461 | 2020-10-14 | Butler | Ohio | 39017 | 7423 | 118 |
627217 | 627217 | 2020-10-13 | Butler | Ohio | 39017 | 7335 | 117 |
623975 | 623975 | 2020-10-12 | Butler | Ohio | 39017 | 7253 | 116 |
620732 | 620732 | 2020-10-11 | Butler | Ohio | 39017 | 7178 | 115 |
617490 | 617490 | 2020-10-10 | Butler | Ohio | 39017 | 7098 | 115 |
614248 | 614248 | 2020-10-09 | Butler | Ohio | 39017 | 7014 | 116 |
611007 | 611007 | 2020-10-08 | Butler | Ohio | 39017 | 6911 | 115 |
607765 | 607765 | 2020-10-07 | Butler | Ohio | 39017 | 6828 | 114 |
604522 | 604522 | 2020-10-06 | Butler | Ohio | 39017 | 6726 | 114 |
601280 | 601280 | 2020-10-05 | Butler | Ohio | 39017 | 6617 | 113 |
598037 | 598037 | 2020-10-04 | Butler | Ohio | 39017 | 6569 | 113 |
594794 | 594794 | 2020-10-03 | Butler | Ohio | 39017 | 6508 | 113 |
591553 | 591553 | 2020-10-02 | Butler | Ohio | 39017 | 6418 | 113 |
588312 | 588312 | 2020-10-01 | Butler | Ohio | 39017 | 6312 | 113 |
585072 | 585072 | 2020-09-30 | Butler | Ohio | 39017 | 6231 | 113 |
581832 | 581832 | 2020-09-29 | Butler | Ohio | 39017 | 6151 | 112 |
578592 | 578592 | 2020-09-28 | Butler | Ohio | 39017 | 6085 | 111 |
575351 | 575351 | 2020-09-27 | Butler | Ohio | 39017 | 6040 | 111 |
572107 | 572107 | 2020-09-26 | Butler | Ohio | 39017 | 6022 | 111 |
568865 | 568865 | 2020-09-25 | Butler | Ohio | 39017 | 5933 | 111 |
565624 | 565624 | 2020-09-24 | Butler | Ohio | 39017 | 5838 | 110 |
562383 | 562383 | 2020-09-23 | Butler | Ohio | 39017 | 5771 | 106 |
559146 | 559146 | 2020-09-22 | Butler | Ohio | 39017 | 5727 | 102 |
555909 | 555909 | 2020-09-21 | Butler | Ohio | 39017 | 5693 | 99 |
552672 | 552672 | 2020-09-20 | Butler | Ohio | 39017 | 5632 | 99 |
549433 | 549433 | 2020-09-19 | Butler | Ohio | 39017 | 5586 | 99 |
546194 | 546194 | 2020-09-18 | Butler | Ohio | 39017 | 5508 | 99 |
542957 | 542957 | 2020-09-17 | Butler | Ohio | 39017 | 5487 | 98 |
539721 | 539721 | 2020-09-16 | Butler | Ohio | 39017 | 5425 | 97 |
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 |
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);