daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

68 rows where country_or_region = "US", "day" is on date 2020-03-24 and province_or_state = "Florida" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-03-24 US Florida Alachua 12001 37 0 0 37 29.67866525 -82.35928158 2020-03-24 23:37:31 Alachua, Florida, US
2020-03-24 US Florida Baker 12003 4 0 0 4 30.33060121 -82.28467476 2020-03-24 23:37:31 Baker, Florida, US
2020-03-24 US Florida Bay 12005 1 0 0 1 30.26548745 -85.62122584 2020-03-24 23:37:31 Bay, Florida, US
2020-03-24 US Florida Bradford 12007 1 0 0 1 29.95079741 -82.16611613 2020-03-24 23:37:31 Bradford, Florida, US
2020-03-24 US Florida Brevard 12009 9 0 0 9 28.29409504 -80.73091022 2020-03-24 23:37:31 Brevard, Florida, US
2020-03-24 US Florida Broward 12011 311 3 0 308 26.15184651 -80.48725556 2020-03-24 23:37:31 Broward, Florida, US
2020-03-24 US Florida Calhoun 12013 0 0 0 0 30.40666734 -85.19394153 2020-03-24 23:37:31 Calhoun, Florida, US
2020-03-24 US Florida Charlotte 12015 3 0 0 3 26.90131002 -81.92949121 2020-03-24 23:37:31 Charlotte, Florida, US
2020-03-24 US Florida Citrus 12017 9 0 0 9 28.84804315 -82.47614748 2020-03-24 23:37:31 Citrus, Florida, US
2020-03-24 US Florida Clay 12019 10 2 0 8 29.98319144 -81.85609986 2020-03-24 23:37:31 Clay, Florida, US
2020-03-24 US Florida Collier 12021 41 0 0 41 26.11091986 -81.34687065 2020-03-24 23:37:31 Collier, Florida, US
2020-03-24 US Florida Columbia 12023 3 0 0 3 30.22509788 -82.62160164 2020-03-24 23:37:31 Columbia, Florida, US
2020-03-24 US Florida DeSoto 12027 1 0 0 1 27.18677893 -81.80941373 2020-03-24 23:37:31 DeSoto,Florida,US
2020-03-24 US Florida Dixie 12029 0 0 0 0 29.60631086 -83.15724673 2020-03-24 23:37:31 Dixie, Florida, US
2020-03-24 US Florida Duval 12031 50 1 0 49 30.33225875 -81.66976468 2020-03-24 23:37:31 Duval, Florida, US
2020-03-24 US Florida Escambia 12033 10 0 0 10 30.67652764 -87.37284571 2020-03-24 23:37:31 Escambia, Florida, US
2020-03-24 US Florida Flagler 12035 4 0 0 4 29.45933576 -81.31508595 2020-03-24 23:37:31 Flagler, Florida, US
2020-03-24 US Florida Franklin 12037 0 0 0 0 29.83791238 -84.82731662 2020-03-24 23:37:31 Franklin, Florida, US
2020-03-24 US Florida Gadsden 12039 1 0 0 1 30.57796289 -84.61915825 2020-03-24 23:37:31 Gadsden, Florida, US
2020-03-24 US Florida Gilchrist 12041 0 0 0 0 29.72856978 -82.79880657 2020-03-24 23:37:31 Gilchrist, Florida, US
2020-03-24 US Florida Glades 12043 0 0 0 0 26.95635849 -81.18996211 2020-03-24 23:37:31 Glades, Florida, US
2020-03-24 US Florida Gulf 12045 0 0 0 0 29.93543004 -85.24270990000002 2020-03-24 23:37:31 Gulf, Florida, US
2020-03-24 US Florida Hamilton 12047 0 0 0 0 30.49673973 -82.94998918 2020-03-24 23:37:31 Hamilton, Florida, US
2020-03-24 US Florida Hardee 12049 0 0 0 0 27.49293939 -81.80956574 2020-03-24 23:37:31 Hardee, Florida, US
2020-03-24 US Florida Hendry 12051 0 0 0 0 26.55386945 -81.16469006 2020-03-24 23:37:31 Hendry, Florida, US
2020-03-24 US Florida Hernando 12053 5 0 0 5 28.55364461 -82.42700204 2020-03-24 23:37:31 Hernando, Florida, US
2020-03-24 US Florida Highlands 12055 4 0 0 4 27.34254618 -81.34071957 2020-03-24 23:37:31 Highlands, Florida, US
2020-03-24 US Florida Hillsborough 12057 91 0 0 91 27.9276559 -82.32013172 2020-03-24 23:37:31 Hillsborough, Florida, US
2020-03-24 US Florida Holmes 12059 0 0 0 0 30.86747479 -85.81319222 2020-03-24 23:37:31 Holmes, Florida, US
2020-03-24 US Florida Indian River 12061 11 0 0 11 27.69308961 -80.60556721 2020-03-24 23:37:31 Indian River, Florida, US
2020-03-24 US Florida Jackson 12063 1 0 0 1 30.795459700000002 -85.21500423 2020-03-24 23:37:31 Jackson, Florida, US
2020-03-24 US Florida Jefferson 12065 0 0 0 0 30.43669112 -83.89442308 2020-03-24 23:37:31 Jefferson, Florida, US
2020-03-24 US Florida Lafayette 12067 0 0 0 0 29.98484137 -83.18166636 2020-03-24 23:37:31 Lafayette, Florida, US
2020-03-24 US Florida Lake 12069 14 0 0 14 28.76202069 -81.7125123 2020-03-24 23:37:31 Lake, Florida, US
2020-03-24 US Florida Lee 12071 32 2 0 30 26.58410348 -81.88399313 2020-03-24 23:37:31 Lee, Florida, US
2020-03-24 US Florida Leon 12073 8 1 0 7 30.45955727 -84.27491114 2020-03-24 23:37:31 Leon, Florida, US
2020-03-24 US Florida Levy 12075 0 0 0 0 29.31829741 -82.74007147 2020-03-24 23:37:31 Levy, Florida, US
2020-03-24 US Florida Liberty 12077 0 0 0 0 30.23766008 -84.8829258 2020-03-24 23:37:31 Liberty, Florida, US
2020-03-24 US Florida Madison 12079 0 0 0 0 30.44396917 -83.47398594 2020-03-24 23:37:31 Madison, Florida, US
2020-03-24 US Florida Manatee 12081 16 1 0 15 27.47196942 -82.31831044 2020-03-24 23:37:31 Manatee, Florida, US
2020-03-24 US Florida Marion 12083 4 0 0 4 29.21227113 -82.05803627 2020-03-24 23:37:31 Marion, Florida, US
2020-03-24 US Florida Martin 12085 4 0 0 4 27.0772071 -80.43109784 2020-03-24 23:37:31 Martin, Florida, US
2020-03-24 US Florida Miami-Dade 12086 338 0 0 338 25.6112362 -80.55170587 2020-03-24 23:37:31 Miami-Dade, Florida, US
2020-03-24 US Florida Monroe 12087 3 0 0 3 25.20904673 -81.07812416 2020-03-24 23:37:31 Monroe, Florida, US
2020-03-24 US Florida Nassau 12089 1 0 0 1 30.61037141 -81.80297522 2020-03-24 23:37:31 Nassau, Florida, US
2020-03-24 US Florida Okaloosa 12091 14 0 0 14 30.69143028 -86.59267105 2020-03-24 23:37:31 Okaloosa, Florida, US
2020-03-24 US Florida Okeechobee 12093 0 0 0 0 27.386336199999995 -80.88944347 2020-03-24 23:37:31 Okeechobee, Florida, US
2020-03-24 US Florida Orange 12095 50 2 0 48 28.51367621 -81.31799498 2020-03-24 23:37:31 Orange, Florida, US
2020-03-24 US Florida Osceola 12097 26 0 0 26 28.06312234 -81.14882926 2020-03-24 23:37:31 Osceola, Florida, US
2020-03-24 US Florida Palm Beach 12099 101 3 0 98 26.64676272 -80.46536002 2020-03-24 23:37:31 Palm Beach, Florida, US
2020-03-24 US Florida Pasco 12101 15 1 0 14 28.30810945 -82.40227529 2020-03-24 23:37:31 Pasco, Florida, US
2020-03-24 US Florida Pinellas 12103 45 0 0 45 27.93130349 -82.72239666 2020-03-24 23:37:31 Pinellas, Florida, US
2020-03-24 US Florida Polk 12105 13 0 0 13 27.95027105 -81.69732947 2020-03-24 23:37:31 Polk, Florida, US
2020-03-24 US Florida Putnam 12107 2 0 0 2 29.60779729 -81.74230285 2020-03-24 23:37:31 Putnam, Florida, US
2020-03-24 US Florida Santa Rosa 12113 4 1 0 3 30.69341450000001 -87.02458128 2020-03-24 23:37:31 Santa Rosa, Florida, US
2020-03-24 US Florida Sarasota 12115 26 0 0 26 27.18546175 -82.33174248 2020-03-24 23:37:31 Sarasota, Florida, US
2020-03-24 US Florida Seminole 12117 23 0 0 23 28.7158582 -81.24060348 2020-03-24 23:37:31 Seminole, Florida, US
2020-03-24 US Florida St. Johns 12109 22 0 0 22 29.90096506 -81.43589967 2020-03-24 23:37:31 St. Johns, Florida, US
2020-03-24 US Florida St. Lucie 12111 6 0 0 6 27.37763908 -80.47106649 2020-03-24 23:37:31 St. Lucie, Florida, US
2020-03-24 US Florida Sumter 12119 10 0 0 10 28.70181754 -82.0794267 2020-03-24 23:37:31 Sumter, Florida, US
2020-03-24 US Florida Suwannee 12121 0 0 0 0 30.19746066 -82.99099670000003 2020-03-24 23:37:31 Suwannee, Florida, US
2020-03-24 US Florida Taylor 12123 0 0 0 0 30.04848048 -83.60445406 2020-03-24 23:37:31 Taylor, Florida, US
2020-03-24 US Florida Unassigned   0 1 0 0 0.0 0.0 2020-03-24 23:37:31 Unassigned, Florida, US
2020-03-24 US Florida Union 12125 0 0 0 0 30.04412971 -82.37497443 2020-03-24 23:37:31 Union, Florida, US
2020-03-24 US Florida Volusia 12127 18 0 0 18 29.05858895 -81.18263252 2020-03-24 23:37:31 Volusia, Florida, US
2020-03-24 US Florida Wakulla 12129 0 0 0 0 30.16548905 -84.39895211 2020-03-24 23:37:31 Wakulla, Florida, US
2020-03-24 US Florida Walton 12131 10 0 0 10 30.64204028 -86.16935664 2020-03-24 23:37:31 Walton, Florida, US
2020-03-24 US Florida Washington 12133 0 0 0 0 30.61359259 -85.66002461 2020-03-24 23:37:31 Washington, Florida, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;