ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,229 rows where county = "Lake" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
903068 | 903068 | 2021-01-06 | Lake | Ohio | 39085 | 13670 | 123 |
903210 | 903210 | 2021-01-06 | Lake | Oregon | 41037 | 208 | 4 |
903464 | 903464 | 2021-01-06 | Lake | South Dakota | 46079 | 1052 | 16 |
903539 | 903539 | 2021-01-06 | Lake | Tennessee | 47095 | 1474 | 14 |
897924 | 897924 | 2021-01-05 | Lake | California | 6033 | 1984 | 24 |
898000 | 898000 | 2021-01-05 | Lake | Colorado | 8065 | 448 | 0 |
898077 | 898077 | 2021-01-05 | Lake | Florida | 12069 | 16697 | 336 |
898371 | 898371 | 2021-01-05 | Lake | Illinois | 17097 | 49517 | 837 |
898469 | 898469 | 2021-01-05 | Lake | Indiana | 18089 | 41221 | 654 |
899006 | 899006 | 2021-01-05 | Lake | Michigan | 26085 | 305 | 9 |
899085 | 899085 | 2021-01-05 | Lake | Minnesota | 27075 | 566 | 15 |
899358 | 899358 | 2021-01-05 | Lake | Montana | 30047 | 1542 | 16 |
899823 | 899823 | 2021-01-05 | Lake | Ohio | 39085 | 13478 | 123 |
899965 | 899965 | 2021-01-05 | Lake | Oregon | 41037 | 203 | 4 |
900219 | 900219 | 2021-01-05 | Lake | South Dakota | 46079 | 1048 | 16 |
900294 | 900294 | 2021-01-05 | Lake | Tennessee | 47095 | 1470 | 15 |
894679 | 894679 | 2021-01-04 | Lake | California | 6033 | 1976 | 24 |
894755 | 894755 | 2021-01-04 | Lake | Colorado | 8065 | 444 | 0 |
894832 | 894832 | 2021-01-04 | Lake | Florida | 12069 | 16483 | 318 |
895126 | 895126 | 2021-01-04 | Lake | Illinois | 17097 | 49151 | 829 |
895224 | 895224 | 2021-01-04 | Lake | Indiana | 18089 | 41028 | 641 |
895761 | 895761 | 2021-01-04 | Lake | Michigan | 26085 | 304 | 9 |
895840 | 895840 | 2021-01-04 | Lake | Minnesota | 27075 | 565 | 15 |
896113 | 896113 | 2021-01-04 | Lake | Montana | 30047 | 1518 | 16 |
896578 | 896578 | 2021-01-04 | Lake | Ohio | 39085 | 13317 | 121 |
896720 | 896720 | 2021-01-04 | Lake | Oregon | 41037 | 201 | 4 |
896974 | 896974 | 2021-01-04 | Lake | South Dakota | 46079 | 1042 | 16 |
897049 | 897049 | 2021-01-04 | Lake | Tennessee | 47095 | 1466 | 14 |
891432 | 891432 | 2021-01-03 | Lake | California | 6033 | 1925 | 24 |
891508 | 891508 | 2021-01-03 | Lake | Colorado | 8065 | 437 | 0 |
891585 | 891585 | 2021-01-03 | Lake | Florida | 12069 | 16261 | 308 |
891879 | 891879 | 2021-01-03 | Lake | Illinois | 17097 | 48978 | 827 |
891977 | 891977 | 2021-01-03 | Lake | Indiana | 18089 | 40916 | 639 |
892514 | 892514 | 2021-01-03 | Lake | Michigan | 26085 | 304 | 9 |
892593 | 892593 | 2021-01-03 | Lake | Minnesota | 27075 | 560 | 15 |
892866 | 892866 | 2021-01-03 | Lake | Montana | 30047 | 1505 | 16 |
893332 | 893332 | 2021-01-03 | Lake | Ohio | 39085 | 13156 | 120 |
893474 | 893474 | 2021-01-03 | Lake | Oregon | 41037 | 200 | 4 |
893728 | 893728 | 2021-01-03 | Lake | South Dakota | 46079 | 1040 | 16 |
893803 | 893803 | 2021-01-03 | Lake | Tennessee | 47095 | 1466 | 13 |
888185 | 888185 | 2021-01-02 | Lake | California | 6033 | 1888 | 24 |
888261 | 888261 | 2021-01-02 | Lake | Colorado | 8065 | 437 | 0 |
888338 | 888338 | 2021-01-02 | Lake | Florida | 12069 | 16106 | 302 |
888632 | 888632 | 2021-01-02 | Lake | Illinois | 17097 | 48809 | 826 |
888731 | 888731 | 2021-01-02 | Lake | Indiana | 18089 | 40690 | 637 |
889268 | 889268 | 2021-01-02 | Lake | Michigan | 26085 | 304 | 9 |
889347 | 889347 | 2021-01-02 | Lake | Minnesota | 27075 | 556 | 15 |
889620 | 889620 | 2021-01-02 | Lake | Montana | 30047 | 1492 | 16 |
890086 | 890086 | 2021-01-02 | Lake | Ohio | 39085 | 13013 | 120 |
890228 | 890228 | 2021-01-02 | Lake | Oregon | 41037 | 200 | 4 |
890482 | 890482 | 2021-01-02 | Lake | South Dakota | 46079 | 1027 | 16 |
890557 | 890557 | 2021-01-02 | Lake | Tennessee | 47095 | 1464 | 13 |
884940 | 884940 | 2021-01-01 | Lake | California | 6033 | 1848 | 24 |
885016 | 885016 | 2021-01-01 | Lake | Colorado | 8065 | 433 | 0 |
885093 | 885093 | 2021-01-01 | Lake | Florida | 12069 | 15559 | 295 |
885387 | 885387 | 2021-01-01 | Lake | Illinois | 17097 | 48300 | 818 |
885485 | 885485 | 2021-01-01 | Lake | Indiana | 18089 | 40299 | 636 |
886022 | 886022 | 2021-01-01 | Lake | Michigan | 26085 | 304 | 9 |
886101 | 886101 | 2021-01-01 | Lake | Minnesota | 27075 | 547 | 15 |
886374 | 886374 | 2021-01-01 | Lake | Montana | 30047 | 1471 | 16 |
886839 | 886839 | 2021-01-01 | Lake | Ohio | 39085 | 12756 | 120 |
886981 | 886981 | 2021-01-01 | Lake | Oregon | 41037 | 200 | 4 |
887235 | 887235 | 2021-01-01 | Lake | South Dakota | 46079 | 1020 | 16 |
887310 | 887310 | 2021-01-01 | Lake | Tennessee | 47095 | 1408 | 13 |
881695 | 881695 | 2020-12-31 | Lake | California | 6033 | 1817 | 23 |
881771 | 881771 | 2020-12-31 | Lake | Colorado | 8065 | 426 | 0 |
881848 | 881848 | 2020-12-31 | Lake | Florida | 12069 | 15559 | 295 |
882142 | 882142 | 2020-12-31 | Lake | Illinois | 17097 | 48300 | 818 |
882240 | 882240 | 2020-12-31 | Lake | Indiana | 18089 | 39901 | 632 |
882777 | 882777 | 2020-12-31 | Lake | Michigan | 26085 | 304 | 9 |
882856 | 882856 | 2020-12-31 | Lake | Minnesota | 27075 | 547 | 15 |
883129 | 883129 | 2020-12-31 | Lake | Montana | 30047 | 1471 | 16 |
883594 | 883594 | 2020-12-31 | Lake | Ohio | 39085 | 12756 | 120 |
883736 | 883736 | 2020-12-31 | Lake | Oregon | 41037 | 197 | 4 |
883990 | 883990 | 2020-12-31 | Lake | South Dakota | 46079 | 1020 | 16 |
884065 | 884065 | 2020-12-31 | Lake | Tennessee | 47095 | 1408 | 13 |
878450 | 878450 | 2020-12-30 | Lake | California | 6033 | 1805 | 23 |
878526 | 878526 | 2020-12-30 | Lake | Colorado | 8065 | 419 | 0 |
878603 | 878603 | 2020-12-30 | Lake | Florida | 12069 | 15201 | 295 |
878897 | 878897 | 2020-12-30 | Lake | Illinois | 17097 | 47939 | 812 |
878995 | 878995 | 2020-12-30 | Lake | Indiana | 18089 | 39534 | 627 |
879532 | 879532 | 2020-12-30 | Lake | Michigan | 26085 | 304 | 9 |
879611 | 879611 | 2020-12-30 | Lake | Minnesota | 27075 | 544 | 15 |
879884 | 879884 | 2020-12-30 | Lake | Montana | 30047 | 1455 | 16 |
880349 | 880349 | 2020-12-30 | Lake | Ohio | 39085 | 12569 | 120 |
880491 | 880491 | 2020-12-30 | Lake | Oregon | 41037 | 195 | 4 |
880745 | 880745 | 2020-12-30 | Lake | South Dakota | 46079 | 1015 | 16 |
880820 | 880820 | 2020-12-30 | Lake | Tennessee | 47095 | 1393 | 13 |
875205 | 875205 | 2020-12-29 | Lake | California | 6033 | 1785 | 23 |
875281 | 875281 | 2020-12-29 | Lake | Colorado | 8065 | 413 | 0 |
875358 | 875358 | 2020-12-29 | Lake | Florida | 12069 | 14998 | 294 |
875652 | 875652 | 2020-12-29 | Lake | Illinois | 17097 | 47564 | 802 |
875750 | 875750 | 2020-12-29 | Lake | Indiana | 18089 | 39337 | 616 |
876287 | 876287 | 2020-12-29 | Lake | Michigan | 26085 | 303 | 9 |
876366 | 876366 | 2020-12-29 | Lake | Minnesota | 27075 | 539 | 15 |
876639 | 876639 | 2020-12-29 | Lake | Montana | 30047 | 1440 | 16 |
877104 | 877104 | 2020-12-29 | Lake | Ohio | 39085 | 12428 | 120 |
877246 | 877246 | 2020-12-29 | Lake | Oregon | 41037 | 194 | 4 |
877500 | 877500 | 2020-12-29 | Lake | South Dakota | 46079 | 1009 | 16 |
877575 | 877575 | 2020-12-29 | Lake | Tennessee | 47095 | 1390 | 13 |
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);