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

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