About this Dataset

Local Law 44 - Development Team

The Development Team data table includes development team information for the developer (Borrower Legal Entity), GC, and subcontractors for each Local Law 44 Housing Development Project. This information is reported 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:00:57.881813
Tags: housing-transparency-local-law-44-ll44

Tables

Table 1

@usgov.city_of_new_york_local_law_44_development_team.table_1

944.06 kB
28,988 rows
28 columns

CREATE TABLE table_1 (
  "developmentteamdwid" BIGINT,
  "projectid" BIGINT,
  "type" VARCHAR,
  "entityname" VARCHAR,
  "firstname" VARCHAR,
  "lastname" VARCHAR,
  "entityindividualindicator" VARCHAR,
  "parententityname" VARCHAR,
  "individualrole" VARCHAR,
  "individualtitle" VARCHAR,
  "individualofficerequivalence" VARCHAR,
  "careof" VARCHAR,
  "number" VARCHAR,
  "street" VARCHAR,
  "apartmentsuitefloor" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "postcode" VARCHAR,
  "tradetype" VARCHAR,
  "borough" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);