The Netherlands has been the biggest trading market in Europe that PharmaFootpath had yet to include. I'm pleased to share we've now included the centralised product pricing, national product registrations will follow in the near future.
Adding a new country to our data takes some time as we have a number of steps to go through to ensure we have data integrity:
- Agree data source for country (for example, we have an agreement with government in Germany to transfer data every 2 weeks)
- Review data, isolating the data required for our database and identify any gaps
- Translate the various APIs, presentations, routes, weights, and other data
- Restructure data to match our schema
- Run quality checks to ensure compliance with our standards, investigate each failure and resolve
- Import data
This process is time consuming, and filled with complex edge cases, and often the origin data itself has mistakes included that we need to investigate. However, when we finish this, the end result is a well structured database that provides us with a valuable dataset that we can quickly interrogate and find new information.
I'm delighted we're continuing to add to this, and getting closer to our goals!
Phil
(If you've any questions about this, please feel free to message me to learn more!)