# Kanta lab values

The Kanta lab values dataset was first released to the FinnGen Sandbox in August 2024. Publically accessible statistics are available on [Risteys](https://risteys.finngen.fi/lab-tests/), and[ GWAS association results for Kanta lab values](https://docs.finngen.fi/finngen-data-specifics/green-library-data-aggregate-data/core-analysis-results-files/kanta-lab-association-results-v1) are available as well.

The documentation is split in three sections:

1. [**Data**: Data location and references](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/data)
2. [**FAQ**: Explanations for common questions](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq)
3. [**How-to guides**: step-by-step instructions for working with the data](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides)

Documentation highlights:

* [Data column overview](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/data#overview)
* [Which years are covered in the data?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-which-years-are-covered-in-the-data)
* [Why are some rows missing both the measurement value and the test outcome?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/how-to-guides#how-to-load-the-dataset-for-only-one-omop-concept-id-using-python-pandas)

***

### **Table of content**

[**Data**](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/data)

* [Location](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/data#location)
* [Data columns](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/data#data-columns)
* Pipeline
* Additional dataset: Values extraction analysis
* [Other reference tables](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/data#other-reference-tables)

[**FAQ**](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq)

* [Which years are covered in the data?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-which-years-are-covered-in-the-data)
* [What part of the FinnGen cohort also has data in the Kanta Lab dataset?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-why-are-some-rows-missing-both-the-measurement-value-and-the-test-outcome)
* [How do we know the reference range for each test?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-how-do-we-know-the-reference-range-for-each-test)
* [How reliable are the time measurements from APPROX\_EVENT\_DATETIME in the data?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-how-do-i-know-if-a-test-was-positive-or-negative-say-for-covid)
* [What is "vierimittaus"?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-what-is-vierimittaus)
* [When will the Kanta Lab dataset be updated?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-when-will-the-kanta-lab-dataset-be-updated)
* [Should I use MEASUREMENT\_VALUE or MEASUREMENT\_VALUE\_HARMONIZED for my analysis?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-why-are-some-rows-duplicates-by-finngenid-approx_event_datetime-omop_concept_id-and-measurement_va)
* [Some of the units are unfamiliar to me, how do I know what they are?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-i-have-found-some-negative-measurement-values-are-they-a-mistake)
* [How was the Kanta data preprocessed before it got to FinnGen users?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/faq#q-how-was-the-kanta-data-preprocessed-before-it-got-to-finngen-users)

[**How-to guides**](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides)

* [How to use Athena to find a test by name?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/how-to-guides#how-to-use-athena-to-find-a-test-by-name)
* [How to load the data file using R?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/how-to-guides#how-to-load-the-data-file-using-r)
* [How to load the full dataset using Python pandas?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/how-to-guides#how-to-load-the-full-dataset-using-python-pandas)
* [How to load the dataset for only one OMOP Concept ID using Python pandas?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/how-to-guides#how-to-load-the-dataset-for-only-one-omop-concept-id-using-python-pandas)
* [How to access the data using BigQuery SQL?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/how-to-guides#how-to-access-the-data-using-bigquery-sql)
* [How to look up what data is available for a test without using the Sandbox?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/how-to-guides#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?](https://docs.finngen.fi/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/how-to-guides#how-to-look-up-a-test-in-the-data-from-the-sandbox)