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-01-07 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
2542075 2542075 2021-01-07 US Florida Alachua 12001 17000 136 0 16864 29.67866525 -82.35928158 2021-01-08 05:22:42 Alachua, Florida, US
2542076 2542076 2021-01-07 US Florida Baker 12003 2625 38 0 2587 30.33060121 -82.28467476 2021-01-08 05:22:42 Baker, Florida, US
2542077 2542077 2021-01-07 US Florida Bay 12005 12839 219 0 12620 30.26548745 -85.62122584 2021-01-08 05:22:42 Bay, Florida, US
2542078 2542078 2021-01-07 US Florida Bradford 12007 2312 24 0 2288 29.95079741 -82.16611613 2021-01-08 05:22:42 Bradford, Florida, US
2542079 2542079 2021-01-07 US Florida Brevard 12009 23103 535 0 22568 28.29409504 -80.73091022 2021-01-08 05:22:42 Brevard, Florida, US
2542080 2542080 2021-01-07 US Florida Broward 12011 146201 1897 0 144304 26.15184651 -80.48725556 2021-01-08 05:22:42 Broward, Florida, US
2542081 2542081 2021-01-07 US Florida Calhoun 12013 1356 29 0 1327 30.40666734 -85.19394153 2021-01-08 05:22:42 Calhoun, Florida, US
2542082 2542082 2021-01-07 US Florida Charlotte 12015 8147 248 0 7899 26.90131002 -81.92949121 2021-01-08 05:22:42 Charlotte, Florida, US
2542083 2542083 2021-01-07 US Florida Citrus 12017 7226 282 0 6944 28.84804315 -82.47614748 2021-01-08 05:22:42 Citrus, Florida, US
2542084 2542084 2021-01-07 US Florida Clay 12019 12543 193 0 12350 29.98319144 -81.85609986 2021-01-08 05:22:42 Clay, Florida, US
2542085 2542085 2021-01-07 US Florida Collier 12021 23707 354 0 23353 26.11091986 -81.34687065 2021-01-08 05:22:42 Collier, Florida, US
2542086 2542086 2021-01-07 US Florida Columbia 12023 6358 119 0 6239 30.22509788 -82.62160164 2021-01-08 05:22:42 Columbia, Florida, US
2542087 2542087 2021-01-07 US Florida DeSoto 12027 3047 58 0 2989 27.18677893 -81.80941373 2021-01-08 05:22:42 DeSoto, Florida, US
2542088 2542088 2021-01-07 US Florida Dixie 12029 1193 11 0 1182 29.60631086 -83.15724673 2021-01-08 05:22:42 Dixie, Florida, US
2542089 2542089 2021-01-07 US Florida Duval 12031 67938 767 0 67171 30.33225875 -81.66976468 2021-01-08 05:22:42 Duval, Florida, US
2542090 2542090 2021-01-07 US Florida Escambia 12033 24530 400 0 24130 30.67652764 -87.37284571 2021-01-08 05:22:42 Escambia, Florida, US
2542091 2542091 2021-01-07 US Florida Flagler 12035 4154 48 0 4106 29.45933576 -81.31508595 2021-01-08 05:22:42 Flagler, Florida, US
2542092 2542092 2021-01-07 US Florida Franklin 12037 992 4 0 988 29.83791238 -84.82731662 2021-01-08 05:22:42 Franklin, Florida, US
2542093 2542093 2021-01-07 US Florida Gadsden 12039 4346 60 0 4286 30.57796289 -84.61915825 2021-01-08 05:22:42 Gadsden, Florida, US
2542094 2542094 2021-01-07 US Florida Gilchrist 12041 1078 25 0 1053 29.72856978 -82.79880657 2021-01-08 05:22:42 Gilchrist, Florida, US
2542095 2542095 2021-01-07 US Florida Glades 12043 798 11 0 787 26.95635849 -81.18996211 2021-01-08 05:22:42 Glades, Florida, US
2542096 2542096 2021-01-07 US Florida Gulf 12045 1424 29 0 1395 29.93543004 -85.24270990000002 2021-01-08 05:22:42 Gulf, Florida, US
2542097 2542097 2021-01-07 US Florida Hamilton 12047 1328 15 0 1313 30.49673973 -82.94998918 2021-01-08 05:22:42 Hamilton, Florida, US
2542098 2542098 2021-01-07 US Florida Hardee 12049 2216 21 0 2195 27.49293939 -81.80956574 2021-01-08 05:22:42 Hardee, Florida, US
2542099 2542099 2021-01-07 US Florida Hendry 12051 3501 52 0 3449 26.55386945 -81.16469006 2021-01-08 05:22:42 Hendry, Florida, US
2542100 2542100 2021-01-07 US Florida Hernando 12053 8041 287 0 7754 28.55364461 -82.42700204 2021-01-08 05:22:42 Hernando, Florida, US
2542101 2542101 2021-01-07 US Florida Highlands 12055 5358 212 0 5146 27.34254618 -81.34071957 2021-01-08 05:22:42 Highlands, Florida, US
2542102 2542102 2021-01-07 US Florida Hillsborough 12057 83574 1110 0 82464 27.9276559 -82.32013172 2021-01-08 05:22:42 Hillsborough, Florida, US
2542103 2542103 2021-01-07 US Florida Holmes 12059 1839 30 0 1809 30.86747479 -85.81319222 2021-01-08 05:22:42 Holmes, Florida, US
2542104 2542104 2021-01-07 US Florida Indian River 12061 7737 166 0 7571 27.69308961 -80.60556721 2021-01-08 05:22:42 Indian River, Florida, US
2542105 2542105 2021-01-07 US Florida Jackson 12063 4948 120 0 4828 30.7954597 -85.21500423 2021-01-08 05:22:42 Jackson, Florida, US
2542106 2542106 2021-01-07 US Florida Jefferson 12065 1090 18 0 1072 30.43669112 -83.89442308 2021-01-08 05:22:42 Jefferson, Florida, US
2542107 2542107 2021-01-07 US Florida Lafayette 12067 1448 21 0 1427 29.98484137 -83.18166636 2021-01-08 05:22:42 Lafayette, Florida, US
2542108 2542108 2021-01-07 US Florida Lake 12069 17228 331 0 16897 28.76202069 -81.7125123 2021-01-08 05:22:42 Lake, Florida, US
2542109 2542109 2021-01-07 US Florida Lee 12071 43871 695 0 43176 26.58410348 -81.88399313 2021-01-08 05:22:42 Lee, Florida, US
2542110 2542110 2021-01-07 US Florida Leon 12073 21337 177 0 21160 30.45955727 -84.27491114 2021-01-08 05:22:42 Leon, Florida, US
2542111 2542111 2021-01-07 US Florida Levy 12075 2079 20 0 2059 29.31829741 -82.74007147 2021-01-08 05:22:42 Levy, Florida, US
2542112 2542112 2021-01-07 US Florida Liberty 12077 827 14 0 813 30.23766008 -84.8829258 2021-01-08 05:22:42 Liberty, Florida, US
2542113 2542113 2021-01-07 US Florida Madison 12079 1604 33 0 1571 30.44396917 -83.47398594 2021-01-08 05:22:42 Madison, Florida, US
2542114 2542114 2021-01-07 US Florida Manatee 12081 24000 438 0 23562 27.47196942 -82.31831044 2021-01-08 05:22:42 Manatee, Florida, US
2542115 2542115 2021-01-07 US Florida Marion 12083 19585 496 0 19089 29.21227113 -82.05803627 2021-01-08 05:22:42 Marion, Florida, US
2542116 2542116 2021-01-07 US Florida Martin 12085 8380 213 0 8167 27.0772071 -80.43109784 2021-01-08 05:22:42 Martin, Florida, US
2542117 2542117 2021-01-07 US Florida Miami-Dade 12086 318115 4297 0 313818 25.6112362 -80.55170587 2021-01-08 05:22:42 Miami-Dade, Florida, US
2542118 2542118 2021-01-07 US Florida Monroe 12087 4529 36 0 4493 25.20904673 -81.07812416 2021-01-08 05:22:42 Monroe, Florida, US
2542119 2542119 2021-01-07 US Florida Nassau 12089 5449 68 0 5381 30.61037141 -81.80297522 2021-01-08 05:22:42 Nassau, Florida, US
2542120 2542120 2021-01-07 US Florida Okaloosa 12091 13756 240 0 13516 30.69143028 -86.59267105 2021-01-08 05:22:42 Okaloosa, Florida, US
2542121 2542121 2021-01-07 US Florida Okeechobee 12093 2620 54 0 2566 27.386336199999995 -80.88944347 2021-01-08 05:22:42 Okeechobee, Florida, US
2542122 2542122 2021-01-07 US Florida Orange 12095 83462 777 0 82685 28.51367621 -81.31799498 2021-01-08 05:22:42 Orange, Florida, US
2542123 2542123 2021-01-07 US Florida Osceola 12097 27569 305 0 27264 28.06312234 -81.14882926 2021-01-08 05:22:42 Osceola, Florida, US
2542124 2542124 2021-01-07 US Florida Palm Beach 12099 88852 1933 0 86919 26.64676272 -80.46536002 2021-01-08 05:22:42 Palm Beach, Florida, US
2542125 2542125 2021-01-07 US Florida Pasco 12101 23948 402 0 23546 28.30810945 -82.40227529 2021-01-08 05:22:42 Pasco, Florida, US
2542126 2542126 2021-01-07 US Florida Pinellas 12103 48998 1114 0 47884 27.93130349 -82.72239666 2021-01-08 05:22:42 Pinellas, Florida, US
2542127 2542127 2021-01-07 US Florida Polk 12105 40983 821 0 40162 27.95027105 -81.69732947 2021-01-08 05:22:42 Polk, Florida, US
2542128 2542128 2021-01-07 US Florida Putnam 12107 4368 83 0 4285 29.60779729 -81.74230285 2021-01-08 05:22:42 Putnam, Florida, US
2542129 2542129 2021-01-07 US Florida Santa Rosa 12113 12310 143 0 12167 30.693414500000006 -87.02458128 2021-01-08 05:22:42 Santa Rosa, Florida, US
2542130 2542130 2021-01-07 US Florida Sarasota 12115 20512 514 0 19998 27.18546175 -82.33174248 2021-01-08 05:22:42 Sarasota, Florida, US
2542131 2542131 2021-01-07 US Florida Seminole 12117 19803 319 0 19484 28.7158582 -81.24060348 2021-01-08 05:22:42 Seminole, Florida, US
2542132 2542132 2021-01-07 US Florida St. Johns 12109 14697 118 0 14579 29.90096506 -81.43589967 2021-01-08 05:22:42 St. Johns, Florida, US
2542133 2542133 2021-01-07 US Florida St. Lucie 12111 15701 424 0 15277 27.37763908 -80.47106649 2021-01-08 05:22:42 St. Lucie, Florida, US
2542134 2542134 2021-01-07 US Florida Sumter 12119 5720 122 0 5598 28.70181754 -82.0794267 2021-01-08 05:22:42 Sumter, Florida, US
2542135 2542135 2021-01-07 US Florida Suwannee 12121 4311 95 0 4216 30.19746066 -82.99099670000003 2021-01-08 05:22:42 Suwannee, Florida, US
2542136 2542136 2021-01-07 US Florida Taylor 12123 2098 28 0 2070 30.04848048 -83.60445406 2021-01-08 05:22:42 Taylor, Florida, US
2542137 2542137 2021-01-07 US Florida Unassigned 90012 3147 0 0 3147 30.86747479 0.0 2021-01-08 05:22:42 Unassigned, Florida, US
2542138 2542138 2021-01-07 US Florida Union 12125 1515 65 0 1450 30.04412971 -82.37497443 2021-01-08 05:22:42 Union, Florida, US
2542139 2542139 2021-01-07 US Florida Volusia 12127 24553 460 0 24093 29.05858895 -81.18263252 2021-01-08 05:22:42 Volusia, Florida, US
2542140 2542140 2021-01-07 US Florida Wakulla 12129 2341 25 0 2316 30.16548905 -84.39895211 2021-01-08 05:22:42 Wakulla, Florida, US
2542141 2542141 2021-01-07 US Florida Walton 12131 5339 52 0 5287 30.64204028 -86.16935664 2021-01-08 05:22:42 Walton, Florida, US
2542142 2542142 2021-01-07 US Florida Washington 12133 2118 30 0 2088 30.61359259 -85.66002461 2021-01-08 05:22:42 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]);