Skip to content

Instantly share code, notes, and snippets.

@toolness

toolness/nycdb-schema.md

Last active January 31, 2019 15:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save toolness/26fc9bbcdc86f91360a3dff3ceae0a2a to your computer and use it in GitHub Desktop.
Save toolness/26fc9bbcdc86f91360a3dff3ceae0a2a to your computer and use it in GitHub Desktop.
Download ZIP
NYC-DB schema
Raw
nycdb-schema.md

NYC-DB schema

This documentation was automatically generated by a Python script.

Note that unless otherwise specified, all columns are nullable.

The dob_violations dataset

The dob_violations table

From the City of New York API metadata:

Violations that have been issued by the Department of Buildings. There may also be an ECB violation. (https://data.cityofnewyork.us/Housing-Development/DOB-ECB-Violations/6bgk-3dad).

This table has the following columns:

  • boro - A 1-character value.
  • bin - A text value.
  • block - A text value.
  • lot - A text value.
  • street - A text value.
  • description - A text value.
  • number - A text value.
  • bbl - A 10-character value.
  • isndobbisviol - A text value.
  • issuedate - A date value.
  • violationtypecode - A text value.
  • violationnumber - A text value.
  • housenumber - A text value.
  • dispositiondate - A date value.
  • dispositioncomments - A text value.
  • devicenumber - A text value.
  • ecbnumber - A text value.
  • violationcategory - A text value.
  • violationtype - A text value.

The pluto_18v1 dataset

The pluto_18v1 table

This table has the following columns:

  • borough - A text value.
  • block - A integer value.
  • lot - A integer value.
  • cd - A smallint value.
  • ct2010 - A text value.
  • cb2010 - A text value.
  • schooldist - A smallint value.
  • council - A smallint value.
  • zipcode - A 5-character value.
  • firecomp - A text value.
  • policeprct - A text value.
  • healthcenterdistrict - A smallint value.
  • healtharea - A text value.
  • sanitboro - A 1-character value.
  • sanitdistrict - A smallint value.
  • sanitsub - A 2-character value.
  • address - A text value.
  • zonedist1 - A text value.
  • zonedist2 - A text value.
  • zonedist3 - A text value.
  • zonedist4 - A text value.
  • overlay1 - A text value.
  • overlay2 - A text value.
  • spdist1 - A text value.
  • spdist2 - A text value.
  • spdist3 - A text value.
  • ltdheight - A text value.
  • splitzone - A boolean value.
  • bldgclass - A 2-character value.
  • landuse - A smallint value.
  • easements - A text value.
  • ownertype - A 1-character value.
  • ownername - A text value.
  • lotarea - A bigint value.
  • bldgarea - A bigint value.
  • comarea - A bigint value.
  • resarea - A bigint value.
  • officearea - A bigint value.
  • retailarea - A bigint value.
  • garagearea - A bigint value.
  • strgearea - A bigint value.
  • factryarea - A bigint value.
  • otherarea - A bigint value.
  • areasource - A text value.
  • numbldgs - A integer value.
  • numfloors - A numeric float value.
  • unitsres - A integer value.
  • unitstotal - A integer value.
  • lotfront - A numeric float value.
  • lotdepth - A numeric float value.
  • bldgfront - A numeric float value.
  • bldgdepth - A numeric float value.
  • ext - A text value.
  • proxcode - A 1-character value.
  • irrlotcode - A boolean value.
  • lottype - A 1-character value.
  • bsmtcode - A 1-character value.
  • assessland - A bigint value.
  • assesstot - A bigint value.
  • exemptland - A bigint value.
  • exempttot - A bigint value.
  • yearbuilt - A smallint value.
  • yearalter1 - A smallint value.
  • yearalter2 - A smallint value.
  • histdist - A text value.
  • landmark - A text value.
  • builtfar - A numeric float value.
  • residfar - A numeric float value.
  • commfar - A numeric float value.
  • facilfar - A numeric float value.
  • borocode - A 1-character value.
  • bbl - A 10-character value.
  • condono - A text value.
  • tract2010 - A text value.
  • xcoord - A integer value.
  • ycoord - A integer value.
  • zonemap - A text value.
  • zmcode - A 1-character value.
  • sanborn - A text value.
  • taxmap - A text value.
  • edesignum - A text value.
  • appbbl - A 10-character value.
  • appdate - A date value.
  • plutomapid - A 1-character value.
  • firm07flag - A 1-character value.
  • pfirm15flag - A 1-character value.
  • version - A text value.
  • lng - A numeric float value.
  • lat - A numeric float value.

The pluto_17v1 dataset

The pluto_17v1 table

This table has the following columns:

  • borough - A text value.
  • block - A integer value.
  • lot - A integer value.
  • cd - A smallint value.
  • ct2010 - A text value.
  • cb2010 - A text value.
  • schooldist - A smallint value.
  • council - A smallint value.
  • zipcode - A 5-character value.
  • firecomp - A text value.
  • policeprct - A text value.
  • healthcenterdistrict - A smallint value.
  • healtharea - A text value.
  • sanitboro - A 1-character value.
  • sanitdistrict - A smallint value.
  • sanitsub - A 2-character value.
  • address - A text value.
  • zonedist1 - A text value.
  • zonedist2 - A text value.
  • zonedist3 - A text value.
  • zonedist4 - A text value.
  • overlay1 - A text value.
  • overlay2 - A text value.
  • spdist1 - A text value.
  • spdist2 - A text value.
  • spdist3 - A text value.
  • ltdheight - A text value.
  • splitzone - A boolean value.
  • bldgclass - A 2-character value.
  • landuse - A smallint value.
  • easements - A text value.
  • ownertype - A 1-character value.
  • ownername - A text value.
  • lotarea - A bigint value.
  • bldgarea - A bigint value.
  • comarea - A bigint value.
  • resarea - A bigint value.
  • officearea - A bigint value.
  • retailarea - A bigint value.
  • garagearea - A bigint value.
  • strgearea - A bigint value.
  • factryarea - A bigint value.
  • otherarea - A bigint value.
  • areasource - A text value.
  • numbldgs - A integer value.
  • numfloors - A numeric float value.
  • unitsres - A integer value.
  • unitstotal - A integer value.
  • lotfront - A numeric float value.
  • lotdepth - A numeric float value.
  • bldgfront - A numeric float value.
  • bldgdepth - A numeric float value.
  • ext - A text value.
  • proxcode - A 1-character value.
  • irrlotcode - A boolean value.
  • lottype - A 1-character value.
  • bsmtcode - A 1-character value.
  • assessland - A bigint value.
  • assesstot - A bigint value.
  • exemptland - A bigint value.
  • exempttot - A bigint value.
  • yearbuilt - A smallint value.
  • yearalter1 - A smallint value.
  • yearalter2 - A smallint value.
  • histdist - A text value.
  • landmark - A text value.
  • builtfar - A numeric float value.
  • residfar - A numeric float value.
  • commfar - A numeric float value.
  • facilfar - A numeric float value.
  • borocode - A 1-character value.
  • bbl - A 10-character value.
  • condono - A text value.
  • tract2010 - A text value.
  • xcoord - A integer value.
  • ycoord - A integer value.
  • zonemap - A text value.
  • zmcode - A 1-character value.
  • sanborn - A text value.
  • taxmap - A text value.
  • edesignum - A text value.
  • appbbl - A 10-character value.
  • appdate - A date value.
  • plutomapid - A 1-character value.
  • firm07flag - A 1-character value.
  • pfirm15flag - A 1-character value.
  • version - A text value.
  • lng - A numeric float value.
  • lat - A numeric float value.

The pluto_16v2 dataset

The pluto_16v2 table

This table has the following columns:

  • borough - A text value.
  • block - A integer value.
  • lot - A integer value.
  • cd - A smallint value.
  • ct2010 - A text value.
  • cb2010 - A text value.
  • schooldist - A smallint value.
  • council - A smallint value.
  • zipcode - A 5-character value.
  • firecomp - A text value.
  • policeprct - A text value.
  • healtharea - A text value.
  • sanitboro - A 1-character value.
  • sanitdistrict - A smallint value.
  • sanitsub - A 2-character value.
  • address - A text value.
  • zonedist1 - A text value.
  • zonedist2 - A text value.
  • zonedist3 - A text value.
  • zonedist4 - A text value.
  • overlay1 - A text value.
  • overlay2 - A text value.
  • spdist1 - A text value.
  • spdist2 - A text value.
  • spdist3 - A text value.
  • ltdheight - A text value.
  • splitzone - A boolean value.
  • bldgclass - A 2-character value.
  • landuse - A smallint value.
  • easements - A text value.
  • ownertype - A 1-character value.
  • ownername - A text value.
  • lotarea - A bigint value.
  • bldgarea - A bigint value.
  • comarea - A bigint value.
  • resarea - A bigint value.
  • officearea - A bigint value.
  • retailarea - A bigint value.
  • garagearea - A bigint value.
  • strgearea - A bigint value.
  • factryarea - A bigint value.
  • otherarea - A bigint value.
  • areasource - A text value.
  • numbldgs - A integer value.
  • numfloors - A numeric float value.
  • unitsres - A integer value.
  • unitstotal - A integer value.
  • lotfront - A numeric float value.
  • lotdepth - A numeric float value.
  • bldgfront - A numeric float value.
  • bldgdepth - A numeric float value.
  • ext - A text value.
  • proxcode - A 1-character value.
  • irrlotcode - A boolean value.
  • lottype - A 1-character value.
  • bsmtcode - A 1-character value.
  • assessland - A bigint value.
  • assesstot - A bigint value.
  • exemptland - A bigint value.
  • exempttot - A bigint value.
  • yearbuilt - A smallint value.
  • yearalter1 - A smallint value.
  • yearalter2 - A smallint value.
  • histdist - A text value.
  • landmark - A text value.
  • builtfar - A numeric float value.
  • residfar - A numeric float value.
  • commfar - A numeric float value.
  • facilfar - A numeric float value.
  • borocode - A 1-character value.
  • bbl - A 10-character value.
  • condono - A text value.
  • tract2010 - A text value.
  • xcoord - A integer value.
  • ycoord - A integer value.
  • zonemap - A text value.
  • zmcode - A 1-character value.
  • sanborn - A text value.
  • taxmap - A text value.
  • edesignum - A text value.
  • appbbl - A 10-character value.
  • appdate - A date value.
  • plutomapid - A 1-character value.
  • version - A text value.
  • lng - A numeric float value.
  • lat - A numeric float value.

The dobjobs dataset

The dobjobs table

From the City of New York API metadata:

This dataset contains all job applications submitted through the Borough Offices, through eFiling, or through the HUB, which have a "Latest Action Date" since January 1, 2000. This dataset does not include jobs submitted through DOB NOW. See the DOB NOW: Build û Job Application Filings dataset for DOB NOW jobs.

This table has the following columns:

  • borough - A text value.

    1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island.

  • block - A text value.

    Tax block assigned by Department of Finance.

  • lot - A text value.

    Tax lot assigned by Department of Finance.

  • cluster - A boolean value.

    Cluster.

  • landmarked - A boolean value.

    L code indicates that the building has been assigned landmark status.

  • plumbing - A boolean value.

    Plumbing Work Type? (X=Yes, Blank=No).

  • mechanical - A boolean value.

    Mechanical Work Type? (X=Yes, Blank=No).

  • boiler - A boolean value.

    Boiler Work Type? (X=Yes, Blank=No).

  • standpipe - A boolean value.

    Standpipe Work Type? (X=Yes, Blank=No).

  • sprinkler - A boolean value.

    Sprinkler Work Type? (X=Yes, Blank=No).

  • equipment - A boolean value.

    Equipment Work Type? (X=Yes, Blank=No).

  • other - A boolean value.

    Other? (X=Yes, Blank=No).

  • paid - A date value.

    Date when job is paid.

  • assigned - A date value.

    Date when job is assigned to plan examiner.

  • approved - A date value.

    Date when job is approved.

  • state - A text value.

    State.

  • zip - A text value.

    Zip.

  • dobrundate - A date value.

    Date when query is run and pushed to Open Data. Could be used to differentiate report dates.

  • job - A bigint value.

  • doc - A smallint value.

  • house - A text value.

  • streetname - A text value.

  • bin - A integer value.

  • jobtype - A text value.

  • jobstatus - A text value.

  • jobstatusdescrp - A text value.

  • latestactiondate - A date value.

  • buildingtype - A text value.

  • communityboard - A text value.

  • adultestab - A boolean value.

  • loftboard - A boolean value.

  • cityowned - A boolean value.

  • littlee - A boolean value.

  • pcfiled - A boolean value.

  • efilingfiled - A boolean value.

  • fuelburning - A boolean value.

  • fuelstorage - A boolean value.

  • firealarm - A boolean value.

  • firesuppression - A boolean value.

  • curbcut - A boolean value.

  • otherdescription - A text value.

  • applicantsfirstname - A text value.

  • applicantslastname - A text value.

  • applicantprofessionaltitle - A text value.

  • applicantlicense - A text value.

  • professionalcert - A text value.

  • prefilingdate - A date value.

  • fullypaid - A date value.

  • fullypermitted - A date value.

  • initialcost - A bigint value.

  • totalestfee - A bigint value.

  • feestatus - A text value.

  • existingzoningsqft - A integer value.

  • proposedzoningsqft - A integer value.

  • horizontalenlrgmt - A boolean value.

  • verticalenlrgmt - A boolean value.

  • enlargementsqfootage - A integer value.

  • streetfrontage - A integer value.

  • existingnoofstories - A integer value.

  • proposednoofstories - A integer value.

  • existingheight - A integer value.

  • proposedheight - A integer value.

  • existingdwellingunits - A integer value.

  • proposeddwellingunits - A integer value.

  • existingoccupancy - A text value.

  • proposedoccupancy - A text value.

  • sitefill - A text value.

  • zoningdist1 - A text value.

  • zoningdist2 - A text value.

  • zoningdist3 - A text value.

  • specialdistrict1 - A text value.

  • specialdistrict2 - A text value.

  • ownertype - A text value.

  • nonprofit - A boolean value.

  • ownersfirstname - A text value.

  • ownerslastname - A text value.

  • ownersbusinessname - A text value.

  • ownershousenumber - A text value.

  • ownershousestreetname - A text value.

  • city - A text value.

  • ownersphone - A text value.

  • jobdescription - A text value.

  • jobs1no - A integer value.

  • totalconstructionfloorarea - A integer value.

  • withdrawalflag - A smallint value.

  • signoffdate - A date value.

  • specialactionstatus - A 1-character value.

  • specialactiondate - A date value.

  • buildingclass - A text value.

  • jobnogoodcount - A smallint value.

  • gislatitude - A numeric float value.

  • gislongitude - A numeric float value.

  • giscouncildistrict - A smallint value.

  • giscensustract - A text value.

  • gisntaname - A text value.

  • gisbin - A integer value.

  • bbl - A 10-character value.

  • id - A required integer value.

  • address - A text value.

  • ownername - A text value.

  • applicantname - A text value.

The hpd_complaints dataset

The hpd_complaints table

From the City of New York API metadata:

The Department of Housing Preservation and Development (HPD) records complaints that are made by the public through the 311 Citizen Services Center, Code Enforcement Borough Offices or the internet for conditions which violate the New York City Housing Maintenance Code (HMC) or the New York State Multiple Dwelling Law (MDL). Each complaint is associated with one or more problems reported by the complainant. Problems are closed if a tenant verifies by phone that the condition was corrected or an inspection result is entered by an HPD inspector. A complaint is closed when all associated problems are closed.

This table has the following columns:

  • complaintid - A integer value.

    System generated unique identifier given to a complaint record.

  • buildingid - A integer value.

    Unique identifier given to a building record.

  • boroughid - A integer value.

    unique number to identify Borough.

  • borough - A text value.

    Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island).

  • housenumber - A text value.

    Complaint house number.

  • streetname - A text value.

    Complaint street name.

  • zip - A text value.

    Complaint zip code.

  • block - A integer value.

    Number assigned by DoF identifying the Tax block the lot is on.

  • lot - A integer value.

    Unique number assigned by DoF within a Block identifying a lot.

  • apartment - A text value.

    Number of the unit or apartment in a building.

  • communityboard - A integer value.

    Unique number identifying a Community District/Board, which is a political geographical area within a borough of the City of NY.

  • receiveddate - A date value.

    Date when the complaint was received.

  • statusid - A integer value.

    unique number to identify complaint status.

  • status - A text value.

    Numeric value representing the complaint status (see ComplaintStatus below).

  • statusdate - A date value.

    Date when the complaint status was updated.

  • bbl - A 10-character value.

