> 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/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/other-registers/finnish-national-diabetes-register.md).

# Finnish National Diabetes Register

### Sandbox directory

The data is available in the following Sandbox directory:

`/finngen/library-red/finngen_R[RELEASE]/diabetes_register_1.0`

Please refer to the readme file in the sandbox directory for full details of the available data.

### Description

The aim of the national diabetes register is to monitor and help improve the quality and effectiveness of diabetes care throughout Finland. The diabetes register tracks follow-up and treatment across the entire care pathway. The register collects data from primary care and specialized healthcare, as well as from both public and private healthcare services.

The diabetes register dataset consists of two parts: laboratory measurement data and patient data. The data was released to the Sandbox first time in release 14 (R14).

#### Laboratory measurement data

Lab data covers measurement values for people with diabetes from four different tests: AlbKre, GFR, HbA1c, and LDL. Data is available since 2018.

The laboratory measurement data contains information about:

* Type of the measurement (AlbKre, GFR, HbA1c, LDL)
* Value of the measurement
* Is value of the measurement outlier

| VARIABLE     | DESCRIPTION                                                                    | VALUES                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               |
| ------------ | ------------------------------------------------------------------------------ | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| FINNGENID    | Studyid                                                                        |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| APPROX\_DATE | **Randomized measurement date** (randomized +/- 1-15 days from the exact date) |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| TIME         | **Measurement time** (HH:MM)                                                   |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| EVENT\_AGE   | **Age at the time of measurement**                                             |                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      |
| LABA         | <p><strong>Type of the measurement:</strong><br></p>                           | <p><strong>HbA1c</strong> The value of the HbA1c laboratory measurement. Covers values from both venous and capillary samples.<br><strong>LDL</strong> The value of the LDL cholesterol laboratory measurement. Covers values from both fasting and non-fasting serum and plasma samples.<br><strong>U-AlbCre</strong> The value of the U-AlbCre laboratory measurement, representing the ratio of albumin to creatinine concentration in a spot urine sample<br><strong>eGFR</strong> The value of the Pt-GFReEPI laboratory measurement, i.e. the estimated glomerular filtration rate. The calculation is performed using the CKD-EPI equation, which requires plasma creatinine concentration, sex, and age.</p> |
| VALUE        | <p><strong>Value of the measurement:</strong><br></p>                          | <p><strong>AlbKre:</strong> mg/mmol<br><strong>GDF:</strong> ml/min/1,73m^2<br><strong>HbA1c:</strong> mmol/mol<br><strong>LDL:</strong> mmol/l</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |
| OUTLIER      | <p><strong>Is value of the measurement outlier?</strong><br></p>               | <p><code>0</code> = No<br><code>1</code> = Yes (high)<br><code>-1</code> = Yes (low)</p>                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             |

#### Patient data

Patient data includes diabetes diagnosis information for people with diabetes. Data is available since 1964.

The patient data contains information about:

* The patient's diabetes type: type 1, type 2, type 4 (special)
* A medication type
* Complication risk
* Risk of kidney disease progression
* Which special reimbursement entitlements the patient has received

