ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Lake" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920716 | 920716 | 2021-01-12 | Lake | Colorado | 8065 | 465 | 0 |
917471 | 917471 | 2021-01-11 | Lake | Colorado | 8065 | 461 | 0 |
914226 | 914226 | 2021-01-10 | Lake | Colorado | 8065 | 461 | 0 |
910981 | 910981 | 2021-01-09 | Lake | Colorado | 8065 | 461 | 0 |
907736 | 907736 | 2021-01-08 | Lake | Colorado | 8065 | 458 | 0 |
904490 | 904490 | 2021-01-07 | Lake | Colorado | 8065 | 457 | 0 |
901245 | 901245 | 2021-01-06 | Lake | Colorado | 8065 | 448 | 0 |
898000 | 898000 | 2021-01-05 | Lake | Colorado | 8065 | 448 | 0 |
894755 | 894755 | 2021-01-04 | Lake | Colorado | 8065 | 444 | 0 |
891508 | 891508 | 2021-01-03 | Lake | Colorado | 8065 | 437 | 0 |
888261 | 888261 | 2021-01-02 | Lake | Colorado | 8065 | 437 | 0 |
885016 | 885016 | 2021-01-01 | Lake | Colorado | 8065 | 433 | 0 |
881771 | 881771 | 2020-12-31 | Lake | Colorado | 8065 | 426 | 0 |
878526 | 878526 | 2020-12-30 | Lake | Colorado | 8065 | 419 | 0 |
875281 | 875281 | 2020-12-29 | Lake | Colorado | 8065 | 413 | 0 |
872036 | 872036 | 2020-12-28 | Lake | Colorado | 8065 | 407 | 0 |
868791 | 868791 | 2020-12-27 | Lake | Colorado | 8065 | 401 | 0 |
865546 | 865546 | 2020-12-26 | Lake | Colorado | 8065 | 401 | 0 |
862301 | 862301 | 2020-12-25 | Lake | Colorado | 8065 | 401 | 0 |
859056 | 859056 | 2020-12-24 | Lake | Colorado | 8065 | 400 | 0 |
855811 | 855811 | 2020-12-23 | Lake | Colorado | 8065 | 399 | 0 |
852566 | 852566 | 2020-12-22 | Lake | Colorado | 8065 | 397 | 0 |
849321 | 849321 | 2020-12-21 | Lake | Colorado | 8065 | 392 | 0 |
846076 | 846076 | 2020-12-20 | Lake | Colorado | 8065 | 391 | 0 |
842830 | 842830 | 2020-12-19 | Lake | Colorado | 8065 | 387 | 0 |
839585 | 839585 | 2020-12-18 | Lake | Colorado | 8065 | 385 | 0 |
836340 | 836340 | 2020-12-17 | Lake | Colorado | 8065 | 383 | 0 |
833094 | 833094 | 2020-12-16 | Lake | Colorado | 8065 | 378 | 0 |
829847 | 829847 | 2020-12-15 | Lake | Colorado | 8065 | 371 | 0 |
826601 | 826601 | 2020-12-14 | Lake | Colorado | 8065 | 354 | 0 |
823354 | 823354 | 2020-12-13 | Lake | Colorado | 8065 | 354 | 0 |
820108 | 820108 | 2020-12-12 | Lake | Colorado | 8065 | 352 | 0 |
816862 | 816862 | 2020-12-11 | Lake | Colorado | 8065 | 350 | 0 |
813616 | 813616 | 2020-12-10 | Lake | Colorado | 8065 | 346 | 0 |
810372 | 810372 | 2020-12-09 | Lake | Colorado | 8065 | 340 | 0 |
807127 | 807127 | 2020-12-08 | Lake | Colorado | 8065 | 336 | 0 |
803882 | 803882 | 2020-12-07 | Lake | Colorado | 8065 | 333 | 0 |
800637 | 800637 | 2020-12-06 | Lake | Colorado | 8065 | 319 | 0 |
797392 | 797392 | 2020-12-05 | Lake | Colorado | 8065 | 318 | 0 |
794147 | 794147 | 2020-12-04 | Lake | Colorado | 8065 | 314 | 0 |
790902 | 790902 | 2020-12-03 | Lake | Colorado | 8065 | 304 | 0 |
787657 | 787657 | 2020-12-02 | Lake | Colorado | 8065 | 291 | 0 |
784413 | 784413 | 2020-12-01 | Lake | Colorado | 8065 | 281 | 0 |
781168 | 781168 | 2020-11-30 | Lake | Colorado | 8065 | 276 | 0 |
777922 | 777922 | 2020-11-29 | Lake | Colorado | 8065 | 273 | 0 |
774677 | 774677 | 2020-11-28 | Lake | Colorado | 8065 | 272 | 0 |
771432 | 771432 | 2020-11-27 | Lake | Colorado | 8065 | 267 | 0 |
768187 | 768187 | 2020-11-26 | Lake | Colorado | 8065 | 265 | 0 |
764941 | 764941 | 2020-11-25 | Lake | Colorado | 8065 | 255 | 0 |
761696 | 761696 | 2020-11-24 | Lake | Colorado | 8065 | 248 | 0 |
758451 | 758451 | 2020-11-23 | Lake | Colorado | 8065 | 239 | 0 |
755204 | 755204 | 2020-11-22 | Lake | Colorado | 8065 | 237 | 0 |
751958 | 751958 | 2020-11-21 | Lake | Colorado | 8065 | 230 | 0 |
748712 | 748712 | 2020-11-20 | Lake | Colorado | 8065 | 224 | 0 |
745466 | 745466 | 2020-11-19 | Lake | Colorado | 8065 | 221 | 0 |
742219 | 742219 | 2020-11-18 | Lake | Colorado | 8065 | 209 | 0 |
738972 | 738972 | 2020-11-17 | Lake | Colorado | 8065 | 202 | 0 |
735728 | 735728 | 2020-11-16 | Lake | Colorado | 8065 | 199 | 0 |
732482 | 732482 | 2020-11-15 | Lake | Colorado | 8065 | 196 | 0 |
729237 | 729237 | 2020-11-14 | Lake | Colorado | 8065 | 184 | 0 |
725994 | 725994 | 2020-11-13 | Lake | Colorado | 8065 | 181 | 0 |
722751 | 722751 | 2020-11-12 | Lake | Colorado | 8065 | 175 | 0 |
719508 | 719508 | 2020-11-11 | Lake | Colorado | 8065 | 173 | 0 |
716265 | 716265 | 2020-11-10 | Lake | Colorado | 8065 | 172 | 0 |
713021 | 713021 | 2020-11-09 | Lake | Colorado | 8065 | 168 | 0 |
709777 | 709777 | 2020-11-08 | Lake | Colorado | 8065 | 163 | 0 |
706533 | 706533 | 2020-11-07 | Lake | Colorado | 8065 | 162 | 0 |
703290 | 703290 | 2020-11-06 | Lake | Colorado | 8065 | 160 | 0 |
700047 | 700047 | 2020-11-05 | Lake | Colorado | 8065 | 155 | 0 |
696803 | 696803 | 2020-11-04 | Lake | Colorado | 8065 | 152 | 0 |
693561 | 693561 | 2020-11-03 | Lake | Colorado | 8065 | 151 | 0 |
690318 | 690318 | 2020-11-02 | Lake | Colorado | 8065 | 151 | 0 |
687073 | 687073 | 2020-11-01 | Lake | Colorado | 8065 | 143 | 0 |
683829 | 683829 | 2020-10-31 | Lake | Colorado | 8065 | 143 | 0 |
680586 | 680586 | 2020-10-30 | Lake | Colorado | 8065 | 135 | 0 |
677343 | 677343 | 2020-10-29 | Lake | Colorado | 8065 | 135 | 0 |
674100 | 674100 | 2020-10-28 | Lake | Colorado | 8065 | 133 | 0 |
670858 | 670858 | 2020-10-27 | Lake | Colorado | 8065 | 133 | 0 |
667615 | 667615 | 2020-10-26 | Lake | Colorado | 8065 | 133 | 0 |
664370 | 664370 | 2020-10-25 | Lake | Colorado | 8065 | 132 | 0 |
661126 | 661126 | 2020-10-24 | Lake | Colorado | 8065 | 127 | 0 |
657882 | 657882 | 2020-10-23 | Lake | Colorado | 8065 | 124 | 0 |
654637 | 654637 | 2020-10-22 | Lake | Colorado | 8065 | 122 | 0 |
651392 | 651392 | 2020-10-21 | Lake | Colorado | 8065 | 122 | 0 |
648148 | 648148 | 2020-10-20 | Lake | Colorado | 8065 | 121 | 0 |
644903 | 644903 | 2020-10-19 | Lake | Colorado | 8065 | 118 | 0 |
641655 | 641655 | 2020-10-18 | Lake | Colorado | 8065 | 117 | 0 |
638408 | 638408 | 2020-10-17 | Lake | Colorado | 8065 | 117 | 0 |
635163 | 635163 | 2020-10-16 | Lake | Colorado | 8065 | 116 | 0 |
631917 | 631917 | 2020-10-15 | Lake | Colorado | 8065 | 114 | 0 |
628673 | 628673 | 2020-10-14 | Lake | Colorado | 8065 | 112 | 0 |
625430 | 625430 | 2020-10-13 | Lake | Colorado | 8065 | 110 | 0 |
622187 | 622187 | 2020-10-12 | Lake | Colorado | 8065 | 105 | 0 |
618944 | 618944 | 2020-10-11 | Lake | Colorado | 8065 | 105 | 0 |
615702 | 615702 | 2020-10-10 | Lake | Colorado | 8065 | 104 | 0 |
612461 | 612461 | 2020-10-09 | Lake | Colorado | 8065 | 104 | 0 |
609219 | 609219 | 2020-10-08 | Lake | Colorado | 8065 | 103 | 0 |
605976 | 605976 | 2020-10-07 | Lake | Colorado | 8065 | 101 | 0 |
602734 | 602734 | 2020-10-06 | Lake | Colorado | 8065 | 99 | 0 |
599491 | 599491 | 2020-10-05 | Lake | Colorado | 8065 | 99 | 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);