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 |
---|---|---|---|---|---|---|---|
1193464 | 1193464 | 2021-04-06 | Lake | Florida | 12069 | 27081 | 611 |
1190214 | 1190214 | 2021-04-05 | Lake | Florida | 12069 | 27028 | 611 |
1186967 | 1186967 | 2021-04-04 | Lake | Florida | 12069 | 26983 | 610 |
1183720 | 1183720 | 2021-04-03 | Lake | Florida | 12069 | 26924 | 610 |
1180473 | 1180473 | 2021-04-02 | Lake | Florida | 12069 | 26862 | 609 |
1177226 | 1177226 | 2021-04-01 | Lake | Florida | 12069 | 26776 | 607 |
1173979 | 1173979 | 2021-03-31 | Lake | Florida | 12069 | 26679 | 606 |
1170732 | 1170732 | 2021-03-30 | Lake | Florida | 12069 | 26604 | 601 |
1167484 | 1167484 | 2021-03-29 | Lake | Florida | 12069 | 26507 | 600 |
1164236 | 1164236 | 2021-03-28 | Lake | Florida | 12069 | 26470 | 600 |
1160988 | 1160988 | 2021-03-27 | Lake | Florida | 12069 | 26418 | 600 |
1157740 | 1157740 | 2021-03-26 | Lake | Florida | 12069 | 26354 | 600 |
1154493 | 1154493 | 2021-03-25 | Lake | Florida | 12069 | 26298 | 592 |
1151246 | 1151246 | 2021-03-24 | Lake | Florida | 12069 | 26199 | 592 |
1147999 | 1147999 | 2021-03-23 | Lake | Florida | 12069 | 26092 | 592 |
1144752 | 1144752 | 2021-03-22 | Lake | Florida | 12069 | 26009 | 594 |
1141505 | 1141505 | 2021-03-21 | Lake | Florida | 12069 | 25978 | 594 |
1138259 | 1138259 | 2021-03-20 | Lake | Florida | 12069 | 25943 | 593 |
1135013 | 1135013 | 2021-03-19 | Lake | Florida | 12069 | 25895 | 593 |
1131766 | 1131766 | 2021-03-18 | Lake | Florida | 12069 | 25831 | 593 |
1128518 | 1128518 | 2021-03-17 | Lake | Florida | 12069 | 25754 | 591 |
1125272 | 1125272 | 2021-03-16 | Lake | Florida | 12069 | 25678 | 594 |
1122026 | 1122026 | 2021-03-15 | Lake | Florida | 12069 | 25627 | 593 |
1118779 | 1118779 | 2021-03-14 | Lake | Florida | 12069 | 25591 | 589 |
1115532 | 1115532 | 2021-03-13 | Lake | Florida | 12069 | 25529 | 587 |
1112286 | 1112286 | 2021-03-12 | Lake | Florida | 12069 | 25444 | 585 |
1109040 | 1109040 | 2021-03-11 | Lake | Florida | 12069 | 25378 | 584 |
1105794 | 1105794 | 2021-03-10 | Lake | Florida | 12069 | 25312 | 576 |
1102548 | 1102548 | 2021-03-09 | Lake | Florida | 12069 | 25252 | 577 |
1099302 | 1099302 | 2021-03-08 | Lake | Florida | 12069 | 25192 | 586 |
1096054 | 1096054 | 2021-03-07 | Lake | Florida | 12069 | 25156 | 583 |
1092808 | 1092808 | 2021-03-06 | Lake | Florida | 12069 | 25083 | 581 |
1089562 | 1089562 | 2021-03-05 | Lake | Florida | 12069 | 25010 | 577 |
1086317 | 1086317 | 2021-03-04 | Lake | Florida | 12069 | 24928 | 574 |
1083071 | 1083071 | 2021-03-03 | Lake | Florida | 12069 | 24841 | 567 |
1079825 | 1079825 | 2021-03-02 | Lake | Florida | 12069 | 24744 | 566 |
1076580 | 1076580 | 2021-03-01 | Lake | Florida | 12069 | 24635 | 560 |
1073334 | 1073334 | 2021-02-28 | Lake | Florida | 12069 | 24611 | 559 |
1070088 | 1070088 | 2021-02-27 | Lake | Florida | 12069 | 24538 | 555 |
1066843 | 1066843 | 2021-02-26 | Lake | Florida | 12069 | 24445 | 554 |
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 |
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);