johns_hopkins_csse_daily_reports

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

39,460 rows where province_or_state = "Florida" sorted by day descending

✎ View and edit SQL

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

Suggested facets: day (date), last_update (date)

province_or_state

  • Florida · 39,460 ✖

country_or_region

  • US 39,460
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
32961 32961 2021-10-23 US Florida Alachua 12001 39676 285 0   29.67866525 -82.35928158 2021-10-24 04:21:22 Alachua, Florida, US
32962 32962 2021-10-23 US Florida Baker 12003 5989 62 0   30.33060121 -82.28467476 2021-10-24 04:21:22 Baker, Florida, US
32963 32963 2021-10-23 US Florida Bay 12005 32518 394 0   30.26548745 -85.62122584 2021-10-24 04:21:22 Bay, Florida, US
32964 32964 2021-10-23 US Florida Bradford 12007 5340 58 0   29.95079741 -82.16611613 2021-10-24 04:21:22 Bradford, Florida, US
32965 32965 2021-10-23 US Florida Brevard 12009 81174 914 0   28.29409504 -80.73091022 2021-10-24 04:21:22 Brevard, Florida, US
32966 32966 2021-10-23 US Florida Broward 12011 358582 3079 0   26.15184651 -80.48725556 2021-10-24 04:21:22 Broward, Florida, US
32967 32967 2021-10-23 US Florida Calhoun 12013 3007 45 0   30.40666734 -85.19394153 2021-10-24 04:21:22 Calhoun, Florida, US
32968 32968 2021-10-23 US Florida Charlotte 12015 23353 437 0   26.90131002 -81.92949121 2021-10-24 04:21:22 Charlotte, Florida, US
32969 32969 2021-10-23 US Florida Citrus 12017 20427 463 0   28.84804315 -82.47614748 2021-10-24 04:21:22 Citrus, Florida, US
32970 32970 2021-10-23 US Florida Clay 12019 33791 352 0   29.98319144 -81.85609986 2021-10-24 04:21:22 Clay, Florida, US
32971 32971 2021-10-23 US Florida Collier 12021 58000 551 0   26.11091986 -81.34687065 2021-10-24 04:21:22 Collier, Florida, US
32972 32972 2021-10-23 US Florida Columbia 12023 14889 170 0   30.22509788 -82.62160164 2021-10-24 04:21:22 Columbia, Florida, US
32973 32973 2021-10-23 US Florida DeSoto 12027 6898 97 0   27.18677893 -81.80941373 2021-10-24 04:21:22 DeSoto, Florida, US
32974 32974 2021-10-23 US Florida Dixie 12029 2950 24 0   29.60631086 -83.15724673 2021-10-24 04:21:22 Dixie, Florida, US
32975 32975 2021-10-23 US Florida Duval 12031 165744 1483 0   30.33225875 -81.66976468 2021-10-24 04:21:22 Duval, Florida, US
32976 32976 2021-10-23 US Florida Escambia 12033 57196 706 0   30.67652764 -87.37284571 2021-10-24 04:21:22 Escambia, Florida, US
32977 32977 2021-10-23 US Florida Flagler 12035 14410 114 0   29.45933576 -81.31508595 2021-10-24 04:21:22 Flagler, Florida, US
32978 32978 2021-10-23 US Florida Franklin 12037 2262 20 0   29.83791238 -84.82731662 2021-10-24 04:21:22 Franklin, Florida, US
32979 32979 2021-10-23 US Florida Gadsden 12039 8636 99 0   30.57796289 -84.61915825 2021-10-24 04:21:22 Gadsden, Florida, US
32980 32980 2021-10-23 US Florida Gilchrist 12041 3146 44 0   29.72856978 -82.79880657 2021-10-24 04:21:22 Gilchrist, Florida, US
32981 32981 2021-10-23 US Florida Glades 12043 1438 19 0   26.95635849 -81.18996211 2021-10-24 04:21:22 Glades, Florida, US
32982 32982 2021-10-23 US Florida Gulf 12045 2991 45 0   29.93543004 -85.24270990000002 2021-10-24 04:21:22 Gulf, Florida, US
32983 32983 2021-10-23 US Florida Hamilton 12047 2746 25 0   30.49673973 -82.94998918 2021-10-24 04:21:22 Hamilton, Florida, US
32984 32984 2021-10-23 US Florida Hardee 12049 6069 45 0   27.49293939 -81.80956574 2021-10-24 04:21:22 Hardee, Florida, US
32985 32985 2021-10-23 US Florida Hendry 12051 7964 87 0   26.55386945 -81.16469006 2021-10-24 04:21:22 Hendry, Florida, US
32986 32986 2021-10-23 US Florida Hernando 12053 28582 482 0   28.55364461 -82.42700204 2021-10-24 04:21:22 Hernando, Florida, US
32987 32987 2021-10-23 US Florida Highlands 12055 15980 366 0   27.34254618 -81.34071957 2021-10-24 04:21:22 Highlands, Florida, US
32988 32988 2021-10-23 US Florida Hillsborough 12057 241798 1832 0   27.9276559 -82.32013172 2021-10-24 04:21:22 Hillsborough, Florida, US
32989 32989 2021-10-23 US Florida Holmes 12059 3870 49 0   30.86747479 -85.81319222 2021-10-24 04:21:22 Holmes, Florida, US
32990 32990 2021-10-23 US Florida Indian River 12061 22196 306 0   27.69308961 -80.60556721 2021-10-24 04:21:22 Indian River, Florida, US
32991 32991 2021-10-23 US Florida Jackson 12063 10143 158 0   30.795459700000002 -85.21500423 2021-10-24 04:21:22 Jackson, Florida, US
32992 32992 2021-10-23 US Florida Jefferson 12065 2482 28 0   30.43669112 -83.89442308 2021-10-24 04:21:22 Jefferson, Florida, US
32993 32993 2021-10-23 US Florida Lafayette 12067 2208 26 0   29.98484137 -83.18166636 2021-10-24 04:21:22 Lafayette, Florida, US
32994 32994 2021-10-23 US Florida Lake 12069 54693 663 0   28.76202069 -81.7125123 2021-10-24 04:21:22 Lake, Florida, US
32995 32995 2021-10-23 US Florida Lee 12071 126751 1009 0   26.58410348 -81.88399313 2021-10-24 04:21:22 Lee, Florida, US
32996 32996 2021-10-23 US Florida Leon 12073 51393 332 0   30.45955727 -84.27491114 2021-10-24 04:21:22 Leon, Florida, US
32997 32997 2021-10-23 US Florida Levy 12075 6966 56 0   29.31829741 -82.74007147 2021-10-24 04:21:22 Levy, Florida, US
32998 32998 2021-10-23 US Florida Liberty 12077 1824 16 0   30.23766008 -84.8829258 2021-10-24 04:21:22 Liberty, Florida, US
32999 32999 2021-10-23 US Florida Madison 12079 3613 45 0   30.44396917 -83.47398594 2021-10-24 04:21:22 Madison, Florida, US
33000 33000 2021-10-23 US Florida Manatee 12081 65499 689 0   27.47196942 -82.31831044 2021-10-24 04:21:22 Manatee, Florida, US
33001 33001 2021-10-23 US Florida Marion 12083 56730 996 0   29.21227113 -82.05803627 2021-10-24 04:21:22 Marion, Florida, US
33002 33002 2021-10-23 US Florida Martin 12085 20302 335 0   27.0772071 -80.43109784 2021-10-24 04:21:22 Martin, Florida, US
33003 33003 2021-10-23 US Florida Miami-Dade 12086 676943 6472 0   25.6112362 -80.55170587 2021-10-24 04:21:22 Miami-Dade, Florida, US
33004 33004 2021-10-23 US Florida Monroe 12087 10853 52 0   25.20904673 -81.07812416 2021-10-24 04:21:22 Monroe, Florida, US
33005 33005 2021-10-23 US Florida Nassau 12089 15448 127 0   30.61037141 -81.80297522 2021-10-24 04:21:22 Nassau, Florida, US
33006 33006 2021-10-23 US Florida Okaloosa 12091 34527 367 0   30.69143028 -86.59267105 2021-10-24 04:21:22 Okaloosa, Florida, US
33007 33007 2021-10-23 US Florida Okeechobee 12093 7436 89 0   27.386336199999995 -80.88944347 2021-10-24 04:21:22 Okeechobee, Florida, US
33008 33008 2021-10-23 US Florida Orange 12095 229561 1310 0   28.51367621 -81.31799498 2021-10-24 04:21:22 Orange, Florida, US
33009 33009 2021-10-23 US Florida Osceola 12097 72111 529 0   28.06312234 -81.14882926 2021-10-24 04:21:22 Osceola, Florida, US
33010 33010 2021-10-23 US Florida Palm Beach 12099 226868 2883 0   26.64676272 -80.46536002 2021-10-24 04:21:22 Palm Beach, Florida, US
33011 33011 2021-10-23 US Florida Pasco 12101 79268 802 0   28.30810945 -82.40227529 2021-10-24 04:21:22 Pasco, Florida, US
33012 33012 2021-10-23 US Florida Pinellas 12103 135998 1671 0   27.93130349 -82.72239666 2021-10-24 04:21:22 Pinellas, Florida, US
33013 33013 2021-10-23 US Florida Polk 12105 128509 1387 0   27.95027105 -81.69732947 2021-10-24 04:21:22 Polk, Florida, US
33014 33014 2021-10-23 US Florida Putnam 12107 12775 160 0   29.60779729 -81.74230285 2021-10-24 04:21:22 Putnam, Florida, US
33015 33015 2021-10-23 US Florida Santa Rosa 12113 32571 291 0   30.69341450000001 -87.02458128 2021-10-24 04:21:22 Santa Rosa, Florida, US
33016 33016 2021-10-23 US Florida Sarasota 12115 56670 844 0   27.18546175 -82.33174248 2021-10-24 04:21:22 Sarasota, Florida, US
33017 33017 2021-10-23 US Florida Seminole 12117 62100 516 0   28.7158582 -81.24060348 2021-10-24 04:21:22 Seminole, Florida, US
33018 33018 2021-10-23 US Florida St. Johns 12109 40812 221 0   29.90096506 -81.43589967 2021-10-24 04:21:22 St. Johns, Florida, US
33019 33019 2021-10-23 US Florida St. Lucie 12111 47837 657 0   27.37763908 -80.47106649 2021-10-24 04:21:22 St. Lucie, Florida, US
33020 33020 2021-10-23 US Florida Sumter 12119 14562 284 0   28.70181754 -82.0794267 2021-10-24 04:21:22 Sumter, Florida, US
33021 33021 2021-10-23 US Florida Suwannee 12121 9204 140 0   30.19746066 -82.99099670000003 2021-10-24 04:21:22 Suwannee, Florida, US
33022 33022 2021-10-23 US Florida Taylor 12123 4587 48 0   30.04848048 -83.60445406 2021-10-24 04:21:22 Taylor, Florida, US
33023 33023 2021-10-23 US Florida Unassigned 90012 2961 21830 0   30.86747479 0.0 2021-10-24 04:21:22 Unassigned, Florida, US
33024 33024 2021-10-23 US Florida Union 12125 3058 74 0   30.04412971 -82.37497443 2021-10-24 04:21:22 Union, Florida, US
33025 33025 2021-10-23 US Florida Volusia 12127 76034 846 0   29.05858895 -81.18263252 2021-10-24 04:21:22 Volusia, Florida, US
33026 33026 2021-10-23 US Florida Wakulla 12129 6389 56 0   30.16548905 -84.39895211 2021-10-24 04:21:22 Wakulla, Florida, US
33027 33027 2021-10-23 US Florida Walton 12131 12790 89 0   30.64204028 -86.16935664 2021-10-24 04:21:22 Walton, Florida, US
33028 33028 2021-10-23 US Florida Washington 12133 4563 52 0   30.61359259 -85.66002461 2021-10-24 04:21:22 Washington, Florida, US
313445 313445 2021-10-22 US Florida Alachua 12001 39676 285 0   29.67866525 -82.35928158 2021-10-23 04:21:32 Alachua, Florida, US
313446 313446 2021-10-22 US Florida Baker 12003 5989 62 0   30.33060121 -82.28467476 2021-10-23 04:21:32 Baker, Florida, US
313447 313447 2021-10-22 US Florida Bay 12005 32518 394 0   30.26548745 -85.62122584 2021-10-23 04:21:32 Bay, Florida, US
313448 313448 2021-10-22 US Florida Bradford 12007 5340 58 0   29.95079741 -82.16611613 2021-10-23 04:21:32 Bradford, Florida, US
313449 313449 2021-10-22 US Florida Brevard 12009 81174 914 0   28.29409504 -80.73091022 2021-10-23 04:21:32 Brevard, Florida, US
313450 313450 2021-10-22 US Florida Broward 12011 358582 3079 0   26.15184651 -80.48725556 2021-10-23 04:21:32 Broward, Florida, US
313451 313451 2021-10-22 US Florida Calhoun 12013 3007 45 0   30.40666734 -85.19394153 2021-10-23 04:21:32 Calhoun, Florida, US
313452 313452 2021-10-22 US Florida Charlotte 12015 23353 437 0   26.90131002 -81.92949121 2021-10-23 04:21:32 Charlotte, Florida, US
313453 313453 2021-10-22 US Florida Citrus 12017 20427 463 0   28.84804315 -82.47614748 2021-10-23 04:21:32 Citrus, Florida, US
313454 313454 2021-10-22 US Florida Clay 12019 33791 352 0   29.98319144 -81.85609986 2021-10-23 04:21:32 Clay, Florida, US
313455 313455 2021-10-22 US Florida Collier 12021 58000 551 0   26.11091986 -81.34687065 2021-10-23 04:21:32 Collier, Florida, US
313456 313456 2021-10-22 US Florida Columbia 12023 14889 170 0   30.22509788 -82.62160164 2021-10-23 04:21:32 Columbia, Florida, US
313457 313457 2021-10-22 US Florida DeSoto 12027 6898 97 0   27.18677893 -81.80941373 2021-10-23 04:21:32 DeSoto, Florida, US
313458 313458 2021-10-22 US Florida Dixie 12029 2950 24 0   29.60631086 -83.15724673 2021-10-23 04:21:32 Dixie, Florida, US
313459 313459 2021-10-22 US Florida Duval 12031 165744 1483 0   30.33225875 -81.66976468 2021-10-23 04:21:32 Duval, Florida, US
313460 313460 2021-10-22 US Florida Escambia 12033 57196 706 0   30.67652764 -87.37284571 2021-10-23 04:21:32 Escambia, Florida, US
313461 313461 2021-10-22 US Florida Flagler 12035 14410 114 0   29.45933576 -81.31508595 2021-10-23 04:21:32 Flagler, Florida, US
313462 313462 2021-10-22 US Florida Franklin 12037 2262 20 0   29.83791238 -84.82731662 2021-10-23 04:21:32 Franklin, Florida, US
313463 313463 2021-10-22 US Florida Gadsden 12039 8636 99 0   30.57796289 -84.61915825 2021-10-23 04:21:32 Gadsden, Florida, US
313464 313464 2021-10-22 US Florida Gilchrist 12041 3146 44 0   29.72856978 -82.79880657 2021-10-23 04:21:32 Gilchrist, Florida, US
313465 313465 2021-10-22 US Florida Glades 12043 1438 19 0   26.95635849 -81.18996211 2021-10-23 04:21:32 Glades, Florida, US
313466 313466 2021-10-22 US Florida Gulf 12045 2991 45 0   29.93543004 -85.24270990000002 2021-10-23 04:21:32 Gulf, Florida, US
313467 313467 2021-10-22 US Florida Hamilton 12047 2746 25 0   30.49673973 -82.94998918 2021-10-23 04:21:32 Hamilton, Florida, US
313468 313468 2021-10-22 US Florida Hardee 12049 6069 45 0   27.49293939 -81.80956574 2021-10-23 04:21:32 Hardee, Florida, US
313469 313469 2021-10-22 US Florida Hendry 12051 7964 87 0   26.55386945 -81.16469006 2021-10-23 04:21:32 Hendry, Florida, US
313470 313470 2021-10-22 US Florida Hernando 12053 28582 482 0   28.55364461 -82.42700204 2021-10-23 04:21:32 Hernando, Florida, US
313471 313471 2021-10-22 US Florida Highlands 12055 15980 366 0   27.34254618 -81.34071957 2021-10-23 04:21:32 Highlands, Florida, US
313472 313472 2021-10-22 US Florida Hillsborough 12057 241798 1832 0   27.9276559 -82.32013172 2021-10-23 04:21:32 Hillsborough, Florida, US
313473 313473 2021-10-22 US Florida Holmes 12059 3870 49 0   30.86747479 -85.81319222 2021-10-23 04:21:32 Holmes, Florida, US
313474 313474 2021-10-22 US Florida Indian River 12061 22196 306 0   27.69308961 -80.60556721 2021-10-23 04:21:32 Indian River, Florida, US
313475 313475 2021-10-22 US Florida Jackson 12063 10143 158 0   30.795459700000002 -85.21500423 2021-10-23 04:21:32 Jackson, Florida, US
313476 313476 2021-10-22 US Florida Jefferson 12065 2482 28 0   30.43669112 -83.89442308 2021-10-23 04:21:32 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]);