ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39165 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922579 | 922579 | 2021-01-12 | Warren | Ohio | 39165 | 18095 | 130 |
919334 | 919334 | 2021-01-11 | Warren | Ohio | 39165 | 17861 | 128 |
916089 | 916089 | 2021-01-10 | Warren | Ohio | 39165 | 17737 | 128 |
912844 | 912844 | 2021-01-09 | Warren | Ohio | 39165 | 17562 | 128 |
909599 | 909599 | 2021-01-08 | Warren | Ohio | 39165 | 17396 | 127 |
906354 | 906354 | 2021-01-07 | Warren | Ohio | 39165 | 17135 | 124 |
903108 | 903108 | 2021-01-06 | Warren | Ohio | 39165 | 16873 | 124 |
899863 | 899863 | 2021-01-05 | Warren | Ohio | 39165 | 16620 | 124 |
896618 | 896618 | 2021-01-04 | Warren | Ohio | 39165 | 16387 | 122 |
893372 | 893372 | 2021-01-03 | Warren | Ohio | 39165 | 16262 | 122 |
890126 | 890126 | 2021-01-02 | Warren | Ohio | 39165 | 16139 | 121 |
886879 | 886879 | 2021-01-01 | Warren | Ohio | 39165 | 15752 | 121 |
883634 | 883634 | 2020-12-31 | Warren | Ohio | 39165 | 15752 | 121 |
880389 | 880389 | 2020-12-30 | Warren | Ohio | 39165 | 15502 | 120 |
877144 | 877144 | 2020-12-29 | Warren | Ohio | 39165 | 15242 | 119 |
873899 | 873899 | 2020-12-28 | Warren | Ohio | 39165 | 15023 | 116 |
870654 | 870654 | 2020-12-27 | Warren | Ohio | 39165 | 14921 | 116 |
867409 | 867409 | 2020-12-26 | Warren | Ohio | 39165 | 14742 | 116 |
864164 | 864164 | 2020-12-25 | Warren | Ohio | 39165 | 14490 | 113 |
860919 | 860919 | 2020-12-24 | Warren | Ohio | 39165 | 14490 | 113 |
857674 | 857674 | 2020-12-23 | Warren | Ohio | 39165 | 14279 | 109 |
854429 | 854429 | 2020-12-22 | Warren | Ohio | 39165 | 14104 | 109 |
851184 | 851184 | 2020-12-21 | Warren | Ohio | 39165 | 13918 | 106 |
847939 | 847939 | 2020-12-20 | Warren | Ohio | 39165 | 13800 | 105 |
844694 | 844694 | 2020-12-19 | Warren | Ohio | 39165 | 13610 | 105 |
841448 | 841448 | 2020-12-18 | Warren | Ohio | 39165 | 13372 | 103 |
838203 | 838203 | 2020-12-17 | Warren | Ohio | 39165 | 13156 | 101 |
834957 | 834957 | 2020-12-16 | Warren | Ohio | 39165 | 12889 | 100 |
831711 | 831711 | 2020-12-15 | Warren | Ohio | 39165 | 12739 | 100 |
828464 | 828464 | 2020-12-14 | Warren | Ohio | 39165 | 12501 | 95 |
825218 | 825218 | 2020-12-13 | Warren | Ohio | 39165 | 12362 | 95 |
821971 | 821971 | 2020-12-12 | Warren | Ohio | 39165 | 12189 | 95 |
818725 | 818725 | 2020-12-11 | Warren | Ohio | 39165 | 11970 | 95 |
815479 | 815479 | 2020-12-10 | Warren | Ohio | 39165 | 11705 | 92 |
812233 | 812233 | 2020-12-09 | Warren | Ohio | 39165 | 11480 | 90 |
808989 | 808989 | 2020-12-08 | Warren | Ohio | 39165 | 11240 | 89 |
805744 | 805744 | 2020-12-07 | Warren | Ohio | 39165 | 10708 | 88 |
802499 | 802499 | 2020-12-06 | Warren | Ohio | 39165 | 10573 | 87 |
799254 | 799254 | 2020-12-05 | Warren | Ohio | 39165 | 10404 | 86 |
796009 | 796009 | 2020-12-04 | Warren | Ohio | 39165 | 10193 | 86 |
792764 | 792764 | 2020-12-03 | Warren | Ohio | 39165 | 9943 | 81 |
789519 | 789519 | 2020-12-02 | Warren | Ohio | 39165 | 9704 | 79 |
786274 | 786274 | 2020-12-01 | Warren | Ohio | 39165 | 9500 | 79 |
783030 | 783030 | 2020-11-30 | Warren | Ohio | 39165 | 9263 | 77 |
779784 | 779784 | 2020-11-29 | Warren | Ohio | 39165 | 9090 | 77 |
776539 | 776539 | 2020-11-28 | Warren | Ohio | 39165 | 8921 | 77 |
773294 | 773294 | 2020-11-27 | Warren | Ohio | 39165 | 8787 | 77 |
770049 | 770049 | 2020-11-26 | Warren | Ohio | 39165 | 8419 | 76 |
766803 | 766803 | 2020-11-25 | Warren | Ohio | 39165 | 8419 | 76 |
763558 | 763558 | 2020-11-24 | Warren | Ohio | 39165 | 8191 | 75 |
760313 | 760313 | 2020-11-23 | Warren | Ohio | 39165 | 7989 | 75 |
757068 | 757068 | 2020-11-22 | Warren | Ohio | 39165 | 7703 | 75 |
753821 | 753821 | 2020-11-21 | Warren | Ohio | 39165 | 7543 | 75 |
750575 | 750575 | 2020-11-20 | Warren | Ohio | 39165 | 7373 | 74 |
747329 | 747329 | 2020-11-19 | Warren | Ohio | 39165 | 7169 | 74 |
744083 | 744083 | 2020-11-18 | Warren | Ohio | 39165 | 7031 | 73 |
740836 | 740836 | 2020-11-17 | Warren | Ohio | 39165 | 6912 | 72 |
737590 | 737590 | 2020-11-16 | Warren | Ohio | 39165 | 6751 | 72 |
734346 | 734346 | 2020-11-15 | Warren | Ohio | 39165 | 6538 | 72 |
731100 | 731100 | 2020-11-14 | Warren | Ohio | 39165 | 6387 | 72 |
727856 | 727856 | 2020-11-13 | Warren | Ohio | 39165 | 6225 | 72 |
724612 | 724612 | 2020-11-12 | Warren | Ohio | 39165 | 6039 | 72 |
721369 | 721369 | 2020-11-11 | Warren | Ohio | 39165 | 5923 | 72 |
718126 | 718126 | 2020-11-10 | Warren | Ohio | 39165 | 5810 | 70 |
714883 | 714883 | 2020-11-09 | Warren | Ohio | 39165 | 5666 | 70 |
711639 | 711639 | 2020-11-08 | Warren | Ohio | 39165 | 5590 | 70 |
708395 | 708395 | 2020-11-07 | Warren | Ohio | 39165 | 5522 | 70 |
705152 | 705152 | 2020-11-06 | Warren | Ohio | 39165 | 5375 | 70 |
701909 | 701909 | 2020-11-05 | Warren | Ohio | 39165 | 5264 | 70 |
698665 | 698665 | 2020-11-04 | Warren | Ohio | 39165 | 5157 | 69 |
695422 | 695422 | 2020-11-03 | Warren | Ohio | 39165 | 5084 | 68 |
692180 | 692180 | 2020-11-02 | Warren | Ohio | 39165 | 4980 | 68 |
688936 | 688936 | 2020-11-01 | Warren | Ohio | 39165 | 4921 | 67 |
685691 | 685691 | 2020-10-31 | Warren | Ohio | 39165 | 4853 | 67 |
682448 | 682448 | 2020-10-30 | Warren | Ohio | 39165 | 4780 | 67 |
679205 | 679205 | 2020-10-29 | Warren | Ohio | 39165 | 4711 | 66 |
675962 | 675962 | 2020-10-28 | Warren | Ohio | 39165 | 4612 | 66 |
672719 | 672719 | 2020-10-27 | Warren | Ohio | 39165 | 4541 | 66 |
669477 | 669477 | 2020-10-26 | Warren | Ohio | 39165 | 4465 | 66 |
666233 | 666233 | 2020-10-25 | Warren | Ohio | 39165 | 4410 | 66 |
662988 | 662988 | 2020-10-24 | Warren | Ohio | 39165 | 4359 | 66 |
659744 | 659744 | 2020-10-23 | Warren | Ohio | 39165 | 4284 | 66 |
656500 | 656500 | 2020-10-22 | Warren | Ohio | 39165 | 4200 | 64 |
653255 | 653255 | 2020-10-21 | Warren | Ohio | 39165 | 4135 | 63 |
650010 | 650010 | 2020-10-20 | Warren | Ohio | 39165 | 4063 | 60 |
646766 | 646766 | 2020-10-19 | Warren | Ohio | 39165 | 3981 | 60 |
643520 | 643520 | 2020-10-18 | Warren | Ohio | 39165 | 3933 | 60 |
640272 | 640272 | 2020-10-17 | Warren | Ohio | 39165 | 3879 | 60 |
637026 | 637026 | 2020-10-16 | Warren | Ohio | 39165 | 3799 | 60 |
633780 | 633780 | 2020-10-15 | Warren | Ohio | 39165 | 3735 | 59 |
630535 | 630535 | 2020-10-14 | Warren | Ohio | 39165 | 3679 | 59 |
627291 | 627291 | 2020-10-13 | Warren | Ohio | 39165 | 3606 | 59 |
624049 | 624049 | 2020-10-12 | Warren | Ohio | 39165 | 3564 | 59 |
620806 | 620806 | 2020-10-11 | Warren | Ohio | 39165 | 3543 | 59 |
617564 | 617564 | 2020-10-10 | Warren | Ohio | 39165 | 3514 | 59 |
614322 | 614322 | 2020-10-09 | Warren | Ohio | 39165 | 3468 | 59 |
611081 | 611081 | 2020-10-08 | Warren | Ohio | 39165 | 3414 | 59 |
607839 | 607839 | 2020-10-07 | Warren | Ohio | 39165 | 3365 | 59 |
604596 | 604596 | 2020-10-06 | Warren | Ohio | 39165 | 3324 | 58 |
601354 | 601354 | 2020-10-05 | Warren | Ohio | 39165 | 3271 | 58 |
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);