September 09, 2021
OK. Just finished loading the latest CDC RIDURA data (detailed, deidentified individual case data for every COVID case since the beginning of the "pandemic")...
This particular run includes all hospitalization
From now on, when I post something like this, I will include the SQL code that generated it, the results, and a screen shot of the table structure.
Summary...
In the 90 day period between 6/1/2021 and 8/31/
INDIAN RIVER - 41
MARTIN - 116
ST. LUCIE - 129
That is not even CLOSE to a spike. In fact, at around 43/month, I'm surprised that anyone has the audacity to suggest that the hospitals are overrun. If they are, then the CDC or the state health departments are not reporting them through the approved channels. That ALONE should give us pause.
More to come.
Generating SQL
SELECT res_county, Count(*) as cases
FROM [COVID_Case_Dat
WHERE 1=1
AND res_state = 'FL'
AND hosp_yn = 'Yes'
AND cdc_case_earlie
group by res_county
order by res_county asc
res_county cases
ALACHUA 79
BAKER 30
BAY 201
BRADFORD 33
BREVARD 365
BROWARD 712
CALHOUN 10
CHARLOTTE 59
CITRUS 107
CLAY 93
COLLIER 90
COLUMBIA 48
DESOTO 11
DIXIE 8
DUVAL 320
ESCAMBIA 273
FLAGLER 64
FRANKLIN 3
GADSDEN 29
GILCHRIST 7
GLADES 8
GULF 13
HAMILTON 9
HARDEE 21
HENDRY 29
HERNANDO 85
HIGHLANDS 38
HILLSBOROUGH 129
HOLMES 7
INDIAN RIVER 41
JACKSON 67
JEFFERSON 14
LAFAYETTE 5
LAKE 174
LEE 161
LEON 74
LEVY 19
LIBERTY 3
MADISON 11
MANATEE 86
MARION 242
MARTIN 116
MIAMI-DADE 1341
MISSING 8
MONROE 11
NASSAU 70
OKALOOSA 68
OKEECHOBEE 26
ORANGE 265
OSCEOLA 120
PALM BEACH 401
PASCO 256
PINELLAS 289
POLK 152
PUTNAM 104
SANTA ROSA 75
SARASOTA 131
SEMINOLE 95
ST. JOHNS 190
ST. LUCIE 129
SUMTER 29
SUWANNEE 24
TAYLOR 13
UNION 7
VOLUSIA 272
WAKULLA 9
WALTON 40
WASHINGTON 9
Posted by: Timothy Birdnow at
08:09 AM
| No Comments
| Add Comment
Post contains 350 words, total size 3 kb.
35 queries taking 0.2168 seconds, 183 records returned.
Powered by Minx 1.1.6c-pink.