The hpd_complaint_problems table

From the City of New York API metadata:

Contains information about problems associated with complaints.

This table has the following columns:

  • problemid - A integer value.

    Unique identifier of this problem.

  • complaintid - A integer value.

    Unique identifier of the complaint this problem is associated with.

  • unittypeid - A smallint value.

    Unique number to identify unit type.

  • unittype - A text value.

    Type of unit where the problem was reported.

  • spacetype - A text value.

    Type of space where the problem was reported.

  • typeid - A smallint value.

    Unique number to identify Problem Type.

  • type - A text value.

    Numeric code indicating the problem type.

  • majorcategoryid - A smallint value.

    Unique number to identify Problem Major Category.

  • majorcategory - A text value.

    The major category of the problem.

  • minorcategoryid - A smallint value.

    The minor category.

  • minorcategory - A text value.

    The minor category.

  • codeid - A smallint value.

    Unique number to identify problem Code.

  • code - A text value.

    The problem code.

  • statusid - A smallint value.

    unique number to identify problem status.

  • status - A text value.

    The status of the problem.

  • statusdate - A date value.

    Date when the problem status was updated.

  • statusdescription - A text value.

    Status description.

  • spacetypeid - A smallint value.

The dob_complaints dataset

The dob_complaints table

This table has the following columns:

  • complaintnumber - A integer value.
  • status - A text value.
  • dateentered - A date value.
  • housenumber - A text value.
  • zipcode - A text value.
  • housestreet - A text value.
  • bin - A integer value.
  • communityboard - A integer value.
  • specialdistrict - A text value.
  • complaintcategory - A text value.
  • unit - A text value.
  • dispositiondate - A date value.
  • dispositioncode - A text value.
  • inspectiondate - A date value.
  • dobrundate - A date value.

The hpd_violations dataset

The hpd_violations table

From the City of New York API metadata:

Pursuant to New York CityÆs Housing Maintenance Code, the Department of Housing Preservation and Development (HPD) issues violations against conditions in rental dwelling units that have been verified to violate the New York City using Maintenance Code (HMC) or the New York State Multiple Dwelling Law (MDL). Violations are issued when an inspection verifies that a violation of the HMC or MDL exists. It is closed when the violation is corrected, as observed/verified by HPD or as certified by the landlord.

This table has the following columns:

  • violationid - A integer value.

    Unique identifier of Violation.

  • buildingid - A integer value.

    Unique identifier of building.

  • registrationid - A integer value.

    Unique identifier of valid registration information.

  • boroid - A 1-character value.

    unique number to identify borough.

  • housenumber - A text value.

    Address information for the building.

  • lowhousenumber - A text value.

    Address information for the building.

  • highhousenumber - A text value.

    Address information for the building.

  • streetname - A text value.

    Address information for the building.

  • streetcode - A text value.

    Address information for the building.

  • apartment - A text value.

    Apartment with violation, if applicable.

  • story - A text value.

    Floor of violation.

  • block - A integer value.

    Tax block for building.

  • lot - A integer value.

    Tax lot for building.

  • class - A 1-character value.

    Indicator of seriousness of the violations, where A is the least serious and C is the most serious.

  • inspectiondate - A date value.

    Date when the violation was observed.

  • approveddate - A date value.

    Date when violation was approved.

  • originalcertifybydate - A date value.

    Original date by when the owner was to inform HPD that the violation as corrected.

  • originalcorrectbydate - A date value.

    Original date by when the owner was to correct the violation.

  • newcertifybydate - A date value.

    Modified date by when the owner was to inform HPD that the violation as corrected.

  • newcorrectbydate - A date value.

    Modified date by when the owner was to correct the violation.

  • certifieddate - A date value.

    Date when the violation was certified (if it was).

  • ordernumber - A text value.

    Reference to the abstract description of the violation condition which cites a specific section of the law which is in violation.

  • novid - A integer value.

    Unique identifier of the Notice of Violation sent to the owner.

  • novdescription - A text value.

    Description of the violation.

  • novissueddate - A date value.

    Date when the NOV was sent.

  • currentstatusid - A smallint value.

    unique id to identify current status.

  • currentstatus - A text value.

    Violation status (see below for details).

  • currentstatusdate - A date value.

    Date when the current status when into effect.

  • novtype - A text value.

    Original / Reissued Notice of Violation. For more information on the Reissuance process, see http://www1.nyc.gov/site/hpd/owners/compliance-clear-violations.page .

  • violationstatus - A text value.

    Status of Violation(Open / Close).

  • latitude - A numeric float value.

    The latitude associated with the provided entity location.

  • longitude - A numeric float value.

    The longitude associated with the provided entity location.

  • communityboard - A text value.

    The NYC community board associated with the provided entity location (numbered 1 û 59.

  • councildistrict - A smallint value.

    The NYC council district associated with the provided entity location (numbered 1 û 51).

  • censustract - A text value.

    The US census tract associated with the provided entity location (in the format of up to four-digit integers, followed by an optional two-digit suffix; e.g., ô15.02ö or ô319ö).

  • bin - A integer value.

    The Building Identification Number (BIN) associated with the provided entity location. It is formatted as a seven-digit numerical identifier, which is unique to each building in NYC.

  • bbl - A 10-character value.

    The Borough, Block, Lot (BBL) associated with the provided entity location. It is formatted as a ten-digit numerical identifier, which is unique to each parcel of real property in NYC.

  • nta - A text value.

    The Neighborhood Tabulation Area (NTA) associated with the provided entity location, which is formatted as a two-letter borough identifier followed by a two-digit numerical identifier (e.g., ôBX31ö).

  • borough - A text value.

  • postcode - A 5-character value.

The hpd_registrations dataset

The hpd_registrations table

From the City of New York API metadata:

Pursuant to New York CityÆs Housing Maintenance Code, the Department of Housing Preservation and Development (HPD) collects registration information from owners of residential rental units. Owners are required to register if they own residential buildings with three or more units or if they own one- or two-family homes and neither they nor members of their immediate family live there. Registrations are required upon taking ownership of a qualifying building, and once a year thereafter.

This table has the following columns:

  • registrationid - A integer value.

    Unique identifier of Registration.

  • buildingid - A integer value.

    Unique identifier of building being registered.

  • boroid - A smallint value.

    Unique identifier of a borough.

  • boro - A text value.

    Boro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island).

  • housenumber - A text value.

    Address information for the building.

  • lowhousenumber - A text value.

    Address information for the building.

  • highhousenumber - A text value.

    Address information for the building.

  • streetname - A text value.

    Address information for the building.

  • streetcode - A integer value.

    Address information for the building.

  • zip - A text value.

    Address information for the building.

  • block - A smallint value.

    Tax block for building.

  • lot - A smallint value.

    Tax lot for building.

  • bin - A integer value.

    DCP Building Identification Number for building.

  • communityboard - A smallint value.

    Community Board for building.

  • lastregistrationdate - A date value.

    Date on which the registration information was processed.

  • registrationenddate - A date value.

    Expiration date of registration record.

  • bbl - A 10-character value.

The hpd_contacts table

From the City of New York API metadata:

Contains information about organizations or individuals listed on a Multiple Dwelling Registration form.

This table has the following columns:

  • registrationcontactid - A integer value.

    Unique identifier of RegistrationContact.

  • registrationid - A integer value.

    Unique identifier of owning Registration.

  • type - A text value.

    "Individual Owner", "Corporate Owner", "Managing Agent", "Head Officer", "Officer", "Shareholder".

  • contactdescription - A text value.

    Description of contact.

  • corporationname - A text value.

    If applicable.

  • title - A text value.

    Contact person information.

  • firstname - A text value.

    Contact person information.

  • middleinitial - A text value.

    Contact person information.

  • lastname - A text value.

    Contact person information.

  • businesshousenumber - A text value.

    Contact address information.

  • businessstreetname - A text value.

    Contact address information.

  • businessapartment - A text value.

    Contact address information.

  • businesscity - A text value.

    Contact address information.

  • businessstate - A text value.

    Contact address information.

  • businesszip - A text value.

    Contact address information.

The dof_sales dataset

The dof_sales table

This table has the following columns:

  • borough - A 1-character value.
  • neighborhood - A text value.
  • buildingclasscategory - A text value.
  • taxclassatpresent - A text value.
  • block - A 5-character value.
  • lot - A 4-character value.
  • easement - A text value.
  • buildingclassatpresent - A text value.
  • address - A text value.
  • apartmentnumber - A text value.
  • zipcode - A 5-character value.
  • residentialunits - A integer value.
  • commercialunits - A integer value.
  • totalunits - A integer value.
  • landsquarefeet - A integer value.
  • grosssquarefeet - A integer value.
  • yearbuilt - A integer value.
  • taxclassattimeofsale - A text value.
  • buildingclassattimeofsale - A text value.
  • saleprice - A bigint value.
  • saledate - A date value.
  • bbl - A 10-character value.
  • id - A required integer value.

The rentstab dataset

The rentstab table

This table has the following columns:

  • borough - A text value.
  • ucbbl - A 10-character value.
  • uc2007 - A integer value.
  • est2007 - A boolean value.
  • dhcr2007 - A boolean value.
  • abat2007 - A text array value.
  • uc2008 - A integer value.
  • est2008 - A boolean value.
  • dhcr2008 - A boolean value.
  • abat2008 - A text array value.
  • uc2009 - A integer value.
  • est2009 - A boolean value.
  • dhcr2009 - A boolean value.
  • abat2009 - A text array value.
  • uc2010 - A integer value.
  • est2010 - A boolean value.
  • dhcr2010 - A boolean value.
  • abat2010 - A text array value.
  • uc2011 - A integer value.
  • est2011 - A boolean value.
  • dhcr2011 - A boolean value.
  • abat2011 - A text array value.
  • uc2012 - A integer value.
  • est2012 - A boolean value.
  • dhcr2012 - A boolean value.
  • abat2012 - A text array value.
  • uc2013 - A integer value.
  • est2013 - A boolean value.
  • dhcr2013 - A boolean value.
  • abat2013 - A text array value.
  • uc2014 - A integer value.
  • est2014 - A boolean value.
  • dhcr2014 - A boolean value.
  • abat2014 - A text array value.
  • uc2015 - A integer value.
  • est2015 - A boolean value.
  • dhcr2015 - A boolean value.
  • abat2015 - A text array value.
  • uc2016 - A integer value.
  • est2016 - A boolean value.
  • dhcr2016 - A boolean value.
  • abat2016 - A text array value.
  • uc2017 - A integer value.
  • est2017 - A boolean value.
  • dhcr2017 - A boolean value.
  • abat2017 - A text array value.
  • cd - A smallint value.
  • ct2010 - A text value.
  • cb2010 - A text value.
  • council - A integer value.
  • zipcode - A 5-character value.
  • address - A text value.
  • ownername - A text value.
  • numbldgs - A smallint value.
  • numfloors - A numeric float value.
  • unitsres - A integer value.
  • unitstotal - A integer value.
  • yearbuilt - A smallint value.
  • condono - A smallint value.
  • lon - A numeric float value.
  • lat - A numeric float value.

The rentstab_summary dataset

The rentstab_summary table

This table has the following columns:

  • ucbbl - A 10-character value.
  • unitstotal - A integer value.
  • unitsstab2007 - A integer value.
  • unitsstab2017 - A integer value.
  • diff - A integer value.
  • percentchange - A numeric float value.
  • j51 - A text value.
  • a421 - A text value.
  • scrie - A text value.
  • drie - A text value.
  • c420 - A text value.
  • cd - A smallint value.
  • ct2010 - A text value.
  • cb2010 - A text value.
  • council - A integer value.
  • zipcode - A 5-character value.
  • address - A text value.
  • ownername - A text value.
  • numbldgs - A smallint value.
  • numfloors - A numeric float value.
  • unitsres - A integer value.
  • unitstotalpluto - A integer value.
  • yearbuilt - A smallint value.
  • condono - A smallint value.
  • lon - A numeric float value.
  • lat - A numeric float value.

The acris dataset

The acris_country_codes table

From the City of New York API metadata:

ACRIS Countries mapping for Codes in the ACRIS Real and Personal Parties Property Datasets.

This table has the following columns:

  • description - A text value.

    Country name.

  • recordtype - A 1-character value.

  • countrycode - A 2-character value.

The acris_document_control_codes table

From the City of New York API metadata:

ACRIS Document Type and Class Code mappings for Codes in the ACRIS Real and Personal Property Master Datasets.

This table has the following columns:

  • recordtype - A 1-character value.
  • doctype - A text value.
  • doctypedescription - A text value.
  • classcodedescription - A text value.
  • party1type - A text value.
  • party2type - A text value.
  • party3type - A text value.

The acris_property_type_codes table

From the City of New York API metadata:

ACRIS State mapping for Codes in the ACRIS Real and Personal Property Legals Datasets.

This table has the following columns:

  • description - A text value.

    Property type description.

  • recordtype - A 1-character value.

  • propertytype - A 2-character value.

The acris_ucc_collateral_codes table

From the City of New York API metadata:

ACRIS Collateral Type mapping for Codes in the ACRIS Personal Property Master Dataset.

This table has the following columns:

  • description - A text value.

    UCC Collateral description.

  • recordtype - A 1-character value.

  • ucccollateralcode - A 1-character value.

The personal_property_legals table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A 1-character value.
  • borough - A smallint value.
  • block - A integer value.
  • lot - A integer value.
  • easement - A boolean value.
  • partiallot - A 1-character value.
  • airrights - A boolean value.
  • subterraneanrights - A boolean value.
  • propertytype - A 2-character value.
  • streetnumber - A text value.
  • streetname - A text value.
  • unit - A text value.
  • goodthroughdate - A date value.
  • bbl - A 10-character value.

The personal_property_master table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A 1-character value.
  • crfn - A text value.
  • borough - A smallint value.
  • doctype - A text value.
  • docamount - A bigint value.
  • recordedfiled - A date value.
  • collateral - A 1-character value.
  • slid - A text value.
  • assessmentdate - A date value.
  • rptt - A integer value.
  • modifieddate - A date value.
  • reelyear - A smallint value.
  • reelnbr - A integer value.
  • reelpage - A integer value.
  • filenumber - A integer value.
  • goodthroughdate - A date value.

The personal_property_parties table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A 1-character value.
  • partytype - A smallint value.
  • name - A text value.
  • address1 - A text value.
  • address2 - A text value.
  • country - A text value.
  • city - A text value.
  • state - A text value.
  • zip - A text value.
  • goodthroughdate - A date value.

The personal_property_references table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A text value.
  • referencebycrfn - A text value.
  • referencebydocid - A text value.
  • referencebyfilenbr - A text value.
  • goodthroughdate - A date value.

The personal_property_remarks table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A 1-character value.
  • remarklinenbr - A smallint value.
  • remarktextline - A text value.
  • goodthroughdate - A date value.

The real_property_legals table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A 1-character value.
  • borough - A smallint value.
  • block - A integer value.
  • lot - A integer value.
  • easement - A boolean value.
  • partiallot - A 1-character value.
  • airrights - A boolean value.
  • subterraneanrights - A boolean value.
  • propertytype - A 2-character value.
  • streetnumber - A text value.
  • streetname - A text value.
  • unit - A text value.
  • goodthroughdate - A date value.
  • bbl - A 10-character value.

The real_property_master table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A 1-character value.
  • crfn - A text value.
  • borough - A 1-character value.
  • doctype - A text value.
  • docdate - A date value.
  • docamount - A bigint value.
  • recordedfiled - A date value.
  • modifieddate - A date value.
  • reelyear - A smallint value.
  • reelnbr - A integer value.
  • reelpage - A integer value.
  • pcttransferred - A numeric float value.
  • goodthroughdate - A date value.

The real_property_parties table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A 1-character value.
  • partytype - A smallint value.
  • name - A text value.
  • address1 - A text value.
  • address2 - A text value.
  • country - A text value.
  • city - A text value.
  • state - A text value.
  • zip - A text value.
  • goodthroughdate - A date value.

The real_property_references table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A text value.
  • referencebycrfn - A text value.
  • referencebydocid - A text value.
  • referencebyreelyear - A smallint value.
  • referencebyreelborough - A smallint value.
  • referencebyreelnbr - A integer value.
  • referencebyreelpage - A integer value.
  • goodthroughdate - A date value.

The real_property_remarks table

This table has the following columns:

  • documentid - A text value.
  • recordtype - A 1-character value.
  • remarklinenbr - A smallint value.
  • remarktextline - A text value.
  • goodthroughdate - A date value.

The marshal_evictions_17 dataset

The marshal_evictions_17 table

This table has the following columns:

  • boro - A text value.
  • courtindex - A text value.
  • docketnumber - A text value.
  • evictionaddress - A text value.
  • apt - A text value.
  • zip - A text value.
  • uniqueid - A text value.
  • executeddate - A date value.
  • marshalfirstname - A text value.
  • marshallastname - A text value.
  • evictiontype - A text value.
  • scheduledstatus - A text value.
  • cleanedaddress1 - A text value.
  • lat - A numeric float value.
  • lng - A numeric float value.
  • geocoder - A text value.
  • cleanedaddress2 - A text value.
  • bbl - A 10-character value.

The oath_hearings dataset

The oath_hearings table

From the City of New York API metadata:

The OATH Hearings Division Case Status dataset contains information about alleged public safety and quality of life violations that are filed and adjudicated through the CityÆs administrative law court, the NYC Office of Administrative Trials and Hearings (OATH) and provides information about the infraction charged, decision outcome, payments, amounts and fees relating to the case. The summonses listed in this dataset are issued and filed at the OATH Hearings Division by City enforcement agencies.

This table has the following columns:

  • ticketnumber - A text value.
  • violationdate - A date value.
  • violationtime - A time without time zone value.
  • issuingagency - A text value.
  • respondentfirstname - A text value.
  • respondentlastname - A text value.
  • balancedue - A numeric float value.
  • violationlocationborough - A text value.
  • violationlocationblockno - A integer value.
  • violationlocationlotno - A integer value.
  • violationlocationhouse - A text value.
  • violationlocationstreetname - A text value.
  • violationlocationfloor - A text value.
  • violationlocationcity - A text value.
  • violationlocationzipcode - A 5-character value.
  • violationlocationstatename - A text value.
  • respondentaddressborough - A text value.
  • respondentaddresshouse - A text value.
  • respondentaddressstreetname - A text value.
  • respondentaddresscity - A text value.
  • respondentaddresszipcode - A 5-character value.
  • respondentaddressstatename - A text value.
  • hearingstatus - A text value.
  • hearingresult - A text value.
  • scheduledhearinglocation - A text value.
  • hearingdate - A date value.
  • hearingtime - A time without time zone value.
  • decisionlocationborough - A text value.
  • decisiondate - A date value.
  • totalviolationamount - A numeric float value.
  • violationdetails - A text value.
  • datejudgmentdocketed - A date value.
  • respondentaddressorfacilitynumberforfdnyanddobtickets - A text value.
  • penaltyimposed - A numeric float value.
  • paidamount - A numeric float value.
  • additionalpenaltiesorlatefees - A numeric float value.
  • compliancestatus - A text value.
  • violationdescription - A text value.
  • charge1code - A text value.
  • charge1codesection - A text value.
  • charge1codedescription - A text value.
  • charge1infractionamount - A numeric float value.
  • charge2code - A text value.
  • charge2codesection - A text value.
  • charge2codedescription - A text value.
  • charge2infractionamount - A numeric float value.
  • charge3code - A text value.
  • charge3codesection - A text value.
  • charge3codedescription - A text value.
  • charge3infractionamount - A numeric float value.
  • charge4code - A text value.
  • charge4codesection - A text value.
  • charge4codedescription - A text value.
  • charge4infractionamount - A numeric float value.
  • charge5code - A text value.
  • charge5codesection - A text value.
  • charge5codedescription - A text value.
  • charge5infractionamount - A numeric float value.
  • charge6code - A text value.
  • charge6codesection - A text value.
  • charge6codedescription - A text value.
  • charge6infractionamount - A numeric float value.
  • charge7code - A text value.
  • charge7codesection - A text value.
  • charge7codedescription - A text value.
  • charge7infractionamount - A numeric float value.
  • charge8code - A text value.
  • charge8codesection - A text value.
  • charge8codedescription - A text value.
  • charge8infractionamount - A numeric float value.
  • charge9code - A text value.
  • charge9codesection - A text value.
  • charge9codedescription - A text value.
  • charge9infractionamount - A numeric float value.
  • charge10code - A text value.
  • charge10codesection - A text value.
  • charge10codedescription - A text value.
  • charge10infractionamount - A numeric float value.
  • bbl - A 10-character value.
@toolness
Copy link
Author

Specifically, this was generated by: https://github.com/toolness/nycdb-fun/blob/master/introspect_schema.py

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment