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 |
---|---|---|---|---|---|---|---|
920640 | 920640 | 2021-01-12 | Lake | California | 6033 | 2205 | 27 |
920716 | 920716 | 2021-01-12 | Lake | Colorado | 8065 | 465 | 0 |
920793 | 920793 | 2021-01-12 | Lake | Florida | 12069 | 18333 | 336 |
921087 | 921087 | 2021-01-12 | Lake | Illinois | 17097 | 51685 | 864 |
921185 | 921185 | 2021-01-12 | Lake | Indiana | 18089 | 43268 | 681 |
921722 | 921722 | 2021-01-12 | Lake | Michigan | 26085 | 325 | 10 |
921801 | 921801 | 2021-01-12 | Lake | Minnesota | 27075 | 604 | 15 |
922074 | 922074 | 2021-01-12 | Lake | Montana | 30047 | 1673 | 18 |
922539 | 922539 | 2021-01-12 | Lake | Ohio | 39085 | 14621 | 126 |
922681 | 922681 | 2021-01-12 | Lake | Oregon | 41037 | 222 | 5 |
922935 | 922935 | 2021-01-12 | Lake | South Dakota | 46079 | 1073 | 16 |
923010 | 923010 | 2021-01-12 | Lake | Tennessee | 47095 | 1518 | 19 |
917395 | 917395 | 2021-01-11 | Lake | California | 6033 | 2174 | 26 |
917471 | 917471 | 2021-01-11 | Lake | Colorado | 8065 | 461 | 0 |
917548 | 917548 | 2021-01-11 | Lake | Florida | 12069 | 18142 | 335 |
917842 | 917842 | 2021-01-11 | Lake | Illinois | 17097 | 51253 | 858 |
917940 | 917940 | 2021-01-11 | Lake | Indiana | 18089 | 43086 | 676 |
918477 | 918477 | 2021-01-11 | Lake | Michigan | 26085 | 319 | 10 |
918556 | 918556 | 2021-01-11 | Lake | Minnesota | 27075 | 603 | 15 |
918829 | 918829 | 2021-01-11 | Lake | Montana | 30047 | 1665 | 18 |
919294 | 919294 | 2021-01-11 | Lake | Ohio | 39085 | 14461 | 126 |
919436 | 919436 | 2021-01-11 | Lake | Oregon | 41037 | 219 | 4 |
919690 | 919690 | 2021-01-11 | Lake | South Dakota | 46079 | 1071 | 16 |
919765 | 919765 | 2021-01-11 | Lake | Tennessee | 47095 | 1516 | 19 |
914150 | 914150 | 2021-01-10 | Lake | California | 6033 | 2144 | 26 |
914226 | 914226 | 2021-01-10 | Lake | Colorado | 8065 | 461 | 0 |
914303 | 914303 | 2021-01-10 | Lake | Florida | 12069 | 17973 | 334 |
914597 | 914597 | 2021-01-10 | Lake | Illinois | 17097 | 51027 | 857 |
914695 | 914695 | 2021-01-10 | Lake | Indiana | 18089 | 42832 | 676 |
915232 | 915232 | 2021-01-10 | Lake | Michigan | 26085 | 315 | 10 |
915311 | 915311 | 2021-01-10 | Lake | Minnesota | 27075 | 599 | 15 |
915584 | 915584 | 2021-01-10 | Lake | Montana | 30047 | 1624 | 18 |
916049 | 916049 | 2021-01-10 | Lake | Ohio | 39085 | 14319 | 126 |
916191 | 916191 | 2021-01-10 | Lake | Oregon | 41037 | 219 | 4 |
916445 | 916445 | 2021-01-10 | Lake | South Dakota | 46079 | 1071 | 16 |
916520 | 916520 | 2021-01-10 | Lake | Tennessee | 47095 | 1514 | 19 |
910905 | 910905 | 2021-01-09 | Lake | California | 6033 | 2098 | 26 |
910981 | 910981 | 2021-01-09 | Lake | Colorado | 8065 | 461 | 0 |
911058 | 911058 | 2021-01-09 | Lake | Florida | 12069 | 17742 | 333 |
911352 | 911352 | 2021-01-09 | Lake | Illinois | 17097 | 50860 | 857 |
911450 | 911450 | 2021-01-09 | Lake | Indiana | 18089 | 42619 | 673 |
911987 | 911987 | 2021-01-09 | Lake | Michigan | 26085 | 315 | 10 |
912066 | 912066 | 2021-01-09 | Lake | Minnesota | 27075 | 589 | 15 |
912339 | 912339 | 2021-01-09 | Lake | Montana | 30047 | 1586 | 17 |
912804 | 912804 | 2021-01-09 | Lake | Ohio | 39085 | 14201 | 126 |
912946 | 912946 | 2021-01-09 | Lake | Oregon | 41037 | 219 | 4 |
913200 | 913200 | 2021-01-09 | Lake | South Dakota | 46079 | 1066 | 16 |
913275 | 913275 | 2021-01-09 | Lake | Tennessee | 47095 | 1503 | 18 |
907660 | 907660 | 2021-01-08 | Lake | California | 6033 | 2054 | 25 |
907736 | 907736 | 2021-01-08 | Lake | Colorado | 8065 | 458 | 0 |
907813 | 907813 | 2021-01-08 | Lake | Florida | 12069 | 17489 | 331 |
908107 | 908107 | 2021-01-08 | Lake | Illinois | 17097 | 50662 | 853 |
908205 | 908205 | 2021-01-08 | Lake | Indiana | 18089 | 42265 | 667 |
908742 | 908742 | 2021-01-08 | Lake | Michigan | 26085 | 312 | 10 |
908821 | 908821 | 2021-01-08 | Lake | Minnesota | 27075 | 581 | 15 |
909094 | 909094 | 2021-01-08 | Lake | Montana | 30047 | 1581 | 17 |
909559 | 909559 | 2021-01-08 | Lake | Ohio | 39085 | 14050 | 126 |
909701 | 909701 | 2021-01-08 | Lake | Oregon | 41037 | 218 | 4 |
909955 | 909955 | 2021-01-08 | Lake | South Dakota | 46079 | 1065 | 16 |
910030 | 910030 | 2021-01-08 | Lake | Tennessee | 47095 | 1495 | 16 |
904414 | 904414 | 2021-01-07 | Lake | California | 6033 | 2033 | 25 |
904490 | 904490 | 2021-01-07 | Lake | Colorado | 8065 | 457 | 0 |
904567 | 904567 | 2021-01-07 | Lake | Florida | 12069 | 17228 | 331 |
904861 | 904861 | 2021-01-07 | Lake | Illinois | 17097 | 50213 | 847 |
904959 | 904959 | 2021-01-07 | Lake | Indiana | 18089 | 41902 | 664 |
905496 | 905496 | 2021-01-07 | Lake | Michigan | 26085 | 311 | 10 |
905575 | 905575 | 2021-01-07 | Lake | Minnesota | 27075 | 576 | 15 |
905848 | 905848 | 2021-01-07 | Lake | Montana | 30047 | 1578 | 17 |
906314 | 906314 | 2021-01-07 | Lake | Ohio | 39085 | 13887 | 126 |
906456 | 906456 | 2021-01-07 | Lake | Oregon | 41037 | 217 | 4 |
906710 | 906710 | 2021-01-07 | Lake | South Dakota | 46079 | 1060 | 16 |
906785 | 906785 | 2021-01-07 | Lake | Tennessee | 47095 | 1491 | 16 |
901169 | 901169 | 2021-01-06 | Lake | California | 6033 | 2015 | 25 |
901245 | 901245 | 2021-01-06 | Lake | Colorado | 8065 | 448 | 0 |
901322 | 901322 | 2021-01-06 | Lake | Florida | 12069 | 16897 | 331 |
901616 | 901616 | 2021-01-06 | Lake | Illinois | 17097 | 49805 | 840 |
901714 | 901714 | 2021-01-06 | Lake | Indiana | 18089 | 41501 | 661 |
902251 | 902251 | 2021-01-06 | Lake | Michigan | 26085 | 310 | 10 |
902330 | 902330 | 2021-01-06 | Lake | Minnesota | 27075 | 574 | 15 |
902603 | 902603 | 2021-01-06 | Lake | Montana | 30047 | 1569 | 17 |
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 |
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);