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 68
- 12057 471
- 12081 471
- 12113 467
- 12011 466
- 12071 466
- 12015 465
- 12091 465
- 12127 465
- 12001 462
- 12021 462
- 12089 462
- 12101 462
- 12103 462
- 12086 461
- 12109 461
- 12019 460
- 12031 460
- 12099 460
- 12115 460
- 12117 460
- 12095 459
- 12097 459
- 12003 457
- 12017 457
- 12033 456
- 12069 456
- 12009 455
- 12105 455
- 12073 454
- 12119 454
- 12131 454
- 12053 453
- 12061 453
- 12063 453
- 12085 453
- 12087 452
- 12005 451
- 12055 451
- 12083 451
- 12107 451
- 12111 451
- 12007 450
- 12023 450
- 12027 450
- 12035 450
- 12039 447
- 12133 446
- 12075 445
- 12121 445
- 12051 444
- 12043 443
- 12129 443
- 12059 442
- 12013 441
- 12125 441
- 12045 440
- 12049 440
- 12079 440
- 12093 440
- - 439
- 12037 438
- 12029 437
- 12065 437
- 12047 435
- 12041 434
- 12123 434
- 12067 433
- 12077 431
county 68
- Hillsborough 471
- Manatee 471
- Santa Rosa 467
- Broward 466
- Lee 466
- Charlotte 465
- Okaloosa 465
- Volusia 465
- Alachua 462
- Collier 462
- Nassau 462
- Pasco 462
- Pinellas 462
- Miami-Dade 461
- St. Johns 461
- Clay 460
- Duval 460
- Palm Beach 460
- Sarasota 460
- Seminole 460
- Orange 459
- Osceola 459
- Baker 457
- Citrus 457
- Escambia 456
- Lake 456
- Brevard 455
- Polk 455
- Leon 454
- Sumter 454
- Walton 454
- Hernando 453
- Indian River 453
- Jackson 453
- Martin 453
- Monroe 452
- Bay 451
- Highlands 451
- Marion 451
- Putnam 451
- St. Lucie 451
- Bradford 450
- Columbia 450
- DeSoto 450
- Flagler 450
- Gadsden 447
- Washington 446
- Levy 445
- Suwannee 445
- Hendry 444
- Glades 443
- Wakulla 443
- Holmes 442
- Calhoun 441
- Union 441
- Gulf 440
- Hardee 440
- Madison 440
- Okeechobee 440
- Unknown 439
- Franklin 438
- Dixie 437
- Jefferson 437
- Hamilton 435
- Gilchrist 434
- Taylor 434
- Lafayette 433
- Liberty 431
state 1
- Florida · 30,718 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417452 | 1417452 | 2021-06-14 | Alachua | Florida | 12001 | 25293 | 285 |
1417453 | 1417453 | 2021-06-14 | Baker | Florida | 12003 | 3557 | 62 |
1417454 | 1417454 | 2021-06-14 | Bay | Florida | 12005 | 19844 | 394 |
1417455 | 1417455 | 2021-06-14 | Bradford | Florida | 12007 | 3045 | 58 |
1417456 | 1417456 | 2021-06-14 | Brevard | Florida | 12009 | 42604 | 914 |
1417457 | 1417457 | 2021-06-14 | Broward | Florida | 12011 | 243765 | 3079 |
1417458 | 1417458 | 2021-06-14 | Calhoun | Florida | 12013 | 1710 | 45 |
1417459 | 1417459 | 2021-06-14 | Charlotte | Florida | 12015 | 13303 | 437 |
1417460 | 1417460 | 2021-06-14 | Citrus | Florida | 12017 | 11401 | 463 |
1417461 | 1417461 | 2021-06-14 | Clay | Florida | 12019 | 19391 | 352 |
1417462 | 1417462 | 2021-06-14 | Collier | Florida | 12021 | 35994 | 551 |
1417463 | 1417463 | 2021-06-14 | Columbia | Florida | 12023 | 8270 | 170 |
1417464 | 1417464 | 2021-06-14 | DeSoto | Florida | 12027 | 4433 | 97 |
1417465 | 1417465 | 2021-06-14 | Dixie | Florida | 12029 | 1628 | 24 |
1417466 | 1417466 | 2021-06-14 | Duval | Florida | 12031 | 100193 | 1483 |
1417467 | 1417467 | 2021-06-14 | Escambia | Florida | 12033 | 33028 | 706 |
1417468 | 1417468 | 2021-06-14 | Flagler | Florida | 12035 | 7459 | 114 |
1417469 | 1417469 | 2021-06-14 | Franklin | Florida | 12037 | 1320 | 20 |
1417470 | 1417470 | 2021-06-14 | Gadsden | Florida | 12039 | 5793 | 99 |
1417471 | 1417471 | 2021-06-14 | Gilchrist | Florida | 12041 | 1645 | 44 |
1417472 | 1417472 | 2021-06-14 | Glades | Florida | 12043 | 984 | 19 |
1417473 | 1417473 | 2021-06-14 | Gulf | Florida | 12045 | 1960 | 45 |
1417474 | 1417474 | 2021-06-14 | Hamilton | Florida | 12047 | 1629 | 25 |
1417475 | 1417475 | 2021-06-14 | Hardee | Florida | 12049 | 3296 | 45 |
1417476 | 1417476 | 2021-06-14 | Hendry | Florida | 12051 | 4886 | 87 |
1417477 | 1417477 | 2021-06-14 | Hernando | Florida | 12053 | 14678 | 482 |
1417478 | 1417478 | 2021-06-14 | Highlands | Florida | 12055 | 8721 | 366 |
1417479 | 1417479 | 2021-06-14 | Hillsborough | Florida | 12057 | 143544 | 1832 |
1417480 | 1417480 | 2021-06-14 | Holmes | Florida | 12059 | 2258 | 49 |
1417481 | 1417481 | 2021-06-14 | Indian River | Florida | 12061 | 12802 | 306 |
1417482 | 1417482 | 2021-06-14 | Jackson | Florida | 12063 | 6284 | 158 |
1417483 | 1417483 | 2021-06-14 | Jefferson | Florida | 12065 | 1502 | 28 |
1417484 | 1417484 | 2021-06-14 | Lafayette | Florida | 12067 | 1627 | 26 |
1417485 | 1417485 | 2021-06-14 | Lake | Florida | 12069 | 30765 | 663 |
1417486 | 1417486 | 2021-06-14 | Lee | Florida | 12071 | 71918 | 1009 |
1417487 | 1417487 | 2021-06-14 | Leon | Florida | 12073 | 32093 | 332 |
1417488 | 1417488 | 2021-06-14 | Levy | Florida | 12075 | 3595 | 56 |
1417489 | 1417489 | 2021-06-14 | Liberty | Florida | 12077 | 1084 | 16 |
1417490 | 1417490 | 2021-06-14 | Madison | Florida | 12079 | 2080 | 45 |
1417491 | 1417491 | 2021-06-14 | Manatee | Florida | 12081 | 39284 | 689 |
1417492 | 1417492 | 2021-06-14 | Marion | Florida | 12083 | 31951 | 996 |
1417493 | 1417493 | 2021-06-14 | Martin | Florida | 12085 | 12596 | 335 |
1417494 | 1417494 | 2021-06-14 | Miami-Dade | Florida | 12086 | 497726 | 6472 |
1417495 | 1417495 | 2021-06-14 | Monroe | Florida | 12087 | 6739 | 52 |
1417496 | 1417496 | 2021-06-14 | Nassau | Florida | 12089 | 8276 | 127 |
1417497 | 1417497 | 2021-06-14 | Okaloosa | Florida | 12091 | 20776 | 367 |
1417498 | 1417498 | 2021-06-14 | Okeechobee | Florida | 12093 | 4181 | 89 |
1417499 | 1417499 | 2021-06-14 | Orange | Florida | 12095 | 141941 | 1310 |
1417500 | 1417500 | 2021-06-14 | Osceola | Florida | 12097 | 45916 | 529 |
1417501 | 1417501 | 2021-06-14 | Palm Beach | Florida | 12099 | 146960 | 2883 |
1417502 | 1417502 | 2021-06-14 | Pasco | Florida | 12101 | 42903 | 802 |
1417503 | 1417503 | 2021-06-14 | Pinellas | Florida | 12103 | 79890 | 1671 |
1417504 | 1417504 | 2021-06-14 | Polk | Florida | 12105 | 71204 | 1387 |
1417505 | 1417505 | 2021-06-14 | Putnam | Florida | 12107 | 6751 | 160 |
1417506 | 1417506 | 2021-06-14 | Santa Rosa | Florida | 12113 | 18423 | 291 |
1417507 | 1417507 | 2021-06-14 | Sarasota | Florida | 12115 | 32325 | 844 |
1417508 | 1417508 | 2021-06-14 | Seminole | Florida | 12117 | 35467 | 516 |
1417509 | 1417509 | 2021-06-14 | St. Johns | Florida | 12109 | 23131 | 221 |
1417510 | 1417510 | 2021-06-14 | St. Lucie | Florida | 12111 | 27633 | 657 |
1417511 | 1417511 | 2021-06-14 | Sumter | Florida | 12119 | 9434 | 284 |
1417512 | 1417512 | 2021-06-14 | Suwannee | Florida | 12121 | 5393 | 140 |
1417513 | 1417513 | 2021-06-14 | Taylor | Florida | 12123 | 2748 | 48 |
1417514 | 1417514 | 2021-06-14 | Union | Florida | 12125 | 1863 | 74 |
1417515 | 1417515 | 2021-06-14 | Unknown | Florida | 4191 | 357 | |
1417516 | 1417516 | 2021-06-14 | Volusia | Florida | 12127 | 44491 | 846 |
1417517 | 1417517 | 2021-06-14 | Wakulla | Florida | 12129 | 3539 | 56 |
1417518 | 1417518 | 2021-06-14 | Walton | Florida | 12131 | 7067 | 89 |
1417519 | 1417519 | 2021-06-14 | Washington | Florida | 12133 | 2737 | 52 |
1414206 | 1414206 | 2021-06-13 | Alachua | Florida | 12001 | 25293 | 285 |
1414207 | 1414207 | 2021-06-13 | Baker | Florida | 12003 | 3557 | 62 |
1414208 | 1414208 | 2021-06-13 | Bay | Florida | 12005 | 19844 | 394 |
1414209 | 1414209 | 2021-06-13 | Bradford | Florida | 12007 | 3045 | 58 |
1414210 | 1414210 | 2021-06-13 | Brevard | Florida | 12009 | 42604 | 914 |
1414211 | 1414211 | 2021-06-13 | Broward | Florida | 12011 | 243765 | 3079 |
1414212 | 1414212 | 2021-06-13 | Calhoun | Florida | 12013 | 1710 | 45 |
1414213 | 1414213 | 2021-06-13 | Charlotte | Florida | 12015 | 13303 | 437 |
1414214 | 1414214 | 2021-06-13 | Citrus | Florida | 12017 | 11401 | 463 |
1414215 | 1414215 | 2021-06-13 | Clay | Florida | 12019 | 19391 | 352 |
1414216 | 1414216 | 2021-06-13 | Collier | Florida | 12021 | 35994 | 551 |
1414217 | 1414217 | 2021-06-13 | Columbia | Florida | 12023 | 8270 | 170 |
1414218 | 1414218 | 2021-06-13 | DeSoto | Florida | 12027 | 4433 | 97 |
1414219 | 1414219 | 2021-06-13 | Dixie | Florida | 12029 | 1628 | 24 |
1414220 | 1414220 | 2021-06-13 | Duval | Florida | 12031 | 100193 | 1483 |
1414221 | 1414221 | 2021-06-13 | Escambia | Florida | 12033 | 33028 | 706 |
1414222 | 1414222 | 2021-06-13 | Flagler | Florida | 12035 | 7459 | 114 |
1414223 | 1414223 | 2021-06-13 | Franklin | Florida | 12037 | 1320 | 20 |
1414224 | 1414224 | 2021-06-13 | Gadsden | Florida | 12039 | 5793 | 99 |
1414225 | 1414225 | 2021-06-13 | Gilchrist | Florida | 12041 | 1645 | 44 |
1414226 | 1414226 | 2021-06-13 | Glades | Florida | 12043 | 984 | 19 |
1414227 | 1414227 | 2021-06-13 | Gulf | Florida | 12045 | 1960 | 45 |
1414228 | 1414228 | 2021-06-13 | Hamilton | Florida | 12047 | 1629 | 25 |
1414229 | 1414229 | 2021-06-13 | Hardee | Florida | 12049 | 3296 | 45 |
1414230 | 1414230 | 2021-06-13 | Hendry | Florida | 12051 | 4886 | 87 |
1414231 | 1414231 | 2021-06-13 | Hernando | Florida | 12053 | 14678 | 482 |
1414232 | 1414232 | 2021-06-13 | Highlands | Florida | 12055 | 8721 | 366 |
1414233 | 1414233 | 2021-06-13 | Hillsborough | Florida | 12057 | 143544 | 1832 |
1414234 | 1414234 | 2021-06-13 | Holmes | Florida | 12059 | 2258 | 49 |
1414235 | 1414235 | 2021-06-13 | Indian River | Florida | 12061 | 12802 | 306 |
1414236 | 1414236 | 2021-06-13 | Jackson | Florida | 12063 | 6284 | 158 |
1414237 | 1414237 | 2021-06-13 | Jefferson | Florida | 12065 | 1502 | 28 |
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);