Name: Prequalified Firms
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Prequalified Firms

List of firms qualified to perform work for the School Construction Authority, their trades, and the end date of their qualification.
Organization: City of New York
Last updated: 2020-11-10T17:05:18.358793
Tags: authority, companies, company, construction, education, firm, qualification, qualified, qualify, sca, school, trade, work

Tables

Table 1

@usgov.city_of_new_york_prequalified_firms.table_1

245.01 KB
5688 rows
15 columns


CREATE TABLE table_1 (
  "prequalified_vendor_master_trade_code" VARCHAR,
  "prequalified_vendor_trade_description" VARCHAR,
  "prequalified_vendor_name" VARCHAR,
  "prequalified_vendor_address" VARCHAR,
  "prequalified_vendor_city_name" VARCHAR,
  "prequalified_vendor_state_code" VARCHAR,
  "prequalified_vendor_zip_code" VARCHAR,
  "prequalified_vendor_phone_number" VARCHAR,
  "prequalified_vendor_fax_number" VARCHAR,
  "prequalified_vendor_contact_person" VARCHAR,
  "prequalified_vendor_minority_business_indicator" VARCHAR,
  "prequalified_vendor_women_business_indicator" VARCHAR,
  "prequalified_vendor_local_business_indicator" VARCHAR,
  "prequalified_vendor_over_million_dollar_revenue_indicator" VARCHAR,
  "prequalified_vendor_date" TIMESTAMP
);