> For the complete documentation index, see [llms.txt](https://docs.finngen.fi/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.finngen.fi/finngen-data-specifics/finnish-health-registers-and-medical-coding/where-to-find-the-translation-file-for-phenotype-data.md).

# Register code translation files

Code definitions of each code set and their translations in english can be found from the Members area [here](https://www.finngen.fi/en/members/document/293) and from the Sandbox (paths below):

## Medcode\_reference:

**Diagnoses and procedure codes (as well as KELA codes) in Sandbox:**

**FinnGen R9:**

`/finngen/library-green/finngen_R9/finngen_R9_medical_codes/finngen_R9_medcode_ref.tsv`

`/finngen/library-green/finngen_R9/finngen_R9_medical_codes/finngen_R9_medcode_ref_readme.txt`

**FinnGen R6:**

`/finngen/library-green/finngen_R6/finngen_R6_medical_codes/finngen_R6_medcode_ref.tsv`

`/finngen/library-green/finngen_R6/finngen_R6_medical_codes/finngen_R6_medcode_ref_readme.txt`

**Diagnoses and procedure codes (as well as KELA codes) in google cloud:**

**FinnGen R9:**

`gs://finngen-production-library-green/finngen_R9/finngen_R9_medical_codes/finngen_R9_medcode_ref.tsv`

`gs://finngen-production-library-green/finngen_R9/finngen_R9_medical_codes/finngen_R9_medcode_ref_readme.txt`

**FinnGen R6:**

`gs://finngen-production-library-green/finngen_R6/finngen_R6_medical_codes/finngen_R6_medcode_ref.tsv`

`gs://finngen-production-library-green/finngen_R6/finngen_R6_medical_codes/finngen_R6_medcode_ref_readme.txt`

## Drugcode\_reference:

**ATC codes in Sandbox:**

`/finngen/library-green/finngen_R6/finngen_R6_medical_codes/ATC_translate_minimal.txt`

`/finngen/library-green/finngen_R6/finngen_R6_medical_codes/ATC_translate_minimal.txt.READ`

**ATC codes in google cloud:**

`gs://finngen-production-library-green/finngen_R6/finngen_R6_medical_codes/ATC_translate_minimal.txt`

`gs://finngen-production-library-green/finngen_R6/finngen_R6_medical_codes/ATC_translate_minimal.txt.READ`

**VNRO codes in Sandbox:**

`/finngen/library-green/finngen_R6/finngen_R6_medical_codes/finngen_R6_drugcode_ref.tsv`

`/finngen/library-green//finngen_R6/finngen_R6_medical_codes/finngen_R6_drugcode_ref_readme.txt`

**VNRO codes in google cloud:**

`gs://finngen-production-library-green/finngen_R6/finngen_R6_medical_codes/finngen_R6_drugcode_ref.tsv`

`gs://finngen-production-library-green/finngen_R6/finngen_R6_medical_codes/finngen_R6_drugcode_ref_readme.txt`

**FinnGen VNR data in Sandbox:**

FinnGen VNR data provide VNR mapping to RxNorm and between VNR codes and ATC codes, and including dosage, package info, package size, substance name and strength, valid unit value (e.g. "mg"), a factor of the package, calculated total strength of the drug, and commercial name, dosage Form, and Substance Strength of the drug.

Even though VNR data is generated from the codes available on DF6, it can be used for all release data. The VNR codes are available for all data releases.

**VNR codes in Sandbox:**

`/finngen/library-green/finngen_R6/finngen_R6_medical_codes/fgVNR.tsv`

`/finngen/library-green/finngen_R6/finngen_R6_medical_codes/fgVNR_readme.txt`

`/finngen/library-green/finngen_R6/finngen_R6_medical_codes/fgVNR_table_definition.tsv`

**VNR codes in google cloud:**

`gs://finngen-production-library-green/finngen_R6/finngen_R6_medical_codes`