Dataset: Capital Projects

About this Dataset

Capital Projects

All major infrastructure and information technology projects with a budget of $25 million or more that are currently active (in the design, procurement, or construction phase).
Organization: City of New York
Last updated: 2020-11-10T17:04:21.131152
Tags: capital-projects, construction, design, information-technology, infrastructure, it, procurement, school-construction

Tables

Table 1

@usgov.city_of_new_york_capital_projects.table_1

127.51 KB
3320 rows
16 columns


CREATE TABLE table_1 (
  "date_reported_as_of" VARCHAR,
  "pid" BIGINT,
  "project_name" VARCHAR,
  "description" VARCHAR,
  "category" VARCHAR,
  "borough" VARCHAR,
  "managing_agency" VARCHAR,
  "client_agency" VARCHAR,
  "current_phase" VARCHAR,
  "design_start" TIMESTAMP,
  "budget_forecast" DOUBLE,
  "latest_budget_changes" DOUBLE,
  "total_budget_changes" DOUBLE,
  "forecast_completion" TIMESTAMP,
  "latest_schedule_changes" DOUBLE,
  "total_schedule_changes" DOUBLE
);