About this Dataset

Expense Budget

This dataset contains expense agency data by unit of appropriation for the Adopted, Financial Plan and Modified conditions by object code. The numbers within can be summarized to be consistent with data from either the Supporting Schedule, Departmental Estimate or the Expense, Revenue, Contact Budget. This dataset is updated three times per year after publication of the Preliminary, Executive and Adopted Budget, usually in January, April and June respectively.
Organization: City of New York
Last updated: 2020-11-10T17:04:17.475354

Tables

Table 1

@usgov.city_of_new_york_expense_budget.table_1

19.3 MB
999,383 rows
26 columns

CREATE TABLE table_1 (
  "publication_date" BIGINT,
  "fiscal_year" BIGINT,
  "agency_number" VARCHAR,
  "agency_name" VARCHAR,
  "unit_appropriation_number" BIGINT,
  "unit_appropriation_name" VARCHAR,
  "budget_code_number" VARCHAR,
  "budget_code_name" VARCHAR,
  "object_class_number" BIGINT,
  "object_class_name" VARCHAR,
  "object_code" VARCHAR,
  "object_code_name" VARCHAR,
  "intra_city_purchase_code" DOUBLE,
  "responsibility_center_code" VARCHAR,
  "responsibility_center_name" VARCHAR,
  "personal_service_other_than_personal_service_indicator" VARCHAR,
  "financial_plan_savings_flag" VARCHAR,
  "adopted_budget_amount" BIGINT,
  "current_modified_budget_amount" BIGINT,
  "financial_plan_amount" BIGINT,
  "adopted_budget_position" BIGINT,
  "current_modified_budget_position" BIGINT,
  "financial_plan_position" BIGINT,
  "adopted_budget_number_of_contracts" BIGINT  -- Adopted Budget - Number Of Contracts,
  "current_modified_budget_number_of_contracts" BIGINT  -- Current Modified Budget - Number Of Contracts,
  "financial_plan_number_of_contracts" BIGINT  -- Financial Plan - Number Of Contracts
);