covid19-florida
covid19-florida copied to clipboard
gadenbuie
Florida COVID19 Data parsed from Florida DOH Dashboard and PDF reports
Florida COVID-19 Data
2020-11-03 11:08:41
Today
| When | Day | Positive | New Positive Since | Deaths | New Deaths Since | Total |
|---|---|---|---|---|---|---|
| Yesterday | 2020-11-02 | 812,063 | 0 | 17,043 | 0 | 6,223,860 |
| The Day Before | 2020-11-01 | 807,412 | 4,651 | 16,997 | 46 | 6,199,281 |
| Last Week | 2020-10-27 | 786,311 | 25,752 | 16,709 | 334 | 6,014,492 |
| 2 Weeks Ago | 2020-10-20 | 760,389 | 51,674 | 16,308 | 735 | 5,767,947 |
Parsed from the Florida’s COVID-19 Data and Surveillance Dashboard.
Prior to 2020-04-25, Florida DOH published updated data twice per day. Starting 2020-04-25, Florida DOH updates once per day at approximately 11am. Since 2020-05-06, the updates are occasionally later in the day. In the following charts, for a given day, I use the last value reported prior to 8am of the subsequent day. I take snapshots of the various FL DOH data sources at 7am, noon and 7pm daily.
Confirmed Cases
Hospital and ICU Utilization
| County | Current COVID Hospitalizations | Change Since Yesterday | Available Hospital Beds | Available ICU Beds |
|---|---|---|---|---|
| All | 2474 | ↑ 63 | 16619/44187 | 1659/4481 |
| Miami-Dade | 332 | ↓ -1 | 2632/6085 | 260/709 |
| Broward | 239 | ↑ 2 | 1154/3992 | 117/397 |
| Hillsborough | 174 | ↑ 8 | 881/3144 | 72/321 |
| Palm Beach | 153 | ↑ 4 | 1344/2650 | 147/247 |
| Orange | 150 | ↑ 13 | 1158/3267 | 153/247 |
| Duval | 135 | ↓ -2 | 1041/2601 | 118/316 |
| Pinellas | 127 | ↑ 4 | 922/2229 | 69/241 |
| Polk | 86 | ↑ 9 | 428/1246 | 54/126 |
| Osceola | 72 | ↑ 1 | 313/840 | 43/80 |
| Alachua | 69 | 339/1358 | 68/240 |
Daily Testing
Cases and Deaths by Age
Sources
-
PDF Reports released daily on Florida Disaster Covid-19
The data structure and format of the released data changes frequently. I’m keeping track of the impact of these changes in this repo in NEWS.md.
FL DOH Dashboard
One table is extracted from the Florida’s COVID-19 Data and Surveillance Dashboard.
- Current test counts: data/covid-19-florida_dash_summary.csv
The timestamp column of indicates when the dashboard was polled for
changes.
Testing statistics prior to 2020-03-16 18:00:00 EDT were imported from https://covidtracking.com.
Snapshots and Data Capture
Initially this repo gathered data from the Florida Department of Health COVID-19 status page. This page has been reformatted several times and the data structure changes frequently, so currently I am collecting snapshots of the webpage and not trying to parse these tables.
I am also capturing a snapshot (HTML) and screenshot of the Florida’s COVID-19 Data and Surveillance Dashboard. Data extracted from the dashboard are currently used for the current test count summaries, available in covid-19-florida-tests.csv.
Prior to the afternoon of 2020-03-18, the dashboard reported county-level case counts. Around 4pm on 2020-03-18, the dashboard layout was modified, making these counts inaccessible. Similarly, prior to this update I was relying on the reported “last update time” listed in the dashboard, but since then I have been using the time at which the dashboard was checked for any time stamps from this source.
On the same day that county-level data became inaccessible in the
dashboard, FL DOH started releasing PDF reports, which I have begun to
collect in pdfs/. The name of the report contains a time stamp,
therefore I am periodically checking the FL DOH web page for the updated
link. I’ve been able to extract most of the data from the PDF tables.
Individual tables are stored in time stamped folders, using the time
stamp in the PDF file name. The unified data files are available in
data/ and prefixed with covid-19-florida_pdf_.
gadenbuie