Skip Main Navigation Skip To Navigation Content

Current Population Survey (CPS)

Skip top of page navigation
You are here: Census.gov People and Households Current Population Survey (CPS) MainData › Tool Options

Tool Options

  1. Year(s) of Data
  2. Filters/Subsets
  3. Define Your Table
  4. Variables
  5. Statistics
  6. Age Range Formats
  7. Missing Values

Year(s) of Data  back to top
  • The following two bullets represent changes to CPS Table Creator effective on February 15, 2006. Before then, the year represented the prior reference year instead of the year in which the data was collected and years were not included in any labels even tho some variables were based on the time of interview and some on the prior reference year.
  • The year represents the year in which the CPS Annual Social and Economic Supplement was conducted. For example, data for 2005 was collected in the 2005 CPS Annual Social and Economic Supplement.
  • Many questions in CPS are asked about the status at the time of interview. Examples include age, marital status, labor force status. Responses to other questions are based on the previous (or reference) year. Examples of these include income, poverty status, health insurance coverage. In the tables generated by the CPS Table Creator, the reference year will be identified in the variable label when it is not the same as the year in which the CPS Annual Social and Economic Supplement was conducted. Thus, age and marital status will not include the year in their labels, but income and poverty status will.

  • Latest Year / Number of Years example: to produce data for 2004 and 2005, select Year = 2005 and Number of Years = 2.
  • Tables for more than one year of data will take longer to create.

  • For the Average or Separate item,
    • If the number of years you select is "one", the value in this field is ignored.
    • If you select multiple years, "Average" will provide data averaged across the selected years. See exception below.
    • If you select multiple years, "Separate" will provide a separate table for each of the selected years.
    • There is one exception to the "Average" selection: if you select the CPS Reference Year as a variable for any row/column/page, the data will NOT be averaged across each year. This is how you would display data for multiple years in ONE table.
    • At present, there are NO COST OF LIVING ADJUSTMENTS made to ANY fields. Thus, two- and three-year averages for income variables may not yield the results you desire.

Filters/Subsets  back to top
  • You may select up to FIVE subsetting conditions.
  • To select an age subset, complete the section for the "Age Ranges" in the "Customized Formatting" section. You may select an age subset whether or not you include age in any row/column/page variable. The age subset will consist of all ages within the minimum age and the maximum age provided (no age gaps allowed).

Define Your Table  back to top
  • Multiple row or column variables can be nested (the default) or concatenated.
  • When a page variable is requested, a separate table is created for each value of the page variable.
  • When a page variable is requested, there MUST be at least one row variable, column variable, or both.
  • If a page variable is requested but no row variable, the pagevariable will be displayed as a row variable, not a page variable.
  • If a page variable is requested but no column variable, the page variable WILL be treated as a page variable.
  • When there are no observations for a particular value for all rows (or columns), then the column (or row) will not appear in the table. It will NOT appear with all zeros.
    For example, if you want a sex by age table for Iowa and the "NHOPI alone" (Native Hawaiian and Other Pacific Islander) race subset, you select age ranges of 10-11, 12-13, 14-14, and 15-65, and there are no 14-year-olds of either sex (for this subset) on the CPS data file, you will NOT get a column for 14-year-olds with zero values, the column for 14-year-olds will simply not appear in the table.

Variables  back to top
  • You may select a variable for no more than one row, column or page variable.
  • You may not use Poverty Status for any row, column or page variable if you select a universe of either "Persons - All" or "Households".
  • If you enter "None" for any row or column variable, all lower-level selections will be ignored. For example, if you select "Age" for the first row variable, "None" for the second row variable, and "Sex" for the third row variable, the generated table's rows will consist of "Age" only.
Variable Values
Age Format defaults age ranges "00-17", "18-64" and "65-80+".
Alternatively, you may use pre-defined or customized Age Ranges
Civilian Labor Force Recode

-- Children or armed forces
-- In civilian labor force
-- Not in civilian labor force
CPS Reference Year Four-digit reference year; for example, "2003" for the 2004 CPS Annual Social and and Economic Supplement
Disabilty - Health Problem

-- Children under 15
-- Yes
-- No
Disabilty - Retirement

-- Children under 15
-- Yes
-- No
Educational Attainment

-- Children under 15
-- No high school diploma
-- High school diploma or equivalent
-- Some college, less than 4-yr degree
-- Bachelor's degree or higher
Education - Detailed

-- Children under 15
-- Less than 9th grade
-- 9th-12th grade, no diploma
-- High school diploma or equivalent
-- Some college, no Assoc. or 4-yr degree
-- Associate degree
-- Bachelor's degree
-- Master's degree
-- Professional degree (such as DDS or JD)
-- Doctorate (such as PhD or EdD)
Employment Status Recode

-- Children, armed forces, or not in labor force
-- Employed
-- Unemployed
Family Income There are two fixed-range formats.
The default format is:
-- zero
-- 1 - 2499 or loss
-- ranges in 2500 increments
-- 100,000 and over

An alternate format available is:
-- zero
-- 1 - 4999 or loss
-- 5000 - 9999
-- 10000 - 14999
-- 15000 - 24999
-- 25000 - 34999
-- 35000 - 49999
-- 50000 - 74999
-- 75000 and over

Family Size -- 1
-- 2
-- 3
-- 4
-- 5
-- 6
-- 7
-- 8
-- 9 or More
Family Type -- Primary Family
-- Primary Individual
-- Related Subfamily
-- Unrelated Subfamily
-- Secondary Individual
Health Insurance Coverage -- Insured
-- Uninsured
Health Insurance: Private -- Covered
-- Not Covered
Health Insurance: Employment-based -- Covered
-- Not Covered
Health Insurance: Own Employment-based -- Covered
-- Not Covered
Health Insurance: Direct-purchase -- Covered
-- Not Covered
Health Insurance: Government -- Covered
-- Not Covered
Health Insurance: Medicare -- Covered
-- Not Covered
Health Insurance: Medicaid -- Covered
-- Not Covered
Health Insurance: Military -- Covered
-- Not Covered
Health Status -- Excellent
-- Very Good
-- Good
-- Fair
-- Poor
Hispanic Origin -- Hispanic
-- Non Hispanic
Household Income There are two fixed-range formats.
The default format is:
-- zero
-- 1 - 2499 or loss
-- ranges in 2500 increments
-- 100,000 and over

An alternate format available is:
-- zero
-- 1 - 4999 or loss
-- 5000 - 9999
-- 10000 - 14999
-- 15000 - 24999
-- 25000 - 34999
-- 35000 - 49999
-- 50000 - 74999
-- 75000 and over

Household Relationship -- Householder
-- Spouse of Householder
-- Related Children Under 18
-- Own Children 18 Years and Older
-- Other Relatives 18 Years and Older
-- Non-Relative
Income-to-Poverty Ratio

(that is, the ratio
[represented as a
percent] of total family
income to the poverty
threshold)

By default:
-- In Poverty
-- Not In Poverty

alternatively, you can select one or more income-to-poverty ratios. For example, if you checked the 100% and 150% check boxes, the values would be:
-- Below 100%
-- 100% to below 150%
-- 150% and above

Kind of Family -- Husband-Wife Family
-- Other Male Reference Person
-- Other Female Reference Person
Labor Force Status Recode

-- Children or armed forces
-- Working
-- With job, not at work
-- Unemployed, looking for work
-- Unemployed, on layoff
-- Not in labor force
Marital Status -- Married, Spouse Present
-- Married, Spouse Absent
-- Widowed
-- Divorced
-- Separated
-- Never Married
Nativity -- Native
-- Foreign Born
Nativity - Detailed -- Native
-- Naturalized Citizen
-- Not a Citizen
Person Income There are two fixed-range formats.
The default format is:
-- zero
-- 1 - 2499 or loss
-- ranges in 2500 increments
-- 100,000 and over

An alternate format available is:
-- zero
-- 1 - 4999 or loss
-- 5000 - 9999
-- 10000 - 14999
-- 15000 - 24999
-- 25000 - 34999
-- 35000 - 49999
-- 50000 - 74999
-- 75000 and over

Poverty Status

-- In Poverty
-- Not In Poverty
Race Two formats are available.
The default format is:
-- White alone
-- Black or African American alone
-- American Indian and Alaska Native alone
-- Asian alone
-- Native Hawaiian and Other Pacific Islander alone
-- Two or more races

An alternate format is:
-- White alone
-- Black or African American alone
-- American Indian and Alaska Native alone
-- Asian alone, NHOPI alone, or Asian/NHOPI
-- Two or more races

