On this page

SALURBAL - Renovation Workflow

This workflow goes through the steps needed to generate FAIR SALURBAL data.

Overview

Due to the heterogeneity in existing SALURBAL data/codebooks, the process of how each dataset is renovate will differ. The Renovation manuals pages will provide guidance for the FAIR renovation of SALURBAL data as well as provide instructions for new SALURBAL datasets. The steps are summarized in the list below.

  • Step 1: Assign var_name to each variable
  • Step 2: Summarize strata information for each variable
  • Step 3: Evaluate metadata linkage
  • Step 4: Renovate codebooks
  • Step 5: Renovate data.csv

Deliverables at each step

The deliverables at each step are displayed in the tabs below. Within each step there are tabs that contain examples (table + downloadable csv) of deliverables for three different datasets.

var_name.csvis a table summarizing var_name called . It should contain two columns:

  • var_name
  • dataset_id
var_name
dataset_id
APSNO2GRIDPTS
APSL1AD
APSNO2MEAN
APSL1AD
APSNO2MEDIAN
APSL1AD
APSNO2STD
APSL1AD
APSPM25GRIDPTS
APSL1AD
APSPM25MEAN
APSL1AD
APSPM25MEDIAN
APSL1AD
APSPM25STD
APSL1AD
APSPM25THRES
APSL1AD
var_name
dataset_id
CNSCROWD25BR
SEC_Census_L1AD
CNSCROWD3RM
SEC_Census_L1AD
CNSFLOOR
SEC_Census_L1AD
CNSLABFEM
SEC_Census_L1AD
CNSLABPART
SEC_Census_L1AD
CNSMINHS
SEC_Census_L1AD
CNSMINPR
SEC_Census_L1AD
CNSMINUN
SEC_Census_L1AD
CNSSEWANY
SEC_Census_L1AD
CNSSEWNET
SEC_Census_L1AD
CNSST1517
SEC_Census_L1AD
CNSUNEMP
SEC_Census_L1AD
CNSWALLDUR1
SEC_Census_L1AD
CNSWALLDUR2
SEC_Census_L1AD
CNSWALLDUR3
SEC_Census_L1AD
CNSWATIN
SEC_Census_L1AD
CNSWATNET
SEC_Census_L1AD
CNSWATPIPE
SEC_Census_L1AD
var_name
dataset_id
SVYBMIOBESE
APSL1AD
SVYBMIOVOB
APSL1AD
SVYBMISOBESE
APSL1AD
SVYBMISOVOB
APSL1AD
SVYBMISUWT
APSL1AD
SVYBMIUWT
APSL1AD
SVYDBDX1
APSL1AD
SVYDBDX2
APSL1AD
SVYHLTHFP
APSL1AD
SVYHTMED
APSL1AD
SVYMAM2YRS
APSL1AD
SVYPAP3YRS
APSL1AD
SVYSMKCUR
APSL1AD

strata.csv is a table that contains all possible strata_id for each variable. This will organize strata information ‘long’ meaning if a variable is stratified there should be multiple rows per variable. It should contain the following columns

  • var_name
  • strata_1_name: name of the first strata. Should have no spaces and no underdashes ’_’ all text should be in Pascal case.
  • strata_1_value value of the first strata. Should have no spaces and no underdashes ’_’ all text should be in Pascal case.
  • strata_2_name name of the second strata. Should have no spaces and no underdashes ’_’ all text should be in Pascal case.
  • strata_2_value value of the second strata. Should have no spaces and no underdashes ’_’ all text should be in Pascal case.
