From a 134-row sample across 42 columns.
boroughpostcodelatitude+7latitudebinlongitude+5boroughpostcodelatitude+2binMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| entity_name | entity_role | street_address | state | city | postcode | country | owner_officer_1_first_name | owner_officer_1_last_name | individual_role_1 | individual_title_1 | officer_equivalent_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| JOSEPH L. BALKAN, INC. | Sub-Contractor | JAMAICA Avenue | NEW YORK | Richmond Hill | 11418 | USA | David | Balkan | Officer | CEO | Chief Executive Officer |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
entity_name | text | The name of the contractor or subcontractor. | 3% | CIRCLE ROSE CONTRACTINGA&E SURFACES CO INCECO REMODELING |
entity_role | categorical | "General Contractor" or "Subcontractor" | 3% | Sub-ContractorContractorof 2 |
street_address | text | The building/house number and street name, along with the suite/unit number (if applicable), on which the entity is located. | 17% | White Plains RoadPowerhouse RoadWalt Whitman Road |
suite_apartment_number | categorical | — | 89% |
GET /api/datasets/9s68-zggy GET /api/datasets/9s68-zggy/quality GET /api/datasets/9s68-zggy/related GET /api/columns?dataset=9s68-zggy
latitudebinlongitude+2latitudebinlongitude+5latitudelongitudebbllatitudebinlongitude+5| Mountco Construction |
| Contractor |
| White Plains Road |
| NEW YORK |
| Scarsdale |
| 10583 |
| USA |
| Joel |
| Mounty |
| Owner |
| President |
| NA |
| ERIN CONSTRUCTION AND DEVELOPMENT CO INC | Contractor | Lakeville Road | NEW YORK | New Hyde Park | 11040 | USA | John | Murnane | Owner | President | NA |
| TEMPA GENERAL CONTRACT CORP. | Sub-Contractor | 21st Avenue | NEW YORK | Whitestone | 11357 | USA | Franco | Colarusso | Owner | President | NA |
| MARINE BULKHEADING INC. | Sub-Contractor | Bay Ct. | NEW YORK | Seaford | 11783 | USA | Thomas | Desousa | Officer | Vice President | NA |
| GREY-RUSO CONSTRUCTION CORP. | Sub-Contractor | 12th Road | NEW YORK | Whitestone | 11357 | USA | Gregory | Caruso | Owner | Owner | NA |
| METALPRO CUSTOM CONSTRUCTION AND RAILING LLC | Sub-Contractor | Ryerson Avenue | NEW JERSEY | Wayne | 7470 | USA | Osmin | Garrido | Owner | N/A | NA |
| JAMCOB ELECTRIC LLC | Sub-Contractor | Tiffany Street | NEW YORK | Bronx | 10459 | USA | Angel | Beato | Owner | N/A | NA |
| L & D DRYWALL SERVICES CORP. | Sub-Contractor | 66th Street | NEW YORK | Woodside | 11377 | USA | Lylian | Denis | Owner | President | NA |
| MASPETH CONTRACTING CORP. | Sub-Contractor | 44th Street | NEW YORK | Maspeth | 11378 | USA | John | Schrone | Officer | President | NA |
Showing 12 of 42 columns. All of them are listed below.
2nd FloorSte 51st Floorof 12state | categorical | The state in which the entity is located. | 3% | NEW YORKNEW JERSEYCONNECTICUTof 6 |
city | text | — | 3% | BronxBrooklynNew York |
postcode | integer | The ZIP/postal code in which the entity is located. | 3% | 112221173511378 |
country | text | The country in which the entity is located. | 3% | USAof 1 |
owner_officer_1_first_name | text | The first name of an entity’s individual owner/officer. There may be multiple owners/officers listed for an entity. | 3% | JohnAnthonyThomas |
owner_officer_1_last_name | text | The last name of an entity’s individual owner/officer. There may be multiple owners/officers listed for an entity. | 3% | AminianlopezOstreander |
individual_role_1 | categorical | The role of the referenced individual within a sub-contractor (“Owner”, “Officer”, or “Both”). | 3% | OwnerOfficerBothof 3 |
individual_title_1 | text | The title given by the company to the referenced individual within the entity. | 3% | PresidentpresidentOwner |
officer_equivalent_1 | categorical | The title equivalency of the title for an officer within an entity (“CEO”, “CFO”, “COO”, “NA”). | 3% | NAChief Executive OfficerChief Operating Officerof 3 |
owner_officer_2_first_name | text | — | 52% | lisaMojsiOrik |
owner_officer_2_last_name | text | — | 52% | MarkeEliassianostrander |
individual_role_2 | categorical | — | 52% | OwnerOfficerBothof 3 |
individual_title_2 | text | — | 52% | PresidentOwnerpresident |
officer_equivalent_2 | categorical | — | 52% | NAChief Executive OfficerChief Operating Officerof 3 |
owner_officer_3_first_name | text | — | 77% | LisaLuisJacon |
owner_officer_3_last_name | text | — | 77% | OstranderAmianPereira |
individual_role_3 | categorical | — | 77% | OwnerOfficerBothof 3 |
individual_title_3 | categorical | — | 77% | PresidentOwnerPRESIDENTof 11 |
officer_equivalent_3 | categorical | — | 77% | NAChief Operating OfficerChief Executive Officerof 3 |
owner_officer_4_first_name | categorical | — | 84% | MichaelLisaJacobof 18 |
owner_officer_4_last_name | text | — | 84% | AminianOstanderPereira |
individual_role_4 | categorical | — | 84% | OwnerOfficerBothof 3 |
individual_title_4 | categorical | — | 84% | Presidentpresownerof 9 |
officer_equivalent_4 | categorical | — | 84% | NAChief Executive Officerof 2 |
owner_officer_5_first_name | categorical | — | 87% | NicholasKennyEdwinof 15 |
owner_officer_5_last_name | categorical | — | 87% | MartoneNgaiDresselof 15 |
individual_role_5 | categorical | — | 87% | OwnerOfficerBothof 3 |
individual_title_5 | categorical | — | 87% | PresidentPRESIDENTOfficerof 11 |
officer_equivalent_5 | categorical | — | 87% | NAChief Executive Officerof 2 |
borough | categorical | — | 61% | BronxQueensBrooklynof 3 |
latitude | coordinate | The latitude associated with the provided entity location. | 49% | 40.67357340.65256940.813224 |
longitude | coordinate | The longitude associated with the provided entity location. | 49% | -73.900256-73.746041-74.001337 |
bin | text | The Building Identification Number (BIN) associated with the provided entity location. It is formatted as a seven-digit numerical identifier, which is unique to each building in NYC. | 51% | 300857142918712094273 |
bbl | text | The Borough, Block, Lot (BBL) associated with the provided entity location. It is formatted as a ten-digit numerical identifier, which is unique to each parcel of real property in NYC. | 51% | 202603017341374700763005620046 |
community_board | text | The NYC community board associated with the provided entity location (numbered 1 – 59, preceded by the borough code). | 49% | 401405212 |
council_district | text | The NYC council district associated with the provided entity location (numbered 1 – 51). | 49% | 26223 |
census_tract | text | The US census tract associated with the provided entity location (in the format of up to four-digit integers, followed by an optional two-digit suffix; e.g., “15.02” or “319”). | 49% | 5595302694 |
nta | text | The Neighborhood Tabulation Area (NTA) associated with the provided entity location, which is formatted as a two-letter borough identifier followed by a two-digit numerical identifier (e.g., “BX31”). | 49% | BX0202QN0104QN0101 |