Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Local Law 44 - Building

hu6m-9cfiHousing & Development24 columns
The Building data table Includes building-level information such as address, other location identifiers, stories, and square footage at base about which HPD is required to report pursuant to Local Law 44 of 2012, and is part of the Housing Projects Receiving City Financial Assistance (Local Law 44) collection of data tables .
View on NYC Open Data↗

Quality

B83.8 / 100

From a 500-row sample across 24 columns.

completeness100/ 25% weight
consistency58/ 20% weight
accuracy93/ 20% weight
timeliness71/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Local Law 44 - Projects0.61
    joins onprojectid
  • Local Law 44 - Development Team0.60
    joins onntabincouncil_district+7
  • Local Law 44 - Unit Income Rent0.59
    joins onprojectidbuildingid
  • Local Law 44 - Rent Affordability0.59
    joins onprojectidbuildingid
  • Local Law 44 - Other City Financial Assistance0.54

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

projectidbuildingidreportingconstructiontypeborough_codeboroidblocklotbinhousenumberstreetnamecountedrentalunitscountedhomeownershipunits
44218987329New Construction1Manhattan017900001105469123193 AVENUE2970
44223927737

Columns

24 queryable · 24 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
projectidtextThe unique ID that refers back to the Project ID column in the Project table (Foreign Key to the Project table)0%530174887768530
buildingidtextThe HPD Building ID is the unique numeric identifier assigned by HPD to all buildings0%80638980639097290
reportingconstructiontypecategoricalIndicates whether the building is categorized as 'new construction' or 'preservation' in Housing New York statistics. 'New construction' is where affordable housing units are created through the development of new buildings or down payment assistance enabling a new homeowner to access an affordable home. 'Preservation' is where existing buildings receive physical rehabilitation and/or financial operating assistance in exchange for affordability for existing and future tenants. Note that some pre0%PreservationNew Constructionof 2

Query this from your own app

GET /api/datasets/hu6m-9cfi
GET /api/datasets/hu6m-9cfi/quality
GET /api/datasets/hu6m-9cfi/related
GET /api/columns?dataset=hu6m-9cfi
joins on
projectid
  • Local Law 44 - Developer Selection0.54
    joins onprojectid
  • Local Law 44 - Funding0.53
    joins onprojectid
  • Local Law 44 - Tax Incentive0.53
    joins onprojectid
    • New Construction
    3
    Brooklyn
    01556
    0003
    300000
    335
    RALPH AVENUE
    0
    13
    44223969695New Construction3Brooklyn01709001030000035ROCHESTER AVENUE08
    44223975702New Construction3Brooklyn017090027300000018-22SUYDAM PLACE015
    44223977564New Construction3Brooklyn0155600073000000329RALPH AVENUE010
    44230336111New Construction3Brooklyn07014005334269412427MERMAID AVENUE21
    44230336151New Construction3Brooklyn07048000634138153216MERMAID AVENUE21
    44230394346New Construction3Brooklyn07021001634253882816WEST 16 STREET21
    44230927137New Construction3Brooklyn07014005231888902425MERMAID AVENUE21
    44230967108New Construction3Brooklyn06978002234137853566CANAL AVENUE21

    Showing 12 of 24 columns. All of them are listed below.

    borough_code
    categorical
    —
    0%
    321of 5
    boroidcategoricalNumeric code indicating each of the five boroughs of New York City0%BrooklynBronxManhattanof 5
    blocktextThe tax block assigned by the Department of Finance0%044520514102443
    lottextThe tax lot assigned by the Department of Finance0%000175010002
    bintextThe Building Identification Number (BIN) is the unique numeric identifier assigned by the Department of City Planning to all buildings1%30000030000002000000
    housenumbertextThe Primary House Number (PHN) is the street number where a building is located0%120100140
    streetnametextThe street where a building is located0%VANDALIA AVENUESCHROEDERS AVENUEEGAN STREET
    countedrentalunitsintegerCounted Rental Units are the units in the building, counted towards the Housing New York plan, where assistance has been provided to landlords in exchange for a requirement for affordable units.0%086
    countedhomeownershipunitsintegerCounted Homeownership Units are the units in the building, counted toward the Housing New York plan, where assistance has been provided directly to homeowners.0%01175
    allcountedunitsintegerThe Counted Units field indicates the total number of affordable, regulated units counted towards the Housing New York plan that are in the building.0%081
    totalbuildingunitsintegerThe number of units in the associated building0%183
    basesquarefootageintegerSquare footage of building footprint of each building (Square footage at base)2%08201
    storiestextNumber of stories in each building1%543
    bbltextThe Borough, Block, Lot (BBL) associated with the provided entity location.0%205141012020513500514124950002
    community_board_cbtextThe NYC community board associated with the provided entity location1%305110303
    council_districttextThe NYC council district associated with the provided entity location1%42917
    census_tracttextThe US census tract associated with the provided entity location1%107001391130
    ntatextThe Neighborhood Tabulation Area (NTA) associated with the provided entity location1%BK0504MN1002BX0101
    latitudefloatThe latitude associated with the provided entity location.1%40.82381440.82303240.824785
    longitudefloatThe longitude associated with the provided entity location.1%-73.919789-73.922374-73.922634
    postcodetextZIP Code for Development Team Entity or Individual's address1%112391120710456