var_name
strata_1_name
strata_1_raw
strata_1_value
strata_2_name
strata_2_raw
strata_2_value
APSNO2GRIDPTS
​
​
​
​
​
​
APSNO2MEAN
​
​
​
​
​
​
APSNO2MEDIAN
​
​
​
​
​
​
APSNO2STD
​
​
​
​
​
​
APSPM25GRIDPTS
​
​
​
​
​
​
APSPM25MEAN
​
​
​
​
​
​
APSPM25MEDIAN
​
​
​
​
​
​
APSPM25STD
​
​
​
​
​
​
APSPM25THRES
​
​
​
​
​
​
var_name
strata_1_name
strata_1_raw
strata_1_value
strata_2_name
strata_2_raw
strata_2_value
CNSCROWD25BR
​
​
​
​
​
​
CNSCROWD3RM
​
​
​
​
​
​
CNSFLOOR
​
​
​
​
​
​
CNSLABFEM
​
​
​
​
​
​
CNSLABPART
Sex
9
Overall
​
​
​
CNSLABPART
Sex
1
Male
​
​
​
CNSLABPART
Sex
0
Female
​
​
​
CNSLABPART
Sex
ratio
Ratio
​
​
​
CNSMINHS
Sex
9
Overall
​
​
​
CNSMINHS
Sex
1
Male
​
​
​
CNSMINHS
Sex
0
Female
​
​
​
CNSMINHS
Sex
ratio
Ratio
​
​
​
CNSMINPR
Sex
9
Overall
​
​
​
CNSMINPR
Sex
1
Male
​
​
​
CNSMINPR
Sex
0
Female
​
​
​
CNSMINUN
Sex
9
Overall
​
​
​
CNSMINUN
Sex
1
Male
​
​
​
CNSMINUN
Sex
0
Female
​
​
​
CNSSEWANY
​
​
​
​
​
​
CNSSEWNET
​
​
​
​
​
​
CNSST1517
Sex
9
Overall
​
​
​
CNSST1517
Sex
1
Male
​
​
​
CNSST1517
Sex
0
Female
​
​
​
CNSST1517
Sex
ratio
Ratio
​
​
​
CNSUNEMP
Sex
9
Overall
​
​
​
CNSUNEMP
Sex
1
Male
​
​
​
CNSUNEMP
Sex
0
Female
​
​
​
CNSUNEMP
Sex
ratio
Ratio
​
​
​
CNSWALLDUR1
​
​
​
​
​
​
CNSWALLDUR2
​
​
​
​
​
​
CNSWALLDUR3
​
​
​
​
​
​
CNSWATIN
​
​
​
​
​
​
CNSWATNET
​
​
​
​
​
​
CNSWATPIPE
​
​
​
​
​
​
var_name
strata_1_name
strata_1_raw
strata_1_value
strata_2_name
strata_2_raw
strata_2_value
SVYBMIOBESE
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIOBESE
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIOBESE
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYBMIOBESE
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMIOBESE
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYBMIOBESE
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIOBESE
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMIOBESE
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIOBESE
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIOBESE
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYBMIOBESE
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMIOBESE
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMIOBESE
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIOBESE
Sex
0
Female
StandardPopulation
TrueCity20-49
TrueCity20-49
SVYBMIOBESE
Sex
0
Female
StandardPopulation
CountrySexSpecific20-49
CountrySexSpecific20-49
SVYBMIOBESE
Sex
0
Female
StandardPopulation
SalurbalSexSpecific20-49
SalurbalSexSpecific20-49
SVYBMIOVOB
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIOVOB
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIOVOB
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYBMIOVOB
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMIOVOB
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYBMIOVOB
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIOVOB
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMIOVOB
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIOVOB
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIOVOB
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYBMIOVOB
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMIOVOB
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMIOVOB
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIOVOB
Sex
0
Female
StandardPopulation
TrueCity20-49
TrueCity20-49
SVYBMIOVOB
Sex
0
Female
StandardPopulation
CountrySexSpecific20-49
CountrySexSpecific20-49
SVYBMIOVOB
Sex
0
Female
StandardPopulation
SalurbalSexSpecific20-49
SalurbalSexSpecific20-49
SVYBMISOBESE
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISOBESE
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISOBESE
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYBMISOBESE
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMISOBESE
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYBMISOBESE
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISOBESE
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMISOBESE
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISOBESE
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISOBESE
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISOBESE
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMISOBESE
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYBMISOBESE
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMISOVOB
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISOVOB
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISOVOB
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYBMISOVOB
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMISOVOB
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYBMISOVOB
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISOVOB
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMISOVOB
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISOVOB
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISOVOB
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISOVOB
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMISOVOB
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYBMISOVOB
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMISUWT
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISUWT
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISUWT
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYBMISUWT
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMISUWT
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYBMISUWT
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISUWT
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMISUWT
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISUWT
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMISUWT
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMISUWT
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMISUWT
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYBMISUWT
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMIUWT
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIUWT
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIUWT
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYBMIUWT
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMIUWT
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYBMIUWT
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIUWT
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMIUWT
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIUWT
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYBMIUWT
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYBMIUWT
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYBMIUWT
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYBMIUWT
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYBMIUWT
Sex
0
Female
StandardPopulation
TrueCity20-49
TrueCity20-49
SVYBMIUWT
Sex
0
Female
StandardPopulation
CountrySexSpecific20-49
CountrySexSpecific20-49
SVYBMIUWT
Sex
0
Female
StandardPopulation
SalurbalSexSpecific20-49
SalurbalSexSpecific20-49
SVYDBDX1
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYDBDX1
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYDBDX1
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYDBDX1
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYDBDX1
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYDBDX1
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYDBDX1
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYDBDX1
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYDBDX1
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYDBDX1
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYDBDX1
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYDBDX1
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYDBDX1
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYDBDX2
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYDBDX2
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYDBDX2
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYDBDX2
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYDBDX2
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYHLTHFP
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYHLTHFP
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYHLTHFP
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYHLTHFP
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYHLTHFP
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYHLTHFP
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYHLTHFP
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYHLTHFP
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYHLTHFP
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYHLTHFP
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYHLTHFP
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYHLTHFP
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYHLTHFP
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYHTMED
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYHTMED
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYHTMED
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYHTMED
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYHTMED
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYHTMED
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYHTMED
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYHTMED
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYHTMED
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYHTMED
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYHTMED
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYHTMED
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYHTMED
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYMAM2YRS
Sex
0
Female
StandardPopulation
TrueCity50-79
TrueCity50-79
SVYMAM2YRS
Sex
0
Female
StandardPopulation
CountrySexSpecific50-79
CountrySexSpecific50-79
SVYMAM2YRS
Sex
0
Female
StandardPopulation
SalurbalSexSpecific50-79
SalurbalSexSpecific50-79
SVYMAM2YRS
Sex
0
Female
StandardPopulation
RateBasedOnSample50-59,NoPopStd
RateBasedOnSample50-59,NoPopStd
SVYPAP3YRS
Sex
0
Female
StandardPopulation
TrueCity25-49
TrueCity25-49
SVYPAP3YRS
Sex
0
Female
StandardPopulation
CountrySexSpecific25-49
CountrySexSpecific25-49
SVYPAP3YRS
Sex
0
Female
StandardPopulation
SalurbalSexSpecific25-49
SalurbalSexSpecific25-49
SVYPAP3YRS
Sex
0
Female
StandardPopulation
TrueCity30-49
TrueCity30-49
SVYPAP3YRS
Sex
0
Female
StandardPopulation
CountrySexSpecific30-49
CountrySexSpecific30-49
SVYPAP3YRS
Sex
0
Female
StandardPopulation
SalurbalSexSpecific30-49
SalurbalSexSpecific30-49
SVYSMKCUR
Sex
9
Overall
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYSMKCUR
Sex
9
Overall
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYSMKCUR
Sex
9
Overall
StandardPopulation
TrueCity
TrueCity
SVYSMKCUR
Sex
0
Female
StandardPopulation
CountrySexSpecific
CountrySexSpecific
SVYSMKCUR
Sex
0
Female
StandardPopulation
TrueCity
TrueCity
SVYSMKCUR
Sex
0
Female
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYSMKCUR
Sex
0
Female
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYSMKCUR
Sex
0
Female
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYSMKCUR
Sex
1
Male
StandardPopulation
SalurbalSexPooled
SalurbalSexPooled
SVYSMKCUR
Sex
1
Male
StandardPopulation
CountrySexPooled
CountrySexPooled
SVYSMKCUR
Sex
1
Male
StandardPopulation
SalurbalSexSpecific
SalurbalSexSpecific
SVYSMKCUR
Sex
1
Male
StandardPopulation
TrueCity
TrueCity
SVYSMKCUR
Sex
1
Male
StandardPopulation
CountrySexSpecific
CountrySexSpecific

linkage.csv is a table that describes how the linkage for each of the codebook fields. Starting with this template (📥 linkage.csv), for each codebook field (row) you should write a value of ‘1’ in the column cells if any variable falls under that linkage type.

All codebook fields are linkable only by_variable for the APS dataset so we for all codebook fields we only check (fill out the cell as ‘1’) the by_var column.

field
by_var
by_var_iso2
by_var_year
by_var_strata
dataset_id
1
​
​
​
domain
1
​
​
​
subdomain
1
​
​
​
var_label
1
​
​
​
var_def
1
​
​
​
value_type
1
​
​
​
units
1
​
​
​
coding
1
​
​
​
strata_description
1
​
​
​
source
1
​
​
​
dataset_notes
1
​
​
​
limitations
1
​
​
​
acknowledgements
1
​
​
​
file
1
​
​
​
longitudinal
1
​
​
​
public
1
​
​
​
censor
1
​
​
​
license
1
​
​
​
fair
1
​
​
​

Most of the codebook fields in the CNS dataset are linkable only be variable except for:

  • source vary by var_name+iso2 for some variables but other do not for other variables; so this row has both by_var and by_var_iso2 filled out.
