Appendix: source tables

Table: finngenid_info

Field Type Most freq. value Comment
finngenid STRING    
bl_year INT64 2019  
bl_age FLOAT64    
sex STRING female  
height INT64    
height_age FLOAT64    
weight INT64    
weight_age FLOAT64    
smoke2 STRING no  
smoke3 STRING    
smoke5 STRING    
smoke_age FLOAT64    
regionofbirth INT64 1  
regionofbirthname STRING Uusimaa  
movedabroad INT64    
number_of_offspring INT64 2  
approx_birth_date DATE    
fu_end_age FLOAT64    

Table: drug_events

Field Type Most freq. value Comment
finngenid STRING    
prescription_id STRING PURCH  
prescription_approx_event_day DATE    
prescription_age FLOAT64 70.125  
prescription_atc STRING C07AB07  
prescription_vnr STRING 193102  
medication_approx_event_day DATE    
medication_age FLOAT64 64.832  
medication_atc STRING C07AB07  
medication_vnr STRING 383992  
medication_quantity FLOAT64 1  
merged_source STRING KELA  

Table: hilmo

Field Type Most freq. value Comment
finngenid STRING    
source STRING OUTPAT  
event_age FLOAT64 71.68  
approx_event_day DATE 2021-11-12  
code1_icd_symptom_operation_code STRING I10  
code2_icd_cause_na STRING    
code3_atc_code_na STRING    
code4_hospital_days_na STRING    
code5_service_sector STRING 93  
code6_speciality STRING 70  
code7_hospital_type STRING University Hospital  
code8_contact_type STRING    
code9_urgency STRING    
icdver STRING 10  
category STRING 0  
index STRING    

Table: prim_out

Field Type Most freq. value Comment
finngenid STRING    
source STRING PRIM_OUT  
event_age FLOAT64    
approx_event_day DATE 2021-03-02  
code1_code STRING A98  
code2_na STRING    
code3_na STRING    
code4_na STRING    
code5_contact_type STRING R10  
code6_service_sector STRING T40  
code7_professional_code STRING 51321  
icdver STRING 10  
category STRING ICP0  
index STRING    

Table: reimb

Field Type Most freq. value Comment
finngenid STRING    
source STRING REIMB  
event_age FLOAT64    
approx_event_day DATE 2016-12-15  
code1_kela_disease STRING 205  
code2_icd STRING E11  
code3_na STRING    
code4_na STRING    
icdver STRING 10  
category STRING    
index STRING    

Table: canc

Field Type Most freq. value Comment
finngenid STRING    
source STRING CANC  
event_age FLOAT64 68.14  
approx_event_day DATE 2018-11-01  
code1_topo STRING C619  
code2_morpho STRING 8140  
code3_beh STRING 3  
code4_na STRING    
icdver STRING O3  
category STRING    
index STRING    

Table: death_register

Field Type Most freq. value Comment
finngenid STRING    
source STRING DEATH  
event_age FLOAT64 83.78  
approx_event_day DATE 2019-12-03  
code1_cause_of_death STRING I251  
code2_na STRING    
code3_na STRING    
code4_na STRING    
icdver STRING 10  
category STRING U  
index STRING    

Table: birth_mother

Field Type Most freq. value Comment
mother_finngenid STRING    
delivery_year INT64 1992  
approx_delivery_date DATE 1992-02-14  
parity INT64 1  
nro_child INT64 2  
nro_fetuses INT64 1  
child_sex INT64 1  
mother_age FLOAT64 26.0  
mother_weight INT64    
mother_height INT64    
smoking INT64    
duration_weeks INT64    
duration_days INT64    
order STRING A  
sdiag1 STRING    
sdiag2 STRING    
sdiag3 STRING    
sdiag4 STRING    
sdiag5 STRING    
sdiag6 STRING    
sdiag7 STRING    
sdiag8 STRING    
sdiag9 STRING    
sdiag10 STRING    
rdiag1 STRING    
rdiag2 STRING    
rdiag3 STRING    
rdiag4 STRING    
rdiag5 STRING    
rdiag6 STRING    
rdiag7 STRING    
rdiag8 STRING    
rdiag9 STRING    
rdiag10 STRING    
matur_threat INT64 0  
insem INT64 0  
ivf INT64 0  
icsi INT64 0  
pas INT64 0  
gamete_donat INT64 0  
rkouris INT64 0  
mother_blood_pres INT64 0  
mother_bleeding INT64 0  
other_preg_diab_threat INT64 0  
diabetes INT64    
gluc INT64    
gluc_patol INT64 0  
ins_threat_init INT64 0  
prem INT64 0  

Table: vision

Field Type Most freq. value Comment
finngenid STRING    
event_age FLOAT64 26.72  
diagn1 STRING 36251  
diagn2 STRING 36250  
diagn3 STRING 22400  
diagn4 STRING H541  
RETINO INT64 1  
OVISUS INT64 6  
VVISUS INT64 1  
OHALK INT64 2  
VHALK INT64 6  
OHEMIA INT64 1  
VHEMIA INT64 1  

Table: kidney

Field Type Most freq. value Comment
finngenid STRING    
event_age FLOAT64 26.72  
diagn1 STRING 36251  
diagn2 STRING 36250  
diagn3 STRING 22400  
diagn4 STRING H541  
RETINO INT64 1  
OVISUS INT64 6  
VVISUS INT64 1  
OHALK INT64 2  
VHALK INT64 6  
OHEMIA INT64 1  
VHEMIA INT64 1  

Table: kanta

Field Type Most freq. value Comment
finngenid STRING    
event_age FLOAT64 66.044  
approx_event_datetime DATETIME    
test_name STRING b-hkr  
test_id STRING 1358  
omop_concept_id INT64 3000963  
measurement_value FLOAT64 0.0  
measurement_unit STRING mmol/l  
measurement_value_harmonized FLOAT64 0.0  
measurement_unit_harmonized STRING mmol/l  
test_outcome STRING A  
measurement_status STRING F  
reference_range_low_value FLOAT64 0.0  
reference_range_high_value FLOAT64 360.0  
coding_system_oid STRING    
test_id_source STRING 1358  
test_name_source STRING E-RDW  
measurement_value_source FLOAT64 0.0  
measurement_unit_source STRING mmol/l  

Table: stem_table

Field Type Most freq. value Comment
finngenid STRING    
source STRING    
approx_event_day DATE    
code1 STRING    
code2 STRING    
code3 STRING    
code4 STRING    
category STRING    
index STRING    
code STRING    
vocabulary_id STRING    
omop_source_concept_id STRING    
default_domain STRING    

Table: fg_codes_info

Field Type Most freq. value Comment
fg_code1 STRING    
fg_code2 STRING    
fg_code3 STRING    
source STRING    
fg_code5 STRING    
fg_code6 STRING    
fg_code7 STRING    
fg_code8 STRING    
fg_code9 STRING    
code STRING    
vocabulary_id STRING    
concept_class_id STRING    
name_en STRING    
name_fi STRING    
omop_source_concept_id STRING