⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

3,997 rows where county = "Lake" sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

county

  • Lake · 3,997
Link rowid date ▲ county state fips cases deaths
1082918 2021-03-03 Lake California 6033 3169 41
1082994 2021-03-03 Lake Colorado 8065 660 0
1083071 2021-03-03 Lake Florida 12069 24841 567
1083365 2021-03-03 Lake Illinois 17097 59784 995
1083464 2021-03-03 Lake Indiana 18089 48587 919
1084001 2021-03-03 Lake Michigan 26085 364 11
1084080 2021-03-03 Lake Minnesota 27075 742 18
1084353 2021-03-03 Lake Montana 30047 1924 26
1084818 2021-03-03 Lake Ohio 39085 18445 318
1084960 2021-03-03 Lake Oregon 41037 378 6
1085214 2021-03-03 Lake South Dakota 46079 1198 17
1085289 2021-03-03 Lake Tennessee 47095 1678 26
1079672 2021-03-02 Lake California 6033 3164 41
1079748 2021-03-02 Lake Colorado 8065 661 0
1079825 2021-03-02 Lake Florida 12069 24744 566
1080119 2021-03-02 Lake Illinois 17097 59682 995
1080218 2021-03-02 Lake Indiana 18089 48538 917
1080755 2021-03-02 Lake Michigan 26085 362 11
1080834 2021-03-02 Lake Minnesota 27075 740 18
1081107 2021-03-02 Lake Montana 30047 1919 26
1081572 2021-03-02 Lake Ohio 39085 18411 318
1081714 2021-03-02 Lake Oregon 41037 378 6
1081968 2021-03-02 Lake South Dakota 46079 1194 17
1082043 2021-03-02 Lake Tennessee 47095 1678 26
1076427 2021-03-01 Lake California 6033 3164 41
1076503 2021-03-01 Lake Colorado 8065 659 0
1076580 2021-03-01 Lake Florida 12069 24635 560
1076874 2021-03-01 Lake Illinois 17097 59589 994
1076973 2021-03-01 Lake Indiana 18089 48502 915
1077509 2021-03-01 Lake Michigan 26085 362 11
1077588 2021-03-01 Lake Minnesota 27075 737 18
1077861 2021-03-01 Lake Montana 30047 1918 26
1078326 2021-03-01 Lake Ohio 39085 18379 305
1078468 2021-03-01 Lake Oregon 41037 376 6
1078722 2021-03-01 Lake South Dakota 46079 1192 17
1078797 2021-03-01 Lake Tennessee 47095 1678 26
1073181 2021-02-28 Lake California 6033 3156 41
1073257 2021-02-28 Lake Colorado 8065 658 0
1073334 2021-02-28 Lake Florida 12069 24611 559
1073628 2021-02-28 Lake Illinois 17097 59517 992
1073727 2021-02-28 Lake Indiana 18089 48464 911
1074263 2021-02-28 Lake Michigan 26085 361 11
1074342 2021-02-28 Lake Minnesota 27075 736 18
1074615 2021-02-28 Lake Montana 30047 1914 26
1075081 2021-02-28 Lake Ohio 39085 18358 305
1075223 2021-02-28 Lake Oregon 41037 376 6
1075477 2021-02-28 Lake South Dakota 46079 1191 17
1075552 2021-02-28 Lake Tennessee 47095 1678 26
1069935 2021-02-27 Lake California 6033 3153 41
1070011 2021-02-27 Lake Colorado 8065 659 0
1070088 2021-02-27 Lake Florida 12069 24538 555
1070382 2021-02-27 Lake Illinois 17097 59408 992
1070481 2021-02-27 Lake Indiana 18089 48427 909
1071017 2021-02-27 Lake Michigan 26085 361 11
1071096 2021-02-27 Lake Minnesota 27075 735 18
1071369 2021-02-27 Lake Montana 30047 1914 26
1071835 2021-02-27 Lake Ohio 39085 18335 305
1071977 2021-02-27 Lake Oregon 41037 375 6
1072231 2021-02-27 Lake South Dakota 46079 1190 17
1072306 2021-02-27 Lake Tennessee 47095 1678 26
1066690 2021-02-26 Lake California 6033 3141 40
1066766 2021-02-26 Lake Colorado 8065 656 0
1066843 2021-02-26 Lake Florida 12069 24445 554
1067137 2021-02-26 Lake Illinois 17097 59315 990
1067236 2021-02-26 Lake Indiana 18089 48373 908
1067772 2021-02-26 Lake Michigan 26085 361 11
1067851 2021-02-26 Lake Minnesota 27075 734 18
1068124 2021-02-26 Lake Montana 30047 1905 26
1068589 2021-02-26 Lake Ohio 39085 18307 304
1068731 2021-02-26 Lake Oregon 41037 374 6
1068985 2021-02-26 Lake South Dakota 46079 1185 17
1069060 2021-02-26 Lake Tennessee 47095 1675 26
1063445 2021-02-25 Lake California 6033 3134 40
1063521 2021-02-25 Lake Colorado 8065 656 0
1063598 2021-02-25 Lake Florida 12069 24342 544
1063892 2021-02-25 Lake Illinois 17097 59119 989
1063991 2021-02-25 Lake Indiana 18089 48313 905
1064527 2021-02-25 Lake Michigan 26085 360 11
1064606 2021-02-25 Lake Minnesota 27075 730 18
1064879 2021-02-25 Lake Montana 30047 1899 26
1065344 2021-02-25 Lake Ohio 39085 18273 301
1065486 2021-02-25 Lake Oregon 41037 374 6
1065740 2021-02-25 Lake South Dakota 46079 1184 17
1065815 2021-02-25 Lake Tennessee 47095 1675 26
1060200 2021-02-24 Lake California 6033 3121 40
1060276 2021-02-24 Lake Colorado 8065 655 0
1060353 2021-02-24 Lake Florida 12069 24228 541
1060647 2021-02-24 Lake Illinois 17097 58996 988
1060746 2021-02-24 Lake Indiana 18089 48237 904
1061283 2021-02-24 Lake Michigan 26085 360 11
1061362 2021-02-24 Lake Minnesota 27075 726 17
1061635 2021-02-24 Lake Montana 30047 1895 26
1062100 2021-02-24 Lake Ohio 39085 18210 300
1062241 2021-02-24 Lake Oregon 41037 374 6
1062495 2021-02-24 Lake South Dakota 46079 1183 17
1062570 2021-02-24 Lake Tennessee 47095 1673 26
1056954 2021-02-23 Lake California 6033 3107 40
1057030 2021-02-23 Lake Colorado 8065 653 0
1057107 2021-02-23 Lake Florida 12069 24110 541
1057401 2021-02-23 Lake Illinois 17097 58864 986

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);