Race White alone or in combination -- White alone or in combination
-- Other
Race Black alone or in combination -- Black alone or in combination
-- Other
Race AIAN alone or in combination -- AIAN alone or in combination
-- Other
Race Asian alone or in combination -- Asian alone or in combination
-- Other
Race NHOPI alone or in combination -- NHOPI alone or in combination
-- Other
Race Asian/NHOPI -- Asian/NHOPI alone or in combination
-- Other
Region -- Northeast
-- Midwest
-- South
-- West
Related Children Under 18: Number -- 1
-- 2
-- 3
-- 4
-- 5
-- 6
-- 7
-- 8 or More
Sex -- Male
-- Female
State Two-letter Postal abbreviations
Work Disability -- Work Disability
-- No Work Disability
Work Disability - Severity -- Severe Work Disability
-- Non-Severe Work Disability
-- No Work Disability
Work Experience -- Worked full-time year-round
-- Worked less than full-time year-round
-- Did not work
-- Under 15 years (not working age)
Work Experience - Detailed -- Worked full-time year-round
-- Worked full-time part-year
-- Worked part-time year-round
-- Worked part-time part-year
-- Did not work
-- Under 15 years (not working age)
World Region of Birth

(Not available for 2007 and later)

-- Native
-- Europe
-- Asia
-- Other Areas
-- Central America
-- Caribbean
-- South America
-- Other Areas
World Region of Birth of Father

(Not available for 2007 and later)

-- Native
-- Europe
-- Asia
-- Other Areas
-- Central America
-- Caribbean
-- South America
-- Other Areas
World Region of Birth of Mother

(Not available for 2007 and later)

-- Native
-- Europe
-- Asia
-- Other Areas
-- Central America
-- Caribbean
-- South America
-- Other Areas

Statistics  back to top
  • The available statistics are cell sums, percentages for a variable in the table, unweighted record counts, and, for one addional numeric variable, one or more of the statistics from the list of mean (average), median, minimum value, maximum value, and sum.
  • You must include at least one statistic, but within this constraint, you can include any combination of the available statistics.
Row or Column Display of Statistics
  • You can control whether you want the statistics displayed as rows or as columns. Columns are generally easier to read, but, for many variables, may make a table very wide, forcing the table to be parsed into sections.
  • The system defaults to column display of statistics.
  • If the table structure has rows, but no columns, the statistics will be displayed in columns no matter what you select for this field. All other combinations should display as you request.
  • If the ONLY statistic requested is SUMs, column display produces a more attractive table than row display.
Sums
  • The sum is a weighted count of the persons, families, or households in the cell.
Percentages
  • If you include a percentage variable, the variable MUST have been selected for a row or a column variable (not a page variable).
  • The percentage variable can be any nested row or column variable or the concatenated variable when only one concatenated variable (for a row or column) has been selected.
  • If the table has multiple concatenated row (or column) variables, none of those variables may be used as a percentage variable since the table cells for the other concatenated variables will have no relationship to the percent variable.
  • The percentages can be displayed as columns (the default) or as rows in the table. However, if your table has column variables only, you may not display percentages in rows.
  • You may display percentages with zero (the default), one, or two decimal places.
  • The percentage variable is displayed in the table's title.
Unweighted Record Counts
  • The unweighted record count provides the number of records on the Current Population Survey input files contributing to these data.
Additional Numeric Variable Statistics
  • The statistics currently available are mean (or average), minimum, maximum, and sum.
  • No more than one additional variable can be included in a table.
  • You may select one or more statistics for the selected variable. For multiple selections, the usual rules for window applications apply. Hold down the shift key and use the up- and down-arrows to select consective choices. Or hold down the control key and use the mouse to select any combination of choices. The statistics in the table will be listed in the order they appear in the selection lists, not the order in which you select them.
  • The number of decimals you choose to display will apply to ALL additional statistics you select.

Age Range Formats  back to top
  • Note that age is top-coded to 80. That is, anyone whose actual age is 80 or higher has a value of 80.
  • A default pre-defined set of age ranges has been provided. You may select an alternative pre-defined set of age ranges or you may customize your own age ranges by selecting "Customize..." from the selection list and entering the age ranges (up to nine ranges) you desire.
  • If you select both a pre-defined set of ranges and enter your own customized ranges, the pre-defined set will be used. Your customized ranges will be ignored unless you've selected "Customize...".
  • For customized age ranges, be sure that the maximum for each range is at least as large as the minimum.
  • Ranges must be sequential from lowest to highest with NO AGE GAPS.
  • Numbers below 10 can be entered with or without leading zeros.
  • If the set of age ranges does not include all ages, it will act as subset for the table (whether or not age is a row/column/page variable).

Missing Values  back to top
  • When there are no records for a particular cell, the software will place a one-character symbol in the cell. Available characters are:
    • . (period, the default)
    • 0 (the number zero)
    • - (dash)
  • Note that if a valid column (or row) has no records for all rows (or columns), the column (or row) will NOT appear in the table at all. It will NOT be listed with the missing values symbol for all rows (or columns). For example, if sex is a column variable for a table that includes data subsetted to include only females, there will be no male column.


Source: U.S. Census Bureau | Current Population Survey (CPS) |  Last Revised: