ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Lake" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195211 | 1195211 | 2021-04-06 | Lake | Ohio | 39085 | 19494 | 357 |
1191963 | 1191963 | 2021-04-05 | Lake | Ohio | 39085 | 19438 | 355 |
1188714 | 1188714 | 2021-04-04 | Lake | Ohio | 39085 | 19370 | 355 |
1185467 | 1185467 | 2021-04-03 | Lake | Ohio | 39085 | 19370 | 355 |
1182220 | 1182220 | 2021-04-02 | Lake | Ohio | 39085 | 19322 | 355 |
1178973 | 1178973 | 2021-04-01 | Lake | Ohio | 39085 | 19288 | 354 |
1175726 | 1175726 | 2021-03-31 | Lake | Ohio | 39085 | 19238 | 354 |
1172479 | 1172479 | 2021-03-30 | Lake | Ohio | 39085 | 19199 | 354 |
1169232 | 1169232 | 2021-03-29 | Lake | Ohio | 39085 | 19169 | 354 |
1165984 | 1165984 | 2021-03-28 | Lake | Ohio | 39085 | 19125 | 354 |
1162736 | 1162736 | 2021-03-27 | Lake | Ohio | 39085 | 19108 | 354 |
1159487 | 1159487 | 2021-03-26 | Lake | Ohio | 39085 | 19077 | 354 |
1156240 | 1156240 | 2021-03-25 | Lake | Ohio | 39085 | 19040 | 353 |
1152993 | 1152993 | 2021-03-24 | Lake | Ohio | 39085 | 19021 | 353 |
1149746 | 1149746 | 2021-03-23 | Lake | Ohio | 39085 | 18991 | 353 |
1146499 | 1146499 | 2021-03-22 | Lake | Ohio | 39085 | 18970 | 349 |
1143252 | 1143252 | 2021-03-21 | Lake | Ohio | 39085 | 18946 | 349 |
1140005 | 1140005 | 2021-03-20 | Lake | Ohio | 39085 | 18930 | 349 |
1136759 | 1136759 | 2021-03-19 | Lake | Ohio | 39085 | 18914 | 349 |
1133513 | 1133513 | 2021-03-18 | Lake | Ohio | 39085 | 18893 | 342 |
1130265 | 1130265 | 2021-03-17 | Lake | Ohio | 39085 | 18853 | 342 |
1127018 | 1127018 | 2021-03-16 | Lake | Ohio | 39085 | 18831 | 342 |
1123772 | 1123772 | 2021-03-15 | Lake | Ohio | 39085 | 18809 | 338 |
1120526 | 1120526 | 2021-03-14 | Lake | Ohio | 39085 | 18789 | 338 |
1117279 | 1117279 | 2021-03-13 | Lake | Ohio | 39085 | 18763 | 338 |
1114032 | 1114032 | 2021-03-12 | Lake | Ohio | 39085 | 18724 | 338 |
1110786 | 1110786 | 2021-03-11 | Lake | Ohio | 39085 | 18702 | 335 |
1107540 | 1107540 | 2021-03-10 | Lake | Ohio | 39085 | 18673 | 335 |
1104294 | 1104294 | 2021-03-09 | Lake | Ohio | 39085 | 18635 | 335 |
1101048 | 1101048 | 2021-03-08 | Lake | Ohio | 39085 | 18602 | 332 |
1097802 | 1097802 | 2021-03-07 | Lake | Ohio | 39085 | 18564 | 332 |
1094554 | 1094554 | 2021-03-06 | Lake | Ohio | 39085 | 18545 | 332 |
1091308 | 1091308 | 2021-03-05 | Lake | Ohio | 39085 | 18509 | 332 |
1088063 | 1088063 | 2021-03-04 | Lake | Ohio | 39085 | 18471 | 318 |
1084818 | 1084818 | 2021-03-03 | Lake | Ohio | 39085 | 18445 | 318 |
1081572 | 1081572 | 2021-03-02 | Lake | Ohio | 39085 | 18411 | 318 |
1078326 | 1078326 | 2021-03-01 | Lake | Ohio | 39085 | 18379 | 305 |
1075081 | 1075081 | 2021-02-28 | Lake | Ohio | 39085 | 18358 | 305 |
1071835 | 1071835 | 2021-02-27 | Lake | Ohio | 39085 | 18335 | 305 |
1068589 | 1068589 | 2021-02-26 | Lake | Ohio | 39085 | 18307 | 304 |
1065344 | 1065344 | 2021-02-25 | Lake | Ohio | 39085 | 18273 | 301 |
1062100 | 1062100 | 2021-02-24 | Lake | Ohio | 39085 | 18210 | 300 |
1058854 | 1058854 | 2021-02-23 | Lake | Ohio | 39085 | 18178 | 300 |
1055608 | 1055608 | 2021-02-22 | Lake | Ohio | 39085 | 18087 | 300 |
1052362 | 1052362 | 2021-02-21 | Lake | Ohio | 39085 | 18062 | 299 |
1049115 | 1049115 | 2021-02-20 | Lake | Ohio | 39085 | 18029 | 295 |
1045868 | 1045868 | 2021-02-19 | Lake | Ohio | 39085 | 17998 | 294 |
1042623 | 1042623 | 2021-02-18 | Lake | Ohio | 39085 | 17949 | 294 |
1039378 | 1039378 | 2021-02-17 | Lake | Ohio | 39085 | 17907 | 293 |
1036133 | 1036133 | 2021-02-16 | Lake | Ohio | 39085 | 17854 | 291 |
1032888 | 1032888 | 2021-02-15 | Lake | Ohio | 39085 | 17810 | 294 |
1029642 | 1029642 | 2021-02-14 | Lake | Ohio | 39085 | 17777 | 294 |
1026395 | 1026395 | 2021-02-13 | Lake | Ohio | 39085 | 17737 | 294 |
1023150 | 1023150 | 2021-02-12 | Lake | Ohio | 39085 | 17677 | 265 |
1019905 | 1019905 | 2021-02-11 | Lake | Ohio | 39085 | 17601 | 204 |
1016660 | 1016660 | 2021-02-10 | Lake | Ohio | 39085 | 17516 | 183 |
1013415 | 1013415 | 2021-02-09 | Lake | Ohio | 39085 | 17454 | 183 |
1010170 | 1010170 | 2021-02-08 | Lake | Ohio | 39085 | 17371 | 178 |
1006924 | 1006924 | 2021-02-07 | Lake | Ohio | 39085 | 17340 | 178 |
1003678 | 1003678 | 2021-02-06 | Lake | Ohio | 39085 | 17288 | 177 |
1000432 | 1000432 | 2021-02-05 | Lake | Ohio | 39085 | 17220 | 171 |
997186 | 997186 | 2021-02-04 | Lake | Ohio | 39085 | 17123 | 171 |
993940 | 993940 | 2021-02-03 | Lake | Ohio | 39085 | 17044 | 169 |
990694 | 990694 | 2021-02-02 | Lake | Ohio | 39085 | 16931 | 169 |
987448 | 987448 | 2021-02-01 | Lake | Ohio | 39085 | 16867 | 163 |
984201 | 984201 | 2021-01-31 | Lake | Ohio | 39085 | 16807 | 163 |
980954 | 980954 | 2021-01-30 | Lake | Ohio | 39085 | 16745 | 163 |
977708 | 977708 | 2021-01-29 | Lake | Ohio | 39085 | 16675 | 163 |
974463 | 974463 | 2021-01-28 | Lake | Ohio | 39085 | 16561 | 162 |
971218 | 971218 | 2021-01-27 | Lake | Ohio | 39085 | 16452 | 161 |
967973 | 967973 | 2021-01-26 | Lake | Ohio | 39085 | 16350 | 161 |
964729 | 964729 | 2021-01-25 | Lake | Ohio | 39085 | 16250 | 154 |
961484 | 961484 | 2021-01-24 | Lake | Ohio | 39085 | 16178 | 154 |
958239 | 958239 | 2021-01-23 | Lake | Ohio | 39085 | 16080 | 154 |
954993 | 954993 | 2021-01-22 | Lake | Ohio | 39085 | 15967 | 154 |
951748 | 951748 | 2021-01-21 | Lake | Ohio | 39085 | 15882 | 153 |
948503 | 948503 | 2021-01-20 | Lake | Ohio | 39085 | 15747 | 136 |
945257 | 945257 | 2021-01-19 | Lake | Ohio | 39085 | 15592 | 136 |
942010 | 942010 | 2021-01-18 | Lake | Ohio | 39085 | 15491 | 135 |
938765 | 938765 | 2021-01-17 | Lake | Ohio | 39085 | 15365 | 135 |
935520 | 935520 | 2021-01-16 | Lake | Ohio | 39085 | 15255 | 135 |
932275 | 932275 | 2021-01-15 | Lake | Ohio | 39085 | 15100 | 135 |
929030 | 929030 | 2021-01-14 | Lake | Ohio | 39085 | 14941 | 134 |
925785 | 925785 | 2021-01-13 | Lake | Ohio | 39085 | 14769 | 126 |
922539 | 922539 | 2021-01-12 | Lake | Ohio | 39085 | 14621 | 126 |
919294 | 919294 | 2021-01-11 | Lake | Ohio | 39085 | 14461 | 126 |
916049 | 916049 | 2021-01-10 | Lake | Ohio | 39085 | 14319 | 126 |
912804 | 912804 | 2021-01-09 | Lake | Ohio | 39085 | 14201 | 126 |
909559 | 909559 | 2021-01-08 | Lake | Ohio | 39085 | 14050 | 126 |
906314 | 906314 | 2021-01-07 | Lake | Ohio | 39085 | 13887 | 126 |
903068 | 903068 | 2021-01-06 | Lake | Ohio | 39085 | 13670 | 123 |
899823 | 899823 | 2021-01-05 | Lake | Ohio | 39085 | 13478 | 123 |
896578 | 896578 | 2021-01-04 | Lake | Ohio | 39085 | 13317 | 121 |
893332 | 893332 | 2021-01-03 | Lake | Ohio | 39085 | 13156 | 120 |
890086 | 890086 | 2021-01-02 | Lake | Ohio | 39085 | 13013 | 120 |
886839 | 886839 | 2021-01-01 | Lake | Ohio | 39085 | 12756 | 120 |
883594 | 883594 | 2020-12-31 | Lake | Ohio | 39085 | 12756 | 120 |
880349 | 880349 | 2020-12-30 | Lake | Ohio | 39085 | 12569 | 120 |
877104 | 877104 | 2020-12-29 | Lake | Ohio | 39085 | 12428 | 120 |
873859 | 873859 | 2020-12-28 | Lake | Ohio | 39085 | 12282 | 113 |
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);