Current Population Survey
The primary source of labor force statistics for the US population
@kaggle.census_current_population_survey
The primary source of labor force statistics for the US population
@kaggle.census_current_population_survey
The Current Population Survey (CPS) is one of the oldest, largest, and most well-recognized surveys in the United States. It is immensely important, providing information on many of the things that define us as individuals and as a society – our work, our earnings, and our education.
In addition to being the primary source of monthly labor force statistics, the CPS is used to collect data for a variety of other studies that keep the nation informed of the economic and social well-being of its people. This is done by adding a set of supplemental questions to the monthly basic CPS questions. Supplemental inquiries vary month to month and cover a wide variety of topics such as child support, volunteerism, health insurance coverage, and school enrollment. Supplements are usually conducted annually or biannually, but the frequency and recurrence of a supplement depend completely on what best meets the needs of the supplement’s sponsor.
Data Dictionary: http://thedataweb.rm.census.gov/pub/cps/basic/201501-/January_2015_Record_Layout.txt
The Current Population Survey (CPS) is administered, processed, researched and disseminated by the U.S. Census Bureau on behalf of the Bureau of Labor Statistics (BLS).
CREATE TABLE cps_2016_08 (
"hrhhid" BIGINT,
"hrmonth" BIGINT,
"hryear4" BIGINT,
"hurespli" BIGINT,
"hufinal" BIGINT,
"huspnish" BIGINT,
"hetenure" BIGINT,
"hehousut" BIGINT,
"hetelhhd" BIGINT,
"hetelavl" BIGINT,
"hephoneo" BIGINT,
"hefaminc" BIGINT,
"hutypea" BIGINT,
"hutypb" BIGINT,
"hutypc" BIGINT,
"hwhhwgt" BIGINT,
"hrintsta" BIGINT,
"hrnumhou" BIGINT,
"hrhtype" BIGINT,
"hrmis" BIGINT,
"huinttyp" BIGINT,
"huprscnt" BIGINT,
"hrlonglk" BIGINT,
"hrhhid2" BIGINT,
"hwhhwtln" BIGINT,
"hubus" BIGINT,
"hubusl1" BIGINT,
"hubusl2" BIGINT,
"hubusl3" BIGINT,
"hubusl4" BIGINT,
"gereg" BIGINT,
"gediv" BIGINT,
"gestfips" BIGINT,
"gtcbsa" BIGINT,
"gtco" BIGINT,
"gtcbsast" BIGINT,
"gtmetsta" BIGINT,
"gtindvpc" BIGINT,
"gtcbsasz" BIGINT,
"gtcsa" BIGINT,
"filler" VARCHAR,
"perrp" BIGINT,
"peparent" BIGINT,
"prtage" BIGINT,
"prtfage" BIGINT,
"pemaritl" BIGINT,
"pespouse" BIGINT,
"pesex" BIGINT,
"peafever" BIGINT,
"filler_1" VARCHAR,
"peafnow" BIGINT,
"peeduca" BIGINT,
"ptdtrace" BIGINT,
"prdthsp" BIGINT,
"puchinhh" BIGINT,
"pulineno" BIGINT,
"prfamnum" BIGINT,
"prfamrel" BIGINT,
"prfamtyp" BIGINT,
"pehspnon" BIGINT,
"prmarsta" BIGINT,
"prpertyp" BIGINT,
"penatvty" BIGINT,
"pemntvty" BIGINT,
"pefntvty" BIGINT,
"prcitshp" BIGINT,
"prcitflg" BIGINT,
"prinusyr" BIGINT,
"puslfprx" BIGINT,
"pemlr" BIGINT,
"puwk" BIGINT,
"pubus1" BIGINT,
"pubus2ot" BIGINT,
"pubusck1" BIGINT,
"pubusck2" BIGINT,
"pubusck3" BIGINT,
"pubusck4" BIGINT,
"puretot" BIGINT,
"pudis" BIGINT,
"peret1" BIGINT,
"pudis1" BIGINT,
"pudis2" BIGINT,
"puabsot" BIGINT,
"pulay" BIGINT,
"peabsrsn" BIGINT,
"peabspdo" BIGINT,
"pemjot" BIGINT,
"pemjnum" BIGINT,
"pehrusl1" BIGINT,
"pehrusl2" BIGINT,
"pehrftpt" BIGINT,
"pehruslt" BIGINT,
"pehrwant" BIGINT,
"pehrrsn1" BIGINT,
"pehrrsn2" BIGINT,
"pehrrsn3" BIGINT,
"puhroff1" BIGINT,
"puhroff2" BIGINT,
"puhrot1" BIGINT,
"puhrot2" BIGINT
);Anyone who has the link will be able to view this.