In our quest to make lookups easier and faster for customers we sometimes take the time to collate open government data sources that are in horrible Excel/CSV/MDB/Text files with differing columns into a single standardised MySQL database table. GP Practices was one such mess of OpenGov Data.

The GPPractices-2020-06-02.sql file contains the following numbers of GP Practice details:

England - 9098
Northern Ireland - 327
Scotland - 921
Wales - 241

It creates a table called GPPractices and inserts the data.

Feedback appreciated as always, and if you use this in a project please do let me know, its always wonderful to know where it has been successfully useful.