field
by_var
by_var_iso2
by_var_year
by_var_strata
dataset_id
1
​
​
​
domain
1
​
​
​
subdomain
1
​
​
​
var_label
1
​
​
​
var_def
1
​
​
​
value_type
1
​
​
​
units
1
​
​
​
coding
1
​
​
​
strata_description
1
​
​
​
source
1
1
​
​
dataset_notes
1
​
​
​
limitations
1
​
​
​
acknowledgements
1
​
​
​
file
1
​
​
​
longitudinal
1
​
​
​
public
1
​
​
​
censor
1
​
​
​
license
1
​
​
​
fair
1
​
​
​

Most of the codebook fields in the SVY dataset are linkable only be variable except for:

  • var_def vary by var_name+strata for some variables but other do not for other variables; so this row has both by_var and by_var_strata filled out.
  • source vary by var_name+iso2 for some variables but other do not for other variables; so this row has both by_var and by_var_iso2 filled out.
field
by_var
by_var_iso2
by_var_year
by_var_strata
dataset_id
1
​
​
​
domain
1
​
​
​
subdomain
1
​
​
​
var_label
1
​
​
​
var_def
1
​
​
1
value_type
1
​
​
​
units
1
​
​
​
coding
1
​
​
​
strata_description
1
​
​
​
source
1
1
​
​
dataset_notes
1
​
​
​
limitations
1
​
​
​
acknowledgements
1
​
​
​
file
1
​
​
​
longitudinal
1
​
​
​
public
1
​
​
​
censor
1
​
​
​
license
1
​
​
​
fair
1
​
​
​

For each data set review the metadta linkage evaluation. For each unique linkage that is present in your dataset you will need to prepare the assosiated codebook. The thought process and deliverables for our three example datasets can be seen below.

Based on the APS codebook evaluation we saw that all the metadata are categorized as simple; therefor our step -4-codebooks deliverable for this dataset contains one file - codebook_simple.csv

var_name
domain
subdomain
var_label
var_def
value_type
units
coding
interpretation
strata_description
source
dataset_notes
limitations
acknowledgment
file
working_group
longitudinal
public
censor
fair
APSPM25GRIDPTS
Physical and Natural Enviro...
Air Pollution
Number of PM2.5 grid point ...
Number of grid point centro...
​
​
999998 = No data available
A higher number indicates m...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0
APSPM25MEAN
Physical and Natural Enviro...
Air Pollution
Average PM2.5 concentration
Arithmetic mean of PM2.5 me...
​
micromilligrams per cubic m...
999998 = No data available
A higher value indicates hi...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0
APSPM25STD
Physical and Natural Enviro...
Air Pollution
Standard Deviation of PM2.5
Standard deviation of PM2.5...
​
micromilligrams per cubic m...
999998 = No data available
A higher value indictates m...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0
APSPM25MEDIAN
Physical and Natural Enviro...
Air Pollution
Median PM2.5 concentration
Median of PM2.5 measurement...
​
micromilligrams per cubic m...
999998 = No data available
A higher value indicates hi...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0
APSPM25THRES
Physical and Natural Enviro...
Air Pollution
Average PM2.5 is above WHO ...
Indicator if the average PM...
​
​
0=10 or less 1=Greater tha...
A value of 1 indicates the ...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0
APSNO2GRIDPTS
Physical and Natural Enviro...
Air Pollution
Number of NO2 grid point ce...
Number of grid point centro...
​
​
999998 = No data available
A higher number indicates m...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0
APSNO2MEAN
Physical and Natural Enviro...
Air Pollution
Area-weighted average NO2
Weighted arithmetic mean of...
​
parts per billion (ppb)
999998 = No data available
A higher value indicates hi...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0
APSNO2STD
Physical and Natural Enviro...
Air Pollution
Area-weighted Standard Devi...
Weighted standard deviation...
​
parts per billion (ppb)
999998 = No data available
A higher value indictates m...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0
APSNO2MEDIAN
Physical and Natural Enviro...
Air Pollution
Area-weighted median NO2
Weighted median of NO2 meas...
​
parts per billion (ppb)
999998 = No data available
A higher value indicates hi...
​
Atmospheric Composition Ana...
​
​
Citation: Hammer, M. S.; et...
raw-data/physical environme...
Climate - UHC
TRUE
1
FALSE
0

Based on the CNS codebook evaluation we saw:

  • 17 simple fields
  • 2 by_country fields (source, public)

Therefore we need to prepare two codebooks for this dataset (see below).

