IBO Federal Stimulus Budget and Spending Tracker (ARPA and CRRSAA)

sg72-pis5City Government12 columns

This dataset contains budget and spending data for City Initiatives that use American Rescue Plan Act of 2021 (ARPA) or Coronavirus Response and Relief Supplemental Appropriations Act of 2021 (CRRSAA) federal funds. Each row is a different "Initiative Detailed", which is IBO's understanding of the purpose of the funding. IBO developed seven categories of initiative to standardize the comparison of budgeted and spent amounts across agencies: "Initiative Category". The IBO definitions of these categories are below, in order of prioritization (e.g. if a budget code fits the definition of 2. COVID Response – Public Programs and 4. Programmatic Support, it is listed under 2). If readers require more detailed information on spending, the underlying data with the previous initiative names is available for download. 1. Covid Response – City Operations: Spending to keep city agencies operating during the Covid pandemic, such as city employee leave for quarantining and vaccinations, air purifiers, personal protective equipment (PPE) for city employees, etc. 2. Covid Response – Public Programs: Programs created to protect people in New York City from Covid-19. 3. Direct Human Services: Public services provided to meet the financial, physical, or mental needs of New York City residents. This includes ongoing services for housing, food, addiction treatment, childcare, education, anti-poverty, etc. These services are either provided by the government or a nonprofit. 4. Programmatic Support: Funds used on temporary governmental programs. Note: this includes youth training and summer work programs because they are optional and extra-curricular, while public education and adult job training programs are direct human services. 5. Government Operations: Federal funding supplemented lost revenue during the pandemic-related recession. These funds are for Other than Personal Spending, those administrative costs or public services provided in perpetuity (as opposed to services defined as Programmatic Support). 6. Personnel/Staffing: Federal funding supplemented lost revenue during the pandemic-related recession. These funds are for salaries and wages paid to city employees, often called “Personal Services.” Salaries and wages related to Covid response, temporary programs, and direct human services are excluded from this category. 7. Hiring & Attrition Management: Administrative costs related to managing the inflow and outflow of city employees.

View on NYC Open Data

Quality

D65.0 / 100

From a 299-row sample across 12 columns.

completeness75/ 25% weight

consistency63/ 20% weight

accuracy84/ 20% weight

timeliness0/ 15% weight

usability85/ 20% weight

· No obvious temporal column — limits time-series joins

Related datasets

Mayor's Management Report Spending and Budget

Sample rows

agency	initiative_category	initiative_detailed	budget_2021	budget_2022	spent_2022	spent_2023	spent_2024	spent_2021	budget_2023	budget_2024	budget_2025
MAYORALTY	Personnel/Staffing	Personal Services	34296	2742789	480125	10127	0	—	—	—	—
MAYORALTY	Covid Response - City Operations

Columns

12 queryable · 12 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`agency`	text	NYC Agency Name	0%	`DEPARTMENT OF EDUCATIONDEPARTMENT OF HEALTH AND…DEPARTMENT OF TRANSPORTA…`
`initiative_category`	categorical	IBO developed seven categories of initiative to standardize the comparison of budgeted and spent amounts across agencies.	0%	`Covid Response - City Op…Government OperationsPersonnel/Staffing`of 8
`initiative_detailed`	text	City initiative for which federal stimulus dollars from either the American Rescue Plan Act of 2021 or the Coronavirus Response and Relief Supplemental Appropriations Act of 2021 are budgeted or have been spent.	0%	`OtherGovernment OperationsCovid Related Leave`

Query this from your own app

GET /api/datasets/sg72-pis5
GET /api/datasets/sg72-pis5/quality
GET /api/datasets/sg72-pis5/related
GET /api/columns?dataset=sg72-pis5