ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Lake" and fips = 12069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920793 | 920793 | 2021-01-12 | Lake | Florida | 12069 | 18333 | 336 |
917548 | 917548 | 2021-01-11 | Lake | Florida | 12069 | 18142 | 335 |
914303 | 914303 | 2021-01-10 | Lake | Florida | 12069 | 17973 | 334 |
911058 | 911058 | 2021-01-09 | Lake | Florida | 12069 | 17742 | 333 |
907813 | 907813 | 2021-01-08 | Lake | Florida | 12069 | 17489 | 331 |
904567 | 904567 | 2021-01-07 | Lake | Florida | 12069 | 17228 | 331 |
901322 | 901322 | 2021-01-06 | Lake | Florida | 12069 | 16897 | 331 |
898077 | 898077 | 2021-01-05 | Lake | Florida | 12069 | 16697 | 336 |
894832 | 894832 | 2021-01-04 | Lake | Florida | 12069 | 16483 | 318 |
891585 | 891585 | 2021-01-03 | Lake | Florida | 12069 | 16261 | 308 |
888338 | 888338 | 2021-01-02 | Lake | Florida | 12069 | 16106 | 302 |
885093 | 885093 | 2021-01-01 | Lake | Florida | 12069 | 15559 | 295 |
881848 | 881848 | 2020-12-31 | Lake | Florida | 12069 | 15559 | 295 |
878603 | 878603 | 2020-12-30 | Lake | Florida | 12069 | 15201 | 295 |
875358 | 875358 | 2020-12-29 | Lake | Florida | 12069 | 14998 | 294 |
872113 | 872113 | 2020-12-28 | Lake | Florida | 12069 | 14841 | 293 |
868868 | 868868 | 2020-12-27 | Lake | Florida | 12069 | 14723 | 290 |
865623 | 865623 | 2020-12-26 | Lake | Florida | 12069 | 14627 | 288 |
862378 | 862378 | 2020-12-25 | Lake | Florida | 12069 | 14280 | 287 |
859133 | 859133 | 2020-12-24 | Lake | Florida | 12069 | 14280 | 287 |
855888 | 855888 | 2020-12-23 | Lake | Florida | 12069 | 14062 | 286 |
852643 | 852643 | 2020-12-22 | Lake | Florida | 12069 | 13863 | 286 |
849398 | 849398 | 2020-12-21 | Lake | Florida | 12069 | 13698 | 286 |
846153 | 846153 | 2020-12-20 | Lake | Florida | 12069 | 13492 | 285 |
842907 | 842907 | 2020-12-19 | Lake | Florida | 12069 | 13341 | 285 |
839662 | 839662 | 2020-12-18 | Lake | Florida | 12069 | 13157 | 283 |
836417 | 836417 | 2020-12-17 | Lake | Florida | 12069 | 12966 | 276 |
833171 | 833171 | 2020-12-16 | Lake | Florida | 12069 | 12727 | 275 |
829924 | 829924 | 2020-12-15 | Lake | Florida | 12069 | 12571 | 275 |
826678 | 826678 | 2020-12-14 | Lake | Florida | 12069 | 12435 | 274 |
823431 | 823431 | 2020-12-13 | Lake | Florida | 12069 | 12291 | 271 |
820185 | 820185 | 2020-12-12 | Lake | Florida | 12069 | 12136 | 270 |
816939 | 816939 | 2020-12-11 | Lake | Florida | 12069 | 11985 | 267 |
813693 | 813693 | 2020-12-10 | Lake | Florida | 12069 | 11798 | 265 |
810449 | 810449 | 2020-12-09 | Lake | Florida | 12069 | 11638 | 265 |
807204 | 807204 | 2020-12-08 | Lake | Florida | 12069 | 11524 | 262 |
803959 | 803959 | 2020-12-07 | Lake | Florida | 12069 | 11301 | 261 |
800714 | 800714 | 2020-12-06 | Lake | Florida | 12069 | 11183 | 260 |
797469 | 797469 | 2020-12-05 | Lake | Florida | 12069 | 11091 | 258 |
794224 | 794224 | 2020-12-04 | Lake | Florida | 12069 | 10982 | 258 |
790979 | 790979 | 2020-12-03 | Lake | Florida | 12069 | 10899 | 258 |
787734 | 787734 | 2020-12-02 | Lake | Florida | 12069 | 10809 | 258 |
784490 | 784490 | 2020-12-01 | Lake | Florida | 12069 | 10743 | 255 |
781245 | 781245 | 2020-11-30 | Lake | Florida | 12069 | 10671 | 255 |
777999 | 777999 | 2020-11-29 | Lake | Florida | 12069 | 10623 | 254 |
774754 | 774754 | 2020-11-28 | Lake | Florida | 12069 | 10531 | 254 |
771509 | 771509 | 2020-11-27 | Lake | Florida | 12069 | 10472 | 253 |
768264 | 768264 | 2020-11-26 | Lake | Florida | 12069 | 10273 | 250 |
765018 | 765018 | 2020-11-25 | Lake | Florida | 12069 | 10273 | 250 |
761773 | 761773 | 2020-11-24 | Lake | Florida | 12069 | 10208 | 248 |
758528 | 758528 | 2020-11-23 | Lake | Florida | 12069 | 10151 | 245 |
755281 | 755281 | 2020-11-22 | Lake | Florida | 12069 | 10084 | 244 |
752035 | 752035 | 2020-11-21 | Lake | Florida | 12069 | 10012 | 244 |
748789 | 748789 | 2020-11-20 | Lake | Florida | 12069 | 9946 | 243 |
745543 | 745543 | 2020-11-19 | Lake | Florida | 12069 | 9872 | 243 |
742296 | 742296 | 2020-11-18 | Lake | Florida | 12069 | 9815 | 243 |
739049 | 739049 | 2020-11-17 | Lake | Florida | 12069 | 9721 | 243 |
735805 | 735805 | 2020-11-16 | Lake | Florida | 12069 | 9665 | 243 |
732559 | 732559 | 2020-11-15 | Lake | Florida | 12069 | 9623 | 243 |
729314 | 729314 | 2020-11-14 | Lake | Florida | 12069 | 9527 | 243 |
726071 | 726071 | 2020-11-13 | Lake | Florida | 12069 | 9466 | 242 |
722828 | 722828 | 2020-11-12 | Lake | Florida | 12069 | 9424 | 241 |
719585 | 719585 | 2020-11-11 | Lake | Florida | 12069 | 9360 | 238 |
716342 | 716342 | 2020-11-10 | Lake | Florida | 12069 | 9312 | 238 |
713098 | 713098 | 2020-11-09 | Lake | Florida | 12069 | 9246 | 236 |
709854 | 709854 | 2020-11-08 | Lake | Florida | 12069 | 9195 | 235 |
706610 | 706610 | 2020-11-07 | Lake | Florida | 12069 | 9132 | 235 |
703367 | 703367 | 2020-11-06 | Lake | Florida | 12069 | 9103 | 236 |
700124 | 700124 | 2020-11-05 | Lake | Florida | 12069 | 9047 | 234 |
696880 | 696880 | 2020-11-04 | Lake | Florida | 12069 | 8947 | 232 |
693638 | 693638 | 2020-11-03 | Lake | Florida | 12069 | 8851 | 228 |
690395 | 690395 | 2020-11-02 | Lake | Florida | 12069 | 8785 | 227 |
687150 | 687150 | 2020-11-01 | Lake | Florida | 12069 | 8729 | 227 |
683906 | 683906 | 2020-10-31 | Lake | Florida | 12069 | 8680 | 227 |
680663 | 680663 | 2020-10-30 | Lake | Florida | 12069 | 8662 | 228 |
677420 | 677420 | 2020-10-29 | Lake | Florida | 12069 | 8613 | 228 |
674177 | 674177 | 2020-10-28 | Lake | Florida | 12069 | 8580 | 227 |
670935 | 670935 | 2020-10-27 | Lake | Florida | 12069 | 8520 | 226 |
667692 | 667692 | 2020-10-26 | Lake | Florida | 12069 | 8479 | 225 |
664447 | 664447 | 2020-10-25 | Lake | Florida | 12069 | 8445 | 225 |
661203 | 661203 | 2020-10-24 | Lake | Florida | 12069 | 8415 | 225 |
657959 | 657959 | 2020-10-23 | Lake | Florida | 12069 | 8387 | 227 |
654714 | 654714 | 2020-10-22 | Lake | Florida | 12069 | 8336 | 227 |
651469 | 651469 | 2020-10-21 | Lake | Florida | 12069 | 8266 | 218 |
648225 | 648225 | 2020-10-20 | Lake | Florida | 12069 | 8240 | 218 |
644980 | 644980 | 2020-10-19 | Lake | Florida | 12069 | 8195 | 218 |
641732 | 641732 | 2020-10-18 | Lake | Florida | 12069 | 8168 | 218 |
638485 | 638485 | 2020-10-17 | Lake | Florida | 12069 | 8130 | 216 |
635240 | 635240 | 2020-10-16 | Lake | Florida | 12069 | 8083 | 214 |
631994 | 631994 | 2020-10-15 | Lake | Florida | 12069 | 8047 | 211 |
628750 | 628750 | 2020-10-14 | Lake | Florida | 12069 | 8012 | 211 |
625507 | 625507 | 2020-10-13 | Lake | Florida | 12069 | 7973 | 209 |
622264 | 622264 | 2020-10-12 | Lake | Florida | 12069 | 7939 | 206 |
619021 | 619021 | 2020-10-11 | Lake | Florida | 12069 | 7917 | 205 |
615779 | 615779 | 2020-10-10 | Lake | Florida | 12069 | 7862 | 202 |
612538 | 612538 | 2020-10-09 | Lake | Florida | 12069 | 7862 | 202 |
609296 | 609296 | 2020-10-08 | Lake | Florida | 12069 | 7818 | 202 |
606053 | 606053 | 2020-10-07 | Lake | Florida | 12069 | 7770 | 199 |
602811 | 602811 | 2020-10-06 | Lake | Florida | 12069 | 7729 | 196 |
599568 | 599568 | 2020-10-05 | Lake | Florida | 12069 | 7712 | 197 |
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);