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-02-11 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
2638391 2638391 2021-02-11 US Florida Alachua 12001 21649 189 0 21460 29.67866525 -82.35928158 2021-02-12 05:23:29 Alachua, Florida, US
2638392 2638392 2021-02-11 US Florida Baker 12003 3199 54 0 3145 30.33060121 -82.28467476 2021-02-12 05:23:29 Baker, Florida, US
2638393 2638393 2021-02-11 US Florida Bay 12005 17721 314 0 17407 30.26548745 -85.62122584 2021-02-12 05:23:29 Bay, Florida, US
2638394 2638394 2021-02-11 US Florida Bradford 12007 2765 48 0 2717 29.95079741 -82.16611613 2021-02-12 05:23:29 Bradford, Florida, US
2638395 2638395 2021-02-11 US Florida Brevard 12009 31581 690 0 30891 28.29409504 -80.73091022 2021-02-12 05:23:29 Brevard, Florida, US
2638396 2638396 2021-02-11 US Florida Broward 12011 182419 2218 0 180201 26.15184651 -80.48725556 2021-02-12 05:23:29 Broward, Florida, US
2638397 2638397 2021-02-11 US Florida Calhoun 12013 1574 36 0 1538 30.40666734 -85.19394153 2021-02-12 05:23:29 Calhoun, Florida, US
2638398 2638398 2021-02-11 US Florida Charlotte 12015 10150 320 0 9830 26.90131002 -81.92949121 2021-02-12 05:23:29 Charlotte, Florida, US
2638399 2638399 2021-02-11 US Florida Citrus 12017 9210 362 0 8848 28.84804315 -82.47614748 2021-02-12 05:23:29 Citrus, Florida, US
2638400 2638400 2021-02-11 US Florida Clay 12019 16080 283 0 15797 29.98319144 -81.85609986 2021-02-12 05:23:29 Clay, Florida, US
2638401 2638401 2021-02-11 US Florida Collier 12021 28883 426 0 28457 26.11091986 -81.34687065 2021-02-12 05:23:29 Collier, Florida, US
2638402 2638402 2021-02-11 US Florida Columbia 12023 7440 148 0 7292 30.22509788 -82.62160164 2021-02-12 05:23:29 Columbia, Florida, US
2638403 2638403 2021-02-11 US Florida DeSoto 12027 3511 69 0 3442 27.18677893 -81.80941373 2021-02-12 05:23:29 DeSoto, Florida, US
2638404 2638404 2021-02-11 US Florida Dixie 12029 1427 15 0 1412 29.60631086 -83.15724673 2021-02-12 05:23:29 Dixie, Florida, US
2638405 2638405 2021-02-11 US Florida Duval 12031 85430 1002 0 84428 30.33225875 -81.66976468 2021-02-12 05:23:29 Duval, Florida, US
2638406 2638406 2021-02-11 US Florida Escambia 12033 32484 582 0 31902 30.67652764 -87.37284571 2021-02-12 05:23:29 Escambia, Florida, US
2638407 2638407 2021-02-11 US Florida Flagler 12035 5573 76 0 5497 29.45933576 -81.31508595 2021-02-12 05:23:29 Flagler, Florida, US
2638408 2638408 2021-02-11 US Florida Franklin 12037 1265 11 0 1254 29.83791238 -84.82731662 2021-02-12 05:23:29 Franklin, Florida, US
2638409 2638409 2021-02-11 US Florida Gadsden 12039 5285 76 0 5209 30.57796289 -84.61915825 2021-02-12 05:23:29 Gadsden, Florida, US
2638410 2638410 2021-02-11 US Florida Gilchrist 12041 1283 28 0 1255 29.72856978 -82.79880657 2021-02-12 05:23:29 Gilchrist, Florida, US
2638411 2638411 2021-02-11 US Florida Glades 12043 872 14 0 858 26.95635849 -81.18996211 2021-02-12 05:23:29 Glades, Florida, US
2638412 2638412 2021-02-11 US Florida Gulf 12045 1784 35 0 1749 29.93543004 -85.24270990000002 2021-02-12 05:23:29 Gulf, Florida, US
2638413 2638413 2021-02-11 US Florida Hamilton 12047 1539 21 0 1518 30.49673973 -82.94998918 2021-02-12 05:23:29 Hamilton, Florida, US
2638414 2638414 2021-02-11 US Florida Hardee 12049 2688 24 0 2664 27.49293939 -81.80956574 2021-02-12 05:23:29 Hardee, Florida, US
2638415 2638415 2021-02-11 US Florida Hendry 12051 4166 62 0 4104 26.55386945 -81.16469006 2021-02-12 05:23:29 Hendry, Florida, US
2638416 2638416 2021-02-11 US Florida Hernando 12053 10515 368 0 10147 28.55364461 -82.42700204 2021-02-12 05:23:29 Hernando, Florida, US
2638417 2638417 2021-02-11 US Florida Highlands 12055 6846 282 0 6564 27.34254618 -81.34071957 2021-02-12 05:23:29 Highlands, Florida, US
2638418 2638418 2021-02-11 US Florida Hillsborough 12057 105142 1387 0 103755 27.9276559 -82.32013172 2021-02-12 05:23:29 Hillsborough, Florida, US
2638419 2638419 2021-02-11 US Florida Holmes 12059 2139 41 0 2098 30.86747479 -85.81319222 2021-02-12 05:23:29 Holmes, Florida, US
2638420 2638420 2021-02-11 US Florida Indian River 12061 10324 248 0 10076 27.69308961 -80.60556721 2021-02-12 05:23:29 Indian River, Florida, US
2638421 2638421 2021-02-11 US Florida Jackson 12063 5791 138 0 5653 30.7954597 -85.21500423 2021-02-12 05:23:29 Jackson, Florida, US
2638422 2638422 2021-02-11 US Florida Jefferson 12065 1362 22 0 1340 30.43669112 -83.89442308 2021-02-12 05:23:29 Jefferson, Florida, US
2638423 2638423 2021-02-11 US Florida Lafayette 12067 1543 24 0 1519 29.98484137 -83.18166636 2021-02-12 05:23:29 Lafayette, Florida, US
2638424 2638424 2021-02-11 US Florida Lake 12069 23099 494 0 22605 28.76202069 -81.7125123 2021-02-12 05:23:29 Lake, Florida, US
2638425 2638425 2021-02-11 US Florida Lee 12071 55001 848 0 54153 26.58410348 -81.88399313 2021-02-12 05:23:29 Lee, Florida, US
2638426 2638426 2021-02-11 US Florida Leon 12073 27807 258 0 27549 30.45955727 -84.27491114 2021-02-12 05:23:29 Leon, Florida, US
2638427 2638427 2021-02-11 US Florida Levy 12075 2704 24 0 2680 29.31829741 -82.74007147 2021-02-12 05:23:29 Levy, Florida, US
2638428 2638428 2021-02-11 US Florida Liberty 12077 1019 14 0 1005 30.23766008 -84.8829258 2021-02-12 05:23:29 Liberty, Florida, US
2638429 2638429 2021-02-11 US Florida Madison 12079 1901 39 0 1862 30.44396917 -83.47398594 2021-02-12 05:23:29 Madison, Florida, US
2638430 2638430 2021-02-11 US Florida Manatee 12081 29972 513 0 29459 27.47196942 -82.31831044 2021-02-12 05:23:29 Manatee, Florida, US
2638431 2638431 2021-02-11 US Florida Marion 12083 25948 672 0 25276 29.21227113 -82.05803627 2021-02-12 05:23:29 Marion, Florida, US
2638432 2638432 2021-02-11 US Florida Martin 12085 9994 262 0 9732 27.0772071 -80.43109784 2021-02-12 05:23:29 Martin, Florida, US
2638433 2638433 2021-02-11 US Florida Miami-Dade 12086 389519 5081 0 384438 25.6112362 -80.55170587 2021-02-12 05:23:29 Miami-Dade, Florida, US
2638434 2638434 2021-02-11 US Florida Monroe 12087 5528 42 0 5486 25.20904673 -81.07812416 2021-02-12 05:23:29 Monroe, Florida, US
2638435 2638435 2021-02-11 US Florida Nassau 12089 7381 105 0 7276 30.61037141 -81.80297522 2021-02-12 05:23:29 Nassau, Florida, US
2638436 2638436 2021-02-11 US Florida Okaloosa 12091 17757 301 0 17456 30.69143028 -86.59267105 2021-02-12 05:23:29 Okaloosa, Florida, US
2638437 2638437 2021-02-11 US Florida Okeechobee 12093 3396 69 0 3327 27.386336199999995 -80.88944347 2021-02-12 05:23:29 Okeechobee, Florida, US
2638438 2638438 2021-02-11 US Florida Orange 12095 108209 1015 0 107194 28.51367621 -81.31799498 2021-02-12 05:23:29 Orange, Florida, US
2638439 2638439 2021-02-11 US Florida Osceola 12097 35033 399 0 34634 28.06312234 -81.14882926 2021-02-12 05:23:29 Osceola, Florida, US
2638440 2638440 2021-02-11 US Florida Palm Beach 12099 112964 2302 0 110662 26.64676272 -80.46536002 2021-02-12 05:23:29 Palm Beach, Florida, US
2638441 2638441 2021-02-11 US Florida Pasco 12101 31188 595 0 30593 28.30810945 -82.40227529 2021-02-12 05:23:29 Pasco, Florida, US
2638442 2638442 2021-02-11 US Florida Pinellas 12103 62499 1372 0 61127 27.93130349 -82.72239666 2021-02-12 05:23:29 Pinellas, Florida, US
2638443 2638443 2021-02-11 US Florida Polk 12105 53651 1050 0 52601 27.95027105 -81.69732947 2021-02-12 05:23:29 Polk, Florida, US
2638444 2638444 2021-02-11 US Florida Putnam 12107 5666 109 0 5557 29.60779729 -81.74230285 2021-02-12 05:23:29 Putnam, Florida, US
2638445 2638445 2021-02-11 US Florida Santa Rosa 12113 16308 237 0 16071 30.693414500000006 -87.02458128 2021-02-12 05:23:29 Santa Rosa, Florida, US
2638446 2638446 2021-02-11 US Florida Sarasota 12115 25801 676 0 25125 27.18546175 -82.33174248 2021-02-12 05:23:29 Sarasota, Florida, US
2638447 2638447 2021-02-11 US Florida Seminole 12117 25455 396 0 25059 28.7158582 -81.24060348 2021-02-12 05:23:29 Seminole, Florida, US
2638448 2638448 2021-02-11 US Florida St. Johns 12109 19343 180 0 19163 29.90096506 -81.43589967 2021-02-12 05:23:29 St. Johns, Florida, US
2638449 2638449 2021-02-11 US Florida St. Lucie 12111 20665 521 0 20144 27.37763908 -80.47106649 2021-02-12 05:23:29 St. Lucie, Florida, US
2638450 2638450 2021-02-11 US Florida Sumter 12119 7522 215 0 7307 28.70181754 -82.0794267 2021-02-12 05:23:29 Sumter, Florida, US
2638451 2638451 2021-02-11 US Florida Suwannee 12121 4962 119 0 4843 30.19746066 -82.99099670000003 2021-02-12 05:23:29 Suwannee, Florida, US
2638452 2638452 2021-02-11 US Florida Taylor 12123 2568 37 0 2531 30.04848048 -83.60445406 2021-02-12 05:23:29 Taylor, Florida, US
2638453 2638453 2021-02-11 US Florida Unassigned 90012 3384 0 0 3384 30.86747479 0.0 2021-02-12 05:23:29 Unassigned, Florida, US
2638454 2638454 2021-02-11 US Florida Union 12125 1702 70 0 1632 30.04412971 -82.37497443 2021-02-12 05:23:29 Union, Florida, US
2638455 2638455 2021-02-11 US Florida Volusia 12127 32839 596 0 32243 29.05858895 -81.18263252 2021-02-12 05:23:29 Volusia, Florida, US
2638456 2638456 2021-02-11 US Florida Wakulla 12129 3080 44 0 3036 30.16548905 -84.39895211 2021-02-12 05:23:29 Wakulla, Florida, US
2638457 2638457 2021-02-11 US Florida Walton 12131 6746 76 0 6670 30.64204028 -86.16935664 2021-02-12 05:23:29 Walton, Florida, US
2638458 2638458 2021-02-11 US Florida Washington 12133 2554 38 0 2516 30.61359259 -85.66002461 2021-02-12 05:23: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]);