Dataset de Zenodo · Patachia, Eduard
EU Medicine Shortage Tracker: MySQL database dump
- Licencia
- CC BY 4.0uso comercial permitidoTexto de la licencia
- Esta licencia permite el uso comercial. Normalmente hay que citar al autor; consulta la licencia para ver las condiciones exactas.
- Formatos
- MD, SQL
- Tamaño
- 98 kB
- Actualizado
- 9 oct 2026
Descripción
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.
Descripción de Zenodo, abreviada.
Archivos (2)
DataHunter no guarda ni aloja estos archivos: cada enlace lleva a la fuente original. Revisa allí la licencia antes de usar los datos.