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

EMAIL

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