From a 500-row sample across 11 columns.
project_idboroughtitleHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| meeting_date | project_id | title | borough | lead_agency | public_private | project_type | construction_type | result | secondary_agency |
|---|---|---|---|---|---|---|---|---|---|
| 2025-12-15T00:00:00.000 | 11788 | Replacement of the roof and construction of rooftop bulkheads, Heckscher Building, 1230 Fifth Avenue, Manhattan | Manhattan | DDC | Public | Building systems & Modifications | Installation of specific elements | Commented | — |
| 2025-12-15T00:00:00.000 | 20880 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
meeting_date | datetime | The Commission meeting date that corresponds with the month during which a project was submitted. | 0% | 2017-05-22T00:00:00.0002020-03-30T00:00:00.0002017-06-19T00:00:00.000 |
project_id | text | Unique identifier for an individual project. | 0% | NULL1703517460 |
title | text | Name assigned to an individual project including the construction type, scope and location. | 0% | Reconstruction of the Br…Construction of a mixed-…Reconstruction of the Up… |
borough | categorical |
GET /api/datasets/5fsv-ze7v GET /api/datasets/5fsv-ze7v/quality GET /api/datasets/5fsv-ze7v/related GET /api/columns?dataset=5fsv-ze7v
boroughborough| Rehabilitation of the East New York Industrial Building, 191-201 Powell Street, Brooklyn |
| Brooklyn |
| EDC |
| Public |
| Architecture |
| Rehabilitation |
| Commented |
| — |
| 2025-12-15T00:00:00.000 | 20959 | Construction of streetscape improvements, including reconstruction of an entrance at Our Lady of Lourdes Church and Corporal Allan F. Kivlehan Park, between Milton Avenue, New Dorp Lane, Cedar Grove Avenue, Ebbits Street, and Hetts Avenue, Staten Island | Staten Island | DDC | Public | Landscape architecture | Construction | Commented | DOT/DPR |
| 2025-12-15T00:00:00.000 | 21265 | Installation of rooftop mechanical equipment, Main Building, Oakwood Beach Wastewater Resource Recovery Facility, 751 Mill Road, Staten Island | Staten Island | DEP | Public | Building systems & Modifications | Installation of specific elements | Commented | — |
| 2025-12-15T00:00:00.000 | 21431 | Replacement of the roof and installation of rooftop mechanical equipment, Ryder Library, 5902 23rd Avenue, Brooklyn | Brooklyn | DDC | Public | Building systems & Modifications | Installation of specific elements | Commented | — |
| 2025-12-15T00:00:00.000 | 21876 | Installation of rooftop mechanical equipment and an exhaust fan, Engine Company 22, 159 East 85th Street, Manhattan | Manhattan | FDNY | Public | Building systems & Modifications | Installation of specific elements | Commented | — |
| 2025-12-15T00:00:00.000 | 21976 | Reconstruction of the bulkheads and adjacent site work, Tallman Island Wastewater Resource Recovery Facility, 127th Street and Powell's Cove Boulevard, College Point, Queens | Queens | DEP | Public | Building systems & Modifications | Reconstruction | Commented | — |
| 2025-12-15T00:00:00.000 | 22101 | Construction of streetscape improvements, Bush Terminal Industrial Campus (Made in NY), between 41st Street, 1st Avenue, and 44th Street, and the waterfront, Brooklyn | Brooklyn | EDC | Public | Landscape architecture | Construction | Commented | — |
| 2025-12-15T00:00:00.000 | 22414 | Construction of a restaurant, parking lot, and adjacent site work, 2 Soundview Avenue, Clason Point Park, Bronx River Avenue, East River, Bronx | Bronx | DPR | Public | Architecture | Construction | Commented | — |
| 2025-12-15T00:00:00.000 | 22417 | Installation of an interim guard booth, doors, and fencing, Kings County Criminal Court, State Street between Boerum Place and Smith Street, Brooklyn | Brooklyn | DDC | Public | Building systems & Modifications | Installation of specific elements | Commented | — |
| — |
| 0% |
BrooklynManhattanQueensof 12 |
lead_agency | text | The City agency or agencies that have jurisdiction over the property on which the project is located. | 0% | DPRDDCEDC |
secondary_agency | text | The City agency or agencies that have jurisdiction over the property on which the project is located. | 69% | DOTDPRQPL |
public_private | categorical | Indicates if the project is open to the public or a private structure(s) that extends over City-owned land. | 0% | PublicPublic and PrivatePrivateof 4 |
project_type | categorical | The major category that the project falls under. | 0% | Landscape architectureArchitectureBuilding systems & Modif…of 15 |
construction_type | categorical | The scope of work proposed for a project. | 0% | Installation of specific…ReconstructionConstructionof 18 |
result | categorical | Design review is an iterative process and the Public Design Commission works to provide applicants with feedback and guidance so that their submissions can be approved in the shortest number of review cycles. Even if a submission is not formally acted upon by the Commission within a cycle, the Design Commission typically provides feedback that will help the agencies revise their proposal so that it may be approved the following month. Submissions that were commented upon but not acted upon may h | 0% | CommentedApprovedApproved with conditionsof 13 |
review_cycles | categorical | A review cycle is the time between the deadline for the filing of a submission to the Public Design Commission and the scheduled date of the next public meeting of the Commission. | 52% | 123of 5 |
previous_year_submission | text | Project submission that was submitted in December of the previous year for a Design Review meeting in January of the current year. | 92% | xof 1 |