Price Paid Data: 1995

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1995

49.85 MB
797,046 rows
16 columns

CREATE TABLE price_paid_data_1995 (
  "n__7130f2c1_b3e4_41a5_9103_3dc40a6a5466" VARCHAR  -- {7130F2C1-B3E4-41A5-9103-3DC40A6A5466},
  "n_166500" BIGINT  -- 166500,
  "n_1995_11_22_00_00" TIMESTAMP  -- 1995-11-22–00:00,
  "cm23_4pa" VARCHAR,
  "d" VARCHAR,
  "y" VARCHAR,
  "f" VARCHAR,
  "n_19" VARCHAR  -- 19,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "mayflower_gardens" VARCHAR,
  "bishop_s_stortford" VARCHAR,
  "bishop_s_stortford_1" VARCHAR,
  "east_hertfordshire" VARCHAR,
  "hertfordshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1995 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1995_part_1

25.35 MB
398,522 rows
16 columns

CREATE TABLE price_paid_data_1995_part_1 (
  "n__7130f2c1_b3e4_41a5_9103_3dc40a6a5466" VARCHAR  -- {7130F2C1-B3E4-41A5-9103-3DC40A6A5466},
  "n_166500" BIGINT  -- 166500,
  "n_1995_11_22_00_00" TIMESTAMP  -- 1995-11-22–00:00,
  "cm23_4pa" VARCHAR,
  "d" VARCHAR,
  "y" VARCHAR,
  "f" VARCHAR,
  "n_19" VARCHAR  -- 19,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "mayflower_gardens" VARCHAR,
  "bishop_s_stortford" VARCHAR,
  "bishop_s_stortford_1" VARCHAR,
  "east_hertfordshire" VARCHAR,
  "hertfordshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1995 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1995_part_2

24.51 MB
398,523 rows
16 columns

CREATE TABLE price_paid_data_1995_part_2 (
  "n__9553294a_86c1_43aa_95ac_216df92ceb25" VARCHAR  -- {9553294A-86C1-43AA-95AC-216DF92CEB25},
  "n_51000" BIGINT  -- 51000,
  "n_1995_12_12_00_00" TIMESTAMP  -- 1995-12-12–00:00,
  "gl2_0dn" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_39" VARCHAR  -- 39,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "brooklands_park" VARCHAR,
  "longlevens" VARCHAR,
  "gloucester" VARCHAR,
  "gloucester_1" VARCHAR,
  "gloucestershire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1996

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1996

60.61 MB
965,287 rows
16 columns

CREATE TABLE price_paid_data_1996 (
  "n__74270ca9_314b_4628_acfd_c4bd5ee3d157" VARCHAR  -- {74270CA9-314B-4628-ACFD-C4BD5EE3D157},
  "n_39500" BIGINT  -- 39500,
  "n_1996_04_19_00_00" TIMESTAMP  -- 1996-04-19–00:00,
  "sa7_9tt" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_165" VARCHAR  -- 165,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "frederick_place" VARCHAR,
  "llansamlet" VARCHAR,
  "swansea" VARCHAR,
  "swansea_1" VARCHAR,
  "swansea_2" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1996 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1996_part_1

30.44 MB
482,643 rows
16 columns

CREATE TABLE price_paid_data_1996_part_1 (
  "n__74270ca9_314b_4628_acfd_c4bd5ee3d157" VARCHAR  -- {74270CA9-314B-4628-ACFD-C4BD5EE3D157},
  "n_39500" BIGINT  -- 39500,
  "n_1996_04_19_00_00" TIMESTAMP  -- 1996-04-19–00:00,
  "sa7_9tt" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_165" VARCHAR  -- 165,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "frederick_place" VARCHAR,
  "llansamlet" VARCHAR,
  "swansea" VARCHAR,
  "swansea_1" VARCHAR,
  "swansea_2" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1996 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1996_part_2

30.23 MB
482,643 rows
16 columns

CREATE TABLE price_paid_data_1996_part_2 (
  "n__24930a89_933e_4aae_94b0_bd980f0fbf91" VARCHAR  -- {24930A89-933E-4AAE-94B0-BD980F0FBF91},
  "n_45500" BIGINT  -- 45500,
  "n_1996_09_03_00_00" TIMESTAMP  -- 1996-09-03–00:00,
  "ip28_8qd" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_3" VARCHAR  -- 3,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "stirling_close" VARCHAR,
  "west_row" VARCHAR,
  "bury_st_edmunds" VARCHAR,
  "forest_heath" VARCHAR,
  "suffolk" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1997

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1997

68.87 MB
1,094,506 rows
16 columns

CREATE TABLE price_paid_data_1997 (
  "n__2acace8c_8fd9_295e_e063_4804a8c0b0eb" VARCHAR  -- {2ACACE8C-8FD9-295E-E063-4804A8C0B0EB},
  "n_185000" BIGINT  -- 185000,
  "n_1997_11_05_00_00" TIMESTAMP  -- 1997-11-05–00:00,
  "sw6_2lb" VARCHAR,
  "f" VARCHAR,
  "y" VARCHAR,
  "l" VARCHAR,
  "n_104a" VARCHAR  -- 104A,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "broughton_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "london" VARCHAR,
  "hammersmith_and_fulham" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1997 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1997_part_1

34.68 MB
547,252 rows
16 columns

CREATE TABLE price_paid_data_1997_part_1 (
  "n__2acace8c_8fd9_295e_e063_4804a8c0b0eb" VARCHAR  -- {2ACACE8C-8FD9-295E-E063-4804A8C0B0EB},
  "n_185000" BIGINT  -- 185000,
  "n_1997_11_05_00_00" TIMESTAMP  -- 1997-11-05–00:00,
  "sw6_2lb" VARCHAR,
  "f" VARCHAR,
  "y" VARCHAR,
  "l" VARCHAR,
  "n_104a" VARCHAR  -- 104A,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "broughton_road" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "london" VARCHAR,
  "hammersmith_and_fulham" VARCHAR,
  "greater_london" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1997 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1997_part_2

34.39 MB
547,253 rows
16 columns

CREATE TABLE price_paid_data_1997_part_2 (
  "n__5d2515b0_0bfb_475f_b241_b698540163d0" VARCHAR  -- {5D2515B0-0BFB-475F-B241-B698540163D0},
  "n_36250" BIGINT  -- 36250,
  "n_1997_08_15_00_00" TIMESTAMP  -- 1997-08-15–00:00,
  "cw2_7pj" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_93" VARCHAR  -- 93,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "gainsborough_road" VARCHAR,
  "crewe" VARCHAR,
  "crewe_1" VARCHAR,
  "crewe_and_nantwich" VARCHAR,
  "cheshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1998

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1998

66.43 MB
1,050,552 rows
16 columns

CREATE TABLE price_paid_data_1998 (
  "n__c0af0316_a220_45c2_8b56_8a710c27925d" VARCHAR  -- {C0AF0316-A220-45C2-8B56-8A710C27925D},
  "n_53000" BIGINT  -- 53000,
  "n_1998_01_09_00_00" TIMESTAMP  -- 1998-01-09–00:00,
  "wa5_3py" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_14" VARCHAR  -- 14,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "leamington_close" VARCHAR,
  "great_sankey" VARCHAR,
  "warrington" VARCHAR,
  "warrington_1" VARCHAR,
  "warrington_2" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1998 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1998_part_1

33.41 MB
525,275 rows
16 columns

CREATE TABLE price_paid_data_1998_part_1 (
  "n__c0af0316_a220_45c2_8b56_8a710c27925d" VARCHAR  -- {C0AF0316-A220-45C2-8B56-8A710C27925D},
  "n_53000" BIGINT  -- 53000,
  "n_1998_01_09_00_00" TIMESTAMP  -- 1998-01-09–00:00,
  "wa5_3py" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_14" VARCHAR  -- 14,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "leamington_close" VARCHAR,
  "great_sankey" VARCHAR,
  "warrington" VARCHAR,
  "warrington_1" VARCHAR,
  "warrington_2" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1998 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1998_part_2

33.19 MB
525,276 rows
16 columns

CREATE TABLE price_paid_data_1998_part_2 (
  "n__53d31c9c_65e5_424b_9ede_5df83f21ff9d" VARCHAR  -- {53D31C9C-65E5-424B-9EDE-5DF83F21FF9D},
  "n_50950" BIGINT  -- 50950,
  "n_1998_08_21_00_00" TIMESTAMP  -- 1998-08-21–00:00,
  "tf1_3ge" VARCHAR,
  "s" VARCHAR,
  "y" VARCHAR,
  "f" VARCHAR,
  "n_8" VARCHAR  -- 8,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "st_catherines_close" VARCHAR,
  "wellington" VARCHAR,
  "telford" VARCHAR,
  "wrekin" VARCHAR,
  "wrekin_1" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1999

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1999

75.01 MB
1,194,931 rows
16 columns

CREATE TABLE price_paid_data_1999 (
  "n__3426b8e4_6e56_4976_8210_d2981ca53d93" VARCHAR  -- {3426B8E4-6E56-4976-8210-D2981CA53D93},
  "n_51000" BIGINT  -- 51000,
  "n_1999_12_30_00_00" TIMESTAMP  -- 1999-12-30–00:00,
  "ol14_5hs" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_30" VARCHAR  -- 30,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "byrom_street" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "todmorden" VARCHAR,
  "calderdale" VARCHAR,
  "west_yorkshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1999 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1999_part_1

37.4 MB
597,465 rows
16 columns

CREATE TABLE price_paid_data_1999_part_1 (
  "n__3426b8e4_6e56_4976_8210_d2981ca53d93" VARCHAR  -- {3426B8E4-6E56-4976-8210-D2981CA53D93},
  "n_51000" BIGINT  -- 51000,
  "n_1999_12_30_00_00" TIMESTAMP  -- 1999-12-30–00:00,
  "ol14_5hs" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_30" VARCHAR  -- 30,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "byrom_street" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "todmorden" VARCHAR,
  "calderdale" VARCHAR,
  "west_yorkshire" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 1999 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_1999_part_2

37.61 MB
597,465 rows
16 columns

CREATE TABLE price_paid_data_1999_part_2 (
  "n__fd735ce1_7798_4455_b312_995a5c07f2ae" VARCHAR  -- {FD735CE1-7798-4455-B312-995A5C07F2AE},
  "n_32000" BIGINT  -- 32000,
  "n_1999_04_30_00_00" TIMESTAMP  -- 1999-04-30–00:00,
  "pe30_4by" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_3" VARCHAR  -- 3,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "queen_elizabeth_avenue" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "king_s_lynn" VARCHAR,
  "king_s_lynn_and_west_norfolk" VARCHAR,
  "norfolk" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2000

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2000

71.16 MB
1,129,418 rows
16 columns

CREATE TABLE price_paid_data_2000 (
  "n__3db2b825_6d7e_46fb_8e6d_6b285c3f8476" VARCHAR  -- {3DB2B825-6D7E-46FB-8E6D-6B285C3F8476},
  "n_71000" BIGINT  -- 71000,
  "n_2000_08_01_00_00" TIMESTAMP  -- 2000-08-01–00:00,
  "cv6_7nu" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_11" VARCHAR  -- 11,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "portwrinkle_avenue" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "coventry" VARCHAR,
  "coventry_1" VARCHAR,
  "west_midlands" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2000 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2000_part_1

35.42 MB
564,708 rows
16 columns

CREATE TABLE price_paid_data_2000_part_1 (
  "n__3db2b825_6d7e_46fb_8e6d_6b285c3f8476" VARCHAR  -- {3DB2B825-6D7E-46FB-8E6D-6B285C3F8476},
  "n_71000" BIGINT  -- 71000,
  "n_2000_08_01_00_00" TIMESTAMP  -- 2000-08-01–00:00,
  "cv6_7nu" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_11" VARCHAR  -- 11,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "portwrinkle_avenue" VARCHAR,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "coventry" VARCHAR,
  "coventry_1" VARCHAR,
  "west_midlands" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2000 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2000_part_2

35.82 MB
564,709 rows
16 columns

CREATE TABLE price_paid_data_2000_part_2 (
  "n__e643f30d_7cdf_4e48_8368_e69f40a5f48d" VARCHAR  -- {E643F30D-7CDF-4E48-8368-E69F40A5F48D},
  "n_89000" BIGINT  -- 89000,
  "n_2000_04_07_00_00" TIMESTAMP  -- 2000-04-07–00:00,
  "tn25_6pb" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_3" VARCHAR  -- 3,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "glebelands" VARCHAR,
  "mersham" VARCHAR,
  "ashford" VARCHAR,
  "ashford_1" VARCHAR,
  "kent" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2001

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2001

79.36 MB
1,245,887 rows
16 columns

CREATE TABLE price_paid_data_2001 (
  "n__fe86600e_2496_4a19_9fdc_c6ec03f9f01b" VARCHAR  -- {FE86600E-2496-4A19-9FDC-C6EC03F9F01B},
  "n_41000" BIGINT  -- 41000,
  "n_2001_12_10_00_00" TIMESTAMP  -- 2001-12-10–00:00,
  "cf41_7ap" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_16" VARCHAR  -- 16,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "victoria_street" VARCHAR,
  "ton_pentre" VARCHAR,
  "pentre" VARCHAR,
  "rhondda_cynon_taff" VARCHAR,
  "rhondda_cynon_taff_1" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2001 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2001_part_1

39.79 MB
622,943 rows
16 columns

CREATE TABLE price_paid_data_2001_part_1 (
  "n__fe86600e_2496_4a19_9fdc_c6ec03f9f01b" VARCHAR  -- {FE86600E-2496-4A19-9FDC-C6EC03F9F01B},
  "n_41000" BIGINT  -- 41000,
  "n_2001_12_10_00_00" TIMESTAMP  -- 2001-12-10–00:00,
  "cf41_7ap" VARCHAR,
  "t" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_16" VARCHAR  -- 16,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "victoria_street" VARCHAR,
  "ton_pentre" VARCHAR,
  "pentre" VARCHAR,
  "rhondda_cynon_taff" VARCHAR,
  "rhondda_cynon_taff_1" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2001 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2001_part_2

39.72 MB
622,943 rows
16 columns

CREATE TABLE price_paid_data_2001_part_2 (
  "n__6b7359db_2b19_492c_9260_f76846145a27" VARCHAR  -- {6B7359DB-2B19-492C-9260-F76846145A27},
  "n_123500" BIGINT  -- 123500,
  "n_2001_01_05_00_00" TIMESTAMP  -- 2001-01-05–00:00,
  "ex15_2pl" VARCHAR,
  "d" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "verdant" VARCHAR,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "gables_road" VARCHAR,
  "willand" VARCHAR,
  "cullompton" VARCHAR,
  "mid_devon" VARCHAR,
  "devon" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2002

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2002

86.29 MB
1,351,813 rows
16 columns

CREATE TABLE price_paid_data_2002 (
  "n__e2d012d8_1b73_40a6_bfd4_b0c1941560a3" VARCHAR  -- {E2D012D8-1B73-40A6-BFD4-B0C1941560A3},
  "n_127500" BIGINT  -- 127500,
  "n_2002_11_19_00_00" TIMESTAMP  -- 2002-11-19–00:00,
  "ta19_0qu" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "north_cottage_2" VARCHAR  -- NORTH COTTAGE, 2,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "west_street" VARCHAR,
  "seavington" VARCHAR,
  "ilminster" VARCHAR,
  "south_somerset" VARCHAR,
  "somerset" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2002 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2002_part_1

43.13 MB
675,906 rows
16 columns

CREATE TABLE price_paid_data_2002_part_1 (
  "n__e2d012d8_1b73_40a6_bfd4_b0c1941560a3" VARCHAR  -- {E2D012D8-1B73-40A6-BFD4-B0C1941560A3},
  "n_127500" BIGINT  -- 127500,
  "n_2002_11_19_00_00" TIMESTAMP  -- 2002-11-19–00:00,
  "ta19_0qu" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "north_cottage_2" VARCHAR  -- NORTH COTTAGE, 2,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "west_street" VARCHAR,
  "seavington" VARCHAR,
  "ilminster" VARCHAR,
  "south_somerset" VARCHAR,
  "somerset" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2002 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2002_part_2

43.21 MB
675,906 rows
16 columns

CREATE TABLE price_paid_data_2002_part_2 (
  "n__58e18387_f7d7_406a_a867_c1ed8f2726a7" VARCHAR  -- {58E18387-F7D7-406A-A867-C1ED8F2726A7},
  "n_96000" BIGINT  -- 96000,
  "n_2002_09_20_00_00" TIMESTAMP  -- 2002-09-20–00:00,
  "nr12_0sl" VARCHAR,
  "s" VARCHAR,
  "n" VARCHAR,
  "f" VARCHAR,
  "n_2" VARCHAR  -- 2,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "beach_road" VARCHAR,
  "eccles_on_sea" VARCHAR,
  "norwich" VARCHAR,
  "north_norfolk" VARCHAR,
  "norfolk" VARCHAR,
  "a" VARCHAR,
  "a_1" VARCHAR
);

Price Paid Data: 2003

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2003

78.94 MB
1,235,504 rows
16 columns

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

Price Paid Data: 2003 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2003_part_1

39.67 MB
617,751 rows
16 columns

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
);

Price Paid Data: 2003 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2003_part_2

39.38 MB
617,752 rows
16 columns

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
);

Price Paid Data: 2004

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2004

78.85 MB
1,231,999 rows
16 columns

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
);

Price Paid Data: 2004 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2004_part_1

39.31 MB
615,999 rows
16 columns

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
);

Price Paid Data: 2004 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2004_part_2

39.61 MB
615,999 rows
16 columns

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
);

Price Paid Data: 2005

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2005

68.03 MB
1,061,452 rows
16 columns

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
);

Price Paid Data: 2005 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2005_part_1

34.11 MB
530,725 rows
16 columns

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
);

Price Paid Data: 2005 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2005_part_2

34.08 MB
530,726 rows
16 columns

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
);

Price Paid Data: 2006

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2006

85.16 MB
1,326,111 rows
16 columns

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
);

Price Paid Data: 2006 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2006_part_1

42.75 MB
663,055 rows
16 columns

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
);

Price Paid Data: 2006 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2006_part_2

42.48 MB
663,055 rows
16 columns

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
);

Price Paid Data: 2007

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2007

81.74 MB
1,272,360 rows
16 columns

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
);

Price Paid Data: 2007 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2007_part_1

41.01 MB
636,179 rows
16 columns

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
);

Price Paid Data: 2007 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2007_part_2

40.94 MB
636,180 rows
16 columns

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
);

Price Paid Data: 2008

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2008

41.83 MB
649,652 rows
16 columns

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
);

Price Paid Data: 2008 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2008_part_1

21.11 MB
324,825 rows
16 columns

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
);

Price Paid Data: 2008 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2008_part_2

20.89 MB
324,826 rows
16 columns

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
);

Price Paid Data: 2009

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2009

40.12 MB
625,310 rows
16 columns

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
);

Price Paid Data: 2009 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2009_part_1

20.07 MB
312,654 rows
16 columns

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
);

Price Paid Data: 2009 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2009_part_2

20.09 MB
312,655 rows
16 columns

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
);

Price Paid Data: 2010

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2010

42.48 MB
663,292 rows
16 columns

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
);

Price Paid Data: 2010 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2010_part_1

21.28 MB
331,645 rows
16 columns

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
);

Price Paid Data: 2010 Part 2

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2010_part_2

21.36 MB
331,646 rows
16 columns

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
);

Price Paid Data: 2011

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2011

42.32 MB
661,208 rows
16 columns

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
);

Price Paid Data: 2011 Part 1

@ukgov.archived_price_paid_information_residential_property_1995_2017.price_paid_data_2011_part_1

21.17 MB
330,603 rows
16 columns

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
);

Tables