About this Dataset

Contractor Registry Certificate

The dataset includes a comprehensive list of contractor licenses that have been issued to businesses for the purpose of contractor registry assessment and remediation within New York State. Contractor Registry establishes a requirement that contractors register with the Bureau of Public Work and Prevailing Wage Enforcement prior to bidding on public work projects or commencing work on a private covered project that is subject to the prevailing wage.
Organization: State of New York
Last updated: 2025-01-03T17:58:28.936494
Tags: assessment, contractor-registry, license, remediation, work-projects

Tables

Table 1

@usgov.state_of_new_york_contractor_registry_certificate.table_1

766.12 kB
9,186 rows
33 columns

CREATE TABLE table_1 (
  "certificate_number" VARCHAR,
  "business_name" VARCHAR,
  "dba_name" VARCHAR,
  "business_type" VARCHAR,
  "business_is_mwbe_owned" VARCHAR,
  "business_is_publicly_traded" VARCHAR,
  "business_officers" VARCHAR,
  "address" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "phone" DOUBLE,
  "issued_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "status" VARCHAR,
  "business_has_a_nys_dol_employer_registration_number" VARCHAR,
  "reason_business_does_not_have_a_nys_dol_employer_regis_956649f4" VARCHAR  -- Reason Business Does Not Have A NYS DOL Employer Registration Number,
  "business_has_a_wcb_employer_number" VARCHAR,
  "business_has_outstanding_wage_assessments" VARCHAR,
  "business_has_been_debarred" VARCHAR,
  "debarment_state_or_federal_law" VARCHAR,
  "debarment_state" VARCHAR,
  "debarment_start_date" TIMESTAMP,
  "debarment_end_date" TIMESTAMP,
  "business_has_final_determination_for_violation_of_labo_70763195" VARCHAR  -- Business Has Final Determination For Violation Of Labor Or Tax Law,
  "business_has_final_determination_safety_standard_violations" VARCHAR,
  "business_is_associated_with_an_apprenticeship_program" VARCHAR,
  "business_is_sponsor_of_a_program" VARCHAR,
  "business_is_signatory_to_a_group_program" VARCHAR,
  "business_has_workers_compensation_insurance" VARCHAR,
  "business_is_exempt_from_workers_compensation_insurance" VARCHAR,
  "georeference" VARCHAR
);