About this Dataset

Capital Projects Dashboard - Citywide Budget And Schedule

All major capital infrastructure projects with a committed budget. Financial information and agency schedule details for each project are joined via FMS ID. Only projects in the design phase or later have project schedules displayed. This dataset is part of the Capital Projects Dashboard. Note: Each row is uniquely identified by its Financial Management Service (FMS) ID. FMS ID is the unique ID that OMB uses for the FMS (Financial Information System). This ID can be universally joined with any OMB dataset that has the same field. The Capital Projects Dashboard is the result of joining OMB’s fiscal data with the agency’s schedule data. FMS IDs and agency projects don't always have a one-to-one relationship (i.e., one project schedule may correlate to multiple FMS IDs, and one FMS may correct to multiple projects with different schedules).
Organization: City of New York
Last updated: 2023-12-22T15:43:53.613276
Tags: budget, capital-projects, fms, spend

Tables

Table 1

@usgov.city_of_new_york_capital_projects_dashboard_budget_and_3cc528b9.table_1

1.27 MB
33682 rows
27 columns


CREATE TABLE table_1 (
  "reporting_period" BIGINT,
  "managing_agency" VARCHAR,
  "sponsor_agency" VARCHAR,
  "pid" DOUBLE,
  "fms_id" VARCHAR,
  "total_budget" DOUBLE,
  "spend_to_date" DOUBLE,
  "spend_to_date_dddd19" DOUBLE,
  "fms_project_name" VARCHAR,
  "agency_project_name" VARCHAR,
  "agency_project_description" VARCHAR,
  "current_phase" VARCHAR,
  "current_phase_start" TIMESTAMP,
  "forecast_current_phase_end" TIMESTAMP,
  "forecast_completion" TIMESTAMP,
  "actual_design_start" TIMESTAMP,
  "actual_design_end" TIMESTAMP,
  "actual_construction_procurement_start" TIMESTAMP,
  "actual_construction_procurement_end" TIMESTAMP,
  "actual_construction_start" TIMESTAMP,
  "actual_construction_end" TIMESTAMP,
  "borough" VARCHAR,
  "community_board" VARCHAR,
  "budget_line" VARCHAR,
  "ten_year_plan_category" VARCHAR,
  "agency_data_date" TIMESTAMP,
  "fms_data_date" TIMESTAMP
);