About this Dataset

Revenue Budget & Financial Plan -- Exec\Adpt\Prel

This dataset contains agency revenue data for Adopted, Modified and five years of Financial Plan by Revenue Class, Revenue Category and Revenue Source (Revenue Structure) or FPS Group name. The numbers within can be summarized to match pages 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:05:36.029009

Tables

Table 1

@usgov.city_of_new_york_revenue_budget_financial_plan_execadptprel.table_1

1.22 MB
49,850 rows
23 columns

CREATE TABLE table_1 (
  "publication_date" TIMESTAMP,
  "fiscal_year" DOUBLE,
  "fundind_source_name" VARCHAR,
  "fps_group" BIGINT,
  "fps_group_name" VARCHAR,
  "agency_number" BIGINT,
  "agency_name" VARCHAR,
  "revenue_category" BIGINT,
  "revenue_category_name" VARCHAR,
  "revenue_class_code" BIGINT,
  "revenue_class_name" VARCHAR,
  "budget_code" VARCHAR,
  "revenue_source" BIGINT,
  "revenue_source_name" VARCHAR,
  "revenue_structure_description" VARCHAR,
  "adopted_budget_amount" DOUBLE,
  "current_modified_budget_amount" DOUBLE,
  "yr1_fy" BIGINT,
  "year_1_revenue_amount" BIGINT,
  "year_2_revenue_amount" BIGINT,
  "year_3_revenue_amount" BIGINT,
  "year_4_revenue_amount" BIGINT,
  "year_5_revenue_amount" BIGINT
);