Baselight

Archived Price Paid Data: 1995 To 2017

HM Land Registry

@ukgov.archived_price_paid_information_residential_property_1995_2017

Loading...
Loading...

About this Dataset

Archived Price Paid Data: 1995 To 2017

HM Land Registry Price Paid Data tracks land and property sales in England and Wales submitted to us for registration.
Publisher name: HM Land Registry
Last updated: 2022-07-01T04:02:41Z

Tables

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

Share link

Anyone who has the link will be able to view this.