ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Clermont", fips = 39025 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
948473 | 948473 | 2021-01-20 | Clermont | Ohio | 39025 | 15546 | 108 |
945227 | 945227 | 2021-01-19 | Clermont | Ohio | 39025 | 15335 | 105 |
941980 | 941980 | 2021-01-18 | Clermont | Ohio | 39025 | 15235 | 104 |
938735 | 938735 | 2021-01-17 | Clermont | Ohio | 39025 | 15160 | 104 |
935490 | 935490 | 2021-01-16 | Clermont | Ohio | 39025 | 15053 | 104 |
932245 | 932245 | 2021-01-15 | Clermont | Ohio | 39025 | 14881 | 103 |
929000 | 929000 | 2021-01-14 | Clermont | Ohio | 39025 | 14703 | 103 |
925755 | 925755 | 2021-01-13 | Clermont | Ohio | 39025 | 14558 | 102 |
922509 | 922509 | 2021-01-12 | Clermont | Ohio | 39025 | 14363 | 94 |
919264 | 919264 | 2021-01-11 | Clermont | Ohio | 39025 | 14238 | 93 |
916019 | 916019 | 2021-01-10 | Clermont | Ohio | 39025 | 14109 | 93 |
912774 | 912774 | 2021-01-09 | Clermont | Ohio | 39025 | 13900 | 93 |
909529 | 909529 | 2021-01-08 | Clermont | Ohio | 39025 | 13695 | 93 |
906284 | 906284 | 2021-01-07 | Clermont | Ohio | 39025 | 13398 | 92 |
903038 | 903038 | 2021-01-06 | Clermont | Ohio | 39025 | 13152 | 86 |
899793 | 899793 | 2021-01-05 | Clermont | Ohio | 39025 | 12877 | 83 |
896548 | 896548 | 2021-01-04 | Clermont | Ohio | 39025 | 12711 | 80 |
893302 | 893302 | 2021-01-03 | Clermont | Ohio | 39025 | 12600 | 78 |
890056 | 890056 | 2021-01-02 | Clermont | Ohio | 39025 | 12428 | 78 |
886809 | 886809 | 2021-01-01 | Clermont | Ohio | 39025 | 12046 | 76 |
883564 | 883564 | 2020-12-31 | Clermont | Ohio | 39025 | 12046 | 76 |
880319 | 880319 | 2020-12-30 | Clermont | Ohio | 39025 | 11856 | 76 |
877074 | 877074 | 2020-12-29 | Clermont | Ohio | 39025 | 11652 | 76 |
873829 | 873829 | 2020-12-28 | Clermont | Ohio | 39025 | 11477 | 76 |
870584 | 870584 | 2020-12-27 | Clermont | Ohio | 39025 | 11384 | 76 |
867339 | 867339 | 2020-12-26 | Clermont | Ohio | 39025 | 11224 | 76 |
864094 | 864094 | 2020-12-25 | Clermont | Ohio | 39025 | 10998 | 76 |
860849 | 860849 | 2020-12-24 | Clermont | Ohio | 39025 | 10998 | 76 |
857604 | 857604 | 2020-12-23 | Clermont | Ohio | 39025 | 10789 | 76 |
854359 | 854359 | 2020-12-22 | Clermont | Ohio | 39025 | 10599 | 75 |
851114 | 851114 | 2020-12-21 | Clermont | Ohio | 39025 | 10457 | 73 |
847869 | 847869 | 2020-12-20 | Clermont | Ohio | 39025 | 10326 | 65 |
844624 | 844624 | 2020-12-19 | Clermont | Ohio | 39025 | 10175 | 65 |
841378 | 841378 | 2020-12-18 | Clermont | Ohio | 39025 | 9975 | 64 |
838133 | 838133 | 2020-12-17 | Clermont | Ohio | 39025 | 9769 | 62 |
834887 | 834887 | 2020-12-16 | Clermont | Ohio | 39025 | 9510 | 60 |
831641 | 831641 | 2020-12-15 | Clermont | Ohio | 39025 | 9366 | 59 |
828394 | 828394 | 2020-12-14 | Clermont | Ohio | 39025 | 9195 | 59 |
825148 | 825148 | 2020-12-13 | Clermont | Ohio | 39025 | 9058 | 59 |
821901 | 821901 | 2020-12-12 | Clermont | Ohio | 39025 | 8844 | 59 |
818655 | 818655 | 2020-12-11 | Clermont | Ohio | 39025 | 8621 | 58 |
815409 | 815409 | 2020-12-10 | Clermont | Ohio | 39025 | 8464 | 57 |
812163 | 812163 | 2020-12-09 | Clermont | Ohio | 39025 | 8294 | 57 |
808919 | 808919 | 2020-12-08 | Clermont | Ohio | 39025 | 8136 | 57 |
805674 | 805674 | 2020-12-07 | Clermont | Ohio | 39025 | 7765 | 56 |
802429 | 802429 | 2020-12-06 | Clermont | Ohio | 39025 | 7622 | 56 |
799184 | 799184 | 2020-12-05 | Clermont | Ohio | 39025 | 7486 | 56 |
795939 | 795939 | 2020-12-04 | Clermont | Ohio | 39025 | 7315 | 56 |
792694 | 792694 | 2020-12-03 | Clermont | Ohio | 39025 | 7121 | 56 |
789449 | 789449 | 2020-12-02 | Clermont | Ohio | 39025 | 6934 | 54 |
786204 | 786204 | 2020-12-01 | Clermont | Ohio | 39025 | 6799 | 54 |
782960 | 782960 | 2020-11-30 | Clermont | Ohio | 39025 | 6602 | 53 |
779714 | 779714 | 2020-11-29 | Clermont | Ohio | 39025 | 6472 | 53 |
776469 | 776469 | 2020-11-28 | Clermont | Ohio | 39025 | 6353 | 53 |
773224 | 773224 | 2020-11-27 | Clermont | Ohio | 39025 | 6229 | 53 |
769979 | 769979 | 2020-11-26 | Clermont | Ohio | 39025 | 5936 | 51 |
766733 | 766733 | 2020-11-25 | Clermont | Ohio | 39025 | 5936 | 51 |
763488 | 763488 | 2020-11-24 | Clermont | Ohio | 39025 | 5772 | 48 |
760243 | 760243 | 2020-11-23 | Clermont | Ohio | 39025 | 5639 | 46 |
756998 | 756998 | 2020-11-22 | Clermont | Ohio | 39025 | 5419 | 46 |
753751 | 753751 | 2020-11-21 | Clermont | Ohio | 39025 | 5317 | 46 |
750505 | 750505 | 2020-11-20 | Clermont | Ohio | 39025 | 5135 | 45 |
747259 | 747259 | 2020-11-19 | Clermont | Ohio | 39025 | 4948 | 45 |
744013 | 744013 | 2020-11-18 | Clermont | Ohio | 39025 | 4817 | 44 |
740766 | 740766 | 2020-11-17 | Clermont | Ohio | 39025 | 4685 | 44 |
737520 | 737520 | 2020-11-16 | Clermont | Ohio | 39025 | 4526 | 42 |
734276 | 734276 | 2020-11-15 | Clermont | Ohio | 39025 | 4396 | 42 |
731030 | 731030 | 2020-11-14 | Clermont | Ohio | 39025 | 4254 | 42 |
727786 | 727786 | 2020-11-13 | Clermont | Ohio | 39025 | 4088 | 42 |
724542 | 724542 | 2020-11-12 | Clermont | Ohio | 39025 | 3963 | 42 |
721299 | 721299 | 2020-11-11 | Clermont | Ohio | 39025 | 3828 | 41 |
718056 | 718056 | 2020-11-10 | Clermont | Ohio | 39025 | 3714 | 41 |
714813 | 714813 | 2020-11-09 | Clermont | Ohio | 39025 | 3567 | 41 |
711569 | 711569 | 2020-11-08 | Clermont | Ohio | 39025 | 3488 | 41 |
708325 | 708325 | 2020-11-07 | Clermont | Ohio | 39025 | 3420 | 41 |
705082 | 705082 | 2020-11-06 | Clermont | Ohio | 39025 | 3283 | 41 |
701839 | 701839 | 2020-11-05 | Clermont | Ohio | 39025 | 3203 | 41 |
698595 | 698595 | 2020-11-04 | Clermont | Ohio | 39025 | 3126 | 41 |
695352 | 695352 | 2020-11-03 | Clermont | Ohio | 39025 | 3064 | 40 |
692110 | 692110 | 2020-11-02 | Clermont | Ohio | 39025 | 3006 | 39 |
688866 | 688866 | 2020-11-01 | Clermont | Ohio | 39025 | 2961 | 39 |
685621 | 685621 | 2020-10-31 | Clermont | Ohio | 39025 | 2911 | 39 |
682378 | 682378 | 2020-10-30 | Clermont | Ohio | 39025 | 2844 | 39 |
679135 | 679135 | 2020-10-29 | Clermont | Ohio | 39025 | 2772 | 39 |
675892 | 675892 | 2020-10-28 | Clermont | Ohio | 39025 | 2732 | 39 |
672649 | 672649 | 2020-10-27 | Clermont | Ohio | 39025 | 2670 | 38 |
669407 | 669407 | 2020-10-26 | Clermont | Ohio | 39025 | 2622 | 38 |
666163 | 666163 | 2020-10-25 | Clermont | Ohio | 39025 | 2598 | 38 |
662918 | 662918 | 2020-10-24 | Clermont | Ohio | 39025 | 2550 | 38 |
659674 | 659674 | 2020-10-23 | Clermont | Ohio | 39025 | 2512 | 38 |
656430 | 656430 | 2020-10-22 | Clermont | Ohio | 39025 | 2459 | 38 |
653185 | 653185 | 2020-10-21 | Clermont | Ohio | 39025 | 2403 | 38 |
649940 | 649940 | 2020-10-20 | Clermont | Ohio | 39025 | 2349 | 37 |
646696 | 646696 | 2020-10-19 | Clermont | Ohio | 39025 | 2302 | 37 |
643450 | 643450 | 2020-10-18 | Clermont | Ohio | 39025 | 2259 | 36 |
640202 | 640202 | 2020-10-17 | Clermont | Ohio | 39025 | 2239 | 36 |
636956 | 636956 | 2020-10-16 | Clermont | Ohio | 39025 | 2198 | 36 |
633710 | 633710 | 2020-10-15 | Clermont | Ohio | 39025 | 2163 | 36 |
630465 | 630465 | 2020-10-14 | Clermont | Ohio | 39025 | 2130 | 36 |
627221 | 627221 | 2020-10-13 | Clermont | Ohio | 39025 | 2091 | 36 |
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);