Dataset: Connecticut Real Estate Sales Data

About this Dataset

Connecticut Real Estate Sales Data

The Office of Policy and Management maintains a listing of all real estate sales with a sales price of $2,000 or greater that occur between October 1 and September 30 of each year. For each sale record, the file includes: town, property address, date of sale, property type (residential, apartment, commercial, industrial or vacant land), sales price, and property assessment.

Data are collected in accordance with Connecticut General Statutes, section 10-261a and 10-261b: https://www.cga.ct.gov/current/pub/chap_172.htm#sec_10-261a and https://www.cga.ct.gov/current/pub/chap_172.htm#sec_10-261b. Annual real estate sales are reported by grand list year (October 1 through September 30 each year). For instance, sales from 2018 GL are from 10/01/2018 through 9/30/2019.

Column Name	Description
Serial Number	A unique identifier for each record in the dataset.
List Year	The grand list year in which the sale was recorded.
Date Recorded	The date when the sale was recorded.
Town	The town where the property is located.
Address	The address of the property.
Assessed Value	The assessed value of the property.
Sale Amount	The sales price of the property.
Sales Ratio	The sales ratio of the property.
Property Type	The type of the property (residential, apartment, commercial, industrial, or vacant land).
Residential Type	The type of residential property (if applicable).
Non Use Code	The non-use code associated with the property (if applicable).
Assessor Remarks	Remarks or comments provided by the assessor (if available).
OPM Remarks	Remarks or comments provided by the Office of Policy and Management (if available).
Location	The location of the property (if available).

Tables

Real Estate Sales 2001–2020 Gl

@kaggle.utkarshx27_real_estate_sales_2001_2020_gl.real_estate_sales_2001_2020_gl

34.99 MB
997213 rows
14 columns


CREATE TABLE real_estate_sales_2001_2020_gl (
  "serial_number" BIGINT,
  "list_year" BIGINT,
  "date_recorded" TIMESTAMP,
  "town" VARCHAR,
  "address" VARCHAR,
  "assessed_value" DOUBLE,
  "sale_amount" DOUBLE,
  "sales_ratio" DOUBLE,
  "property_type" VARCHAR,
  "residential_type" VARCHAR,
  "non_use_code" VARCHAR,
  "assessor_remarks" VARCHAR,
  "opm_remarks" VARCHAR,
  "location" VARCHAR
);