var_name
domain
subdomain
var_label
var_def
value_type
units
coding
interpretation
strata_description
dataset_notes
limitations
acknowledgment
file
working_group
longitudinal
censor
fair
CNSCROWD25BR
Social, Economic, and Servi...
Housing
Overcrowding: Proportion of...
Overcrowding: Proportion of...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSCROWD3RM
Social, Economic, and Servi...
Housing
Overcrowding: Proportion o...
Overcrowding: Proportion o...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSFLOOR
Social, Economic, and Servi...
Housing
Proportion of dwellings wit...
Proportion of dwellings wit...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSLABFEM
Social, Economic, and Servi...
Employment
The proportion of the total...
The proportion of the total...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSLABPART
Social, Economic, and Servi...
Employment
The labor force participati...
The labor force participati...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSLABPART
Social, Economic, and Servi...
Employment
The labor force participati...
The labor force participati...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSLABPART
Social, Economic, and Servi...
Employment
The labor force participati...
The labor force participati...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSLABPART
Social, Economic, and Servi...
Employment
The ratio of the labor forc...
The ratio of the labor forc...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINHS
Social, Economic, and Servi...
Education
Proportion of the populatio...
Proportion of the populatio...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINHS
Social, Economic, and Servi...
Education
Proportion of the male popu...
Proportion of the male popu...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINHS
Social, Economic, and Servi...
Education
Proportion of the female po...
Proportion of the female po...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINHS
Social, Economic, and Servi...
Education
The ratio of the female to ...
The ratio of the female to ...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINPR
Social, Economic, and Servi...
Education
Proportion of the populatio...
Proportion of the populatio...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINPR
Social, Economic, and Servi...
Education
Proportion of the male popu...
Proportion of the male popu...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINPR
Social, Economic, and Servi...
Education
Proportion of the female po...
Proportion of the female po...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINUN
Social, Economic, and Servi...
Education
Proportion of the populatio...
Proportion of the populatio...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINUN
Social, Economic, and Servi...
Education
Proportion of the male popu...
Proportion of the male popu...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSMINUN
Social, Economic, and Servi...
Education
Proportion of the female po...
Proportion of the female po...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSSEWANY
Social, Economic, and Servi...
Housing
Proportion of households co...
Proportion of households co...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSSEWNET
Social, Economic, and Servi...
Housing
Proportion of households co...
Proportion of households co...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSST1517
Social, Economic, and Servi...
Education
Proportion of the populatio...
Proportion of the populatio...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSST1517
Social, Economic, and Servi...
Education
Proportion of the male popu...
Proportion of the male popu...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSST1517
Social, Economic, and Servi...
Education
Proportion of the female po...
Proportion of the female po...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSST1517
Social, Economic, and Servi...
Education
The ratio of the proportion...
The ratio of the proportion...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSUNEMP
Social, Economic, and Servi...
Employment
The unemployment rate among...
The unemployment rate among...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSUNEMP
Social, Economic, and Servi...
Employment
The unemployment rate among...
The unemployment rate among...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSUNEMP
Social, Economic, and Servi...
Employment
The unemployment rate among...
The unemployment rate among...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSUNEMP
Social, Economic, and Servi...
Employment
The ratio of the unemployme...
The ratio of the unemployme...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSWALLDUR1
Social, Economic, and Servi...
Housing
Proportion of dwellings wit...
Proportion of dwellings wit...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSWALLDUR2
Social, Economic, and Servi...
Housing
Proportion of dwellings wit...
Proportion of dwellings wit...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSWALLDUR3
Social, Economic, and Servi...
Housing
Proportion of dwellings wit...
Proportion of dwellings wit...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSWATIN
Social, Economic, and Servi...
Housing
Proportion of households wi...
Proportion of households wi...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSWATNET
Social, Economic, and Servi...
Housing
Proportion of households wi...
Proportion of households wi...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
CNSWATPIPE
Social, Economic, and Servi...
Housing
Proportion of households wi...
Proportion of households wi...
​
​
​
​
​
​
​
​
raw-data/SEC/Codebook_SEC_C...
Climate - UHC
​
​
0
var_name
iso2
public
source
CNSCROWD25BR
BR
1
​
CNSCROWD25BR
CL
0
​
CNSCROWD25BR
PE
1
​
CNSCROWD3RM
BR
1
​
CNSCROWD3RM
CL
0
​
CNSCROWD3RM
PE
1
​
CNSFLOOR
BR
1
​
CNSFLOOR
CL
0
​
CNSFLOOR
PE
1
​
CNSLABFEM
BR
1
​
CNSLABFEM
CL
0
​
CNSLABFEM
PE
1
​
CNSLABPART
BR
1
​
CNSLABPART
CL
0
​
CNSLABPART
PE
1
​
CNSLABPART
BR
1
​
CNSLABPART
CL
0
​
CNSLABPART
PE
1
​
CNSLABPART
BR
1
​
CNSLABPART
CL
0
​
CNSLABPART
PE
1
​
CNSLABPART
BR
1
​
CNSLABPART
CL
0
​
CNSLABPART
PE
1
​
CNSMINHS
BR
1
​
CNSMINHS
CL
0
​
CNSMINHS
PE
1
​
CNSMINHS
BR
1
​
CNSMINHS
CL
0
​
CNSMINHS
PE
1
​
CNSMINHS
BR
1
​
CNSMINHS
CL
0
​
CNSMINHS
PE
1
​
CNSMINHS
BR
1
​
CNSMINHS
CL
0
​
CNSMINHS
PE
1
​
CNSMINPR
BR
1
​
CNSMINPR
CL
0
​
CNSMINPR
PE
1
​
CNSMINPR
BR
1
​
CNSMINPR
CL
0
​
CNSMINPR
PE
1
​
CNSMINPR
BR
1
​
CNSMINPR
CL
0
​
CNSMINPR
PE
1
​
CNSMINUN
BR
1
​
CNSMINUN
CL
0
​
CNSMINUN
PE
1
​
CNSMINUN
BR
1
​
CNSMINUN
CL
0
​
CNSMINUN
PE
1
​
CNSMINUN
BR
1
​
CNSMINUN
CL
0
​
CNSMINUN
PE
1
​
CNSSEWANY
BR
1
​
CNSSEWANY
CL
0
​
CNSSEWANY
PE
1
​
CNSSEWNET
BR
1
​
CNSSEWNET
CL
0
​
CNSSEWNET
PE
1
​
CNSST1517
BR
1
​
CNSST1517
CL
0
​
CNSST1517
PE
1
​
CNSST1517
BR
1
​
CNSST1517
CL
0
​
CNSST1517
PE
1
​
CNSST1517
BR
1
​
CNSST1517
CL
0
​
CNSST1517
PE
1
​
CNSST1517
BR
1
​
CNSST1517
CL
0
​
CNSST1517
PE
1
​
CNSUNEMP
BR
1
​
CNSUNEMP
CL
0
​
CNSUNEMP
PE
1
​
CNSUNEMP
BR
1
​
CNSUNEMP
CL
0
​
CNSUNEMP
PE
1
​
CNSUNEMP
BR
1
​
CNSUNEMP
CL
0
​
CNSUNEMP
PE
1
​
CNSUNEMP
BR
1
​
CNSUNEMP
CL
0
​
CNSUNEMP
PE
1
​
CNSWALLDUR1
BR
1
​
CNSWALLDUR1
CL
0
​
CNSWALLDUR1
PE
1
​
CNSWALLDUR2
BR
1
​
CNSWALLDUR2
CL
0
​
CNSWALLDUR2
PE
1
​
CNSWALLDUR3
BR
1
​
CNSWALLDUR3
CL
0
​
CNSWALLDUR3
PE
1
​
CNSWATIN
BR
1
​
CNSWATIN
CL
0
​
CNSWATIN
PE
1
​
CNSWATNET
BR
1
​
CNSWATNET
CL
0
​
CNSWATNET
PE
1
​
CNSWATPIPE
BR
1
​
CNSWATPIPE
CL
0
​
CNSWATPIPE
PE
1
​

Based on the SVY codebook evaluation we saw:

  • 15 simple fields
  • 2 by_country fields (source, public, censor)
  • 2 by_strata (var_def, interpretation)

Therefore we need to prepare three codebooks for this dataset (see below).

