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 199
- 12081 199
- 12113 195
- 12011 194
- 12071 194
- 12015 193
- 12091 193
- 12127 193
- 12001 190
- 12021 190
- 12089 190
- 12101 190
- 12103 190
- 12086 189
- 12109 189
- 12019 188
- 12031 188
- 12099 188
- 12115 188
- 12117 188
- 12095 187
- 12097 187
- 12003 185
- 12017 185
- 12033 184
- 12069 184
- 12009 183
- 12105 183
- 12073 182
- 12119 182
- …
county >30
- Hillsborough 199
- Manatee 199
- Santa Rosa 195
- Broward 194
- Lee 194
- Charlotte 193
- Okaloosa 193
- Volusia 193
- Alachua 190
- Collier 190
- Nassau 190
- Pasco 190
- Pinellas 190
- Miami-Dade 189
- St. Johns 189
- Clay 188
- Duval 188
- Palm Beach 188
- Sarasota 188
- Seminole 188
- Orange 187
- Osceola 187
- Baker 185
- Citrus 185
- Escambia 184
- Lake 184
- Brevard 183
- Polk 183
- Leon 182
- Sumter 182
- …
state 1
- Florida · 12,222 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534744 | 534744 | 2020-09-15 | Alachua | Florida | 12001 | 6657 | 42 |
534745 | 534745 | 2020-09-15 | Baker | Florida | 12003 | 1341 | 8 |
534746 | 534746 | 2020-09-15 | Bay | Florida | 12005 | 5719 | 93 |
534747 | 534747 | 2020-09-15 | Bradford | Florida | 12007 | 945 | 6 |
534748 | 534748 | 2020-09-15 | Brevard | Florida | 12009 | 8050 | 263 |
534749 | 534749 | 2020-09-15 | Broward | Florida | 12011 | 74689 | 1288 |
534750 | 534750 | 2020-09-15 | Calhoun | Florida | 12013 | 602 | 9 |
534751 | 534751 | 2020-09-15 | Charlotte | Florida | 12015 | 2881 | 125 |
534752 | 534752 | 2020-09-15 | Citrus | Florida | 12017 | 2493 | 75 |
534753 | 534753 | 2020-09-15 | Clay | Florida | 12019 | 4607 | 88 |
534754 | 534754 | 2020-09-15 | Collier | Florida | 12021 | 12254 | 193 |
534755 | 534755 | 2020-09-15 | Columbia | Florida | 12023 | 3559 | 45 |
534756 | 534756 | 2020-09-15 | DeSoto | Florida | 12027 | 1539 | 23 |
534757 | 534757 | 2020-09-15 | Dixie | Florida | 12029 | 799 | 5 |
534758 | 534758 | 2020-09-15 | Duval | Florida | 12031 | 28632 | 326 |
534759 | 534759 | 2020-09-15 | Escambia | Florida | 12033 | 11944 | 210 |
534760 | 534760 | 2020-09-15 | Flagler | Florida | 12035 | 1589 | 19 |
534761 | 534761 | 2020-09-15 | Franklin | Florida | 12037 | 582 | 3 |
534762 | 534762 | 2020-09-15 | Gadsden | Florida | 12039 | 2625 | 44 |
534763 | 534763 | 2020-09-15 | Gilchrist | Florida | 12041 | 490 | 12 |
534764 | 534764 | 2020-09-15 | Glades | Florida | 12043 | 476 | 4 |
534765 | 534765 | 2020-09-15 | Gulf | Florida | 12045 | 862 | 13 |
534766 | 534766 | 2020-09-15 | Hamilton | Florida | 12047 | 785 | 8 |
534767 | 534767 | 2020-09-15 | Hardee | Florida | 12049 | 1242 | 9 |
534768 | 534768 | 2020-09-15 | Hendry | Florida | 12051 | 2026 | 42 |
534769 | 534769 | 2020-09-15 | Hernando | Florida | 12053 | 2901 | 107 |
534770 | 534770 | 2020-09-15 | Highlands | Florida | 12055 | 2018 | 79 |
534771 | 534771 | 2020-09-15 | Hillsborough | Florida | 12057 | 39751 | 591 |
534772 | 534772 | 2020-09-15 | Holmes | Florida | 12059 | 711 | 5 |
534773 | 534773 | 2020-09-15 | Indian River | Florida | 12061 | 3000 | 107 |
534774 | 534774 | 2020-09-15 | Jackson | Florida | 12063 | 2632 | 73 |
534775 | 534775 | 2020-09-15 | Jefferson | Florida | 12065 | 534 | 8 |
534776 | 534776 | 2020-09-15 | Lafayette | Florida | 12067 | 1222 | 10 |
534777 | 534777 | 2020-09-15 | Lake | Florida | 12069 | 7092 | 156 |
534778 | 534778 | 2020-09-15 | Lee | Florida | 12071 | 19565 | 451 |
534779 | 534779 | 2020-09-15 | Leon | Florida | 12073 | 9270 | 46 |
534780 | 534780 | 2020-09-15 | Levy | Florida | 12075 | 971 | 8 |
534781 | 534781 | 2020-09-15 | Liberty | Florida | 12077 | 481 | 7 |
534782 | 534782 | 2020-09-15 | Madison | Florida | 12079 | 989 | 16 |
534783 | 534783 | 2020-09-15 | Manatee | Florida | 12081 | 10972 | 274 |
534784 | 534784 | 2020-09-15 | Marion | Florida | 12083 | 9217 | 253 |
534785 | 534785 | 2020-09-15 | Martin | Florida | 12085 | 4607 | 129 |
534786 | 534786 | 2020-09-15 | Miami-Dade | Florida | 12086 | 164687 | 2923 |
534787 | 534787 | 2020-09-15 | Monroe | Florida | 12087 | 1787 | 20 |
534788 | 534788 | 2020-09-15 | Nassau | Florida | 12089 | 1960 | 31 |
534789 | 534789 | 2020-09-15 | Okaloosa | Florida | 12091 | 4675 | 94 |
534790 | 534790 | 2020-09-15 | Okeechobee | Florida | 12093 | 1341 | 21 |
534791 | 534791 | 2020-09-15 | Orange | Florida | 12095 | 38146 | 411 |
534792 | 534792 | 2020-09-15 | Osceola | Florida | 12097 | 11846 | 137 |
534793 | 534793 | 2020-09-15 | Palm Beach | Florida | 12099 | 44303 | 1216 |
534794 | 534794 | 2020-09-15 | Pasco | Florida | 12101 | 8600 | 195 |
534795 | 534795 | 2020-09-15 | Pinellas | Florida | 12103 | 21081 | 710 |
534796 | 534796 | 2020-09-15 | Polk | Florida | 12105 | 18612 | 494 |
534797 | 534797 | 2020-09-15 | Putnam | Florida | 12107 | 1980 | 38 |
534798 | 534798 | 2020-09-15 | Santa Rosa | Florida | 12113 | 5157 | 69 |
534799 | 534799 | 2020-09-15 | Sarasota | Florida | 12115 | 7671 | 239 |
534800 | 534800 | 2020-09-15 | Seminole | Florida | 12117 | 8613 | 193 |
534801 | 534801 | 2020-09-15 | St. Johns | Florida | 12109 | 4928 | 63 |
534802 | 534802 | 2020-09-15 | St. Lucie | Florida | 12111 | 7633 | 256 |
534803 | 534803 | 2020-09-15 | Sumter | Florida | 12119 | 2121 | 61 |
534804 | 534804 | 2020-09-15 | Suwannee | Florida | 12121 | 2552 | 65 |
534805 | 534805 | 2020-09-15 | Taylor | Florida | 12123 | 1261 | 11 |
534806 | 534806 | 2020-09-15 | Union | Florida | 12125 | 820 | 8 |
534807 | 534807 | 2020-09-15 | Unknown | Florida | 1556 | 0 | |
534808 | 534808 | 2020-09-15 | Volusia | Florida | 12127 | 10262 | 209 |
534809 | 534809 | 2020-09-15 | Wakulla | Florida | 12129 | 1037 | 9 |
534810 | 534810 | 2020-09-15 | Walton | Florida | 12131 | 1840 | 22 |
534811 | 534811 | 2020-09-15 | Washington | Florida | 12133 | 1048 | 18 |
531509 | 531509 | 2020-09-14 | Alachua | Florida | 12001 | 6555 | 40 |
531510 | 531510 | 2020-09-14 | Baker | Florida | 12003 | 1330 | 7 |
531511 | 531511 | 2020-09-14 | Bay | Florida | 12005 | 5693 | 91 |
531512 | 531512 | 2020-09-14 | Bradford | Florida | 12007 | 937 | 6 |
531513 | 531513 | 2020-09-14 | Brevard | Florida | 12009 | 7995 | 256 |
531514 | 531514 | 2020-09-14 | Broward | Florida | 12011 | 74525 | 1284 |
531515 | 531515 | 2020-09-14 | Calhoun | Florida | 12013 | 599 | 9 |
531516 | 531516 | 2020-09-14 | Charlotte | Florida | 12015 | 2877 | 122 |
531517 | 531517 | 2020-09-14 | Citrus | Florida | 12017 | 2477 | 73 |
531518 | 531518 | 2020-09-14 | Clay | Florida | 12019 | 4593 | 86 |
531519 | 531519 | 2020-09-14 | Collier | Florida | 12021 | 12234 | 192 |
531520 | 531520 | 2020-09-14 | Columbia | Florida | 12023 | 3540 | 44 |
531521 | 531521 | 2020-09-14 | DeSoto | Florida | 12027 | 1536 | 23 |
531522 | 531522 | 2020-09-14 | Dixie | Florida | 12029 | 792 | 5 |
531523 | 531523 | 2020-09-14 | Duval | Florida | 12031 | 28525 | 322 |
531524 | 531524 | 2020-09-14 | Escambia | Florida | 12033 | 11891 | 204 |
531525 | 531525 | 2020-09-14 | Flagler | Florida | 12035 | 1571 | 19 |
531526 | 531526 | 2020-09-14 | Franklin | Florida | 12037 | 581 | 3 |
531527 | 531527 | 2020-09-14 | Gadsden | Florida | 12039 | 2604 | 44 |
531528 | 531528 | 2020-09-14 | Gilchrist | Florida | 12041 | 486 | 12 |
531529 | 531529 | 2020-09-14 | Glades | Florida | 12043 | 475 | 4 |
531530 | 531530 | 2020-09-14 | Gulf | Florida | 12045 | 861 | 13 |
531531 | 531531 | 2020-09-14 | Hamilton | Florida | 12047 | 763 | 7 |
531532 | 531532 | 2020-09-14 | Hardee | Florida | 12049 | 1235 | 9 |
531533 | 531533 | 2020-09-14 | Hendry | Florida | 12051 | 2023 | 41 |
531534 | 531534 | 2020-09-14 | Hernando | Florida | 12053 | 2894 | 105 |
531535 | 531535 | 2020-09-14 | Highlands | Florida | 12055 | 2005 | 78 |
531536 | 531536 | 2020-09-14 | Hillsborough | Florida | 12057 | 39600 | 585 |
531537 | 531537 | 2020-09-14 | Holmes | Florida | 12059 | 707 | 5 |
531538 | 531538 | 2020-09-14 | Indian River | Florida | 12061 | 2990 | 106 |
531539 | 531539 | 2020-09-14 | Jackson | Florida | 12063 | 2618 | 73 |
531540 | 531540 | 2020-09-14 | Jefferson | Florida | 12065 | 534 | 8 |
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);