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 |
---|---|---|---|---|---|---|---|
1193311 | 1193311 | 2021-04-06 | Lake | California | 6033 | 3359 | 43 |
1193387 | 1193387 | 2021-04-06 | Lake | Colorado | 8065 | 705 | 0 |
1193464 | 1193464 | 2021-04-06 | Lake | Florida | 12069 | 27081 | 611 |
1193758 | 1193758 | 2021-04-06 | Lake | Illinois | 17097 | 62986 | 1027 |
1193857 | 1193857 | 2021-04-06 | Lake | Indiana | 18089 | 50478 | 962 |
1194393 | 1194393 | 2021-04-06 | Lake | Michigan | 26085 | 461 | 12 |
1194472 | 1194472 | 2021-04-06 | Lake | Minnesota | 27075 | 772 | 19 |
1194745 | 1194745 | 2021-04-06 | Lake | Montana | 30047 | 1987 | 30 |
1195211 | 1195211 | 2021-04-06 | Lake | Ohio | 39085 | 19494 | 357 |
1195354 | 1195354 | 2021-04-06 | Lake | Oregon | 41037 | 406 | 7 |
1195608 | 1195608 | 2021-04-06 | Lake | South Dakota | 46079 | 1314 | 18 |
1195683 | 1195683 | 2021-04-06 | Lake | Tennessee | 47095 | 1693 | 26 |
1190061 | 1190061 | 2021-04-05 | Lake | California | 6033 | 3355 | 43 |
1190137 | 1190137 | 2021-04-05 | Lake | Colorado | 8065 | 703 | 0 |
1190214 | 1190214 | 2021-04-05 | Lake | Florida | 12069 | 27028 | 611 |
1190508 | 1190508 | 2021-04-05 | Lake | Illinois | 17097 | 62863 | 1026 |
1190607 | 1190607 | 2021-04-05 | Lake | Indiana | 18089 | 50426 | 961 |
1191144 | 1191144 | 2021-04-05 | Lake | Michigan | 26085 | 458 | 12 |
1191223 | 1191223 | 2021-04-05 | Lake | Minnesota | 27075 | 772 | 19 |
1191496 | 1191496 | 2021-04-05 | Lake | Montana | 30047 | 1987 | 30 |
1191963 | 1191963 | 2021-04-05 | Lake | Ohio | 39085 | 19438 | 355 |
1192106 | 1192106 | 2021-04-05 | Lake | Oregon | 41037 | 406 | 7 |
1192360 | 1192360 | 2021-04-05 | Lake | South Dakota | 46079 | 1314 | 18 |
1192435 | 1192435 | 2021-04-05 | Lake | Tennessee | 47095 | 1693 | 26 |
1186814 | 1186814 | 2021-04-04 | Lake | California | 6033 | 3350 | 43 |
1186890 | 1186890 | 2021-04-04 | Lake | Colorado | 8065 | 702 | 0 |
1186967 | 1186967 | 2021-04-04 | Lake | Florida | 12069 | 26983 | 610 |
1187261 | 1187261 | 2021-04-04 | Lake | Illinois | 17097 | 62746 | 1024 |
1187360 | 1187360 | 2021-04-04 | Lake | Indiana | 18089 | 50374 | 961 |
1187896 | 1187896 | 2021-04-04 | Lake | Michigan | 26085 | 448 | 12 |
1187975 | 1187975 | 2021-04-04 | Lake | Minnesota | 27075 | 772 | 19 |
1188248 | 1188248 | 2021-04-04 | Lake | Montana | 30047 | 1987 | 30 |
1188714 | 1188714 | 2021-04-04 | Lake | Ohio | 39085 | 19370 | 355 |
1188857 | 1188857 | 2021-04-04 | Lake | Oregon | 41037 | 406 | 7 |
1189111 | 1189111 | 2021-04-04 | Lake | South Dakota | 46079 | 1311 | 18 |
1189186 | 1189186 | 2021-04-04 | Lake | Tennessee | 47095 | 1689 | 26 |
1183567 | 1183567 | 2021-04-03 | Lake | California | 6033 | 3348 | 43 |
1183643 | 1183643 | 2021-04-03 | Lake | Colorado | 8065 | 704 | 0 |
1183720 | 1183720 | 2021-04-03 | Lake | Florida | 12069 | 26924 | 610 |
1184014 | 1184014 | 2021-04-03 | Lake | Illinois | 17097 | 62686 | 1024 |
1184113 | 1184113 | 2021-04-03 | Lake | Indiana | 18089 | 50299 | 961 |
1184649 | 1184649 | 2021-04-03 | Lake | Michigan | 26085 | 448 | 12 |
1184728 | 1184728 | 2021-04-03 | Lake | Minnesota | 27075 | 772 | 19 |
1185001 | 1185001 | 2021-04-03 | Lake | Montana | 30047 | 1987 | 30 |
1185467 | 1185467 | 2021-04-03 | Lake | Ohio | 39085 | 19370 | 355 |
1185610 | 1185610 | 2021-04-03 | Lake | Oregon | 41037 | 406 | 7 |
1185864 | 1185864 | 2021-04-03 | Lake | South Dakota | 46079 | 1311 | 18 |
1185939 | 1185939 | 2021-04-03 | Lake | Tennessee | 47095 | 1689 | 26 |
1180320 | 1180320 | 2021-04-02 | Lake | California | 6033 | 3337 | 43 |
1180396 | 1180396 | 2021-04-02 | Lake | Colorado | 8065 | 701 | 0 |
1180473 | 1180473 | 2021-04-02 | Lake | Florida | 12069 | 26862 | 609 |
1180767 | 1180767 | 2021-04-02 | Lake | Illinois | 17097 | 62533 | 1023 |
1180866 | 1180866 | 2021-04-02 | Lake | Indiana | 18089 | 50220 | 960 |
1181403 | 1181403 | 2021-04-02 | Lake | Michigan | 26085 | 444 | 12 |
1181482 | 1181482 | 2021-04-02 | Lake | Minnesota | 27075 | 770 | 19 |
1181755 | 1181755 | 2021-04-02 | Lake | Montana | 30047 | 1986 | 28 |
1182220 | 1182220 | 2021-04-02 | Lake | Ohio | 39085 | 19322 | 355 |
1182363 | 1182363 | 2021-04-02 | Lake | Oregon | 41037 | 405 | 6 |
1182617 | 1182617 | 2021-04-02 | Lake | South Dakota | 46079 | 1307 | 18 |
1182692 | 1182692 | 2021-04-02 | Lake | Tennessee | 47095 | 1689 | 26 |
1177073 | 1177073 | 2021-04-01 | Lake | California | 6033 | 3332 | 43 |
1177149 | 1177149 | 2021-04-01 | Lake | Colorado | 8065 | 699 | 0 |
1177226 | 1177226 | 2021-04-01 | Lake | Florida | 12069 | 26776 | 607 |
1177520 | 1177520 | 2021-04-01 | Lake | Illinois | 17097 | 62368 | 1023 |
1177619 | 1177619 | 2021-04-01 | Lake | Indiana | 18089 | 50135 | 958 |
1178156 | 1178156 | 2021-04-01 | Lake | Michigan | 26085 | 436 | 12 |
1178235 | 1178235 | 2021-04-01 | Lake | Minnesota | 27075 | 770 | 19 |
1178508 | 1178508 | 2021-04-01 | Lake | Montana | 30047 | 1984 | 26 |
1178973 | 1178973 | 2021-04-01 | Lake | Ohio | 39085 | 19288 | 354 |
1179116 | 1179116 | 2021-04-01 | Lake | Oregon | 41037 | 404 | 6 |
1179370 | 1179370 | 2021-04-01 | Lake | South Dakota | 46079 | 1302 | 18 |
1179445 | 1179445 | 2021-04-01 | Lake | Tennessee | 47095 | 1689 | 26 |
1173826 | 1173826 | 2021-03-31 | Lake | California | 6033 | 3330 | 43 |
1173902 | 1173902 | 2021-03-31 | Lake | Colorado | 8065 | 699 | 0 |
1173979 | 1173979 | 2021-03-31 | Lake | Florida | 12069 | 26679 | 606 |
1174273 | 1174273 | 2021-03-31 | Lake | Illinois | 17097 | 62242 | 1023 |
1174372 | 1174372 | 2021-03-31 | Lake | Indiana | 18089 | 50057 | 957 |
1174909 | 1174909 | 2021-03-31 | Lake | Michigan | 26085 | 432 | 12 |
1174988 | 1174988 | 2021-03-31 | Lake | Minnesota | 27075 | 769 | 19 |
1175261 | 1175261 | 2021-03-31 | Lake | Montana | 30047 | 1982 | 26 |
1175726 | 1175726 | 2021-03-31 | Lake | Ohio | 39085 | 19238 | 354 |
1175869 | 1175869 | 2021-03-31 | Lake | Oregon | 41037 | 404 | 6 |
1176123 | 1176123 | 2021-03-31 | Lake | South Dakota | 46079 | 1298 | 18 |
1176198 | 1176198 | 2021-03-31 | Lake | Tennessee | 47095 | 1688 | 26 |
1170579 | 1170579 | 2021-03-30 | Lake | California | 6033 | 3325 | 43 |
1170655 | 1170655 | 2021-03-30 | Lake | Colorado | 8065 | 697 | 0 |
1170732 | 1170732 | 2021-03-30 | Lake | Florida | 12069 | 26604 | 601 |
1171026 | 1171026 | 2021-03-30 | Lake | Illinois | 17097 | 62133 | 1022 |
1171125 | 1171125 | 2021-03-30 | Lake | Indiana | 18089 | 50006 | 957 |
1171662 | 1171662 | 2021-03-30 | Lake | Michigan | 26085 | 427 | 12 |
1171741 | 1171741 | 2021-03-30 | Lake | Minnesota | 27075 | 766 | 19 |
1172014 | 1172014 | 2021-03-30 | Lake | Montana | 30047 | 1978 | 26 |
1172479 | 1172479 | 2021-03-30 | Lake | Ohio | 39085 | 19199 | 354 |
1172622 | 1172622 | 2021-03-30 | Lake | Oregon | 41037 | 403 | 6 |
1172876 | 1172876 | 2021-03-30 | Lake | South Dakota | 46079 | 1292 | 18 |
1172951 | 1172951 | 2021-03-30 | Lake | Tennessee | 47095 | 1687 | 26 |
1167331 | 1167331 | 2021-03-29 | Lake | California | 6033 | 3320 | 43 |
1167407 | 1167407 | 2021-03-29 | Lake | Colorado | 8065 | 697 | 0 |
1167484 | 1167484 | 2021-03-29 | Lake | Florida | 12069 | 26507 | 600 |
1167778 | 1167778 | 2021-03-29 | Lake | Illinois | 17097 | 62024 | 1021 |
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);