Dataset from Zenodo · Patachia, Eduard
EU Medicine Shortage Tracker: MySQL database dump
- License
- CC BY 4.0commercial use allowedLicense text
- This license allows commercial use. Usually you must credit the author; read the license for the exact terms.
- Formats
- MD, SQL
- Size
- 98 kB
- Updated
- Oct 9, 2026
Description
MySQL dump of the database from our KEN2110 Databases group project at Maastricht University (2026). It stores medicine shortages per country, the authority that reported them and the companies involved. Code and documentation: https://github.com/EduardPatachia/Schema-Design-Database-Connection The file medicine shortage tracker.sql creates the medicine shortage tracker database with 12 tables and all their constraints. It has 387 shortages: - 15 made-up shortages from our seed data - 74 from openFDA Drug Shortages (US), feed updated 30/09/2026 - 298 from the French BDPM (ANSM), shortage file updated 28/09/2026 To load it (MySQL 8.0.16 or newer): mysql -u root -p < medicine shortage tracker.sql Data sources: - openFDA (https://open.fda.gov), CC0 1.0. Data provided by the U.S. Food and Drug Administration. - Base de données publique des médicaments (BDPM), ANSM. Shortage file updated 28/09/2026, product and composition files 29/09/2026, ATC file 03/06/2026. Licence Ouverte / Open Licence. There is no personal data in the dump. Shortages are stored per medicine and not per patient, the reported companies are all companies, and the facility names are made up.
Description from Zenodo, shortened.
Files (2)
DataHunter does not store or host these files: every link leads to the original source. Check the license there before using the data.