NYC Property Sales

A year's worth of properties sold on the NYC real estate market

@kaggle.new_york_city_nyc_property_sales

Table List

1 table(1.97 MB)

Nyc Rolling Sales

@kaggle.new_york_city_nyc_property_sales.nyc_rolling_sales

1.97 MB
84548 rows
22 columns

unnamed_0 Unnamed: 0	borough BOROUGH	neighborhood NEIGHBORHOOD	building_class_category BUILDING CLASS CATEGORY	tax_class_at_present TAX CLASS AT PRESENT	block BLOCK	lot LOT	building_class_at_present BUILDING CLASS AT PRESENT	address ADDRESS	zip_code ZIP CODE	residential_units RESIDENTIAL UNITS	commercial_units COMMERCIAL UNITS	total_units TOTAL UNITS	land_square_feet LAND SQUARE FEET	gross_square_feet GROSS SQUARE FEET	year_built YEAR BUILT	tax_class_at_time_of_sale TAX CLASS AT TIME OF SALE	building_class_at_time_of_sale BUILDING CLASS AT TIME OF SALE	sale_price SALE PRICE	sale_date SALE DATE
4	1	ALPHABET CITY	07 RENTALS - WALKUP APARTMENTS	2A	392	6	C2	153 AVENUE B	10009	5		5	1633	6440	1900	2	C2	6625000	Wed Jul 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)
5	1	ALPHABET CITY	07 RENTALS - WALKUP APARTMENTS	2	399	26	C7	234 EAST 4TH STREET	10009	28	3	31	4616	18690	1900	2	C7	-	Wed Dec 14 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
6	1	ALPHABET CITY	07 RENTALS - WALKUP APARTMENTS	2	399	39	C7	197 EAST 3RD STREET	10009	16	1	17	2212	7803	1900	2	C7	-	Fri Dec 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
7	1	ALPHABET CITY	07 RENTALS - WALKUP APARTMENTS	2B	402	21	C4	154 EAST 7TH STREET	10009	10		10	2272	6794	1913	2	C4	3936272	Fri Sep 23 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
8	1	ALPHABET CITY	07 RENTALS - WALKUP APARTMENTS	2A	404	55	C2	301 EAST 10TH STREET	10009	6		6	2369	4615	1900	2	C2	8000000	Thu Nov 17 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
9	1	ALPHABET CITY	07 RENTALS - WALKUP APARTMENTS	2	405	16	C4	516 EAST 12TH STREET	10009	20		20	2581	9730	1900	2	C4	-	Thu Jul 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)
10	1	ALPHABET CITY	07 RENTALS - WALKUP APARTMENTS	2B	406	32	C4	210 AVENUE B	10009	8		8	1750	4226	1920	2	C4	3192840	Fri Sep 23 2016 00:00:00 GMT+0000 (Coordinated Universal Time)
11	1	ALPHABET CITY	07 RENTALS - WALKUP APARTMENTS	2	407	18	C7	520 EAST 14TH STREET	10009	44	2	46	5163	21007	1900	2	C7	-	Thu Jul 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)
12	1	ALPHABET CITY	08 RENTALS - ELEVATOR APARTMENTS	2	379	34	D5	141 AVENUE D	10009	15		15	1534	9198	1920	2	D5	-	Tue Jun 20 2017 00:00:00 GMT+0000 (Coordinated Universal Time)
13	1	ALPHABET CITY	08 RENTALS - ELEVATOR APARTMENTS	2	387	153	D9	629 EAST 5TH STREET	10009	24		24	4489	18523	1920	2	D9	16232000	Mon Nov 07 2016 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE nyc_rolling_sales (
  "unnamed_0" BIGINT,
  "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
);