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

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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/ibo-federal-stimulus-budget-and-spending-tracker-sg72-pis5\".\"ibo_federal_stimulus_budget_and_spending_tracker\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.