About this Dataset

Industrial & Commercial Abatement Program (ICAP) Businesses That Received EO50 Certificate Of Approval From SBS

This dataset contains a list of ICAP businesses that have successfully complied with Equal Employment Opportunity (EO 50) requirements and have received EO50 certificate of approval from the NYC Department of Small Business Services (SBS). Executive Order No. 50 was established in 1980 during Mayor Koch's tenure. It mandates that all contractors adhere to equal employment principles, explicitly prohibiting discriminatory hiring practices. This order safeguards individuals from discrimination based on ten protected categories: race, sex, creed, age, color, disability, national origin, marital status, sexual orientation, and citizenship status.
Organization: City of New York
Last updated: 2020-11-10T17:01:29.349595
Tags: construction-opportunities, icap, sbs

Tables

Table 1

@usgov.city_of_new_york_sbs_icap_contract_opportunities.table_1

80.29 kB
915 rows
16 columns

CREATE TABLE table_1 (
  "eo50_approval_date" TIMESTAMP,
  "business_name" VARCHAR,
  "business_address" VARCHAR,
  "business_city" VARCHAR,
  "business_state" VARCHAR,
  "business_phone" VARCHAR,
  "postcode" DOUBLE,
  "borough" VARCHAR,
  "community_board" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);