From a 500-row sample across 7 columns.
projectidprojectidprojectidprojectidgeneralcontractornameprojectname+2projectid| projectid | projectname | programname | borrowerlegalentityname | generalcontractorname | entity_wage_reporting_status | project_wage_reporting_status |
|---|---|---|---|---|---|---|
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Jan-Mar 2021 | A&S STEEL CONTRACTORS, LTD. | Subcontractor | Provided | N/A |
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Apr-Jun 2021 | A&S STEEL CONTRACTORS, LTD. | Subcontractor | Provided | N/A |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
projectid | text | The unique ID that refers back to the Project ID column in the Project table (Foreign Key to the Project table) | 0% | 62,29966,90361,388 |
projectname | text | The name of the project in HPD's systems | 0% | DUNN. 82-41 PARSONS BLVD…INWOOD LIBRARYESSEX CROSSING - SITE 4 |
programname | text | The three-month reporting period associated with the required wage information | 0% | Jul-Sep 2020Apr-Jun 2021Oct-Dec 2020 |
borrowerlegalentityname | text | The name of the Borrower Legal Entity or contractor for which wage information reporting is required | 0% |
GET /api/datasets/34zf-iv73 GET /api/datasets/34zf-iv73/quality GET /api/datasets/34zf-iv73/related GET /api/columns?dataset=34zf-iv73
projectidprojectidprojectid| 44,218 |
| MEC E. 125TH ST. PARCEL B WEST |
| Jul-Sep 2020 |
| A&S STEEL CONTRACTORS, LTD. |
| Subcontractor |
| Provided |
| N/A |
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Jul-Sep 2021 | A&S STEEL CONTRACTORS, LTD. | Subcontractor | Provided | N/A |
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Oct-Dec 2020 | A&S STEEL CONTRACTORS, LTD. | Subcontractor | Provided | N/A |
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Apr-Jun 2021 | ABOVE ALL STORE FRONTS, INC | Subcontractor | Provided | N/A |
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Jul-Sep 2021 | ABOVE ALL STORE FRONTS, INC | Subcontractor | Provided | N/A |
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Oct-Dec 2021 | ABOVE ALL STORE FRONTS, INC | Subcontractor | Provided | N/A |
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Jan-Mar 2021 | ARSENAL SCAFFOLD INC. | Subcontractor | Not provided | N/A |
| 44,218 | MEC E. 125TH ST. PARCEL B WEST | Apr-Jun 2021 | ARSENAL SCAFFOLD INC. | Subcontractor | Provided | N/A |
MEGA CONTRACTING GROUP L…COSAN CONSTRUCTION CORPOTIS ELEVATOR COMPANY |
generalcontractorname | categorical | Notes whether an Entity or an Individual is the Borrower Legal Entity, General Contractor and/or Subcontractor | 0% | SubcontractorBorrower Legal EntityGeneral Contractorof 3 |
entity_wage_reporting_status | categorical | “Provided” if the entity has provided the requisite wage information; otherwise, “Not provided” | 0% | ProvidedNot ProvidedNot providedof 3 |
project_wage_reporting_status | categorical | “All information provided” if all entities associated with the project have provided all required wage information, otherwise “Not all information provided” (applies only to Borrower Legal Entities; contractors have “N/A”) | 0% | N/ANot All info providedAll info providedof 3 |