The following datasets provide fabricated information for the fictional hospital Alliance Regional Medical Center (armc). All identifying information (e.g., id’s, names, dates, addresses, occupations, etc.) were randomly created. Disease and medication assignments follow distributions and patterns identified in multiple healthcare datasets to which the authors have access. Errors and outliers have been introduced to simulate those found in real healthcare environments (e.g., missing and unreasonable values).
The data comes in ten varieties and is compatible with many database management systems (DBMS). In line with the DBMS recommendations from Hylock and Harris (2016), PostgreSQL and MySQL are specifically supported with schema backup files and data exports respectively. For all other DBMS’s the creation and insertion commands are also available. Note: modification might be required depending on the DBMS. Specifics regarding the schema and sizes can be found in “Appendix.pdf” below.
Download the data sets
There are four files available for download. To download the zip files, select the link, then in the upper right-hand corner of Google Drive, select download.
- Appendix.pdf — Detailed documentation (Electronic Appendix to the submitted article).
- MySQL_schema_dumps.zip (491 MB) — MySQL data exports.
- PostgreSQL_schema_backups.zip (655 MB) — PostgreSQL schema backups.
- SQL_statements.zip (649 MB) — Generic SQL statements for creating and populating the databases manually. These may require modification to conform to the chosen DBMS’s standards.
Contributors
Publication: Hylock, R., Harris, S.T., (2017). Healthcare Database Management for Health Informatics and Information Management Students: Challenges and Instruction Strategies—Part 2. Educational Perspectives in Health Information Management.
Project lead: Ray Hylock