ny_times_us_counties

Table actions
⚠️ 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,517 rows where county = "Lake" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Lake · 3,517 ✖
Link rowid date ▲ county state fips cases deaths
953174 953174 2021-01-22 Lake California 6033 2669 31
953250 953250 2021-01-22 Lake Colorado 8065 486 0
953327 953327 2021-01-22 Lake Florida 12069 20296 392
953621 953621 2021-01-22 Lake Illinois 17097 54272 903
953719 953719 2021-01-22 Lake Indiana 18089 45259 708
954256 954256 2021-01-22 Lake Michigan 26085 340 11
954335 954335 2021-01-22 Lake Minnesota 27075 660 15
954608 954608 2021-01-22 Lake Montana 30047 1755 19
955073 955073 2021-01-22 Lake Ohio 39085 15967 154
955215 955215 2021-01-22 Lake Oregon 41037 240 5
955469 955469 2021-01-22 Lake South Dakota 46079 1119 16
955544 955544 2021-01-22 Lake Tennessee 47095 1578 21
949929 949929 2021-01-21 Lake California 6033 2646 31
950005 950005 2021-01-21 Lake Colorado 8065 482 0
950082 950082 2021-01-21 Lake Florida 12069 20128 393
950376 950376 2021-01-21 Lake Illinois 17097 53926 901
950474 950474 2021-01-21 Lake Indiana 18089 45042 706
951011 951011 2021-01-21 Lake Michigan 26085 339 10
951090 951090 2021-01-21 Lake Minnesota 27075 656 15
951363 951363 2021-01-21 Lake Montana 30047 1748 19
951828 951828 2021-01-21 Lake Ohio 39085 15882 153
951970 951970 2021-01-21 Lake Oregon 41037 237 5
952224 952224 2021-01-21 Lake South Dakota 46079 1112 16
952299 952299 2021-01-21 Lake Tennessee 47095 1575 21
946683 946683 2021-01-20 Lake California 6033 2625 30
946759 946759 2021-01-20 Lake Colorado 8065 479 0
946836 946836 2021-01-20 Lake Florida 12069 19897 378
947130 947130 2021-01-20 Lake Illinois 17097 53688 895
947228 947228 2021-01-20 Lake Indiana 18089 44848 704
947765 947765 2021-01-20 Lake Michigan 26085 338 10
947844 947844 2021-01-20 Lake Minnesota 27075 649 15
948117 948117 2021-01-20 Lake Montana 30047 1743 19
948583 948583 2021-01-20 Lake Ohio 39085 15747 136
948725 948725 2021-01-20 Lake Oregon 41037 236 5
948979 948979 2021-01-20 Lake South Dakota 46079 1106 16
949054 949054 2021-01-20 Lake Tennessee 47095 1566 20
943436 943436 2021-01-19 Lake California 6033 2591 30
943512 943512 2021-01-19 Lake Colorado 8065 479 0
943589 943589 2021-01-19 Lake Florida 12069 19713 378
943883 943883 2021-01-19 Lake Illinois 17097 53439 886
943981 943981 2021-01-19 Lake Indiana 18089 44695 697
944518 944518 2021-01-19 Lake Michigan 26085 339 10
944597 944597 2021-01-19 Lake Minnesota 27075 637 15
944870 944870 2021-01-19 Lake Montana 30047 1739 19
945337 945337 2021-01-19 Lake Ohio 39085 15592 136
945479 945479 2021-01-19 Lake Oregon 41037 232 5
945733 945733 2021-01-19 Lake South Dakota 46079 1100 16
945808 945808 2021-01-19 Lake Tennessee 47095 1560 19
940191 940191 2021-01-18 Lake California 6033 2572 28
940267 940267 2021-01-18 Lake Colorado 8065 478 0
940344 940344 2021-01-18 Lake Florida 12069 19547 377
940638 940638 2021-01-18 Lake Illinois 17097 53227 886
940736 940736 2021-01-18 Lake Indiana 18089 44564 695
941273 941273 2021-01-18 Lake Michigan 26085 338 10
941352 941352 2021-01-18 Lake Minnesota 27075 636 15
941625 941625 2021-01-18 Lake Montana 30047 1730 19
942090 942090 2021-01-18 Lake Ohio 39085 15491 135
942232 942232 2021-01-18 Lake Oregon 41037 230 5
942486 942486 2021-01-18 Lake South Dakota 46079 1099 16
942561 942561 2021-01-18 Lake Tennessee 47095 1555 19
936946 936946 2021-01-17 Lake California 6033 2504 28
937022 937022 2021-01-17 Lake Colorado 8065 476 0
937099 937099 2021-01-17 Lake Florida 12069 19387 377
937393 937393 2021-01-17 Lake Illinois 17097 53068 884
937491 937491 2021-01-17 Lake Indiana 18089 44375 693
938028 938028 2021-01-17 Lake Michigan 26085 334 10
938107 938107 2021-01-17 Lake Minnesota 27075 632 15
938380 938380 2021-01-17 Lake Montana 30047 1727 19
938845 938845 2021-01-17 Lake Ohio 39085 15365 135
938987 938987 2021-01-17 Lake Oregon 41037 230 5
939241 939241 2021-01-17 Lake South Dakota 46079 1097 16
939316 939316 2021-01-17 Lake Tennessee 47095 1553 19
933701 933701 2021-01-16 Lake California 6033 2434 28
933777 933777 2021-01-16 Lake Colorado 8065 476 0
933854 933854 2021-01-16 Lake Florida 12069 19208 377
934148 934148 2021-01-16 Lake Illinois 17097 52834 884
934246 934246 2021-01-16 Lake Indiana 18089 44190 692
934783 934783 2021-01-16 Lake Michigan 26085 334 10
934862 934862 2021-01-16 Lake Minnesota 27075 629 15
935135 935135 2021-01-16 Lake Montana 30047 1722 19
935600 935600 2021-01-16 Lake Ohio 39085 15255 135
935742 935742 2021-01-16 Lake Oregon 41037 229 5
935996 935996 2021-01-16 Lake South Dakota 46079 1093 16
936071 936071 2021-01-16 Lake Tennessee 47095 1545 19
930456 930456 2021-01-15 Lake California 6033 2378 28
930532 930532 2021-01-15 Lake Colorado 8065 477 0
930609 930609 2021-01-15 Lake Florida 12069 18962 349
930903 930903 2021-01-15 Lake Illinois 17097 52591 877
931001 931001 2021-01-15 Lake Indiana 18089 43906 692
931538 931538 2021-01-15 Lake Michigan 26085 332 10
931617 931617 2021-01-15 Lake Minnesota 27075 626 15
931890 931890 2021-01-15 Lake Montana 30047 1719 19
932355 932355 2021-01-15 Lake Ohio 39085 15100 135
932497 932497 2021-01-15 Lake Oregon 41037 228 5
932751 932751 2021-01-15 Lake South Dakota 46079 1090 16
932826 932826 2021-01-15 Lake Tennessee 47095 1540 19
927211 927211 2021-01-14 Lake California 6033 2305 28
927287 927287 2021-01-14 Lake Colorado 8065 471 0
927364 927364 2021-01-14 Lake Florida 12069 18753 339
927658 927658 2021-01-14 Lake Illinois 17097 52264 874

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