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 596
- 12081 596
- 12113 592
- 12011 591
- 12071 591
- 12015 590
- 12091 590
- 12127 590
- 12001 587
- 12021 587
- 12089 587
- 12101 587
- 12103 587
- 12086 586
- 12109 586
- 12019 585
- 12031 585
- 12099 585
- 12115 585
- 12117 585
- 12095 584
- 12097 584
- 12003 582
- 12017 582
- 12033 581
- 12069 581
- 12009 580
- 12105 580
- 12073 579
- 12119 579
- …
county >30
- Hillsborough 596
- Manatee 596
- Santa Rosa 592
- Broward 591
- Lee 591
- Charlotte 590
- Okaloosa 590
- Volusia 590
- Alachua 587
- Collier 587
- Nassau 587
- Pasco 587
- Pinellas 587
- Miami-Dade 586
- St. Johns 586
- Clay 585
- Duval 585
- Palm Beach 585
- Sarasota 585
- Seminole 585
- Orange 584
- Osceola 584
- Baker 582
- Citrus 582
- Escambia 581
- Lake 581
- Brevard 580
- Polk 580
- Leon 579
- Sumter 579
- …
state 1
- Florida · 39,218 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1823435 | 1823435 | 2021-10-17 | Alachua | Florida | 12001 | 39153 | 521 |
1823436 | 1823436 | 2021-10-17 | Baker | Florida | 12003 | 5960 | 117 |
1823437 | 1823437 | 2021-10-17 | Bay | Florida | 12005 | 31587 | 667 |
1823438 | 1823438 | 2021-10-17 | Bradford | Florida | 12007 | 5319 | 73 |
1823439 | 1823439 | 2021-10-17 | Brevard | Florida | 12009 | 80128 | 1671 |
1823440 | 1823440 | 2021-10-17 | Broward | Florida | 12011 | 354108 | 4614 |
1823441 | 1823441 | 2021-10-17 | Calhoun | Florida | 12013 | 3000 | 61 |
1823442 | 1823442 | 2021-10-17 | Charlotte | Florida | 12015 | 22972 | 532 |
1823443 | 1823443 | 2021-10-17 | Citrus | Florida | 12017 | 20261 | 758 |
1823444 | 1823444 | 2021-10-17 | Clay | Florida | 12019 | 33642 | 675 |
1823445 | 1823445 | 2021-10-17 | Collier | Florida | 12021 | 56373 | 823 |
1823446 | 1823446 | 2021-10-17 | Columbia | Florida | 12023 | 14809 | 302 |
1823447 | 1823447 | 2021-10-17 | DeSoto | Florida | 12027 | 6841 | 130 |
1823448 | 1823448 | 2021-10-17 | Dixie | Florida | 12029 | 2935 | 32 |
1823449 | 1823449 | 2021-10-17 | Duval | Florida | 12031 | 163590 | 2691 |
1823450 | 1823450 | 2021-10-17 | Escambia | Florida | 12033 | 53282 | 1011 |
1823451 | 1823451 | 2021-10-17 | Flagler | Florida | 12035 | 14254 | 192 |
1823452 | 1823452 | 2021-10-17 | Franklin | Florida | 12037 | 2218 | 45 |
1823453 | 1823453 | 2021-10-17 | Gadsden | Florida | 12039 | 8594 | 115 |
1823454 | 1823454 | 2021-10-17 | Gilchrist | Florida | 12041 | 3127 | 59 |
1823455 | 1823455 | 2021-10-17 | Glades | Florida | 12043 | 1429 | 24 |
1823456 | 1823456 | 2021-10-17 | Gulf | Florida | 12045 | 2960 | 64 |
1823457 | 1823457 | 2021-10-17 | Hamilton | Florida | 12047 | 2708 | 45 |
1823458 | 1823458 | 2021-10-17 | Hardee | Florida | 12049 | 6035 | 96 |
1823459 | 1823459 | 2021-10-17 | Hendry | Florida | 12051 | 7916 | 109 |
1823460 | 1823460 | 2021-10-17 | Hernando | Florida | 12053 | 28373 | 859 |
1823461 | 1823461 | 2021-10-17 | Highlands | Florida | 12055 | 15811 | 527 |
1823462 | 1823462 | 2021-10-17 | Hillsborough | Florida | 12057 | 239223 | 2857 |
1823463 | 1823463 | 2021-10-17 | Holmes | Florida | 12059 | 3822 | 69 |
1823464 | 1823464 | 2021-10-17 | Indian River | Florida | 12061 | 22036 | 528 |
1823465 | 1823465 | 2021-10-17 | Jackson | Florida | 12063 | 10035 | 209 |
1823466 | 1823466 | 2021-10-17 | Jefferson | Florida | 12065 | 2444 | 36 |
1823467 | 1823467 | 2021-10-17 | Lafayette | Florida | 12067 | 2186 | 32 |
1823468 | 1823468 | 2021-10-17 | Lake | Florida | 12069 | 53868 | 1137 |
1823469 | 1823469 | 2021-10-17 | Lee | Florida | 12071 | 123984 | 1726 |
1823470 | 1823470 | 2021-10-17 | Leon | Florida | 12073 | 50205 | 487 |
1823471 | 1823471 | 2021-10-17 | Levy | Florida | 12075 | 6921 | 79 |
1823472 | 1823472 | 2021-10-17 | Liberty | Florida | 12077 | 1815 | 19 |
1823473 | 1823473 | 2021-10-17 | Madison | Florida | 12079 | 3572 | 54 |
1823474 | 1823474 | 2021-10-17 | Manatee | Florida | 12081 | 64348 | 913 |
1823475 | 1823475 | 2021-10-17 | Marion | Florida | 12083 | 56318 | 1690 |
1823476 | 1823476 | 2021-10-17 | Martin | Florida | 12085 | 19952 | 494 |
1823477 | 1823477 | 2021-10-17 | Miami-Dade | Florida | 12086 | 667933 | 8648 |
1823478 | 1823478 | 2021-10-17 | Monroe | Florida | 12087 | 10381 | 85 |
1823479 | 1823479 | 2021-10-17 | Nassau | Florida | 12089 | 14931 | 235 |
1823480 | 1823480 | 2021-10-17 | Okaloosa | Florida | 12091 | 34174 | 537 |
1823481 | 1823481 | 2021-10-17 | Okeechobee | Florida | 12093 | 7370 | 120 |
1823482 | 1823482 | 2021-10-17 | Orange | Florida | 12095 | 226228 | 2066 |
1823483 | 1823483 | 2021-10-17 | Osceola | Florida | 12097 | 70989 | 835 |
1823484 | 1823484 | 2021-10-17 | Palm Beach | Florida | 12099 | 223197 | 4004 |
1823485 | 1823485 | 2021-10-17 | Pasco | Florida | 12101 | 78642 | 1466 |
1823486 | 1823486 | 2021-10-17 | Pinellas | Florida | 12103 | 133436 | 2576 |
1823487 | 1823487 | 2021-10-17 | Polk | Florida | 12105 | 127470 | 2334 |
1823488 | 1823488 | 2021-10-17 | Putnam | Florida | 12107 | 12708 | 316 |
1823489 | 1823489 | 2021-10-17 | Santa Rosa | Florida | 12113 | 32164 | 499 |
1823490 | 1823490 | 2021-10-17 | Sarasota | Florida | 12115 | 54899 | 1248 |
1823491 | 1823491 | 2021-10-17 | Seminole | Florida | 12117 | 61582 | 824 |
1823492 | 1823492 | 2021-10-17 | St. Johns | Florida | 12109 | 40360 | 441 |
1823493 | 1823493 | 2021-10-17 | St. Lucie | Florida | 12111 | 47433 | 979 |
1823494 | 1823494 | 2021-10-17 | Sumter | Florida | 12119 | 14369 | 446 |
1823495 | 1823495 | 2021-10-17 | Suwannee | Florida | 12121 | 9152 | 166 |
1823496 | 1823496 | 2021-10-17 | Taylor | Florida | 12123 | 4572 | 77 |
1823497 | 1823497 | 2021-10-17 | Union | Florida | 12125 | 3056 | 78 |
1823498 | 1823498 | 2021-10-17 | Unknown | Florida | 2485 | 1182 | |
1823499 | 1823499 | 2021-10-17 | Volusia | Florida | 12127 | 74698 | 1233 |
1823500 | 1823500 | 2021-10-17 | Wakulla | Florida | 12129 | 6348 | 102 |
1823501 | 1823501 | 2021-10-17 | Walton | Florida | 12131 | 11824 | 157 |
1823502 | 1823502 | 2021-10-17 | Washington | Florida | 12133 | 4531 | 62 |
1820186 | 1820186 | 2021-10-16 | Alachua | Florida | 12001 | 39153 | 521 |
1820187 | 1820187 | 2021-10-16 | Baker | Florida | 12003 | 5960 | 117 |
1820188 | 1820188 | 2021-10-16 | Bay | Florida | 12005 | 31587 | 667 |
1820189 | 1820189 | 2021-10-16 | Bradford | Florida | 12007 | 5319 | 73 |
1820190 | 1820190 | 2021-10-16 | Brevard | Florida | 12009 | 80128 | 1671 |
1820191 | 1820191 | 2021-10-16 | Broward | Florida | 12011 | 354108 | 4614 |
1820192 | 1820192 | 2021-10-16 | Calhoun | Florida | 12013 | 3000 | 61 |
1820193 | 1820193 | 2021-10-16 | Charlotte | Florida | 12015 | 22972 | 532 |
1820194 | 1820194 | 2021-10-16 | Citrus | Florida | 12017 | 20261 | 758 |
1820195 | 1820195 | 2021-10-16 | Clay | Florida | 12019 | 33642 | 675 |
1820196 | 1820196 | 2021-10-16 | Collier | Florida | 12021 | 56373 | 823 |
1820197 | 1820197 | 2021-10-16 | Columbia | Florida | 12023 | 14809 | 302 |
1820198 | 1820198 | 2021-10-16 | DeSoto | Florida | 12027 | 6841 | 130 |
1820199 | 1820199 | 2021-10-16 | Dixie | Florida | 12029 | 2935 | 32 |
1820200 | 1820200 | 2021-10-16 | Duval | Florida | 12031 | 163590 | 2691 |
1820201 | 1820201 | 2021-10-16 | Escambia | Florida | 12033 | 53282 | 1011 |
1820202 | 1820202 | 2021-10-16 | Flagler | Florida | 12035 | 14254 | 192 |
1820203 | 1820203 | 2021-10-16 | Franklin | Florida | 12037 | 2218 | 45 |
1820204 | 1820204 | 2021-10-16 | Gadsden | Florida | 12039 | 8594 | 115 |
1820205 | 1820205 | 2021-10-16 | Gilchrist | Florida | 12041 | 3127 | 59 |
1820206 | 1820206 | 2021-10-16 | Glades | Florida | 12043 | 1429 | 24 |
1820207 | 1820207 | 2021-10-16 | Gulf | Florida | 12045 | 2960 | 64 |
1820208 | 1820208 | 2021-10-16 | Hamilton | Florida | 12047 | 2708 | 45 |
1820209 | 1820209 | 2021-10-16 | Hardee | Florida | 12049 | 6035 | 96 |
1820210 | 1820210 | 2021-10-16 | Hendry | Florida | 12051 | 7916 | 109 |
1820211 | 1820211 | 2021-10-16 | Hernando | Florida | 12053 | 28373 | 859 |
1820212 | 1820212 | 2021-10-16 | Highlands | Florida | 12055 | 15811 | 527 |
1820213 | 1820213 | 2021-10-16 | Hillsborough | Florida | 12057 | 239223 | 2857 |
1820214 | 1820214 | 2021-10-16 | Holmes | Florida | 12059 | 3822 | 69 |
1820215 | 1820215 | 2021-10-16 | Indian River | Florida | 12061 | 22036 | 528 |
1820216 | 1820216 | 2021-10-16 | Jackson | Florida | 12063 | 10035 | 209 |
1820217 | 1820217 | 2021-10-16 | Jefferson | Florida | 12065 | 2444 | 36 |
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);