ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Columbiana" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081544 | 1081544 | 2021-03-02 | Columbiana | Ohio | 39029 | 8134 | 200 |
1078298 | 1078298 | 2021-03-01 | Columbiana | Ohio | 39029 | 8120 | 183 |
1075053 | 1075053 | 2021-02-28 | Columbiana | Ohio | 39029 | 8103 | 182 |
1071807 | 1071807 | 2021-02-27 | Columbiana | Ohio | 39029 | 8094 | 182 |
1068561 | 1068561 | 2021-02-26 | Columbiana | Ohio | 39029 | 8086 | 182 |
1065316 | 1065316 | 2021-02-25 | Columbiana | Ohio | 39029 | 8077 | 180 |
1062072 | 1062072 | 2021-02-24 | Columbiana | Ohio | 39029 | 8052 | 179 |
1058826 | 1058826 | 2021-02-23 | Columbiana | Ohio | 39029 | 8049 | 179 |
1055580 | 1055580 | 2021-02-22 | Columbiana | Ohio | 39029 | 8029 | 177 |
1052334 | 1052334 | 2021-02-21 | Columbiana | Ohio | 39029 | 8018 | 177 |
1049087 | 1049087 | 2021-02-20 | Columbiana | Ohio | 39029 | 7999 | 177 |
1045840 | 1045840 | 2021-02-19 | Columbiana | Ohio | 39029 | 7985 | 176 |
1042595 | 1042595 | 2021-02-18 | Columbiana | Ohio | 39029 | 7969 | 176 |
1039350 | 1039350 | 2021-02-17 | Columbiana | Ohio | 39029 | 7942 | 175 |
1036105 | 1036105 | 2021-02-16 | Columbiana | Ohio | 39029 | 7932 | 175 |
1032860 | 1032860 | 2021-02-15 | Columbiana | Ohio | 39029 | 7911 | 175 |
1029614 | 1029614 | 2021-02-14 | Columbiana | Ohio | 39029 | 7902 | 175 |
1026367 | 1026367 | 2021-02-13 | Columbiana | Ohio | 39029 | 7883 | 173 |
1023122 | 1023122 | 2021-02-12 | Columbiana | Ohio | 39029 | 7866 | 163 |
1019877 | 1019877 | 2021-02-11 | Columbiana | Ohio | 39029 | 7835 | 134 |
1016632 | 1016632 | 2021-02-10 | Columbiana | Ohio | 39029 | 7810 | 132 |
1013387 | 1013387 | 2021-02-09 | Columbiana | Ohio | 39029 | 7786 | 132 |
1010142 | 1010142 | 2021-02-08 | Columbiana | Ohio | 39029 | 7777 | 132 |
1006896 | 1006896 | 2021-02-07 | Columbiana | Ohio | 39029 | 7755 | 132 |
1003650 | 1003650 | 2021-02-06 | Columbiana | Ohio | 39029 | 7748 | 132 |
1000404 | 1000404 | 2021-02-05 | Columbiana | Ohio | 39029 | 7722 | 132 |
997158 | 997158 | 2021-02-04 | Columbiana | Ohio | 39029 | 7693 | 131 |
993912 | 993912 | 2021-02-03 | Columbiana | Ohio | 39029 | 7665 | 130 |
990666 | 990666 | 2021-02-02 | Columbiana | Ohio | 39029 | 7634 | 130 |
987420 | 987420 | 2021-02-01 | Columbiana | Ohio | 39029 | 7618 | 125 |
984173 | 984173 | 2021-01-31 | Columbiana | Ohio | 39029 | 7583 | 124 |
980926 | 980926 | 2021-01-30 | Columbiana | Ohio | 39029 | 7572 | 124 |
977680 | 977680 | 2021-01-29 | Columbiana | Ohio | 39029 | 7557 | 124 |
974435 | 974435 | 2021-01-28 | Columbiana | Ohio | 39029 | 7519 | 124 |
971190 | 971190 | 2021-01-27 | Columbiana | Ohio | 39029 | 7468 | 124 |
967945 | 967945 | 2021-01-26 | Columbiana | Ohio | 39029 | 7433 | 124 |
964701 | 964701 | 2021-01-25 | Columbiana | Ohio | 39029 | 7409 | 124 |
961456 | 961456 | 2021-01-24 | Columbiana | Ohio | 39029 | 7356 | 124 |
958211 | 958211 | 2021-01-23 | Columbiana | Ohio | 39029 | 7327 | 124 |
954965 | 954965 | 2021-01-22 | Columbiana | Ohio | 39029 | 7286 | 124 |
951720 | 951720 | 2021-01-21 | Columbiana | Ohio | 39029 | 7263 | 124 |
948475 | 948475 | 2021-01-20 | Columbiana | Ohio | 39029 | 7202 | 124 |
945229 | 945229 | 2021-01-19 | Columbiana | Ohio | 39029 | 7164 | 124 |
941982 | 941982 | 2021-01-18 | Columbiana | Ohio | 39029 | 7117 | 124 |
938737 | 938737 | 2021-01-17 | Columbiana | Ohio | 39029 | 7085 | 124 |
935492 | 935492 | 2021-01-16 | Columbiana | Ohio | 39029 | 7047 | 124 |
932247 | 932247 | 2021-01-15 | Columbiana | Ohio | 39029 | 6971 | 124 |
929002 | 929002 | 2021-01-14 | Columbiana | Ohio | 39029 | 6922 | 124 |
925757 | 925757 | 2021-01-13 | Columbiana | Ohio | 39029 | 6851 | 123 |
922511 | 922511 | 2021-01-12 | Columbiana | Ohio | 39029 | 6780 | 122 |
919266 | 919266 | 2021-01-11 | Columbiana | Ohio | 39029 | 6699 | 122 |
916021 | 916021 | 2021-01-10 | Columbiana | Ohio | 39029 | 6651 | 122 |
912776 | 912776 | 2021-01-09 | Columbiana | Ohio | 39029 | 6626 | 122 |
909531 | 909531 | 2021-01-08 | Columbiana | Ohio | 39029 | 6579 | 122 |
906286 | 906286 | 2021-01-07 | Columbiana | Ohio | 39029 | 6498 | 120 |
903040 | 903040 | 2021-01-06 | Columbiana | Ohio | 39029 | 6430 | 120 |
899795 | 899795 | 2021-01-05 | Columbiana | Ohio | 39029 | 6375 | 120 |
896550 | 896550 | 2021-01-04 | Columbiana | Ohio | 39029 | 6309 | 119 |
893304 | 893304 | 2021-01-03 | Columbiana | Ohio | 39029 | 6260 | 119 |
890058 | 890058 | 2021-01-02 | Columbiana | Ohio | 39029 | 6239 | 119 |
886811 | 886811 | 2021-01-01 | Columbiana | Ohio | 39029 | 6147 | 119 |
883566 | 883566 | 2020-12-31 | Columbiana | Ohio | 39029 | 6147 | 119 |
880321 | 880321 | 2020-12-30 | Columbiana | Ohio | 39029 | 6074 | 119 |
877076 | 877076 | 2020-12-29 | Columbiana | Ohio | 39029 | 6015 | 119 |
873831 | 873831 | 2020-12-28 | Columbiana | Ohio | 39029 | 5936 | 119 |
870586 | 870586 | 2020-12-27 | Columbiana | Ohio | 39029 | 5892 | 119 |
867341 | 867341 | 2020-12-26 | Columbiana | Ohio | 39029 | 5863 | 119 |
864096 | 864096 | 2020-12-25 | Columbiana | Ohio | 39029 | 5780 | 119 |
860851 | 860851 | 2020-12-24 | Columbiana | Ohio | 39029 | 5780 | 119 |
857606 | 857606 | 2020-12-23 | Columbiana | Ohio | 39029 | 5672 | 118 |
854361 | 854361 | 2020-12-22 | Columbiana | Ohio | 39029 | 5598 | 117 |
851116 | 851116 | 2020-12-21 | Columbiana | Ohio | 39029 | 5538 | 116 |
847871 | 847871 | 2020-12-20 | Columbiana | Ohio | 39029 | 5496 | 116 |
844626 | 844626 | 2020-12-19 | Columbiana | Ohio | 39029 | 5443 | 116 |
841380 | 841380 | 2020-12-18 | Columbiana | Ohio | 39029 | 5396 | 115 |
838135 | 838135 | 2020-12-17 | Columbiana | Ohio | 39029 | 5340 | 113 |
834889 | 834889 | 2020-12-16 | Columbiana | Ohio | 39029 | 5212 | 113 |
831643 | 831643 | 2020-12-15 | Columbiana | Ohio | 39029 | 5168 | 113 |
828396 | 828396 | 2020-12-14 | Columbiana | Ohio | 39029 | 5118 | 110 |
825150 | 825150 | 2020-12-13 | Columbiana | Ohio | 39029 | 5048 | 110 |
821903 | 821903 | 2020-12-12 | Columbiana | Ohio | 39029 | 4988 | 110 |
818657 | 818657 | 2020-12-11 | Columbiana | Ohio | 39029 | 4915 | 110 |
815411 | 815411 | 2020-12-10 | Columbiana | Ohio | 39029 | 4837 | 109 |
812165 | 812165 | 2020-12-09 | Columbiana | Ohio | 39029 | 4732 | 107 |
808921 | 808921 | 2020-12-08 | Columbiana | Ohio | 39029 | 4650 | 107 |
805676 | 805676 | 2020-12-07 | Columbiana | Ohio | 39029 | 4480 | 104 |
802431 | 802431 | 2020-12-06 | Columbiana | Ohio | 39029 | 4411 | 104 |
799186 | 799186 | 2020-12-05 | Columbiana | Ohio | 39029 | 4353 | 104 |
795941 | 795941 | 2020-12-04 | Columbiana | Ohio | 39029 | 4233 | 104 |
792696 | 792696 | 2020-12-03 | Columbiana | Ohio | 39029 | 4131 | 103 |
789451 | 789451 | 2020-12-02 | Columbiana | Ohio | 39029 | 4012 | 102 |
786206 | 786206 | 2020-12-01 | Columbiana | Ohio | 39029 | 3952 | 100 |
782962 | 782962 | 2020-11-30 | Columbiana | Ohio | 39029 | 3902 | 99 |
779716 | 779716 | 2020-11-29 | Columbiana | Ohio | 39029 | 3852 | 99 |
776471 | 776471 | 2020-11-28 | Columbiana | Ohio | 39029 | 3789 | 99 |
773226 | 773226 | 2020-11-27 | Columbiana | Ohio | 39029 | 3765 | 99 |
769981 | 769981 | 2020-11-26 | Columbiana | Ohio | 39029 | 3576 | 98 |
766735 | 766735 | 2020-11-25 | Columbiana | Ohio | 39029 | 3576 | 98 |
763490 | 763490 | 2020-11-24 | Columbiana | Ohio | 39029 | 3472 | 97 |
760245 | 760245 | 2020-11-23 | Columbiana | Ohio | 39029 | 3395 | 97 |
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);