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 |
---|---|---|---|---|---|---|---|
247087 | 247087 | 2020-06-17 | Lake | Indiana | 18089 | 4257 | 246 |
247608 | 247608 | 2020-06-17 | Lake | Michigan | 26085 | 7 | 0 |
247686 | 247686 | 2020-06-17 | Lake | Minnesota | 27075 | 4 | 0 |
247943 | 247943 | 2020-06-17 | Lake | Montana | 30047 | 9 | 0 |
248365 | 248365 | 2020-06-17 | Lake | Ohio | 39085 | 354 | 12 |
248502 | 248502 | 2020-06-17 | Lake | Oregon | 41037 | 6 | 0 |
248750 | 248750 | 2020-06-17 | Lake | South Dakota | 46079 | 17 | 1 |
248823 | 248823 | 2020-06-17 | Lake | Tennessee | 47095 | 689 | 0 |
243444 | 243444 | 2020-06-16 | Lake | California | 6033 | 34 | 0 |
243516 | 243516 | 2020-06-16 | Lake | Colorado | 8065 | 39 | 0 |
243592 | 243592 | 2020-06-16 | Lake | Florida | 12069 | 498 | 16 |
243876 | 243876 | 2020-06-16 | Lake | Illinois | 17097 | 9147 | 386 |
243974 | 243974 | 2020-06-16 | Lake | Indiana | 18089 | 4246 | 245 |
244495 | 244495 | 2020-06-16 | Lake | Michigan | 26085 | 7 | 0 |
244573 | 244573 | 2020-06-16 | Lake | Minnesota | 27075 | 2 | 0 |
244830 | 244830 | 2020-06-16 | Lake | Montana | 30047 | 9 | 0 |
245252 | 245252 | 2020-06-16 | Lake | Ohio | 39085 | 350 | 12 |
245389 | 245389 | 2020-06-16 | Lake | Oregon | 41037 | 5 | 0 |
245637 | 245637 | 2020-06-16 | Lake | South Dakota | 46079 | 16 | 1 |
245710 | 245710 | 2020-06-16 | Lake | Tennessee | 47095 | 689 | 0 |
240333 | 240333 | 2020-06-15 | Lake | California | 6033 | 34 | 0 |
240405 | 240405 | 2020-06-15 | Lake | Colorado | 8065 | 39 | 0 |
240481 | 240481 | 2020-06-15 | Lake | Florida | 12069 | 482 | 16 |
240765 | 240765 | 2020-06-15 | Lake | Illinois | 17097 | 9123 | 375 |
240863 | 240863 | 2020-06-15 | Lake | Indiana | 18089 | 4207 | 245 |
241384 | 241384 | 2020-06-15 | Lake | Michigan | 26085 | 7 | 0 |
241462 | 241462 | 2020-06-15 | Lake | Minnesota | 27075 | 1 | 0 |
241719 | 241719 | 2020-06-15 | Lake | Montana | 30047 | 9 | 0 |
242140 | 242140 | 2020-06-15 | Lake | Ohio | 39085 | 348 | 12 |
242277 | 242277 | 2020-06-15 | Lake | Oregon | 41037 | 5 | 0 |
242525 | 242525 | 2020-06-15 | Lake | South Dakota | 46079 | 15 | 1 |
242598 | 242598 | 2020-06-15 | Lake | Tennessee | 47095 | 690 | 0 |
237225 | 237225 | 2020-06-14 | Lake | California | 6033 | 31 | 0 |
237297 | 237297 | 2020-06-14 | Lake | Colorado | 8065 | 39 | 0 |
237373 | 237373 | 2020-06-14 | Lake | Florida | 12069 | 464 | 16 |
237657 | 237657 | 2020-06-14 | Lake | Illinois | 17097 | 9076 | 374 |
237755 | 237755 | 2020-06-14 | Lake | Indiana | 18089 | 4168 | 245 |
238275 | 238275 | 2020-06-14 | Lake | Michigan | 26085 | 7 | 0 |
238353 | 238353 | 2020-06-14 | Lake | Minnesota | 27075 | 1 | 0 |
238609 | 238609 | 2020-06-14 | Lake | Montana | 30047 | 9 | 0 |
239031 | 239031 | 2020-06-14 | Lake | Ohio | 39085 | 347 | 12 |
239168 | 239168 | 2020-06-14 | Lake | Oregon | 41037 | 4 | 0 |
239415 | 239415 | 2020-06-14 | Lake | South Dakota | 46079 | 14 | 1 |
239488 | 239488 | 2020-06-14 | Lake | Tennessee | 47095 | 690 | 0 |
234118 | 234118 | 2020-06-13 | Lake | California | 6033 | 31 | 0 |
234190 | 234190 | 2020-06-13 | Lake | Colorado | 8065 | 38 | 0 |
234266 | 234266 | 2020-06-13 | Lake | Florida | 12069 | 452 | 16 |
234550 | 234550 | 2020-06-13 | Lake | Illinois | 17097 | 9033 | 374 |
234648 | 234648 | 2020-06-13 | Lake | Indiana | 18089 | 4144 | 243 |
235168 | 235168 | 2020-06-13 | Lake | Michigan | 26085 | 7 | 0 |
235246 | 235246 | 2020-06-13 | Lake | Minnesota | 27075 | 1 | 0 |
235502 | 235502 | 2020-06-13 | Lake | Montana | 30047 | 9 | 0 |
235923 | 235923 | 2020-06-13 | Lake | Ohio | 39085 | 346 | 12 |
236060 | 236060 | 2020-06-13 | Lake | Oregon | 41037 | 4 | 0 |
236307 | 236307 | 2020-06-13 | Lake | South Dakota | 46079 | 14 | 1 |
236380 | 236380 | 2020-06-13 | Lake | Tennessee | 47095 | 690 | 0 |
231012 | 231012 | 2020-06-12 | Lake | California | 6033 | 31 | 0 |
231084 | 231084 | 2020-06-12 | Lake | Colorado | 8065 | 38 | 0 |
231160 | 231160 | 2020-06-12 | Lake | Florida | 12069 | 383 | 15 |
231444 | 231444 | 2020-06-12 | Lake | Illinois | 17097 | 9021 | 372 |
231542 | 231542 | 2020-06-12 | Lake | Indiana | 18089 | 4116 | 239 |
232063 | 232063 | 2020-06-12 | Lake | Michigan | 26085 | 7 | 0 |
232140 | 232140 | 2020-06-12 | Lake | Minnesota | 27075 | 1 | 0 |
232396 | 232396 | 2020-06-12 | Lake | Montana | 30047 | 6 | 0 |
232818 | 232818 | 2020-06-12 | Lake | Ohio | 39085 | 344 | 12 |
232955 | 232955 | 2020-06-12 | Lake | Oregon | 41037 | 4 | 0 |
233202 | 233202 | 2020-06-12 | Lake | South Dakota | 46079 | 14 | 1 |
233274 | 233274 | 2020-06-12 | Lake | Tennessee | 47095 | 691 | 0 |
227909 | 227909 | 2020-06-11 | Lake | California | 6033 | 30 | 0 |
227981 | 227981 | 2020-06-11 | Lake | Colorado | 8065 | 38 | 0 |
228057 | 228057 | 2020-06-11 | Lake | Florida | 12069 | 355 | 15 |
228341 | 228341 | 2020-06-11 | Lake | Illinois | 17097 | 8962 | 367 |
228439 | 228439 | 2020-06-11 | Lake | Indiana | 18089 | 4092 | 238 |
228959 | 228959 | 2020-06-11 | Lake | Michigan | 26085 | 7 | 0 |
229036 | 229036 | 2020-06-11 | Lake | Minnesota | 27075 | 1 | 0 |
229291 | 229291 | 2020-06-11 | Lake | Montana | 30047 | 5 | 0 |
229713 | 229713 | 2020-06-11 | Lake | Ohio | 39085 | 338 | 12 |
229850 | 229850 | 2020-06-11 | Lake | Oregon | 41037 | 4 | 0 |
230097 | 230097 | 2020-06-11 | Lake | South Dakota | 46079 | 13 | 1 |
230169 | 230169 | 2020-06-11 | Lake | Tennessee | 47095 | 688 | 0 |
224807 | 224807 | 2020-06-10 | Lake | California | 6033 | 30 | 0 |
224879 | 224879 | 2020-06-10 | Lake | Colorado | 8065 | 38 | 0 |
224955 | 224955 | 2020-06-10 | Lake | Florida | 12069 | 342 | 15 |
225239 | 225239 | 2020-06-10 | Lake | Illinois | 17097 | 8924 | 362 |
225337 | 225337 | 2020-06-10 | Lake | Indiana | 18089 | 4068 | 234 |
225857 | 225857 | 2020-06-10 | Lake | Michigan | 26085 | 7 | 0 |
225934 | 225934 | 2020-06-10 | Lake | Minnesota | 27075 | 1 | 0 |
226188 | 226188 | 2020-06-10 | Lake | Montana | 30047 | 5 | 0 |
226609 | 226609 | 2020-06-10 | Lake | Ohio | 39085 | 337 | 12 |
226746 | 226746 | 2020-06-10 | Lake | Oregon | 41037 | 2 | 0 |
226993 | 226993 | 2020-06-10 | Lake | South Dakota | 46079 | 13 | 1 |
227065 | 227065 | 2020-06-10 | Lake | Tennessee | 47095 | 712 | 0 |
221712 | 221712 | 2020-06-09 | Lake | California | 6033 | 30 | 0 |
221784 | 221784 | 2020-06-09 | Lake | Colorado | 8065 | 38 | 0 |
221860 | 221860 | 2020-06-09 | Lake | Florida | 12069 | 339 | 15 |
222144 | 222144 | 2020-06-09 | Lake | Illinois | 17097 | 8890 | 356 |
222242 | 222242 | 2020-06-09 | Lake | Indiana | 18089 | 4040 | 232 |
222759 | 222759 | 2020-06-09 | Lake | Michigan | 26085 | 7 | 0 |
222836 | 222836 | 2020-06-09 | Lake | Minnesota | 27075 | 1 | 0 |
223089 | 223089 | 2020-06-09 | Lake | Montana | 30047 | 5 | 0 |
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);