# 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`


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.finngen.fi/finngen-data-specifics/finnish-health-registers-and-medical-coding/where-to-find-the-translation-file-for-phenotype-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.