Required Data Format
Overview of Data Formats Used in Diaceutics DALI Platform
This request was made to ensure data consistency both now and moving forward.
MySQL Table Column Labelling and Arrangement Conventions
Country data (ICD-10) files must contain these fields:
|
Field |
|
CASES |
|
CODE |
|
CODE_3 |
|
COUNTRY |
|
REGION |
|
SERIAL |
|
YEAR |
Hospital information files must contain these fields:
|
Field |
|
ADDRESS_1 |
|
ADDRESS_2 |
|
AMMAP_ID |
|
AMMAP_REGION |
|
BEDS |
|
CLIENT_NOTES |
|
COUNTRY |
|
COUNTY |
|
|
|
FAX |
|
LATITUDE |
|
LONGITUDE |
|
HOSPITAL_NAME |
|
OWNERSHIP |
|
POSTCODE |
|
REGION |
|
SERIAL |
|
TELEPHONE |
|
TOWN |
|
TYPE |
|
WEB |
Note! It is okay for for obsolete columns to be blank, we no longer support the use of CLIENT_NOTES, OWNERSHIP or TYPE.
Standardised File Naming
Stick to a standard naming convention:
V stands for version so we will know if there is a newer version of the same file i.e. v_1 vs v_2
•All country data: <country>_all_<YYYY_MM_DD>_v_<n>.csv.gz
○Full refresh per country – include all data for country including new data
•All Hospital data: <country>_hospitals_all_<YYYY_MM_DD>_v_<n>.csv.gz
○Full refresh of hospitals per country – include all data for hospitals including new data
S3 Upload Location Requirements
Save files in specific folder in S3
•Country files to be saved in
s3://dali-transfer-dtr-023-ew1-dxrx-com/europe/
•Hospital files to be saved in
s3://dali-transfer-dtr-023-ew1-dxrx-com/hospitals/
Summary to send full refreshes of the data:
•Diag_all datasets for Germany, France, Spain, Italy and UK
1.Each country table should include data from all available time ranges (i.e. from 2017/2018 – 2023 inclusive)
2.Each country table should include 7 data fields as specified in this document
3.Each country table should be dropped in the Europe folder on S3 as specified in this document
4.Each country table should include ICD10s exclusively
5.Each country table should follow the “All country data” naming convention: <country>_all_<YYYY_MM_DD>_v_<n>.csv.gz
•Hospital datasets for Germany, France, Spain, Italy and UK
1.Each hospital table should include all serial numbers present in the country table so that we have a hospital match for each
2.Each hospital table should be dropped in the hospitals folder on S3 as specified in this document
3.Each hospital table should include 21 data fields as specified in this document
4.Each hospital table should follow the “All Hospital data” naming convention: <country>_hospitals_all_<YYYY_MM_DD>_v_<n>.csv.gz
Topic last reviewed: 23/07/25