Archived Price Paid Data: 1995 To 2017

CREATE TABLE price_paid_data_2003_part_1 (
  "n__2a289e9e_06a3_cdc8_e050_a8c063054829" VARCHAR  -- {2A289E9E-06A3-CDC8-E050-A8C063054829},
  "n_172500" BIGINT  -- 172500,
  "n_2003_03_23_00_00" TIMESTAMP  -- 2003-03-23–00:00,
  "de1_2gt" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_8" VARCHAR  -- 8,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "charnwood_street" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "derby" VARCHAR,
  "city_of_derby" VARCHAR,
  "city_of_derby_1" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2003_part_2 (
  "n__661050fc_c935_4e0b_95cb_6c26f9714503" VARCHAR  -- {661050FC-C935-4E0B-95CB-6C26F9714503},
  "n_20000" BIGINT  -- 20000,
  "n_2003_07_29_00_00" TIMESTAMP  -- 2003-07-29–00:00,
  "ne15_8dn" VARCHAR,
  "f" VARCHAR,
  "n" VARCHAR,
  "l" VARCHAR,
  "n_5" VARCHAR  -- 5,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "lesbury_street" VARCHAR,
  "newcastle_upon_tyne" VARCHAR,
  "newcastle_upon_tyne_1" VARCHAR,
  "newcastle_upon_tyne_2" VARCHAR,
  "tyne_and_wear" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2004 (
  "n__87f11a5a_6e96_4b4a_a95d_0f6f6aacd32a" VARCHAR  -- {87F11A5A-6E96-4B4A-A95D-0F6F6AACD32A},
  "n_236000" BIGINT  -- 236000,
  "n_2004_08_25_00_00" TIMESTAMP  -- 2004-08-25–00:00,
  "ub6_9dq" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_3" VARCHAR  -- 3,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "canterbury_close" VARCHAR,
  "greenford" VARCHAR,
  "greenford_1" VARCHAR,
  "ealing" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2004_part_1 (
  "n__87f11a5a_6e96_4b4a_a95d_0f6f6aacd32a" VARCHAR  -- {87F11A5A-6E96-4B4A-A95D-0F6F6AACD32A},
  "n_236000" BIGINT  -- 236000,
  "n_2004_08_25_00_00" TIMESTAMP  -- 2004-08-25–00:00,
  "ub6_9dq" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_3" VARCHAR  -- 3,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "canterbury_close" VARCHAR,
  "greenford" VARCHAR,
  "greenford_1" VARCHAR,
  "ealing" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2004_part_2 (
  "n__e14eaae9_3d59_472e_8703_685fd6ef976f" VARCHAR  -- {E14EAAE9-3D59-472E-8703-685FD6EF976F},
  "n_39000" BIGINT  -- 39000,
  "n_2004_03_05_00_00" TIMESTAMP  -- 2004-03-05–00:00,
  "wn7_2xt" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_11" VARCHAR  -- 11,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "ludlow_drive" VARCHAR,
  "leigh" VARCHAR,
  "leigh_1" VARCHAR,
  "wigan" VARCHAR,
  "greater_manchester" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2005 (
  "n__53fa8d88_3d60_447d_8889_65b9e3eed1f2" VARCHAR  -- {53FA8D88-3D60-447D-8889-65B9E3EED1F2},
  "n_71000" BIGINT  -- 71000,
  "n_2005_02_25_00_00" TIMESTAMP  -- 2005-02-25–00:00,
  "pe26_1sq" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_24" VARCHAR  -- 24,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "malthouse_lane" VARCHAR,
  "ramsey" VARCHAR,
  "huntingdon" VARCHAR,
  "huntingdonshire" VARCHAR,
  "cambridgeshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2005_part_1 (
  "n__53fa8d88_3d60_447d_8889_65b9e3eed1f2" VARCHAR  -- {53FA8D88-3D60-447D-8889-65B9E3EED1F2},
  "n_71000" BIGINT  -- 71000,
  "n_2005_02_25_00_00" TIMESTAMP  -- 2005-02-25–00:00,
  "pe26_1sq" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_24" VARCHAR  -- 24,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "malthouse_lane" VARCHAR,
  "ramsey" VARCHAR,
  "huntingdon" VARCHAR,
  "huntingdonshire" VARCHAR,
  "cambridgeshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2005_part_2 (
  "n__cd204894_21b6_40df_8be4_73c1cfcfa672" VARCHAR  -- {CD204894-21B6-40DF-8BE4-73C1CFCFA672},
  "n_249995" BIGINT  -- 249995,
  "n_2005_03_31_00_00" TIMESTAMP  -- 2005-03-31–00:00,
  "bs24_7ad" VARCHAR,
  "d" VARCHAR,
  "y" VARCHAR,
  "f" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "broadway" VARCHAR,
  "locking" VARCHAR,
  "weston_super_mare" VARCHAR,
  "north_somerset" VARCHAR,
  "north_somerset_1" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2006 (
  "n__0dd08181_c406_4124_a414_1a60e653de21" VARCHAR  -- {0DD08181-C406-4124-A414-1A60E653DE21},
  "n_240000" BIGINT  -- 240000,
  "n_2006_02_03_00_00" TIMESTAMP  -- 2006-02-03–00:00,
  "cb21_5ds" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_14" VARCHAR  -- 14,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "oslars_way" VARCHAR,
  "fulbourn" VARCHAR,
  "cambridge" VARCHAR,
  "south_cambridgeshire" VARCHAR,
  "cambridgeshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2006_part_1 (
  "n__0dd08181_c406_4124_a414_1a60e653de21" VARCHAR  -- {0DD08181-C406-4124-A414-1A60E653DE21},
  "n_240000" BIGINT  -- 240000,
  "n_2006_02_03_00_00" TIMESTAMP  -- 2006-02-03–00:00,
  "cb21_5ds" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_14" VARCHAR  -- 14,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "oslars_way" VARCHAR,
  "fulbourn" VARCHAR,
  "cambridge" VARCHAR,
  "south_cambridgeshire" VARCHAR,
  "cambridgeshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2006_part_2 (
  "n__b99d3151_cb6a_483c_bc6a_78fd6226ea0e" VARCHAR  -- {B99D3151-CB6A-483C-BC6A-78FD6226EA0E},
  "n_499950" BIGINT  -- 499950,
  "n_2006_12_18_00_00" TIMESTAMP  -- 2006-12-18–00:00,
  "rg8_8ap" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "belleisle" VARCHAR,
  "purley_on_thames" VARCHAR,
  "reading" VARCHAR,
  "west_berkshire" VARCHAR,
  "west_berkshire_1" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2007 (
  "n__a71e482d_8891_465b_8cb1_c73c30657400" VARCHAR  -- {A71E482D-8891-465B-8CB1-C73C30657400},
  "n_230000" BIGINT  -- 230000,
  "n_2007_07_03_00_00" TIMESTAMP  -- 2007-07-03–00:00,
  "sk12_1yw" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "l" VARCHAR,
  "n_7" VARCHAR  -- 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "graymarsh_drive" VARCHAR,
  "poynton" VARCHAR,
  "stockport" VARCHAR,
  "macclesfield" VARCHAR,
  "cheshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2007_part_1 (
  "n__a71e482d_8891_465b_8cb1_c73c30657400" VARCHAR  -- {A71E482D-8891-465B-8CB1-C73C30657400},
  "n_230000" BIGINT  -- 230000,
  "n_2007_07_03_00_00" TIMESTAMP  -- 2007-07-03–00:00,
  "sk12_1yw" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "l" VARCHAR,
  "n_7" VARCHAR  -- 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "graymarsh_drive" VARCHAR,
  "poynton" VARCHAR,
  "stockport" VARCHAR,
  "macclesfield" VARCHAR,
  "cheshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2007_part_2 (
  "n__5cf373e1_e2a0_478f_bf3f_a8a4adc8e727" VARCHAR  -- {5CF373E1-E2A0-478F-BF3F-A8A4ADC8E727},
  "n_450000" BIGINT  -- 450000,
  "n_2007_10_12_00_00" TIMESTAMP  -- 2007-10-12–00:00,
  "de72_3eg" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_1" VARCHAR  -- 1,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "firfield_avenue" VARCHAR,
  "breaston" VARCHAR,
  "derby" VARCHAR,
  "erewash" VARCHAR,
  "derbyshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2008 (
  "n__a9ba8f0b_89d8_461c_88ec_23e281cfcd32" VARCHAR  -- {A9BA8F0B-89D8-461C-88EC-23E281CFCD32},
  "n_220000" BIGINT  -- 220000,
  "n_2008_01_22_00_00" TIMESTAMP  -- 2008-01-22–00:00,
  "so32_1gl" VARCHAR,
  "s" VARCHAR,
  "y" VARCHAR,
  "f" VARCHAR,
  "n_16" VARCHAR  -- 16,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "the_orchard" VARCHAR,
  "bishops_waltham" VARCHAR,
  "southampton" VARCHAR,
  "winchester" VARCHAR,
  "hampshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2008_part_1 (
  "n__a9ba8f0b_89d8_461c_88ec_23e281cfcd32" VARCHAR  -- {A9BA8F0B-89D8-461C-88EC-23E281CFCD32},
  "n_220000" BIGINT  -- 220000,
  "n_2008_01_22_00_00" TIMESTAMP  -- 2008-01-22–00:00,
  "so32_1gl" VARCHAR,
  "s" VARCHAR,
  "y" VARCHAR,
  "f" VARCHAR,
  "n_16" VARCHAR  -- 16,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "the_orchard" VARCHAR,
  "bishops_waltham" VARCHAR,
  "southampton" VARCHAR,
  "winchester" VARCHAR,
  "hampshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2008_part_2 (
  "n__567a0a45_5d63_4c73_87f7_2a7db4a3d9f8" VARCHAR  -- {567A0A45-5D63-4C73-87F7-2A7DB4A3D9F8},
  "n_307500" BIGINT  -- 307500,
  "n_2008_05_22_00_00" TIMESTAMP  -- 2008-05-22–00:00,
  "tn12_9eq" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_8" VARCHAR  -- 8,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "lime_close" VARCHAR,
  "marden" VARCHAR,
  "tonbridge" VARCHAR,
  "maidstone" VARCHAR,
  "kent" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2009 (
  "n__611e8fa7_15c1_47a0_a7e3_d257361f2c6d" VARCHAR  -- {611E8FA7-15C1-47A0-A7E3-D257361F2C6D},
  "n_227000" BIGINT  -- 227000,
  "n_2009_08_24_00_00" TIMESTAMP  -- 2009-08-24–00:00,
  "se25_4dz" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_64" VARCHAR  -- 64,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "warminster_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "london" VARCHAR,
  "croydon" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2009_part_1 (
  "n__611e8fa7_15c1_47a0_a7e3_d257361f2c6d" VARCHAR  -- {611E8FA7-15C1-47A0-A7E3-D257361F2C6D},
  "n_227000" BIGINT  -- 227000,
  "n_2009_08_24_00_00" TIMESTAMP  -- 2009-08-24–00:00,
  "se25_4dz" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_64" VARCHAR  -- 64,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "warminster_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "london" VARCHAR,
  "croydon" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2009_part_2 (
  "n__0fa7bebc_b18f_4276_81b9_6286b4e91500" VARCHAR  -- {0FA7BEBC-B18F-4276-81B9-6286B4E91500},
  "n_310000" BIGINT  -- 310000,
  "n_2009_03_27_00_00" TIMESTAMP  -- 2009-03-27–00:00,
  "ha7_1ja" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_58" VARCHAR  -- 58,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "lyon_meade" VARCHAR,
  "stanmore" VARCHAR,
  "stanmore_1" VARCHAR,
  "harrow" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2010 (
  "n__cb83b524_4ac4_43f6_91a6_b1f8f9c6eb78" VARCHAR  -- {CB83B524-4AC4-43F6-91A6-B1F8F9C6EB78},
  "n_180000" BIGINT  -- 180000,
  "n_2010_09_23_00_00" TIMESTAMP  -- 2010-09-23–00:00,
  "co16_8fb" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_17" VARCHAR  -- 17,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "reigate_avenue" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "clacton_on_sea" VARCHAR,
  "tendring" VARCHAR,
  "essex" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2010_part_1 (
  "n__cb83b524_4ac4_43f6_91a6_b1f8f9c6eb78" VARCHAR  -- {CB83B524-4AC4-43F6-91A6-B1F8F9C6EB78},
  "n_180000" BIGINT  -- 180000,
  "n_2010_09_23_00_00" TIMESTAMP  -- 2010-09-23–00:00,
  "co16_8fb" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_17" VARCHAR  -- 17,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "reigate_avenue" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "clacton_on_sea" VARCHAR,
  "tendring" VARCHAR,
  "essex" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2010_part_2 (
  "n__a19b8e33_373a_444c_940e_ec332ccc40e3" VARCHAR  -- {A19B8E33-373A-444C-940E-EC332CCC40E3},
  "n_242000" BIGINT  -- 242000,
  "n_2010_01_15_00_00" TIMESTAMP  -- 2010-01-15–00:00,
  "se6_2ln" VARCHAR,
  "f" VARCHAR,
  "n" VARCHAR,
  "l" VARCHAR,
  "n_38b" VARCHAR  -- 38B,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "bargery_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "london" VARCHAR,
  "lewisham" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2011 (
  "n__d707e534_cf06_0ad9_e053_6b04a8c067cc" VARCHAR  -- {D707E534-CF06-0AD9-E053-6B04A8C067CC},
  "n_132000" BIGINT  -- 132000,
  "n_2011_10_25_00_00" TIMESTAMP  -- 2011-10-25–00:00,
  "mk13_8bj" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_40" VARCHAR  -- 40,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "arbrook_avenue" VARCHAR,
  "bradwell_common" VARCHAR,
  "milton_keynes" VARCHAR,
  "milton_keynes_1" VARCHAR,
  "milton_keynes_2" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2011_part_1 (
  "n__d707e534_cf06_0ad9_e053_6b04a8c067cc" VARCHAR  -- {D707E534-CF06-0AD9-E053-6B04A8C067CC},
  "n_132000" BIGINT  -- 132000,
  "n_2011_10_25_00_00" TIMESTAMP  -- 2011-10-25–00:00,
  "mk13_8bj" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_40" VARCHAR  -- 40,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "arbrook_avenue" VARCHAR,
  "bradwell_common" VARCHAR,
  "milton_keynes" VARCHAR,
  "milton_keynes_1" VARCHAR,
  "milton_keynes_2" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);