From a 500-row sample across 54 columns.
council_districtbinstate+7council_districtbinstate+6binstateborough+4council_districtbinborough+3Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| account_number | vendor_formal_name | vendor_dba | first_name | last_name | telephone | business_description | certification | cert_renewal_date | ethnicity | address1 | city |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 373634 | “I AM” EHS Management LLC | “I AM” EHS Management LLC | Kirt | Asson | 9147712515 | In 2006, I had the opportunity to join NYC Sandhog Union 147, working in mining and tunneling. Back then, safety practices were minimal, and the culture around workplace safety was not a priority. However, over the years, I witnessed a significant shift—new safety regulations were introduced, management became more engaged, and a stronger emphasis was placed on safe work practices. As a result, injuries decreased, and work became more efficient. Recognizing this transformation, I felt inspired to be part of the movement. In 2016, I founded “I AM” EHS Management LLC with the goal of contributing to the workforce and supporting businesses in creating safer, more effective work environments. |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
account_number | text | Vendor Number | 0% | 370434101812339281 |
vendor_formal_name | text | Formal Name of the Company | 0% | Group Coaching HQ LLCRJS Security Services, I…Madeline Vera |
vendor_dba | text | Name the Company goes by | 86% | 101 Mobility10Cube Studio128-12 18th Ave LLC (RE … |
first_name | text | First Name of the Company's Contact Person | 0% | JenniferMichael |
GET /api/datasets/ci93-uc8s GET /api/datasets/ci93-uc8s/quality GET /api/datasets/ci93-uc8s/related GET /api/columns?dataset=ci93-uc8s
council_districtbinlatitude+3council_districtbinlatitude+3statezipcitycouncil_districtbinstate+6| MBE |
| 3/31/2029 |
| BLACK |
| 54 Pyngyp Rd |
| Stony point |
| 377031 | 000 Architecture PLLC | — | Jedy | Lau | 2012561092 | 000 Architecture PLLC is an architectural studio. | MBE | 3/31/2030 | ASIAN | 616 E9th Street | New York |
| 315255 | 1 Oak Tasty Deli Inc. | — | Santiago | Francisco | 2129230700 | 1 Oak Tasty Deli supplies food for events, gatherings, trips, and school lunches. | MBE | 4/30/2029 | HISPANIC | 4020 Broadway Avenue | New York |
| 342721 | 1 Of A Kind Home Health Care L.L.C. | — | Andrea | David | 7183008023 | NYS Licensed Home Health Agency | MBE,WBE | 03/31/2027;03/31/2027 | BLACK | 148 George Street | Brooklyn |
| 216904 | 1 Venus Fire Safety, Inc. | Venus Fire Protection and Safety Service | John | Tran | 7182153892 | 1 Venus Fire Safety Services is a certified FDNY / NJ And Nassau to service and sell portable fire extinguishers. As a NFPA 10 and FDNY-certified company, we provide a full range of fire extinguishers, fire protection products and services to small businesses, commercial businesses, property management companies and construction projects. We sell, service, inspect, tag and recharge all type of fire extinguishers. | MBE | 12/21/2026 | ASIAN | 159 21st Street | Brooklyn |
| 308309 | 1 We Build Environments Corp | WBE NYC | Alla | Antsis | 2032152688 | 1 We Build Environments is a company which does budget development, scheduling, conceptual estimating, logistics evaluation, value engineering analysis, pre-construction services, bid preparation, project program analysis, scope review & analysis, construction oversight & management, oversight of design development, construction documentation, cost analysis, general construction and construction closeouts. | WBE | — | NON-MINORITY | 11 Fort George Hill | New York |
| 10015 | 1-800 Mr. Rubbish Inc. | — | Abeir | Saleh | 7187683700 | 1-800 Mr. Rubbish is a garbage removal and demolition company. The firm removes and hauls trash, junk, construction debris. 1-800 Mr. Rubbish provides trucking services and provides mini container service. | MBE,WBE | 03/31/2027;03/31/2027 | ASIAN | 1033 86th Street | Brooklyn |
| 10007 | 10 November LLC | — | Alfred | Reyes | 9175834703 | 10 November LLC is a subcontractor that does commercial and residential renovation and new construction. The company specializes in concrete, masonry, carpentry, steel and demolition. | MBE | 12/31/2028 | HISPANIC | 34 Evans Street | New Rochelle |
| 365947 | 10-63Meal LLC | — | Camilla | StLouis | 9172543768 | 10-63 Meal is a Mission Driven Catering Small Business that is operated by Law Enforcement Officers. Our Mission focuses on Uniting and Building a Trusting and Respectful Relationship between Community Members and their Local Law-Enforcement Agencies. We are doing this by creating Safe Spaces for community members and law enforcement officers to enjoy a healthy meal and healthy conversation together. We also provide the following services: *Youth Culinary Arts After School Program *Emergency Fresh and Hot Food Service *Vending Machine Services * Street and Community Fairs *Birthdays and Retirement Parties *NYPD Community Affairs | MBE,WBE | 04/30/2029;04/30/2029 | BLACK | 188-42 Mnagin Ave | St.Albans |
| 309818 | 100 Cleaners Inc. | — | Valeriya | Artimovich | 9292948890 | 100 Cleaners Inc. is a comprehensive commercial cleaning company, providing a wide range of services such as building maintenance, hotel cleaning, office cleaning, healthcare facility cleaning, school cleaning, COVID-19 disinfection, carpet cleaning, floor buffing and burnishing. | WBE | — | NON-MINORITY | 3049 Brighton 6th Street | Brooklyn |
Showing 12 of 50 columns. All of them are listed below.
Marialast_name | text | Last Name of the Company's Contact Person | 0% | SinghWilliamsPatel |
telephone | text | Telephone Number | 0% | 732422150091466506542124332829 |
business_description | text | A brief description of the type of service provided | 0% | Electrical ContractorGeneral ConstructionConstruction |
certification | categorical | Type of Certification the company qualified for | 0% | MBEMBE,WBEWBEof 9 |
cert_renewal_date | text | Date on which certification was renewed | 25% | 10/31/20306/30/20281/31/2028 |
ethnicity | categorical | Ethnicity of the Company owner(s) | 0% | BLACKNON-MINORITYASIANof 6 |
address1 | text | Company Address | 1% | 26 Broadway147 Prince Street68 Jay Street |
address2 | text | Company Address | 61% | 2nd Floor3rd Floor1st Floor |
city | text | City in which Company is located | 0% | New YorkBrooklynBronx |
state | text | State in which Company is located | 0% | NYNJCT |
zip | text | ZIP code | 0% | 100011001811201 |
mailingaddress1 | text | Company mailing address | 0% | 99 Wall Street26 Broadway147 Prince Street |
mailingaddress2 | text | Company mailing address | 60% | 2nd Floor3rd Floor1st Floor |
mailingcity | text | City | 0% | New YorkBrooklynBronx |
mailingstate | text | State | 0% | New YorkNew JerseyConnecticut |
mailingzip | text | ZIP code | 0% | 100011001811201 |
website | url | Company Website | 30% | http://N/Ahttp://www.wolfgangandhi… |
date_of_establishment | datetime | Date the Company was Established | 6% | 2017-01-01T00:00:00.0002018-01-01T00:00:00.0002015-01-01T00:00:00.000 |
aggregate_bonding_limit | integer | Bonding Limit | 91% | 1000000100002000000 |
signatory_to_union_contracts | text | Signatory to Union contracts | 94% | IBEW 3Electric IBEW 3Teamsters 282 |
id6_digit_naics_code | integer | North American Industry Classification System (NAICS) Code that identifies the type of business | 0% | 541990611710238990 |
naics_sector | text | NAICS sector (Industry) | 0% | Professional, Scientific…ConstructionEducational Services |
naics_subsector | text | NAICS Subsector | 0% | Management, Scientific, …Architectural, Engineeri…Other Professional, Scie… |
naics_title | text | Type of Business | 0% | All Other Professional, …Educational Support Serv…All Other Specialty Trad… |
types_of_construction_projects_performed | text | Type of jobs performed in the construction industry | 100% | — |
nigp_codes | text | National Institute of Governmental Purchasing (NIGP) Codes | 0% | 918009120092400 |
name_of_client_job_exp_1 | text | The Business the vendor is working for | 7% | NYCHANYC Department of Educat…New York City Housing Au… |
largest_value_of_contract | integer | Value (in dollars) of the the contract | 7% | 2500020000100000 |
percent_self_performed_job_exp_1 | integer | Percent of the job performed by the vendor | 9% | 100500 |
date_of_work_job_exp_1 | datetime | Date the work was done | 7% | 2024-01-01T00:00:00.0002023-01-01T00:00:00.0002018-01-01T00:00:00.000 |
description_of_work_job_exp_1 | text | Description of the work done | 7% | #NAME?Provided consulting serv…Provided security guard … |
name_of_client_job_exp_2 | text | Name of second business the vendor is working for | 24% | NYCHANYC Department of Educat…NYC SCA |
value_of_contract_job_exp_2 | integer | Value (in dollars) of the the contract | 25% | 10000500020000 |
percent_self_performed_job_exp_2 | integer | Percent of the job performed by the vendor | 26% | 100500 |
date_of_work_job_exp_2 | datetime | Date the work was done | 24% | 2024-01-01T00:00:00.0002018-01-01T00:00:00.0002022-01-01T00:00:00.000 |
description_of_work_job_exp_2 | text | Description of the work done | 24% | #NAME?ConsultingPainting |
name_of_client_job_exp_3 | text | Name of third business the vendor is working for | 37% | NYCHANYC Department of Educat…NYC SCA |
value_of_contract_job_exp_3 | integer | Value (in dollars) of the the contract | 37% | 10000500020000 |
percent_self_performed_job_exp_3 | integer | Percent of the job performed by the vendor | 38% | 1005090 |
date_of_work_job_exp_3 | datetime | Date the work was done | 37% | 2022-01-01T00:00:00.0002018-01-01T00:00:00.0002024-01-01T00:00:00.000 |
description_of_work_job_exp_3 | text | Description of the work done | 37% | #NAME?Provided security guard …Consulting |
capacity_building_programs | text | — | 100% | — |
enrolled_in_passport | categorical | Enrollment in the NYC's Procurement and Sourcing Solutions Portal (PASSPort) | 0% | YesNoof 2 |
borough | categorical | Borough in which the building is located | 39% | MANHATTANBROOKLYNQUEENSof 5 |
latitude | float | Latitude of the building's location | 39% | 40.75202140.66216240.744521 |
longitude | float | Longitude of the building's location | 39% | -73.929345-73.961739-73.987427 |
community_board | integer | The Community Board field indicates the New York City Community District where the building is located | 39% | 105101413 |
council_district | integer | The Council District field indicates the New York City Council District where the building is located | 39% | 341 |
bin | integer | The BIN (Building Identification Number) is a unique identifier for each building in the City | 40% | 300000040000004003108 |
bbl | integer | The BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City | 40% | 302023000140021402493000400001 |
census_tract_2020_ | integer | The Census Tract (Census 2020) field indicates the U.S. Census Tract where the building is located. Please note that as part of the geocoding process, leading and trailing zeros are dropped | 39% | 219109 |
neighborhood_tabulation_area_nta_2020_ | text | The Neighborhood Tabulation Area (Census 2020) field indicates the New York City Neighborhood area where the building is located | 39% | MN0502MN0501MN0101 |