Pandemic Response Accountability Committee, Coronavirus Relief Fund recipient data dictionary (spreadsheet)

Summary

A spreadsheet data dictionary from the Pandemic Response Accountability Committee for Coronavirus Relief Fund recipient data, with the columns Field Name, Field Definition and Notes. It defines Prime Recipient as all 50 States, units of Local Governments, the District of Columbia, U.S. Territories and Tribal governments that received direct payments from the Department of the Treasury in accordance with Title V of the CARES Act. Its notes say the Award Amount is repeated on every row of the same award, so adding prime award amounts together will result in duplication of the funding. It also defines Sub-recipient as an entity issued a contract, grant, loan, direct payment or government transfer of $50,000 or more, and lists the Award Type values Contract, Grant, Loan, Direct Payment, Transfer and Individual.

Summary drafted by a model from the document's text below and checked by script against that text before publication. It is a navigation aid, not a reading of what the document proves. Where AI is used

Full text

Text extracted from the spreadsheet file: one line per row, cells separated by tabs, each sheet headed by its name. Numbers appear as stored, without the workbook’s formatting.

Sheet: Sheet2
Field Name	Field Definition	Notes
Prime Recipient	All 50 States, units of Local Governments, the District of Columbia, U.S. Territories, and Tribal governments that received direct payments from Department of the Treasury in accordance with Title V of the CARES Act.
Award Amount	The total amount of Coronavirus Relief Fund dollars paid to the prime recipient from the Department of the Treasury	The amount has been repeated on every row of the same award.  Adding the prime award amounts together will result in duplication of the funding.
Sub-recipient	Any entity to which a prime recipient (of CRF funding) issues a contract, grant, loan, direct payment, or government transfer of $50,000 or more or entities that received less than $50,000 that are reported in aggregate.
Sub-recipient-address 1	First line of the sub-recipient organization's  address	The sub-recipient address is associated with the place of performance -- where the work will be performed -- for Contract, Grant, and Loan award types; for Transfer and Direct award types, the address is the physical address for the sub-recipient; for Aggregate award types, the address is the prime recipient's physical location.
Sub-recipient-address 2	Second line of the sub-recipient organization's address
Sub-recipient-address 3	Third line of the sub-recipient organization's address
City	City where the sub-recipient organization is located
County	This field is derived from the sub-recipient's address by the Pandemic Accountability Response Committee
State	United States Postal Service two-letter abbreviation for the state or territory where the sub-recipient organization is located
Zip	United States five digit Zip code concatenated with the additional +4 digits (if available) associated with the sub-recipient organization's address.
Sub-recipient congressional district	This field is derived from the sub-recipient's address by the Pandemic Accountability Response Committee.  Each congressional district (if available) begins with the two-letter state or territory abbreviation where the sub-recipient organization is located.
Award number	Prime recipient's internal account number for the award; the account number or any other identifying number assigned by the prime recipient to the award. This number is strictly for the prime recipient’s use only. Award numbers are not captured for the direct payments.
Award Type
	• Contract: An agreement between the prime recipient and the sub-recipient to provide goods or services for a fee.
	• Grant: Financial assistance from the prime recipient to the sub-recipient for a public project or service.
	• Loan: Award by prime recipient to sub-recipient that may be required to be paid back.
	• Direct Payment: A cash payment made by the prime recipient to an individual, private company, or institution.
	• Transfer: Funds from the prime recipient to another government entity, such as a state transferring funds to a city government
	• Individual: Payments by the prime recipient to individuals (reported in aggregate) which include payroll costs to individuals and any other payments to individuals regardless of the amount.
	• Contract, Grant, Loan, Transfer, Direct Aggregates: Less than $50,000 payments by the prime recipient for contracts, grants, transfers, loans, and direct payments. These payments are aggregated.
Award description	A brief description of the purpose of the award. award descriptions are not captured for the direct payments
Sub-award amount	Total amount of funding from the prime recipient to the sub-recipient organization.	The amount has been repeated on every row of the same award.  Adding the sub-award amounts together will result in duplication of the funding.
Money spent to date	Expenditure amount incurred by the sub-recipient organization as a result of the service being rendered or the goods delivered
Project description	A description of the overall purpose and expected outputs and outcomes or results of the project or activity funded by the Coronavirus Relief Fund (if available), including significant deliverables and, if appropriate, associated units of measure.
Project status	The status of work that has been completed = Not Started, Completed 50% or More, Fully Complete (if available)
Spending category	The self-reported classification most closely related to the purpose of an obligated cost or expenditure. Categories include:
	• Payroll for public health and safety employees
	• Budgeted personnel and services diverted to a substantially different use
	• Improve telework capabilities of public employees
	• Medical expenses
	• Public health expenses
	• Distance learning
	• Economic support
	• Expenses associated with the issuance of tax anticipation notes
	• Administrative expenses
	• Nursing home assistance
	• Housing support
	• Small business assistance
	• Personal protective equipment
	• Food programs
	• Unemployment benefits
	• Covid-19 testing and contact tracing
	• Workers’ compensation
	• Items Not Listed Above: Includes other eligible expenses manually entered by the prime recipient. See "Category Description" for details.
Category Description	Includes details of eligible expenses manually entered by the prime recipient.

File and source

File

DATA_PRAC_CRF-data-dictionary.xlsx

Size

22,559 bytes

SHA-256

96e08cdeb97f1d92ffcc53bb477336e34a3cc435be30a890234427421dc783e7

Our copy

DATA_PRAC_CRF-data-dictionary.xlsx

Original

www.pandemicoversight.gov