Avan Data Portal

Use this portal to explore available datasets, search variables, and build a CSV-ready selection list.

Secrecy

All data are subject to the General Data Protection Regulation (GDPR) and are covered by secrecy in accordance with §7 of the Offentlighets- och sekretessförordningen (OSF) and/or Chapter 24, §8 of the Offentlighets- och sekretesslagen (OSL; Public Access to Information and Secrecy Act). Access to the data is strictly regulated, and any request for disclosure is subject to a documented secrecy assessment (sekretessprövning) before approval.

How to use the Avan Data Portal

The Avan Data Portal provides an overview of the variables available in the Avan data lake. You can browse variables, read their descriptions, select the ones you need, and export your final selection as a CSV file. Please ensure that all selected variables align with the project description in your approved ethics application.

The portal currently includes variables from several national and regional data sources. Additional datasets may be added in future updates as the PREDICT infrastructure continues to grow.

Instructions

Select variables by clicking; all chosen variables are added to your list.
When your selection is complete, export it using the "Download CSV" button. This downloads the CSV file to your computer.
Include the CSV file with your data application submitted to research.predict@umu.se.

Important

This version of the portal is a temporary, simplified release. Your selection is only saved for the current session. If you leave, close, or refresh the page, you will need to redo your selections.

If you prefer to work offline — and avoid the risk of losing your selections — you can download an Excel file containing all available variables. This allows you to complete your variable selection locally on your computer.

➜ Download the Excel version of the variable list here: Download Excel file
In the Excel file, mark your selected variables by adding an “x” in the “Selection” column.
When your selection is complete, attach the edited Excel file to your data application.

National board of health and welfare

This dataset is an extract from the National Cancer Register, covering the period 1958‑01‑01 to 2022‑03‑31. It includes all individuals in the PREDICT cohort who have relevant register records within this time span.

Official site:
https://www.socialstyrelsen.se/statistik-och-data/register/cancerregistret/
Official variable list:
https://www.socialstyrelsen.se/globalassets/sharepoint-dokument/dokument-webb/statistik/register-variabelforteckning-cancerregistret.xlsx
Date of extraction: 2025‑02‑25
Notes:
- The official variable names differ from those used internally within Avan. These original register names are shown under Source variable name in the table below.
- In addition to the variables originating from the register, Avan has enriched the dataset by deriving several convenience variables, such as clear‑text translations of medical code values at different hierarchical levels.

