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-06-01 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
2104801 2104801 2021-06-01 US Florida Alachua 12001 25484 285 0   29.67866525 -82.35928158 2021-06-02 04:24:34 Alachua, Florida, US
2104802 2104802 2021-06-01 US Florida Baker 12003 3542 62 0   30.33060121 -82.28467476 2021-06-02 04:24:34 Baker, Florida, US
2104803 2104803 2021-06-01 US Florida Bay 12005 20577 394 0   30.26548745 -85.62122584 2021-06-02 04:24:34 Bay, Florida, US
2104804 2104804 2021-06-01 US Florida Bradford 12007 3049 58 0   29.95079741 -82.16611613 2021-06-02 04:24:34 Bradford, Florida, US
2104805 2104805 2021-06-01 US Florida Brevard 12009 42963 905 0   28.29409504 -80.73091022 2021-06-02 04:24:34 Brevard, Florida, US
2104806 2104806 2021-06-01 US Florida Broward 12011 245036 3077 0   26.15184651 -80.48725556 2021-06-02 04:24:34 Broward, Florida, US
2104807 2104807 2021-06-01 US Florida Calhoun 12013 1707 45 0   30.40666734 -85.19394153 2021-06-02 04:24:34 Calhoun, Florida, US
2104808 2104808 2021-06-01 US Florida Charlotte 12015 13413 437 0   26.90131002 -81.92949121 2021-06-02 04:24:34 Charlotte, Florida, US
2104809 2104809 2021-06-01 US Florida Citrus 12017 11401 463 0   28.84804315 -82.47614748 2021-06-02 04:24:34 Citrus, Florida, US
2104810 2104810 2021-06-01 US Florida Clay 12019 19265 352 0   29.98319144 -81.85609986 2021-06-02 04:24:34 Clay, Florida, US
2104811 2104811 2021-06-01 US Florida Collier 12021 37102 549 0   26.11091986 -81.34687065 2021-06-02 04:24:34 Collier, Florida, US
2104812 2104812 2021-06-01 US Florida Columbia 12023 8265 170 0   30.22509788 -82.62160164 2021-06-02 04:24:34 Columbia, Florida, US
2104813 2104813 2021-06-01 US Florida DeSoto 12027 4435 97 0   27.18677893 -81.80941373 2021-06-02 04:24:34 DeSoto, Florida, US
2104814 2104814 2021-06-01 US Florida Dixie 12029 1626 24 0   29.60631086 -83.15724673 2021-06-02 04:24:34 Dixie, Florida, US
2104815 2104815 2021-06-01 US Florida Duval 12031 100837 1480 0   30.33225875 -81.66976468 2021-06-02 04:24:34 Duval, Florida, US
2104816 2104816 2021-06-01 US Florida Escambia 12033 36633 700 0   30.67652764 -87.37284571 2021-06-02 04:24:34 Escambia, Florida, US
2104817 2104817 2021-06-01 US Florida Flagler 12035 7500 112 0   29.45933576 -81.31508595 2021-06-02 04:24:34 Flagler, Florida, US
2104818 2104818 2021-06-01 US Florida Franklin 12037 1359 20 0   29.83791238 -84.82731662 2021-06-02 04:24:34 Franklin, Florida, US
2104819 2104819 2021-06-01 US Florida Gadsden 12039 5770 99 0   30.57796289 -84.61915825 2021-06-02 04:24:34 Gadsden, Florida, US
2104820 2104820 2021-06-01 US Florida Gilchrist 12041 1636 44 0   29.72856978 -82.79880657 2021-06-02 04:24:34 Gilchrist, Florida, US
2104821 2104821 2021-06-01 US Florida Glades 12043 982 19 0   26.95635849 -81.18996211 2021-06-02 04:24:34 Glades, Florida, US
2104822 2104822 2021-06-01 US Florida Gulf 12045 1979 45 0   29.93543004 -85.24270990000002 2021-06-02 04:24:34 Gulf, Florida, US
2104823 2104823 2021-06-01 US Florida Hamilton 12047 1647 25 0   30.49673973 -82.94998918 2021-06-02 04:24:34 Hamilton, Florida, US
2104824 2104824 2021-06-01 US Florida Hardee 12049 3275 45 0   27.49293939 -81.80956574 2021-06-02 04:24:34 Hardee, Florida, US
2104825 2104825 2021-06-01 US Florida Hendry 12051 4868 86 0   26.55386945 -81.16469006 2021-06-02 04:24:34 Hendry, Florida, US
2104826 2104826 2021-06-01 US Florida Hernando 12053 14590 477 0   28.55364461 -82.42700204 2021-06-02 04:24:34 Hernando, Florida, US
2104827 2104827 2021-06-01 US Florida Highlands 12055 8778 366 0   27.34254618 -81.34071957 2021-06-02 04:24:34 Highlands, Florida, US
2104828 2104828 2021-06-01 US Florida Hillsborough 12057 143236 1828 0   27.9276559 -82.32013172 2021-06-02 04:24:34 Hillsborough, Florida, US
2104829 2104829 2021-06-01 US Florida Holmes 12059 2282 49 0   30.86747479 -85.81319222 2021-06-02 04:24:34 Holmes, Florida, US
2104830 2104830 2021-06-01 US Florida Indian River 12061 12845 305 0   27.69308961 -80.60556721 2021-06-02 04:24:34 Indian River, Florida, US
2104831 2104831 2021-06-01 US Florida Jackson 12063 6309 158 0   30.7954597 -85.21500423 2021-06-02 04:24:34 Jackson, Florida, US
2104832 2104832 2021-06-01 US Florida Jefferson 12065 1522 28 0   30.43669112 -83.89442308 2021-06-02 04:24:34 Jefferson, Florida, US
2104833 2104833 2021-06-01 US Florida Lafayette 12067 1623 26 0   29.98484137 -83.18166636 2021-06-02 04:24:34 Lafayette, Florida, US
2104834 2104834 2021-06-01 US Florida Lake 12069 31065 658 0   28.76202069 -81.7125123 2021-06-02 04:24:34 Lake, Florida, US
2104835 2104835 2021-06-01 US Florida Lee 12071 73701 1007 0   26.58410348 -81.88399313 2021-06-02 04:24:34 Lee, Florida, US
2104836 2104836 2021-06-01 US Florida Leon 12073 32831 333 0   30.45955727 -84.27491114 2021-06-02 04:24:34 Leon, Florida, US
2104837 2104837 2021-06-01 US Florida Levy 12075 3571 56 0   29.31829741 -82.74007147 2021-06-02 04:24:34 Levy, Florida, US
2104838 2104838 2021-06-01 US Florida Liberty 12077 1084 16 0   30.23766008 -84.8829258 2021-06-02 04:24:34 Liberty, Florida, US
2104839 2104839 2021-06-01 US Florida Madison 12079 2094 45 0   30.44396917 -83.47398594 2021-06-02 04:24:34 Madison, Florida, US
2104840 2104840 2021-06-01 US Florida Manatee 12081 39913 688 0   27.47196942 -82.31831044 2021-06-02 04:24:34 Manatee, Florida, US
2104841 2104841 2021-06-01 US Florida Marion 12083 31939 985 0   29.21227113 -82.05803627 2021-06-02 04:24:34 Marion, Florida, US
2104842 2104842 2021-06-01 US Florida Martin 12085 12714 331 0   27.0772071 -80.43109784 2021-06-02 04:24:34 Martin, Florida, US
2104843 2104843 2021-06-01 US Florida Miami-Dade 12086 501423 6440 0   25.6112362 -80.55170587 2021-06-02 04:24:34 Miami-Dade, Florida, US
2104844 2104844 2021-06-01 US Florida Monroe 12087 7091 51 0   25.20904673 -81.07812416 2021-06-02 04:24:34 Monroe, Florida, US
2104845 2104845 2021-06-01 US Florida Nassau 12089 8648 126 0   30.61037141 -81.80297522 2021-06-02 04:24:34 Nassau, Florida, US
2104846 2104846 2021-06-01 US Florida Okaloosa 12091 20890 367 0   30.69143028 -86.59267105 2021-06-02 04:24:34 Okaloosa, Florida, US
2104847 2104847 2021-06-01 US Florida Okeechobee 12093 4180 89 0   27.386336199999995 -80.88944347 2021-06-02 04:24:34 Okeechobee, Florida, US
2104848 2104848 2021-06-01 US Florida Orange 12095 143001 1309 0   28.51367621 -81.31799498 2021-06-02 04:24:34 Orange, Florida, US
2104849 2104849 2021-06-01 US Florida Osceola 12097 46245 527 0   28.06312234 -81.14882926 2021-06-02 04:24:34 Osceola, Florida, US
2104850 2104850 2021-06-01 US Florida Palm Beach 12099 148656 2881 0   26.64676272 -80.46536002 2021-06-02 04:24:34 Palm Beach, Florida, US
2104851 2104851 2021-06-01 US Florida Pasco 12101 42888 800 0   28.30810945 -82.40227529 2021-06-02 04:24:34 Pasco, Florida, US
2104852 2104852 2021-06-01 US Florida Pinellas 12103 81438 1670 0   27.93130349 -82.72239666 2021-06-02 04:24:34 Pinellas, Florida, US
2104853 2104853 2021-06-01 US Florida Polk 12105 71145 1391 0   27.95027105 -81.69732947 2021-06-02 04:24:34 Polk, Florida, US
2104854 2104854 2021-06-01 US Florida Putnam 12107 6719 158 0   29.60779729 -81.74230285 2021-06-02 04:24:34 Putnam, Florida, US
2104855 2104855 2021-06-01 US Florida Santa Rosa 12113 18556 291 0   30.693414500000006 -87.02458128 2021-06-02 04:24:34 Santa Rosa, Florida, US
2104856 2104856 2021-06-01 US Florida Sarasota 12115 33703 843 0   27.18546175 -82.33174248 2021-06-02 04:24:34 Sarasota, Florida, US
2104857 2104857 2021-06-01 US Florida Seminole 12117 35360 516 0   28.7158582 -81.24060348 2021-06-02 04:24:34 Seminole, Florida, US
2104858 2104858 2021-06-01 US Florida St. Johns 12109 23280 221 0   29.90096506 -81.43589967 2021-06-02 04:24:34 St. Johns, Florida, US
2104859 2104859 2021-06-01 US Florida St. Lucie 12111 27468 656 0   27.37763908 -80.47106649 2021-06-02 04:24:34 St. Lucie, Florida, US
2104860 2104860 2021-06-01 US Florida Sumter 12119 9504 282 0   28.70181754 -82.0794267 2021-06-02 04:24:34 Sumter, Florida, US
2104861 2104861 2021-06-01 US Florida Suwannee 12121 5391 139 0   30.19746066 -82.99099670000003 2021-06-02 04:24:34 Suwannee, Florida, US
2104862 2104862 2021-06-01 US Florida Taylor 12123 2753 48 0   30.04848048 -83.60445406 2021-06-02 04:24:34 Taylor, Florida, US
2104863 2104863 2021-06-01 US Florida Unassigned 90012 3031 0 0   30.86747479 0.0 2021-06-02 04:24:34 Unassigned, Florida, US
2104864 2104864 2021-06-01 US Florida Union 12125 1847 74 0   30.04412971 -82.37497443 2021-06-02 04:24:34 Union, Florida, US
2104865 2104865 2021-06-01 US Florida Volusia 12127 44897 844 0   29.05858895 -81.18263252 2021-06-02 04:24:34 Volusia, Florida, US
2104866 2104866 2021-06-01 US Florida Wakulla 12129 3525 56 0   30.16548905 -84.39895211 2021-06-02 04:24:34 Wakulla, Florida, US
2104867 2104867 2021-06-01 US Florida Walton 12131 7917 89 0   30.64204028 -86.16935664 2021-06-02 04:24:34 Walton, Florida, US
2104868 2104868 2021-06-01 US Florida Washington 12133 2751 52 0   30.61359259 -85.66002461 2021-06-02 04:24:34 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]);