ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23,374 rows where state = "Florida" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips
- 12057 363
- 12081 363
- 12113 359
- 12011 358
- 12071 358
- 12015 357
- 12091 357
- 12127 357
- 12001 354
- 12021 354
- 12089 354
- 12101 354
- 12103 354
- 12086 353
- 12109 353
- 12019 352
- 12031 352
- 12099 352
- 12115 352
- 12117 352
- 12095 351
- 12097 351
- 12003 349
- 12017 349
- 12033 348
- 12069 348
- 12009 347
- 12105 347
- 12073 346
- 12119 346
- ...
county
- Hillsborough 363
- Manatee 363
- Santa Rosa 359
- Broward 358
- Lee 358
- Charlotte 357
- Okaloosa 357
- Volusia 357
- Alachua 354
- Collier 354
- Nassau 354
- Pasco 354
- Pinellas 354
- Miami-Dade 353
- St. Johns 353
- Clay 352
- Duval 352
- Palm Beach 352
- Sarasota 352
- Seminole 352
- Orange 351
- Osceola 351
- Baker 349
- Citrus 349
- Escambia 348
- Lake 348
- Brevard 347
- Polk 347
- Leon 346
- Sumter 346
- ...
state
- Florida · 23,374 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1066810 | 1066810 | 2021-02-26 | Alachua | Florida | 12001 | 22293 | 228 |
1066811 | 1066811 | 2021-02-26 | Baker | Florida | 12003 | 3292 | 55 |
1066812 | 1066812 | 2021-02-26 | Bay | Florida | 12005 | 18606 | 339 |
1066813 | 1066813 | 2021-02-26 | Bradford | Florida | 12007 | 2845 | 52 |
1066814 | 1066814 | 2021-02-26 | Brevard | Florida | 12009 | 33739 | 738 |
1066815 | 1066815 | 2021-02-26 | Broward | Florida | 12011 | 193560 | 2369 |
1066816 | 1066816 | 2021-02-26 | Calhoun | Florida | 12013 | 1607 | 40 |
1066817 | 1066817 | 2021-02-26 | Charlotte | Florida | 12015 | 10642 | 359 |
1066818 | 1066818 | 2021-02-26 | Citrus | Florida | 12017 | 9716 | 397 |
1066819 | 1066819 | 2021-02-26 | Clay | Florida | 12019 | 16673 | 304 |
1066820 | 1066820 | 2021-02-26 | Collier | Florida | 12021 | 30144 | 459 |
1066821 | 1066821 | 2021-02-26 | Columbia | Florida | 12023 | 7655 | 155 |
1066822 | 1066822 | 2021-02-26 | DeSoto | Florida | 12027 | 3769 | 73 |
1066823 | 1066823 | 2021-02-26 | Dixie | Florida | 12029 | 1484 | 19 |
1066824 | 1066824 | 2021-02-26 | Duval | Florida | 12031 | 88430 | 1139 |
1066825 | 1066825 | 2021-02-26 | Escambia | Florida | 12033 | 33556 | 628 |
1066826 | 1066826 | 2021-02-26 | Flagler | Florida | 12035 | 5898 | 89 |
1066827 | 1066827 | 2021-02-26 | Franklin | Florida | 12037 | 1278 | 14 |
1066828 | 1066828 | 2021-02-26 | Gadsden | Florida | 12039 | 5418 | 83 |
1066829 | 1066829 | 2021-02-26 | Gilchrist | Florida | 12041 | 1397 | 33 |
1066830 | 1066830 | 2021-02-26 | Glades | Florida | 12043 | 902 | 15 |
1066831 | 1066831 | 2021-02-26 | Gulf | Florida | 12045 | 1860 | 39 |
1066832 | 1066832 | 2021-02-26 | Hamilton | Florida | 12047 | 1566 | 21 |
1066833 | 1066833 | 2021-02-26 | Hardee | Florida | 12049 | 2783 | 29 |
1066834 | 1066834 | 2021-02-26 | Hendry | Florida | 12051 | 4289 | 72 |
1066835 | 1066835 | 2021-02-26 | Hernando | Florida | 12053 | 11212 | 398 |
1066836 | 1066836 | 2021-02-26 | Highlands | Florida | 12055 | 7206 | 299 |
1066837 | 1066837 | 2021-02-26 | Hillsborough | Florida | 12057 | 110837 | 1484 |
1066838 | 1066838 | 2021-02-26 | Holmes | Florida | 12059 | 2175 | 44 |
1066839 | 1066839 | 2021-02-26 | Indian River | Florida | 12061 | 10967 | 261 |
1066840 | 1066840 | 2021-02-26 | Jackson | Florida | 12063 | 5901 | 150 |
1066841 | 1066841 | 2021-02-26 | Jefferson | Florida | 12065 | 1402 | 24 |
1066842 | 1066842 | 2021-02-26 | Lafayette | Florida | 12067 | 1586 | 24 |
1066843 | 1066843 | 2021-02-26 | Lake | Florida | 12069 | 24445 | 554 |
1066844 | 1066844 | 2021-02-26 | Lee | Florida | 12071 | 57468 | 872 |
1066845 | 1066845 | 2021-02-26 | Leon | Florida | 12073 | 29052 | 283 |
1066846 | 1066846 | 2021-02-26 | Levy | Florida | 12075 | 2863 | 35 |
1066847 | 1066847 | 2021-02-26 | Liberty | Florida | 12077 | 1040 | 15 |
1066848 | 1066848 | 2021-02-26 | Madison | Florida | 12079 | 1986 | 42 |
1066849 | 1066849 | 2021-02-26 | Manatee | Florida | 12081 | 31685 | 586 |
1066850 | 1066850 | 2021-02-26 | Marion | Florida | 12083 | 27485 | 782 |
1066851 | 1066851 | 2021-02-26 | Martin | Florida | 12085 | 10536 | 276 |
1066852 | 1066852 | 2021-02-26 | Miami-Dade | Florida | 12086 | 408095 | 5396 |
1066853 | 1066853 | 2021-02-26 | Monroe | Florida | 12087 | 5799 | 46 |
1066854 | 1066854 | 2021-02-26 | Nassau | Florida | 12089 | 7701 | 112 |
1066855 | 1066855 | 2021-02-26 | Okaloosa | Florida | 12091 | 18724 | 327 |
1066856 | 1066856 | 2021-02-26 | Okeechobee | Florida | 12093 | 3548 | 75 |
1066857 | 1066857 | 2021-02-26 | Orange | Florida | 12095 | 113647 | 1090 |
1066858 | 1066858 | 2021-02-26 | Osceola | Florida | 12097 | 36607 | 441 |
1066859 | 1066859 | 2021-02-26 | Palm Beach | Florida | 12099 | 119909 | 2454 |
1066860 | 1066860 | 2021-02-26 | Pasco | Florida | 12101 | 33139 | 646 |
1066861 | 1066861 | 2021-02-26 | Pinellas | Florida | 12103 | 66205 | 1438 |
1066862 | 1066862 | 2021-02-26 | Polk | Florida | 12105 | 56759 | 1137 |
1066863 | 1066863 | 2021-02-26 | Putnam | Florida | 12107 | 5828 | 126 |
1066864 | 1066864 | 2021-02-26 | Santa Rosa | Florida | 12113 | 17020 | 257 |
1066865 | 1066865 | 2021-02-26 | Sarasota | Florida | 12115 | 26882 | 730 |
1066866 | 1066866 | 2021-02-26 | Seminole | Florida | 12117 | 27057 | 422 |
1066867 | 1066867 | 2021-02-26 | St. Johns | Florida | 12109 | 20007 | 191 |
1066868 | 1066868 | 2021-02-26 | St. Lucie | Florida | 12111 | 22015 | 544 |
1066869 | 1066869 | 2021-02-26 | Sumter | Florida | 12119 | 7965 | 238 |
1066870 | 1066870 | 2021-02-26 | Suwannee | Florida | 12121 | 5108 | 131 |
1066871 | 1066871 | 2021-02-26 | Taylor | Florida | 12123 | 2632 | 41 |
1066872 | 1066872 | 2021-02-26 | Union | Florida | 12125 | 1740 | 70 |
1066873 | 1066873 | 2021-02-26 | Unknown | Florida | 3454 | 0 | |
1066874 | 1066874 | 2021-02-26 | Volusia | Florida | 12127 | 34338 | 654 |
1066875 | 1066875 | 2021-02-26 | Wakulla | Florida | 12129 | 3153 | 51 |
1066876 | 1066876 | 2021-02-26 | Walton | Florida | 12131 | 7017 | 81 |
1066877 | 1066877 | 2021-02-26 | Washington | Florida | 12133 | 2618 | 47 |
1063565 | 1063565 | 2021-02-25 | Alachua | Florida | 12001 | 22272 | 228 |
1063566 | 1063566 | 2021-02-25 | Baker | Florida | 12003 | 3289 | 55 |
1063567 | 1063567 | 2021-02-25 | Bay | Florida | 12005 | 18530 | 339 |
1063568 | 1063568 | 2021-02-25 | Bradford | Florida | 12007 | 2843 | 52 |
1063569 | 1063569 | 2021-02-25 | Brevard | Florida | 12009 | 33578 | 736 |
1063570 | 1063570 | 2021-02-25 | Broward | Florida | 12011 | 192738 | 2365 |
1063571 | 1063571 | 2021-02-25 | Calhoun | Florida | 12013 | 1607 | 40 |
1063572 | 1063572 | 2021-02-25 | Charlotte | Florida | 12015 | 10622 | 359 |
1063573 | 1063573 | 2021-02-25 | Citrus | Florida | 12017 | 9687 | 395 |
1063574 | 1063574 | 2021-02-25 | Clay | Florida | 12019 | 16641 | 304 |
1063575 | 1063575 | 2021-02-25 | Collier | Florida | 12021 | 30037 | 452 |
1063576 | 1063576 | 2021-02-25 | Columbia | Florida | 12023 | 7649 | 155 |
1063577 | 1063577 | 2021-02-25 | DeSoto | Florida | 12027 | 3747 | 73 |
1063578 | 1063578 | 2021-02-25 | Dixie | Florida | 12029 | 1483 | 19 |
1063579 | 1063579 | 2021-02-25 | Duval | Florida | 12031 | 88258 | 1139 |
1063580 | 1063580 | 2021-02-25 | Escambia | Florida | 12033 | 33474 | 622 |
1063581 | 1063581 | 2021-02-25 | Flagler | Florida | 12035 | 5877 | 89 |
1063582 | 1063582 | 2021-02-25 | Franklin | Florida | 12037 | 1278 | 14 |
1063583 | 1063583 | 2021-02-25 | Gadsden | Florida | 12039 | 5405 | 83 |
1063584 | 1063584 | 2021-02-25 | Gilchrist | Florida | 12041 | 1394 | 33 |
1063585 | 1063585 | 2021-02-25 | Glades | Florida | 12043 | 900 | 15 |
1063586 | 1063586 | 2021-02-25 | Gulf | Florida | 12045 | 1860 | 37 |
1063587 | 1063587 | 2021-02-25 | Hamilton | Florida | 12047 | 1564 | 21 |
1063588 | 1063588 | 2021-02-25 | Hardee | Florida | 12049 | 2777 | 29 |
1063589 | 1063589 | 2021-02-25 | Hendry | Florida | 12051 | 4279 | 72 |
1063590 | 1063590 | 2021-02-25 | Hernando | Florida | 12053 | 11179 | 398 |
1063591 | 1063591 | 2021-02-25 | Highlands | Florida | 12055 | 7189 | 298 |
1063592 | 1063592 | 2021-02-25 | Hillsborough | Florida | 12057 | 110485 | 1484 |
1063593 | 1063593 | 2021-02-25 | Holmes | Florida | 12059 | 2170 | 44 |
1063594 | 1063594 | 2021-02-25 | Indian River | Florida | 12061 | 10925 | 260 |
1063595 | 1063595 | 2021-02-25 | Jackson | Florida | 12063 | 5891 | 147 |
1063596 | 1063596 | 2021-02-25 | Jefferson | Florida | 12065 | 1400 | 24 |
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]);