TagScript

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...

Download LARS as a .sql file

D

Its a constant challenge to keep many of the systems that I help develop up to date with Government data sources. One of the most awkward is the LARS (Learning Aims Reference Service) database. () It’s updated several times a month, and is only available for download in .mdb, .csv and .psv files – none of which are even remotely useful for integrating with existing databases in a...

Archive

Tags

Get in touch

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