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.
