GP Practices List in MySQL for The United Kingdom

G

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.

Add Comment

Leave a Reply

By RMTWeb

Archive

Tags

Get in touch

I'm available on just about every social media platform out there as RMTWeb.