Name: New York City Expense Budget
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

New York City Expense Budget

Content

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.

Context

This is a dataset hosted by the City of New York. The city has an open data platform found here and they update their information according the amount of data that is brought in. Explore New York City using Kaggle and all of the data sources available through the City of New York organization page!

Update Frequency: This dataset is updated annually.

Acknowledgements

This dataset is maintained using Socrata's API and Kaggle's API. Socrata has assisted countless organizations with hosting their open data and has been an integral part of the process of bringing more data to the public.

Cover photo by Josh Couch on Unsplash
Unsplash Images are distributed under a unique Unsplash License.

Tables

Expense Budget

@kaggle.new_york_city_new_york_city_expense_budget.expense_budget

9.77 MB
473,911 rows
26 columns

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