From a 346-row sample across 52 columns.
programtotal_populationboroughboroughHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| data_as_of | development | hud_amp_ | tds_ | consolidated_tds_ | development_edp_ | operating_edp_ | hud__ | program | method | type | number_of_section_8_transition_apartments |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1/1/2025 | 1010 EAST 178TH STREET | NY005011330 | 180 | 180 | 289 | 289 | NY005090 | FEDERAL | CONVENTIONAL | NEW CONST | 0 |
| 1/1/2025 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
data_as_of | text | — | 0% | 1/1/2025of 1 |
development | text | Development name. | 0% | LINDENWEBSTERPARK AVENUE-EAST 122ND, … |
hud_amp_ | text | Asset Management Project (AMP) numbers. | 1% | NY005012090NY005011670NY005015300 |
tds_ | text | The number used by numerous computer applications to identify NYCHA Developments. | 1% | 354065247 |
consolidated_tds_ |
GET /api/datasets/evjd-dqpz GET /api/datasets/evjd-dqpz/quality GET /api/datasets/evjd-dqpz/related GET /api/columns?dataset=evjd-dqpz
typeboroughborough| 104-14 TAPSCOTT STREET |
| NY005011670 |
| 242 |
| 167 |
| 361 |
| 283 |
| NY005174 |
| FEDERAL |
| TURNKEY |
| NEW CONST |
| — |
| 1/1/2025 | 1162-1176 WASHINGTON AVENUE | NY005013080 | 233 | 308 | 354 | 344 | NY005138 | FEDERAL | TURNKEY | REHAB | 0 |
| 1/1/2025 | 131 SAINT NICHOLAS AVENUE | NY005010970 | 154 | 097 | 264 | 261 | NY005065 | FEDERAL | CONVENTIONAL | NEW CONST | 0 |
| 1/1/2025 | 1471 WATSON AVENUE | NY005010670 | 214 | 067 | 332 | 222 | NY005162 | FEDERAL | TURNKEY | NEW CONST | 0 |
| 1/1/2025 | 154 WEST 84TH STREET | NY005013590 | 359 | 359 | 840 | 840 | NY005270 | FEDERAL | TURNKEY | NEW CONST | 0 |
| 1/1/2025 | 303 VERNON AVENUE | NY005010730 | 156 | 073 | 267 | 267 | NY005068 | FEDERAL | CONVENTIONAL | NEW CONST | 0 |
| 1/1/2025 | 335 EAST 111TH STREET | NY005010640 | 203 | 064 | 320 | 219 | NY005126 | FEDERAL | TURNKEY | NEW CONST | — |
| 1/1/2025 | 344 EAST 28TH STREET | NY005021850 | 185 | 153 | 452 | 452 | NY005374 | MIXED FINANCE/LLC2 | CONVENTIONAL | NEW CONST | 88 |
| 1/1/2025 | 45 ALLEN STREET | NY005011000 | 265 | 100 | 380 | 312 | NY005186 | FEDERAL | TURNKEY | NEW CONST | 0 |
Showing 12 of 50 columns. All of them are listed below.
| text |
| Consolidated Tenant Data Systems number. |
| 2% |
091359167 |
development_edp_ | text | Assigned to a development during the development (construction) period. | 2% | 569259570 |
operating_edp_ | text | A number that each development utilize for Operating Costs. | 2% | 324259748 |
hud__ | text | The U.S. Department of Housing and Urban Development (HUD) identification number. | 2% | NY005244BNY005056NY005216C |
program | categorical | The Programs designations are: Federal, MHOP, Mixed Finance, Mixed Finance/LLC1, Mixed Finance LLC2, Mixed Finance/Non-NYCHA Development. | 0% | FEDERALMIXED FINANCE/LLC1MIXED FINANCE/LLC2of 6 |
method | categorical | Two items in this field Conventional and Turnkey. | 1% | CONVENTIONALTURNKEYof 2 |
type | categorical | 5 items in this field: Gut Rehab, New Const, New Const (Eld), Rehab, and Rehab (Eld). | 0% | NEW CONSTREHABNEW CONST (ELD)of 5 |
number_of_section_8_transition_apartments | text | The total number of apartments transitioned to the Section 8 Program in the LLC1 developments. | 25% | 020988 |
number_of_current_apartments | text | The number of units available for occupancy in the development as per the January 1, 2024 Dwelling Unit Inventory which is used to track the number of units on the rent roll. | 1% | 150111421 |
total_number_of_apartments | text | The total number of apartments at the development including the Section 8 Transition apartments at the LLC1 developments. | 1% | 150125200 |
number_of_rental_rooms | text | Rental room count per unit is equal to 2 1/2 plus the number of bedrooms. The number of rental rooms includes balconies and half-bath as half-rooms. | 2% | 525.0220.51,504.5 |
avg_no_r_r_per_apartment | coordinate | The average number of rental rooms per apartment is the number of rental rooms divided by the number of current units. The Section 8 units in the LLC1 Developments are included. | 2% | 4.504.673.50 |
population_section_8_transition | text | The number of persons living in the Section 8 Transition units in the LLC1 developments. | 11% | 0441764 |
population_public_housing | text | The number of persons living in all public housing units. The residents living in the Section 8 Transition units in the LLC1 developments are not included in this population count. | 12% | 405137320 |
total_population | text | The total number of persons living at the developments, including the Section 8 Transition apartments in the LLC1 developments. | 2% | 405730255 |
total_of_fixed_income_household | integer | Number of households on fixed income (households with income from Social Security, Supplementary Security Income (SSI), Survivors Insurance, Veterans Benefits, or Pension (as well as other Public or Non Public Benefits), while not earning employment income or receiving Public Assistance. | 12% | 182015 |
percent_fixed_income_households | float | Number of households on fixed income divided by the total number of households. | 12% | 0.00360.00910.4114 |
number_of_residential_bldgs | text | The number of residential buildings on the grounds that are used for dwelling units. | 1% | 123 |
number_of_non_residential_bldgs | categorical | The number of non-residential buildings at a development. | 1% | 012of 6 |
number_of_stairhalls | text | The number of individual entrances in each development. | 1% | 125 |
number_of_stories | text | The number of floors in each building. | 1% | 6514 |
total_area_sq_ft | text | This number includes land acquired and developed as part of the development for a park or playground to be operated and manintained by the NYC Department of Parks. At State and City Developments, the park or playground is owned by the City of New York. At federal Developments, parks and playgrounds are leased to the City. | 2% | 1,224,449.9514,243.2752,397.6 |
acres | coordinate | The land area of the development including buildings and grounds is shown in acres (one acre equals 43,560 square feet). | 2% | 0.230.511.96 |
net_dev_area_sq_ft | text | This is Square Feet at a Development less the land set aside for a park or playground. For the majority of developments this figure is the same acreage. | 1% | 5,00010,00047,204 |
excluding_park_acres | coordinate | This is the number of acres at a development less the land set aside for a park or playground. For the majority of developments this figure is the same as "acres". | 1% | 0.581.030.63 |
bldg_coverage_sq_ft | text | The total ground floor area of the building footprints of a development. | 5% | 102,600160,09857,006 |
cubage_cu_ft | text | Cubic Space (height x length x width of residential buildings) in all the buildings at a development, expressed as cubic feet. | 5% | 3,200,584114,67511,440,850 |
bldg_coverage__ | text | This is the building coverage, divided by a development’s total area in square feet. This figure is presented as a percentage. | 5% | 13.77%66.74%17.67% |
density | text | Measure of development density as represented by the number of persons per acre. | 2% | 101193103 |
development_cost | text | The sum of the land cost, construction cost and site improvement cost, including fees for architects and engineers at the time of original construction. | 4% | $22,862,156$10,480,359$4,669,919 |
per_rental_room | text | Cost to develop the property divided by the number of rental rooms at the time of original construction. | 4% | $8,055$7,289$4,277 |
avg_monthly_gross_rent | text | This is the average gross monthly rent of the households in each development. The average tenant share of rent for the Section 8 households in the LLC1 developments is included. | 2% | $604$645$653 |
location_street_a | text | For NYCHA Developments that fit into a relatively neat rectangular block or two, these fields should be the four border streets (north, south, east, and west) of the Development. For Developments that are spread over some distance such as West Farms Road Rehab, the streets that best define the location of the development are provided. | 0% | PARK AVESUTTER AVEE 169TH ST |
location_street_b | text | — | 1% | AMSTERDAM AVEPARK AVEAVENUE D |
location_street_c | text | — | 7% | AMSTERDAM AVESUTTER AVETHIRD AVE |
location_street_d | text | — | 22% | PARK AVEAMSTERDAM AVEE 166TH ST |
borough | categorical | Bronx, Brooklyn, Manhattan, Queens, or Staten Island. | 0% | MANHATTANBROOKLYNBRONXof 7 |
community_distirct | text | Community District Number. | 3% | 3111 |
us_congressional_district | categorical | Congressional District Number. | 0% | 131508of 17 |
ny_state_senate_district | text | New York State Senate District Number. | 0% | 252932 |
ny_state_assembly_district | text | New York State Assembly District Number. | 0% | 795568 |
ny_city_council_district | text | New York City Council District Number. | 0% | 084117 |
completion_date | datetime | The Initial Occupancy Completion Date: The date when the development was at least 95% occupied. | 2% | 1973-07-31T00:00:00.0001994-08-31T00:00:00.0001973-05-31T00:00:00.000 |
federalized_development | categorical | Date on which City and / or State Developments were transferred to the Federal Program. There are 11 items in this field. They are: 1968/08/29-Fed Tran; 1971/06/29-Fed Tran; 1972/06/29-Fed Tran; 1977/07/01-ATP 1 (abbreviation for Authority Transfer Program); 1978/02/01-ATP 2; 1978/07/01-ATP 3; 1979/08/01-ATP 4; 1980/07/01-ATP 5; 1980/10/01-ATP 7; and 1995/07/13-PTA (abbreviation for Physical Transfer of Assets). | 81% | 1978/07/01-ATP 31977/07/01-ATP 11979/08/01-ATP 4of 11 |
senior_development | categorical | A senior development where all residents are senior, aged 62 or older, is denoted as "Exclusively". A development where only some buildings are designated for senior residents is denoted as "Partially". | 84% | EXCLUSIVELYPARTIALLY (1 BUILDING)PARTIALLYof 5 |
electricity_paid_by_residents | text | A "Yes" indicates developments where residents pay for their electricity. | 74% | YESof 1 |
private_management | text | A "Yes" indicates developments managed by a private management company. | 90% | YESof 1 |
rad_transferred_date | datetime | The date when the development underwent a Rental Assistance (RAD) / Permanent Affordability Commitment Together (PACT) conversion. | 71% | 2020-11-30T00:00:00.0002023-11-28T00:00:00.0002018-11-16T00:00:00.000of 19 |