ny_times_us_counties

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

7,190 rows where state = "Florida" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

county

state

  • Florida · 7,190
Link rowid date ▲ county state fips cases deaths
292077 2020-07-03 Alachua Florida 12001 1423 12
292078 2020-07-03 Baker Florida 12003 84 4
292079 2020-07-03 Bay Florida 12005 625 5
292080 2020-07-03 Bradford Florida 12007 92 2
292081 2020-07-03 Brevard Florida 12009 2366 18
292082 2020-07-03 Broward Florida 12011 18229 406
292083 2020-07-03 Calhoun Florida 12013 97 6
292084 2020-07-03 Charlotte Florida 12015 860 76
292085 2020-07-03 Citrus Florida 12017 364 13
292086 2020-07-03 Clay Florida 12019 871 34
292087 2020-07-03 Collier Florida 12021 4701 85
292088 2020-07-03 Columbia Florida 12023 331 3
292089 2020-07-03 DeSoto Florida 12027 676 10
292090 2020-07-03 Dixie Florida 12029 72 4
292091 2020-07-03 Duval Florida 12031 7961 68
292092 2020-07-03 Escambia Florida 12033 2397 46
292093 2020-07-03 Flagler Florida 12035 359 5
292094 2020-07-03 Franklin Florida 12037 11 0
292095 2020-07-03 Gadsden Florida 12039 427 7
292096 2020-07-03 Gilchrist Florida 12041 109 0
292097 2020-07-03 Glades Florida 12043 172 1
292098 2020-07-03 Gulf Florida 12045 34 0
292099 2020-07-03 Hamilton Florida 12047 380 2
292100 2020-07-03 Hardee Florida 12049 496 3
292101 2020-07-03 Hendry Florida 12051 1021 27
292102 2020-07-03 Hernando Florida 12053 472 5
292103 2020-07-03 Highlands Florida 12055 390 11
292104 2020-07-03 Hillsborough Florida 12057 13044 148
292105 2020-07-03 Holmes Florida 12059 196 0
292106 2020-07-03 Indian River Florida 12061 820 16
292107 2020-07-03 Jackson Florida 12063 394 2
292108 2020-07-03 Jefferson Florida 12065 57 4
292109 2020-07-03 Lafayette Florida 12067 34 0
292110 2020-07-03 Lake Florida 12069 1603 23
292111 2020-07-03 Lee Florida 12071 6667 162
292112 2020-07-03 Leon Florida 12073 1465 8
292113 2020-07-03 Levy Florida 12075 192 1
292114 2020-07-03 Liberty Florida 12077 238 1
292115 2020-07-03 Madison Florida 12079 220 3
292116 2020-07-03 Manatee Florida 12081 3261 131
292117 2020-07-03 Marion Florida 12083 817 12
292118 2020-07-03 Martin Florida 12085 2208 28
292119 2020-07-03 Miami-Dade Florida 12086 42310 1034
292120 2020-07-03 Monroe Florida 12087 322 5
292121 2020-07-03 Nassau Florida 12089 253 1
292122 2020-07-03 Okaloosa Florida 12091 819 8
292123 2020-07-03 Okeechobee Florida 12093 402 0
292124 2020-07-03 Orange Florida 12095 12077 58
292125 2020-07-03 Osceola Florida 12097 2526 25
292126 2020-07-03 Palm Beach Florida 12099 15322 536
292127 2020-07-03 Pasco Florida 12101 2443 23
292128 2020-07-03 Pinellas Florida 12103 7697 183
292129 2020-07-03 Polk Florida 12105 4660 105
292130 2020-07-03 Putnam Florida 12107 489 6
292131 2020-07-03 Santa Rosa Florida 12113 743 9
292132 2020-07-03 Sarasota Florida 12115 1814 98
292133 2020-07-03 Seminole Florida 12117 2987 20
292134 2020-07-03 St. Johns Florida 12109 1188 8
292135 2020-07-03 St. Lucie Florida 12111 1983 50
292136 2020-07-03 Sumter Florida 12119 401 17
292137 2020-07-03 Suwannee Florida 12121 581 21
292138 2020-07-03 Taylor Florida 12123 91 1
292139 2020-07-03 Union Florida 12125 74 2
292140 2020-07-03 Unknown Florida   187 0
292141 2020-07-03 Volusia Florida 12127 2496 58
292142 2020-07-03 Wakulla Florida 12129 72 1
292143 2020-07-03 Walton Florida 12131 295 9
292144 2020-07-03 Washington Florida 12133 118 13
289000 2020-07-02 Alachua Florida 12001 1332 12
289001 2020-07-02 Baker Florida 12003 80 4
289002 2020-07-02 Bay Florida 12005 581 5
289003 2020-07-02 Bradford Florida 12007 89 2
289004 2020-07-02 Brevard Florida 12009 2180 17
289005 2020-07-02 Broward Florida 12011 17116 394
289006 2020-07-02 Calhoun Florida 12013 85 6
289007 2020-07-02 Charlotte Florida 12015 836 76
289008 2020-07-02 Citrus Florida 12017 345 13
289009 2020-07-02 Clay Florida 12019 801 34
289010 2020-07-02 Collier Florida 12021 4539 82
289011 2020-07-02 Columbia Florida 12023 316 3
289012 2020-07-02 DeSoto Florida 12027 661 10
289013 2020-07-02 Dixie Florida 12029 69 4
289014 2020-07-02 Duval Florida 12031 7247 68
289015 2020-07-02 Escambia Florida 12033 2240 45
289016 2020-07-02 Flagler Florida 12035 340 5
289017 2020-07-02 Franklin Florida 12037 9 0
289018 2020-07-02 Gadsden Florida 12039 405 7
289019 2020-07-02 Gilchrist Florida 12041 106 0
289020 2020-07-02 Glades Florida 12043 167 1
289021 2020-07-02 Gulf Florida 12045 32 0
289022 2020-07-02 Hamilton Florida 12047 376 2
289023 2020-07-02 Hardee Florida 12049 468 3
289024 2020-07-02 Hendry Florida 12051 993 25
289025 2020-07-02 Hernando Florida 12053 451 5
289026 2020-07-02 Highlands Florida 12055 372 11
289027 2020-07-02 Hillsborough Florida 12057 12376 145
289028 2020-07-02 Holmes Florida 12059 191 0
289029 2020-07-02 Indian River Florida 12061 772 16
289030 2020-07-02 Jackson Florida 12063 381 2
289031 2020-07-02 Jefferson Florida 12065 57 4

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
Powered by Datasette · Query took 969.496ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette