About this Dataset

Construction Pipeline (Historical)

Pursuant to 312(a) of the City Charter, as amended by Local Law 63 of 2011, the Mayor's Office is required to publish a plan and schedule for each City agency detailing the anticipated contracting actions of each agency for the upcoming fiscal year for certain categories of procurement.
Organization: City of New York
Last updated: 2020-11-10T17:03:37.342705
Tags: construction-pipeline

Tables

Table 1

@usgov.city_of_new_york_construction_pipeline_historical.table_1

43.81 kB
576 rows
23 columns

CREATE TABLE table_1 (
  "estimated_bid_date" VARCHAR,
  "agency" VARCHAR,
  "agency_unit" VARCHAR,
  "trade_s" VARCHAR  -- Trade(s),
  "project_description" VARCHAR,
  "award_method" VARCHAR,
  "project_id" VARCHAR,
  "epin" VARCHAR,
  "engineer_s_estimate_amount_in_000s" VARCHAR  -- Engineer's Estimate (Amount In 000s),
  "status_of_bid" VARCHAR,
  "borough_of_work_bronx" VARCHAR  -- Borough Of Work - Bronx,
  "borough_of_work_brooklyn" VARCHAR  -- Borough Of Work -Brooklyn,
  "borough_of_work_manhattan" VARCHAR  -- Borough Of Work -Manhattan,
  "borough_of_work_queens" VARCHAR  -- Borough Of Work -Queens,
  "borough_of_work_staten_island" VARCHAR  -- Borough Of Work -Staten Island,
  "borough_of_work_upstate" VARCHAR  -- Borough Of Work -Upstate,
  "pre_bid_meeting_y_n" VARCHAR  -- Pre-bid Meeting? (Y/N),
  "subject_to_ll1_y_n" VARCHAR  -- Subject To LL1? (Y/N),
  "federal_or_state_goals" VARCHAR  -- Federal Or State Goals?,
  "is_apprenticeship_required_y_n" VARCHAR  -- Is Apprenticeship Required? (Y/N),
  "subject_to_a_pla_y_n" VARCHAR  -- Subject To A PLA? (Y/N),
  "subject_to_damages_for_delay" VARCHAR  -- Subject To Damages For Delay?,
  "onenyc_y_n" VARCHAR  -- OneNYC? (Y/N)
);