About this Dataset

Local Law 44 - Projects

The Projects data table contains information about Housing Development Projects about which HPD is required to report pursuant to Local Law 44 of 2012. This includes general project information such as start and completion dates, units, Borrower Legal Entity, general contractor (GC), and prevailing wage information. There is a one-to-one relationship between this information and the project. This 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:05:33.724062
Tags: housing-transparency-local-law-44-ll44

Tables

Table 1

@usgov.city_of_new_york_local_law_44_projects.table_1

86.38 KB
986 rows
15 columns


CREATE TABLE table_1 (
  "projectdwid" BIGINT,
  "projectid" BIGINT,
  "projectname" VARCHAR,
  "programgroup" VARCHAR,
  "startdate" TIMESTAMP,
  "projectedcompletiondate" TIMESTAMP,
  "counted_rental_units" BIGINT,
  "counted_homeownership_units" BIGINT,
  "all_counted_units" DOUBLE,
  "totalprojectunits" BIGINT,
  "commercialsquarefootage" BIGINT,
  "borrowerlegalentityname" VARCHAR,
  "generalcontractorname" VARCHAR,
  "isdavisbacon" VARCHAR,
  "issection220nyslaborlaw" VARCHAR
);