From a 500-row sample across 28 columns.
projectidlatitudestreetnameprojectid+7projectidprojectidtypeprojectidMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| developmentteamdwid | projectid | type | firstname | lastname | entityindividualindicator | parententityname | individualrole | individualtitle | individualofficerequivalence | housenumber | streetname |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2335 | 61290 | BORROWER LEGAL ENTITY | Nikant | Ohri | Individual | ICL Nevins Street Housing Development Fund Corporation | Officer | Chief Financial Officer | CFO | 125 | Broad Street |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
developmentteamdwid | text | Unique identifier of Development team in data warehouse | 0% | 76241008710063 |
projectid | text | The unique ID that refers back to the Project ID column in the Project table (Foreign Key to the Project table) | 0% | 497226229958480 |
type | categorical | Notes whether an Entity or an Individual is the Borrower Legal Entity, General Contractor and/or Subcontractor | 0% | SUB CONTRACTORBORROWER LEGAL ENTITYGENERAL CONTRACTORof 3 |
entityname | text | The name of an entity associated with a project | 32% |
GET /api/datasets/6anw-twe4 GET /api/datasets/6anw-twe4/quality GET /api/datasets/6anw-twe4/related GET /api/columns?dataset=6anw-twe4
projectidprojectidprojectid| 2340 | 61290 | BORROWER LEGAL ENTITY | — | — | Entity | ICL NEVINS STREET APARTMENTS L.P. | — | — | — | 125 | Broad Street |
| 2337 | 61290 | BORROWER LEGAL ENTITY | David | Woodlock | Individual | ICL Nevins Street Housing Development Fund Corporation | Officer | CEO | CEO | 125 | Broad Street |
| 2338 | 61290 | BORROWER LEGAL ENTITY | — | — | Entity | ICL NEVINS STREET APARTMENTS L.P. | — | — | — | 125 | Broad Street |
| 2341 | 61290 | BORROWER LEGAL ENTITY | — | — | Entity | ICL NEVINS STREET APARTMENTS L.P. | — | — | — | 125 | Broad Street |
| 2336 | 61290 | BORROWER LEGAL ENTITY | Chris | Copeland | Individual | ICL Nevins Street Housing Development Fund Corporation | Officer | Chief Operating Oficer | COO | 125 | Broad Street |
| 25024 | 50282 | SUB CONTRACTOR | — | — | Entity | Otis Elevator Company | — | — | — | 125 | Broad street |
| 84268 | 60810 | SUB CONTRACTOR | — | — | Entity | Otis Elevator | — | — | — | 125 | Broad Street |
| 84269 | 60810 | SUB CONTRACTOR | Jonathan | Shankman | Individual | Otis Elevator | Officer | — | — | 125 | Broad Street |
| 79895 | 50282 | SUB CONTRACTOR | — | — | Entity | Otis Elevator Company | — | — | — | 125 | Broad street |
Showing 12 of 27 columns. All of them are listed below.
OTIS ELEVATOR COMPANYMETRO ERECTORS, INC.COSAN CONSTRUCTION CORPfirstname | text | First name of a "Principal Officer" or "Principal Owner" for an Individual associated with a Borrower Legal Entity, General Contractor, or Subcontractor on the project | 67% | MichaelJohnRobert |
lastname | text | Last name of a "Principal Officer" or "Principal Owner" for an Individual associated with a Borrower Legal Entity, General Contractor, or Subcontractor on the project | 67% | HanjisMartinLembo |
entityindividualindicator | categorical | Notes whether the Development Team owner or officer is an Entity or an Individual | 0% | EntityIndividualOfficerof 3 |
parententityname | text | Name of parent entity associated with the Development Team Entity or Individual | 0% | Monadnock Construction I…L&M Development Partners…Oldcastle Precast |
individualrole | categorical | Notes whether a Development Team Individual is a "Principal Officer" or "Principal Owner" or both. | 68% | OfficerBothOwnerof 18 |
individualtitle | text | Development Team Individual's actual title | 70% | PresidentMemberVice President |
individualofficerequivalence | categorical | The Officer equivalence for a Development Team Individual who serves as or performs the functions of Chief Executive Officer (CEO), Chief Finance Officer (CFO), or Chief Operating Officer (COO) | 90% | CEOCOOCFOof 18 |
careof | text | "Care of" (C/O) for Development Team Entity or Individual's address | 87% | Signature Urban Properti…Monadnock Development LL…Phipps Houses |
housenumber | text | Primary House Number is the building or house number for Development Team Entity or Individual's address | 33% | 1551865242 |
streetname | text | Street name for Development Team Entity or Individual's address | 32% | BroadwayPalmer Avenue3rd Street |
apartmentsuitefloor | text | Apartment, suite or floor number for Development Team Entity or Individual's address | 81% | 2nd Floor3rd Floor19th Floor |
city | text | City for Development Team Entity or Individual's address | 32% | New YorkBrooklynBronx |
state | text | State (abbreviation) for Development Team Entity or Individual's address | 33% | NEW YORKNEW JERSEYCONNECTICUT |
zip | text | ZIP Code for Development Team Entity or Individual's address | 32% | 100181123110001 |
tradetype | text | Subcontractor's trade as a category | 75% | Specialties (Mailboxes, …ElectricalSteel / Metals |
borough | categorical | The name associated with the borough in which the entity is located | 33% | Out of NYCManhattanQueensof 7 |
latitude | float | The latitude associated with the provided entity location. | 56% | 40.67646540.75281140.888213 |
longitude | float | The longitude associated with the provided entity location. | 56% | -73.990861-73.990973-73.898900 |
community_board | text | The NYC community board associated with the provided entity location | 56% | 050102 |
council_district | text | The NYC council district associated with the provided entity location | 56% | 030402 |
census_tract | text | The US census tract associated with the provided entity location | 56% | 10977145 |
bin | text | The Building Identification Number (BIN) associated with the provided entity location. | 57% | 325516710144342084013 |
bbl | text | The Borough, Block, Lot (BBL) associated with the provided entity location. | 57% | 300462001410078500672057760539 |
nta | text | The Neighborhood Tabulation Area (NTA) associated with the provided entity location | 56% | MN17MN13BK33 |