johns_hopkins_csse_daily_reports

⚠️ 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

9,472 rows where province_or_state = "Florida" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Florida · 9,472

country_or_region

  • US 9,472
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391110 2020-08-08 US Florida Alachua 12001 4088 26 0 4062 29.67866525 -82.35928158 2020-08-09 04:34:54 Alachua, Florida, US
391206 2020-08-08 US Florida Baker 12003 827 4 0 823 30.33060121 -82.28467476 2020-08-09 04:34:54 Baker, Florida, US
391242 2020-08-08 US Florida Bay 12005 4388 51 0 4337 30.26548745 -85.62122584 2020-08-09 04:34:54 Bay, Florida, US
391348 2020-08-08 US Florida Bradford 12007 469 4 0 465 29.95079741 -82.16611613 2020-08-09 04:34:54 Bradford, Florida, US
391360 2020-08-08 US Florida Brevard 12009 5963 142 0 5821 28.29409504 -80.73091022 2020-08-09 04:34:54 Brevard, Florida, US
391374 2020-08-08 US Florida Broward 12011 61614 789 0 60825 26.15184651 -80.48725556 2020-08-09 04:34:54 Broward, Florida, US
391440 2020-08-08 US Florida Calhoun 12013 462 7 0 455 30.40666734 -85.19394153 2020-08-09 04:34:54 Calhoun, Florida, US
391549 2020-08-08 US Florida Charlotte 12015 2214 91 0 2123 26.90131002 -81.92949121 2020-08-09 04:34:54 Charlotte, Florida, US
391609 2020-08-08 US Florida Citrus 12017 1514 36 0 1478 28.84804315 -82.47614748 2020-08-09 04:34:54 Citrus, Florida, US
391638 2020-08-08 US Florida Clay 12019 3245 51 0 3194 29.98319144 -81.85609986 2020-08-09 04:34:54 Clay, Florida, US
391698 2020-08-08 US Florida Collier 12021 10265 133 0 10132 26.11091986 -81.34687065 2020-08-09 04:34:54 Collier, Florida, US
391705 2020-08-08 US Florida Columbia 12023 2835 15 0 2820 30.22509788 -82.62160164 2020-08-09 04:34:54 Columbia, Florida, US
391845 2020-08-08 US Florida DeSoto 12027 1339 16 0 1323 27.18677893 -81.80941373 2020-08-09 04:34:54 DeSoto, Florida, US
391891 2020-08-08 US Florida Dixie 12029 475 4 0 471 29.60631086 -83.15724673 2020-08-09 04:34:54 Dixie, Florida, US
391932 2020-08-08 US Florida Duval 12031 23166 188 0 22978 30.33225875 -81.66976468 2020-08-09 04:34:54 Duval, Florida, US
391983 2020-08-08 US Florida Escambia 12033 9297 120 0 9177 30.67652764 -87.37284571 2020-08-09 04:34:54 Escambia, Florida, US
392031 2020-08-08 US Florida Flagler 12035 1052 13 0 1039 29.45933576 -81.31508595 2020-08-09 04:34:54 Flagler, Florida, US
392058 2020-08-08 US Florida Franklin 12037 398 2 0 396 29.83791238 -84.82731662 2020-08-09 04:34:54 Franklin, Florida, US
392103 2020-08-08 US Florida Gadsden 12039 1866 21 0 1845 30.57796289 -84.61915825 2020-08-09 04:34:54 Gadsden, Florida, US
392138 2020-08-08 US Florida Gilchrist 12041 355 3 0 352 29.72856978 -82.79880657 2020-08-09 04:34:54 Gilchrist, Florida, US
392147 2020-08-08 US Florida Glades 12043 401 3 0 398 26.95635849 -81.18996211 2020-08-09 04:34:54 Glades, Florida, US
392247 2020-08-08 US Florida Gulf 12045 599 2 0 597 29.93543004 -85.24270990000002 2020-08-09 04:34:54 Gulf, Florida, US
392263 2020-08-08 US Florida Hamilton 12047 617 4 0 613 30.49673973 -82.94998918 2020-08-09 04:34:54 Hamilton, Florida, US
392294 2020-08-08 US Florida Hardee 12049 950 7 0 943 27.49293939 -81.80956574 2020-08-09 04:34:54 Hardee, Florida, US
392348 2020-08-08 US Florida Hendry 12051 1750 38 0 1712 26.55386945 -81.16469006 2020-08-09 04:34:54 Hendry, Florida, US
392362 2020-08-08 US Florida Hernando 12053 1975 47 0 1928 28.55364461 -82.42700204 2020-08-09 04:34:54 Hernando, Florida, US
392372 2020-08-08 US Florida Highlands 12055 1396 37 0 1359 27.34254618 -81.34071957 2020-08-09 04:34:54 Highlands, Florida, US
392375 2020-08-08 US Florida Hillsborough 12057 32268 388 0 31880 27.9276559 -82.32013172 2020-08-09 04:34:54 Hillsborough, Florida, US
392385 2020-08-08 US Florida Holmes 12059 494 2 0 492 30.86747479 -85.81319222 2020-08-09 04:34:54 Holmes, Florida, US
392443 2020-08-08 US Florida Indian River 12061 2488 55 0 2433 27.69308961 -80.60556721 2020-08-09 04:34:54 Indian River, Florida, US
392471 2020-08-08 US Florida Jackson 12063 1817 37 0 1780 30.7954597 -85.21500423 2020-08-09 04:34:54 Jackson, Florida, US
392508 2020-08-08 US Florida Jefferson 12065 448 5 0 443 30.43669112 -83.89442308 2020-08-09 04:34:54 Jefferson, Florida, US
392658 2020-08-08 US Florida Lafayette 12067 134 1 0 133 29.98484137 -83.18166636 2020-08-09 04:34:54 Lafayette, Florida, US
392667 2020-08-08 US Florida Lake 12069 5073 67 0 5006 28.76202069 -81.7125123 2020-08-09 04:34:54 Lake, Florida, US
392731 2020-08-08 US Florida Lee 12071 16431 334 0 16097 26.58410348 -81.88399313 2020-08-09 04:34:54 Lee, Florida, US
392747 2020-08-08 US Florida Leon 12073 4922 24 0 4898 30.45955727 -84.27491114 2020-08-09 04:34:54 Leon, Florida, US
392751 2020-08-08 US Florida Levy 12075 673 4 0 669 29.31829741 -82.74007147 2020-08-09 04:34:54 Levy, Florida, US
392761 2020-08-08 US Florida Liberty 12077 400 6 0 394 30.23766008 -84.8829258 2020-08-09 04:34:54 Liberty, Florida, US
392863 2020-08-08 US Florida Madison 12079 700 8 0 692 30.44396917 -83.47398594 2020-08-09 04:34:54 Madison, Florida, US
392889 2020-08-08 US Florida Manatee 12081 9199 191 0 9008 27.47196942 -82.31831044 2020-08-09 04:34:54 Manatee, Florida, US
392902 2020-08-08 US Florida Marion 12083 6260 89 0 6171 29.21227113 -82.05803627 2020-08-09 04:34:54 Marion, Florida, US
392933 2020-08-08 US Florida Martin 12085 3802 92 0 3710 27.0772071 -80.43109784 2020-08-09 04:34:54 Martin, Florida, US
393024 2020-08-08 US Florida Miami-Dade 12086 131217 1838 0 129379 25.6112362 -80.55170587 2020-08-09 04:34:54 Miami-Dade, Florida, US
393069 2020-08-08 US Florida Monroe 12087 1514 13 0 1501 25.20904673 -81.07812416 2020-08-09 04:34:54 Monroe, Florida, US
393156 2020-08-08 US Florida Nassau 12089 1219 11 0 1208 30.61037141 -81.80297522 2020-08-09 04:34:54 Nassau, Florida, US
393236 2020-08-08 US Florida Okaloosa 12091 3448 41 0 3407 30.69143028 -86.59267105 2020-08-09 04:34:54 Okaloosa, Florida, US
393238 2020-08-08 US Florida Okeechobee 12093 1027 10 0 1017 27.386336199999995 -80.88944347 2020-08-09 04:34:54 Okeechobee, Florida, US
393255 2020-08-08 US Florida Orange 12095 31395 297 0 31098 28.51367621 -81.31799498 2020-08-09 04:34:54 Orange, Florida, US
393272 2020-08-08 US Florida Osceola 12097 9568 104 0 9464 28.06312234 -81.14882926 2020-08-09 04:34:54 Osceola, Florida, US
393311 2020-08-08 US Florida Palm Beach 12099 36600 929 0 35671 26.64676272 -80.46536002 2020-08-09 04:34:54 Palm Beach, Florida, US
393323 2020-08-08 US Florida Pasco 12101 6982 127 0 6855 28.30810945 -82.40227529 2020-08-09 04:34:54 Pasco, Florida, US
393399 2020-08-08 US Florida Pinellas 12103 17725 497 0 17228 27.93130349 -82.72239666 2020-08-09 04:34:54 Pinellas, Florida, US
393420 2020-08-08 US Florida Polk 12105 14124 312 0 13812 27.95027105 -81.69732947 2020-08-09 04:34:54 Polk, Florida, US
393481 2020-08-08 US Florida Putnam 12107 1481 26 0 1455 29.60779729 -81.74230285 2020-08-09 04:34:54 Putnam, Florida, US
393658 2020-08-08 US Florida Santa Rosa 12113 3857 37 0 3820 30.69341450000001 -87.02458128 2020-08-09 04:34:54 Santa Rosa, Florida, US
393659 2020-08-08 US Florida Sarasota 12115 6164 138 0 6026 27.18546175 -82.33174248 2020-08-09 04:34:54 Sarasota, Florida, US
393696 2020-08-08 US Florida Seminole 12117 7048 118 0 6930 28.7158582 -81.24060348 2020-08-09 04:34:54 Seminole, Florida, US
393790 2020-08-08 US Florida St. Johns 12109 3593 34 0 3559 29.90096506 -81.43589967 2020-08-09 04:34:54 St. Johns, Florida, US
393798 2020-08-08 US Florida St. Lucie 12111 5695 163 0 5532 27.37763908 -80.47106649 2020-08-09 04:34:54 St. Lucie, Florida, US
393861 2020-08-08 US Florida Sumter 12119 1284 41 0 1243 28.70181754 -82.0794267 2020-08-09 04:34:54 Sumter, Florida, US
393873 2020-08-08 US Florida Suwannee 12121 1404 43 0 1361 30.19746066 -82.99099670000003 2020-08-09 04:34:54 Suwannee, Florida, US
393893 2020-08-08 US Florida Taylor 12123 947 4 0 943 30.04848048 -83.60445406 2020-08-09 04:34:54 Taylor, Florida, US
393990 2020-08-08 US Florida Unassigned 90012 678 0 0 678 30.86747479 0.0 2020-08-09 04:34:54 Unassigned, Florida, US
394033 2020-08-08 US Florida Union 12125 297 5 0 292 30.04412971 -82.37497443 2020-08-09 04:34:54 Union, Florida, US
394088 2020-08-08 US Florida Volusia 12127 7779 131 0 7648 29.05858895 -81.18263252 2020-08-09 04:34:54 Volusia, Florida, US
394097 2020-08-08 US Florida Wakulla 12129 680 4 0 676 30.16548905 -84.39895211 2020-08-09 04:34:54 Wakulla, Florida, US
394107 2020-08-08 US Florida Walton 12131 1383 15 0 1368 30.64204028 -86.16935664 2020-08-09 04:34:54 Walton, Florida, US
394138 2020-08-08 US Florida Washington 12133 839 14 0 825 30.61359259 -85.66002461 2020-08-09 04:34:54 Washington, Florida, US
281674 2020-08-07 US Florida Alachua 12001 4006 26 0 3980 29.67866525 -82.35928158 2020-08-08 04:34:53 Alachua, Florida, US
281770 2020-08-07 US Florida Baker 12003 630 4 0 626 30.33060121 -82.28467476 2020-08-08 04:34:53 Baker, Florida, US
281806 2020-08-07 US Florida Bay 12005 4194 45 0 4149 30.26548745 -85.62122584 2020-08-08 04:34:53 Bay, Florida, US
281912 2020-08-07 US Florida Bradford 12007 434 4 0 430 29.95079741 -82.16611613 2020-08-08 04:34:53 Bradford, Florida, US
281924 2020-08-07 US Florida Brevard 12009 5851 140 0 5711 28.29409504 -80.73091022 2020-08-08 04:34:53 Brevard, Florida, US
281938 2020-08-07 US Florida Broward 12011 60746 782 0 59964 26.15184651 -80.48725556 2020-08-08 04:34:53 Broward, Florida, US
282004 2020-08-07 US Florida Calhoun 12013 417 7 0 410 30.40666734 -85.19394153 2020-08-08 04:34:53 Calhoun, Florida, US
282113 2020-08-07 US Florida Charlotte 12015 2174 90 0 2084 26.90131002 -81.92949121 2020-08-08 04:34:53 Charlotte, Florida, US
282173 2020-08-07 US Florida Citrus 12017 1473 36 0 1437 28.84804315 -82.47614748 2020-08-08 04:34:53 Citrus, Florida, US
282202 2020-08-07 US Florida Clay 12019 3186 50 0 3136 29.98319144 -81.85609986 2020-08-08 04:34:53 Clay, Florida, US
282262 2020-08-07 US Florida Collier 12021 10202 131 0 10071 26.11091986 -81.34687065 2020-08-08 04:34:53 Collier, Florida, US
282269 2020-08-07 US Florida Columbia 12023 2784 14 0 2770 30.22509788 -82.62160164 2020-08-08 04:34:53 Columbia, Florida, US
282409 2020-08-07 US Florida DeSoto 12027 1327 16 0 1311 27.18677893 -81.80941373 2020-08-08 04:34:53 DeSoto, Florida, US
282455 2020-08-07 US Florida Dixie 12029 424 4 0 420 29.60631086 -83.15724673 2020-08-08 04:34:53 Dixie, Florida, US
282496 2020-08-07 US Florida Duval 12031 22889 177 0 22712 30.33225875 -81.66976468 2020-08-08 04:34:53 Duval, Florida, US
282547 2020-08-07 US Florida Escambia 12033 8757 115 0 8642 30.67652764 -87.37284571 2020-08-08 04:34:53 Escambia, Florida, US
282595 2020-08-07 US Florida Flagler 12035 1008 13 0 995 29.45933576 -81.31508595 2020-08-08 04:34:53 Flagler, Florida, US
282622 2020-08-07 US Florida Franklin 12037 377 2 0 375 29.83791238 -84.82731662 2020-08-08 04:34:53 Franklin, Florida, US
282667 2020-08-07 US Florida Gadsden 12039 1781 21 0 1760 30.57796289 -84.61915825 2020-08-08 04:34:53 Gadsden, Florida, US
282702 2020-08-07 US Florida Gilchrist 12041 345 3 0 342 29.72856978 -82.79880657 2020-08-08 04:34:53 Gilchrist, Florida, US
282711 2020-08-07 US Florida Glades 12043 398 3 0 395 26.95635849 -81.18996211 2020-08-08 04:34:53 Glades, Florida, US
282811 2020-08-07 US Florida Gulf 12045 569 2 0 567 29.93543004 -85.24270990000002 2020-08-08 04:34:53 Gulf, Florida, US
282827 2020-08-07 US Florida Hamilton 12047 612 4 0 608 30.49673973 -82.94998918 2020-08-08 04:34:53 Hamilton, Florida, US
282858 2020-08-07 US Florida Hardee 12049 908 7 0 901 27.49293939 -81.80956574 2020-08-08 04:34:53 Hardee, Florida, US
282912 2020-08-07 US Florida Hendry 12051 1725 37 0 1688 26.55386945 -81.16469006 2020-08-08 04:34:53 Hendry, Florida, US
282926 2020-08-07 US Florida Hernando 12053 1929 43 0 1886 28.55364461 -82.42700204 2020-08-08 04:34:53 Hernando, Florida, US
282936 2020-08-07 US Florida Highlands 12055 1355 36 0 1319 27.34254618 -81.34071957 2020-08-08 04:34:53 Highlands, Florida, US
282939 2020-08-07 US Florida Hillsborough 12057 31865 386 0 31479 27.9276559 -82.32013172 2020-08-08 04:34:53 Hillsborough, Florida, US
282949 2020-08-07 US Florida Holmes 12059 486 2 0 484 30.86747479 -85.81319222 2020-08-08 04:34:53 Holmes, Florida, US
283007 2020-08-07 US Florida Indian River 12061 2450 52 0 2398 27.69308961 -80.60556721 2020-08-08 04:34:53 Indian River, Florida, US
283035 2020-08-07 US Florida Jackson 12063 1832 37 0 1795 30.7954597 -85.21500423 2020-08-08 04:34:53 Jackson, Florida, US
283072 2020-08-07 US Florida Jefferson 12065 447 5 0 442 30.43669112 -83.89442308 2020-08-08 04:34:53 Jefferson, Florida, US

Next page

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] INTEGER,
   [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]);
Powered by Datasette · Query took 1918.131ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette