Skip to content

Dataset: DOB Vacate Orders

Leo Shaw edited this page Jan 20, 2024 · 6 revisions

dob_vacate_orders

The dob_vacate_orders dataset can be added to NYCDB by running:

nycdb --download dob_vacate_orders
nycdb --load dob_vacate_orders

Provenance

The dataset was received from the Department of Buildings (DOB) through a FOIL request 11/5/2022. It covers vacate orders from 1/2012 through 9/2022.

Data dictionary

Click to Expand the dob_vacate_orders Data Dictionary
column_name data_type description
LastDispositionDateDateOfIssuanceOfVacate date Last Disposition Date (date of issuance of vacate)
LastDispositionYear integer Last Disposition Year
HouseNumber text House Number
StreetName text Street Name
BoroughName text Borough name
ZipCode char(5) ZIP Code
Block integer Block
Lot integer Lot
ComplaintCategoryDescription text Complaint Category Description
LastDispositionCodeDescription text Last Disposition Code Description
BBL char(10) Borough Block Lot

Tables

This dataset has the following tables:

  • dob_vacate_orders is the only table in this dataset.

Example Queries