About this Dataset

COVID-19 Expenditures Report

This dataset is made up of expenditure transactions incurred by City agencies and recorded to a “CV” or “CR” expense budget code in the City's Financial Management System (FMS). The dataset includes accounting entries such as automated accruals and journals. Dollar amounts are in actual dollars. This dataset will be refreshed four times a year and is inclusive of older datasets. To access the most current information, please refer to the most recent “Publication Date.”
Organization: City of New York
Last updated: 2021-08-07T17:40:34.284253
Tags: covid-19-expenditures, nyc-omb

Tables

Table 1

@usgov.city_of_new_york_covid_19_expenditures_report.table_1

39.46 MB
3,996,197 rows
20 columns

CREATE TABLE table_1 (
  "publication_date" BIGINT,
  "agency_name" VARCHAR,
  "agency_code" BIGINT,
  "budget_fiscal_year" BIGINT,
  "unit_of_appropriation" BIGINT,
  "unit_of_appropriation_description" VARCHAR,
  "object_code" VARCHAR,
  "object_code_type" VARCHAR,
  "object_code_description" VARCHAR,
  "expenditure_type" VARCHAR,
  "capital_project_id" VARCHAR,
  "capital_project_description" VARCHAR,
  "budget_code" VARCHAR,
  "budget_object_code_description" VARCHAR,
  "projected_funding_source" VARCHAR,
  "vendor" VARCHAR,
  "date_of_expenditure" TIMESTAMP,
  "document_id" VARCHAR,
  "fms_contract_id" VARCHAR,
  "expenditure_amount" DOUBLE
);