RMTWeb

View Original

GP Practices List in MySQL for The United Kingdom

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.