<table><thead><tr><th width="211.1796875">VARIABLE</th><th width="262.91015625">DESCRIPTION</th><th>VALUES</th></tr></thead><tbody><tr><td>FINNGENID</td><td><strong>Studyid</strong></td><td></td></tr><tr><td>APPROX_DIAG_DATE</td><td><strong>Randomized first diagnosis date</strong> (randomized +/- 1-15 days from the exact date). The date is the earliest recorded date of diabetes diagnosis. Selected as the earliest of the following: the date of the first diabetes diagnosis (ICD-10: E10–E14), the creation date of the diagnosis document, the date of the first diabetes prescription (ATC: A10), or the date of the first special reimbursement entitlement decision (codes 103, 215, 285, 295, 346, or 3022).</td><td></td></tr><tr><td>EVENT_AGE</td><td><strong>Age at the time of the first diagnosis</strong></td><td></td></tr><tr><td>APPROX_DEATH_DATE</td><td><strong>Randomized death date</strong> (randomized +/- 1-15 days from the exact date)</td><td></td></tr><tr><td>DMTYPE2</td><td><strong>Diabetes type.</strong> The patient's diabetes type (1, 2 or 4). Based on the patient's two most recent consecutive and concordant diabetes diagnoses. If no such pair is found, the patient's most recent diabetes diagnosis has been used instead.</td><td><p><code>1</code> Type 1 diabetes </p><p><code>2</code> Type 2 diabetes  </p><p><code>4</code> special</p></td></tr><tr><td>MEDTYPEID2</td><td><strong>Diabetes medication type.</strong> The diabetes medication type based on medication purchases made during the patient's last year of life, derived from ATC codes<br></td><td><p><code>10</code> = A10B<br><code>21</code> = A10B and A10AC/A10AE<br><code>22</code> = A10B and A10AB ja A10AC/A10AE<br><code>23</code> = A10B and A10AB<br><code>24</code> = A10B and A10AD<br><code>30</code>  = A10A<br><code>31</code> = A10A and A10AC/A10AE<br><code>32</code> = A10A and A10AB<br><code>33</code> = A10A and A10AB and A10AC/A10AE<br><code>34</code> = A10A and A10AD<br><code>A null value</code> for those for whom no diabetes diagnosis with an ICD-10 code can be found in the Kanta PTA database.  </p><p></p><p><em>See more detailed information in readme file.</em></p></td></tr><tr><td>HIRISK</td><td><p><strong>Risk of atherosclerotic event.</strong> Indicates whether a patient has an elevated risk of cardiovascular events and death.</p><p></p></td><td><p><code>0</code> = No elevated risk<br><code>1</code> = Patient has cardiovascular disease<br><code>2</code> = Patient belongs to the high or very high risk group for kidney disease progression<br><code>3</code> = Patient has cardiovascular disease and belongs to the high or very high risk group for kidney disease progression. </p><p></p><p><em>See more detailed information in readme file.</em></p></td></tr><tr><td>KIDNEY_DISEASE</td><td><strong>Risk of kidney disease progression.</strong> Describes the risk of kidney disease based on the patient's most recent U-AlbKre and eGFR (Pt-GFReEPI) measurements within the past 24 months.<br></td><td><code>1</code> = Low risk: U-AlbKre lower than 3 and eGFR higher than 60,<br><code>2</code> = Moderate risk: (U-AlbKre 3–30 and eGFR higher than 60) or (U-AlbKre lower than 3 and eGFR 45–59),<br><code>3</code> = High risk: (U-AlbKre higher than 30 and eGFR higher than 60) or (U-AlbKre 3–30 and eGFR 30–59 or (U-AlbKre lower than 3 and eGFR 30–44),<br><code>4</code> = Very high risk: (eGFR lower than 29) or (U-AlbKre higher than 30 and eGFR lower than 60),<br><code>0</code> = no information<br><code>A null value</code> indicates that the category could not be determined.</td></tr><tr><td>REIMBURSEMENT</td><td><strong>Special reimbursement entitlement.</strong> The variable indicates which special reimbursement entitlements the patient has received (zero, one, or more). Bits 1–6 of this integer variable correspond to the following special reimbursement codes:<br>Bit number = Special reimbursement code<br></td><td><code>1</code> = 103 (diabetes, insulin therapy)<br><code>2</code> = 215 (diabetes, treatment other than insulin)<br><code>3</code> = 285 (dulaglutide, exenatide, liraglutide and semaglutide, higher reimbursement category, type 2 diabetes, adults)<br><code>4</code> = 295 (liraglutide, higher reimbursement category, type 2 diabetes, children and adolescents)<br><code>5</code> = 346 (dulaglutide, exenatide, liraglutide and semaglutide, basic/lower reimbursement category, type 2 diabetes, adults)<br><code>6</code> = 3022 (liraglutide, basic/lower special reimbursement, type 2 diabetes, children and adolescents)<br><code>0</code> = no special reimbursement entitlements</td></tr></tbody></table>

{% hint style="info" %}
More information about the data is available from the [Diabetes register (THL)](https://www.thl.fi/kansallisten-laaturekisterien-raportit/diabetesrekisteri/) and [Aineistokatalogi](https://aineistokatalogi.fi/catalog/studies/2277f826-58af-4d42-b84b-45238463a738/datasets/3f866d5a-bf6e-4bba-9fc2-d1990530a31b)
{% endhint %}