var_name
domain
subdomain
var_label
value_type
units
coding
strata_description
dataset_notes
limitations
acknowledgment
file
working_group
longitudinal
censor
fair
SVYDBDX1
Health Risk Factors
Diabetes
Prevelance Estimate for Dia...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYDBDX2
Health Risk Factors
Diabetes
Prevalence Estimate for Dia...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYHTMED
Health Risk Factors
Hypertension
Prevalence Estimate for Cur...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYBMIOBESE
Health Risk Factors
Anthropometry
Prevelence Estimate for Obe...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYBMISOBESE
Health Risk Factors
Anthropometry
Prevelence Estimate for Obe...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYBMIOVOB
Health Risk Factors
Anthropometry
Prevalence Estimate for Ove...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYBMISOVOB
Health Risk Factors
Anthropometry
Prevalence Estimate for Ove...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYBMIUWT
Health Risk Factors
Anthropometry
Prevalence Estimate for Und...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYBMISUWT
Health Risk Factors
Anthropometry
Prevalence Estimate for Und...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYHLTHFP
Health Risk Factors
Health Status
Prevalence Estimate for Sel...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYSMKCUR
Health Risk Factors
Tobacco Use
Prevalence Estimate for Cur...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYPAP3YRS
Health Risk Factors
Health Care
Prevalence Estimate for Pap...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
SVYMAM2YRS
Health Risk Factors
Health Care
Prevalence Estimate for Mam...
​
​
​
​
​
​
​
raw-data/health mortality/h...
Climate - UHC
​
​
0
var_name
iso2
public
source
SVYDBDX1
BR
1
​
SVYDBDX1
CL
0
​
SVYDBDX1
PE
1
​
SVYDBDX2
BR
1
​
SVYDBDX2
CL
0
​
SVYDBDX2
PE
1
​
SVYHTMED
BR
1
​
SVYHTMED
CL
0
​
SVYHTMED
PE
1
​
SVYBMIOBESE
BR
1
​
SVYBMIOBESE
CL
0
​
SVYBMIOBESE
PE
1
​
SVYBMISOBESE
BR
1
​
SVYBMISOBESE
CL
0
​
SVYBMISOBESE
PE
1
​
SVYBMIOVOB
BR
1
​
SVYBMIOVOB
CL
0
​
SVYBMIOVOB
PE
1
​
SVYBMISOVOB
BR
1
​
SVYBMISOVOB
CL
0
​
SVYBMISOVOB
PE
1
​
SVYBMIUWT
BR
1
​
SVYBMIUWT
CL
0
​
SVYBMIUWT
PE
1
​
SVYBMISUWT
BR
1
​
SVYBMISUWT
CL
0
​
SVYBMISUWT
PE
1
​
SVYHLTHFP
BR
1
​
SVYHLTHFP
CL
0
​
SVYHLTHFP
PE
1
​
SVYSMKCUR
BR
1
​
SVYSMKCUR
CL
0
​
SVYSMKCUR
PE
1
​
SVYPAP3YRS
BR
1
​
SVYPAP3YRS
CL
0
​
SVYPAP3YRS
PE
1
​
SVYMAM2YRS
BR
1
​
SVYMAM2YRS
CL
0
​
SVYMAM2YRS
PE
1
​
var_name
strata_id
var_def
interpretation
SVYDBDX1
sex_male_stdPop_30
Prevelance Estimate for Dia...
​
SVYDBDX1
sex_female_stdPop_30
Prevelance Estimate for Dia...
​
SVYDBDX1
sex_male_stdPop_60
Prevelance Estimate for Dia...
​
SVYDBDX1
sex_female_stdPop_60
Prevelance Estimate for Dia...
​
SVYDBDX2
sex_male_stdPop_30
Prevalence Estimate for Dia...
​
SVYDBDX2
sex_female_stdPop_30
Prevalence Estimate for Dia...
​
SVYDBDX2
sex_male_stdPop_60
Prevalence Estimate for Dia...
​
SVYDBDX2
sex_female_stdPop_60
Prevalence Estimate for Dia...
​
SVYHTMED
sex_male_stdPop_30
Prevalence Estimate for Cur...
​
SVYHTMED
sex_female_stdPop_30
Prevalence Estimate for Cur...
​
SVYHTMED
sex_male_stdPop_60
Prevalence Estimate for Cur...
​
SVYHTMED
sex_female_stdPop_60
Prevalence Estimate for Cur...
​
SVYBMIOBESE
sex_male_stdPop_30
Prevelence Estimate for Obe...
​
SVYBMIOBESE
sex_female_stdPop_30
Prevelence Estimate for Obe...
​
SVYBMIOBESE
sex_male_stdPop_60
Prevelence Estimate for Obe...
​
SVYBMIOBESE
sex_female_stdPop_60
Prevelence Estimate for Obe...
​
SVYBMISOBESE
sex_male_stdPop_30
Prevelence Estimate for Obe...
​
SVYBMISOBESE
sex_female_stdPop_30
Prevelence Estimate for Obe...
​
SVYBMISOBESE
sex_male_stdPop_60
Prevelence Estimate for Obe...
​
SVYBMISOBESE
sex_female_stdPop_60
Prevelence Estimate for Obe...
​
SVYBMIOVOB
sex_male_stdPop_30
Prevalence Estimate for Ove...
​
SVYBMIOVOB
sex_female_stdPop_30
Prevalence Estimate for Ove...
​
SVYBMIOVOB
sex_male_stdPop_60
Prevalence Estimate for Ove...
​
SVYBMIOVOB
sex_female_stdPop_60
Prevalence Estimate for Ove...
​
SVYBMISOVOB
sex_male_stdPop_30
Prevalence Estimate for Ove...
​
SVYBMISOVOB
sex_female_stdPop_30
Prevalence Estimate for Ove...
​
SVYBMISOVOB
sex_male_stdPop_60
Prevalence Estimate for Ove...
​
SVYBMISOVOB
sex_female_stdPop_60
Prevalence Estimate for Ove...
​
SVYBMIUWT
sex_male_stdPop_30
Prevalence Estimate for Und...
​
SVYBMIUWT
sex_female_stdPop_30
Prevalence Estimate for Und...
​
SVYBMIUWT
sex_male_stdPop_60
Prevalence Estimate for Und...
​
SVYBMIUWT
sex_female_stdPop_60
Prevalence Estimate for Und...
​
SVYBMISUWT
sex_male_stdPop_30
Prevalence Estimate for Und...
​
SVYBMISUWT
sex_female_stdPop_30
Prevalence Estimate for Und...
​
SVYBMISUWT
sex_male_stdPop_60
Prevalence Estimate for Und...
​
SVYBMISUWT
sex_female_stdPop_60
Prevalence Estimate for Und...
​
SVYHLTHFP
sex_male_stdPop_30
Prevalence Estimate for Sel...
​
SVYHLTHFP
sex_female_stdPop_30
Prevalence Estimate for Sel...
​
SVYHLTHFP
sex_male_stdPop_60
Prevalence Estimate for Sel...
​
SVYHLTHFP
sex_female_stdPop_60
Prevalence Estimate for Sel...
​
SVYSMKCUR
sex_male_stdPop_30
Prevalence Estimate for Cur...
​
SVYSMKCUR
sex_female_stdPop_30
Prevalence Estimate for Cur...
​
SVYSMKCUR
sex_male_stdPop_60
Prevalence Estimate for Cur...
​
SVYSMKCUR
sex_female_stdPop_60
Prevalence Estimate for Cur...
​
SVYPAP3YRS
sex_male_stdPop_30
Prevalence Estimate for Pap...
​
SVYPAP3YRS
sex_female_stdPop_30
Prevalence Estimate for Pap...
​
SVYPAP3YRS
sex_male_stdPop_60
Prevalence Estimate for Pap...
​
SVYPAP3YRS
sex_female_stdPop_60
Prevalence Estimate for Pap...
​
SVYMAM2YRS
sex_male_stdPop_30
Prevalence Estimate for Mam...
​
SVYMAM2YRS
sex_female_stdPop_30
Prevalence Estimate for Mam...
​
SVYMAM2YRS
sex_male_stdPop_60
Prevalence Estimate for Mam...
​
SVYMAM2YRS
sex_female_stdPop_60
Prevalence Estimate for Mam...
​

