Dataset: House Sales And Prices

About this Dataset

House Sales And Prices

This data comes form the Office of National Statisitcs about the number of sales of new build and existing (second hand) homes across our local area, between December 1995 and December 2015.
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:35:41Z

Tables

Newly Built Homes: Number Of Sales

@ukgov.house_sales_and_prices1.newly_built_homes_number_of_sales

56.48 KB
8 rows
83 columns


CREATE TABLE newly_built_homes_number_of_sales (
  "ons_code" VARCHAR,
  "area" VARCHAR,
  "q4_1995" BIGINT,
  "q1_1996" BIGINT,
  "q2_1996" BIGINT,
  "q3_1996" BIGINT,
  "q4_1996" BIGINT,
  "q1_1997" BIGINT,
  "q2_1997" BIGINT,
  "q3_1997" BIGINT,
  "q4_1997" BIGINT,
  "q1_1998" BIGINT,
  "q2_1998" BIGINT,
  "q3_1998" BIGINT,
  "q4_1998" BIGINT,
  "q1_1999" BIGINT,
  "q2_1999" BIGINT,
  "q3_1999" BIGINT,
  "q4_1999" BIGINT,
  "q1_2000" BIGINT,
  "q2_2000" BIGINT,
  "q3_2000" BIGINT,
  "q4_2000" BIGINT,
  "q1_2001" BIGINT,
  "q2_2001" BIGINT,
  "q3_2001" BIGINT,
  "q4_2001" BIGINT,
  "q1_2002" BIGINT,
  "q2_2002" BIGINT,
  "q3_2002" BIGINT,
  "q4_2002" BIGINT,
  "q1_2003" BIGINT,
  "q2_2003" BIGINT,
  "q3_2003" BIGINT,
  "q4_2003" BIGINT,
  "q1_2004" BIGINT,
  "q2_2004" BIGINT,
  "q3_2004" BIGINT,
  "q4_2004" BIGINT,
  "q1_2005" BIGINT,
  "q2_2005" BIGINT,
  "q3_2005" BIGINT,
  "q4_2005" BIGINT,
  "q1_2006" BIGINT,
  "q2_2006" BIGINT,
  "q3_2006" BIGINT,
  "q4_2006" BIGINT,
  "q1_2007" BIGINT,
  "q2_2007" BIGINT,
  "q3_2007" BIGINT,
  "q4_2007" BIGINT,
  "q1_2008" BIGINT,
  "q2_2008" BIGINT,
  "q3_2008" BIGINT,
  "q4_2008" BIGINT,
  "q1_2009" BIGINT,
  "q2_2009" BIGINT,
  "q3_2009" BIGINT,
  "q4_2009" BIGINT,
  "q1_2010" BIGINT,
  "q2_2010" BIGINT,
  "q3_2010" BIGINT,
  "q4_2010" BIGINT,
  "q1_2011" BIGINT,
  "q2_2011" BIGINT,
  "q3_2011" BIGINT,
  "q4_2011" BIGINT,
  "q1_2012" BIGINT,
  "q2_2012" BIGINT,
  "q3_2012" BIGINT,
  "q4_2012" BIGINT,
  "q1_2013" BIGINT,
  "q2_2013" BIGINT,
  "q3_2013" BIGINT,
  "q4_2013" BIGINT,
  "q1_2014" BIGINT,
  "q2_2014" BIGINT,
  "q3_2014" BIGINT,
  "q4_2014" BIGINT,
  "q1_2015" BIGINT,
  "q2_2015" BIGINT,
  "q3_2015" BIGINT,
  "q4_2015" BIGINT
);

Median Price Of Existing Homes

@ukgov.house_sales_and_prices1.median_price_of_existing_homes

56.8 KB
8 rows
83 columns


