Thread by @AndrewJacksonV3

1) OK, it took me a couple of days, but it'll be a while yet before I get anything useful.

When working with data, my pet peeve is garbage... GIGO...

Methinks the CDC database admin in over his/her head...

@Scavino45 @realDonaldTrump @DonaldJTrumpJr

Cont...

https://twitter.com/AndrewJacksonV3/status/1258355690688729088

2)... First things first, examining the source data from CDC, as of 02 May 2020.

data.cdc.gov/NCHS/Provision…

14 columns in this dataset...

WTH is "Start Week" & "End Week"? (Strike 1). If up to me, SW would be Sunday's date and EW would be Saturday's date - more useful.

Cont...

3)... Anyhoo, gotta deal with the given data. I exported the data to Excel and made a table of it. Plan is to structure the workbook, so I can simply import updates and use pivot charts, formulas etc for review.

Attached is table unfiltered; 87,638 COVID-19 deaths???

Cont...

4)... Table includes U.S. OK, let's filter that out.

🤔 Only 43,622??? But fake news have been screaming over 55k since last Friday.

Cont...

5)... There are also 2 sets of entries, New York and New York City...

🤔 Is NYC a subset of NYS? No clarification from DBA (Strike 2). Assuming NYS, includes NYC, let's filter out NYC...

Only 31,024 COVID-19 deaths?

Cont...

6)... Let's look closer at the NYC vs NYS. Filtering for only those two and filtering only for the past 2 weeks, we see that NYC has more deaths than NYS, ergo "New York" must mean the "Rest of New York"...

Cont...

7)... I downloaded today's updates and the table is twice as large, instead of 14 weeks, I count 28 weeks, apparently all duplicated 🤷‍♂️ (Strike 3). Garbage...

Cont...

8)... Preliminary review of the other categories of death don't add up. As @DrDannielle surmised, perhaps totals are being inflated, or DBA is incompetent.

Either way, I need to analyze the source data to figure out what's going on. I'll update when I have more.

FYI, digging on CDC's data @leestruck7
@realDonaldTrump @Ryvenger1 @derrickstheman @4trumpAmy @anna2539 @Ronin1_Q @rminton @rmartinv316 @DogMa_SuZ @JohnDel90348092 @boy12_jimmy @rdrhwke @JosephSoblosky @darkwolf514 @DaleRobin_ @Elliemaeclampet @MdKnightBabe @RebelSister81