Current Population Survey (CPS) Annual Social and Economic Supplement (ASEC)

From Data-gov Wiki

Jump to: navigation, search

Contents

Facts

NOTES: This dataset covers data with following features: state.This dataset covers temporal data from 1999 to 2008.



Source data

Current Population Survey (CPS) Annual Social and Economic Supplement (ASEC) 2008

Current Population Survey (CPS) Annual Social and Economic Supplement (ASEC) 2009

Overview

Health-related Time series dataset considered for Demo: Big Data in Healthcare‎

Sample content

In 2008, 301,483,000 people lived in United States households.
In 2007, 299,106,000 people lived in United States households.
...
In 1999, 276,804,000 people lived in United States households.
In 2008, 255,143,000 people living in United States households had health insurance coverage.
In 2007, 253,449,000 people living in United States households had health insurance coverage.
...
In 1999, 238,037,000 people living in United States households had health insurance coverage.
In 2008, 200,992,000 people living in United States households had private health insurance coverage.
In 2007, 201,991,000 people living in United States households had private health insurance coverage.
...
In 1999, 200,721,000 people living in United States households had private health insurance coverage.
In 2008, 176,332,000 people living in United States households had private employment-based health insurance coverage.
In 2007, 177,446,000 people living in United States households had private employment-based health insurance coverage.
...
In 1999, 176,838,000 people living in United States households had private employment-based health insurance coverage.

Background

(From Health Insurance Estimates from the U.S. Census Bureau: Background for a New Historical Series:)

The current CPS ASEC is a survey of approximately 78,000 households, which includes detailed health insurance questions. The survey questions are asked about all people in the household, but usually a single person within the household responds.

The CPS ASEC also asked health insurance questions from 1980 to 1986, but these questions were quite different from the questions asked from 1987 to the present.

Respondents are asked to report health insurance coverage status in the previous calendar year for themselves and all other household members.

State Children’s Health Insurance Program

The CPS ASEC is a popular source of health insurance coverage data in the United States due to the other critical characteristics available for analysis—employment, poverty, etc.

The questionnaire items pertinent to the edit process that assign employment-based and private health insurance coverage are SHI2, SHI3, SHI4, SHI7, SHI8, and SHI9.

(some data dictionary stuff on page 4)

Full items booklet: http://www.census.gov/apsd/techdoc/cps/cps-main.html

Question flow chart: http://www.census.gov/hhes/www/hlthins/hlthinsseq.pdf

Familiarization

got link http://www.census.gov/hhes/www/hlthins/historic/index.html from email

Made Current Population Survey (CPS) Annual Social and Economic Supplement (ASEC)

paper linked from census page: Health Insurance Estimates from the U.S. Census Bureau: Background for a New Historical Series

US Census Bureau

downloaded HIA-1 through HIA-8 8 xls (no URIs) hihistt1.xls

File:CPS ASEC HIA-1.png

"Table HIA-1" should become an identifier

NOTE: Numbers in thousands. People as of March of the following year.

Year values may cite footnotes:

2004 (4)

which are listed at http://www.census.gov/hhes/www/hlthins/historic/footnotes.html:

4/ These estimates from the 2005 ASEC were revised based on improvements to the 
algorithm that assigned coverage to dependents, and  there was an adjustment to the weights.

opened and saved-as to csv hihistt1.xls.csv

older version (HI-1 through HI-9) (1987-2005, before adjustments) http://www.census.gov/hhes/www/hlthins/historic/index_old.html

Current Population Survey

CPS ASEC

ASEC

Q: What is "SE" column in hihistt1.xls / HIA-4? A: "Standard Error"

Analysis of the Information (Bertin)

Aggregate

Invariant:

  • Group of people - nominal

Variational components:

  • number with insurance coverage - quantitative
    • covered
      • covered by private health insurance
        • employment-based
        • direct purchase
      • covered by government health insurance
        • medicaid
        • medicare
        • military health care
    • not covered
  • percentage with insurance coverage - quantitative
    • covered
      • covered by private health insurance
        • employment-based
        • direct purchase
      • covered by government health insurance
        • medicaid
        • medicare
        • military health care
    • not covered
  • year - quantitative [1999,2008]
    • year - ordered <1999,2008>
      • year - nominal {1999,2008}
  • age - ordered <0-17,18-24,25-34,35-44,45-54,55-64,65+>
    • {child, adult} - nominal
  • sex - nominal {male, female}
  • race - nominal
  • state - nominal

Individual

Invariant:

  • Person living in US household

Variational components:

  • year - quantitative [1999,2008]
    • year - ordered <1999,2008>
      • year - nominal {1999,2008}
  • age - quantitative [0,]
    • age - ordered <0-17,18-24,25-34,35-44,45-54,55-64,65+>
    • age - ordered <0-2,3-5,6-11,12-17,0-17,18-24,25-34,35-44,45-54,55-64,65+>
      • age - nominal {0-17,18-24,25-34,35-44,45-54,55-64,65+}
      • {child, adult} - nominal
  • sex - nominal {male, female}
  • race - nominal {white, not hispanic, black, asian, pacific islander, hispanic}
  • state - nominal {United States, Alabama, Wyoming}
  • Health insured - nominal
 covered
    covered by private health insurance
       employment-based
       direct purchase
    covered by government health insurance
       medicaid
       medicare
       military health care
 not covered
  • nativity - nominal {native, foreign born, naturalized citizen, not a citizen}
  • poverty - nominal {below poverty level, above poverty level}

Conversion

Tim converted to RDF. Hosting on localhost with joseki.

Queries

prefix row: <http://open.vocab.org/terms/csvRow>

select distinct ?s ?p ?o
where {
  graph <http://tw.rpi.edu/dataset/CPS_ASEC/hihistt8.xls.csv.ttl> {
    ?s row: ?row; ?p ?o 
  }
} order by ?s ?p ?o

What graphs use what properties?

prefix row: <http://open.vocab.org/terms/csvRow>

select distinct ?g ?p
where {
  graph ?g {
    ?s row: ?row; ?p ?o 
  }
} order by ?g ?p

How are the properties described?

prefix row: <http://open.vocab.org/terms/csvRow>

select distinct ?p ?pp ?po
where {
  graph ?g {
    ?s row: ?row; ?p ?o . ?p ?pp ?po
  }
} order by ?g ?p

What is the entire table?

prefix ov: <http://open.vocab.org/terms/>
prefix csv: <http://csv2rdf.org/property/>
prefix num: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b1>
prefix per: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b2>

select distinct ?csvRow ?csvCol ?property ?value
where {
  graph <http://tw.rpi.edu/dataset/CPS_ASEC/hihistt1.xls.csv.ttl> {
    ?t csv:depth1 ?demographic; 
       ?property ?value ;
       ov:csvRow ?csvRow .
    ?property ov:csvCol ?csvCol .
  }
} order by ?csvRow ?csvCol


To get the table in hihist1.xsl from 354 to 356:

prefix csv: <http://csv2rdf.org/property/>
prefix num: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b1>
prefix per: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b2>

select *
where {
  graph <http://tw.rpi.edu/dataset/CPS_ASEC/hihistt1.xls.csv.ttl> {
    ?t csv:depth1 "BLACK (6) FEMALES"; 
       num:p1 ?c1 ;
       num:p2 ?c2 ;
       num:p3 ?c3 ;
       num:p4 ?c4 ;
       num:p5 ?c5 ;
       num:p6 ?c6 ;
       num:p7 ?c7 ;
       num:p8 ?c8 ;
       num:p9 ?c9 ;
       num:p10 ?c10 ;
       num:p11 ?c11 ;
  }
}

Which demographics are covered in which years?

prefix csv: <http://csv2rdf.org/property/>
prefix num: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b1>
prefix per: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b2>

