# Drug Events

### Details

Drug events from [Kela drug PURCH](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/detailed-longitudinal-data.md) registry, [Kanta medication delivery](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-medication-delivery.md) registry and [Kanta prescription](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-prescriptions.md) registry were combined into single table. Kanta prescription and medication delivery registries are connected using prescription ids. Kanta medication delivery is then connected to Kela PURCH registry was done using FINNGENID, EVENT\_AGE, APPROX\_EVENT\_DAY and ATC code.

### Sandbox directory

Drug events data file is available as a separate file in the following Sandbox directory:

`/finngen/library-red/finngen_R13/drug_events_v2.0/`

### Data files

This data is available in the following file:

`data/finngen_R{RELEASE]_drug_events_2.0.csv`

The file contains the following columns:

| Column                           | Description                                                                                                                                                                                                                                                                                                                                                                                                                           |
| -------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| FINNGENID                        | Studyid                                                                                                                                                                                                                                                                                                                                                                                                                               |
| PRESCRIPTION\_ID                 | Prescription id information needed to track.                                                                                                                                                                                                                                                                                                                                                                                          |
| PRESCRIPTION\_APPROX\_EVENT\_DAY | Date of the prescription.                                                                                                                                                                                                                                                                                                                                                                                                             |
| PRESCRIPTION\_AGE                | Age of the patient at the time of the prescription.                                                                                                                                                                                                                                                                                                                                                                                   |
| PRESCRIPTION\_ATC                | ATC code of the prescription.                                                                                                                                                                                                                                                                                                                                                                                                         |
| PRESCRIPTION\_VNR                | VNR code of the prescription.                                                                                                                                                                                                                                                                                                                                                                                                         |
| MEDICATION\_APPROX\_EVENT\_DAY   | Date of the medication. This date comes from Kela PURCH or Kanta Medication delivery registries.                                                                                                                                                                                                                                                                                                                                      |
| MEDICATION\_AGE                  | Age of the patient at the time of the medication.                                                                                                                                                                                                                                                                                                                                                                                     |
| MEDICATION\_ATC                  | ATC code of the medication.                                                                                                                                                                                                                                                                                                                                                                                                           |
| MEDICATION\_VNR                  | VNR code of the medication.                                                                                                                                                                                                                                                                                                                                                                                                           |
| DRUG\_MAPPING\_SOURCE            | <p>'PRESCRIPTION' - Only Prescription events</p><p>'DELIVERY' - Only Delivery events</p><p>'KELA' - Only PURCH events</p><p>'PRESCRIPTION\_DELIVERY' - Events present in both Kanta prescription and medication delivery registries only.</p><p>'DELIVERY\_KELA' - Events present in both Kanta medication delivery and Kela PURCH registries only.</p><p>'PRESCRIPTION\_DELIVERY\_KELA' - Events present in all three registries</p> |
| INDEX                            | INDEX from the Kela PURCH registry                                                                                                                                                                                                                                                                                                                                                                                                    |


---

# 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/drug-events.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.