ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
118 rows where deaths = 40 and state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1813706 | 1813706 | 2021-10-14 | Franklin | Florida | 12037 | 2212 | 40 |
1810457 | 1810457 | 2021-10-13 | Franklin | Florida | 12037 | 2212 | 40 |
1807208 | 1807208 | 2021-10-12 | Franklin | Florida | 12037 | 2212 | 40 |
1803957 | 1803957 | 2021-10-11 | Franklin | Florida | 12037 | 2212 | 40 |
1800708 | 1800708 | 2021-10-10 | Franklin | Florida | 12037 | 2212 | 40 |
1797459 | 1797459 | 2021-10-09 | Franklin | Florida | 12037 | 2212 | 40 |
1794210 | 1794210 | 2021-10-08 | Franklin | Florida | 12037 | 2212 | 40 |
1790962 | 1790962 | 2021-10-07 | Franklin | Florida | 12037 | 2202 | 40 |
1787713 | 1787713 | 2021-10-06 | Franklin | Florida | 12037 | 2202 | 40 |
1784464 | 1784464 | 2021-10-05 | Franklin | Florida | 12037 | 2202 | 40 |
1781215 | 1781215 | 2021-10-04 | Franklin | Florida | 12037 | 2202 | 40 |
1777965 | 1777965 | 2021-10-03 | Franklin | Florida | 12037 | 2202 | 40 |
1774715 | 1774715 | 2021-10-02 | Franklin | Florida | 12037 | 2202 | 40 |
1771465 | 1771465 | 2021-10-01 | Franklin | Florida | 12037 | 2202 | 40 |
1768216 | 1768216 | 2021-09-30 | Franklin | Florida | 12037 | 2186 | 40 |
1764967 | 1764967 | 2021-09-29 | Franklin | Florida | 12037 | 2186 | 40 |
1761718 | 1761718 | 2021-09-28 | Franklin | Florida | 12037 | 2186 | 40 |
1758470 | 1758470 | 2021-09-27 | Franklin | Florida | 12037 | 2186 | 40 |
1755222 | 1755222 | 2021-09-26 | Franklin | Florida | 12037 | 2186 | 40 |
1751974 | 1751974 | 2021-09-25 | Franklin | Florida | 12037 | 2186 | 40 |
1216187 | 1216187 | 2021-04-13 | Gilchrist | Florida | 12041 | 1542 | 40 |
1212940 | 1212940 | 2021-04-12 | Gilchrist | Florida | 12041 | 1538 | 40 |
1209692 | 1209692 | 2021-04-11 | Gilchrist | Florida | 12041 | 1538 | 40 |
1206443 | 1206443 | 2021-04-10 | Gilchrist | Florida | 12041 | 1533 | 40 |
1196702 | 1196702 | 2021-04-07 | Hardee | Florida | 12049 | 2939 | 40 |
1105782 | 1105782 | 2021-03-10 | Gulf | Florida | 12045 | 1887 | 40 |
1102536 | 1102536 | 2021-03-09 | Gulf | Florida | 12045 | 1880 | 40 |
1092811 | 1092811 | 2021-03-06 | Levy | Florida | 12075 | 2924 | 40 |
1089565 | 1089565 | 2021-03-05 | Levy | Florida | 12075 | 2914 | 40 |
1079798 | 1079798 | 2021-03-02 | Calhoun | Florida | 12013 | 1613 | 40 |
1076553 | 1076553 | 2021-03-01 | Calhoun | Florida | 12013 | 1608 | 40 |
1073307 | 1073307 | 2021-02-28 | Calhoun | Florida | 12013 | 1608 | 40 |
1070061 | 1070061 | 2021-02-27 | Calhoun | Florida | 12013 | 1608 | 40 |
1066816 | 1066816 | 2021-02-26 | Calhoun | Florida | 12013 | 1607 | 40 |
1063571 | 1063571 | 2021-02-25 | Calhoun | Florida | 12013 | 1607 | 40 |
1060326 | 1060326 | 2021-02-24 | Calhoun | Florida | 12013 | 1604 | 40 |
1060358 | 1060358 | 2021-02-24 | Madison | Florida | 12079 | 1978 | 40 |
1057112 | 1057112 | 2021-02-23 | Madison | Florida | 12079 | 1969 | 40 |
1053866 | 1053866 | 2021-02-22 | Madison | Florida | 12079 | 1968 | 40 |
1050619 | 1050619 | 2021-02-21 | Madison | Florida | 12079 | 1963 | 40 |
1040905 | 1040905 | 2021-02-18 | Taylor | Florida | 12123 | 2600 | 40 |
1040911 | 1040911 | 2021-02-18 | Washington | Florida | 12133 | 2589 | 40 |
1037666 | 1037666 | 2021-02-17 | Washington | Florida | 12133 | 2585 | 40 |
988957 | 988957 | 2021-02-02 | Monroe | Florida | 12087 | 5392 | 40 |
985670 | 985670 | 2021-02-01 | Bradford | Florida | 12007 | 2661 | 40 |
985710 | 985710 | 2021-02-01 | Monroe | Florida | 12087 | 5372 | 40 |
982463 | 982463 | 2021-01-31 | Monroe | Florida | 12087 | 5369 | 40 |
979217 | 979217 | 2021-01-30 | Monroe | Florida | 12087 | 5332 | 40 |
975972 | 975972 | 2021-01-29 | Monroe | Florida | 12087 | 5288 | 40 |
972727 | 972727 | 2021-01-28 | Monroe | Florida | 12087 | 5262 | 40 |
969482 | 969482 | 2021-01-27 | Monroe | Florida | 12087 | 5218 | 40 |
950012 | 950012 | 2021-01-21 | Monroe | Florida | 12087 | 5057 | 40 |
933742 | 933742 | 2021-01-16 | Baker | Florida | 12003 | 2814 | 40 |
829957 | 829957 | 2020-12-15 | Walton | Florida | 12131 | 4248 | 40 |
826711 | 826711 | 2020-12-14 | Walton | Florida | 12131 | 4198 | 40 |
823464 | 823464 | 2020-12-13 | Walton | Florida | 12131 | 4177 | 40 |
820218 | 820218 | 2020-12-12 | Walton | Florida | 12131 | 4142 | 40 |
816972 | 816972 | 2020-12-11 | Walton | Florida | 12131 | 4086 | 40 |
735788 | 735788 | 2020-11-16 | Flagler | Florida | 12035 | 2410 | 40 |
732542 | 732542 | 2020-11-15 | Flagler | Florida | 12035 | 2399 | 40 |
729297 | 729297 | 2020-11-14 | Flagler | Florida | 12035 | 2379 | 40 |
726054 | 726054 | 2020-11-13 | Flagler | Florida | 12035 | 2356 | 40 |
722811 | 722811 | 2020-11-12 | Flagler | Florida | 12035 | 2337 | 40 |
719568 | 719568 | 2020-11-11 | Flagler | Florida | 12035 | 2324 | 40 |
716325 | 716325 | 2020-11-10 | Flagler | Florida | 12035 | 2311 | 40 |
713081 | 713081 | 2020-11-09 | Flagler | Florida | 12035 | 2295 | 40 |
709837 | 709837 | 2020-11-08 | Flagler | Florida | 12035 | 2286 | 40 |
706593 | 706593 | 2020-11-07 | Flagler | Florida | 12035 | 2262 | 40 |
703350 | 703350 | 2020-11-06 | Flagler | Florida | 12035 | 2254 | 40 |
700107 | 700107 | 2020-11-05 | Flagler | Florida | 12035 | 2248 | 40 |
696863 | 696863 | 2020-11-04 | Flagler | Florida | 12035 | 2225 | 40 |
690378 | 690378 | 2020-11-02 | Flagler | Florida | 12035 | 2193 | 40 |
690408 | 690408 | 2020-11-02 | Okeechobee | Florida | 12093 | 1763 | 40 |
609287 | 609287 | 2020-10-08 | Hendry | Florida | 12051 | 2099 | 40 |
606044 | 606044 | 2020-10-07 | Hendry | Florida | 12051 | 2094 | 40 |
602802 | 602802 | 2020-10-06 | Hendry | Florida | 12051 | 2092 | 40 |
599559 | 599559 | 2020-10-05 | Hendry | Florida | 12051 | 2089 | 40 |
596316 | 596316 | 2020-10-04 | Hendry | Florida | 12051 | 2088 | 40 |
593074 | 593074 | 2020-10-03 | Hendry | Florida | 12051 | 2085 | 40 |
586622 | 586622 | 2020-10-01 | Putnam | Florida | 12107 | 2145 | 40 |
583382 | 583382 | 2020-09-30 | Putnam | Florida | 12107 | 2141 | 40 |
557450 | 557450 | 2020-09-22 | Nassau | Florida | 12089 | 2036 | 40 |
531509 | 531509 | 2020-09-14 | Alachua | Florida | 12001 | 6555 | 40 |
528272 | 528272 | 2020-09-13 | Alachua | Florida | 12001 | 6401 | 40 |
525036 | 525036 | 2020-09-12 | Alachua | Florida | 12001 | 6241 | 40 |
521800 | 521800 | 2020-09-11 | Alachua | Florida | 12001 | 6029 | 40 |
512130 | 512130 | 2020-09-08 | Leon | Florida | 12073 | 7942 | 40 |
508897 | 508897 | 2020-09-07 | Leon | Florida | 12073 | 7824 | 40 |
505665 | 505665 | 2020-09-06 | Leon | Florida | 12073 | 7704 | 40 |
441019 | 441019 | 2020-08-17 | Citrus | Florida | 12017 | 1799 | 40 |
437793 | 437793 | 2020-08-16 | Citrus | Florida | 12017 | 1778 | 40 |
434567 | 434567 | 2020-08-15 | Citrus | Florida | 12017 | 1750 | 40 |
431360 | 431360 | 2020-08-14 | Highlands | Florida | 12055 | 1548 | 40 |
428132 | 428132 | 2020-08-13 | Highlands | Florida | 12055 | 1523 | 40 |
421715 | 421715 | 2020-08-11 | Santa Rosa | Florida | 12113 | 4013 | 40 |
408840 | 408840 | 2020-08-07 | Suwannee | Florida | 12121 | 1356 | 40 |
405619 | 405619 | 2020-08-06 | Sumter | Florida | 12119 | 1208 | 40 |
402401 | 402401 | 2020-08-05 | Sumter | Florida | 12119 | 1180 | 40 |
341398 | 341398 | 2020-07-17 | Pasco | Florida | 12101 | 4654 | 40 |
338201 | 338201 | 2020-07-16 | Pasco | Florida | 12101 | 4489 | 40 |
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);