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-16 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
3102109 3102109 2021-01-16 US Florida Alachua 12001 18655 145 0 18510 29.67866525 -82.35928158 2021-01-17 05:22:17 Alachua, Florida, US
3102110 3102110 2021-01-16 US Florida Baker 12003 2814 40 0 2774 30.33060121 -82.28467476 2021-01-17 05:22:17 Baker, Florida, US
3102111 3102111 2021-01-16 US Florida Bay 12005 13949 255 0 13694 30.26548745 -85.62122584 2021-01-17 05:22:17 Bay, Florida, US
3102112 3102112 2021-01-16 US Florida Bradford 12007 2486 26 0 2460 29.95079741 -82.16611613 2021-01-17 05:22:17 Bradford, Florida, US
3102113 3102113 2021-01-16 US Florida Brevard 12009 25831 578 0 25253 28.29409504 -80.73091022 2021-01-17 05:22:17 Brevard, Florida, US
3102114 3102114 2021-01-16 US Florida Broward 12011 157590 1957 0 155633 26.15184651 -80.48725556 2021-01-17 05:22:17 Broward, Florida, US
3102115 3102115 2021-01-16 US Florida Calhoun 12013 1438 32 0 1406 30.40666734 -85.19394153 2021-01-17 05:22:17 Calhoun, Florida, US
3102116 3102116 2021-01-16 US Florida Charlotte 12015 8921 258 0 8663 26.90131002 -81.92949121 2021-01-17 05:22:17 Charlotte, Florida, US
3102117 3102117 2021-01-16 US Florida Citrus 12017 7861 308 0 7553 28.84804315 -82.47614748 2021-01-17 05:22:17 Citrus, Florida, US
3102118 3102118 2021-01-16 US Florida Clay 12019 13904 221 0 13683 29.98319144 -81.85609986 2021-01-17 05:22:17 Clay, Florida, US
3102119 3102119 2021-01-16 US Florida Collier 12021 25645 375 0 25270 26.11091986 -81.34687065 2021-01-17 05:22:17 Collier, Florida, US
3102120 3102120 2021-01-16 US Florida Columbia 12023 6800 131 0 6669 30.22509788 -82.62160164 2021-01-17 05:22:17 Columbia, Florida, US
3102121 3102121 2021-01-16 US Florida DeSoto 12027 3201 66 0 3135 27.18677893 -81.80941373 2021-01-17 05:22:17 DeSoto, Florida, US
3102122 3102122 2021-01-16 US Florida Dixie 12029 1310 11 0 1299 29.60631086 -83.15724673 2021-01-17 05:22:17 Dixie, Florida, US
3102123 3102123 2021-01-16 US Florida Duval 12031 74553 800 0 73753 30.33225875 -81.66976468 2021-01-17 05:22:17 Duval, Florida, US
3102124 3102124 2021-01-16 US Florida Escambia 12033 27242 448 0 26794 30.67652764 -87.37284571 2021-01-17 05:22:17 Escambia, Florida, US
3102125 3102125 2021-01-16 US Florida Flagler 12035 4672 52 0 4620 29.45933576 -81.31508595 2021-01-17 05:22:17 Flagler, Florida, US
3102126 3102126 2021-01-16 US Florida Franklin 12037 1105 4 0 1101 29.83791238 -84.82731662 2021-01-17 05:22:17 Franklin, Florida, US
3102127 3102127 2021-01-16 US Florida Gadsden 12039 4732 64 0 4668 30.57796289 -84.61915825 2021-01-17 05:22:17 Gadsden, Florida, US
3102128 3102128 2021-01-16 US Florida Gilchrist 12041 1124 27 0 1097 29.72856978 -82.79880657 2021-01-17 05:22:17 Gilchrist, Florida, US
3102129 3102129 2021-01-16 US Florida Glades 12043 833 12 0 821 26.95635849 -81.18996211 2021-01-17 05:22:17 Glades, Florida, US
3102130 3102130 2021-01-16 US Florida Gulf 12045 1539 31 0 1508 29.93543004 -85.24270990000002 2021-01-17 05:22:17 Gulf, Florida, US
3102131 3102131 2021-01-16 US Florida Hamilton 12047 1412 15 0 1397 30.49673973 -82.94998918 2021-01-17 05:22:17 Hamilton, Florida, US
3102132 3102132 2021-01-16 US Florida Hardee 12049 2387 22 0 2365 27.49293939 -81.80956574 2021-01-17 05:22:17 Hardee, Florida, US
3102133 3102133 2021-01-16 US Florida Hendry 12051 3784 53 0 3731 26.55386945 -81.16469006 2021-01-17 05:22:17 Hendry, Florida, US
3102134 3102134 2021-01-16 US Florida Hernando 12053 8881 311 0 8570 28.55364461 -82.42700204 2021-01-17 05:22:17 Hernando, Florida, US
3102135 3102135 2021-01-16 US Florida Highlands 12055 5833 231 0 5602 27.34254618 -81.34071957 2021-01-17 05:22:17 Highlands, Florida, US
3102136 3102136 2021-01-16 US Florida Hillsborough 12057 91632 1175 0 90457 27.9276559 -82.32013172 2021-01-17 05:22:17 Hillsborough, Florida, US
3102137 3102137 2021-01-16 US Florida Holmes 12059 1964 32 0 1932 30.86747479 -85.81319222 2021-01-17 05:22:17 Holmes, Florida, US
3102138 3102138 2021-01-16 US Florida Indian River 12061 8682 189 0 8493 27.69308961 -80.60556721 2021-01-17 05:22:17 Indian River, Florida, US
3102139 3102139 2021-01-16 US Florida Jackson 12063 5296 122 0 5174 30.7954597 -85.21500423 2021-01-17 05:22:17 Jackson, Florida, US
3102140 3102140 2021-01-16 US Florida Jefferson 12065 1176 18 0 1158 30.43669112 -83.89442308 2021-01-17 05:22:17 Jefferson, Florida, US
3102141 3102141 2021-01-16 US Florida Lafayette 12067 1490 23 0 1467 29.98484137 -83.18166636 2021-01-17 05:22:17 Lafayette, Florida, US
3102142 3102142 2021-01-16 US Florida Lake 12069 19208 377 0 18831 28.76202069 -81.7125123 2021-01-17 05:22:17 Lake, Florida, US
3102143 3102143 2021-01-16 US Florida Lee 12071 47803 727 0 47076 26.58410348 -81.88399313 2021-01-17 05:22:17 Lee, Florida, US
3102144 3102144 2021-01-16 US Florida Leon 12073 23394 201 0 23193 30.45955727 -84.27491114 2021-01-17 05:22:17 Leon, Florida, US
3102145 3102145 2021-01-16 US Florida Levy 12075 2311 22 0 2289 29.31829741 -82.74007147 2021-01-17 05:22:17 Levy, Florida, US
3102146 3102146 2021-01-16 US Florida Liberty 12077 926 14 0 912 30.23766008 -84.8829258 2021-01-17 05:22:17 Liberty, Florida, US
3102147 3102147 2021-01-16 US Florida Madison 12079 1697 34 0 1663 30.44396917 -83.47398594 2021-01-17 05:22:17 Madison, Florida, US
3102148 3102148 2021-01-16 US Florida Manatee 12081 25881 456 0 25425 27.47196942 -82.31831044 2021-01-17 05:22:17 Manatee, Florida, US
3102149 3102149 2021-01-16 US Florida Marion 12083 22030 534 0 21496 29.21227113 -82.05803627 2021-01-17 05:22:17 Marion, Florida, US
3102150 3102150 2021-01-16 US Florida Martin 12085 8964 228 0 8736 27.0772071 -80.43109784 2021-01-17 05:22:17 Martin, Florida, US
3102151 3102151 2021-01-16 US Florida Miami-Dade 12086 341842 4561 0 337281 25.6112362 -80.55170587 2021-01-17 05:22:17 Miami-Dade, Florida, US
3102152 3102152 2021-01-16 US Florida Monroe 12087 4917 37 0 4880 25.20904673 -81.07812416 2021-01-17 05:22:17 Monroe, Florida, US
3102153 3102153 2021-01-16 US Florida Nassau 12089 6204 73 0 6131 30.61037141 -81.80297522 2021-01-17 05:22:17 Nassau, Florida, US
3102154 3102154 2021-01-16 US Florida Okaloosa 12091 15107 257 0 14850 30.69143028 -86.59267105 2021-01-17 05:22:17 Okaloosa, Florida, US
3102155 3102155 2021-01-16 US Florida Okeechobee 12093 2961 56 0 2905 27.386336199999995 -80.88944347 2021-01-17 05:22:17 Okeechobee, Florida, US
3102156 3102156 2021-01-16 US Florida Orange 12095 92439 828 0 91611 28.51367621 -81.31799498 2021-01-17 05:22:17 Orange, Florida, US
3102157 3102157 2021-01-16 US Florida Osceola 12097 30293 330 0 29963 28.06312234 -81.14882926 2021-01-17 05:22:17 Osceola, Florida, US
3102158 3102158 2021-01-16 US Florida Palm Beach 12099 96743 2033 0 94710 26.64676272 -80.46536002 2021-01-17 05:22:17 Palm Beach, Florida, US
3102159 3102159 2021-01-16 US Florida Pasco 12101 26584 453 0 26131 28.30810945 -82.40227529 2021-01-17 05:22:17 Pasco, Florida, US
3102160 3102160 2021-01-16 US Florida Pinellas 12103 53882 1173 0 52709 27.93130349 -82.72239666 2021-01-17 05:22:17 Pinellas, Florida, US
3102161 3102161 2021-01-16 US Florida Polk 12105 45224 887 0 44337 27.95027105 -81.69732947 2021-01-17 05:22:17 Polk, Florida, US
3102162 3102162 2021-01-16 US Florida Putnam 12107 4991 87 0 4904 29.60779729 -81.74230285 2021-01-17 05:22:17 Putnam, Florida, US
3102163 3102163 2021-01-16 US Florida Santa Rosa 12113 13698 177 0 13521 30.693414500000006 -87.02458128 2021-01-17 05:22:17 Santa Rosa, Florida, US
3102164 3102164 2021-01-16 US Florida Sarasota 12115 22518 560 0 21958 27.18546175 -82.33174248 2021-01-17 05:22:17 Sarasota, Florida, US
3102165 3102165 2021-01-16 US Florida Seminole 12117 21791 335 0 21456 28.7158582 -81.24060348 2021-01-17 05:22:17 Seminole, Florida, US
3102166 3102166 2021-01-16 US Florida St. Johns 12109 16460 136 0 16324 29.90096506 -81.43589967 2021-01-17 05:22:17 St. Johns, Florida, US
3102167 3102167 2021-01-16 US Florida St. Lucie 12111 17521 449 0 17072 27.37763908 -80.47106649 2021-01-17 05:22:17 St. Lucie, Florida, US
3102168 3102168 2021-01-16 US Florida Sumter 12119 6363 156 0 6207 28.70181754 -82.0794267 2021-01-17 05:22:17 Sumter, Florida, US
3102169 3102169 2021-01-16 US Florida Suwannee 12121 4575 100 0 4475 30.19746066 -82.99099670000003 2021-01-17 05:22:17 Suwannee, Florida, US
3102170 3102170 2021-01-16 US Florida Taylor 12123 2264 29 0 2235 30.04848048 -83.60445406 2021-01-17 05:22:17 Taylor, Florida, US
3102171 3102171 2021-01-16 US Florida Unassigned 90012 3287 0 0 3287 30.86747479 0.0 2021-01-17 05:22:17 Unassigned, Florida, US
3102172 3102172 2021-01-16 US Florida Union 12125 1609 69 0 1540 30.04412971 -82.37497443 2021-01-17 05:22:17 Union, Florida, US
3102173 3102173 2021-01-16 US Florida Volusia 12127 27250 472 0 26778 29.05858895 -81.18263252 2021-01-17 05:22:17 Volusia, Florida, US
3102174 3102174 2021-01-16 US Florida Wakulla 12129 2637 32 0 2605 30.16548905 -84.39895211 2021-01-17 05:22:17 Wakulla, Florida, US
3102175 3102175 2021-01-16 US Florida Walton 12131 5809 59 0 5750 30.64204028 -86.16935664 2021-01-17 05:22:17 Walton, Florida, US
3102176 3102176 2021-01-16 US Florida Washington 12133 2261 30 0 2231 30.61359259 -85.66002461 2021-01-17 05:22:17 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]);