# Hilmo and avohilmo extended data

## Introduction

Starting from release 13 (R13), additional longitudinal data from Avohilmo (primary care) and Hilmo (hospital inpatient and outpatient) registers has been collated and released into sandbox. The purpose of this data is to provide, in one file, additional context on FinnGen individuals that can be useful in epidemiological and genetic analyses.

## Sandbox directory

The data is available in the following Sandbox directories:

* R14: `/finngen/library-red/finngen_R14/hilmo_avohilmo_extended_1.0/`
* R13: `/finngen/library-red/finngen_R13/hilmo_avohilmo_extended_1.0/`

The readme file in these directories provides full details of the available data and the meaning of each variable.

## Description

The data files contain the following information from the Hilmo inpatient and outpatient registers (INPAT, OUTPAT) and the Avohilmo primary care register (PRIM\_OUT):

* Weight (kg)
* Height (cm)
* BMI
* Smoking code
* Audit test results (10 questions)
* Systolic and diastolic blood pressure (mmHg)
* Long term diagnosis (ICD10-codes)

**Note:** In some cases (most often seen in PRIM\_OUT - primary care), the same measurement has been recorded multiple times on the same day - these entries look identical but will have a different INDEX (see table below). As this may impact some analyses, we recommend filtering or deduplicating the data using APPROX\_EVENT\_DAY so only of the identical measurements are selected per day.

| Field              | Description                                          |
| ------------------ | ---------------------------------------------------- |
| FINNGENID          | Study ID                                             |
| SOURCE             | Source register                                      |
| EVENT\_AGE         | Age at the event                                     |
| APPROX\_EVENT\_DAY | Randomized event day (within +/- 1-15 days)          |
| CODE1-10           | Register source specific codes and other information |
| CATEOGORY          | Code sequence number                                 |
| INDEX              | Register specific index number of entries            |

<figure><img src="/files/LQf3d0DkrmrG8GTBbWem" alt=""><figcaption></figcaption></figure>

#### Definitions

**SMOKING**

* 1 Smokes daily
* 2 Smokes occasionally but significantly
* 3 Significant passive smoking
* 4 No significant tobacco exposure
* 5 Significant smoking or exposure has ceased
* 6 Never smoked or had significant exposure
* 9 No information on smoking and exposure

**AUDIT\_FULL**

* 0-5: the risks are low
* 6-10: risks slightly increased
* 11-14: risks have clearly increased
* 20-40: the risks are very high

**ARRIVAL\_MODE**

* 1 Emergency
* 2 Appointment
* 3 Transfer from clinic to inpatient care
* 4 Intra-hospital transfer
* 5 Inter-hospital transfer
* 6 Unknown (mainly in use only 2007-2010, definition was not found)
* 9 Other


---

# 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/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/other-registers/hilmo-and-avohilmo-extended-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.