Page History
...
Variable Name | Variable Label | Type | Codelist/Controlled Terms | Core | Notes |
---|---|---|---|---|---|
STRTM1 | Stratum 1 | text | yearYEAR | Req | populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the left-most column in this example |
STRVAL1 | Stratum 1 Value | integer??text | Req | populate with the STRTM1 values in the source data (years 2000-2050 in this example) | |
STRTM2 | Stratum 2 | text | SexSEX | Cond | populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the first part of the second column concept in this example |
STRVAL2 | Stratum 2 Value | text | M;F | Cond | populate with the STRTM2 values in the source data (M/F in this example for displayed data) |
STRTM3 | Stratum 3 | text | RaceRACE | Cond | populate with the variable descriptor of one of the cell descriptors (either a row identifier or a column identifier) - the second part of the second column concept in this example |
STRVAL3 | Stratum 3 Value | text | TotalTOTAL;WhiteWHITE | Cond | populate with the STRTM3 values in the source data (Race in this example) |
INPRM | Input Parameter | text | BIRTH RATE | Req | populate with the concept describing the value in the cell being captured in the dataset. it may come from a spreadsheet tab name, a spreadsheet name, or any desired parameter indentifying value |
INPRMVAL | Input Parameter Value | float | Req | populate with the cell value from the referenced data that is being described by the STRMVALy values | |
INPRMU | Input Parameter Unit | text | RATIO / 10 PER 1000 | Perm | populate with the unit describing the cell values if appropriate |
...
REFSRCE | Reference Data Source | text | Perm | populate with the file that is the source of the reference data (the same columns and rows will change over time so identifying the source allows for traceability) |
---|
STRTM1 | STRVAL1 | STRTM2 | STRVAL2 | STRTM3 | STRVAL3 | INPRM | INPRMVAL | INPRMU |
---|
REFSRCE | |
---|---|
YEAR | 2000 |
SEX | F |
RACE |
TOTAL | BIRTH RATE | 0.048156602 | RATIO / 10 PER 1000 | birthrate 2015.xslx |
YEAR | 2001 |
SEX | F |
RACE |
TOTAL | BIRTH RATE | 0.050162384 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2002 |
SEX | F |
RACE |
TOTAL | BIRTH RATE | 0.049912072 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2003 |
SEX | F |
RACE |
TOTAL | BIRTH RATE | 0.049953214 | RATIO / 10 PER 1000 | birthrate 2015.xslx |
YEAR | 2004 |
SEX | F |
RACE |
TOTAL | BIRTH RATE | 0.050199534 | RATIO / 10 PER 1000 | birthrate 2015.xslx |
YEAR |
2005 |
SEX | M |
RACE |
TOTAL | BIRTH RATE | 0.050497803 | RATIO / 10 PER 1000 | birthrate 2015.xslx |
YEAR | 2001 |
SEX | M |
RACE |
TOTAL | BIRTH RATE | 0.052554053 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2002 |
SEX | M |
RACE |
TOTAL | BIRTH RATE | 0.052289152 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2003 |
SEX | M |
RACE |
TOTAL | BIRTH RATE | 0.052334712 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2004 |
SEX | M |
RACE |
TOTAL | BIRTH RATE | 0.052594772 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2000 |
SEX | F |
RACE |
WHITE | BIRTH RATE | 0.043829866 | RATIO / 10 PER 1000 | birthrate 2015.xslx |
YEAR | 2001 |
SEX | F |
RACE |
WHITE | BIRTH RATE | 0.04509937 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2002 |
SEX | F |
RACE |
WHITE | BIRTH RATE | 0.044711283 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2003 |
SEX | F |
RACE |
WHITE | BIRTH RATE | 0.044899939 | RATIO / 10 PER 1000 |
birthrate 2015.xslx | |
YEAR | 2004 |
SEX | F |
RACE |
WHITE | BIRTH RATE | 0.045284915 | RATIO / 10 PER 1000 | birthrate 2015.xslx |
Overview
Content Tools