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-26 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
2184252 2184252 2021-02-26 US Florida Alachua 12001 22293 228 0 22065 29.67866525 -82.35928158 2021-02-27 05:22:28 Alachua, Florida, US
2184253 2184253 2021-02-26 US Florida Baker 12003 3292 55 0 3237 30.33060121 -82.28467476 2021-02-27 05:22:28 Baker, Florida, US
2184254 2184254 2021-02-26 US Florida Bay 12005 18606 339 0 18267 30.26548745 -85.62122584 2021-02-27 05:22:28 Bay, Florida, US
2184255 2184255 2021-02-26 US Florida Bradford 12007 2845 52 0 2793 29.95079741 -82.16611613 2021-02-27 05:22:28 Bradford, Florida, US
2184256 2184256 2021-02-26 US Florida Brevard 12009 33739 738 0 33001 28.29409504 -80.73091022 2021-02-27 05:22:28 Brevard, Florida, US
2184257 2184257 2021-02-26 US Florida Broward 12011 193560 2369 0 191191 26.15184651 -80.48725556 2021-02-27 05:22:28 Broward, Florida, US
2184258 2184258 2021-02-26 US Florida Calhoun 12013 1607 40 0 1567 30.40666734 -85.19394153 2021-02-27 05:22:28 Calhoun, Florida, US
2184259 2184259 2021-02-26 US Florida Charlotte 12015 10642 359 0 10283 26.90131002 -81.92949121 2021-02-27 05:22:28 Charlotte, Florida, US
2184260 2184260 2021-02-26 US Florida Citrus 12017 9716 397 0 9319 28.84804315 -82.47614748 2021-02-27 05:22:28 Citrus, Florida, US
2184261 2184261 2021-02-26 US Florida Clay 12019 16673 304 0 16369 29.98319144 -81.85609986 2021-02-27 05:22:28 Clay, Florida, US
2184262 2184262 2021-02-26 US Florida Collier 12021 30144 459 0 29685 26.11091986 -81.34687065 2021-02-27 05:22:28 Collier, Florida, US
2184263 2184263 2021-02-26 US Florida Columbia 12023 7655 155 0 7500 30.22509788 -82.62160164 2021-02-27 05:22:28 Columbia, Florida, US
2184264 2184264 2021-02-26 US Florida DeSoto 12027 3769 73 0 3696 27.18677893 -81.80941373 2021-02-27 05:22:28 DeSoto, Florida, US
2184265 2184265 2021-02-26 US Florida Dixie 12029 1484 19 0 1465 29.60631086 -83.15724673 2021-02-27 05:22:28 Dixie, Florida, US
2184266 2184266 2021-02-26 US Florida Duval 12031 88430 1139 0 87291 30.33225875 -81.66976468 2021-02-27 05:22:28 Duval, Florida, US
2184267 2184267 2021-02-26 US Florida Escambia 12033 33556 628 0 32928 30.67652764 -87.37284571 2021-02-27 05:22:28 Escambia, Florida, US
2184268 2184268 2021-02-26 US Florida Flagler 12035 5898 89 0 5809 29.45933576 -81.31508595 2021-02-27 05:22:28 Flagler, Florida, US
2184269 2184269 2021-02-26 US Florida Franklin 12037 1278 14 0 1264 29.83791238 -84.82731662 2021-02-27 05:22:28 Franklin, Florida, US
2184270 2184270 2021-02-26 US Florida Gadsden 12039 5419 83 0 5336 30.57796289 -84.61915825 2021-02-27 05:22:28 Gadsden, Florida, US
2184271 2184271 2021-02-26 US Florida Gilchrist 12041 1397 33 0 1364 29.72856978 -82.79880657 2021-02-27 05:22:28 Gilchrist, Florida, US
2184272 2184272 2021-02-26 US Florida Glades 12043 902 15 0 887 26.95635849 -81.18996211 2021-02-27 05:22:28 Glades, Florida, US
2184273 2184273 2021-02-26 US Florida Gulf 12045 1860 39 0 1821 29.93543004 -85.24270990000002 2021-02-27 05:22:28 Gulf, Florida, US
2184274 2184274 2021-02-26 US Florida Hamilton 12047 1566 21 0 1545 30.49673973 -82.94998918 2021-02-27 05:22:28 Hamilton, Florida, US
2184275 2184275 2021-02-26 US Florida Hardee 12049 2783 29 0 2754 27.49293939 -81.80956574 2021-02-27 05:22:28 Hardee, Florida, US
2184276 2184276 2021-02-26 US Florida Hendry 12051 4289 72 0 4217 26.55386945 -81.16469006 2021-02-27 05:22:28 Hendry, Florida, US
2184277 2184277 2021-02-26 US Florida Hernando 12053 11212 398 0 10814 28.55364461 -82.42700204 2021-02-27 05:22:28 Hernando, Florida, US
2184278 2184278 2021-02-26 US Florida Highlands 12055 7206 299 0 6907 27.34254618 -81.34071957 2021-02-27 05:22:28 Highlands, Florida, US
2184279 2184279 2021-02-26 US Florida Hillsborough 12057 110837 1484 0 109353 27.9276559 -82.32013172 2021-02-27 05:22:28 Hillsborough, Florida, US
2184280 2184280 2021-02-26 US Florida Holmes 12059 2175 44 0 2131 30.86747479 -85.81319222 2021-02-27 05:22:28 Holmes, Florida, US
2184281 2184281 2021-02-26 US Florida Indian River 12061 10967 261 0 10706 27.69308961 -80.60556721 2021-02-27 05:22:28 Indian River, Florida, US
2184282 2184282 2021-02-26 US Florida Jackson 12063 5901 150 0 5751 30.7954597 -85.21500423 2021-02-27 05:22:28 Jackson, Florida, US
2184283 2184283 2021-02-26 US Florida Jefferson 12065 1402 24 0 1378 30.43669112 -83.89442308 2021-02-27 05:22:28 Jefferson, Florida, US
2184284 2184284 2021-02-26 US Florida Lafayette 12067 1586 24 0 1562 29.98484137 -83.18166636 2021-02-27 05:22:28 Lafayette, Florida, US
2184285 2184285 2021-02-26 US Florida Lake 12069 24445 554 0 23891 28.76202069 -81.7125123 2021-02-27 05:22:28 Lake, Florida, US
2184286 2184286 2021-02-26 US Florida Lee 12071 57469 872 0 56597 26.58410348 -81.88399313 2021-02-27 05:22:28 Lee, Florida, US
2184287 2184287 2021-02-26 US Florida Leon 12073 29053 283 0 28770 30.45955727 -84.27491114 2021-02-27 05:22:28 Leon, Florida, US
2184288 2184288 2021-02-26 US Florida Levy 12075 2863 35 0 2828 29.31829741 -82.74007147 2021-02-27 05:22:28 Levy, Florida, US
2184289 2184289 2021-02-26 US Florida Liberty 12077 1040 15 0 1025 30.23766008 -84.8829258 2021-02-27 05:22:28 Liberty, Florida, US
2184290 2184290 2021-02-26 US Florida Madison 12079 1986 42 0 1944 30.44396917 -83.47398594 2021-02-27 05:22:28 Madison, Florida, US
2184291 2184291 2021-02-26 US Florida Manatee 12081 31685 586 0 31099 27.47196942 -82.31831044 2021-02-27 05:22:28 Manatee, Florida, US
2184292 2184292 2021-02-26 US Florida Marion 12083 27485 782 0 26703 29.21227113 -82.05803627 2021-02-27 05:22:28 Marion, Florida, US
2184293 2184293 2021-02-26 US Florida Martin 12085 10536 276 0 10260 27.0772071 -80.43109784 2021-02-27 05:22:28 Martin, Florida, US
2184294 2184294 2021-02-26 US Florida Miami-Dade 12086 408096 5396 0 402700 25.6112362 -80.55170587 2021-02-27 05:22:28 Miami-Dade, Florida, US
2184295 2184295 2021-02-26 US Florida Monroe 12087 5799 46 0 5753 25.20904673 -81.07812416 2021-02-27 05:22:28 Monroe, Florida, US
2184296 2184296 2021-02-26 US Florida Nassau 12089 7701 112 0 7589 30.61037141 -81.80297522 2021-02-27 05:22:28 Nassau, Florida, US
2184297 2184297 2021-02-26 US Florida Okaloosa 12091 18725 327 0 18398 30.69143028 -86.59267105 2021-02-27 05:22:28 Okaloosa, Florida, US
2184298 2184298 2021-02-26 US Florida Okeechobee 12093 3548 75 0 3473 27.386336199999995 -80.88944347 2021-02-27 05:22:28 Okeechobee, Florida, US
2184299 2184299 2021-02-26 US Florida Orange 12095 113648 1091 0 112557 28.51367621 -81.31799498 2021-02-27 05:22:28 Orange, Florida, US
2184300 2184300 2021-02-26 US Florida Osceola 12097 36607 441 0 36166 28.06312234 -81.14882926 2021-02-27 05:22:28 Osceola, Florida, US
2184301 2184301 2021-02-26 US Florida Palm Beach 12099 119911 2454 0 117457 26.64676272 -80.46536002 2021-02-27 05:22:28 Palm Beach, Florida, US
2184302 2184302 2021-02-26 US Florida Pasco 12101 33139 646 0 32493 28.30810945 -82.40227529 2021-02-27 05:22:28 Pasco, Florida, US
2184303 2184303 2021-02-26 US Florida Pinellas 12103 66205 1438 0 64767 27.93130349 -82.72239666 2021-02-27 05:22:28 Pinellas, Florida, US
2184304 2184304 2021-02-26 US Florida Polk 12105 56759 1137 0 55622 27.95027105 -81.69732947 2021-02-27 05:22:28 Polk, Florida, US
2184305 2184305 2021-02-26 US Florida Putnam 12107 5828 126 0 5702 29.60779729 -81.74230285 2021-02-27 05:22:28 Putnam, Florida, US
2184306 2184306 2021-02-26 US Florida Santa Rosa 12113 17020 257 0 16763 30.693414500000006 -87.02458128 2021-02-27 05:22:28 Santa Rosa, Florida, US
2184307 2184307 2021-02-26 US Florida Sarasota 12115 26882 730 0 26152 27.18546175 -82.33174248 2021-02-27 05:22:28 Sarasota, Florida, US
2184308 2184308 2021-02-26 US Florida Seminole 12117 27057 422 0 26635 28.7158582 -81.24060348 2021-02-27 05:22:28 Seminole, Florida, US
2184309 2184309 2021-02-26 US Florida St. Johns 12109 20007 191 0 19816 29.90096506 -81.43589967 2021-02-27 05:22:28 St. Johns, Florida, US
2184310 2184310 2021-02-26 US Florida St. Lucie 12111 22015 544 0 21471 27.37763908 -80.47106649 2021-02-27 05:22:28 St. Lucie, Florida, US
2184311 2184311 2021-02-26 US Florida Sumter 12119 7965 238 0 7727 28.70181754 -82.0794267 2021-02-27 05:22:28 Sumter, Florida, US
2184312 2184312 2021-02-26 US Florida Suwannee 12121 5108 131 0 4977 30.19746066 -82.99099670000003 2021-02-27 05:22:28 Suwannee, Florida, US
2184313 2184313 2021-02-26 US Florida Taylor 12123 2632 41 0 2591 30.04848048 -83.60445406 2021-02-27 05:22:28 Taylor, Florida, US
2184314 2184314 2021-02-26 US Florida Unassigned 90012 3454 0 0 3454 30.86747479 0.0 2021-02-27 05:22:28 Unassigned, Florida, US
2184315 2184315 2021-02-26 US Florida Union 12125 1740 70 0 1670 30.04412971 -82.37497443 2021-02-27 05:22:28 Union, Florida, US
2184316 2184316 2021-02-26 US Florida Volusia 12127 34338 654 0 33684 29.05858895 -81.18263252 2021-02-27 05:22:28 Volusia, Florida, US
2184317 2184317 2021-02-26 US Florida Wakulla 12129 3153 51 0 3102 30.16548905 -84.39895211 2021-02-27 05:22:28 Wakulla, Florida, US
2184318 2184318 2021-02-26 US Florida Walton 12131 7017 81 0 6936 30.64204028 -86.16935664 2021-02-27 05:22:28 Walton, Florida, US
2184319 2184319 2021-02-26 US Florida Washington 12133 2618 47 0 2571 30.61359259 -85.66002461 2021-02-27 05:22:28 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]);