Label	Variable name	Source variable name	Type	Categories
Date of birth Extracted from pin	`birthdate`	`birthdate`	date	demography
Sex Derived from pin	`sex`	`sex`	character	demography
Year of diagnosis Calendar year of diagnosis	`diagnosis_year`	`AR`	integer	diagnosiscancer_diagnosis
Date of diagnosis Where the complete date is unavailable (`diagnosis_date_original`), it has been extrapolated by letting it default to…	`diagnosis_date`	`DIADAT_complete`	date	diagnosiscancer_diagnosis
Age at diagnosis Derived from `diagnosis_date` and `birthdate`.	`age_diagnosis`	`age_diagnosis`	double	demography
Tumour location according to ICD-O-3 Tumor location according to ICD-O-3. This is a four-character topographical code (except for the three-character code…	`icdo3_code`	`ICDO3`	character	diagnosiscancer_diagnosis
Tumour location according to ICD-O-2 Tumor location according to ICD-O-2. This is a four-character topographical code (except for the three-character code…	`icdo2_code`	`ICDO10`	character	diagnosiscancer_diagnosis
Tumour location according to ICD-9 Tumor location according to ICD-9-CM	`icd9_code`	`ICD9`	character	diagnosiscancer_diagnosis
Tumour location according to ICD-7 Tumor location according to ICD-7	`icd7_code`	`ICD7`	character	diagnosiscancer_diagnosis
Morphological diagnosis according to ICD-O-3 Tumor morphological diagnosis according to ICD-O-3	`snomed3_code`	`SNOMED3`	character	diagnosiscancer_diagnosis
Morphological diagnosis according to ICD-O-2 Tumor morphological diagnosis according to ICD-O-2	`snomed2_code`	`SNOMEDO10`	character	diagnosiscancer_diagnosis
Morphological diagnosis according to C24_1 Tumor morphological diagnosis according to C24.1	`c24_code`	`PAD`	character	diagnosiscancer_diagnosis
Malignant or benign tumour Indicates if a tumor is malignant or benign. Further documentation is provided by the National Board of Health and…	`malignancy_status`	`BEN`	character	diagnosiscancer_diagnosis
Tumour location according to ICD-9 (3-chr) Tumor location according to ICD-9-CM, at three-character level. Derived from `icd9_code` through truncation.	`icd9_3chr_code`	`ICD9_3chr_code`	character	diagnosiscancer_diagnosis
Tumour location according to ICD-9 (3-chr) Tumor location according to ICD-9-CM, at three-character level. Derived from `icd9_3chr_code` through in-house…	`icd9_3chr_text`	`ICD9_3chr_text`	character	diagnosiscancer_diagnosis

This dataset is an extract from the National Cause of Death Register, covering the period from 1958‑01‑01 to 2022‑03‑31. It includes all individuals in the PREDICT cohort who have relevant register records within this time span.

Official site:
https://www.socialstyrelsen.se/statistik-och-data/register/dodsorsaksregistret/
Date of extraction: 2025‑02‑24
Notes:
- The official variable names differ from those used internally within Avan. These original register names are shown under Source variable name in the table below.
- In addition to the variables originating from the register, Avan has enriched the dataset by deriving several convenience variables, such as clear‑text translations of medical code values at different hierarchical levels.

Label	Variable name	Source variable name	Type	Categories
Date of birth Extracted from pin	`birthdate`	`birthdate`	date	demography
Sex Derived from pin	`sex`	`sex`	character	demography
Date of death (00 represents missing month and/or day) '00' presumably represents missing month/and or day. Consequently, this column can not be managed as date type.	`death_date_original`	`DODSDAT`	character	death
Date of death Where an exact date is unavailable (`death_date_original`), it has been extrapolated by letting missing months default…	`death_date`	`DODSDAT_valid`	date	deathdemography
Age at death Derived from `death_date` and `birthdate`.	`age_death`	`age_death`	double	death
Year of death Calendar year of death	`death_year`	`AR`	double	death
ICD-code version ICD version used for coding causes of death in each record (e.g., ICD-9 or ICD-10)	`icd_version`	`ICD`	character	medical_code
Underlying cause of death ICD-code	`cod_underlying_code`	`ULORSAK`	character	deathmedical_code
Underlying cause of death Text description of `cod_underlying_code`, based on in-house translation using resources from the National Board of…	`cod_underlying_text`	`ULORSAK_text`	character	deathmedical_code
Underlying cause of death Three-character ICD code, derived by truncating `cod_underlying_code`.	`cod_underlying_3chr_code`	`ULORSAK_3chr_code`	character	deathmedical_code
Underlying cause of death Text description of `cod_underlying_3chr_code`, based on in-house translation using resources from the National Board…	`cod_underlying_3chr_text`	`ULORSAK_3chr_text`	character	deathmedical_code
Underlying cause of death Top-level ICD interval code, derived from `cod_underlying_3chr_code` using in-house mapping, based on resources from…	`cod_underlying_int_code`	`ULORSAK_int_code`	character	deathmedical_code
Underlying cause of death Text description of `cod_underlying_int_code`, based on in-house translation using resources from the National Board of…	`cod_underlying_int_text`	`ULORSAK_int_text`	character	deathmedical_code
Contributing cause(s) of death ICD-coded contributing causes across up to 17 fields.	`contributing_cod`	`MORSAK1-MORSAK17`		deathmedical_code

This dataset is an extract from the National In‑Patient Register (Slutenvård), covering the period from 1987‑01‑01 to 2022‑03‑31. It includes all individuals in the PREDICT cohort with relevant register records within this time span.

Official site:
https://www.socialstyrelsen.se/statistik-och-data/register/patientregistret/
Official variable list:
https://www.socialstyrelsen.se/globalassets/sharepoint-dokument/dokument-webb/ovrigt/register-variabelforteckning-patientregistret.xlsx
Date of extraction: 2025‑02‑25
Notes:
- The official variable names differ from those used internally within Avan. These original register names are shown under Source variable name in the table below.
- In addition to the variables originating from the register, Avan has enriched the dataset by deriving several convenience variables, such as clear‑text translations of medical code values at different hierarchical levels.

Label	Variable name	Source variable name	Type	Categories
Date of birth Extracted from pin	`birthdate`	`birthdate`	date	demography
Sex Derived from pin	`sex`	`sex`	character	demography
Date of admission Year of introduction: 1964	`admission_date`	`INDATUM`	date	care_episode
Date of discharge Year of introduction: 1964	`discharge_date`	`UTDATUM`	date	care_episode
Year of discharge Year of introduction: 1964	`discharge_year`	`AR`	double	care_episode
Age at admission Derived from `admission_date` and `birthdate`.	`admission_age`	`age_admission`	double	demography
Age at discharge Derived from `discharge_date` and `birthdate`.	`discharge_age`	`age_discharge`	double	demography
ICD-code version Inferred from `diagnosis` using: 1. Year (<1997 = ICD-9), 2. Strict pattern matching, 3. Relaxed pattern matching, 4…	`icd_version`	`HDIA_icd_v`	character	medical_code
ICD-code validation Best-effort validation of `diagnosis` ICD-code values using custom in-house methods.	`icd_validation`	`check_icd_info`	character	medical_code
Main diagnosis (ICD) ICD code. Includes discontinued codes, format errors, and values not found in official ICD-9/10-SE lookup assets. Year…	`diagnosis`	`HDIA`	character	medical_codediagnosis
Main diagnosis (ICD) Text description of `diagnosis`, based on in-house translation using resources from the National Board of Health and…	`diagnosis_text`	`HDIA_text`	character	medical_codediagnosis
Main diagnosis (ICD, 3-chr) Three-character ICD code, derived by truncating `diagnosis`.	`diagnosis_3chr_code`	`HDIA_3chr_code`	character	medical_codediagnosis
Main diagnosis (ICD, 3-chr) Text description of `diagnosis_3chr_code`, based on in-house translation using resources from the National Board of…	`diagnosis_3chr_text`	`HDIA_3chr_text`	character	medical_codediagnosis
Main diagnosis (ICD, interval) Top-level ICD interval code, derived from `diagnosis` using in-house mapping, based on resources from the National…	`diagnosis_int_code`	`HDIA_int_code`	character	medical_codediagnosis
Main diagnosis (ICD, interval) Text description of `diagnosis_int_code`, based on in-house translation using resources from the National Board of…	`diagnosis_int_text`	`HDIA_int_text`	character	medical_codediagnosis
Diagnosis "ICD-code. The order of `diagnosis_nn` variables is not systematically meaningful across the dataset. Year of…	`diagnosis_all`	`DIA1-DIA30`		diagnosismedical_code
External cause "ICD-code, Year of introduction: 1964."	`external_cause_all`	`EKOD1-EKOD5`		diagnosismedical_code
Procedure codes (KVA, space delimited list) Multiple procedure codes, space delimited, using KOP-codes (1964-1996) or KVA-code (post 1996). Includes errors, such…	`procedures`	`OP`	character	medical_codeprocedure
Number of procedures recorded Number of reported procedures; may exceed 30. Derived from `procedures`. Replaces the variable `OP_ANT` provided by the…	`procedures_count`	`OP_count`	double	medical_codeprocedure
Date of procedure "Dates of the procedures listed in 'Procedure codes'"	`procedure_date_all`	`OPD1-OPD29`		medical_codeprocedure
Is reporting complete Indicates whether the care episode has been finalized by the healthcare provider. The value `final` means reporting is…	`report_complete`	`slutrapporterad`	character	care_episode

This dataset is an extract from the National Out‑Patient Register (Öppenvård), covering the period from 2001‑01‑01 to 2022‑03‑31. It includes all individuals in the PREDICT cohort with relevant register records within this time span.

Official site:
https://www.socialstyrelsen.se/statistik-och-data/register/patientregistret/
Official variable list:
https://www.socialstyrelsen.se/globalassets/sharepoint-dokument/dokument-webb/ovrigt/register-variabelforteckning-patientregistret.xlsx
Date of extraction: 2025‑02‑25
Notes:
- The official variable names differ from those used internally within Avan. These original register names are shown under Source variable name in the table below.
- In addition to the variables originating from the register, Avan has enriched the dataset by deriving several convenience variables, such as clear‑text translations of medical code values at different hierarchical levels.

Label	Variable name	Source variable name	Type	Categories
Date of birth Extracted from pin	`birthdate`	`birthdate`	date	demography
Sex Derived from pin	`sex`	`sex`	character	demography
Date of visit Year of introduction: 2001	`visit_date`	`INDATUM`	date	care_episode
Year of visit Year of introduction: 2001	`visit_year`	`AR`	double	care_episode
Age at visit Derived from `visit_date` and `birthdate`.	`age_visit`	`age_visit`	double	demography
ICD-code version Inferred from context; all records are dated 2001 and later.	`icd_version`	`HDIA_icd_v`	character	medical_code
ICD-code validation Best-effort validation of `diagnosis` ICD-code values using custom in-house methods.	`icd_validation`	`check_icd_info`	character	medical_code
Main diagnosis (ICD) ICD code. Includes discontinued codes, and othervalues not found in official ICD-10-SE lookup assets. Year of…	`diagnosis`	`HDIA`	character	medical_codediagnosis
Main diagnosis (ICD) Text description of `diagnosis`, based on in-house translation using resources from the National Board of Health and…	`diagnosis_text`	`HDIA_text`	character	medical_codediagnosis
Main diagnosis (ICD, 3-chr) Three-character ICD code, derived by truncating `diagnosis`.	`diagnosis_3chr_code`	`HDIA_3chr_code`	character	medical_codediagnosis
Main diagnosis (ICD, 3-chr) Text description of `diagnosis_3chr_code`, based on in-house translation using resources from the National Board of…	`diagnosis_3chr_text`	`HDIA_3chr_text`	character	medical_codediagnosis
Main diagnosis (ICD, interval) Top-level ICD interval code, derived from `diagnosis` using in-house mapping, based on resources from the National…	`diagnosis_int_code`	`HDIA_int_code`	character	medical_codediagnosis
Main diagnosis (ICD, interval) Text description of `diagnosis_int_code`, based on in-house translation using resources from the National Board of…	`diagnosis_int_text`	`HDIA_int_text`	character	medical_codediagnosis
Diagnosis "ICD-code. The order of `diagnosis_nn` variables is not systematically meaningful across the dataset. Year of…	`diagnosis_all`	`DIA1-DIA30`		diagnosismedical_code
External cause "ICD-code, Year of introduction: 1964."	`external_cause_all`	`EKOD1-EKOD5`		diagnosismedical_code
Procedure codes (KVA, space delimited list) Multiple procedure codes, space delimited, using KVA-code (post 1996). Year of introduction: 2001	`procedures`	`OP`	character	medical_codeprocedure
Number of procedures recorded Number of reported procedures; may exceed 30. Derived from `procedures`. Replaces the variable `OP_ANT` provided by the…	`procedures_count`	`OP_count`	double	medical_codeprocedure
Is reporting complete Indicates whether the care episode has been finalized by the healthcare provider. The value `final` means reporting is…	`report_complete`	`slutrapporterad`	character	care_episode

This dataset is an extract from the National Prescribed Drug Register (Läkemedelsregistret), covering the period 2005‑01‑01 to 2022‑03‑31. It includes all individuals in the PREDICT cohort who have recorded dispensings during this time span.

Official site:
https://www.socialstyrelsen.se/statistik-och-data/register/lakemedelsregistret/
Official variable list:
https://www.socialstyrelsen.se/globalassets/sharepoint-dokument/dokument-webb/statistik/register-variabelforteckning-lakemedelsregistret.xlsx
Date of extraction: 2025‑02‑24
Notes:
- The official variable names differ from those used internally within Avan. These original register names are shown under Source variable name in the table below.
- In addition to the variables originating from the register, Avan has enriched the dataset by deriving several convenience variables, such as clear‑text translations of medical code values at different hierarchical levels.
  - Negative dispensing counts:
    The register uses negative values of ANTAL (dispensed_package_count) to represent corrections to earlier erroneous records. To support users in identifying such corrections, Avan provides a set of convenience variables — Candidate Corresponding Erroneous Post (ccep) — derived using in‑house algorithms.

Label	Variable name	Source variable name	Type	Categories
Date of birth Extracted from pin	`birthdate`	`birthdate`	date	demography
Sex Derived from pin	`sex`	`sex`	character	demography
Anatomical Therapeutic Chemical (ATC 7-chr) ATC code according to the World Health Organization (WHO) (7 characters; 5th level - chemical substance). This is a…	`atc_code`	`ATC`	character	medical_codedrug_dispensingatc
Chemical substance (ATC 7-chr) Text description of `atc_code`, based on in-house translation using the ATC index from the WHO Collaborating Centre for…	`atc_text`	`ATC_text`	character	medical_codedrug_dispensingatc
Anatomical Therapeutic Chemical (ATC 3-chr) ATC code according to the World Health Organization (WHO) (3 characters; 2nd level - therapeutic subgroup). This is a…	`atc_3chr_code`	`ATC_3chr_code`	character	medical_codedrug_dispensingatc
Therapeutic subgroup (ATC 3-chr) Text description of `atc_3chr_code`, based on in-house translation using the ATC index from the WHO Collaborating…	`atc_3chr_text`	`ATC_3chr_text`	character	medical_codedrug_dispensingatc
Date of drug dispensing Date of drug dispensing	`dispensing_date`	`EDATUM`	date	drug_dispensing
Age at drug dispensing Age at drug dispensing	`age_dispensing`	`age_dispensing`	double	drug_dispensing
Number of packages dispensed Number of packages dispensed to the patient. For dose-dispensed medications, this value may be a decimal. Negative…	`dispensed_package_count`	`ANTAL`	double	drug_dispensing
Year of drug dispensing Year of drug dispensing	`dispensing_year`	`ar`	double	drug_dispensing
Daily Defined Dose Defined Daily Doses (DDD) per package. Indicates how many Defined Daily Doses the package contains (number of treatment…	`package_ddd`	`forpddd`	double	drug_dispensing
Candidate Corresponding Erroneous Post Identifier of the Candidate Corresponding Erroneous Post (CCEP) for negative dispensing events. For each negative…	`ccep`	`ccep`	character	drug_dispensing
NA Number of days between the negative dispensing event and its matched CCEP. This value allows users to assess the…	`ccep_datediff`	`ccep_datediff`	double	drug_dispensing
NA Flag indicating whether a post has been identified as a CCEP. All negative `dispensed_package_count` entries and…	`ccep_filter`	`ccep_filter`	factor	drug_dispensing

Västerbotten Intervention Programme (VIP)

This dataset is an extract from the Northern Sweden Health and Disease Study (NSHDS). It includes all individuals in the PREDICT cohort who have corresponding NSHDS records.

Official site:
https://www.umu.se/en/brs/provsamlingar-och-register/nshds/
Date of extraction: 2024‑02‑01
Notes:
- The official NSHDS variable names differ from those used internally within Avan. These original names are shown under Source variable name in the table below.
- This data extract includes only a subset of NSHDS variables (VIP and MONICA). If you wish to order NSHDS variables not included here, please refer to the NSHDS access information at the link above.
- Further descriptions of NSHDS:
  - Cohort profile (2025)
  - Descriptive statistics

Important

NSHDS maintains its own variable order forms (in Swedish and English), which provide detailed variable descriptions and context and are widely used in NSHDS‑related projects. To order variables from this dataset, you may choose either the selection tool below or the official NSHDS order form, depending on your preference.

If you use the selection tool, all chosen variables across data sources are included in a single CSV file, which you submit with your application.
If you use the official NSHDS order form, please submit both the generated CSV file and the completed order form:
- English version
- Swedish version (Svenska)

Label	Variable name	Source variable name	Type	Categories
Date of birth Extracted from pin	`birthdate`	`birthdate`	date	demography
Diet questionnaire exists Information about availablility of diet questionnaire data.	`diet_questionnaire`	`kostenkat`	character	diet_questionnaire
Diet data completeness Information about deficiencies in diet questionnaire data.	`exclude_diet`	`exclude`	character	diet_questionnaire
NSHDS consent to commercial research Information about the NSHDS consent, where some (n = 37) participants have opted out of commercial research. At this…	`consent_nshds_note`	`x_ad`	character	consent
Date of questionnaire Date of the questionnaire. Note: `sample_date` and `questionnaire_date` may differ. BRS keeps a a variable called…	`questionnaire_date`	`q_date`	date	questionnaire
Data linked to questionnaire or sample date Information about whether medical and anthropometric variables are linked to `questionnaire_date` or `sample_date`.	`background_at`	`bakg_at_sampledate`	character	questionnairesample_info
Sex Sex	`sex`	`gender`	character	demography
Data from which NSHDS cohort Information about which of the three NSHDS cohorts data originates from.	`nshds_cohort`	`delproj`	character	questionnaire
Age at healthcare visit Age at healthcare visit	`age`	`age`	number	demography
Fasting at time of questionnaire Fasting status relevent for interpreting questionnaire data on blood sugar, cholesterol, and triglycerides. These data…	`questionnaire_fasting`	`fasta_enk`	character	questionnairesample_info
Height (cm) Height in centimeters, which may be measured or self-reported. Refer to `h_w_estimate` to determine the source.	`height`	`langd`	number	anthropometry
Weight (kg) Weight in kilograms, which may be measured or self-reported. Refer to `h_w_estimate` to determine the source. [Note:…	`weight`	`vikt`	number	anthropometry
Height and weight measured or self reported Information about whether `height` and `weight` is measured or self-reported.	`h_w_estimate`	`l_v_uppskattad`	character	anthropometry
BMI Body mass index, derived from `height` and `weight` regardless of whether they are measured or self reported.	`bmi`	`bmi`	number	anthropometry
Waist (cm) Waist circumference in centimeters.	`waist`	`midja`	number	anthropometry
Total cholesterol (mmol/l) Total cholesterol level in mmol/l. Analyzed using different methods over time, with Reflotron until 2009-08-31 and at…	`total_cholesterol`	`skol`	number	biochemistrylipids
HDL cholesterol (mmol/l) HDL cholesterol level in mmol/l. Measured for all participants from 2009-09-01 onwards, with some values available for…	`hdl_cholesterol`	`hdl`	number	biochemistrylipids
LDL cholesterol (mmol/l) LDL cholesterol level in mmol/l. Measured for all participants from 2009-09-01 onwards, with some values available for…	`ldl_cholesterol`	`ldl`	number	biochemistrylipids
Triglycerides (mmol/l) Triglyceride level in mmol/L. Analyzed using different methods over time, with Reflotron until 2009-08-31 and at the…	`triglycerides`	`stg`	number	biochemistry
Blood sugar 0 hours Oral glucose tolerance test; blood glucose at 0 hours. Measured using capillary plasma (Reflotron/Hemocue)	`bloodsugar_0h`	`blods0`	number	biochemistry
Blood sugar 2 hours Oral glucose tolerance test; blood glucose at 2 hours. Measured using capillary plasma (Reflotron/Hemocue)	`bloodsugar_2h`	`blods2`	number	biochemistry
Blood pressure systolic Systolic blood pressure, measured laying down until 2009-08-31 and sitting up from 2009-09-01 onwards. The clinical…	`bp_syst`	`sbt`	number	blood_pressurevital_signs
Blood pressure diastoic Diastolic blood pressure, measured laying down until 2009-08-31 and sitting up from 2009-09-01 onwards. The clinical…	`bp_diast`	`dbt`	number	blood_pressurevital_signs
Sample before or after 2009-08-31 This is a convenience variable indicating whether measurements were performed before or after 2009-01-01. On that date,…	`after_090901`	`efter_090901`	character	blood_pressure
Marital status Response to the question: 'Marital status?' (Civilstånd?)	`marital_status`	`civil`	character	questionnaire
Education Response to the question: 'Education level?' (Utbildningsnivå?)	`education`	`utbild`	character	questionnaire
Cohabitant Response to the question: 'Who do you cohabitate with?' (Vilka sammanbor du med?)	`cohabitant`	`sambo`	character	questionnaire
Sick leave Response to the question: 'Have you been on sick leave for more than 6 months?'. (Har du varit långtidssjukskriven mer…	`sickleave`	`sjukskriven`	character	questionnaire
Employment type - Permanent Response to the question: 'Type of employment = Permanent employment?'. (Anställningstyp = Fast anställning?)	`employment_type_a`	`ansttyp_a`	character	questionnaireemployment
Employment type - Temporary/contract Response to the question: 'Type of employment = Temporary, substitute, or preparedness work?'. (Anställningstyp =…	`employment_type_b`	`ansttyp_b`	character	questionnaireemployment
Employment type - Homemaker Response to the question: 'Type of employment = Homemaker?'. (Anställningstyp = Arbetar i hemmet?)	`employment_type_c`	`ansttyp_c`	character	questionnaireemployment
Employment type - Unemployed Response to the question: 'Type of employment = Unemployed?'. (Anställningstyp = Arbetslös?)	`employment_type_d`	`ansttyp_d`	character	questionnaireemployment
Employment type - Student Response to the question: 'Type of employment = Student?'. (Anställningstyp = Studerar?)	`employment_type_e`	`ansttyp_e`	character	questionnaireemployment
Employment type - Self-employed Response to the question: 'Type of employment = Self-employed?'. (Anställningstyp = Egen företagare?)	`employment_type_f`	`ansttyp_f`	character	questionnaireemployment
Employment type - Early retirement/full disability pension Response to the question: 'Type of employment = Early retirement or disability pension, full pension?'…	`employment_type_g`	`ansttyp_g`	character	questionnaireemployment
Employment type - Early retirement/partial disability pension Response to the question: 'Type of employment = Early retirement or disability pension, partial pension?'…	`employment_type_h`	`ansttyp_h`	character	questionnaireemployment
Employment type - Early retirement/unspecified pension Response to the question: 'Type of employment = Early retirement or disability pension, unspecified full or partial…	`employment_type_i`	`ansttyp_i`	character	questionnaireemployment
Country of origin Response to the question: 'Which country are you from?'. (Vilket land kommer du från?)	`country_of_origin`	`ursprungsland`	character	questionnaire
Country of origin - specific Specifies which country the person is from, other than Sweden.	`country_of_origin_specific`	`ursprungsland_vilket`	character	questionnaire
General health status last year Response to the question: 'How would you rate your health status over the past year?'. (Hälsotillstånd senaste året?)	`health_status_year`	`halsoar`	character	questionnaire
Family history - heart attack/stroke before age 60 Response to the question: 'Have any of your parents or siblings had a heart attack or stroke before the age of 60?'…	`mi_stroke_family`	`hjartinf_foraldrar_syskon`	character	questionnaire
Family history - diabetes Response to the question: 'Do any of your parents or siblings have diabetes?'. (Förekommer diabetes hos någon av dina…	`diabetes_family`	`diab_foraldrar_syskon`	character	questionnaire
Ever diagnosed with high blood pressure Response to the question: 'Have you ever been told that you have high blood pressure?'. (Har du vid något tillfälle…	`high_bp`	`beskbltr`	character	questionnaireblood_pressure
Medication - Blood pressure Response to the question: 'Have you used any of the following medications in the past 14 days - Blood pressure…	`medication_c5a`	`med_C5a`	character	questionnairemedication
Medication - Heart/angina Response to the question: 'Have you used any of the following medications in the past 14 days - Heart or angina…	`medication_c5b`	`med_C5b`	character	questionnairemedication
Medication - Tranquilizers/sleep aids Response to the question: 'Have you used any of the following medications in the past 14 days - Tranquilizers or…	`medication_c5c`	`med_C5c`	character	questionnairemedication
Medication - Ulcer/gastritis Response to the question: 'Have you used any of the following medications in the past 14 days - Ulcer or gastritis…	`medication_c5d`	`med_C5d`	character	questionnairemedication
Medication - Cholesterol-lowering Response to the question: 'Have you used any of the following medications in the past 14 days - Lipid-lowering…	`medication_c5e`	`med_C5e`	character	questionnairemedication
Medication - None of the above (c5a-c5e) Response to the question: 'Have you used any of the following medications in the past 14 days - None of the above?'…	`medication_c5f`	`med_C5f`	character	questionnairemedication
Medication - Pain relievers Response to the question: 'Have you used any of the following medications in the past 14 days - Painkillers?'…	`medication_pain`	`smartmed`	character	questionnairemedication
Medication - Other Response to the question: 'Have you used any of the following medications in the past 14 days - Other medications…	`medication_other`	`andra_mediciner`	character	questionnairemedication
Diabetes - yes/no Response to the question: 'Do you have diabetes?' (Har du diabetes?)	`diabetes`	`diabet`	character	questionnaire
RAND-36 - Physical functioning The score value calculated for the 'Physical Functioning (PF)' dimension of RAND-36. The dataset includes the the score…	`rand36_pf`	`RAND36_PF`	number	questionnairequality_of_lifephysical_activity
RAND-36 - Role limitations due to physical health The score value calculated for the 'Role Limitations due to Physical Health (RP)' dimension of RAND-36. The dataset…	`rand36_rp`	`RAND36_RP`	number	questionnairequality_of_lifephysical_activity
RAND-36 - Bodily pain The score value calculated for the 'Bodily Pain (BP)' dimension of RAND-36. The dataset includes the the score values…	`rand36_bp`	`RAND36_BP`	number	questionnairequality_of_lifephysical_activity
RAND-36 - General health The score value calculated for the 'General Health (GH)' dimension of RAND-36. The dataset includes the the score…	`rand36_gh`	`RAND36_GH`	number	questionnairequality_of_lifephysical_activity
RAND-36 - Energy/Vitality The score value calculated for the 'Energy/Vitality (VT)' dimension of RAND-36. The dataset includes the the score…	`rand36_vt`	`RAND36_VT`	number	questionnairequality_of_lifephysical_activity
RAND-36 - Social functioning The score value calculated for the 'Social Functioning (SF)' dimension of RAND-36. The dataset includes the the score…	`rand36_sf`	`RAND36_SF`	number	questionnairequality_of_lifephysical_activity
RAND-36 - Role limitations due to emotional problems The score value calculated for the 'Role Limitations due to Emotional Problems (RE)' dimension of RAND-36. The dataset…	`rand36_re`	`RAND36_RE`	number	questionnairequality_of_lifephysical_activity
RAND-36 - Mental health The score value calculated for the 'Mental Health (MH)' dimension of RAND-36. The dataset includes the the score values…	`rand36_mh`	`RAND36_MH`	number	questionnairequality_of_lifephysical_activity
Quality of life - Home and family situation Response to the question: 'How satisfied are you with your situation - Home and family?' (Hem och familjesituation?)'…	`qol_d1`	`livskvalitet_d1`	number	questionnairequality_of_life
Quality of life - Housing Response to the question: 'How satisfied are you with your situation - Housing?' (Bostad?)'. Rated on a scale from 1…	`qol_d2`	`livskvalitet_d2`	number	questionnairequality_of_life
Quality of life - Work situation Response to the question: 'How satisfied are you with your situation - Work?' (Arbetssituation?)'. Rated on a scale…	`qol_d3`	`livskvalitet_d3`	number	questionnairequality_of_life
Quality of life - Finances Response to the question: 'How satisfied are you with your situation - Financial situation?' (Ekonomi?)'. Rated on a…	`qol_d4`	`livskvalitet_d4`	number	questionnairequality_of_life
Quality of life - Leisure Response to the question: 'How satisfied are you with your situation - Leisure time?' (Fritid?)'. Rated on a scale from…	`qol_d5`	`livskvalitet_d5`	number	questionnairequality_of_life
Quality of life - Hearing Response to the question: 'How satisfied are you with your situation - Hearing?' (Hörseln?)'. One can experience…	`qol_d6`	`livskvalitet_d6`	number	questionnairequality_of_life
Quality of life - Vision Response to the question: 'How satisfied are you with your situation - Vision?' (Synen?)'. One can experience changes…	`qol_d7`	`livskvalitet_d7`	number	questionnairequality_of_life
Quality of life - Memory Response to the question: 'How satisfied are you with your situation - Memory?' (Minnet?)'. One can experience changes…	`qol_d8`	`livskvalitet_d8`	number	questionnairequality_of_life
Quality of life - Physical fitness Response to the question: 'How satisfied are you with your situation - Physical fitness?' (Konditionen?)'. One can…	`qol_d9`	`livskvalitet_d9`	number	questionnairequality_of_life
Quality of life - Appetite Response to the question: 'How satisfied are you with your situation - Appetite?' (Aptiten?)'. One can experience…	`qol_d10`	`livskvalitet_d10`	number	questionnairequality_of_life
Quality of life - Mood Response to the question: 'How satisfied are you with your situation - Mood?' (Humöret?)'. One can experience changes…	`qol_d11`	`livskvalitet_d11`	number	questionnairequality_of_life
Quality of life - Energy Response to the question: 'How satisfied are you with your situation - Energy?' (Energin?)'. One can experience changes…	`qol_d12`	`livskvalitet_d12`	number	questionnairequality_of_life
Quality of life - Patience Response to the question: 'How satisfied are you with your situation - Patience?' (Tålamodet?)'. One can experience…	`qol_d13`	`livskvalitet_d13`	number	questionnairequality_of_life
Quality of life - Self-confidence Response to the question: 'How satisfied are you with your situation - Self-confidence?' (Självförtroendet?)'. One can…	`qol_d14`	`livskvalitet_d14`	number	questionnairequality_of_life
Quality of life - Sleep Response to the question: 'How satisfied are you with your situation - Sleep?' (Sömnen?)'. One can experience changes…	`qol_d15`	`livskvalitet_d15`	number	questionnairequality_of_life
Quality of life - Feeling valued outisde home Response to the question: 'Do you feel important and valued - Outside of home?' (Utanför hemmet?)'. Rated on a scale…	`qol_d16`	`livskvalitet_d16`	number	questionnairequality_of_life
Quality of life - Feeling valued at home Response to the question: 'Do you feel important and valued - At home?' (I hemmet?)'. Rated on a scale from 1 (Not at…	`qol_d17`	`livskvalitet_d17`	number	questionnairequality_of_life
Availability of Social Interaction (AVSI) Score for the 'Availability of Social Interaction (AVSI)' dimension of the Interview Schedule for Social Interaction…	`issi_avsi`	`ISSI_avsi`	number	questionnairesocial
Availability of Attachment (AVAT) Score for the 'Availability of Attachment (AVAT)' dimension of the Interview Schedule for Social Interaction (ISSI)…	`issi_avat`	`ISSI_avat`	number	questionnairesocial
Physical activity - Commute spring Response to the question: 'How do you usually travel to and from work - During the spring?'	`g1_a`	`g1_a`	character	questionnairephysical_activity
Physical activity - Commute summer Response to the question: 'How do you usually travel to and from work - During the summer?'	`g1_b`	`g1_b`	character	questionnairephysical_activity
Physical activity - Commute autumn Response to the question: 'How do you usually travel to and from work - During the autumn?'	`g1_c`	`g1_c`	character	questionnairephysical_activity
Physical activity - Commute winter Response to the question: 'How do you usually travel to and from work - During the winter?'	`g1_d`	`g1_d`	character	questionnairephysical_activity
Distance to work Response to the question: 'How many kilometers is your one-way commute to work?'	`distance_work`	`antal_km`	number	questionnairephysical_activity
Physical activity, Occupation - Sedentary or standing Response to the question: 'Best description of physical activity at work = Sedentary or standing?'	`g2_a`	`g2_a`	character	questionnairephysical_activity
Physical activity, Occupation - Light, partially active Response to the question: 'Best description of physical activity at work = Light but partially active?'	`g2_b`	`g2_b`	character	questionnairephysical_activity
Physical activity, Occupation - Light and active Response to the question: 'Best description of physical activity at work = Light but partially active?'	`g2_c`	`g2_c`	character	questionnairephysical_activity
Physical activity, Occupation - Occasionally physically demanding Response to the question: 'Best description of physical activity at work = Light and active?'	`g2_d`	`g2_d`	character	questionnairephysical_activity
Physical activity, Occupation - Mostly physically demanding Response to the question: 'Best description of physical activity at work = Occasionally physically demanding?'	`g2_e`	`g2_e`	character	questionnairephysical_activity
Physical activity, Leisure - Walks Response to the question: 'How often do you go for walks in your leisure time?'	`g3_a`	`g3_a`	character	questionnairephysical_activity
Physical activity, Leisure - Bike rides Response to the question: 'How often do you go for bike rides in your leisure time?'	`g3_b`	`g3_b`	character	questionnairephysical_activity
Physical activity, Leisure - Workouts Response to the question: 'How often have you exercised or engaged in physical activity in the past three months, with…	`g6`	`g6`	character	questionnairephysical_activity
Alcohol - Cut down, Annoyance, Guilt, Eye-opener (CAGE) CAGE (Cut down, Annoyance, Guilt, Eye-opener) is a score value based on 4 individual questions, to identify…	`cage`	`CAGE`	number	questionnairealcohol
Alcohol - Alcohol Use Disorders Identification Test (AUDIT) AUDIT (Alcohol Use Disorders Identification Test) is a score value based on 10 individual questions, used to identify…	`audit`	`AUDIT`	number	questionnairealcohol
Tobacco - Smoking status Response to the question: 'Smoking status?'.	`sm_status`	`sm_status`	character	questionnairetobacco
Tobacco - Number of cigarettes per day, grouped Response to the question: 'Number of cigarettes (interval) per day?'.	`sm_num_cig_grouped`	`sm_cig_groups`	character	questionnairetobacco
Tobacco - Number of cigarettes per day Response to the question: 'Number of cigarettes per day?'.	`sm_num_cig`	`sm_num_cig`	number	questionnairetobacco
Tobacco - Number of cigares per day Response to the question: 'Number of cigars per day?'.	`sm_num_cigar`	`sm_num_cigar`	number	questionnairetobacco
Tobacco - Total amout tobacco (grams/week) Response to the question: 'Grams of tobacco per week?'.	`sm_gr_tobacco`	`sm_gr_tobacco`	number	questionnairetobacco
Tobacco - Age at smoking start Response to the question: 'Age when you started smoking?'.	`sm_start`	`sm_start`	number	questionnairetobacco
Tobacco - Age at smoking cessation Response to the question: 'Age when you stopped smoking?'.	`sm_stop`	`sm_stop`	number	questionnairetobacco
Tobacoo - Total years of smoking Number of years an individual has smoked, calculated based on the age they started (`sm_start`) and the age they…	`sm_duration`	`sm_duration`	number	questionnairetobacco
Tobacco - Snus Status Response to the question: 'Snus status?'.	`sn_status`	`sn_status`	character	questionnairetobacco
Tobacco - Number of snus boxes per week Response to the question: 'Number of snus boxes per week?'.	`sn_quantity`	`sn_quantity`	character	questionnairetobacco
Tobacoo - Total years of snus usage Response to the question: 'Number of years you have used snus?'.	`sn_duration`	`sn_time`	number	questionnairetobacco
Tobacco - Smoking status Smoking status, for those where smokeing data is not available from VIP questionnaire	`sm_status_alt`	`sm_yes_no`	character	questionnairetobacco
Tobacco - Snus Status Snus status, for those where snus data is not available from VIP questionnaire	`sn_status_alt`	`sn_yes_no`	character	questionnairetobacco
Cambridge index - imputed missing Cambridge index for physical activity, based on two questions from the VIP questionnaire related to physical activity…	`pa_index`	`pa_index`	character	questionnairephysical_activity
Cambridge index - excluded missing Cambridge index for physical activity, based on two questions from the VIP questionnaire related to physical activity…	`pa_index_noimpute`	`pa_index_miss`	character	questionnairephysical_activity
Cambridge index - missing occupation Information about missing values for physical activity at work (`g2`), used to calculate in the Cambridge index for…	`pa_index_miss_work`	`occup_pa_miss`	character	questionnairephysical_activity
Cambridge index - missing leisure Information about missing values for physical activity during leisure time (`g6`), used to calculate in the Cambridge…	`pa_index_miss_leisure`	`leisure_pa_miss`	character	questionnairephysical_activity

Avan Data Portal

How to use the Avan Data Portal

National board of health and welfare

National Cancer Register

National Cause of Death Register

National In Patient Register

National Out Patient Register

National Prescribed Drug Register

Västerbotten Intervention Programme (VIP)

NSHDS Questionnaires