Real Estate Sales 2001-2022 GL

State of Connecticut

@usgov.state_of_connecticut_real_estate_sales_2001_2018

Table List

1 table(41.04 MB)

Table 1

@usgov.state_of_connecticut_real_estate_sales_2001_2018.table_1

41.04 MB
1097629 rows
14 columns

serial_number Serial Number	list_year List Year	date_recorded Date Recorded	town Town	address Address	assessed_value Assessed Value	sale_amount Sale Amount	sales_ratio Sales Ratio	property_type Property Type	residential_type Residential Type	non_use_code Non Use Code	location Location
220008	2022	Mon Jan 30 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Andover	618 ROUTE 6	139020	232000	0.5992	Residential	Single Family		POINT (-72.343628962 41.728431984)
2020348	2020	Mon Sep 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Ansonia	230 WAKELEE AVE	150500	325000	0.463	Commercial
20002	2020	Fri Oct 02 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Ashford	390 TURNPIKE RD	253000	430000	0.5883	Residential	Single Family
210317	2021	Tue Jul 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Avon	53 COTSWOLD WAY	329730	805000	0.4096	Residential	Single Family		POINT (-72.846365959 41.781677018)
200212	2020	Tue Mar 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Avon	5 CHESTNUT DRIVE	130400	179900	0.7248	Residential	Condo
200243	2020	Tue Apr 13 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Avon	111 NORTHINGTON DRIVE	619290	890000	0.6958	Residential	Single Family
200377	2020	Fri Jul 02 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Avon	70 FAR HILLS DRIVE	862330	1447500	0.5957	Residential	Single Family
22043	2022	Wed Mar 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Beacon Falls	41 EDGEWOOD DRIVE	164170	285000	0.576	Residential	Single Family		POINT (-73.053071989 41.439434021)
200109	2020	Wed Dec 09 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	Avon	57 FAR HILLS DRIVE	847520	1250000	0.678	Residential	Single Family
2020180	2020	Mon Mar 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Berlin	1539 FARMINGTON AVE	234200	130000	1.8015	Residential	Two Family	08 - Part Interest


CREATE TABLE table_1 (
  "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
);