For each dataset you should have a data.csv as a deliverable

aps_data.csv

var_name
iso2
strata_id
value
geo
salid1
year
strata_1_name
strata_1_value
strata_2_name
strata_2_value
file
APSNO2MEDIAN
BR
​
999998
L1AD
562262
2017
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEAN
BR
​
0.2181460636
L1AD
562835
2010
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEAN
MX
​
0.4418814243
L1AD
328185
2006
​
​
​
​
APSL1AD_02152022.csv
APSPM25GRIDPTS
MX
​
6120
L1AD
328663
2010
​
​
​
​
APSL1AD_02152022.csv
APSNO2GRIDPTS
MX
​
999998
L1AD
328686
2017
​
​
​
​
APSL1AD_02152022.csv
APSPM25STD
MX
​
999998
L1AD
328464
1997
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEDIAN
BR
​
17
L1AD
562726
2004
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEAN
MX
​
18.836308795
L1AD
328991
1999
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEDIAN
CL
​
8.1999998093
L1AD
278757
1998
​
​
​
​
APSL1AD_02152022.csv
APSPM25GRIDPTS
BR
​
9372
L1AD
562402
2009
​
​
​
​
APSL1AD_02152022.csv
APSNO2STD
BR
​
999998
L1AD
562640
2016
​
​
​
​
APSL1AD_02152022.csv
APSNO2STD
MX
​
999998
L1AD
328940
2020
​
​
​
​
APSL1AD_02152022.csv
APSNO2GRIDPTS
BR
​
14
L1AD
562939
1999
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEDIAN
CO
​
16.299999237
L1AD
625504
2018
​
​
​
​
APSL1AD_02152022.csv
APSPM25GRIDPTS
CO
​
8832
L1AD
625968
2010
​
​
​
​
APSL1AD_02152022.csv
APSPM25STD
BR
​
3.8878411133
L1AD
562397
2015
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEAN
CO
​
0.3194525196
L1AD
625896
2005
​
​
​
​
APSL1AD_02152022.csv
APSPM25THRES
PE
​
1
L1AD
294456
2009
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEAN
BR
​
18.089824064
L1AD
562878
2016
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEAN
CL
​
0.1766634207
L1AD
278437
2002
​
​
​
​
APSL1AD_02152022.csv
APSPM25GRIDPTS
AR
​
168024
L1AD
514103
2012
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEAN
BR
​
12.088406531
L1AD
562159
2003
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEDIAN
BR
​
0.0949768048
L1AD
562549
2011
​
​
​
​
APSL1AD_02152022.csv
APSNO2STD
CO
​
999998
L1AD
625121
2013
​
​
​
​
APSL1AD_02152022.csv
APSPM25STD
CL
​
11.537632428
L1AD
278909
2018
​
​
​
​
APSL1AD_02152022.csv
APSNO2STD
BR
​
0.0537869197
L1AD
562464
2007
​
​
​
​
APSL1AD_02152022.csv
APSNO2GRIDPTS
BR
​
999998
L1AD
562774
2020
​
​
​
​
APSL1AD_02152022.csv
APSNO2GRIDPTS
CL
​
999998
L1AD
278157
2016
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEDIAN
BR
​
10.199999809
L1AD
562826
2000
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEAN
CO
​
18.373456233
L1AD
625742
2014
​
​
​
​
APSL1AD_02152022.csv
APSPM25GRIDPTS
MX
​
50796
L1AD
328457
2017
​
​
​
​
APSL1AD_02152022.csv
APSPM25GRIDPTS
PE
​
4656
L1AD
294160
2020
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEDIAN
BR
​
0.2588326035
L1AD
562891
2008
​
​
​
​
APSL1AD_02152022.csv
APSPM25STD
BR
​
2.1640789432
L1AD
562262
2008
​
​
​
​
APSL1AD_02152022.csv
APSNO2STD
CL
​
0.0849626704
L1AD
278246
1996
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEAN
MX
​
0.4935348088
L1AD
328585
2009
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEAN
BR
​
8.8657613855
L1AD
562728
2013
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEAN
BR
​
0.2757041702
L1AD
562526
2005
​
​
​
​
APSL1AD_02152022.csv
APSPM25STD
CL
​
21.773713561
L1AD
278315
1999
​
​
​
​
APSL1AD_02152022.csv
APSNO2STD
MX
​
999998
L1AD
328237
2017
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEAN
PE
​
18.111506788
L1AD
294558
2002
​
​
​
​
APSL1AD_02152022.csv
APSPM25GRIDPTS
AR
​
33996
L1AD
514523
1998
​
​
​
​
APSL1AD_02152022.csv
APSPM25STD
PE
​
7.9159363067
L1AD
294456
2004
​
​
​
​
APSL1AD_02152022.csv
APSNO2STD
MX
​
999998
L1AD
328165
2014
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEAN
BR
​
0.0680536596
L1AD
562442
2003
​
​
​
​
APSL1AD_02152022.csv
APSNO2MEAN
BR
​
0.5901720058
L1AD
562758
1998
​
​
​
​
APSL1AD_02152022.csv
APSNO2GRIDPTS
CL
​
999998
L1AD
278157
2018
​
​
​
​
APSL1AD_02152022.csv
APSNO2STD
BR
​
0.0676830016
L1AD
562170
2012
​
​
​
​
APSL1AD_02152022.csv
APSPM25MEAN
MX
​
7.6959494856
L1AD
328560
2003
​
​
​
​
APSL1AD_02152022.csv
APSNO2GRIDPTS
MX
​
57
L1AD
328380
1999
​
​
​
​
APSL1AD_02152022.csv

cns_data.csv

