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 362
- 12057 361
- 12113 358
- 12071 357
- 12011 356
- 12091 356
- 12127 356
- 12015 355
- 12089 353
- 12101 353
- 12103 353
- 12001 352
- 12021 352
- 12086 352
- 12109 352
- 12099 351
- 12115 351
- 12117 351
- 12019 350
- 12031 350
- 12095 350
- 12097 350
- 12003 347
- 12017 347
- 12069 347
- 12033 346
- 12105 346
- 12009 345
- 12073 345
- 12119 345
- …
county >30
- Manatee 362
- Hillsborough 361
- Santa Rosa 358
- Lee 357
- Broward 356
- Okaloosa 356
- Volusia 356
- Charlotte 355
- Nassau 353
- Pasco 353
- Pinellas 353
- Alachua 352
- Collier 352
- Miami-Dade 352
- St. Johns 352
- Palm Beach 351
- Sarasota 351
- Seminole 351
- Clay 350
- Duval 350
- Orange 350
- Osceola 350
- Baker 347
- Citrus 347
- Lake 347
- Escambia 346
- Polk 346
- Brevard 345
- Leon 345
- Sumter 345
- …
state 1
- Florida · 23,274 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1063597 | 1063597 | 2021-02-25 | Lafayette | Florida | 12067 | 1583 | 24 |
1063598 | 1063598 | 2021-02-25 | Lake | Florida | 12069 | 24342 | 544 |
1063599 | 1063599 | 2021-02-25 | Lee | Florida | 12071 | 57274 | 869 |
1063600 | 1063600 | 2021-02-25 | Leon | Florida | 12073 | 28960 | 276 |
1063601 | 1063601 | 2021-02-25 | Levy | Florida | 12075 | 2854 | 35 |
1063602 | 1063602 | 2021-02-25 | Liberty | Florida | 12077 | 1039 | 15 |
1063603 | 1063603 | 2021-02-25 | Madison | Florida | 12079 | 1980 | 42 |
1063604 | 1063604 | 2021-02-25 | Manatee | Florida | 12081 | 31579 | 577 |
1063605 | 1063605 | 2021-02-25 | Marion | Florida | 12083 | 27382 | 780 |
1063606 | 1063606 | 2021-02-25 | Martin | Florida | 12085 | 10500 | 273 |
1063607 | 1063607 | 2021-02-25 | Miami-Dade | Florida | 12086 | 406986 | 5369 |
1063608 | 1063608 | 2021-02-25 | Monroe | Florida | 12087 | 5771 | 46 |
1063609 | 1063609 | 2021-02-25 | Nassau | Florida | 12089 | 7681 | 109 |
1063610 | 1063610 | 2021-02-25 | Okaloosa | Florida | 12091 | 18661 | 327 |
1063611 | 1063611 | 2021-02-25 | Okeechobee | Florida | 12093 | 3545 | 75 |
1063612 | 1063612 | 2021-02-25 | Orange | Florida | 12095 | 113329 | 1090 |
1063613 | 1063613 | 2021-02-25 | Osceola | Florida | 12097 | 36521 | 435 |
1063614 | 1063614 | 2021-02-25 | Palm Beach | Florida | 12099 | 119371 | 2443 |
1063615 | 1063615 | 2021-02-25 | Pasco | Florida | 12101 | 33035 | 641 |
1063616 | 1063616 | 2021-02-25 | Pinellas | Florida | 12103 | 65937 | 1433 |
1063617 | 1063617 | 2021-02-25 | Polk | Florida | 12105 | 56583 | 1131 |
1063618 | 1063618 | 2021-02-25 | Putnam | Florida | 12107 | 5820 | 123 |
1063619 | 1063619 | 2021-02-25 | Santa Rosa | Florida | 12113 | 16972 | 256 |
1063620 | 1063620 | 2021-02-25 | Sarasota | Florida | 12115 | 26804 | 730 |
1063621 | 1063621 | 2021-02-25 | Seminole | Florida | 12117 | 26967 | 422 |
1063622 | 1063622 | 2021-02-25 | St. Johns | Florida | 12109 | 19982 | 189 |
1063623 | 1063623 | 2021-02-25 | St. Lucie | Florida | 12111 | 21949 | 543 |
1063624 | 1063624 | 2021-02-25 | Sumter | Florida | 12119 | 7946 | 235 |
1063625 | 1063625 | 2021-02-25 | Suwannee | Florida | 12121 | 5099 | 131 |
1063626 | 1063626 | 2021-02-25 | Taylor | Florida | 12123 | 2624 | 41 |
1063627 | 1063627 | 2021-02-25 | Union | Florida | 12125 | 1740 | 70 |
1063628 | 1063628 | 2021-02-25 | Unknown | Florida | 3446 | 0 | |
1063629 | 1063629 | 2021-02-25 | Volusia | Florida | 12127 | 34240 | 650 |
1063630 | 1063630 | 2021-02-25 | Wakulla | Florida | 12129 | 3151 | 51 |
1063631 | 1063631 | 2021-02-25 | Walton | Florida | 12131 | 6996 | 80 |
1063632 | 1063632 | 2021-02-25 | Washington | Florida | 12133 | 2616 | 41 |
1060320 | 1060320 | 2021-02-24 | Alachua | Florida | 12001 | 22228 | 226 |
1060321 | 1060321 | 2021-02-24 | Baker | Florida | 12003 | 3283 | 55 |
1060322 | 1060322 | 2021-02-24 | Bay | Florida | 12005 | 18475 | 338 |
1060323 | 1060323 | 2021-02-24 | Bradford | Florida | 12007 | 2833 | 52 |
1060324 | 1060324 | 2021-02-24 | Brevard | Florida | 12009 | 33429 | 736 |
1060325 | 1060325 | 2021-02-24 | Broward | Florida | 12011 | 191968 | 2361 |
1060326 | 1060326 | 2021-02-24 | Calhoun | Florida | 12013 | 1604 | 40 |
1060327 | 1060327 | 2021-02-24 | Charlotte | Florida | 12015 | 10596 | 358 |
1060328 | 1060328 | 2021-02-24 | Citrus | Florida | 12017 | 9641 | 391 |
1060329 | 1060329 | 2021-02-24 | Clay | Florida | 12019 | 16603 | 299 |
1060330 | 1060330 | 2021-02-24 | Collier | Florida | 12021 | 29963 | 450 |
1060331 | 1060331 | 2021-02-24 | Columbia | Florida | 12023 | 7634 | 155 |
1060332 | 1060332 | 2021-02-24 | DeSoto | Florida | 12027 | 3734 | 72 |
1060333 | 1060333 | 2021-02-24 | Dixie | Florida | 12029 | 1468 | 19 |
1060334 | 1060334 | 2021-02-24 | Duval | Florida | 12031 | 88057 | 1130 |
1060335 | 1060335 | 2021-02-24 | Escambia | Florida | 12033 | 33391 | 618 |
1060336 | 1060336 | 2021-02-24 | Flagler | Florida | 12035 | 5832 | 87 |
1060337 | 1060337 | 2021-02-24 | Franklin | Florida | 12037 | 1277 | 13 |
1060338 | 1060338 | 2021-02-24 | Gadsden | Florida | 12039 | 5400 | 83 |
1060339 | 1060339 | 2021-02-24 | Gilchrist | Florida | 12041 | 1390 | 33 |
1060340 | 1060340 | 2021-02-24 | Glades | Florida | 12043 | 899 | 15 |
1060341 | 1060341 | 2021-02-24 | Gulf | Florida | 12045 | 1856 | 37 |
1060342 | 1060342 | 2021-02-24 | Hamilton | Florida | 12047 | 1559 | 21 |
1060343 | 1060343 | 2021-02-24 | Hardee | Florida | 12049 | 2769 | 29 |
1060344 | 1060344 | 2021-02-24 | Hendry | Florida | 12051 | 4267 | 71 |
1060345 | 1060345 | 2021-02-24 | Hernando | Florida | 12053 | 11147 | 395 |
1060346 | 1060346 | 2021-02-24 | Highlands | Florida | 12055 | 7176 | 298 |
1060347 | 1060347 | 2021-02-24 | Hillsborough | Florida | 12057 | 110086 | 1470 |
1060348 | 1060348 | 2021-02-24 | Holmes | Florida | 12059 | 2166 | 44 |
1060349 | 1060349 | 2021-02-24 | Indian River | Florida | 12061 | 10897 | 260 |
1060350 | 1060350 | 2021-02-24 | Jackson | Florida | 12063 | 5879 | 147 |
1060351 | 1060351 | 2021-02-24 | Jefferson | Florida | 12065 | 1396 | 23 |
1060352 | 1060352 | 2021-02-24 | Lafayette | Florida | 12067 | 1582 | 24 |
1060353 | 1060353 | 2021-02-24 | Lake | Florida | 12069 | 24228 | 541 |
1060354 | 1060354 | 2021-02-24 | Lee | Florida | 12071 | 57123 | 869 |
1060355 | 1060355 | 2021-02-24 | Leon | Florida | 12073 | 28884 | 277 |
1060356 | 1060356 | 2021-02-24 | Levy | Florida | 12075 | 2842 | 34 |
1060357 | 1060357 | 2021-02-24 | Liberty | Florida | 12077 | 1037 | 15 |
1060358 | 1060358 | 2021-02-24 | Madison | Florida | 12079 | 1978 | 40 |
1060359 | 1060359 | 2021-02-24 | Manatee | Florida | 12081 | 31469 | 576 |
1060360 | 1060360 | 2021-02-24 | Marion | Florida | 12083 | 27301 | 778 |
1060361 | 1060361 | 2021-02-24 | Martin | Florida | 12085 | 10434 | 273 |
1060362 | 1060362 | 2021-02-24 | Miami-Dade | Florida | 12086 | 405562 | 5353 |
1060363 | 1060363 | 2021-02-24 | Monroe | Florida | 12087 | 5747 | 46 |
1060364 | 1060364 | 2021-02-24 | Nassau | Florida | 12089 | 7664 | 109 |
1060365 | 1060365 | 2021-02-24 | Okaloosa | Florida | 12091 | 18512 | 322 |
1060366 | 1060366 | 2021-02-24 | Okeechobee | Florida | 12093 | 3531 | 75 |
1060367 | 1060367 | 2021-02-24 | Orange | Florida | 12095 | 112974 | 1075 |
1060368 | 1060368 | 2021-02-24 | Osceola | Florida | 12097 | 36387 | 433 |
1060369 | 1060369 | 2021-02-24 | Palm Beach | Florida | 12099 | 118851 | 2428 |
1060370 | 1060370 | 2021-02-24 | Pasco | Florida | 12101 | 32900 | 641 |
1060371 | 1060371 | 2021-02-24 | Pinellas | Florida | 12103 | 65623 | 1432 |
1060372 | 1060372 | 2021-02-24 | Polk | Florida | 12105 | 56409 | 1133 |
1060373 | 1060373 | 2021-02-24 | Putnam | Florida | 12107 | 5811 | 123 |
1060374 | 1060374 | 2021-02-24 | Santa Rosa | Florida | 12113 | 16915 | 256 |
1060375 | 1060375 | 2021-02-24 | Sarasota | Florida | 12115 | 26714 | 724 |
1060376 | 1060376 | 2021-02-24 | Seminole | Florida | 12117 | 26869 | 419 |
1060377 | 1060377 | 2021-02-24 | St. Johns | Florida | 12109 | 19945 | 188 |
1060378 | 1060378 | 2021-02-24 | St. Lucie | Florida | 12111 | 21850 | 536 |
1060379 | 1060379 | 2021-02-24 | Sumter | Florida | 12119 | 7908 | 234 |
1060380 | 1060380 | 2021-02-24 | Suwannee | Florida | 12121 | 5087 | 131 |
1060381 | 1060381 | 2021-02-24 | Taylor | Florida | 12123 | 2618 | 41 |
1060382 | 1060382 | 2021-02-24 | Union | Florida | 12125 | 1732 | 70 |
1060383 | 1060383 | 2021-02-24 | Unknown | Florida | 3440 | 0 |
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);