Archived Price Paid Data: 1995 To 2017

CREATE TABLE price_paid_data_2011_part_2 (
  "n__7a755ea4_0ba1_4e81_8665_17c556a791c8" VARCHAR  -- {7A755EA4-0BA1-4E81-8665-17C556A791C8},
  "n_102000" BIGINT  -- 102000,
  "n_2011_06_16_00_00" TIMESTAMP  -- 2011-06-16–00:00,
  "cf5_4hx" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_140" VARCHAR  -- 140,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "grand_avenue" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "cardiff" VARCHAR,
  "cardiff_1" VARCHAR,
  "cardiff_2" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2012 (
  "n__ec048171_ae16_4c22_8fb7_0b9c6ab51871" VARCHAR  -- {EC048171-AE16-4C22-8FB7-0B9C6AB51871},
  "n_150000" BIGINT  -- 150000,
  "n_2012_01_31_00_00" TIMESTAMP  -- 2012-01-31–00:00,
  "me10_5jr" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_11" VARCHAR  -- 11,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "amethyst_drive" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "sittingbourne" VARCHAR,
  "swale" VARCHAR,
  "kent" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2012_part_1 (
  "n__ec048171_ae16_4c22_8fb7_0b9c6ab51871" VARCHAR  -- {EC048171-AE16-4C22-8FB7-0B9C6AB51871},
  "n_150000" BIGINT  -- 150000,
  "n_2012_01_31_00_00" TIMESTAMP  -- 2012-01-31–00:00,
  "me10_5jr" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_11" VARCHAR  -- 11,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "amethyst_drive" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "sittingbourne" VARCHAR,
  "swale" VARCHAR,
  "kent" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2012_part_2 (
  "n__14000a5d_9d46_4065_aee4_b70a26997998" VARCHAR  -- {14000A5D-9D46-4065-AEE4-B70A26997998},
  "n_93995" BIGINT  -- 93995,
  "n_2012_03_30_00_00" TIMESTAMP  -- 2012-03-30–00:00,
  "pe2_5rp" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_99" VARCHAR  -- 99,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "stagsden" VARCHAR,
  "orton_goldhay" VARCHAR,
  "peterborough" VARCHAR,
  "city_of_peterborough" VARCHAR,
  "city_of_peterborough_1" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2013_part_1 (
  "n__03cca900_d6a0_4f45_8926_d0d0c048452b" VARCHAR  -- {03CCA900-D6A0-4F45-8926-D0D0C048452B},
  "n_125000" BIGINT  -- 125000,
  "n_2013_05_03_00_00" TIMESTAMP  -- 2013-05-03–00:00,
  "de11_9tr" VARCHAR,
  "t" VARCHAR,
  "y" VARCHAR,
  "f" VARCHAR,
  "n_26" VARCHAR  -- 26,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "salford_way" VARCHAR,
  "church_gresley" VARCHAR,
  "swadlincote" VARCHAR,
  "south_derbyshire" VARCHAR,
  "derbyshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2013_part_2 (
  "n__8459aeea_f8b4_4bb5_b703_779aafd398f9" VARCHAR  -- {8459AEEA-F8B4-4BB5-B703-779AAFD398F9},
  "n_228000" BIGINT  -- 228000,
  "n_2013_09_30_00_00" TIMESTAMP  -- 2013-09-30–00:00,
  "wr11_1gg" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_3" VARCHAR  -- 3,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "priors_walk" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "evesham" VARCHAR,
  "wychavon" VARCHAR,
  "worcestershire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2014_part_1 (
  "n__298dbe49_1ea5_4c3b_942d_616309851139" VARCHAR  -- {298DBE49-1EA5-4C3B-942D-616309851139},
  "n_225000" BIGINT  -- 225000,
  "n_2014_06_17_00_00" TIMESTAMP  -- 2014-06-17–00:00,
  "al8_6tl" VARCHAR,
  "f" VARCHAR,
  "n" VARCHAR,
  "l" VARCHAR,
  "n_31" VARCHAR  -- 31,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "barnside_court" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "welwyn_garden_city" VARCHAR,
  "welwyn_hatfield" VARCHAR,
  "hertfordshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2014_part_2 (
  "n__a70fb0fd_379c_4737_b0b3_0f2a7f90810d" VARCHAR  -- {A70FB0FD-379C-4737-B0B3-0F2A7F90810D},
  "n_139950" BIGINT  -- 139950,
  "n_2014_04_17_00_00" TIMESTAMP  -- 2014-04-17–00:00,
  "b30_2ur" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_48" VARCHAR  -- 48,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "lockton_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "birmingham" VARCHAR,
  "birmingham_1" VARCHAR,
  "west_midlands" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2015_part_1 (
  "n__f5e8b080_f9b6_3a13_e053_6c04a8c060b7" VARCHAR  -- {F5E8B080-F9B6-3A13-E053-6C04A8C060B7},
  "n_90000" BIGINT  -- 90000,
  "n_2015_05_28_00_00" TIMESTAMP  -- 2015-05-28–00:00,
  "wa4_6fz" VARCHAR,
  "f" VARCHAR,
  "n" VARCHAR,
  "l" VARCHAR,
  "beaumont_court" VARCHAR,
  "apartment_17" VARCHAR,
  "elphins_drive" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "warrington" VARCHAR,
  "warrington_1" VARCHAR,
  "warrington_2" VARCHAR,
  "b" VARCHAR,
  "a" VARCHAR
);

CREATE TABLE price_paid_data_2015_part_2 (
  "n__288dce29_9fd2_e510_e050_a8c06205480e" VARCHAR  -- {288DCE29-9FD2-E510-E050-A8C06205480E},
  "n_365250" BIGINT  -- 365250,
  "n_2015_12_14_00_00" TIMESTAMP  -- 2015-12-14–00:00,
  "se12_9rx" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_37" VARCHAR  -- 37,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "roseveare_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "london" VARCHAR,
  "lewisham" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2016_part_1 (
  "n__31fb4c17_dfca_57b9_e050_a8c063053436" VARCHAR  -- {31FB4C17-DFCA-57B9-E050-A8C063053436},
  "n_522000" BIGINT  -- 522000,
  "n_2016_03_23_00_00" TIMESTAMP  -- 2016-03-23–00:00,
  "tw12_2qs" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_36a" VARCHAR  -- 36A,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "holly_bush_lane" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "hampton" VARCHAR,
  "richmond_upon_thames" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2016_part_2 (
  "n__2d1e4b26_10ac_fcd1_e050_a8c0630544ec" VARCHAR  -- {2D1E4B26-10AC-FCD1-E050-A8C0630544EC},
  "n_525000" BIGINT  -- 525000,
  "n_2016_01_26_00_00" TIMESTAMP  -- 2016-01-26–00:00,
  "tr11_4be" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_16" VARCHAR  -- 16,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "lansdowne_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "falmouth" VARCHAR,
  "cornwall" VARCHAR,
  "cornwall_1" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2017_part_1 (
  "n__50f18103_65be_9fd5_e050_a8c063054923" VARCHAR  -- {50F18103-65BE-9FD5-E050-A8C063054923},
  "n_125000" BIGINT  -- 125000,
  "n_2017_04_06_00_00" TIMESTAMP  -- 2017-04-06–00:00,
  "bd23_2be" VARCHAR,
  "f" VARCHAR,
  "n" VARCHAR,
  "l" VARCHAR,
  "burnside_house" VARCHAR,
  "apartment_22" VARCHAR,
  "carleton_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "skipton" VARCHAR,
  "craven" VARCHAR,
  "north_yorkshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

CREATE TABLE price_paid_data_2017_part_2 (
  "n__4c4edfff_a3ff_1854_e050_a8c063054f34" VARCHAR  -- {4C4EDFFF-A3FF-1854-E050-A8C063054F34},
  "n_1010000" BIGINT  -- 1010000,
  "n_2017_03_02_00_00" TIMESTAMP  -- 2017-03-02–00:00,
  "ha6_3qt" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_45" VARCHAR  -- 45,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "elgood_avenue" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "northwood" VARCHAR,
  "hillingdon" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);