This is an analysis of some of the Covid Relief Funds that you are not going to find on the official web site.
The source of the data is located here at https://www.pandemicoversight.gov/. Also, a shout out to the Professor’s Record for providing an interview about this topic here.
The data structure in this spreadsheet starting with Col 1 is the following:
Prime Recipient
Award Amount (per Prime Recipient)
Total Funds Received (per Prime Recipient)
Sub-recipient
Sub-recipient address 1, 2 and 3
City
State
Zip
County
Congressional District
Award Number
Award Type
Award Description
Sub-award
Money spent to date
Project description
Project status
Spending category
Category description
Recipient Counts
There are 2,972 prime recipients with 229,427 line items. There are 77,752 sub recipients associated with these 2,972 prime recipients.
Prime Recipients Award Counts - Top 20
Sub Recipients Counts - Top 20
This includes 17,099 blanks assignments, 799 multiple assignments and 720 that are not yet available for public display.
Sample of Prime Recipient Amounts Top 20
Sample of Sub Recipient Amounts Top 20
This includes 58 Billion that are for Multiple Recipients. 9.4 Billion that are not yet available for public display.
Summary by State of Sub-Award Amount
Sample of Top 20 Cities by Award Count
This includes 21,768 that don’t have a city specified.
Sample of Top 20 Counties by Award Count
This includes 22,779 that don’t include a county specified.
Sample of Top 20 Cities by Award Amount
This includes 9.4 Billion that don’t include a city.
Sample of Top 20 Counties by Award Amount
This includes 9.4 Billion that don’t include a county.
Sample of Top Congressional Districts by Award Amount
This includes 9.4 Billion that is not specified by congressional district.
Summary of Spending Category Counts
This includes 33,280 that don’t have a spending categories assigned.
Summary of Sub-Award Amounts by Spending Category
This includes 69 Billion in non-specified spending categories.
Summary of Sub-Award Amounts by University
Summary of Sub-Award Amounts by LLC
Summary of Sub-Award Amounts by INC
Sub-Award Amounts Including The Word “BALLOT”
The total is ~14 Million.
Sub-Award Amounts Including The Word “Dominion”
The total is ~4.4 Million.
Sub-Award Amounts Including The Word “Hart”
The total is ~814,000.
Sub-Award Amounts Including The Word “ES&S”
The total is ~1.4 Million
Sub-Award Amounts Including The Word “Runbeck”
The total is ~1.1 Million
Sub-Award Amounts Including The Word “Sushi”
The total is ~1.8 Million
Sample of Sub-Award Amounts Including The Word “Pizza”
The total is ~8.9 Million. Delaware has the most PIZZA awards
Sub-Award Amounts Including The Word “Taco”
The total is ~580,000
Hey EDA! We should be talking. I'm the old guy that David interviewed.
s/The Ole' Buzzard
Be curious to see report on what lines are whole numbers for example;
ARIZONA COMMUNITY ACTION ASSOCIATION with received $29,000,000 Million dollars. That's one huge number for an organization that states...
"ACAA publishes the People's Information Guide (PIG), a comprehensive directory of services and organizations where people can go for help. A PDF version of the PIG can be downloaded, and viewed or printed, from the ACAA web site at the following address:
●http://www.azcaa.org"
PROBLEM: When you click on that link it hangs and finally goes to https://wildfireaz.org
How convenient that they get $29,000,000 and then suddenly change their name and website. Google reviews look suspicious as well. A number of one star ratings people not getting help.
I think it would be interesting to see big numbers that are obviously lacking in accountability.
(Source https://dbmefaapolicy.azdes.gov/index.html#page/FAA6/Arizona_Community_Action_Association_(ACAA).html)
EDA once again with eye opening content. Outstanding work.