var_name
iso2
strata_id
value
geo
salid1
year
strata_1_name
strata_1_value
strata_2_name
strata_2_value
file
CNSST1517
MX
Sex_Overall
74.440863366
L1AD
328712
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
BR
Sex_Overall
83.236804484
L1AD
562349
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSLABPART
BR
Sex_Overall
61.056545239
L1AD
562178
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
BR
Sex_Female
87.298725266
L1AD
562320
2010
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSWALLDUR1
CO
​
64.818438
L1AD
625759
2005
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
BR
Sex_Female
83.249195517
L1AD
562925
2010
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSMINPR
BR
Sex_Overall
67.37358022
L1AD
562668
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSUNEMP
BR
Sex_Overall
3.0119026723
L1AD
562462
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSLABPART
BR
Sex_Ratio
0.7759829283
L1AD
562348
2010
Sex
Ratio
​
​
SEC_Census_L1AD_06232021.csv
CNSMINPR
MX
Sex_Female
81.541489013
L1AD
328826
2010
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSLABPART
CL
Sex_Ratio
0.584958017
L1AD
278206
2017
Sex
Ratio
​
​
SEC_Census_L1AD_06232021.csv
CNSWATPIPE
BR
​
99.740444545
L1AD
562922
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSLABFEM
BR
​
45.444070634
L1AD
562894
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSLABFEM
BR
​
46.158472311
L1AD
562699
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSLABPART
PE
Sex_Male
73.007082741
L1AD
294456
2007
Sex
Male
​
​
SEC_Census_L1AD_06232021.csv
CNSMINPR
PE
Sex_Female
72.507674821
L1AD
294282
2007
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSLABFEM
MX
​
33.762081831
L1AD
328375
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
CO
Sex_Female
85.793192
L1AD
625672
2018
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSWALLDUR3
BR
​
98.872624707
L1AD
562769
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSLABPART
BR
Sex_Overall
64.860144862
L1AD
562691
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSUNEMP
PE
Sex_Overall
3.8680568929
L1AD
294851
2007
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSLABFEM
PE
​
40.338969596
L1AD
294988
2017
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSMINPR
BR
Sex_Male
69.827584847
L1AD
562777
2010
Sex
Male
​
​
SEC_Census_L1AD_06232021.csv
CNSWALLDUR2
BR
​
99.086769464
L1AD
562406
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSWALLDUR3
BR
​
99.621010526
L1AD
562800
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSUNEMP
CO
Sex_Female
16.418812
L1AD
625687
2018
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSLABPART
PE
Sex_Male
75.76259231
L1AD
294825
2017
Sex
Male
​
​
SEC_Census_L1AD_06232021.csv
CNSMINPR
BR
Sex_Overall
43.29807087
L1AD
562333
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSWATNET
MX
​
89.810292861
L1AD
328539
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSCROWD3RM
AR
​
5.4603809762
L1AD
514178
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
BR
Sex_Female
82.205185002
L1AD
562939
2010
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSMINPR
CO
Sex_Female
77.20615
L1AD
625968
2005
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSWALLDUR3
CO
​
99.88421
L1AD
625555
2018
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
BR
Sex_Overall
85.669953993
L1AD
562922
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSWALLDUR3
NI
​
82.036815304
L1AD
343574
2005
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSUNEMP
MX
Sex_Male
2.7973111118
L1AD
328165
2010
Sex
Male
​
​
SEC_Census_L1AD_06232021.csv
CNSLABPART
BR
Sex_Overall
61.075840111
L1AD
562559
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSMINHS
AR
Sex_Female
39.029172719
L1AD
514947
2010
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSFLOOR
PE
​
73.564796735
L1AD
294851
2017
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
BR
Sex_Male
82.286030383
L1AD
562348
2010
Sex
Male
​
​
SEC_Census_L1AD_06232021.csv
CNSLABPART
MX
Sex_Ratio
0.6008378247
L1AD
328135
2010
Sex
Ratio
​
​
SEC_Census_L1AD_06232021.csv
CNSWATIN
BR
​
97.871115833
L1AD
562392
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSWATNET
BR
​
90.018136181
L1AD
562633
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSWATIN
BR
​
88.368869028
L1AD
562707
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSMINPR
AR
Sex_Female
82.270200361
L1AD
514609
2010
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
MX
Sex_Overall
72.157749515
L1AD
328562
2010
Sex
Overall
​
​
SEC_Census_L1AD_06232021.csv
CNSST1517
CL
Sex_Female
97.169811321
L1AD
278494
2017
Sex
Female
​
​
SEC_Census_L1AD_06232021.csv
CNSUNEMP
AR
Sex_Ratio
2.3114632593
L1AD
514178
2010
Sex
Ratio
​
​
SEC_Census_L1AD_06232021.csv
CNSWALLDUR2
BR
​
99.37355531
L1AD
562925
2010
​
​
​
​
SEC_Census_L1AD_06232021.csv
CNSUNEMP
BR
Sex_Ratio
2.3194572795
L1AD
562948
2010
Sex
Ratio
​
​
SEC_Census_L1AD_06232021.csv

svy_data.csv

