# Endpoint Cohorts

### Details

Table is a transformation of table [finngen\_R13\_endpoint\_3.0.txt](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/endpoint-and-endpoint-longitudinal-data) from wide to long format.

### Sandbox directory

Endpoint cohorts data is available as a separate file in the following Sandbox directory:

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

### Data files

This data is available in the following file:

`finngen_R{RELEASE]_endpoint_cohorts_3.0.csv.gz` 

The file contains the following columns:

| Column              | Description                                                   |
| ------------------- | ------------------------------------------------------------- |
| FINNGENID           | Studyid                                                       |
| ENDPOINT            | Endpoint name                                                 |
| CONTROL\_CASE\_EXCL | Indicates if patient is control=1, case=1, excluded control=2 |
| AGE                 | If case, the age of the first event                           |
| YEAR                | If case, the year of the first event                          |
| NEVT                | If case, the number of events                                 |