FinnGen Handbook

Introduction
Where to begin
Background Concepts
FinnGen Data Specifics
Disease Specific Task Forces
- Inflammatory bowel disease (IBD)
- Kidney Diseases
- Eye Diseases
- Rheumatic Diseases
- Atopic Dermatitis
- Pulmonary Diseases
- Alzheimer's Disease
  - Retrieving quantitative data from brain MRI images
- Heart Failure
- Fibrotic Diseases
- Metabolic diseases
- Parkinson's disease
Working in the Sandbox
Working outside the Sandbox
FAQ
Release Notes
Tool Catalog
Glossary
User Support
Data Protection & Security

Powered by GitBook

On this page

FinnGen Data Specifics
Red Library Data (individual level data)
Phenotype data

Kanta lab values

PreviousEndpoint and endpoint longitudinal data NextData

Last updated 3 months ago

Was this helpful?

CtrlK

Was this helpful?

The Kanta lab values dataset was first released to the FinnGen Sandbox in August 2024. Publically accessible statistics are available on Risteys, and GWAS association results for Kanta lab values are available as well.

The documentation is split in three sections:

Data: Data location and references
FAQ: Explanations for common questions
How-to guides: step-by-step instructions for working with the data

Documentation highlights:

Data column overview
Which years are covered in the data?
Why are some rows missing both the measurement value and the test outcome?
How to load the dataset for only one OMOP Concept ID using Python pandas?

Table of content

Location
Data columns
Pipeline
Additional dataset: Values extraction analysis
Other reference tables

Which years are covered in the data?
What part of the FinnGen cohort also has data in the Kanta Lab dataset?
Why are some rows missing both the measurement value and the test outcome?
How do we know the reference range for each test?
How reliable are the time measurements from APPROX_EVENT_DATETIME in the data?
Can I differentiate between the time a test is ordered vs. the time is test is taken?
What is the meaning of the different TEST_OUTCOME and TEST_OUTCOME_IMPUTED values?
How do I know if a test was positive or negative, say for Covid?
What is "vierimittaus"?
When will the Kanta Lab dataset be updated?
Should I use MEASUREMENT_VALUE or MEASUREMENT_VALUE_HARMONIZED for my analysis?
Is it possible to know which test center processed the sample and made the test measurement?
Why are some rows duplicates by FINNGENID, APPROX_EVENT_DATETIME, OMOP_CONCEPT_ID and MEASUREMENT_VALUE?
Some of the units are unfamiliar to me, how do I know what they are?
I have found some negative measurement values, are they a mistake?
How was the Kanta data preprocessed before it got to FinnGen users?

How-to guides

How to use Athena to find a test by name?
How to load the data file using R?
How to load the full dataset using Python pandas?
How to load the dataset for only one OMOP Concept ID using Python pandas?
How to access the data using BigQuery SQL?
How to look up what data is available for a test without using the Sandbox?
How to look up a test in the data from the Sandbox?