# 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](/finngen-data-specifics/green-library-data-aggregate-data/core-analysis-results-files/kanta-lab-association-results-v1.md) are available as well. The documentation is split in three sections: 1. [**Data**: Data location and references](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/data.md) 2. [**FAQ**: Explanations for common questions](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md) 3. [**How-to guides**: step-by-step instructions for working with the data](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md) Documentation highlights: * [Data column overview](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/data.md#overview) * [Which years are covered in the data?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-which-years-are-covered-in-the-data) * [Why are some rows missing both the measurement value and the test outcome?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md#how-to-load-the-dataset-for-only-one-omop-concept-id-using-python-pandas) *** ### **Table of content** [**Data**](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/data.md) * [Location](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/data.md#location) * [Data columns](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/data.md#data-columns) * Pipeline * Additional dataset: Values extraction analysis * [Other reference tables](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/data.md#other-reference-tables) [**FAQ**](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md) * [Which years are covered in the data?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-which-years-are-covered-in-the-data) * [What part of the FinnGen cohort also has data in the Kanta Lab dataset?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-why-are-some-rows-missing-both-the-measurement-value-and-the-test-outcome) * [How do we know the reference range for each test?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-how-do-we-know-the-reference-range-for-each-test) * [How reliable are the time measurements from APPROX\_EVENT\_DATETIME in the data?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#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/pages/YUOeEUa4yEu7cvdi6BJy#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-how-do-i-know-if-a-test-was-positive-or-negative-say-for-covid) * [What is "vierimittaus"?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-what-is-vierimittaus) * [When will the Kanta Lab dataset be updated?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-when-will-the-kanta-lab-dataset-be-updated) * [Should I use MEASUREMENT\_VALUE or MEASUREMENT\_VALUE\_HARMONIZED for my analysis?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-i-have-found-some-negative-measurement-values-are-they-a-mistake) * [How was the Kanta data preprocessed before it got to FinnGen users?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/faq.md#q-how-was-the-kanta-data-preprocessed-before-it-got-to-finngen-users) [**How-to guides**](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md) * [How to use Athena to find a test by name?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md#how-to-use-athena-to-find-a-test-by-name) * [How to load the data file using R?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md#how-to-load-the-data-file-using-r) * [How to load the full dataset using Python pandas?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md#how-to-load-the-full-dataset-using-python-pandas) * [How to load the dataset for only one OMOP Concept ID using Python pandas?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md#how-to-load-the-dataset-for-only-one-omop-concept-id-using-python-pandas) * [How to access the data using BigQuery SQL?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md#how-to-access-the-data-using-bigquery-sql) * [How to look up what data is available for a test without using the Sandbox?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md#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?](/finngen-data-specifics/red-library-data-individual-level-data/what-phenotype-files-are-available-in-sandbox-1/kanta-lab-values/how-to-guides.md#how-to-look-up-a-test-in-the-data-from-the-sandbox) --- # 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/kanta-lab-values.md?ask= ``` 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.