About this Dataset

Capital Projects Dashboard - Citywide Schedule History And Variance

This is the history all agency reported forecasts/actual project completion dates. Each row is the snapshot of data taken on each reporting period. The 'completion date type' column shows if the 'completion date' is either a forecast or actual date. Over time, a project would have one or more forecasted completion dates before it is actually completed. The 'variance' is the day difference between 'completion date' of each row and its prior reporting period. This dataset is part of the Capital Projects Dashboard.
Organization: City of New York
Last updated: 2024-03-30T00:07:07.234210
Tags: budget, capital-projects, fms, spend

Tables

Table 1

@usgov.city_of_new_york_capital_projects_dashboard_schedule_h_7f4a9a41.table_1

179.24 kB
13,208 rows
10 columns

CREATE TABLE table_1 (
  "reporting_period" BIGINT,
  "managing_agency" VARCHAR,
  "pid" BIGINT,
  "agency_project_name" VARCHAR,
  "current_phase" VARCHAR,
  "completion_date" TIMESTAMP,
  "completion_date_type" VARCHAR,
  "variance_day" DOUBLE  -- Variance (day),
  "reason_for_forecast_completion_change" VARCHAR,
  "data_date" TIMESTAMP
);