CREATE TABLE median_price_of_existing_homes (
  "ons_code" VARCHAR,
  "area" VARCHAR,
  "q4_1995" BIGINT,
  "q1_1996" BIGINT,
  "q2_1996" BIGINT,
  "q3_1996" BIGINT,
  "q4_1996" BIGINT,
  "q1_1997" BIGINT,
  "q2_1997" BIGINT,
  "q3_1997" BIGINT,
  "q4_1997" BIGINT,
  "q1_1998" BIGINT,
  "q2_1998" BIGINT,
  "q3_1998" BIGINT,
  "q4_1998" BIGINT,
  "q1_1999" BIGINT,
  "q2_1999" BIGINT,
  "q3_1999" BIGINT,
  "q4_1999" BIGINT,
  "q1_2000" BIGINT,
  "q2_2000" BIGINT,
  "q3_2000" BIGINT,
  "q4_2000" BIGINT,
  "q1_2001" BIGINT,
  "q2_2001" BIGINT,
  "q3_2001" BIGINT,
  "q4_2001" BIGINT,
  "q1_2002" BIGINT,
  "q2_2002" BIGINT,
  "q3_2002" BIGINT,
  "q4_2002" BIGINT,
  "q1_2003" BIGINT,
  "q2_2003" BIGINT,
  "q3_2003" BIGINT,
  "q4_2003" BIGINT,
  "q1_2004" BIGINT,
  "q2_2004" BIGINT,
  "q3_2004" BIGINT,
  "q4_2004" BIGINT,
  "q1_2005" BIGINT,
  "q2_2005" BIGINT,
  "q3_2005" BIGINT,
  "q4_2005" BIGINT,
  "q1_2006" BIGINT,
  "q2_2006" BIGINT,
  "q3_2006" BIGINT,
  "q4_2006" BIGINT,
  "q1_2007" BIGINT,
  "q2_2007" BIGINT,
  "q3_2007" BIGINT,
  "q4_2007" BIGINT,
  "q1_2008" BIGINT,
  "q2_2008" BIGINT,
  "q3_2008" BIGINT,
  "q4_2008" BIGINT,
  "q1_2009" BIGINT,
  "q2_2009" BIGINT,
  "q3_2009" BIGINT,
  "q4_2009" BIGINT,
  "q1_2010" BIGINT,
  "q2_2010" BIGINT,
  "q3_2010" BIGINT,
  "q4_2010" BIGINT,
  "q1_2011" BIGINT,
  "q2_2011" BIGINT,
  "q3_2011" BIGINT,
  "q4_2011" BIGINT,
  "q1_2012" BIGINT,
  "q2_2012" BIGINT,
  "q3_2012" BIGINT,
  "q4_2012" BIGINT,
  "q1_2013" BIGINT,
  "q2_2013" BIGINT,
  "q3_2013" BIGINT,
  "q4_2013" BIGINT,
  "q1_2014" BIGINT,
  "q2_2014" BIGINT,
  "q3_2014" BIGINT,
  "q4_2014" BIGINT,
  "q1_2015" BIGINT,
  "q2_2015" BIGINT,
  "q3_2015" BIGINT,
  "q4_2015" BIGINT
);

Existing Homes: Number Of Sales

@ukgov.house_sales_and_prices1.existing_homes_number_of_sales

56.62 KB
8 rows
83 columns


CREATE TABLE existing_homes_number_of_sales (
  "ons_code" VARCHAR,
  "area" VARCHAR,
  "q4_1995" BIGINT,
  "q1_1996" BIGINT,
  "q2_1996" BIGINT,
  "q3_1996" BIGINT,
  "q4_1996" BIGINT,
  "q1_1997" BIGINT,
  "q2_1997" BIGINT,
  "q3_1997" BIGINT,
  "q4_1997" BIGINT,
  "q1_1998" BIGINT,
  "q2_1998" BIGINT,
  "q3_1998" BIGINT,
  "q4_1998" BIGINT,
  "q1_1999" BIGINT,
  "q2_1999" BIGINT,
  "q3_1999" BIGINT,
  "q4_1999" BIGINT,
  "q1_2000" BIGINT,
  "q2_2000" BIGINT,
  "q3_2000" BIGINT,
  "q4_2000" BIGINT,
  "q1_2001" BIGINT,
  "q2_2001" BIGINT,
  "q3_2001" BIGINT,
  "q4_2001" BIGINT,
  "q1_2002" BIGINT,
  "q2_2002" BIGINT,
  "q3_2002" BIGINT,
  "q4_2002" BIGINT,
  "q1_2003" BIGINT,
  "q2_2003" BIGINT,
  "q3_2003" BIGINT,
  "q4_2003" BIGINT,
  "q1_2004" BIGINT,
  "q2_2004" BIGINT,
  "q3_2004" BIGINT,
  "q4_2004" BIGINT,
  "q1_2005" BIGINT,
  "q2_2005" BIGINT,
  "q3_2005" BIGINT,
  "q4_2005" BIGINT,
  "q1_2006" BIGINT,
  "q2_2006" BIGINT,
  "q3_2006" BIGINT,
  "q4_2006" BIGINT,
  "q1_2007" BIGINT,
  "q2_2007" BIGINT,
  "q3_2007" BIGINT,
  "q4_2007" BIGINT,
  "q1_2008" BIGINT,
  "q2_2008" BIGINT,
  "q3_2008" BIGINT,
  "q4_2008" BIGINT,
  "q1_2009" BIGINT,
  "q2_2009" BIGINT,
  "q3_2009" BIGINT,
  "q4_2009" BIGINT,
  "q1_2010" BIGINT,
  "q2_2010" BIGINT,
  "q3_2010" BIGINT,
  "q4_2010" BIGINT,
  "q1_2011" BIGINT,
  "q2_2011" BIGINT,
  "q3_2011" BIGINT,
  "q4_2011" BIGINT,
  "q1_2012" BIGINT,
  "q2_2012" BIGINT,
  "q3_2012" BIGINT,
  "q4_2012" BIGINT,
  "q1_2013" BIGINT,
  "q2_2013" BIGINT,
  "q3_2013" BIGINT,
  "q4_2013" BIGINT,
  "q1_2014" BIGINT,
  "q2_2014" BIGINT,
  "q3_2014" BIGINT,
  "q4_2014" BIGINT,
  "q1_2015" BIGINT,
  "q2_2015" BIGINT,
  "q3_2015" BIGINT,
  "q4_2015" BIGINT
);