var_name
iso2
strata_id
value
geo
salid1
year
strata_1_name
strata_1_value
strata_2_name
strata_2_value
file
SVYBMIUWT
CO
Sex_Overall_Standard Population_True City
0.0443426132900725
L1AD
625158
2010
Sex
Overall
Standard Population
True City
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
CL
Sex_Male_Standard Population_Country Sex Specific
0.300370494740239
L1AD
278206
2017
Sex
Male
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYSMKCUR
MX
Sex_Female_Standard Population_Salurbal Sex Pooled
0.0579749334632633
L1AD
328408
2018
Sex
Female
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIOVOB
MX
Sex_Male_Standard Population_Salurbal Sex Pooled
0.781151333228552
L1AD
328560
2018
Sex
Male
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYHTMED
BR
Sex_Male_Standard Population_Salurbal Sex Specific
0.0809134037484001
L1AD
562839
2013
Sex
Male
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYBMIOVOB
MX
Sex_Female_Standard Population_Salurbal Sex Specific
0.757643051751982
L1AD
328527
2012
Sex
Female
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYHTMED
MX
Sex_Female_Standard Population_Country Sex Specific
0.124958510161609
L1AD
328581
2012
Sex
Female
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYHTMED
MX
Sex_Overall_Standard Population_Salurbal Sex Pooled
0.140930386550267
L1AD
328196
2016
Sex
Overall
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIOVOB
MX
Sex_Female_Standard Population_Salurbal Sex Specific 20-49
0.735672803032523
L1AD
328594
2012
Sex
Female
Standard Population
Salurbal Sex Specific 20-49
adult_survey_prevalence_city_02222022.csv
SVYHTMED
MX
Sex_Female_Standard Population_Salurbal Sex Pooled
0.128274752898498
L1AD
328600
2012
Sex
Female
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
MX
Sex_Female_Standard Population_Country Sex Specific 20-49
0.379377569147745
L1AD
328310
2006
Sex
Female
Standard Population
Country Sex Specific 20-49
adult_survey_prevalence_city_02222022.csv
SVYBMIUWT
MX
Sex_Female_Standard Population_True City
0.0112954762268946
L1AD
328663
2012
Sex
Female
Standard Population
True City
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
CL
Sex_Male_Standard Population_Salurbal Sex Specific
0.195211045263653
L1AD
278939
2010
Sex
Male
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYSMKCUR
MX
Sex_Overall_Standard Population_Salurbal Sex Pooled
0.178975851818086
L1AD
328443
2018
Sex
Overall
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
CL
Sex_Male_Standard Population_Salurbal Sex Pooled
0.211998912982238
L1AD
278138
2003
Sex
Male
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIUWT
MX
Sex_Female_Standard Population_Salurbal Sex Pooled
0.0121822063380611
L1AD
328928
2018
Sex
Female
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYDBDX1
CL
Sex_Female_Standard Population_Salurbal Sex Specific
0.0772112849388255
L1AD
278246
2010
Sex
Female
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
CO
Sex_Overall_Standard Population_Salurbal Sex Pooled
0.223081789306237
L1AD
625742
2010
Sex
Overall
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIUWT
PE
Sex_Female_Standard Population_Salurbal Sex Specific
0.00780761913556795
L1AD
294282
2016
Sex
Female
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYHTMED
MX
Sex_Female_Standard Population_True City
0.120191902951536
L1AD
328725
2016
Sex
Female
Standard Population
True City
adult_survey_prevalence_city_02222022.csv
SVYMAM2YRS
BR
Sex_Female_Standard Population_True City 50-79
0.507012837423006
L1AD
562839
2013
Sex
Female
Standard Population
True City 50-79
adult_survey_prevalence_city_02222022.csv
SVYHTMED
CL
Sex_Overall_Standard Population_True City
0.135021690933263
L1AD
278449
2003
Sex
Overall
Standard Population
True City
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
MX
Sex_Female_Standard Population_True City
0.345991583953327
L1AD
328776
2006
Sex
Female
Standard Population
True City
adult_survey_prevalence_city_02222022.csv
SVYBMIOVOB
MX
Sex_Male_Standard Population_Salurbal Sex Specific
0.680461561558253
L1AD
328240
2006
Sex
Male
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYBMIOVOB
CO
Sex_Female_Standard Population_Country Sex Specific
0.424922819821468
L1AD
625983
2007
Sex
Female
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYSMKCUR
MX
Sex_Overall_Standard Population_True City
0.15337285913835
L1AD
328375
2012
Sex
Overall
Standard Population
True City
adult_survey_prevalence_city_02222022.csv
SVYHTMED
MX
Sex_Male_Standard Population_Salurbal Sex Pooled
0.0553920736046246
L1AD
328527
2006
Sex
Male
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIUWT
MX
Sex_Male_Standard Population_Salurbal Sex Specific
0.00962311289381109
L1AD
328520
2018
Sex
Male
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYBMIOVOB
BR
Sex_Male_Standard Population_Country Sex Specific
0.616635343898989
L1AD
562474
2013
Sex
Male
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYHTMED
AR
Sex_Overall_Standard Population_Salurbal Sex Pooled
0.122884465457916
L1AD
514983
2005
Sex
Overall
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYSMKCUR
AR
Sex_Female_Standard Population_Salurbal Sex Pooled
0.209425073394706
L1AD
514673
2013
Sex
Female
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYHTMED
CL
Sex_Female_Standard Population_Salurbal Sex Pooled
0.127972403790473
L1AD
278142
2003
Sex
Female
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYSMKCUR
CL
Sex_Male_Standard Population_Country Sex Specific
0.463612779120417
L1AD
278494
2003
Sex
Male
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYSMKCUR
MX
Sex_Female_Standard Population_Salurbal Sex Pooled
0.0955324593306429
L1AD
328826
2018
Sex
Female
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYDBDX1
BR
Sex_Male_Standard Population_Country Sex Specific
0.0558215799230648
L1AD
562684
2013
Sex
Male
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
MX
Sex_Male_Standard Population_Country Sex Specific
0.275668536441049
L1AD
328853
2006
Sex
Male
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYSMKCUR
BR
Sex_Male_Standard Population_Salurbal Sex Specific
0.205876122990375
L1AD
562176
2013
Sex
Male
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYBMIUWT
MX
Sex_Overall_Standard Population_Salurbal Sex Pooled
0.0129901197095651
L1AD
328185
2012
Sex
Overall
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMISOBESE
AR
Sex_Male_Standard Population_Salurbal Sex Pooled
0.182302930485782
L1AD
514383
2005
Sex
Male
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIUWT
CO
Sex_Male_Standard Population_True City
0.0306501215086076
L1AD
625995
2007
Sex
Male
Standard Population
True City
adult_survey_prevalence_city_02222022.csv
SVYDBDX1
MX
Sex_Female_Standard Population_Country Sex Pooled
0.10969991495047
L1AD
328853
2016
Sex
Female
Standard Population
Country Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
MX
Sex_Male_Standard Population_Salurbal Sex Pooled
0.267685417631157
L1AD
328306
2018
Sex
Male
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIOVOB
BR
Sex_Male_Standard Population_Salurbal Sex Pooled
0.62863285071423
L1AD
562633
2013
Sex
Male
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
MX
Sex_Overall_Standard Population_True City
0.317005607317163
L1AD
328884
2006
Sex
Overall
Standard Population
True City
adult_survey_prevalence_city_02222022.csv
SVYBMIOBESE
MX
Sex_Female_Standard Population_Country Sex Specific
0.42843597813536
L1AD
328478
2006
Sex
Female
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYBMIUWT
BR
Sex_Male_Standard Population_Country Sex Pooled
0.0193144387925586
L1AD
562915
2013
Sex
Male
Standard Population
Country Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYBMISUWT
AR
Sex_Overall_Standard Population_Salurbal Sex Pooled
0.0198957053720737
L1AD
514722
2013
Sex
Overall
Standard Population
Salurbal Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYDBDX1
CO
Sex_Male_Standard Population_Country Sex Pooled
0.0258043478269077
L1AD
625641
2007
Sex
Male
Standard Population
Country Sex Pooled
adult_survey_prevalence_city_02222022.csv
SVYSMKCUR
CL
Sex_Male_Standard Population_Country Sex Specific
0.407237681108777
L1AD
278494
2010
Sex
Male
Standard Population
Country Sex Specific
adult_survey_prevalence_city_02222022.csv
SVYBMIUWT
MX
Sex_Male_Standard Population_Salurbal Sex Specific
0.0122594837394782
L1AD
328488
2016
Sex
Male
Standard Population
Salurbal Sex Specific
adult_survey_prevalence_city_02222022.csv

Based on the SVY codebook evaluation we saw:

  • 15 simple fields
  • 2 by_country fields (source, public, censor)
  • 2 by_strata (var_def, interpretation)

Therefore we need to prepare three codebooks for this dataset (see below).

Deliverables summary

So for the three examples we provided here are the final deliverable files.

dataset
strata_summary.csv
metadata_evaluation.csv
data.csv
codebook_simple.csv
codebook_by_country.csv
codebook_by_strata.csv
codebook_by_year.csv
Air Pollution (APS)
x
x
x
x
​
​
​
SEC census (CNS)
x
x
x
x
x
​
​
Health Survey (SVY)
x
x
x
x
x
x
​