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 360
- 12081 360
- 12113 356
- 12011 355
- 12071 355
- 12127 355
- 12015 354
- 12091 354
- 12001 351
- 12021 351
- 12089 351
- 12101 351
- 12103 351
- 12086 350
- 12109 350
- 12019 349
- 12031 349
- 12099 349
- 12115 349
- 12117 349
- 12095 348
- 12097 348
- 12003 346
- 12017 346
- 12033 345
- 12069 345
- 12009 344
- 12105 344
- 12131 344
- 12073 343
- …
county >30
- Hillsborough 360
- Manatee 360
- Santa Rosa 356
- Broward 355
- Lee 355
- Volusia 355
- Charlotte 354
- Okaloosa 354
- Alachua 351
- Collier 351
- Nassau 351
- Pasco 351
- Pinellas 351
- Miami-Dade 350
- St. Johns 350
- Clay 349
- Duval 349
- Palm Beach 349
- Sarasota 349
- Seminole 349
- Orange 348
- Osceola 348
- Baker 346
- Citrus 346
- Escambia 345
- Lake 345
- Brevard 344
- Polk 344
- Walton 344
- Leon 343
- …
state 1
- Florida · 23,174 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1060384 | 1060384 | 2021-02-24 | Volusia | Florida | 12127 | 34090 | 645 |
1060385 | 1060385 | 2021-02-24 | Wakulla | Florida | 12129 | 3148 | 51 |
1060386 | 1060386 | 2021-02-24 | Walton | Florida | 12131 | 6974 | 80 |
1060387 | 1060387 | 2021-02-24 | Washington | Florida | 12133 | 2611 | 41 |
1057074 | 1057074 | 2021-02-23 | Alachua | Florida | 12001 | 22197 | 222 |
1057075 | 1057075 | 2021-02-23 | Baker | Florida | 12003 | 3280 | 56 |
1057076 | 1057076 | 2021-02-23 | Bay | Florida | 12005 | 18354 | 339 |
1057077 | 1057077 | 2021-02-23 | Bradford | Florida | 12007 | 2822 | 52 |
1057078 | 1057078 | 2021-02-23 | Brevard | Florida | 12009 | 33238 | 731 |
1057079 | 1057079 | 2021-02-23 | Broward | Florida | 12011 | 191065 | 2352 |
1057080 | 1057080 | 2021-02-23 | Calhoun | Florida | 12013 | 1603 | 39 |
1057081 | 1057081 | 2021-02-23 | Charlotte | Florida | 12015 | 10567 | 355 |
1057082 | 1057082 | 2021-02-23 | Citrus | Florida | 12017 | 9606 | 386 |
1057083 | 1057083 | 2021-02-23 | Clay | Florida | 12019 | 16571 | 299 |
1057084 | 1057084 | 2021-02-23 | Collier | Florida | 12021 | 29865 | 448 |
1057085 | 1057085 | 2021-02-23 | Columbia | Florida | 12023 | 7612 | 155 |
1057086 | 1057086 | 2021-02-23 | DeSoto | Florida | 12027 | 3706 | 72 |
1057087 | 1057087 | 2021-02-23 | Dixie | Florida | 12029 | 1463 | 19 |
1057088 | 1057088 | 2021-02-23 | Duval | Florida | 12031 | 87885 | 1120 |
1057089 | 1057089 | 2021-02-23 | Escambia | Florida | 12033 | 33304 | 620 |
1057090 | 1057090 | 2021-02-23 | Flagler | Florida | 12035 | 5813 | 87 |
1057091 | 1057091 | 2021-02-23 | Franklin | Florida | 12037 | 1273 | 13 |
1057092 | 1057092 | 2021-02-23 | Gadsden | Florida | 12039 | 5391 | 83 |
1057093 | 1057093 | 2021-02-23 | Gilchrist | Florida | 12041 | 1389 | 31 |
1057094 | 1057094 | 2021-02-23 | Glades | Florida | 12043 | 896 | 15 |
1057095 | 1057095 | 2021-02-23 | Gulf | Florida | 12045 | 1848 | 37 |
1057096 | 1057096 | 2021-02-23 | Hamilton | Florida | 12047 | 1554 | 21 |
1057097 | 1057097 | 2021-02-23 | Hardee | Florida | 12049 | 2766 | 29 |
1057098 | 1057098 | 2021-02-23 | Hendry | Florida | 12051 | 4256 | 70 |
1057099 | 1057099 | 2021-02-23 | Hernando | Florida | 12053 | 11082 | 394 |
1057100 | 1057100 | 2021-02-23 | Highlands | Florida | 12055 | 7131 | 296 |
1057101 | 1057101 | 2021-02-23 | Hillsborough | Florida | 12057 | 109527 | 1465 |
1057102 | 1057102 | 2021-02-23 | Holmes | Florida | 12059 | 2162 | 43 |
1057103 | 1057103 | 2021-02-23 | Indian River | Florida | 12061 | 10857 | 259 |
1057104 | 1057104 | 2021-02-23 | Jackson | Florida | 12063 | 5874 | 147 |
1057105 | 1057105 | 2021-02-23 | Jefferson | Florida | 12065 | 1394 | 24 |
1057106 | 1057106 | 2021-02-23 | Lafayette | Florida | 12067 | 1582 | 24 |
1057107 | 1057107 | 2021-02-23 | Lake | Florida | 12069 | 24110 | 541 |
1057108 | 1057108 | 2021-02-23 | Lee | Florida | 12071 | 56936 | 870 |
1057109 | 1057109 | 2021-02-23 | Leon | Florida | 12073 | 28795 | 273 |
1057110 | 1057110 | 2021-02-23 | Levy | Florida | 12075 | 2832 | 34 |
1057111 | 1057111 | 2021-02-23 | Liberty | Florida | 12077 | 1036 | 15 |
1057112 | 1057112 | 2021-02-23 | Madison | Florida | 12079 | 1969 | 40 |
1057113 | 1057113 | 2021-02-23 | Manatee | Florida | 12081 | 31314 | 575 |
1057114 | 1057114 | 2021-02-23 | Marion | Florida | 12083 | 27180 | 771 |
1057115 | 1057115 | 2021-02-23 | Martin | Florida | 12085 | 10385 | 273 |
1057116 | 1057116 | 2021-02-23 | Miami-Dade | Florida | 12086 | 404498 | 5338 |
1057117 | 1057117 | 2021-02-23 | Monroe | Florida | 12087 | 5721 | 46 |
1057118 | 1057118 | 2021-02-23 | Nassau | Florida | 12089 | 7632 | 109 |
1057119 | 1057119 | 2021-02-23 | Okaloosa | Florida | 12091 | 18466 | 321 |
1057120 | 1057120 | 2021-02-23 | Okeechobee | Florida | 12093 | 3515 | 75 |
1057121 | 1057121 | 2021-02-23 | Orange | Florida | 12095 | 112507 | 1073 |
1057122 | 1057122 | 2021-02-23 | Osceola | Florida | 12097 | 36271 | 431 |
1057123 | 1057123 | 2021-02-23 | Palm Beach | Florida | 12099 | 118149 | 2414 |
1057124 | 1057124 | 2021-02-23 | Pasco | Florida | 12101 | 32754 | 636 |
1057125 | 1057125 | 2021-02-23 | Pinellas | Florida | 12103 | 65375 | 1430 |
1057126 | 1057126 | 2021-02-23 | Polk | Florida | 12105 | 56153 | 1116 |
1057127 | 1057127 | 2021-02-23 | Putnam | Florida | 12107 | 5791 | 123 |
1057128 | 1057128 | 2021-02-23 | Santa Rosa | Florida | 12113 | 16860 | 252 |
1057129 | 1057129 | 2021-02-23 | Sarasota | Florida | 12115 | 26622 | 725 |
1057130 | 1057130 | 2021-02-23 | Seminole | Florida | 12117 | 26781 | 418 |
1057131 | 1057131 | 2021-02-23 | St. Johns | Florida | 12109 | 19905 | 188 |
1057132 | 1057132 | 2021-02-23 | St. Lucie | Florida | 12111 | 21717 | 532 |
1057133 | 1057133 | 2021-02-23 | Sumter | Florida | 12119 | 7810 | 234 |
1057134 | 1057134 | 2021-02-23 | Suwannee | Florida | 12121 | 5085 | 131 |
1057135 | 1057135 | 2021-02-23 | Taylor | Florida | 12123 | 2612 | 41 |
1057136 | 1057136 | 2021-02-23 | Union | Florida | 12125 | 1730 | 70 |
1057137 | 1057137 | 2021-02-23 | Unknown | Florida | 3426 | 0 | |
1057138 | 1057138 | 2021-02-23 | Volusia | Florida | 12127 | 33964 | 642 |
1057139 | 1057139 | 2021-02-23 | Wakulla | Florida | 12129 | 3144 | 51 |
1057140 | 1057140 | 2021-02-23 | Walton | Florida | 12131 | 6946 | 80 |
1057141 | 1057141 | 2021-02-23 | Washington | Florida | 12133 | 2601 | 41 |
1053828 | 1053828 | 2021-02-22 | Alachua | Florida | 12001 | 22154 | 220 |
1053829 | 1053829 | 2021-02-22 | Baker | Florida | 12003 | 3276 | 54 |
1053830 | 1053830 | 2021-02-22 | Bay | Florida | 12005 | 18293 | 335 |
1053831 | 1053831 | 2021-02-22 | Bradford | Florida | 12007 | 2814 | 50 |
1053832 | 1053832 | 2021-02-22 | Brevard | Florida | 12009 | 33106 | 728 |
1053833 | 1053833 | 2021-02-22 | Broward | Florida | 12011 | 190364 | 2349 |
1053834 | 1053834 | 2021-02-22 | Calhoun | Florida | 12013 | 1602 | 39 |
1053835 | 1053835 | 2021-02-22 | Charlotte | Florida | 12015 | 10537 | 355 |
1053836 | 1053836 | 2021-02-22 | Citrus | Florida | 12017 | 9585 | 386 |
1053837 | 1053837 | 2021-02-22 | Clay | Florida | 12019 | 16546 | 299 |
1053838 | 1053838 | 2021-02-22 | Collier | Florida | 12021 | 29751 | 443 |
1053839 | 1053839 | 2021-02-22 | Columbia | Florida | 12023 | 7595 | 155 |
1053840 | 1053840 | 2021-02-22 | DeSoto | Florida | 12027 | 3685 | 72 |
1053841 | 1053841 | 2021-02-22 | Dixie | Florida | 12029 | 1462 | 19 |
1053842 | 1053842 | 2021-02-22 | Duval | Florida | 12031 | 87745 | 1109 |
1053843 | 1053843 | 2021-02-22 | Escambia | Florida | 12033 | 33242 | 608 |
1053844 | 1053844 | 2021-02-22 | Flagler | Florida | 12035 | 5795 | 87 |
1053845 | 1053845 | 2021-02-22 | Franklin | Florida | 12037 | 1274 | 13 |
1053846 | 1053846 | 2021-02-22 | Gadsden | Florida | 12039 | 5381 | 83 |
1053847 | 1053847 | 2021-02-22 | Gilchrist | Florida | 12041 | 1389 | 31 |
1053848 | 1053848 | 2021-02-22 | Glades | Florida | 12043 | 895 | 15 |
1053849 | 1053849 | 2021-02-22 | Gulf | Florida | 12045 | 1841 | 37 |
1053850 | 1053850 | 2021-02-22 | Hamilton | Florida | 12047 | 1554 | 21 |
1053851 | 1053851 | 2021-02-22 | Hardee | Florida | 12049 | 2758 | 29 |
1053852 | 1053852 | 2021-02-22 | Hendry | Florida | 12051 | 4255 | 68 |
1053853 | 1053853 | 2021-02-22 | Hernando | Florida | 12053 | 11034 | 394 |
1053854 | 1053854 | 2021-02-22 | Highlands | Florida | 12055 | 7111 | 298 |
1053855 | 1053855 | 2021-02-22 | Hillsborough | Florida | 12057 | 109174 | 1455 |
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);