Name: NYC Property Sales
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

NYC Property Sales

Context

This dataset is a record of every building or building unit (apartment, etc.) sold in the New York City property market over a 12-month period.

Content

This dataset contains the location, address, type, sale price, and sale date of building units sold. A reference on the trickier fields:

BOROUGH: A digit code for the borough the property is located in; in order these are Manhattan (1), Bronx (2), Brooklyn (3), Queens (4), and Staten Island (5).
BLOCK; LOT: The combination of borough, block, and lot forms a unique key for property in New York City. Commonly called a BBL.
BUILDING CLASS AT PRESENT and BUILDING CLASS AT TIME OF SALE: The type of building at various points in time. See the glossary linked to below.

For further reference on individual fields see the Glossary of Terms. For the building classification codes see the Building Classifications Glossary.

Note that because this is a financial transaction dataset, there are some points that need to be kept in mind:

Many sales occur with a nonsensically small dollar amount: $0 most commonly. These sales are actually transfers of deeds between parties: for example, parents transferring ownership to their home to a child after moving out for retirement.
This dataset uses the financial definition of a building/building unit, for tax purposes. In case a single entity owns the building in question, a sale covers the value of the entire building. In case a building is owned piecemeal by its residents (a condominium), a sale refers to a single apartment (or group of apartments) owned by some individual.

Acknowledgements

This dataset is a concatenated and slightly cleaned-up version of the New York City Department of Finance's Rolling Sales dataset.

Inspiration

What can you discover about New York City real estate by looking at a year's worth of raw transaction records? Can you spot trends in the market, or build a model that predicts sale value in the future?

Tables

Nyc Rolling Sales

@kaggle.new_york_city_nyc_property_sales.nyc_rolling_sales

2.07 MB
84,548 rows
22 columns

CREATE TABLE nyc_rolling_sales (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "borough" BIGINT,
  "neighborhood" VARCHAR,
  "building_class_category" VARCHAR,
  "tax_class_at_present" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "ease_ment" VARCHAR,
  "building_class_at_present" VARCHAR,
  "address" VARCHAR,
  "apartment_number" VARCHAR,
  "zip_code" BIGINT,
  "residential_units" BIGINT,
  "commercial_units" BIGINT,
  "total_units" BIGINT,
  "land_square_feet" VARCHAR,
  "gross_square_feet" VARCHAR,
  "year_built" BIGINT,
  "tax_class_at_time_of_sale" BIGINT,
  "building_class_at_time_of_sale" VARCHAR,
  "sale_price" VARCHAR,
  "sale_date" TIMESTAMP
);