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 |
---|---|---|---|---|---|---|---|
534625 | 534625 | 2020-09-15 | Lake | California | 6033 | 407 | 7 |
534700 | 534700 | 2020-09-15 | Lake | Colorado | 8065 | 87 | 0 |
534777 | 534777 | 2020-09-15 | Lake | Florida | 12069 | 7092 | 156 |
535070 | 535070 | 2020-09-15 | Lake | Illinois | 17097 | 15906 | 481 |
535169 | 535169 | 2020-09-15 | Lake | Indiana | 18089 | 10000 | 327 |
535704 | 535704 | 2020-09-15 | Lake | Michigan | 26085 | 32 | 0 |
535783 | 535783 | 2020-09-15 | Lake | Minnesota | 27075 | 48 | 0 |
536055 | 536055 | 2020-09-15 | Lake | Montana | 30047 | 243 | 1 |
536518 | 536518 | 2020-09-15 | Lake | Ohio | 39085 | 1530 | 46 |
536660 | 536660 | 2020-09-15 | Lake | Oregon | 41037 | 29 | 0 |
536913 | 536913 | 2020-09-15 | Lake | South Dakota | 46079 | 153 | 6 |
536988 | 536988 | 2020-09-15 | Lake | Tennessee | 47095 | 863 | 2 |
531390 | 531390 | 2020-09-14 | Lake | California | 6033 | 397 | 7 |
531465 | 531465 | 2020-09-14 | Lake | Colorado | 8065 | 87 | 0 |
531542 | 531542 | 2020-09-14 | Lake | Florida | 12069 | 7063 | 147 |
531835 | 531835 | 2020-09-14 | Lake | Illinois | 17097 | 15832 | 481 |
531934 | 531934 | 2020-09-14 | Lake | Indiana | 18089 | 9963 | 326 |
532469 | 532469 | 2020-09-14 | Lake | Michigan | 26085 | 32 | 0 |
532548 | 532548 | 2020-09-14 | Lake | Minnesota | 27075 | 48 | 0 |
532820 | 532820 | 2020-09-14 | Lake | Montana | 30047 | 241 | 1 |
533282 | 533282 | 2020-09-14 | Lake | Ohio | 39085 | 1516 | 46 |
533424 | 533424 | 2020-09-14 | Lake | Oregon | 41037 | 29 | 0 |
533677 | 533677 | 2020-09-14 | Lake | South Dakota | 46079 | 149 | 6 |
533752 | 533752 | 2020-09-14 | Lake | Tennessee | 47095 | 863 | 2 |
528153 | 528153 | 2020-09-13 | Lake | California | 6033 | 393 | 7 |
528228 | 528228 | 2020-09-13 | Lake | Colorado | 8065 | 87 | 0 |
528305 | 528305 | 2020-09-13 | Lake | Florida | 12069 | 7046 | 147 |
528598 | 528598 | 2020-09-13 | Lake | Illinois | 17097 | 15776 | 481 |
528697 | 528697 | 2020-09-13 | Lake | Indiana | 18089 | 9913 | 326 |
529233 | 529233 | 2020-09-13 | Lake | Michigan | 26085 | 32 | 0 |
529312 | 529312 | 2020-09-13 | Lake | Minnesota | 27075 | 47 | 0 |
529584 | 529584 | 2020-09-13 | Lake | Montana | 30047 | 241 | 1 |
530047 | 530047 | 2020-09-13 | Lake | Ohio | 39085 | 1507 | 45 |
530189 | 530189 | 2020-09-13 | Lake | Oregon | 41037 | 29 | 0 |
530442 | 530442 | 2020-09-13 | Lake | South Dakota | 46079 | 148 | 6 |
530517 | 530517 | 2020-09-13 | Lake | Tennessee | 47095 | 857 | 2 |
524917 | 524917 | 2020-09-12 | Lake | California | 6033 | 382 | 7 |
524992 | 524992 | 2020-09-12 | Lake | Colorado | 8065 | 86 | 0 |
525069 | 525069 | 2020-09-12 | Lake | Florida | 12069 | 7021 | 147 |
525362 | 525362 | 2020-09-12 | Lake | Illinois | 17097 | 15700 | 478 |
525461 | 525461 | 2020-09-12 | Lake | Indiana | 18089 | 9852 | 326 |
525997 | 525997 | 2020-09-12 | Lake | Michigan | 26085 | 32 | 0 |
526076 | 526076 | 2020-09-12 | Lake | Minnesota | 27075 | 47 | 0 |
526348 | 526348 | 2020-09-12 | Lake | Montana | 30047 | 232 | 1 |
526810 | 526810 | 2020-09-12 | Lake | Ohio | 39085 | 1502 | 45 |
526952 | 526952 | 2020-09-12 | Lake | Oregon | 41037 | 29 | 0 |
527205 | 527205 | 2020-09-12 | Lake | South Dakota | 46079 | 145 | 6 |
527280 | 527280 | 2020-09-12 | Lake | Tennessee | 47095 | 856 | 2 |
521681 | 521681 | 2020-09-11 | Lake | California | 6033 | 377 | 6 |
521756 | 521756 | 2020-09-11 | Lake | Colorado | 8065 | 85 | 0 |
521833 | 521833 | 2020-09-11 | Lake | Florida | 12069 | 6972 | 140 |
522126 | 522126 | 2020-09-11 | Lake | Illinois | 17097 | 15592 | 477 |
522225 | 522225 | 2020-09-11 | Lake | Indiana | 18089 | 9793 | 325 |
522761 | 522761 | 2020-09-11 | Lake | Michigan | 26085 | 32 | 0 |
522840 | 522840 | 2020-09-11 | Lake | Minnesota | 27075 | 44 | 0 |
523112 | 523112 | 2020-09-11 | Lake | Montana | 30047 | 232 | 1 |
523574 | 523574 | 2020-09-11 | Lake | Ohio | 39085 | 1463 | 45 |
523716 | 523716 | 2020-09-11 | Lake | Oregon | 41037 | 29 | 0 |
523969 | 523969 | 2020-09-11 | Lake | South Dakota | 46079 | 142 | 6 |
524044 | 524044 | 2020-09-11 | Lake | Tennessee | 47095 | 854 | 2 |
518444 | 518444 | 2020-09-10 | Lake | California | 6033 | 371 | 6 |
518519 | 518519 | 2020-09-10 | Lake | Colorado | 8065 | 84 | 0 |
518596 | 518596 | 2020-09-10 | Lake | Florida | 12069 | 6921 | 136 |
518889 | 518889 | 2020-09-10 | Lake | Illinois | 17097 | 15486 | 476 |
518988 | 518988 | 2020-09-10 | Lake | Indiana | 18089 | 9709 | 322 |
519524 | 519524 | 2020-09-10 | Lake | Michigan | 26085 | 31 | 0 |
519603 | 519603 | 2020-09-10 | Lake | Minnesota | 27075 | 44 | 0 |
519875 | 519875 | 2020-09-10 | Lake | Montana | 30047 | 227 | 1 |
520338 | 520338 | 2020-09-10 | Lake | Ohio | 39085 | 1459 | 45 |
520480 | 520480 | 2020-09-10 | Lake | Oregon | 41037 | 30 | 0 |
520733 | 520733 | 2020-09-10 | Lake | South Dakota | 46079 | 140 | 6 |
520808 | 520808 | 2020-09-10 | Lake | Tennessee | 47095 | 853 | 2 |
515209 | 515209 | 2020-09-09 | Lake | California | 6033 | 370 | 5 |
515284 | 515284 | 2020-09-09 | Lake | Colorado | 8065 | 83 | 0 |
515361 | 515361 | 2020-09-09 | Lake | Florida | 12069 | 6871 | 131 |
515654 | 515654 | 2020-09-09 | Lake | Illinois | 17097 | 15407 | 475 |
515753 | 515753 | 2020-09-09 | Lake | Indiana | 18089 | 9662 | 319 |
516289 | 516289 | 2020-09-09 | Lake | Michigan | 26085 | 30 | 0 |
516368 | 516368 | 2020-09-09 | Lake | Minnesota | 27075 | 44 | 0 |
516640 | 516640 | 2020-09-09 | Lake | Montana | 30047 | 227 | 1 |
517102 | 517102 | 2020-09-09 | Lake | Ohio | 39085 | 1444 | 45 |
517244 | 517244 | 2020-09-09 | Lake | Oregon | 41037 | 30 | 0 |
517497 | 517497 | 2020-09-09 | Lake | South Dakota | 46079 | 135 | 6 |
517572 | 517572 | 2020-09-09 | Lake | Tennessee | 47095 | 850 | 2 |
511976 | 511976 | 2020-09-08 | Lake | California | 6033 | 367 | 5 |
512051 | 512051 | 2020-09-08 | Lake | Colorado | 8065 | 83 | 0 |
512128 | 512128 | 2020-09-08 | Lake | Florida | 12069 | 6841 | 128 |
512421 | 512421 | 2020-09-08 | Lake | Illinois | 17097 | 15354 | 473 |
512520 | 512520 | 2020-09-08 | Lake | Indiana | 18089 | 9628 | 317 |
513055 | 513055 | 2020-09-08 | Lake | Michigan | 26085 | 30 | 0 |
513134 | 513134 | 2020-09-08 | Lake | Minnesota | 27075 | 44 | 0 |
513406 | 513406 | 2020-09-08 | Lake | Montana | 30047 | 224 | 1 |
513867 | 513867 | 2020-09-08 | Lake | Ohio | 39085 | 1438 | 45 |
514009 | 514009 | 2020-09-08 | Lake | Oregon | 41037 | 30 | 0 |
514262 | 514262 | 2020-09-08 | Lake | South Dakota | 46079 | 131 | 6 |
514337 | 514337 | 2020-09-08 | Lake | Tennessee | 47095 | 848 | 2 |
508743 | 508743 | 2020-09-07 | Lake | California | 6033 | 362 | 5 |
508818 | 508818 | 2020-09-07 | Lake | Colorado | 8065 | 82 | 0 |
508895 | 508895 | 2020-09-07 | Lake | Florida | 12069 | 6824 | 129 |
509188 | 509188 | 2020-09-07 | Lake | Illinois | 17097 | 15250 | 473 |
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);