About this Dataset

Local Law 44 - Building

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.
Organization: City of New York
Last updated: 2020-11-10T17:03:25.902510
Tags: housing-transparency-local-law-44-ll44

Tables

Table 1

@usgov.city_of_new_york_local_law_44_building.table_1

224.62 kB
3,239 rows
23 columns

CREATE TABLE table_1 (
  "projectid" BIGINT,
  "buildingid" VARCHAR,
  "reportingconstructiontype" VARCHAR,
  "borough" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "bin" VARCHAR,
  "housenumber" VARCHAR,
  "streetname" VARCHAR,
  "countedrentalunits" BIGINT,
  "countedhomeownershipunits" BIGINT,
  "allcountedunits" BIGINT,
  "totalbuildingunits" BIGINT,
  "basesquarefootage" DOUBLE,
  "stories" VARCHAR,
  "bbl" VARCHAR,
  "community_board" VARCHAR,
  "council_district" VARCHAR,
  "census_tract" VARCHAR,
  "nta" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "postcode" VARCHAR
);