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-03-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
2208323 2208323 2021-03-04 US Florida Alachua 12001 22512 235 0 22277 29.67866525 -82.35928158 2021-03-05 05:26:29 Alachua, Florida, US
2208324 2208324 2021-03-04 US Florida Baker 12003 3312 56 0 3256 30.33060121 -82.28467476 2021-03-05 05:26:29 Baker, Florida, US
2208325 2208325 2021-03-04 US Florida Bay 12005 18888 348 0 18540 30.26548745 -85.62122584 2021-03-05 05:26:29 Bay, Florida, US
2208326 2208326 2021-03-04 US Florida Bradford 12007 2858 52 0 2806 29.95079741 -82.16611613 2021-03-05 05:26:29 Bradford, Florida, US
2208327 2208327 2021-03-04 US Florida Brevard 12009 34434 751 0 33683 28.29409504 -80.73091022 2021-03-05 05:26:29 Brevard, Florida, US
2208328 2208328 2021-03-04 US Florida Broward 12011 197542 2431 0 195111 26.15184651 -80.48725556 2021-03-05 05:26:29 Broward, Florida, US
2208329 2208329 2021-03-04 US Florida Calhoun 12013 1621 46 0 1575 30.40666734 -85.19394153 2021-03-05 05:26:29 Calhoun, Florida, US
2208330 2208330 2021-03-04 US Florida Charlotte 12015 10781 372 0 10409 26.90131002 -81.92949121 2021-03-05 05:26:29 Charlotte, Florida, US
2208331 2208331 2021-03-04 US Florida Citrus 12017 9836 406 0 9430 28.84804315 -82.47614748 2021-03-05 05:26:29 Citrus, Florida, US
2208332 2208332 2021-03-04 US Florida Clay 12019 16805 315 0 16490 29.98319144 -81.85609986 2021-03-05 05:26:29 Clay, Florida, US
2208333 2208333 2021-03-04 US Florida Collier 12021 30572 462 0 30110 26.11091986 -81.34687065 2021-03-05 05:26:29 Collier, Florida, US
2208334 2208334 2021-03-04 US Florida Columbia 12023 7706 160 0 7546 30.22509788 -82.62160164 2021-03-05 05:26:29 Columbia, Florida, US
2208335 2208335 2021-03-04 US Florida DeSoto 12027 3841 75 0 3766 27.18677893 -81.80941373 2021-03-05 05:26:29 DeSoto, Florida, US
2208336 2208336 2021-03-04 US Florida Dixie 12029 1504 21 0 1483 29.60631086 -83.15724673 2021-03-05 05:26:29 Dixie, Florida, US
2208337 2208337 2021-03-04 US Florida Duval 12031 89337 1188 0 88149 30.33225875 -81.66976468 2021-03-05 05:26:29 Duval, Florida, US
2208338 2208338 2021-03-04 US Florida Escambia 12033 33959 635 0 33324 30.67652764 -87.37284571 2021-03-05 05:26:29 Escambia, Florida, US
2208339 2208339 2021-03-04 US Florida Flagler 12035 6063 92 0 5971 29.45933576 -81.31508595 2021-03-05 05:26:29 Flagler, Florida, US
2208340 2208340 2021-03-04 US Florida Franklin 12037 1279 17 0 1262 29.83791238 -84.82731662 2021-03-05 05:26:29 Franklin, Florida, US
2208341 2208341 2021-03-04 US Florida Gadsden 12039 5472 87 0 5385 30.57796289 -84.61915825 2021-03-05 05:26:29 Gadsden, Florida, US
2208342 2208342 2021-03-04 US Florida Gilchrist 12041 1424 36 0 1388 29.72856978 -82.79880657 2021-03-05 05:26:29 Gilchrist, Florida, US
2208343 2208343 2021-03-04 US Florida Glades 12043 905 15 0 890 26.95635849 -81.18996211 2021-03-05 05:26:29 Glades, Florida, US
2208344 2208344 2021-03-04 US Florida Gulf 12045 1875 41 0 1834 29.93543004 -85.24270990000002 2021-03-05 05:26:29 Gulf, Florida, US
2208345 2208345 2021-03-04 US Florida Hamilton 12047 1571 22 0 1549 30.49673973 -82.94998918 2021-03-05 05:26:29 Hamilton, Florida, US
2208346 2208346 2021-03-04 US Florida Hardee 12049 2809 31 0 2778 27.49293939 -81.80956574 2021-03-05 05:26:29 Hardee, Florida, US
2208347 2208347 2021-03-04 US Florida Hendry 12051 4338 73 0 4265 26.55386945 -81.16469006 2021-03-05 05:26:29 Hendry, Florida, US
2208348 2208348 2021-03-04 US Florida Hernando 12053 11464 403 0 11061 28.55364461 -82.42700204 2021-03-05 05:26:29 Hernando, Florida, US
2208349 2208349 2021-03-04 US Florida Highlands 12055 7307 308 0 6999 27.34254618 -81.34071957 2021-03-05 05:26:29 Highlands, Florida, US
2208350 2208350 2021-03-04 US Florida Hillsborough 12057 112672 1523 0 111149 27.9276559 -82.32013172 2021-03-05 05:26:29 Hillsborough, Florida, US
2208351 2208351 2021-03-04 US Florida Holmes 12059 2193 44 0 2149 30.86747479 -85.81319222 2021-03-05 05:26:29 Holmes, Florida, US
2208352 2208352 2021-03-04 US Florida Indian River 12061 11138 267 0 10871 27.69308961 -80.60556721 2021-03-05 05:26:29 Indian River, Florida, US
2208353 2208353 2021-03-04 US Florida Jackson 12063 5947 152 0 5795 30.7954597 -85.21500423 2021-03-05 05:26:29 Jackson, Florida, US
2208354 2208354 2021-03-04 US Florida Jefferson 12065 1409 24 0 1385 30.43669112 -83.89442308 2021-03-05 05:26:29 Jefferson, Florida, US
2208355 2208355 2021-03-04 US Florida Lafayette 12067 1594 24 0 1570 29.98484137 -83.18166636 2021-03-05 05:26:29 Lafayette, Florida, US
2208356 2208356 2021-03-04 US Florida Lake 12069 24928 574 0 24354 28.76202069 -81.7125123 2021-03-05 05:26:29 Lake, Florida, US
2208357 2208357 2021-03-04 US Florida Lee 12071 58360 883 0 57477 26.58410348 -81.88399313 2021-03-05 05:26:29 Lee, Florida, US
2208358 2208358 2021-03-04 US Florida Leon 12073 29367 287 0 29080 30.45955727 -84.27491114 2021-03-05 05:26:29 Leon, Florida, US
2208359 2208359 2021-03-04 US Florida Levy 12075 2905 39 0 2866 29.31829741 -82.74007147 2021-03-05 05:26:29 Levy, Florida, US
2208360 2208360 2021-03-04 US Florida Liberty 12077 1045 16 0 1029 30.23766008 -84.8829258 2021-03-05 05:26:29 Liberty, Florida, US
2208361 2208361 2021-03-04 US Florida Madison 12079 2008 43 0 1965 30.44396917 -83.47398594 2021-03-05 05:26:29 Madison, Florida, US
2208362 2208362 2021-03-04 US Florida Manatee 12081 32309 608 0 31701 27.47196942 -82.31831044 2021-03-05 05:26:29 Manatee, Florida, US
2208363 2208363 2021-03-04 US Florida Marion 12083 27879 827 0 27052 29.21227113 -82.05803627 2021-03-05 05:26:29 Marion, Florida, US
2208364 2208364 2021-03-04 US Florida Martin 12085 10718 293 0 10425 27.0772071 -80.43109784 2021-03-05 05:26:29 Martin, Florida, US
2208365 2208365 2021-03-04 US Florida Miami-Dade 12086 416021 5511 0 410510 25.6112362 -80.55170587 2021-03-05 05:26:29 Miami-Dade, Florida, US
2208366 2208366 2021-03-04 US Florida Monroe 12087 5937 46 0 5891 25.20904673 -81.07812416 2021-03-05 05:26:29 Monroe, Florida, US
2208367 2208367 2021-03-04 US Florida Nassau 12089 7768 112 0 7656 30.61037141 -81.80297522 2021-03-05 05:26:29 Nassau, Florida, US
2208368 2208368 2021-03-04 US Florida Okaloosa 12091 19125 328 0 18797 30.69143028 -86.59267105 2021-03-05 05:26:29 Okaloosa, Florida, US
2208369 2208369 2021-03-04 US Florida Okeechobee 12093 3583 81 0 3502 27.386336199999995 -80.88944347 2021-03-05 05:26:29 Okeechobee, Florida, US
2208370 2208370 2021-03-04 US Florida Orange 12095 115475 1116 0 114359 28.51367621 -81.31799498 2021-03-05 05:26:29 Orange, Florida, US
2208371 2208371 2021-03-04 US Florida Osceola 12097 37188 449 0 36739 28.06312234 -81.14882926 2021-03-05 05:26:29 Osceola, Florida, US
2208372 2208372 2021-03-04 US Florida Palm Beach 12099 122226 2498 0 119728 26.64676272 -80.46536002 2021-03-05 05:26:29 Palm Beach, Florida, US
2208373 2208373 2021-03-04 US Florida Pasco 12101 33778 664 0 33114 28.30810945 -82.40227529 2021-03-05 05:26:29 Pasco, Florida, US
2208374 2208374 2021-03-04 US Florida Pinellas 12103 67359 1465 0 65894 27.93130349 -82.72239666 2021-03-05 05:26:29 Pinellas, Florida, US
2208375 2208375 2021-03-04 US Florida Polk 12105 57655 1164 0 56491 27.95027105 -81.69732947 2021-03-05 05:26:29 Polk, Florida, US
2208376 2208376 2021-03-04 US Florida Putnam 12107 5874 128 0 5746 29.60779729 -81.74230285 2021-03-05 05:26:29 Putnam, Florida, US
2208377 2208377 2021-03-04 US Florida Santa Rosa 12113 17252 267 0 16985 30.693414500000006 -87.02458128 2021-03-05 05:26:29 Santa Rosa, Florida, US
2208378 2208378 2021-03-04 US Florida Sarasota 12115 27301 749 0 26552 27.18546175 -82.33174248 2021-03-05 05:26:29 Sarasota, Florida, US
2208379 2208379 2021-03-04 US Florida Seminole 12117 27554 437 0 27117 28.7158582 -81.24060348 2021-03-05 05:26:29 Seminole, Florida, US
2208380 2208380 2021-03-04 US Florida St. Johns 12109 20242 199 0 20043 29.90096506 -81.43589967 2021-03-05 05:26:29 St. Johns, Florida, US
2208381 2208381 2021-03-04 US Florida St. Lucie 12111 22445 551 0 21894 27.37763908 -80.47106649 2021-03-05 05:26:29 St. Lucie, Florida, US
2208382 2208382 2021-03-04 US Florida Sumter 12119 8125 243 0 7882 28.70181754 -82.0794267 2021-03-05 05:26:29 Sumter, Florida, US
2208383 2208383 2021-03-04 US Florida Suwannee 12121 5130 133 0 4997 30.19746066 -82.99099670000003 2021-03-05 05:26:29 Suwannee, Florida, US
2208384 2208384 2021-03-04 US Florida Taylor 12123 2651 42 0 2609 30.04848048 -83.60445406 2021-03-05 05:26:29 Taylor, Florida, US
2208385 2208385 2021-03-04 US Florida Unassigned 90012 3493 0 0 3493 30.86747479 0.0 2021-03-05 05:26:29 Unassigned, Florida, US
2208386 2208386 2021-03-04 US Florida Union 12125 1742 70 0 1672 30.04412971 -82.37497443 2021-03-05 05:26:29 Union, Florida, US
2208387 2208387 2021-03-04 US Florida Volusia 12127 34891 671 0 34220 29.05858895 -81.18263252 2021-03-05 05:26:29 Volusia, Florida, US
2208388 2208388 2021-03-04 US Florida Wakulla 12129 3183 52 0 3131 30.16548905 -84.39895211 2021-03-05 05:26:29 Wakulla, Florida, US
2208389 2208389 2021-03-04 US Florida Walton 12131 7113 81 0 7032 30.64204028 -86.16935664 2021-03-05 05:26:29 Walton, Florida, US
2208390 2208390 2021-03-04 US Florida Washington 12133 2634 48 0 2586 30.61359259 -85.66002461 2021-03-05 05:26:29 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]);