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

68 rows where "day" is on date 2021-02-04 and province_or_state = "Florida" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Florida · 68 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
791052 791052 2021-02-04 US Florida Alachua 12001 21055 176 0 20879 29.67866525 -82.35928158 2021-02-05 05:22:38 Alachua, Florida, US
791053 791053 2021-02-04 US Florida Baker 12003 3089 51 0 3038 30.33060121 -82.28467476 2021-02-05 05:22:38 Baker, Florida, US
791054 791054 2021-02-04 US Florida Bay 12005 17262 297 0 16965 30.26548745 -85.62122584 2021-02-05 05:22:38 Bay, Florida, US
791055 791055 2021-02-04 US Florida Bradford 12007 2687 46 0 2641 29.95079741 -82.16611613 2021-02-05 05:22:38 Bradford, Florida, US
791056 791056 2021-02-04 US Florida Brevard 12009 30153 663 0 29490 28.29409504 -80.73091022 2021-02-05 05:22:38 Brevard, Florida, US
791057 791057 2021-02-04 US Florida Broward 12011 176144 2139 0 174005 26.15184651 -80.48725556 2021-02-05 05:22:38 Broward, Florida, US
791058 791058 2021-02-04 US Florida Calhoun 12013 1538 36 0 1502 30.40666734 -85.19394153 2021-02-05 05:22:38 Calhoun, Florida, US
791059 791059 2021-02-04 US Florida Charlotte 12015 9890 304 0 9586 26.90131002 -81.92949121 2021-02-05 05:22:38 Charlotte, Florida, US
791060 791060 2021-02-04 US Florida Citrus 12017 8853 356 0 8497 28.84804315 -82.47614748 2021-02-05 05:22:38 Citrus, Florida, US
791061 791061 2021-02-04 US Florida Clay 12019 15655 266 0 15389 29.98319144 -81.85609986 2021-02-05 05:22:38 Clay, Florida, US
791062 791062 2021-02-04 US Florida Collier 12021 28224 414 0 27810 26.11091986 -81.34687065 2021-02-05 05:22:38 Collier, Florida, US
791063 791063 2021-02-04 US Florida Columbia 12023 7322 143 0 7179 30.22509788 -82.62160164 2021-02-05 05:22:38 Columbia, Florida, US
791064 791064 2021-02-04 US Florida DeSoto 12027 3427 67 0 3360 27.18677893 -81.80941373 2021-02-05 05:22:38 DeSoto, Florida, US
791065 791065 2021-02-04 US Florida Dixie 12029 1400 13 0 1387 29.60631086 -83.15724673 2021-02-05 05:22:38 Dixie, Florida, US
791066 791066 2021-02-04 US Florida Duval 12031 83166 946 0 82220 30.33225875 -81.66976468 2021-02-05 05:22:38 Duval, Florida, US
791067 791067 2021-02-04 US Florida Escambia 12033 31579 541 0 31038 30.67652764 -87.37284571 2021-02-05 05:22:38 Escambia, Florida, US
791068 791068 2021-02-04 US Florida Flagler 12035 5405 73 0 5332 29.45933576 -81.31508595 2021-02-05 05:22:38 Flagler, Florida, US
791069 791069 2021-02-04 US Florida Franklin 12037 1247 10 0 1237 29.83791238 -84.82731662 2021-02-05 05:22:38 Franklin, Florida, US
791070 791070 2021-02-04 US Florida Gadsden 12039 5161 72 0 5089 30.57796289 -84.61915825 2021-02-05 05:22:38 Gadsden, Florida, US
791071 791071 2021-02-04 US Florida Gilchrist 12041 1245 28 0 1217 29.72856978 -82.79880657 2021-02-05 05:22:38 Gilchrist, Florida, US
791072 791072 2021-02-04 US Florida Glades 12043 870 13 0 857 26.95635849 -81.18996211 2021-02-05 05:22:38 Glades, Florida, US
791073 791073 2021-02-04 US Florida Gulf 12045 1734 34 0 1700 29.93543004 -85.24270990000002 2021-02-05 05:22:38 Gulf, Florida, US
791074 791074 2021-02-04 US Florida Hamilton 12047 1520 18 0 1502 30.49673973 -82.94998918 2021-02-05 05:22:38 Hamilton, Florida, US
791075 791075 2021-02-04 US Florida Hardee 12049 2614 24 0 2590 27.49293939 -81.80956574 2021-02-05 05:22:38 Hardee, Florida, US
791076 791076 2021-02-04 US Florida Hendry 12051 4079 57 0 4022 26.55386945 -81.16469006 2021-02-05 05:22:38 Hendry, Florida, US
791077 791077 2021-02-04 US Florida Hernando 12053 10143 353 0 9790 28.55364461 -82.42700204 2021-02-05 05:22:38 Hernando, Florida, US
791078 791078 2021-02-04 US Florida Highlands 12055 6603 266 0 6337 27.34254618 -81.34071957 2021-02-05 05:22:38 Highlands, Florida, US
791079 791079 2021-02-04 US Florida Hillsborough 12057 102337 1342 0 100995 27.9276559 -82.32013172 2021-02-05 05:22:38 Hillsborough, Florida, US
791080 791080 2021-02-04 US Florida Holmes 12059 2103 41 0 2062 30.86747479 -85.81319222 2021-02-05 05:22:38 Holmes, Florida, US
791081 791081 2021-02-04 US Florida Indian River 12061 9980 235 0 9745 27.69308961 -80.60556721 2021-02-05 05:22:38 Indian River, Florida, US
791082 791082 2021-02-04 US Florida Jackson 12063 5717 133 0 5584 30.7954597 -85.21500423 2021-02-05 05:22:38 Jackson, Florida, US
791083 791083 2021-02-04 US Florida Jefferson 12065 1321 22 0 1299 30.43669112 -83.89442308 2021-02-05 05:22:38 Jefferson, Florida, US
791084 791084 2021-02-04 US Florida Lafayette 12067 1534 23 0 1511 29.98484137 -83.18166636 2021-02-05 05:22:38 Lafayette, Florida, US
791085 791085 2021-02-04 US Florida Lake 12069 22311 453 0 21858 28.76202069 -81.7125123 2021-02-05 05:22:38 Lake, Florida, US
791086 791086 2021-02-04 US Florida Lee 12071 53549 813 0 52736 26.58410348 -81.88399313 2021-02-05 05:22:38 Lee, Florida, US
791087 791087 2021-02-04 US Florida Leon 12073 26990 245 0 26745 30.45955727 -84.27491114 2021-02-05 05:22:38 Leon, Florida, US
791088 791088 2021-02-04 US Florida Levy 12075 2605 24 0 2581 29.31829741 -82.74007147 2021-02-05 05:22:38 Levy, Florida, US
791089 791089 2021-02-04 US Florida Liberty 12077 1001 14 0 987 30.23766008 -84.8829258 2021-02-05 05:22:38 Liberty, Florida, US
791090 791090 2021-02-04 US Florida Madison 12079 1860 37 0 1823 30.44396917 -83.47398594 2021-02-05 05:22:38 Madison, Florida, US
791091 791091 2021-02-04 US Florida Manatee 12081 29041 505 0 28536 27.47196942 -82.31831044 2021-02-05 05:22:38 Manatee, Florida, US
791092 791092 2021-02-04 US Florida Marion 12083 25003 642 0 24361 29.21227113 -82.05803627 2021-02-05 05:22:38 Marion, Florida, US
791093 791093 2021-02-04 US Florida Martin 12085 9773 256 0 9517 27.0772071 -80.43109784 2021-02-05 05:22:38 Martin, Florida, US
791094 791094 2021-02-04 US Florida Miami-Dade 12086 377999 4942 0 373057 25.6112362 -80.55170587 2021-02-05 05:22:38 Miami-Dade, Florida, US
791095 791095 2021-02-04 US Florida Monroe 12087 5425 41 0 5384 25.20904673 -81.07812416 2021-02-05 05:22:38 Monroe, Florida, US
791096 791096 2021-02-04 US Florida Nassau 12089 7142 95 0 7047 30.61037141 -81.80297522 2021-02-05 05:22:38 Nassau, Florida, US
791097 791097 2021-02-04 US Florida Okaloosa 12091 17190 292 0 16898 30.69143028 -86.59267105 2021-02-05 05:22:38 Okaloosa, Florida, US
791098 791098 2021-02-04 US Florida Okeechobee 12093 3316 68 0 3248 27.386336199999995 -80.88944347 2021-02-05 05:22:38 Okeechobee, Florida, US
791099 791099 2021-02-04 US Florida Orange 12095 104989 990 0 103999 28.51367621 -81.31799498 2021-02-05 05:22:38 Orange, Florida, US
791100 791100 2021-02-04 US Florida Osceola 12097 34099 385 0 33714 28.06312234 -81.14882926 2021-02-05 05:22:38 Osceola, Florida, US
791101 791101 2021-02-04 US Florida Palm Beach 12099 109219 2238 0 106981 26.64676272 -80.46536002 2021-02-05 05:22:38 Palm Beach, Florida, US
791102 791102 2021-02-04 US Florida Pasco 12101 30214 576 0 29638 28.30810945 -82.40227529 2021-02-05 05:22:38 Pasco, Florida, US
791103 791103 2021-02-04 US Florida Pinellas 12103 60623 1312 0 59311 27.93130349 -82.72239666 2021-02-05 05:22:38 Pinellas, Florida, US
791104 791104 2021-02-04 US Florida Polk 12105 51630 991 0 50639 27.95027105 -81.69732947 2021-02-05 05:22:38 Polk, Florida, US
791105 791105 2021-02-04 US Florida Putnam 12107 5545 103 0 5442 29.60779729 -81.74230285 2021-02-05 05:22:38 Putnam, Florida, US
791106 791106 2021-02-04 US Florida Santa Rosa 12113 15784 217 0 15567 30.693414500000006 -87.02458128 2021-02-05 05:22:38 Santa Rosa, Florida, US
791107 791107 2021-02-04 US Florida Sarasota 12115 25158 651 0 24507 27.18546175 -82.33174248 2021-02-05 05:22:38 Sarasota, Florida, US
791108 791108 2021-02-04 US Florida Seminole 12117 24635 385 0 24250 28.7158582 -81.24060348 2021-02-05 05:22:38 Seminole, Florida, US
791109 791109 2021-02-04 US Florida St. Johns 12109 18743 173 0 18570 29.90096506 -81.43589967 2021-02-05 05:22:38 St. Johns, Florida, US
791110 791110 2021-02-04 US Florida St. Lucie 12111 19997 501 0 19496 27.37763908 -80.47106649 2021-02-05 05:22:38 St. Lucie, Florida, US
791111 791111 2021-02-04 US Florida Sumter 12119 7281 187 0 7094 28.70181754 -82.0794267 2021-02-05 05:22:38 Sumter, Florida, US
791112 791112 2021-02-04 US Florida Suwannee 12121 4898 118 0 4780 30.19746066 -82.99099670000003 2021-02-05 05:22:38 Suwannee, Florida, US
791113 791113 2021-02-04 US Florida Taylor 12123 2527 35 0 2492 30.04848048 -83.60445406 2021-02-05 05:22:38 Taylor, Florida, US
791114 791114 2021-02-04 US Florida Unassigned 90012 3348 0 0 3348 30.86747479 0.0 2021-02-05 05:22:38 Unassigned, Florida, US
791115 791115 2021-02-04 US Florida Union 12125 1672 70 0 1602 30.04412971 -82.37497443 2021-02-05 05:22:38 Union, Florida, US
791116 791116 2021-02-04 US Florida Volusia 12127 31676 541 0 31135 29.05858895 -81.18263252 2021-02-05 05:22:38 Volusia, Florida, US
791117 791117 2021-02-04 US Florida Wakulla 12129 3002 41 0 2961 30.16548905 -84.39895211 2021-02-05 05:22:38 Wakulla, Florida, US
791118 791118 2021-02-04 US Florida Walton 12131 6529 69 0 6460 30.64204028 -86.16935664 2021-02-05 05:22:38 Walton, Florida, US
791119 791119 2021-02-04 US Florida Washington 12133 2499 35 0 2464 30.61359259 -85.66002461 2021-02-05 05:22:38 Washington, Florida, US

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] TEXT,
   [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]);