ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 12069 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063598 | 1063598 | 2021-02-25 | Lake | Florida | 12069 | 24342 | 544 |
1060353 | 1060353 | 2021-02-24 | Lake | Florida | 12069 | 24228 | 541 |
1057107 | 1057107 | 2021-02-23 | Lake | Florida | 12069 | 24110 | 541 |
1053861 | 1053861 | 2021-02-22 | Lake | Florida | 12069 | 24030 | 544 |
1050614 | 1050614 | 2021-02-21 | Lake | Florida | 12069 | 23978 | 541 |
1047367 | 1047367 | 2021-02-20 | Lake | Florida | 12069 | 23903 | 541 |
1044122 | 1044122 | 2021-02-19 | Lake | Florida | 12069 | 23786 | 534 |
1040877 | 1040877 | 2021-02-18 | Lake | Florida | 12069 | 23728 | 531 |
1037632 | 1037632 | 2021-02-17 | Lake | Florida | 12069 | 23655 | 525 |
1034387 | 1034387 | 2021-02-16 | Lake | Florida | 12069 | 23587 | 526 |
1031141 | 1031141 | 2021-02-15 | Lake | Florida | 12069 | 23498 | 527 |
1027894 | 1027894 | 2021-02-14 | Lake | Florida | 12069 | 23442 | 516 |
1024649 | 1024649 | 2021-02-13 | Lake | Florida | 12069 | 23346 | 516 |
1021404 | 1021404 | 2021-02-12 | Lake | Florida | 12069 | 23215 | 503 |
1018159 | 1018159 | 2021-02-11 | Lake | Florida | 12069 | 23099 | 494 |
1014914 | 1014914 | 2021-02-10 | Lake | Florida | 12069 | 22989 | 492 |
1011669 | 1011669 | 2021-02-09 | Lake | Florida | 12069 | 22933 | 489 |
1008423 | 1008423 | 2021-02-08 | Lake | Florida | 12069 | 22800 | 468 |
1005177 | 1005177 | 2021-02-07 | Lake | Florida | 12069 | 22728 | 468 |
1001931 | 1001931 | 2021-02-06 | Lake | Florida | 12069 | 22618 | 468 |
998685 | 998685 | 2021-02-05 | Lake | Florida | 12069 | 22500 | 459 |
995439 | 995439 | 2021-02-04 | Lake | Florida | 12069 | 22311 | 453 |
992193 | 992193 | 2021-02-03 | Lake | Florida | 12069 | 22180 | 443 |
988947 | 988947 | 2021-02-02 | Lake | Florida | 12069 | 22058 | 437 |
985700 | 985700 | 2021-02-01 | Lake | Florida | 12069 | 21864 | 435 |
982453 | 982453 | 2021-01-31 | Lake | Florida | 12069 | 21824 | 425 |
979207 | 979207 | 2021-01-30 | Lake | Florida | 12069 | 21697 | 426 |
975962 | 975962 | 2021-01-29 | Lake | Florida | 12069 | 21511 | 424 |
972717 | 972717 | 2021-01-28 | Lake | Florida | 12069 | 21343 | 388 |
969472 | 969472 | 2021-01-27 | Lake | Florida | 12069 | 21131 | 388 |
966228 | 966228 | 2021-01-26 | Lake | Florida | 12069 | 20972 | 388 |
962983 | 962983 | 2021-01-25 | Lake | Florida | 12069 | 20797 | 387 |
959738 | 959738 | 2021-01-24 | Lake | Florida | 12069 | 20664 | 386 |
956492 | 956492 | 2021-01-23 | Lake | Florida | 12069 | 20470 | 386 |
953247 | 953247 | 2021-01-22 | Lake | Florida | 12069 | 20296 | 392 |
950002 | 950002 | 2021-01-21 | Lake | Florida | 12069 | 20128 | 393 |
946756 | 946756 | 2021-01-20 | Lake | Florida | 12069 | 19897 | 378 |
943509 | 943509 | 2021-01-19 | Lake | Florida | 12069 | 19713 | 378 |
940264 | 940264 | 2021-01-18 | Lake | Florida | 12069 | 19547 | 377 |
937019 | 937019 | 2021-01-17 | Lake | Florida | 12069 | 19387 | 377 |
933774 | 933774 | 2021-01-16 | Lake | Florida | 12069 | 19208 | 377 |
930529 | 930529 | 2021-01-15 | Lake | Florida | 12069 | 18962 | 349 |
927284 | 927284 | 2021-01-14 | Lake | Florida | 12069 | 18753 | 339 |
924038 | 924038 | 2021-01-13 | Lake | Florida | 12069 | 18537 | 338 |
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 |
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);