⚠️ 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 source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

23,616 rows where province_or_state = "Florida" sorted by day descending

View and edit SQL

province_or_state

  • Florida · 23,616

country_or_region

  • US 23,616
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
901352 2021-03-04 US Florida Alachua 12001 22512 235 0 22277 29.67866525 -82.35928158 2021-03-05 05:26:29 Alachua, Florida, US
901353 2021-03-04 US Florida Baker 12003 3312 56 0 3256 30.33060121 -82.28467476 2021-03-05 05:26:29 Baker, Florida, US
901354 2021-03-04 US Florida Bay 12005 18888 348 0 18540 30.26548745 -85.62122584 2021-03-05 05:26:29 Bay, Florida, US
901355 2021-03-04 US Florida Bradford 12007 2858 52 0 2806 29.95079741 -82.16611613 2021-03-05 05:26:29 Bradford, Florida, US
901356 2021-03-04 US Florida Brevard 12009 34434 751 0 33683 28.29409504 -80.73091022 2021-03-05 05:26:29 Brevard, Florida, US
901357 2021-03-04 US Florida Broward 12011 197542 2431 0 195111 26.15184651 -80.48725556 2021-03-05 05:26:29 Broward, Florida, US
901358 2021-03-04 US Florida Calhoun 12013 1621 46 0 1575 30.40666734 -85.19394153 2021-03-05 05:26:29 Calhoun, Florida, US
901359 2021-03-04 US Florida Charlotte 12015 10781 372 0 10409 26.90131002 -81.92949121 2021-03-05 05:26:29 Charlotte, Florida, US
901360 2021-03-04 US Florida Citrus 12017 9836 406 0 9430 28.84804315 -82.47614748 2021-03-05 05:26:29 Citrus, Florida, US
901361 2021-03-04 US Florida Clay 12019 16805 315 0 16490 29.98319144 -81.85609986 2021-03-05 05:26:29 Clay, Florida, US
901362 2021-03-04 US Florida Collier 12021 30572 462 0 30110 26.11091986 -81.34687065 2021-03-05 05:26:29 Collier, Florida, US
901363 2021-03-04 US Florida Columbia 12023 7706 160 0 7546 30.22509788 -82.62160164 2021-03-05 05:26:29 Columbia, Florida, US
901364 2021-03-04 US Florida DeSoto 12027 3841 75 0 3766 27.18677893 -81.80941373 2021-03-05 05:26:29 DeSoto, Florida, US
901365 2021-03-04 US Florida Dixie 12029 1504 21 0 1483 29.60631086 -83.15724673 2021-03-05 05:26:29 Dixie, Florida, US
901366 2021-03-04 US Florida Duval 12031 89337 1188 0 88149 30.33225875 -81.66976468 2021-03-05 05:26:29 Duval, Florida, US
901367 2021-03-04 US Florida Escambia 12033 33959 635 0 33324 30.67652764 -87.37284571 2021-03-05 05:26:29 Escambia, Florida, US
901368 2021-03-04 US Florida Flagler 12035 6063 92 0 5971 29.45933576 -81.31508595 2021-03-05 05:26:29 Flagler, Florida, US
901369 2021-03-04 US Florida Franklin 12037 1279 17 0 1262 29.83791238 -84.82731662 2021-03-05 05:26:29 Franklin, Florida, US
901370 2021-03-04 US Florida Gadsden 12039 5472 87 0 5385 30.57796289 -84.61915825 2021-03-05 05:26:29 Gadsden, Florida, US
901371 2021-03-04 US Florida Gilchrist 12041 1424 36 0 1388 29.72856978 -82.79880657 2021-03-05 05:26:29 Gilchrist, Florida, US
901372 2021-03-04 US Florida Glades 12043 905 15 0 890 26.95635849 -81.18996211 2021-03-05 05:26:29 Glades, Florida, US
901373 2021-03-04 US Florida Gulf 12045 1875 41 0 1834 29.93543004 -85.24270990000002 2021-03-05 05:26:29 Gulf, Florida, US
901374 2021-03-04 US Florida Hamilton 12047 1571 22 0 1549 30.49673973 -82.94998918 2021-03-05 05:26:29 Hamilton, Florida, US
901375 2021-03-04 US Florida Hardee 12049 2809 31 0 2778 27.49293939 -81.80956574 2021-03-05 05:26:29 Hardee, Florida, US
901376 2021-03-04 US Florida Hendry 12051 4338 73 0 4265 26.55386945 -81.16469006 2021-03-05 05:26:29 Hendry, Florida, US
901377 2021-03-04 US Florida Hernando 12053 11464 403 0 11061 28.55364461 -82.42700204 2021-03-05 05:26:29 Hernando, Florida, US
901378 2021-03-04 US Florida Highlands 12055 7307 308 0 6999 27.34254618 -81.34071957 2021-03-05 05:26:29 Highlands, Florida, US
901379 2021-03-04 US Florida Hillsborough 12057 112672 1523 0 111149 27.9276559 -82.32013172 2021-03-05 05:26:29 Hillsborough, Florida, US
901380 2021-03-04 US Florida Holmes 12059 2193 44 0 2149 30.86747479 -85.81319222 2021-03-05 05:26:29 Holmes, Florida, US
901381 2021-03-04 US Florida Indian River 12061 11138 267 0 10871 27.69308961 -80.60556721 2021-03-05 05:26:29 Indian River, Florida, US
901382 2021-03-04 US Florida Jackson 12063 5947 152 0 5795 30.7954597 -85.21500423 2021-03-05 05:26:29 Jackson, Florida, US
901383 2021-03-04 US Florida Jefferson 12065 1409 24 0 1385 30.43669112 -83.89442308 2021-03-05 05:26:29 Jefferson, Florida, US
901384 2021-03-04 US Florida Lafayette 12067 1594 24 0 1570 29.98484137 -83.18166636 2021-03-05 05:26:29 Lafayette, Florida, US
901385 2021-03-04 US Florida Lake 12069 24928 574 0 24354 28.76202069 -81.7125123 2021-03-05 05:26:29 Lake, Florida, US
901386 2021-03-04 US Florida Lee 12071 58360 883 0 57477 26.58410348 -81.88399313 2021-03-05 05:26:29 Lee, Florida, US
901387 2021-03-04 US Florida Leon 12073 29367 287 0 29080 30.45955727 -84.27491114 2021-03-05 05:26:29 Leon, Florida, US
901388 2021-03-04 US Florida Levy 12075 2905 39 0 2866 29.31829741 -82.74007147 2021-03-05 05:26:29 Levy, Florida, US
901389 2021-03-04 US Florida Liberty 12077 1045 16 0 1029 30.23766008 -84.8829258 2021-03-05 05:26:29 Liberty, Florida, US
901390 2021-03-04 US Florida Madison 12079 2008 43 0 1965 30.44396917 -83.47398594 2021-03-05 05:26:29 Madison, Florida, US
901391 2021-03-04 US Florida Manatee 12081 32309 608 0 31701 27.47196942 -82.31831044 2021-03-05 05:26:29 Manatee, Florida, US
901392 2021-03-04 US Florida Marion 12083 27879 827 0 27052 29.21227113 -82.05803627 2021-03-05 05:26:29 Marion, Florida, US
901393 2021-03-04 US Florida Martin 12085 10718 293 0 10425 27.0772071 -80.43109784 2021-03-05 05:26:29 Martin, Florida, US
901394 2021-03-04 US Florida Miami-Dade 12086 416021 5511 0 410510 25.6112362 -80.55170587 2021-03-05 05:26:29 Miami-Dade, Florida, US
901395 2021-03-04 US Florida Monroe 12087 5937 46 0 5891 25.20904673 -81.07812416 2021-03-05 05:26:29 Monroe, Florida, US
901396 2021-03-04 US Florida Nassau 12089 7768 112 0 7656 30.61037141 -81.80297522 2021-03-05 05:26:29 Nassau, Florida, US
901397 2021-03-04 US Florida Okaloosa 12091 19125 328 0 18797 30.69143028 -86.59267105 2021-03-05 05:26:29 Okaloosa, Florida, US
901398 2021-03-04 US Florida Okeechobee 12093 3583 81 0 3502 27.386336199999995 -80.88944347 2021-03-05 05:26:29 Okeechobee, Florida, US
901399 2021-03-04 US Florida Orange 12095 115475 1116 0 114359 28.51367621 -81.31799498 2021-03-05 05:26:29 Orange, Florida, US
901400 2021-03-04 US Florida Osceola 12097 37188 449 0 36739 28.06312234 -81.14882926 2021-03-05 05:26:29 Osceola, Florida, US
901401 2021-03-04 US Florida Palm Beach 12099 122226 2498 0 119728 26.64676272 -80.46536002 2021-03-05 05:26:29 Palm Beach, Florida, US
901402 2021-03-04 US Florida Pasco 12101 33778 664 0 33114 28.30810945 -82.40227529 2021-03-05 05:26:29 Pasco, Florida, US
901403 2021-03-04 US Florida Pinellas 12103 67359 1465 0 65894 27.93130349 -82.72239666 2021-03-05 05:26:29 Pinellas, Florida, US
901404 2021-03-04 US Florida Polk 12105 57655 1164 0 56491 27.95027105 -81.69732947 2021-03-05 05:26:29 Polk, Florida, US
901405 2021-03-04 US Florida Putnam 12107 5874 128 0 5746 29.60779729 -81.74230285 2021-03-05 05:26:29 Putnam, Florida, US
901406 2021-03-04 US Florida Santa Rosa 12113 17252 267 0 16985 30.693414500000006 -87.02458128 2021-03-05 05:26:29 Santa Rosa, Florida, US
901407 2021-03-04 US Florida Sarasota 12115 27301 749 0 26552 27.18546175 -82.33174248 2021-03-05 05:26:29 Sarasota, Florida, US
901408 2021-03-04 US Florida Seminole 12117 27554 437 0 27117 28.7158582 -81.24060348 2021-03-05 05:26:29 Seminole, Florida, US
901409 2021-03-04 US Florida St. Johns 12109 20242 199 0 20043 29.90096506 -81.43589967 2021-03-05 05:26:29 St. Johns, Florida, US
901410 2021-03-04 US Florida St. Lucie 12111 22445 551 0 21894 27.37763908 -80.47106649 2021-03-05 05:26:29 St. Lucie, Florida, US
901411 2021-03-04 US Florida Sumter 12119 8125 243 0 7882 28.70181754 -82.0794267 2021-03-05 05:26:29 Sumter, Florida, US
901412 2021-03-04 US Florida Suwannee 12121 5130 133 0 4997 30.19746066 -82.99099670000003 2021-03-05 05:26:29 Suwannee, Florida, US
901413 2021-03-04 US Florida Taylor 12123 2651 42 0 2609 30.04848048 -83.60445406 2021-03-05 05:26:29 Taylor, Florida, US
901414 2021-03-04 US Florida Unassigned 90012 3493 0 0 3493 30.86747479 0.0 2021-03-05 05:26:29 Unassigned, Florida, US
901415 2021-03-04 US Florida Union 12125 1742 70 0 1672 30.04412971 -82.37497443 2021-03-05 05:26:29 Union, Florida, US
901416 2021-03-04 US Florida Volusia 12127 34891 671 0 34220 29.05858895 -81.18263252 2021-03-05 05:26:29 Volusia, Florida, US
901417 2021-03-04 US Florida Wakulla 12129 3183 52 0 3131 30.16548905 -84.39895211 2021-03-05 05:26:29 Wakulla, Florida, US
901418 2021-03-04 US Florida Walton 12131 7113 81 0 7032 30.64204028 -86.16935664 2021-03-05 05:26:29 Walton, Florida, US
901419 2021-03-04 US Florida Washington 12133 2634 48 0 2586 30.61359259 -85.66002461 2021-03-05 05:26:29 Washington, Florida, US
909077 2021-03-03 US Florida Alachua 12001 22458 235 0 22223 29.67866525 -82.35928158 2021-03-04 05:24:24 Alachua, Florida, US
909078 2021-03-03 US Florida Baker 12003 3311 56 0 3255 30.33060121 -82.28467476 2021-03-04 05:24:24 Baker, Florida, US
909079 2021-03-03 US Florida Bay 12005 18815 347 0 18468 30.26548745 -85.62122584 2021-03-04 05:24:24 Bay, Florida, US
909080 2021-03-03 US Florida Bradford 12007 2857 52 0 2805 29.95079741 -82.16611613 2021-03-04 05:24:24 Bradford, Florida, US
909081 2021-03-03 US Florida Brevard 12009 34303 751 0 33552 28.29409504 -80.73091022 2021-03-04 05:24:24 Brevard, Florida, US
909082 2021-03-03 US Florida Broward 12011 196771 2422 0 194349 26.15184651 -80.48725556 2021-03-04 05:24:24 Broward, Florida, US
909083 2021-03-03 US Florida Calhoun 12013 1618 46 0 1572 30.40666734 -85.19394153 2021-03-04 05:24:24 Calhoun, Florida, US
909084 2021-03-03 US Florida Charlotte 12015 10751 372 0 10379 26.90131002 -81.92949121 2021-03-04 05:24:24 Charlotte, Florida, US
909085 2021-03-03 US Florida Citrus 12017 9814 404 0 9410 28.84804315 -82.47614748 2021-03-04 05:24:24 Citrus, Florida, US
909086 2021-03-03 US Florida Clay 12019 16777 315 0 16462 29.98319144 -81.85609986 2021-03-04 05:24:24 Clay, Florida, US
909087 2021-03-03 US Florida Collier 12021 30505 461 0 30044 26.11091986 -81.34687065 2021-03-04 05:24:24 Collier, Florida, US
909088 2021-03-03 US Florida Columbia 12023 7697 157 0 7540 30.22509788 -82.62160164 2021-03-04 05:24:24 Columbia, Florida, US
909089 2021-03-03 US Florida DeSoto 12027 3834 74 0 3760 27.18677893 -81.80941373 2021-03-04 05:24:24 DeSoto, Florida, US
909090 2021-03-03 US Florida Dixie 12029 1495 21 0 1474 29.60631086 -83.15724673 2021-03-04 05:24:24 Dixie, Florida, US
909091 2021-03-03 US Florida Duval 12031 89177 1186 0 87991 30.33225875 -81.66976468 2021-03-04 05:24:24 Duval, Florida, US
909092 2021-03-03 US Florida Escambia 12033 33894 633 0 33261 30.67652764 -87.37284571 2021-03-04 05:24:24 Escambia, Florida, US
909093 2021-03-03 US Florida Flagler 12035 6033 92 0 5941 29.45933576 -81.31508595 2021-03-04 05:24:24 Flagler, Florida, US
909094 2021-03-03 US Florida Franklin 12037 1279 17 0 1262 29.83791238 -84.82731662 2021-03-04 05:24:24 Franklin, Florida, US
909095 2021-03-03 US Florida Gadsden 12039 5464 87 0 5377 30.57796289 -84.61915825 2021-03-04 05:24:24 Gadsden, Florida, US
909096 2021-03-03 US Florida Gilchrist 12041 1421 36 0 1385 29.72856978 -82.79880657 2021-03-04 05:24:24 Gilchrist, Florida, US
909097 2021-03-03 US Florida Glades 12043 905 15 0 890 26.95635849 -81.18996211 2021-03-04 05:24:24 Glades, Florida, US
909098 2021-03-03 US Florida Gulf 12045 1875 41 0 1834 29.93543004 -85.24270990000002 2021-03-04 05:24:24 Gulf, Florida, US
909099 2021-03-03 US Florida Hamilton 12047 1571 21 0 1550 30.49673973 -82.94998918 2021-03-04 05:24:24 Hamilton, Florida, US
909100 2021-03-03 US Florida Hardee 12049 2807 31 0 2776 27.49293939 -81.80956574 2021-03-04 05:24:24 Hardee, Florida, US
909101 2021-03-03 US Florida Hendry 12051 4329 73 0 4256 26.55386945 -81.16469006 2021-03-04 05:24:24 Hendry, Florida, US
909102 2021-03-03 US Florida Hernando 12053 11419 403 0 11016 28.55364461 -82.42700204 2021-03-04 05:24:24 Hernando, Florida, US
909103 2021-03-03 US Florida Highlands 12055 7281 307 0 6974 27.34254618 -81.34071957 2021-03-04 05:24:24 Highlands, Florida, US
909104 2021-03-03 US Florida Hillsborough 12057 112267 1521 0 110746 27.9276559 -82.32013172 2021-03-04 05:24:24 Hillsborough, Florida, US
909105 2021-03-03 US Florida Holmes 12059 2190 44 0 2146 30.86747479 -85.81319222 2021-03-04 05:24:24 Holmes, Florida, US
909106 2021-03-03 US Florida Indian River 12061 11108 264 0 10844 27.69308961 -80.60556721 2021-03-04 05:24:24 Indian River, Florida, US
909107 2021-03-03 US Florida Jackson 12063 5935 151 0 5784 30.7954597 -85.21500423 2021-03-04 05:24:24 Jackson, Florida, US
909108 2021-03-03 US Florida Jefferson 12065 1407 24 0 1383 30.43669112 -83.89442308 2021-03-04 05:24:24 Jefferson, Florida, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);