From a 500-row sample across 27 columns.
reported_property_tax_lotreported_commencement_datereported_property_tax_block+14longitudepostcodelatitudelongitudebblpostcode+1Mappable — coordinate pair `latitude` / `longitude`.
Open on the map →| no | form_submission_date | reported_property_addresses | reported_borough | reported_dob_bin_number | reported_dob_permit_sequence | reported_units | reported_affordale_units | reported_commencement_date | reported_anticipated | reported_property_tax_block | reported_property_tax_lot |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2024-06-14T00:00:00.000 | 155 Third Street, Brooklyn, NY 11231 | BROOKLYN | 3255167 | B00640761 | 300 | 75 | 2022-05-18T00:00:00.000 | 2031-06-15T00: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% | 143655 |
form_submission_date | datetime | Submission date of each Form response. | 0% | 2024-09-12T00:00:00.0002024-09-09T00:00:00.0002024-09-10T00:00:00.000 |
reported_property_addresses | text | Address of 421-a Building as reported from the Form user. | 0% | 33 4th Street1817 Topping Avenue180 East 125th Street |
reported_borough | categorical | Borough of 421-a Building as reported from the Form user. | 0% |
GET /api/datasets/pq4c-wbq4 GET /api/datasets/pq4c-wbq4/quality GET /api/datasets/pq4c-wbq4/related GET /api/columns?dataset=pq4c-wbq4
longitudebbllatitudelongitudebblpostcode+1longitudebbllatitude| 462 |
| 12;14 |
| 2 | 2024-06-14T00:00:00.000 | 267 Bond Street, Brooklyn, NY 11217 | BROOKLYN | 3429687 | B00612352 | 344 | 88 | 2022-05-23T00:00:00.000 | 2024-12-16T00:00:00.000 | 424 | 1 |
| 3 | 2024-06-14T00:00:00.000 | 498 Sackett Street Brooklyn, NY | BROOKLYN | 3429688 | B00616358 | 173 | 44 | 2022-05-25T00:00:00.000 | 2024-12-16T00:00:00.000 | 431 | 12 |
| 4 | 2024-06-17T00:00:00.000 | 247 East 117th Street | MANHATTAN | 1089658 | 123265484 | 51 | 15 | 2022-06-13T00:00:00.000 | 2026-09-18T00:00:00.000 | 1667 | 120 |
| 5 | 2024-06-17T00:00:00.000 | 240 4th Avenue, Brooklyn, NY, 11215 | BROOKLYN | 3395598 | B00716682 | 165 | 42 | 2022-06-09T00:00:00.000 | 2031-06-14T00:00:00.000 | 441 | 24;35 |
| 6 | 2024-06-17T00:00:00.000 | 232 4th Avenue, Brooklyn, NY, 11215 | BROOKLYN | 3250623 | B00717743 | 18 | 5 | 2022-06-07T00:00:00.000 | 2031-06-14T00:00:00.000 | 441 | 33 |
| 7 | 2024-06-17T00:00:00.000 | 180 East 125th Street | MANHATTAN | 1091630 | 121207504-01-FO | 455 | 137 | 2022-02-17T00:00:00.000 | 2027-03-31T00:00:00.000 | 1773 | 27 |
| 8 | 2024-06-17T00:00:00.000 | 360 Fulton St, Brooklyn, NY 11201 | BROOKLYN | 3000421 | B00658106-l1-FO | 451 | 135 | 2022-05-11T00:00:00.000 | 2028-05-31T00:00:00.000 | 154 | 5;11;12;14;15;18;19 |
| 9 | 2024-06-17T00:00:00.000 | 585 Union Street | BROOKLYN | 3429819 | B00621076 | 224 | 56 | 2022-05-11T00:00:00.000 | 2026-06-15T00:00:00.000 | 433 | 28 |
| 10 | 2024-06-17T00:00:00.000 | 251 Douglass Street | BROOKLYN | 3006610 | B00621061 | 260 | 65 | 2022-05-11T00:00:00.000 | 2026-10-31T00:00:00.000 | 412 | 50 |
Showing 12 of 27 columns. All of them are listed below.
BROOKLYNBRONXQUEENSreported_dob_bin_number | text | 421-a Building Reported DOB BIN as reported from the Form user. | 0% | N/A - MTA permitted purs…34298023018646 |
reported_dob_permit_sequence | text | 421-a Building Reported Commencement Permit as reported from the Form user. | 0% | X00685700X006883413 |
reported_units | integer | 421-a Building Reported Units as reported from the Form user. | 0% | 8109 |
reported_affordale_units | integer | 421-a Building Reported Affordable Units as reported from the Form user. | 0% | 386 |
reported_commencement_date | datetime | 421-a Building Reported Commencement Date as reported from the Form user. | 0% | 2022-06-14T00:00:00.0002022-06-09T00:00:00.0002022-06-10T00:00:00.000 |
reported_anticipated | datetime | 421-a Building Reported Completion Date as reported from the Form user. | 0% | 2027-01-01T00:00:00.0002026-07-01T00:00:00.0002026-06-01T00:00:00.000 |
reported_property_tax_block | integer | Tax Block of 421-a Building as reported from the Form user. | 0% | 4264622471 |
reported_property_tax_lot | text | Tax Lot(s) of 421-a Building as reported from the Form user. | 0% | 165 |
reported_affordability_option | categorical | 421-a Building Reported Affordability Option as reported from the Form user. | 0% | OPTION BOPTION AOPTION Fof 5 |
presumed_borough | categorical | 421-a Building Borough based on Presumed address | 0% | BROOKLYNBRONXQUEENSof 5 |
presumed_community_board | integer | 421-a Building Community Board of Presumed address | 0% | 317306301 |
presumed_council_district | integer | 421-a Building Council District of Presumed address | 0% | 393315 |
presumed_duplicate | text | Duplicate Filing of 421-a Building based on repeated Form user response. | 81% | DUPLICATEof 1 |
presumed_duplicate_weight | categorical | Fraction applied to each submission response where duplicates were identified. | 0% | 1.000.500.33of 3 |
presumed_building_units | integer | Count of Units in 421-a Building; where duplicates exist, highest number of reported units is utilized. | 0% | 8109 |
presumed_building_affordable | integer | Count of Reported Units in 421-a Building; where duplicates exist, highest number of reported affordable housing units is utilized. | 0% | 386 |
presumed_lot_1 | text | Presumed Tax Lots based on Form user response Property Tax Lot(s) merged with Borough and Property Tax Block | 0% | 300464005130042600171017730027 |
postcode | text | Zipcode where the site is located | 3% | 112261121710457 |
latitude | float | Latitude of the site's location | 3% | 40.84032340.83042340.681608 |
longitude | float | Longitude of the site's location | 3% | -73.922034-73.985921-73.936413 |
bbl | integer | The BBL (Borough, Block, and Lot) is a combination of three numeric codes -- a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. | 9% | 300426001730521200512028000046 |
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 that as part of the geocoding process, leading and trailing zeros are dropped. | 3% | 119017751 |
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 | 3% | BK0601BK1701BK0301 |