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
- 12057 326
- 12081 326
- 12113 322
- 12011 321
- 12071 321
- 12015 320
- 12091 320
- 12127 320
- 12001 317
- 12021 317
- 12089 317
- 12101 317
- 12103 317
- 12086 316
- 12109 316
- 12019 315
- 12031 315
- 12099 315
- 12115 315
- 12117 315
- 12095 314
- 12097 314
- 12003 312
- 12017 312
- 12033 311
- 12069 311
- 12009 310
- 12105 310
- 12073 309
- 12119 309
- …
county >30
- Hillsborough 326
- Manatee 326
- Santa Rosa 322
- Broward 321
- Lee 321
- Charlotte 320
- Okaloosa 320
- Volusia 320
- Alachua 317
- Collier 317
- Nassau 317
- Pasco 317
- Pinellas 317
- Miami-Dade 316
- St. Johns 316
- Clay 315
- Duval 315
- Palm Beach 315
- Sarasota 315
- Seminole 315
- Orange 314
- Osceola 314
- Baker 312
- Citrus 312
- Escambia 311
- Lake 311
- Brevard 310
- Polk 310
- Leon 309
- Sumter 309
- …
state 1
- Florida · 20,858 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946723 | 946723 | 2021-01-20 | Alachua | Florida | 12001 | 19136 | 156 |
946724 | 946724 | 2021-01-20 | Baker | Florida | 12003 | 2869 | 41 |
946725 | 946725 | 2021-01-20 | Bay | Florida | 12005 | 14381 | 257 |
946726 | 946726 | 2021-01-20 | Bradford | Florida | 12007 | 2534 | 29 |
946727 | 946727 | 2021-01-20 | Brevard | Florida | 12009 | 26735 | 594 |
946728 | 946728 | 2021-01-20 | Broward | Florida | 12011 | 161624 | 1998 |
946729 | 946729 | 2021-01-20 | Calhoun | Florida | 12013 | 1455 | 33 |
946730 | 946730 | 2021-01-20 | Charlotte | Florida | 12015 | 9138 | 271 |
946731 | 946731 | 2021-01-20 | Citrus | Florida | 12017 | 8036 | 319 |
946732 | 946732 | 2021-01-20 | Clay | Florida | 12019 | 14286 | 221 |
946733 | 946733 | 2021-01-20 | Collier | Florida | 12021 | 26164 | 382 |
946734 | 946734 | 2021-01-20 | Columbia | Florida | 12023 | 6921 | 134 |
946735 | 946735 | 2021-01-20 | DeSoto | Florida | 12027 | 3241 | 67 |
946736 | 946736 | 2021-01-20 | Dixie | Florida | 12029 | 1328 | 12 |
946737 | 946737 | 2021-01-20 | Duval | Florida | 12031 | 76171 | 857 |
946738 | 946738 | 2021-01-20 | Escambia | Florida | 12033 | 28035 | 469 |
946739 | 946739 | 2021-01-20 | Flagler | Florida | 12035 | 4804 | 60 |
946740 | 946740 | 2021-01-20 | Franklin | Florida | 12037 | 1132 | 5 |
946741 | 946741 | 2021-01-20 | Gadsden | Florida | 12039 | 4829 | 65 |
946742 | 946742 | 2021-01-20 | Gilchrist | Florida | 12041 | 1142 | 28 |
946743 | 946743 | 2021-01-20 | Glades | Florida | 12043 | 846 | 12 |
946744 | 946744 | 2021-01-20 | Gulf | Florida | 12045 | 1570 | 31 |
946745 | 946745 | 2021-01-20 | Hamilton | Florida | 12047 | 1441 | 15 |
946746 | 946746 | 2021-01-20 | Hardee | Florida | 12049 | 2442 | 22 |
946747 | 946747 | 2021-01-20 | Hendry | Florida | 12051 | 3859 | 54 |
946748 | 946748 | 2021-01-20 | Hernando | Florida | 12053 | 9127 | 326 |
946749 | 946749 | 2021-01-20 | Highlands | Florida | 12055 | 5970 | 236 |
946750 | 946750 | 2021-01-20 | Hillsborough | Florida | 12057 | 94012 | 1198 |
946751 | 946751 | 2021-01-20 | Holmes | Florida | 12059 | 1987 | 33 |
946752 | 946752 | 2021-01-20 | Indian River | Florida | 12061 | 8988 | 196 |
946753 | 946753 | 2021-01-20 | Jackson | Florida | 12063 | 5383 | 128 |
946754 | 946754 | 2021-01-20 | Jefferson | Florida | 12065 | 1210 | 18 |
946755 | 946755 | 2021-01-20 | Lafayette | Florida | 12067 | 1502 | 23 |
946756 | 946756 | 2021-01-20 | Lake | Florida | 12069 | 19897 | 378 |
946757 | 946757 | 2021-01-20 | Lee | Florida | 12071 | 49115 | 742 |
946758 | 946758 | 2021-01-20 | Leon | Florida | 12073 | 24177 | 204 |
946759 | 946759 | 2021-01-20 | Levy | Florida | 12075 | 2359 | 22 |
946760 | 946760 | 2021-01-20 | Liberty | Florida | 12077 | 945 | 14 |
946761 | 946761 | 2021-01-20 | Madison | Florida | 12079 | 1729 | 36 |
946762 | 946762 | 2021-01-20 | Manatee | Florida | 12081 | 26602 | 464 |
946763 | 946763 | 2021-01-20 | Marion | Florida | 12083 | 22644 | 556 |
946764 | 946764 | 2021-01-20 | Martin | Florida | 12085 | 9129 | 228 |
946765 | 946765 | 2021-01-20 | Miami-Dade | Florida | 12086 | 350251 | 4630 |
946766 | 946766 | 2021-01-20 | Monroe | Florida | 12087 | 5024 | 37 |
946767 | 946767 | 2021-01-20 | Nassau | Florida | 12089 | 6399 | 75 |
946768 | 946768 | 2021-01-20 | Okaloosa | Florida | 12091 | 15450 | 264 |
946769 | 946769 | 2021-01-20 | Okeechobee | Florida | 12093 | 3039 | 56 |
946770 | 946770 | 2021-01-20 | Orange | Florida | 12095 | 95405 | 849 |
946771 | 946771 | 2021-01-20 | Osceola | Florida | 12097 | 31205 | 331 |
946772 | 946772 | 2021-01-20 | Palm Beach | Florida | 12099 | 99377 | 2061 |
946773 | 946773 | 2021-01-20 | Pasco | Florida | 12101 | 27367 | 470 |
946774 | 946774 | 2021-01-20 | Pinellas | Florida | 12103 | 55241 | 1206 |
946775 | 946775 | 2021-01-20 | Polk | Florida | 12105 | 46486 | 909 |
946776 | 946776 | 2021-01-20 | Putnam | Florida | 12107 | 5087 | 92 |
946777 | 946777 | 2021-01-20 | Santa Rosa | Florida | 12113 | 14093 | 189 |
946778 | 946778 | 2021-01-20 | Sarasota | Florida | 12115 | 23037 | 563 |
946779 | 946779 | 2021-01-20 | Seminole | Florida | 12117 | 22373 | 341 |
946780 | 946780 | 2021-01-20 | St. Johns | Florida | 12109 | 16887 | 143 |
946781 | 946781 | 2021-01-20 | St. Lucie | Florida | 12111 | 18048 | 461 |
946782 | 946782 | 2021-01-20 | Sumter | Florida | 12119 | 6553 | 163 |
946783 | 946783 | 2021-01-20 | Suwannee | Florida | 12121 | 4643 | 101 |
946784 | 946784 | 2021-01-20 | Taylor | Florida | 12123 | 2309 | 30 |
946785 | 946785 | 2021-01-20 | Union | Florida | 12125 | 1616 | 70 |
946786 | 946786 | 2021-01-20 | Unknown | Florida | 3279 | 0 | |
946787 | 946787 | 2021-01-20 | Volusia | Florida | 12127 | 28015 | 478 |
946788 | 946788 | 2021-01-20 | Wakulla | Florida | 12129 | 2714 | 34 |
946789 | 946789 | 2021-01-20 | Walton | Florida | 12131 | 5915 | 60 |
946790 | 946790 | 2021-01-20 | Washington | Florida | 12133 | 2295 | 30 |
943476 | 943476 | 2021-01-19 | Alachua | Florida | 12001 | 18986 | 156 |
943477 | 943477 | 2021-01-19 | Baker | Florida | 12003 | 2853 | 41 |
943478 | 943478 | 2021-01-19 | Bay | Florida | 12005 | 14254 | 255 |
943479 | 943479 | 2021-01-19 | Bradford | Florida | 12007 | 2515 | 29 |
943480 | 943480 | 2021-01-19 | Brevard | Florida | 12009 | 26488 | 591 |
943481 | 943481 | 2021-01-19 | Broward | Florida | 12011 | 160514 | 1990 |
943482 | 943482 | 2021-01-19 | Calhoun | Florida | 12013 | 1445 | 33 |
943483 | 943483 | 2021-01-19 | Charlotte | Florida | 12015 | 9059 | 271 |
943484 | 943484 | 2021-01-19 | Citrus | Florida | 12017 | 7981 | 316 |
943485 | 943485 | 2021-01-19 | Clay | Florida | 12019 | 14190 | 221 |
943486 | 943486 | 2021-01-19 | Collier | Florida | 12021 | 25979 | 381 |
943487 | 943487 | 2021-01-19 | Columbia | Florida | 12023 | 6886 | 132 |
943488 | 943488 | 2021-01-19 | DeSoto | Florida | 12027 | 3232 | 67 |
943489 | 943489 | 2021-01-19 | Dixie | Florida | 12029 | 1322 | 12 |
943490 | 943490 | 2021-01-19 | Duval | Florida | 12031 | 75731 | 856 |
943491 | 943491 | 2021-01-19 | Escambia | Florida | 12033 | 27733 | 448 |
943492 | 943492 | 2021-01-19 | Flagler | Florida | 12035 | 4764 | 53 |
943493 | 943493 | 2021-01-19 | Franklin | Florida | 12037 | 1127 | 4 |
943494 | 943494 | 2021-01-19 | Gadsden | Florida | 12039 | 4798 | 65 |
943495 | 943495 | 2021-01-19 | Gilchrist | Florida | 12041 | 1133 | 28 |
943496 | 943496 | 2021-01-19 | Glades | Florida | 12043 | 845 | 12 |
943497 | 943497 | 2021-01-19 | Gulf | Florida | 12045 | 1561 | 31 |
943498 | 943498 | 2021-01-19 | Hamilton | Florida | 12047 | 1428 | 15 |
943499 | 943499 | 2021-01-19 | Hardee | Florida | 12049 | 2417 | 22 |
943500 | 943500 | 2021-01-19 | Hendry | Florida | 12051 | 3845 | 53 |
943501 | 943501 | 2021-01-19 | Hernando | Florida | 12053 | 9073 | 322 |
943502 | 943502 | 2021-01-19 | Highlands | Florida | 12055 | 5933 | 232 |
943503 | 943503 | 2021-01-19 | Hillsborough | Florida | 12057 | 93487 | 1197 |
943504 | 943504 | 2021-01-19 | Holmes | Florida | 12059 | 1975 | 32 |
943505 | 943505 | 2021-01-19 | Indian River | Florida | 12061 | 8899 | 196 |
943506 | 943506 | 2021-01-19 | Jackson | Florida | 12063 | 5360 | 126 |
943507 | 943507 | 2021-01-19 | Jefferson | Florida | 12065 | 1199 | 18 |
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);