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 601
- 12057 600
- 12113 597
- 12071 596
- 12011 595
- 12091 595
- 12127 595
- 12015 594
- 12089 592
- 12101 592
- 12103 592
- 12001 591
- 12021 591
- 12086 591
- 12109 591
- 12099 590
- 12115 590
- 12117 590
- 12019 589
- 12031 589
- 12095 589
- 12097 589
- 12003 586
- 12017 586
- 12069 586
- 12033 585
- 12105 585
- 12009 584
- 12073 584
- 12119 584
- …
county >30
- Manatee 601
- Hillsborough 600
- Santa Rosa 597
- Lee 596
- Broward 595
- Okaloosa 595
- Volusia 595
- Charlotte 594
- Nassau 592
- Pasco 592
- Pinellas 592
- Alachua 591
- Collier 591
- Miami-Dade 591
- St. Johns 591
- Palm Beach 590
- Sarasota 590
- Seminole 590
- Clay 589
- Duval 589
- Orange 589
- Osceola 589
- Baker 586
- Citrus 586
- Lake 586
- Escambia 585
- Polk 585
- Brevard 584
- Leon 584
- Sumter 584
- …
state 1
- Florida · 39,526 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839712 | 1839712 | 2021-10-22 | Lafayette | Florida | 12067 | 2208 | 32 |
1839713 | 1839713 | 2021-10-22 | Lake | Florida | 12069 | 54129 | 1181 |
1839714 | 1839714 | 2021-10-22 | Lee | Florida | 12071 | 124415 | 1748 |
1839715 | 1839715 | 2021-10-22 | Leon | Florida | 12073 | 50441 | 494 |
1839716 | 1839716 | 2021-10-22 | Levy | Florida | 12075 | 6953 | 81 |
1839717 | 1839717 | 2021-10-22 | Liberty | Florida | 12077 | 1823 | 19 |
1839718 | 1839718 | 2021-10-22 | Madison | Florida | 12079 | 3584 | 54 |
1839719 | 1839719 | 2021-10-22 | Manatee | Florida | 12081 | 64610 | 930 |
1839720 | 1839720 | 2021-10-22 | Marion | Florida | 12083 | 56558 | 1709 |
1839721 | 1839721 | 2021-10-22 | Martin | Florida | 12085 | 20060 | 500 |
1839722 | 1839722 | 2021-10-22 | Miami-Dade | Florida | 12086 | 670019 | 8768 |
1839723 | 1839723 | 2021-10-22 | Monroe | Florida | 12087 | 10445 | 91 |
1839724 | 1839724 | 2021-10-22 | Nassau | Florida | 12089 | 14994 | 238 |
1839725 | 1839725 | 2021-10-22 | Okaloosa | Florida | 12091 | 34287 | 542 |
1839726 | 1839726 | 2021-10-22 | Okeechobee | Florida | 12093 | 7382 | 126 |
1839727 | 1839727 | 2021-10-22 | Orange | Florida | 12095 | 227246 | 2124 |
1839728 | 1839728 | 2021-10-22 | Osceola | Florida | 12097 | 71294 | 855 |
1839729 | 1839729 | 2021-10-22 | Palm Beach | Florida | 12099 | 224195 | 4060 |
1839730 | 1839730 | 2021-10-22 | Pasco | Florida | 12101 | 78907 | 1511 |
1839731 | 1839731 | 2021-10-22 | Pinellas | Florida | 12103 | 133980 | 2625 |
1839732 | 1839732 | 2021-10-22 | Polk | Florida | 12105 | 128010 | 2381 |
1839733 | 1839733 | 2021-10-22 | Putnam | Florida | 12107 | 12751 | 317 |
1839734 | 1839734 | 2021-10-22 | Santa Rosa | Florida | 12113 | 32310 | 512 |
1839735 | 1839735 | 2021-10-22 | Sarasota | Florida | 12115 | 55072 | 1277 |
1839736 | 1839736 | 2021-10-22 | Seminole | Florida | 12117 | 61835 | 833 |
1839737 | 1839737 | 2021-10-22 | St. Johns | Florida | 12109 | 40496 | 455 |
1839738 | 1839738 | 2021-10-22 | St. Lucie | Florida | 12111 | 47636 | 990 |
1839739 | 1839739 | 2021-10-22 | Sumter | Florida | 12119 | 14451 | 451 |
1839740 | 1839740 | 2021-10-22 | Suwannee | Florida | 12121 | 9175 | 163 |
1839741 | 1839741 | 2021-10-22 | Taylor | Florida | 12123 | 4582 | 77 |
1839742 | 1839742 | 2021-10-22 | Union | Florida | 12125 | 3057 | 96 |
1839743 | 1839743 | 2021-10-22 | Unknown | Florida | 1 | 929 | |
1839744 | 1839744 | 2021-10-22 | Volusia | Florida | 12127 | 75256 | 1271 |
1839745 | 1839745 | 2021-10-22 | Wakulla | Florida | 12129 | 6375 | 103 |
1839746 | 1839746 | 2021-10-22 | Walton | Florida | 12131 | 11895 | 159 |
1839747 | 1839747 | 2021-10-22 | Washington | Florida | 12133 | 4542 | 62 |
1836431 | 1836431 | 2021-10-21 | Alachua | Florida | 12001 | 39153 | 521 |
1836432 | 1836432 | 2021-10-21 | Baker | Florida | 12003 | 5960 | 117 |
1836433 | 1836433 | 2021-10-21 | Bay | Florida | 12005 | 31587 | 673 |
1836434 | 1836434 | 2021-10-21 | Bradford | Florida | 12007 | 5319 | 119 |
1836435 | 1836435 | 2021-10-21 | Brevard | Florida | 12009 | 80128 | 1695 |
1836436 | 1836436 | 2021-10-21 | Broward | Florida | 12011 | 354108 | 4698 |
1836437 | 1836437 | 2021-10-21 | Calhoun | Florida | 12013 | 3000 | 62 |
1836438 | 1836438 | 2021-10-21 | Charlotte | Florida | 12015 | 22972 | 669 |
1836439 | 1836439 | 2021-10-21 | Citrus | Florida | 12017 | 20261 | 777 |
1836440 | 1836440 | 2021-10-21 | Clay | Florida | 12019 | 33642 | 685 |
1836441 | 1836441 | 2021-10-21 | Collier | Florida | 12021 | 56373 | 833 |
1836442 | 1836442 | 2021-10-21 | Columbia | Florida | 12023 | 14809 | 308 |
1836443 | 1836443 | 2021-10-21 | DeSoto | Florida | 12027 | 6841 | 132 |
1836444 | 1836444 | 2021-10-21 | Dixie | Florida | 12029 | 2935 | 31 |
1836445 | 1836445 | 2021-10-21 | Duval | Florida | 12031 | 163590 | 2732 |
1836446 | 1836446 | 2021-10-21 | Escambia | Florida | 12033 | 53282 | 1049 |
1836447 | 1836447 | 2021-10-21 | Flagler | Florida | 12035 | 14254 | 205 |
1836448 | 1836448 | 2021-10-21 | Franklin | Florida | 12037 | 2218 | 45 |
1836449 | 1836449 | 2021-10-21 | Gadsden | Florida | 12039 | 8594 | 116 |
1836450 | 1836450 | 2021-10-21 | Gilchrist | Florida | 12041 | 3127 | 55 |
1836451 | 1836451 | 2021-10-21 | Glades | Florida | 12043 | 1429 | 25 |
1836452 | 1836452 | 2021-10-21 | Gulf | Florida | 12045 | 2960 | 64 |
1836453 | 1836453 | 2021-10-21 | Hamilton | Florida | 12047 | 2708 | 47 |
1836454 | 1836454 | 2021-10-21 | Hardee | Florida | 12049 | 6035 | 97 |
1836455 | 1836455 | 2021-10-21 | Hendry | Florida | 12051 | 7916 | 110 |
1836456 | 1836456 | 2021-10-21 | Hernando | Florida | 12053 | 28373 | 876 |
1836457 | 1836457 | 2021-10-21 | Highlands | Florida | 12055 | 15811 | 537 |
1836458 | 1836458 | 2021-10-21 | Hillsborough | Florida | 12057 | 239223 | 2906 |
1836459 | 1836459 | 2021-10-21 | Holmes | Florida | 12059 | 3822 | 70 |
1836460 | 1836460 | 2021-10-21 | Indian River | Florida | 12061 | 22036 | 538 |
1836461 | 1836461 | 2021-10-21 | Jackson | Florida | 12063 | 10035 | 211 |
1836462 | 1836462 | 2021-10-21 | Jefferson | Florida | 12065 | 2444 | 36 |
1836463 | 1836463 | 2021-10-21 | Lafayette | Florida | 12067 | 2186 | 32 |
1836464 | 1836464 | 2021-10-21 | Lake | Florida | 12069 | 53868 | 1181 |
1836465 | 1836465 | 2021-10-21 | Lee | Florida | 12071 | 123984 | 1748 |
1836466 | 1836466 | 2021-10-21 | Leon | Florida | 12073 | 50205 | 494 |
1836467 | 1836467 | 2021-10-21 | Levy | Florida | 12075 | 6921 | 81 |
1836468 | 1836468 | 2021-10-21 | Liberty | Florida | 12077 | 1815 | 19 |
1836469 | 1836469 | 2021-10-21 | Madison | Florida | 12079 | 3572 | 54 |
1836470 | 1836470 | 2021-10-21 | Manatee | Florida | 12081 | 64348 | 930 |
1836471 | 1836471 | 2021-10-21 | Marion | Florida | 12083 | 56318 | 1709 |
1836472 | 1836472 | 2021-10-21 | Martin | Florida | 12085 | 19952 | 500 |
1836473 | 1836473 | 2021-10-21 | Miami-Dade | Florida | 12086 | 667933 | 8768 |
1836474 | 1836474 | 2021-10-21 | Monroe | Florida | 12087 | 10381 | 91 |
1836475 | 1836475 | 2021-10-21 | Nassau | Florida | 12089 | 14931 | 238 |
1836476 | 1836476 | 2021-10-21 | Okaloosa | Florida | 12091 | 34174 | 542 |
1836477 | 1836477 | 2021-10-21 | Okeechobee | Florida | 12093 | 7370 | 126 |
1836478 | 1836478 | 2021-10-21 | Orange | Florida | 12095 | 226228 | 2124 |
1836479 | 1836479 | 2021-10-21 | Osceola | Florida | 12097 | 70989 | 855 |
1836480 | 1836480 | 2021-10-21 | Palm Beach | Florida | 12099 | 223197 | 4060 |
1836481 | 1836481 | 2021-10-21 | Pasco | Florida | 12101 | 78642 | 1511 |
1836482 | 1836482 | 2021-10-21 | Pinellas | Florida | 12103 | 133436 | 2625 |
1836483 | 1836483 | 2021-10-21 | Polk | Florida | 12105 | 127470 | 2381 |
1836484 | 1836484 | 2021-10-21 | Putnam | Florida | 12107 | 12708 | 317 |
1836485 | 1836485 | 2021-10-21 | Santa Rosa | Florida | 12113 | 32164 | 512 |
1836486 | 1836486 | 2021-10-21 | Sarasota | Florida | 12115 | 54899 | 1277 |
1836487 | 1836487 | 2021-10-21 | Seminole | Florida | 12117 | 61582 | 833 |
1836488 | 1836488 | 2021-10-21 | St. Johns | Florida | 12109 | 40360 | 455 |
1836489 | 1836489 | 2021-10-21 | St. Lucie | Florida | 12111 | 47433 | 990 |
1836490 | 1836490 | 2021-10-21 | Sumter | Florida | 12119 | 14369 | 451 |
1836491 | 1836491 | 2021-10-21 | Suwannee | Florida | 12121 | 9152 | 163 |
1836492 | 1836492 | 2021-10-21 | Taylor | Florida | 12123 | 4572 | 77 |
1836493 | 1836493 | 2021-10-21 | Union | Florida | 12125 | 3056 | 96 |
1836494 | 1836494 | 2021-10-21 | Unknown | Florida | 12536 | 734 |
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);