Santa Clara County released the most detailed look yet at its pandemic-related spending.

In a memo issued Tuesday to the Board of Supervisors, county Finance Director Alan Minato said he identified 2,300 expenditures from at least seven different departments. All told, they amount to nearly $97.5 million budgeted as of May 19 to address the crisis.

Of the $28 million spent on payroll by that time, the vast majority—upward of $9 million—went to Valley Med. Another $6.5 million covered employees assigned to the Emergency Operations Center while $3 million went to the Public Health Department and $2.3 million to the Sheriff’s Office.

Source: Santa Clara County Department of Finance

Minato noted that payroll costs are “significantly understated,” and that the figures presented reflect the best estimates so far. “An effort is underway to account for further costs and work with departments to ensure that payroll is tracked appropriately,” he explained in the written summary.

Meanwhile, the county spent about $480,000 on clothing, helmets, goggles, masks and other equipment designed to shield frontline workers from disease. Additional personal protective gear came from the state at no cost to the county.

About $1.6 million has paid for motels, inns and hotels and $1.1 million on labs, testing sites and diagnostic equipment. Some $1.6 million went to contract nursing, $274,000 to daycare for essential workers, $182,000 to transporting patients and clients, $138,000 to consultants and $130,000 to janitorial services.

More than $2 million funded donations to the Silicon Valley Community Foundation, Destination: Home and an unnamed behavioral health organization.

Information technology gobbled up $3.5 million, medical and plastic supplies $351,000, renovations at DePaul Health Center $200,000 and meals $127,000.

Pharmaceutical costs veered up to $10 million.

Roughly $49 million is spoken for in yet-to-be-paid purchase orders.

The financial disclosures come three months after the county declared a state of emergency, which expanded the administration’s authority to fight the crisis, and weeks after the board allocated $175 million for COVID-related spending.

As weeks turned into months, however, demands for transparency began to escalate. They culminated with a referral by supervisors Susan Ellenberg and Dave Cortese for the county to create a public web portal showing exactly where the money went.

Their joint proposal—which directs the county to create the data hub “as quickly as possible”—won unanimous approval today from the five-member board.

Ellenberg and Cortese held up dashboards launched by St. Louis and New York City as models. The referral directs the county to publish a breakdown of all emergency expenses by date, type, vendor, department and eligibility for federal or state reimbursement.

They said the portal should also list how much the county spends on meeting the key benchmarks it must meet to ease shelter-in-place restrictions. Metrics such as hospital capacity, COVID-19 testing, contact tracing and isolation and maintaining a month’s supply of protective equipment for healthcare workers.

In a statement emailed to San Jose Inside after the vote, Ellenberg applauded her cohorts for advancing the measure.

“With the enormous sacrifice our residents are being asked to make to fight the COVID virus, we owe them in return the greatest level of transparency in our effort to contain the virus and move us away from a shelter-in-place order,” she said. “Today’s approval ... is expected to present information in a manner that will be clear and easily digestible for the public. I look forward to seeing this dashboard online as soon as possible.”

In a phone call Tuesday evening, Cortese echoed his colleague.

“I think this is extremely important to maintain the confidence of the public, including by showing them what it’s costing, how much taxpayer money is being invested to address this crisis,” he told San Jose Inside during few-minute break from the board meeting.

Normally, the county’s emergency spending powers have a distinct end date. But the protracted nature of the pandemic presents new, ongoing challenges, County Executive Jeff Smith reminded the board today. “COVID is not going away any time soon,” he said, adding, “we have no immunization on the horizon, no specific treatment and no other approach that’s proven effective except shelter in place.”

Below is a transcript of Minato’s memo. 

Total County Costs and Encumbrances through May 19, 2020, Related to COVID-19 

Background: On May 12, 2020, the Board of Supervisors appropriated an initial $175,099,960 into a new COVID-19 fund in order to better track revenues and expenditures related to the county’s efforts in fighting the COVID-19 virus. During this meeting, Supervisor Ellenberg requested that staff return with an off-agenda report to the board with a breakout of costs by the following categories: EOC Personnel, Testing, Personal Protective Equipment, Specific Services related to COVID-19, and Housing Support.

Analysis: As of May 19, 2020, the county has expended $49,345,210 for COVID-19 related activities (payroll and services and supplies). Please note that this information (2,300 lines of cost information) was extracted from at least seven different county databases that collect financial information and was quickly analyzed and categorized by numerous finance agency and department staff members. The amounts presented have not been audited by the finance agency or department managers as there was limited time available before this report was due. As we move forward towards claiming relating to reimbursement, amounts will be thoroughly reviewed by supervisory staff as well as by a consulting firm with detailed knowledge of FEMA and CARES Act reimbursement requirements.

Please note that the $49,345,210 only accounts for those funds that have been expended, meaning that payment has been processed and sent to the vendor. This amount does not include encumbrances, which are commitments to pay. These encumbrances result from the time lag between time of purchase (e.g., contract and purchase order) and time of payment. Encumbrances for services and supplies amount to an additional $48,095,954 for a total cost as of May 19, 2020 of $97,441,164.

Payroll costs of $26,874,672 were tracked by coding recorded on individual employee time sheets and activity logs completed by staff assigned to the Emergency Operations Center (EOC). The county departments with significant costs include Valley Medical Center ($9,085,682) for treatment of COVID-19 patients, the EOC ($6,548,832), the Public Health Department ($2,963,199) for detection, training, outreach and oversight of the pandemic, and the Office of the Sheriff ($2,281,780) to mitigate risk and exposure of the virus to staff, contact tracing analysis and investigation of inmates and staff to COVID-19 exposure and to provide security services.

PPE costs of $480,119 include protective clothing, helmets, goggles, face masks or other garments or equipment designed to protect the wearer’s body from injury or infection. The significant amount of PPE provided to the county via the state mutual aid system is provided at no county cost.

Housing Support of $1,586,190 includes motels, inns and hotels.

Testing costs of $1,089,312 include labs, testing locations, testing equipment, checkpoint testing and nasal swabs.

Specific Services of $2,572,833 include many different contracts and services related to COVID-19. The top categories include $1,633,521 for medical staffing (mainly contract nursing), $273,907 for daycare provided to children of essential workers, $182,267 for transporting patients and clients, $137,786 for consulting services, and $129,198 for janitorial services at testing sites and other locations.

Medical costs of $9,926,700 consist mainly of medicine and drug costs.

Donations of $2,042,600 were for donations to Silicon Valley Community Foundation, Destination: Home, and a behavioral health community-based organization as approved by the Board of Supervisors.

Other costs of $4,772,784 are composed of about two dozen expense categories. It includes $3,544,711 for IT equipment and services, $351,453 for medical and plastic supplies, $201,293 from the County’s Facilities and Fleet department for renovations made to the DePaul Medical Center and interior modifications made to fleet vehicles, and $126,550 for meals and food provided to County clients and community members as well as to EOC staff.

Encumbrances of $48,095,954 are services and supplies that are in the purchase order stage. This means that the county has procured the items or services but has not yet expended funds on them. Because of this, the information is more difficult to access and will require review of detailed order information. The analysis of the encumbrances will be shared in a future report.

Please note that the finance agency believes that payroll cost amounts are significantly understated. An effort is underway to account for further costs and work with departments to ensure that payroll is tracked appropriately.