From a 500-row sample across 30 columns.
project_descrmanaging_agcy_cdboro+3pub_dateboropub_dateHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| pub_date | boro | managing_agcy_cd | managing_agcy | project_id | project_descr | typ_category_name | community_board | budget_line | delay_desc | scope_text | fy_yr1_plan |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20200116 | CITYWIDE | 042 | CITY UNIVERSITY | CA207-006 | CUNY Incubator Network | MISCELLANEOUS RECONSTRUCTION | 0 | HN-0206 | PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGN | PROVIDE SPACE IN EACH COMMUNITY COLLEGE TO OFFER RESOURCES FOR SMALL BUSINESS OWNERS. |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
pub_date | categorical | — | 0% | 20211222021080520200416of 14 |
boro | categorical | — | 0% | MANHATTANBROOKLYNQUEENSof 6 |
managing_agcy_cd | text | — | 0% | 846850841 |
managing_agcy | text | — | 0% | DEPT OF PARKS AND RECREA…DEPT OF DESIGN & CONSTRU…DEPARTMENT OF TRANSPORTA… |
GET /api/datasets/wa2y-rh4b GET /api/datasets/wa2y-rh4b/quality GET /api/datasets/wa2y-rh4b/related GET /api/columns?dataset=wa2y-rh4b
| 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79-ADA | ADA COMPLIANCE RENOVATIONS AT NYPD PRECINCTS | POLICE FACILITIES | 0 | PO-0079 | — | ADA COMPLIANCE RENOVATION AT NYPD PRECINTS | 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79BATH | CITYWIDE BATHROOM RENOVATION | POLICE FACILITIES | 0 | PO-0079 | PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGN | BATHROOM RENOVATION | 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79BMAHD | BATHROOM RENO AT 67TH, 77TH AND TRAFFIC CONTROL DIVISION | POLICE FACILITIES | 0 | PO-0079 | PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGN | BATHROOM RENOVATION | 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79BMAHG | ELEVATOR REHABILITATION FOR 20TH, 25TH | POLICE FACILITIES | 0 | PO-0079 | PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGN | ELEVATOR REHABILITATION | 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79BMAHI | BOILER REPLACEMENT AT 68TH, 76TH AND 102ND PCTS | POLICE FACILITIES | 0 | PO-0079 | PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGN | BOILER REPLACEMENTS | 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79BMAHY | BOILERS AT 26TH, 42ND & 46TH PRECINCTS | POLICE FACILITIES | 0 | PO-0079 | PROJECT DELAYED DUE TO CHANGES IN SCOPE/DESIGN | BOILER REPLACEMENT | 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79BMAJZ | 49TH & 115TH & MTN PCT HVAC REPLACEMENT | POLICE FACILITIES | 0 | PO-0079 | — | ESTIMATES | 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79BMAKF | CAC BATHROOM RENOVATION | POLICE FACILITIES | 0 | PO-0079 | — | ESTIMATE | 2020 |
| 20200116 | CITYWIDE | 056 | POLICE DEPARTMENT | PO79BMAKI | BOILERS AT MTS, HWY 3, 75 & 77 PRECINCTS | POLICE FACILITIES | 0 | PO-0079 | — | ESTIMATE | 2020 |
Showing 12 of 30 columns. All of them are listed below.
project_id |
| text |
| — |
| 0% |
HBBA24181SANDCONDTSAND2605 |
project_descr | text | — | 0% | JOB ORDER CONTRACTING WO…FUEL TANK REPLACEMENTSAFE ROUTES TO SCHOOLS-9… |
typ_category_name | text | — | 0% | NEIGHBORHOOD PARKS AND P…LOW TO MODERATE INCOME P…LARGE, MAJOR AND REGIONA… |
community_board | integer | — | 9% | 0300400 |
budget_line | text | — | 0% | P-1018HA-D001PU-0025 |
delay_desc | categorical | — | 40% | PROJECT DELAYED DUE TO B…PROJECT DELAYED DUE TO C…PROJECT DELAYED DUE TO U…of 12 |
site_descr | text | — | 66% | CITYWIDEBOROUGH OF BROOKLYNMANHATTAN |
scope_text | text | — | 2% | IA/SQSQ/IAESTIMATE |
fy_yr1_plan | categorical | — | 0% | 202120202023of 6 |
orig_bud_amt | integer | — | 0% | 50010000 |
city_prior_actual | integer | — | 0% | 050100 |
city_yr1_plan | integer | — | 0% | 0500100 |
city_yr2_plan | integer | — | 0% | 01000500 |
city_yr3_plan | integer | — | 0% | 020001000 |
city_yr4_plan | integer | — | 0% | 05002000 |
city_yr5_plan | integer | — | 0% | 05002000 |
city_rtc | integer | — | 0% | 05001000 |
city_plan_total | integer | — | 0% | 50010000 |
noncity_prior_actual | integer | — | 0% | 050015 |
noncity_yr1_plan | integer | — | 0% | 05001000 |
noncity_yr2_plan | integer | — | 0% | 05001 |
noncity_yr3_plan | integer | — | 0% | 0100009309 |
noncity_yr4_plan | integer | — | 0% | 010000750 |
noncity_yr5_plan | integer | — | 0% | 010000750 |
noncity_rtc | integer | — | 0% | 011770 |
noncity_plan_total | integer | — | 0% | 05001000 |