From a 500-row sample across 16 columns.
boroughdescriptionboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| date_reported_as_of | pid | project_name | description | category | managing_agency | client_agency | current_phase | design_start | budget_forecast | latest_budget_changes | total_budget_changes |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2023-01-01T00:00:00.000 | 945 | North River WWTP Primary Treatment Improvements | Rehabilitation of the Primary Settling Tanks at North River Wastewater Resources Recovery Facility. | Wastewater Treatment | DEP | DEP | Design | 2021-05-17T00:00:00.000 | 201191899.00 | 1272624.00 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
date_reported_as_of | datetime | — | 0% | 2023-01-01T00:00:00.0002022-09-01T00:00:00.0002022-04-01T00:00:00.000 |
pid | integer | — | 0% | 193170112 |
project_name | text | — | 0% | Gilboa Dam Reconstructio…Wyckoff Avenue Street Re…Bergen Avenue Street Rec… |
description | text | — | 14% | NEW SCHOOLADDITIONCITYWIDE FUEL TANK REPLA… |
GET /api/datasets/n7gv-k5yt GET /api/datasets/n7gv-k5yt/quality GET /api/datasets/n7gv-k5yt/related GET /api/columns?dataset=n7gv-k5yt
borough| 35891899.00 |
| 2023-01-01T00:00:00.000 | 667 | The Reconstruction of The Lower Catskill Aqueduct | Reconstruction of Aqueduct structures; Replacement of mechanical equipment; cleaning the aqueduct interior & rehabilitation & repair of cracks & leaks. All relevent assessments, investigations, piloting, plans and reports. | Water Supply | DEP | DEP | Design | 2019-04-15T00:00:00.000 | 249500116.00 | 0.00 | -65760729.00 |
| 2023-01-01T00:00:00.000 | 1236 | 4th Ave Safety Improvements - Phase B | Redesign of 4th Ave from Atlantic Ave to 64th Street. | Streets and Roadways | DDC | Transportation | Design | 2022-03-28T00:00:00.000 | 221567000.00 | 0.00 | -21000.00 |
| 2023-01-01T00:00:00.000 | 180 | Pelham Parkway Roadway Reconstruction, Phase 2 | Pelham Pkwy main road W/B from Bronx River Pkwy to Hutchinson River Pkwy Pelham Pkwy North Service Rd. (S/R) from Bronx Park East to Eastchester Rd. Stillwell Ave from westbound mainline to north service road | Streets and Roadways | DDC | Transportation | Construction | 2002-02-15T00:00:00.000 | 158533000.00 | 0.00 | 125164000.00 |
| 2023-01-01T00:00:00.000 | 539 | Boston Road Bridge Over Hutchinson River Rehabilitation | Rehabilitation of Boston Road Bridge over Hutchinson River, located in the Bornx. | Bridges, Streets and Roadways | DOT | DOT | Construction Procurement | 2018-04-16T00:00:00.000 | 88359814.00 | 10880806.00 | 49309814.00 |
| 2023-01-01T00:00:00.000 | 991 | WM REPLMT EAST NEW YORK AVE | Trunk Water Main replacement in East New York Avenue between Howard Avenue and Pacific Street; Jamaica Avenue between Herkimer Street and Vermont Street; and Atlantic Avenue between Van Sinderen Avenue and Pennsylvania Avenue. | Water Supply | DDC | Environmental Protection | Construction | 2015-02-16T00:00:00.000 | 102950000.00 | 0.00 | 29337000.00 |
| 2023-01-01T00:00:00.000 | 1180 | Reconstruction of Regulator HP06 | Project REG-HP06 is for the reconstruction of Regulator HP06 . The work shall include, but is not limited to, the following items: 1. Reconstruction of the existing Diversion Chamber (see attachment labeled 'REG-HP06 As-builts'). 2. Reconstruction of the existing Regulator Chamber (see attachment labeled 'REG-HP06 As-builts'). 3. Rehabilitation of the existing Interceptor (scope previously included in PS-312MX) 4. Replacement of existing instrumentation and monitoring systems, as needed (i.e., sensors, probes, conduits, cables, etc.). 5. Restoration of construction areas as needed (i.e., roadways, sidewalks, etc.) 6. Implementation of an approved plan to maintain regulator and interceptor operations during construction. 7. Shop drawings, as-built drawings, and equipment information. | Streets and Roadways | DDC | Environmental Protection | Construction | 2020-10-27T00:00:00.000 | 63632000.00 | 0.00 | 8706000.00 |
| 2023-01-01T00:00:00.000 | 1235 | 444 Thomas Boyland Community Center | — | Other Government Facilities | DDC | Human Services | Design | 2023-02-15T00:00:00.000 | 127387000.00 | 0.00 | 382000.00 |
| 2023-01-01T00:00:00.000 | 1301 | Haffen Park Courts, Synthetic Turf Field, Playground, Adult Fitness, and Landscape Reconstruction | This project will reconstruct the playground, landscape, tennis courts, basketball courts, synthetic turf ballfield, pavements, water and drainage systems, park lighting, plantings, and construct an adult fitness area at Haffen Park. | Parks | DPR | DPR | Design | 2022-03-22T00:00:00.000 | 35399000.00 | 0.00 | 0.00 |
| 2023-01-01T00:00:00.000 | 703 | Pelham Bay Equestrian Park over Amtrak | Replace/Rehab the Pelham Bay Equestrian Park bridge over Amtrak, the Bronx | Bridges | DOT | DPR | Design | 2019-01-30T00:00:00.000 | 41466997.00 | 41466997.00 | 137997.00 |
Showing 12 of 16 columns. All of them are listed below.
category | text | — | 0% | Streets and RoadwaysBridgesWastewater Treatment |
borough | categorical | — | 56% | BronxBrooklynQueensof 15 |
managing_agency | categorical | — | 0% | DDCDOTDEPof 11 |
client_agency | text | — | 0% | DOTDEPTransportation |
current_phase | categorical | — | 12% | DesignConstructionConstruction Procurementof 5 |
design_start | datetime | — | 16% | 2017-08-01T00:00:00.0002014-01-01T00:00:00.0002017-05-30T00:00:00.000 |
budget_forecast | integer | — | 12% | 764063231.000.0084520367.00 |
latest_budget_changes | integer | — | 19% | 0.00-500000.00100000.00 |
total_budget_changes | float | — | 1% | 0.0043926000.00-7266000.00 |
forecast_completion | datetime | — | 17% | 2024-09-03T00:00:00.0002023-09-03T00:00:00.0002022-12-31T00:00:00.000 |
latest_schedule_changes | integer | — | 25% | 03651 |
total_schedule_changes | integer | — | 3% | 06631684 |