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 2020-09-17 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
1122251 1122251 2020-09-17 US Florida Alachua 12001 6994 44 0 6950 29.67866525 -82.35928158 2020-09-18 05:05:00 Alachua, Florida, US
1122252 1122252 2020-09-17 US Florida Baker 12003 1373 11 0 1362 30.33060121 -82.28467476 2020-09-18 05:05:00 Baker, Florida, US
1122253 1122253 2020-09-17 US Florida Bay 12005 5754 94 0 5660 30.26548745 -85.62122584 2020-09-18 05:05:00 Bay, Florida, US
1122254 1122254 2020-09-17 US Florida Bradford 12007 984 7 0 977 29.95079741 -82.16611613 2020-09-18 05:05:00 Bradford, Florida, US
1122255 1122255 2020-09-17 US Florida Brevard 12009 8193 270 0 7923 28.29409504 -80.73091022 2020-09-18 05:05:00 Brevard, Florida, US
1122256 1122256 2020-09-17 US Florida Broward 12011 75048 1311 0 73737 26.15184651 -80.48725556 2020-09-18 05:05:00 Broward, Florida, US
1122257 1122257 2020-09-17 US Florida Calhoun 12013 605 9 0 596 30.40666734 -85.19394153 2020-09-18 05:05:00 Calhoun, Florida, US
1122258 1122258 2020-09-17 US Florida Charlotte 12015 2901 131 0 2770 26.90131002 -81.92949121 2020-09-18 05:05:00 Charlotte, Florida, US
1122259 1122259 2020-09-17 US Florida Citrus 12017 2541 80 0 2461 28.84804315 -82.47614748 2020-09-18 05:05:00 Citrus, Florida, US
1122260 1122260 2020-09-17 US Florida Clay 12019 4672 91 0 4581 29.98319144 -81.85609986 2020-09-18 05:05:00 Clay, Florida, US
1122261 1122261 2020-09-17 US Florida Collier 12021 12324 196 0 12128 26.11091986 -81.34687065 2020-09-18 05:05:00 Collier, Florida, US
1122262 1122262 2020-09-17 US Florida Columbia 12023 3592 50 0 3542 30.22509788 -82.62160164 2020-09-18 05:05:00 Columbia, Florida, US
1122263 1122263 2020-09-17 US Florida DeSoto 12027 1540 23 0 1517 27.18677893 -81.80941373 2020-09-18 05:05:00 DeSoto, Florida, US
1122264 1122264 2020-09-17 US Florida Dixie 12029 814 5 0 809 29.60631086 -83.15724673 2020-09-18 05:05:00 Dixie, Florida, US
1122265 1122265 2020-09-17 US Florida Duval 12031 28876 345 0 28531 30.33225875 -81.66976468 2020-09-18 05:05:00 Duval, Florida, US
1122266 1122266 2020-09-17 US Florida Escambia 12033 11991 215 0 11776 30.67652764 -87.37284571 2020-09-18 05:05:00 Escambia, Florida, US
1122267 1122267 2020-09-17 US Florida Flagler 12035 1614 22 0 1592 29.45933576 -81.31508595 2020-09-18 05:05:00 Flagler, Florida, US
1122268 1122268 2020-09-17 US Florida Franklin 12037 588 3 0 585 29.83791238 -84.82731662 2020-09-18 05:05:00 Franklin, Florida, US
1122269 1122269 2020-09-17 US Florida Gadsden 12039 2656 44 0 2612 30.57796289 -84.61915825 2020-09-18 05:05:00 Gadsden, Florida, US
1122270 1122270 2020-09-17 US Florida Gilchrist 12041 493 12 0 481 29.72856978 -82.79880657 2020-09-18 05:05:00 Gilchrist, Florida, US
1122271 1122271 2020-09-17 US Florida Glades 12043 487 4 0 483 26.95635849 -81.18996211 2020-09-18 05:05:00 Glades, Florida, US
1122272 1122272 2020-09-17 US Florida Gulf 12045 864 13 0 851 29.93543004 -85.2427099 2020-09-18 05:05:00 Gulf, Florida, US
1122273 1122273 2020-09-17 US Florida Hamilton 12047 807 8 0 799 30.49673973 -82.94998918 2020-09-18 05:05:00 Hamilton, Florida, US
1122274 1122274 2020-09-17 US Florida Hardee 12049 1259 10 0 1249 27.49293939 -81.80956574 2020-09-18 05:05:00 Hardee, Florida, US
1122275 1122275 2020-09-17 US Florida Hendry 12051 2034 42 0 1992 26.55386945 -81.16469006 2020-09-18 05:05:00 Hendry, Florida, US
1122276 1122276 2020-09-17 US Florida Hernando 12053 2941 110 0 2831 28.55364461 -82.42700204 2020-09-18 05:05:00 Hernando, Florida, US
1122277 1122277 2020-09-17 US Florida Highlands 12055 2037 81 0 1956 27.34254618 -81.34071957 2020-09-18 05:05:00 Highlands, Florida, US
1122278 1122278 2020-09-17 US Florida Hillsborough 12057 40126 601 0 39525 27.9276559 -82.32013172 2020-09-18 05:05:00 Hillsborough, Florida, US
1122279 1122279 2020-09-17 US Florida Holmes 12059 717 5 0 712 30.86747479 -85.81319222 2020-09-18 05:05:00 Holmes, Florida, US
1122280 1122280 2020-09-17 US Florida Indian River 12061 3026 109 0 2917 27.69308961 -80.60556721 2020-09-18 05:05:00 Indian River, Florida, US
1122281 1122281 2020-09-17 US Florida Jackson 12063 2673 75 0 2598 30.7954597 -85.21500423 2020-09-18 05:05:00 Jackson, Florida, US
1122282 1122282 2020-09-17 US Florida Jefferson 12065 540 8 0 532 30.43669112 -83.89442308 2020-09-18 05:05:00 Jefferson, Florida, US
1122283 1122283 2020-09-17 US Florida Lafayette 12067 1227 12 0 1215 29.98484137 -83.18166636 2020-09-18 05:05:00 Lafayette, Florida, US
1122284 1122284 2020-09-17 US Florida Lake 12069 7173 163 0 7010 28.76202069 -81.7125123 2020-09-18 05:05:00 Lake, Florida, US
1122285 1122285 2020-09-17 US Florida Lee 12071 19733 457 0 19276 26.58410348 -81.88399313 2020-09-18 05:05:00 Lee, Florida, US
1122286 1122286 2020-09-17 US Florida Leon 12073 9566 52 0 9514 30.45955727 -84.27491114 2020-09-18 05:05:00 Leon, Florida, US
1122287 1122287 2020-09-17 US Florida Levy 12075 989 8 0 981 29.31829741 -82.74007147 2020-09-18 05:05:00 Levy, Florida, US
1122288 1122288 2020-09-17 US Florida Liberty 12077 485 7 0 478 30.23766008 -84.8829258 2020-09-18 05:05:00 Liberty, Florida, US
1122289 1122289 2020-09-17 US Florida Madison 12079 995 18 0 977 30.44396917 -83.47398594 2020-09-18 05:05:00 Madison, Florida, US
1122290 1122290 2020-09-17 US Florida Manatee 12081 11041 277 0 10764 27.47196942 -82.31831044 2020-09-18 05:05:00 Manatee, Florida, US
1122291 1122291 2020-09-17 US Florida Marion 12083 9274 258 0 9016 29.21227113 -82.05803627 2020-09-18 05:05:00 Marion, Florida, US
1122292 1122292 2020-09-17 US Florida Martin 12085 4645 132 0 4513 27.0772071 -80.43109784 2020-09-18 05:05:00 Martin, Florida, US
1122293 1122293 2020-09-17 US Florida Miami-Dade 12086 165595 2977 0 162618 25.6112362 -80.55170587 2020-09-18 05:05:00 Miami-Dade, Florida, US
1122294 1122294 2020-09-17 US Florida Monroe 12087 1799 22 0 1777 25.20904673 -81.07812416 2020-09-18 05:05:00 Monroe, Florida, US
1122295 1122295 2020-09-17 US Florida Nassau 12089 1989 35 0 1954 30.61037141 -81.80297522 2020-09-18 05:05:00 Nassau, Florida, US
1122296 1122296 2020-09-17 US Florida Okaloosa 12091 4706 99 0 4607 30.69143028 -86.59267105 2020-09-18 05:05:00 Okaloosa, Florida, US
1122297 1122297 2020-09-17 US Florida Okeechobee 12093 1376 22 0 1354 27.3863362 -80.88944347 2020-09-18 05:05:00 Okeechobee, Florida, US
1122298 1122298 2020-09-17 US Florida Orange 12095 38422 426 0 37996 28.51367621 -81.31799498 2020-09-18 05:05:00 Orange, Florida, US
1122299 1122299 2020-09-17 US Florida Osceola 12097 11919 137 0 11782 28.06312234 -81.14882926 2020-09-18 05:05:00 Osceola, Florida, US
1122300 1122300 2020-09-17 US Florida Palm Beach 12099 44683 1254 0 43429 26.64676272 -80.46536002 2020-09-18 05:05:00 Palm Beach, Florida, US
1122301 1122301 2020-09-17 US Florida Pasco 12101 8680 197 0 8483 28.30810945 -82.40227529 2020-09-18 05:05:00 Pasco, Florida, US
1122302 1122302 2020-09-17 US Florida Pinellas 12103 21254 715 0 20539 27.93130349 -82.72239666 2020-09-18 05:05:00 Pinellas, Florida, US
1122303 1122303 2020-09-17 US Florida Polk 12105 18783 503 0 18280 27.95027105 -81.69732947 2020-09-18 05:05:00 Polk, Florida, US
1122304 1122304 2020-09-17 US Florida Putnam 12107 2017 38 0 1979 29.60779729 -81.74230285 2020-09-18 05:05:00 Putnam, Florida, US
1122305 1122305 2020-09-17 US Florida Santa Rosa 12113 5192 69 0 5123 30.6934145 -87.02458128 2020-09-18 05:05:00 Santa Rosa, Florida, US
1122306 1122306 2020-09-17 US Florida Sarasota 12115 7752 245 0 7507 27.18546175 -82.33174248 2020-09-18 05:05:00 Sarasota, Florida, US
1122307 1122307 2020-09-17 US Florida Seminole 12117 8694 197 0 8497 28.7158582 -81.24060348 2020-09-18 05:05:00 Seminole, Florida, US
1122308 1122308 2020-09-17 US Florida St. Johns 12109 4991 65 0 4926 29.90096506 -81.43589967 2020-09-18 05:05:00 St. Johns, Florida, US
1122309 1122309 2020-09-17 US Florida St. Lucie 12111 7704 259 0 7445 27.37763908 -80.47106649 2020-09-18 05:05:00 St. Lucie, Florida, US
1122310 1122310 2020-09-17 US Florida Sumter 12119 2137 64 0 2073 28.70181754 -82.0794267 2020-09-18 05:05:00 Sumter, Florida, US
1122311 1122311 2020-09-17 US Florida Suwannee 12121 2563 65 0 2498 30.19746066 -82.9909967 2020-09-18 05:05:00 Suwannee, Florida, US
1122312 1122312 2020-09-17 US Florida Taylor 12123 1270 11 0 1259 30.04848048 -83.60445406 2020-09-18 05:05:00 Taylor, Florida, US
1122313 1122313 2020-09-17 US Florida Unassigned 90012 1569 0 0 1569 30.86747479 0.0 2020-09-18 05:05:00 Unassigned, Florida, US
1122314 1122314 2020-09-17 US Florida Union 12125 839 10 0 829 30.04412971 -82.37497443 2020-09-18 05:05:00 Union, Florida, US
1122315 1122315 2020-09-17 US Florida Volusia 12127 10364 214 0 10150 29.05858895 -81.18263252 2020-09-18 05:05:00 Volusia, Florida, US
1122316 1122316 2020-09-17 US Florida Wakulla 12129 1057 9 0 1048 30.16548905 -84.39895211 2020-09-18 05:05:00 Wakulla, Florida, US
1122317 1122317 2020-09-17 US Florida Walton 12131 1858 22 0 1836 30.64204028 -86.16935664 2020-09-18 05:05:00 Walton, Florida, US
1122318 1122318 2020-09-17 US Florida Washington 12133 1051 18 0 1033 30.61359259 -85.66002461 2020-09-18 05:05:00 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]);