National Health and Nutrition Database


The exercises use a very simple database, derived from data collected through the US National Health and Nutrition Survey.

The exercise database is available in MS Access format and can be downloaded here.

The database contains a single table of data with 8 columns (variables) and 31311 rows (records). The first few records in the table are shown below:



Each record in the table contains information from a single person. The variables are defined as follows:


variable name variable definition
rseqn

Respondent identification number
Each person (record) in this table is identified by a unique identification number.

fseqn

Family sequence number
Families that persons belong to have unique identification numbers. Persons from the same family have the same family sequence number.

ethn

Ethnicity is coded with a single character. The following codes are used:
W = White; B = Black; H = Hispanic; O = Other

sex

Sex is coded with a single character. The following codes are used:
M = Male; F = Female

age Age at interview. Depending on the age unit, these integer values represent either months or years.
ageunit

Age unit is coded with a single character. The following codes are used:
M = Months; Y = Years
The code in this field determines whether the value in the age field represents months or years.

weight

Weight (kg) (2 months and over)
Weight is measured in kg with two decimal places. Only persons aged 2 months and above were measured.

height

Standing height (cm) (2 years and over)
Height is measured in cm with one decimal place. Only persons aged 2 years and above were measured.


Last modified February 8, 2008 5:01 am