ny_times_us_counties

Table actions
⚠️ 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

20,994 rows where state = "Florida" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

fips

county

state

  • Florida · 20,994 ✖
Link rowid date ▲ county state fips cases deaths
953294 953294 2021-01-22 Alachua Florida 12001 19408 158
953295 953295 2021-01-22 Baker Florida 12003 2903 44
953296 953296 2021-01-22 Bay Florida 12005 15044 261
953297 953297 2021-01-22 Bradford Florida 12007 2565 32
953298 953298 2021-01-22 Brevard Florida 12009 27245 603
953299 953299 2021-01-22 Broward Florida 12011 163896 2011
953300 953300 2021-01-22 Calhoun Florida 12013 1482 36
953301 953301 2021-01-22 Charlotte Florida 12015 9257 271
953302 953302 2021-01-22 Citrus Florida 12017 8192 323
953303 953303 2021-01-22 Clay Florida 12019 14574 226
953304 953304 2021-01-22 Collier Florida 12021 26573 386
953305 953305 2021-01-22 Columbia Florida 12023 6988 136
953306 953306 2021-01-22 DeSoto Florida 12027 3273 68
953307 953307 2021-01-22 Dixie Florida 12029 1340 12
953308 953308 2021-01-22 Duval Florida 12031 77741 864
953309 953309 2021-01-22 Escambia Florida 12033 28757 484
953310 953310 2021-01-22 Flagler Florida 12035 4905 61
953311 953311 2021-01-22 Franklin Florida 12037 1164 9
953312 953312 2021-01-22 Gadsden Florida 12039 4916 66
953313 953313 2021-01-22 Gilchrist Florida 12041 1151 28
953314 953314 2021-01-22 Glades Florida 12043 850 12
953315 953315 2021-01-22 Gulf Florida 12045 1602 31
953316 953316 2021-01-22 Hamilton Florida 12047 1460 15
953317 953317 2021-01-22 Hardee Florida 12049 2472 22
953318 953318 2021-01-22 Hendry Florida 12051 3892 55
953319 953319 2021-01-22 Hernando Florida 12053 9353 328
953320 953320 2021-01-22 Highlands Florida 12055 6086 242
953321 953321 2021-01-22 Hillsborough Florida 12057 95477 1220
953322 953322 2021-01-22 Holmes Florida 12059 2004 33
953323 953323 2021-01-22 Indian River Florida 12061 9187 208
953324 953324 2021-01-22 Jackson Florida 12063 5470 128
953325 953325 2021-01-22 Jefferson Florida 12065 1233 18
953326 953326 2021-01-22 Lafayette Florida 12067 1509 23
953327 953327 2021-01-22 Lake Florida 12069 20296 392
953328 953328 2021-01-22 Lee Florida 12071 49889 750
953329 953329 2021-01-22 Leon Florida 12073 24737 207
953330 953330 2021-01-22 Levy Florida 12075 2397 22
953331 953331 2021-01-22 Liberty Florida 12077 958 14
953332 953332 2021-01-22 Madison Florida 12079 1756 36
953333 953333 2021-01-22 Manatee Florida 12081 26990 484
953334 953334 2021-01-22 Marion Florida 12083 23050 560
953335 953335 2021-01-22 Martin Florida 12085 9246 238
953336 953336 2021-01-22 Miami-Dade Florida 12086 354703 4678
953337 953337 2021-01-22 Monroe Florida 12087 5105 39
953338 953338 2021-01-22 Nassau Florida 12089 6552 79
953339 953339 2021-01-22 Okaloosa Florida 12091 15728 270
953340 953340 2021-01-22 Okeechobee Florida 12093 3091 56
953341 953341 2021-01-22 Orange Florida 12095 96847 892
953342 953342 2021-01-22 Osceola Florida 12097 31734 333
953343 953343 2021-01-22 Palm Beach Florida 12099 101017 2083
953344 953344 2021-01-22 Pasco Florida 12101 27865 482
953345 953345 2021-01-22 Pinellas Florida 12103 56247 1209
953346 953346 2021-01-22 Polk Florida 12105 47254 920
953347 953347 2021-01-22 Putnam Florida 12107 5201 92
953348 953348 2021-01-22 Santa Rosa Florida 12113 14421 199
953349 953349 2021-01-22 Sarasota Florida 12115 23603 604
953350 953350 2021-01-22 Seminole Florida 12117 22757 353
953351 953351 2021-01-22 St. Johns Florida 12109 17242 146
953352 953352 2021-01-22 St. Lucie Florida 12111 18366 465
953353 953353 2021-01-22 Sumter Florida 12119 6646 170
953354 953354 2021-01-22 Suwannee Florida 12121 4698 101
953355 953355 2021-01-22 Taylor Florida 12123 2352 32
953356 953356 2021-01-22 Union Florida 12125 1622 70
953357 953357 2021-01-22 Unknown Florida   3291 0
953358 953358 2021-01-22 Volusia Florida 12127 28850 492
953359 953359 2021-01-22 Wakulla Florida 12129 2779 36
953360 953360 2021-01-22 Walton Florida 12131 6010 62
953361 953361 2021-01-22 Washington Florida 12133 2326 30
950049 950049 2021-01-21 Alachua Florida 12001 19274 158
950050 950050 2021-01-21 Baker Florida 12003 2888 41
950051 950051 2021-01-21 Bay Florida 12005 14952 258
950052 950052 2021-01-21 Bradford Florida 12007 2554 31
950053 950053 2021-01-21 Brevard Florida 12009 26975 595
950054 950054 2021-01-21 Broward Florida 12011 162720 2004
950055 950055 2021-01-21 Calhoun Florida 12013 1471 33
950056 950056 2021-01-21 Charlotte Florida 12015 9195 271
950057 950057 2021-01-21 Citrus Florida 12017 8109 323
950058 950058 2021-01-21 Clay Florida 12019 14393 226
950059 950059 2021-01-21 Collier Florida 12021 26361 386
950060 950060 2021-01-21 Columbia Florida 12023 6948 135
950061 950061 2021-01-21 DeSoto Florida 12027 3254 68
950062 950062 2021-01-21 Dixie Florida 12029 1332 12
950063 950063 2021-01-21 Duval Florida 12031 76707 863
950064 950064 2021-01-21 Escambia Florida 12033 28431 472
950065 950065 2021-01-21 Flagler Florida 12035 4847 60
950066 950066 2021-01-21 Franklin Florida 12037 1153 6
950067 950067 2021-01-21 Gadsden Florida 12039 4872 65
950068 950068 2021-01-21 Gilchrist Florida 12041 1146 28
950069 950069 2021-01-21 Glades Florida 12043 848 12
950070 950070 2021-01-21 Gulf Florida 12045 1588 31
950071 950071 2021-01-21 Hamilton Florida 12047 1452 15
950072 950072 2021-01-21 Hardee Florida 12049 2456 22
950073 950073 2021-01-21 Hendry Florida 12051 3870 55
950074 950074 2021-01-21 Hernando Florida 12053 9230 327
950075 950075 2021-01-21 Highlands Florida 12055 6032 237
950076 950076 2021-01-21 Hillsborough Florida 12057 94870 1215
950077 950077 2021-01-21 Holmes Florida 12059 1998 33
950078 950078 2021-01-21 Indian River Florida 12061 9101 200
950079 950079 2021-01-21 Jackson Florida 12063 5437 128
950080 950080 2021-01-21 Jefferson Florida 12065 1220 18

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
);
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]);