No description, website, or topics provided.
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
README.md
landregistry.csv.zip
load.sql
summary.sql.gz

README.md

The UK land registry paid dataset

This sql script will allow you to import the UK land registry paid dataset into MySQL. The dataset can be found at https://data.gov.uk/dataset/land-registry-monthly-price-paid-data

It will create the right table and load the csv files for you into that table - assuming the csv files can be found in /tmp on your server. The load.sql script will also create a summary table for you based on the first part of the postcode, year and month.

Reporting and Analytics

If you do not wish to download the entire dataset, I have placed a summary.sql.gz file for that summary table. I have also placed a CSV file of the summary table for excel users.

This summary table, CSV file and load.sql script are correct as of May 2016.