From a 312-row sample across 25 columns.
presumed_building_unitsreported_commencement_datelongitude+14longitudepostcodelatitudelongitudecouncil_districtlatitudeMappable — coordinate pair `latitude` / `longitude`.
Open on the map →| no | form_submission_date | reported_property_address | reported_property_borough | reported_dob_bin | reported_dob_permit_sequence | reported_property_tax_block | reported_property_tax_lot | reported_units | reported_restricted_units | reported_commencement_date | reported_anticipated |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2024-07-08T11:51:38.000 | 26-18 4TH STREET | QUEENS | 4020673 | Q00713110 | 910 | 29 | 22 | 5 | 2024-02-09T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
no | integer | Random Number Assigned to each Form response. | 0% | 33204124 |
form_submission_date | datetime | Submission date of each Form response. | 0% | 2025-07-31T00:00:00.0002025-10-20T00:00:00.0002025-10-24T00:00:00.000 |
reported_property_address | text | Address of 485-x Building as reported from the Form user. | 0% | 1435 EAST GUNHILL ROAD26-18 4TH STREET91 DE SALES PL |
reported_property_borough | categorical | Borough of 485-x Building as reported from the Form user. | 0% |
GET /api/datasets/rrtd-iyd7 GET /api/datasets/rrtd-iyd7/quality GET /api/datasets/rrtd-iyd7/related GET /api/columns?dataset=rrtd-iyd7
longitudecouncil_districtlatitudelongitudecouncil_districtlatitudelongitudecouncil_districtlatitudelongitudepostcodecouncil_district+1| 2024-10-01T00:00:00.000 |
| 2 | 2024-07-08T12:42:52.000 | 26-18 4TH STREET | QUEENS | 4020673 | Q00713110 | 910 | 29 | 22 | 5 | 2023-05-23T00:00:00.000 | 2024-10-01T00:00:00.000 |
| 3 | 2024-07-17T12:53:21.000 | 3815 CARPENTER AVENUE | BRONX | 2057543 | X08028598 | 4653 | 22 | 18 | 4 | 2023-11-17T00:00:00.000 | 2025-02-01T00:00:00.000 |
| 4 | 2024-07-09T15:15:28.000 | 239 EAST 28 STREET | BROOKLYN | 3119204 | 322031145 | 5172 | 51 | 6 | 2 | 2022-07-27T00:00:00.000 | 2027-01-04T00:00:00.000 |
| 5 | 2024-11-13T14:08:56.000 | 91 DE SALES PL | BROOKLYN | 3080465 | B00672250-S1-FO-EA | 3469 | 30 | 12 | 3 | 2023-06-27T00:00:00.000 | 2024-11-04T00:00:00.000 |
| 6 | 2024-11-26T18:18:36.000 | 91 DE SALES PL | BROOKLYN | 3080465 | B00672250 | 3469 | 30 | 10 | 2 | 2023-09-22T00:00:00.000 | 2024-11-04T00:00:00.000 |
| 7 | 2024-12-13T02:25:50.000 | 91 DE SALES PLACE | BROOKLYN | 3080465 | B00672250 | 3469 | 30 | 10 | 2 | 2023-10-25T00:00:00.000 | 2024-11-04T00:00:00.000 |
| 8 | 2024-12-13T13:25:24.000 | 91 DE SALES PL BROOKLYN NY 11207 | BROOKLYN | 3080465 | B00672250 | 3469 | 30 | 10 | 2 | 2023-06-27T00:00:00.000 | 2024-11-04T00:00:00.000 |
| 9 | 2024-10-08T16:19:31.000 | 1550 WHITE PLAINS ROAD | BRONX | 2114062 | X00594578 | 3937 | 22 | 39 | 8 | 2022-06-16T00:00:00.000 | 2025-02-01T00:00:00.000 |
| 10 | 2024-08-08T15:42:10.000 | 150 LAWRENCE STREET | BROOKLYN | 3000398 | B00805143 | 151 | 37 | 99 | 20 | 2023-12-08T00:00:00.000 | 2027-01-01T00:00:00.000 |
Showing 12 of 25 columns. All of them are listed below.
BRONXBROOKLYNQUEENSof 4reported_dob_bin | integer | 485-x Building Reported DOB Building Identification Number (BIIN) as reported from the Form user. | 0% | 308046521236513429309 |
reported_dob_permit_sequence | text | 485-x Building Reported Commencement Permit as reported from the Form user. | 0% | B00672250X08007884Q00713110 |
reported_property_tax_block | integer | Tax Block of 485-x Building as reported from the Form user. | 0% | 20623883469 |
reported_property_tax_lot | integer | Tax Lot of 485-x Building as reported from the Form user. | 0% | 12218 |
reported_units | integer | 485-x Building Reported Units as reported from the Form user. Reported Units refers to the reported, anticipated number of dwelling units in the building. | 0% | 99108 |
reported_restricted_units | integer | 485-x Building Reported Restricted Units as reported from the Form user, which refers to the reported, anticipated number of affordable housing units and dwelling units that are subject to rent stabilization in accordance with Affordability Option C. | 0% | 235 |
reported_commencement_date | datetime | 485-x Building Reported Commencement Date as reported from the Form user. Reported Commencement Date refers to the date upon which excavation and construction of initial footings and foundations lawfully begins in good faith or, for an eligible conversion, the date upon which the actual construction of the conversion, alteration or improvement of the pre-existing building or structure lawfully begins in good faith. | 0% | 2025-05-06T00:00:00.0002025-12-19T00:00:00.0002026-01-05T00:00:00.000 |
reported_anticipated | datetime | 485-x Building Reported Completion Date as reported from the Form user. Reported Anticipated Completion Date refers to the anticipated date upon which the local department of buildings will issue the first temporary or permanent certificate of occupancy covering all residential areas of the reported building. | 0% | 2027-01-01T00:00:00.0002026-07-01T00:00:00.0002026-09-01T00:00:00.000 |
reported_affordability_option | categorical | 485-x Building Reported Affordability Option as reported from the Form user. Affordability options include OPTION A (Large Rental Projects and Very Large Rental Projects), OPTION B (Modest Rental Projects), OPTION C (Small Rental Projects), and OPTION D (Homeownership Projects). | 0% | OPTION BOPTION DOPTION Cof 4 |
presumed_community_board | integer | 485-x Building Community Board of Presumed address. | 0% | 212206207 |
presumed_duplicate | text | Duplicate Filing of 485-x Building based on repeated Form user response. | 93% | DUPLICATEof 1 |
duplicate_count | categorical | The number of times a building is recorded as a submission response based either on its reported DOB BIN or DOB Job. | 93% | 24of 2 |
presumed_building_units | integer | Count of Units in 485-x Building; where duplicates exist, latest form response number of reported units is utilized. Presumed Buildings Units refers to the number of dwelling units anticipated to be in the reported building. | 0% | 99108 |
presumed_restricted_units | integer | Count of Reported Units in 485-x Building; where duplicates exist, latest form response number of reported affordable housing units is utilized. Presumed Building Restricted Units refers to the anticipated number of affordable housing units and dwelling units that are subject to rent stabilization in accordance with Affordability Option C. | 0% | 234 |
presumed_bbl | integer | Presumed Tax Lots based on Form user response Property Tax Lot(s) merged with Borough and Property Tax Block | 0% | 303469003030230500112031490082 |
postcode | text | Zipcode where the site is located | 2% | 104671045710458 |
latitude | float | Latitude of the site's location | 2% | 40.68278540.85158740.863775 |
longitude | float | Longitude of the site's location | 2% | -73.904075-73.890656-73.90067 |
council_district | integer | The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. | 2% | 151412 |
ct2020 | integer | The Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Note: as part of the geocoding process, leading and trailing zeros are dropped. | 2% | 127373413 |
nta2020 | text | The Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitiv | 2% | BX1201BX0602BX0702 |