ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
53,362 rows where state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 12081 562
- 12057 561
- 12113 558
- 12071 557
- 12011 556
- 12091 556
- 12127 556
- 12015 555
- 12089 553
- 12101 553
- 12103 553
- 12001 552
- 12021 552
- 12086 552
- 12109 552
- 12099 551
- 12115 551
- 12117 551
- 12019 550
- 12031 550
- 12095 550
- 12097 550
- 12003 547
- 12017 547
- 12069 547
- 12033 546
- 12105 546
- 12009 545
- 12073 545
- 12119 545
- …
county >30
- Manatee 562
- Hillsborough 561
- Santa Rosa 558
- Lee 557
- Broward 556
- Okaloosa 556
- Volusia 556
- Charlotte 555
- Nassau 553
- Pasco 553
- Pinellas 553
- Alachua 552
- Collier 552
- Miami-Dade 552
- St. Johns 552
- Palm Beach 551
- Sarasota 551
- Seminole 551
- Clay 550
- Duval 550
- Orange 550
- Osceola 550
- Baker 547
- Citrus 547
- Lake 547
- Escambia 546
- Polk 546
- Brevard 545
- Leon 545
- Sumter 545
- …
state 1
- Florida · 36,874 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1713001 | 1713001 | 2021-09-13 | Lafayette | Florida | 12067 | 2113 | 26 |
1713002 | 1713002 | 2021-09-13 | Lake | Florida | 12069 | 49249 | 663 |
1713003 | 1713003 | 2021-09-13 | Lee | Florida | 12071 | 115839 | 1009 |
1713004 | 1713004 | 2021-09-13 | Leon | Florida | 12073 | 46857 | 332 |
1713005 | 1713005 | 2021-09-13 | Levy | Florida | 12075 | 6421 | 56 |
1713006 | 1713006 | 2021-09-13 | Liberty | Florida | 12077 | 1705 | 16 |
1713007 | 1713007 | 2021-09-13 | Madison | Florida | 12079 | 3308 | 45 |
1713008 | 1713008 | 2021-09-13 | Manatee | Florida | 12081 | 60130 | 689 |
1713009 | 1713009 | 2021-09-13 | Marion | Florida | 12083 | 52411 | 996 |
1713010 | 1713010 | 2021-09-13 | Martin | Florida | 12085 | 18574 | 335 |
1713011 | 1713011 | 2021-09-13 | Miami-Dade | Florida | 12086 | 642199 | 6472 |
1713012 | 1713012 | 2021-09-13 | Monroe | Florida | 12087 | 9714 | 52 |
1713013 | 1713013 | 2021-09-13 | Nassau | Florida | 12089 | 14286 | 127 |
1713014 | 1713014 | 2021-09-13 | Okaloosa | Florida | 12091 | 31903 | 367 |
1713015 | 1713015 | 2021-09-13 | Okeechobee | Florida | 12093 | 6787 | 89 |
1713016 | 1713016 | 2021-09-13 | Orange | Florida | 12095 | 213034 | 1310 |
1713017 | 1713017 | 2021-09-13 | Osceola | Florida | 12097 | 66882 | 529 |
1713018 | 1713018 | 2021-09-13 | Palm Beach | Florida | 12099 | 210204 | 2883 |
1713019 | 1713019 | 2021-09-13 | Pasco | Florida | 12101 | 72254 | 802 |
1713020 | 1713020 | 2021-09-13 | Pinellas | Florida | 12103 | 124373 | 1671 |
1713021 | 1713021 | 2021-09-13 | Polk | Florida | 12105 | 118826 | 1387 |
1713022 | 1713022 | 2021-09-13 | Putnam | Florida | 12107 | 11564 | 160 |
1713023 | 1713023 | 2021-09-13 | Santa Rosa | Florida | 12113 | 29798 | 291 |
1713024 | 1713024 | 2021-09-13 | Sarasota | Florida | 12115 | 51218 | 844 |
1713025 | 1713025 | 2021-09-13 | Seminole | Florida | 12117 | 57731 | 516 |
1713026 | 1713026 | 2021-09-13 | St. Johns | Florida | 12109 | 36945 | 221 |
1713027 | 1713027 | 2021-09-13 | St. Lucie | Florida | 12111 | 44152 | 657 |
1713028 | 1713028 | 2021-09-13 | Sumter | Florida | 12119 | 13322 | 284 |
1713029 | 1713029 | 2021-09-13 | Suwannee | Florida | 12121 | 8633 | 140 |
1713030 | 1713030 | 2021-09-13 | Taylor | Florida | 12123 | 4266 | 48 |
1713031 | 1713031 | 2021-09-13 | Union | Florida | 12125 | 2910 | 74 |
1713032 | 1713032 | 2021-09-13 | Unknown | Florida | 32927 | 11799 | |
1713033 | 1713033 | 2021-09-13 | Volusia | Florida | 12127 | 69378 | 846 |
1713034 | 1713034 | 2021-09-13 | Wakulla | Florida | 12129 | 5907 | 56 |
1713035 | 1713035 | 2021-09-13 | Walton | Florida | 12131 | 11092 | 89 |
1713036 | 1713036 | 2021-09-13 | Washington | Florida | 12133 | 4304 | 52 |
1709722 | 1709722 | 2021-09-12 | Alachua | Florida | 12001 | 36610 | 285 |
1709723 | 1709723 | 2021-09-12 | Baker | Florida | 12003 | 5747 | 62 |
1709724 | 1709724 | 2021-09-12 | Bay | Florida | 12005 | 30026 | 394 |
1709725 | 1709725 | 2021-09-12 | Bradford | Florida | 12007 | 5021 | 58 |
1709726 | 1709726 | 2021-09-12 | Brevard | Florida | 12009 | 75107 | 914 |
1709727 | 1709727 | 2021-09-12 | Broward | Florida | 12011 | 336741 | 3079 |
1709728 | 1709728 | 2021-09-12 | Calhoun | Florida | 12013 | 2806 | 45 |
1709729 | 1709729 | 2021-09-12 | Charlotte | Florida | 12015 | 20916 | 437 |
1709730 | 1709730 | 2021-09-12 | Citrus | Florida | 12017 | 18542 | 463 |
1709731 | 1709731 | 2021-09-12 | Clay | Florida | 12019 | 31369 | 352 |
1709732 | 1709732 | 2021-09-12 | Collier | Florida | 12021 | 52526 | 551 |
1709733 | 1709733 | 2021-09-12 | Columbia | Florida | 12023 | 14045 | 170 |
1709734 | 1709734 | 2021-09-12 | DeSoto | Florida | 12027 | 6356 | 97 |
1709735 | 1709735 | 2021-09-12 | Dixie | Florida | 12029 | 2673 | 24 |
1709736 | 1709736 | 2021-09-12 | Duval | Florida | 12031 | 156313 | 1483 |
1709737 | 1709737 | 2021-09-12 | Escambia | Florida | 12033 | 50153 | 706 |
1709738 | 1709738 | 2021-09-12 | Flagler | Florida | 12035 | 13303 | 114 |
1709739 | 1709739 | 2021-09-12 | Franklin | Florida | 12037 | 2105 | 20 |
1709740 | 1709740 | 2021-09-12 | Gadsden | Florida | 12039 | 8111 | 99 |
1709741 | 1709741 | 2021-09-12 | Gilchrist | Florida | 12041 | 2894 | 44 |
1709742 | 1709742 | 2021-09-12 | Glades | Florida | 12043 | 1323 | 19 |
1709743 | 1709743 | 2021-09-12 | Gulf | Florida | 12045 | 2844 | 45 |
1709744 | 1709744 | 2021-09-12 | Hamilton | Florida | 12047 | 2563 | 25 |
1709745 | 1709745 | 2021-09-12 | Hardee | Florida | 12049 | 5494 | 45 |
1709746 | 1709746 | 2021-09-12 | Hendry | Florida | 12051 | 7405 | 87 |
1709747 | 1709747 | 2021-09-12 | Hernando | Florida | 12053 | 26227 | 482 |
1709748 | 1709748 | 2021-09-12 | Highlands | Florida | 12055 | 14317 | 366 |
1709749 | 1709749 | 2021-09-12 | Hillsborough | Florida | 12057 | 223492 | 1832 |
1709750 | 1709750 | 2021-09-12 | Holmes | Florida | 12059 | 3524 | 49 |
1709751 | 1709751 | 2021-09-12 | Indian River | Florida | 12061 | 20654 | 306 |
1709752 | 1709752 | 2021-09-12 | Jackson | Florida | 12063 | 9388 | 158 |
1709753 | 1709753 | 2021-09-12 | Jefferson | Florida | 12065 | 2279 | 28 |
1709754 | 1709754 | 2021-09-12 | Lafayette | Florida | 12067 | 2113 | 26 |
1709755 | 1709755 | 2021-09-12 | Lake | Florida | 12069 | 49249 | 663 |
1709756 | 1709756 | 2021-09-12 | Lee | Florida | 12071 | 115839 | 1009 |
1709757 | 1709757 | 2021-09-12 | Leon | Florida | 12073 | 46857 | 332 |
1709758 | 1709758 | 2021-09-12 | Levy | Florida | 12075 | 6421 | 56 |
1709759 | 1709759 | 2021-09-12 | Liberty | Florida | 12077 | 1705 | 16 |
1709760 | 1709760 | 2021-09-12 | Madison | Florida | 12079 | 3308 | 45 |
1709761 | 1709761 | 2021-09-12 | Manatee | Florida | 12081 | 60130 | 689 |
1709762 | 1709762 | 2021-09-12 | Marion | Florida | 12083 | 52411 | 996 |
1709763 | 1709763 | 2021-09-12 | Martin | Florida | 12085 | 18574 | 335 |
1709764 | 1709764 | 2021-09-12 | Miami-Dade | Florida | 12086 | 642199 | 6472 |
1709765 | 1709765 | 2021-09-12 | Monroe | Florida | 12087 | 9714 | 52 |
1709766 | 1709766 | 2021-09-12 | Nassau | Florida | 12089 | 14286 | 127 |
1709767 | 1709767 | 2021-09-12 | Okaloosa | Florida | 12091 | 31903 | 367 |
1709768 | 1709768 | 2021-09-12 | Okeechobee | Florida | 12093 | 6787 | 89 |
1709769 | 1709769 | 2021-09-12 | Orange | Florida | 12095 | 213034 | 1310 |
1709770 | 1709770 | 2021-09-12 | Osceola | Florida | 12097 | 66882 | 529 |
1709771 | 1709771 | 2021-09-12 | Palm Beach | Florida | 12099 | 210204 | 2883 |
1709772 | 1709772 | 2021-09-12 | Pasco | Florida | 12101 | 72254 | 802 |
1709773 | 1709773 | 2021-09-12 | Pinellas | Florida | 12103 | 124373 | 1671 |
1709774 | 1709774 | 2021-09-12 | Polk | Florida | 12105 | 118826 | 1387 |
1709775 | 1709775 | 2021-09-12 | Putnam | Florida | 12107 | 11564 | 160 |
1709776 | 1709776 | 2021-09-12 | Santa Rosa | Florida | 12113 | 29798 | 291 |
1709777 | 1709777 | 2021-09-12 | Sarasota | Florida | 12115 | 51218 | 844 |
1709778 | 1709778 | 2021-09-12 | Seminole | Florida | 12117 | 57731 | 516 |
1709779 | 1709779 | 2021-09-12 | St. Johns | Florida | 12109 | 36945 | 221 |
1709780 | 1709780 | 2021-09-12 | St. Lucie | Florida | 12111 | 44152 | 657 |
1709781 | 1709781 | 2021-09-12 | Sumter | Florida | 12119 | 13322 | 284 |
1709782 | 1709782 | 2021-09-12 | Suwannee | Florida | 12121 | 8633 | 140 |
1709783 | 1709783 | 2021-09-12 | Taylor | Florida | 12123 | 4266 | 48 |
1709784 | 1709784 | 2021-09-12 | Union | Florida | 12125 | 2910 | 74 |
1709785 | 1709785 | 2021-09-12 | Unknown | Florida | 8997 | 11799 |
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);