ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where 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 |
---|---|---|---|---|---|---|---|
1055578 | 1055578 | 2021-02-22 | Clermont | Ohio | 39025 | 18113 | 204 |
1052332 | 1052332 | 2021-02-21 | Clermont | Ohio | 39025 | 18091 | 203 |
1049085 | 1049085 | 2021-02-20 | Clermont | Ohio | 39025 | 18058 | 202 |
1045838 | 1045838 | 2021-02-19 | Clermont | Ohio | 39025 | 17948 | 202 |
1042593 | 1042593 | 2021-02-18 | Clermont | Ohio | 39025 | 17901 | 200 |
1039348 | 1039348 | 2021-02-17 | Clermont | Ohio | 39025 | 17847 | 200 |
1036103 | 1036103 | 2021-02-16 | Clermont | Ohio | 39025 | 17804 | 200 |
1032858 | 1032858 | 2021-02-15 | Clermont | Ohio | 39025 | 17772 | 197 |
1029612 | 1029612 | 2021-02-14 | Clermont | Ohio | 39025 | 17742 | 198 |
1026365 | 1026365 | 2021-02-13 | Clermont | Ohio | 39025 | 17701 | 198 |
1023120 | 1023120 | 2021-02-12 | Clermont | Ohio | 39025 | 17610 | 182 |
1019875 | 1019875 | 2021-02-11 | Clermont | Ohio | 39025 | 17557 | 141 |
1016630 | 1016630 | 2021-02-10 | Clermont | Ohio | 39025 | 17503 | 127 |
1013385 | 1013385 | 2021-02-09 | Clermont | Ohio | 39025 | 17446 | 127 |
1010140 | 1010140 | 2021-02-08 | Clermont | Ohio | 39025 | 17362 | 126 |
1006894 | 1006894 | 2021-02-07 | Clermont | Ohio | 39025 | 17336 | 125 |
1003648 | 1003648 | 2021-02-06 | Clermont | Ohio | 39025 | 17285 | 125 |
1000402 | 1000402 | 2021-02-05 | Clermont | Ohio | 39025 | 17212 | 125 |
997156 | 997156 | 2021-02-04 | Clermont | Ohio | 39025 | 17123 | 124 |
993910 | 993910 | 2021-02-03 | Clermont | Ohio | 39025 | 17024 | 122 |
990664 | 990664 | 2021-02-02 | Clermont | Ohio | 39025 | 16946 | 120 |
987418 | 987418 | 2021-02-01 | Clermont | Ohio | 39025 | 16857 | 120 |
984171 | 984171 | 2021-01-31 | Clermont | Ohio | 39025 | 16780 | 117 |
980924 | 980924 | 2021-01-30 | Clermont | Ohio | 39025 | 16715 | 117 |
977678 | 977678 | 2021-01-29 | Clermont | Ohio | 39025 | 16608 | 117 |
974433 | 974433 | 2021-01-28 | Clermont | Ohio | 39025 | 16486 | 117 |
971188 | 971188 | 2021-01-27 | Clermont | Ohio | 39025 | 16341 | 114 |
967943 | 967943 | 2021-01-26 | Clermont | Ohio | 39025 | 16235 | 113 |
964699 | 964699 | 2021-01-25 | Clermont | Ohio | 39025 | 16128 | 112 |
961454 | 961454 | 2021-01-24 | Clermont | Ohio | 39025 | 16057 | 111 |
958209 | 958209 | 2021-01-23 | Clermont | Ohio | 39025 | 15926 | 111 |
954963 | 954963 | 2021-01-22 | Clermont | Ohio | 39025 | 15800 | 111 |
951718 | 951718 | 2021-01-21 | Clermont | Ohio | 39025 | 15697 | 110 |
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 |
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);