Median Price Of Newly Built Homes

@ukgov.house_sales_and_prices1.median_price_of_newly_built_homes

56.86 KB
8 rows
83 columns


CREATE TABLE median_price_of_newly_built_homes (
  "ons_code" VARCHAR,
  "area" VARCHAR,
  "q4_1995" BIGINT,
  "q1_1996" BIGINT,
  "q2_1996" BIGINT,
  "q3_1996" BIGINT,
  "q4_1996" BIGINT,
  "q1_1997" BIGINT,
  "q2_1997" BIGINT,
  "q3_1997" BIGINT,
  "q4_1997" BIGINT,
  "q1_1998" BIGINT,
  "q2_1998" BIGINT,
  "q3_1998" BIGINT,
  "q4_1998" BIGINT,
  "q1_1999" BIGINT,
  "q2_1999" BIGINT,
  "q3_1999" BIGINT,
  "q4_1999" BIGINT,
  "q1_2000" BIGINT,
  "q2_2000" BIGINT,
  "q3_2000" BIGINT,
  "q4_2000" BIGINT,
  "q1_2001" BIGINT,
  "q2_2001" BIGINT,
  "q3_2001" BIGINT,
  "q4_2001" BIGINT,
  "q1_2002" BIGINT,
  "q2_2002" BIGINT,
  "q3_2002" BIGINT,
  "q4_2002" BIGINT,
  "q1_2003" BIGINT,
  "q2_2003" BIGINT,
  "q3_2003" BIGINT,
  "q4_2003" BIGINT,
  "q1_2004" BIGINT,
  "q2_2004" BIGINT,
  "q3_2004" BIGINT,
  "q4_2004" BIGINT,
  "q1_2005" BIGINT,
  "q2_2005" BIGINT,
  "q3_2005" BIGINT,
  "q4_2005" BIGINT,
  "q1_2006" BIGINT,
  "q2_2006" BIGINT,
  "q3_2006" BIGINT,
  "q4_2006" BIGINT,
  "q1_2007" BIGINT,
  "q2_2007" BIGINT,
  "q3_2007" BIGINT,
  "q4_2007" BIGINT,
  "q1_2008" BIGINT,
  "q2_2008" BIGINT,
  "q3_2008" BIGINT,
  "q4_2008" BIGINT,
  "q1_2009" BIGINT,
  "q2_2009" BIGINT,
  "q3_2009" BIGINT,
  "q4_2009" BIGINT,
  "q1_2010" BIGINT,
  "q2_2010" BIGINT,
  "q3_2010" BIGINT,
  "q4_2010" BIGINT,
  "q1_2011" BIGINT,
  "q2_2011" BIGINT,
  "q3_2011" BIGINT,
  "q4_2011" BIGINT,
  "q1_2012" BIGINT,
  "q2_2012" BIGINT,
  "q3_2012" BIGINT,
  "q4_2012" BIGINT,
  "q1_2013" BIGINT,
  "q2_2013" BIGINT,
  "q3_2013" BIGINT,
  "q4_2013" BIGINT,
  "q1_2014" BIGINT,
  "q2_2014" BIGINT,
  "q3_2014" BIGINT,
  "q4_2014" BIGINT,
  "q1_2015" BIGINT,
  "q2_2015" BIGINT,
  "q3_2015" BIGINT,
  "q4_2015" BIGINT
);