select distinct ?demographic ?year
where {
  graph <http://tw.rpi.edu/dataset/CPS_ASEC/hihistt1.xls.csv.ttl> {
    ?t csv:depth1 ?demographic; 
       num:p1     ?year ;
  }
} order by ?demographic ?year

What years is a particular demographic described?

prefix csv: <http://csv2rdf.org/property/>
prefix num: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b1>
prefix per: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b2>

select distinct ?year
where {
  graph <http://tw.rpi.edu/dataset/CPS_ASEC/hihistt1.xls.csv.ttl> {
    ?t csv:depth1 "ALL RACES BOTH SEXES"; 
       num:p1     ?year ;
  }
} order by ?year


How many years is a particular demographic described?

prefix csv: <http://csv2rdf.org/property/>
prefix num: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b1>
prefix per: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b2>
 
select (count(distinct ?year) as ?numYears)
where {
  graph <http://tw.rpi.edu/dataset/CPS_ASEC/hihistt1.xls.csv.ttl> {
    ?t csv:depth1 "ALL RACES BOTH SEXES"; 
       num:p1     ?year ;
  }
}


prefix ov: <http://open.vocab.org/terms/>
prefix csv: <http://csv2rdf.org/property/>
prefix num: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b1>
prefix per: <http://tw.rpi.edu/dataset/CPS_ASEC/HIA-1/conversion/1/b2>

select ?demographic ?year ?c2 ?c3 ?c4 ?c5 ?c6 ?c7 ?c8 ?c9 ?c10 ?c11
where {
  graph <http://tw.rpi.edu/dataset/CPS_ASEC/hihistt1.xls.csv.ttl> {
    ?t ov:csvRow ?row ;
       csv:depth1 ?demographic; 
       num:p1 ?year ;
       num:p2 ?c2 ;
       num:p3 ?c3 ;
       num:p4 ?c4 ;
       num:p5 ?c5 ;
       num:p6 ?c6 ;
       num:p7 ?c7 ;
       num:p8 ?c8 ;
       num:p9 ?c9 ;
       num:p10 ?c10 ;
       num:p11 ?c11 ;
  }
}

Facts about Current Population Survey (CPS) Annual Social and Economic Supplement (ASEC)RDF feed
AHealth-related dataset  +, and Time series dataset  +
AcronymCPS ASEC  +, and ASEC  +
AffectsState Children’s Health Insurance Program  +
ConsideredForDemo: Big Data in Healthcare  +
Dc:identifierdgtwc(ASEC)  +
Dcterms:publisherUS Census Bureau  +
Dgtwc:linked data entry pointhttp://data-gov.tw.rpi.edu/vocab/Current_Population_Survey_(CPS)_Annual_Social_and_Economic_Supplement_(ASEC)  +
Dgtwc id(ASEC)  +
FeaturesHealth insurance  +, Person  +, Year  +, Sex  +, Race  +, State  +, Health insured  +, Nativity  +, and Poverty  +
FeaturessAge  +
Has end year2008  +
Has featureState  +
Has start year1999  +
Skos:broaderCurrent Population Survey  +
Skos:narrowerCurrent Population Survey (CPS) Annual Social and Economic Supplement (ASEC) 2008  +, and Current Population Survey (CPS) Annual Social and Economic Supplement (ASEC) 2009  +
Source datahttp://www.census.gov/hhes/www/hlthins/historic/hihistt1.xls  +, http://www.census.gov/hhes/www/hlthins/historic/hihistt2.xls  +, http://www.census.gov/hhes/www/hlthins/historic/hihistt3.xls  +, http://www.census.gov/hhes/www/hlthins/historic/hihistt4.xls  +, http://www.census.gov/hhes/www/hlthins/historic/hihistt5.xls  +, http://www.census.gov/hhes/www/hlthins/historic/hihistt6.xls  +, http://www.census.gov/hhes/www/hlthins/historic/hihistt7.xls  +, and http://www.census.gov/hhes/www/hlthins/historic/hihistt8.xls  +
Personal tools
internal pages