< Return to Datasets Menu

Public Workforce System

Public Workforce System

http://api.dol.gov/V1/Statistics/PWSD

The PWSD is a dataset that can be used to answer questions about various public workforce system programs and how these programs fit in with the overall public workforce system and the economy. It was designed primarily to be used as a tool to understand what has been occurring in the Wagner-Peyser program and contains data from quarter 1 of 1995 through quarter 4 of 2008. Also, it was designed to understand the relationship and flow of participants as they go through the public workforce system. The PWSD can be used to analyze these programs both individually and in combination. The PWSD contains economic variables, Unemployment Insurance System data, and data on programs funded by the Workforce Investment Act and Employment Service. Economic variables included are labor force, employment, unemployment, unemployment rate, and gross domestic product data.

This complete dataset can be found at http://catalog.data.gov/dataset/public-workforce-system-dataset-pwsd

Browse Metadata Explore This Data

Dataset Tables

esFinal

Employment Service
Column Name Data Type Column Description
Column Name id Data Type bigint Column Description Record id. - Primary Key
Column Name state Data Type varchar (3) Column Description State.
Column Name fy Data Type int Column Description Fiscal year.
Column Name fyq Data Type int Column Description Fiscal year quarter.
Column Name cy Data Type int Column Description Calendar year.
Column Name cyq Data Type int Column Description Calendar year quarter.
Column Name esObligation Data Type float Column Description Employment service obligation.
Column Name esExpenditure Data Type float Column Description Employment service expenditure.

Model

Model
Column Name Data Type Column Description
Column Name id Data Type bigint Column Description Record id. - Primary Key
Column Name state Data Type varchar (3) Column Description State.
Column Name calendarYear Data Type int Column Description Calendar year.
Column Name calendarQuarter Data Type int Column Description Calendar year quarter.
Column Name fiscalYear Data Type int Column Description Fiscal year.
Column Name fiscalQuarter Data Type int Column Description Fiscal year quarter.
Column Name laborForce Data Type int Column Description Labor force.
Column Name employment Data Type int Column Description Employment.
Column Name unemployment Data Type int Column Description Unemployment.
Column Name unemploymentRate Data Type int Column Description Unemployment rate.
Column Name quarterGDP Data Type varchar (10) Column Description Quarter GDP.
Column Name benefitsPaid Data Type int Column Description Benefits paid.
Column Name initialClaims Data Type int Column Description Initial claims.
Column Name firstPayments Data Type int Column Description First payments.
Column Name weeksClaimed Data Type int Column Description Weeks claimed.
Column Name weeksCompensated Data Type int Column Description Weeks compensated.
Column Name exhaustions Data Type int Column Description Exhaustions.
Column Name averageDuration Data Type int Column Description Average duration.
Column Name exhaustionRate Data Type varchar (16) Column Description Exhaustion rate.
Column Name ebBenefits Data Type int Column Description EB benefits.
Column Name ebFirstPayments Data Type int Column Description EB first payments.
Column Name ebWeeksClaimed Data Type int Column Description EB weeks claimed.
Column Name ebExhaustions Data Type int Column Description EB exhaustions.
Column Name ebWeeksCompensated Data Type int Column Description EB weeks compensated.
Column Name profiledClaimants Data Type int Column Description Profiled claimants.
Column Name poolProfiledClaimants Data Type int Column Description Pool profiled claimants.
Column Name referredProfiledClaimants Data Type int Column Description Referred profiled claimants.
Column Name exemptedProfiledClaimants Data Type int Column Description Exempted profiled claimants.
Column Name reportingToService Data Type int Column Description Reporting to service.
Column Name reportingToOrientationService Data Type int Column Description Reporting to orientation service.
Column Name reportingToAssessmentService Data Type int Column Description Reporting to assessment service.
Column Name reportingToCounselingService Data Type int Column Description Reporting to counseling service.
Column Name reportingToPlacementService Data Type int Column Description Reporting to placement service.
Column Name reportingToJSWServices Data Type int Column Description Reporting to JSW services.
Column Name reportingToTrainingServices Data Type int Column Description Reporting to training services.
Column Name reportingToSelfEmploymentService Data Type int Column Description Reporting to self employment service.
Column Name completingServices Data Type int Column Description Completing services.
Column Name completingOrientationService Data Type int Column Description Completing orientation service.
Column Name completingAssessmentService Data Type int Column Description Completing assessment service.
Column Name completingCounselingServices Data Type int Column Description Completing counseling services.
Column Name completingPlacementServices Data Type int Column Description Completing placement services.
Column Name completingJSWServices Data Type int Column Description Completing JSW services.
Column Name completingTrainingServices Data Type int Column Description Completing training services.
Column Name completingSelfEmploymentService Data Type int Column Description Completing self employment service.
Column Name totalWagnerPeyser Data Type int Column Description Total Wagner Peyser.
Column Name totalMaleWagnerPeyser Data Type int Column Description Total male Wagner Peyser.
Column Name totalUIEligibleWagnerPeyser Data Type int Column Description Total UI eligible Wagner Peyser.
Column Name totalEmployedWagnerPeyser Data Type int Column Description Total employed Wagner Peyser.
Column Name totalUnemployedWagnerPeyser int Column Description Total unemployed Wagner Peyser.
Column Name totalInSchoolWagnerPeyser Data Type int Column Description Total in school Wagner Peyser.
Column Name totalLessThanHighSchoolEducationWagnerPeyser Data Type int Column Description Total less than high school education Wagner Peyser.
Column Name totalHighSchoolEducationOrGedWagnerPeyser Data Type int Column Description Total high school education or GED Wagner Peyser.
Column Name totalPostSecondaryEducationWagnerPeyser Data Type int Column Description Total post secondary education Wagner Peyser.
Column Name totalYouthWagnerPeyser Data Type int Column Description Total youth Wagner Peyser.
Column Name totalAdult18To22WagnerPeyser Data Type int Column Description Total adult 18 to 22 Wagner Peyser.
Column Name totalAdult18To44WagnerPeyser Data Type int Column Description Total adult 18 to 44 Wagner Peyser.
Column Name totalAdult45To54WagnerPeyser Data Type int Column Description Total adult 45 to 54 Wagner Peyser.
Column Name totalAdult55PlusWagnerPeyser Data Type int Column Description Total adult 55 and older Wagner Peyser.
Column Name totalReferredToJtpaOrWiaWagnerPeyser Data Type int Column Description Total referred to JTPA or WIA Wagner Peyser.
Column Name totalReferredToSupportServicesWagnerPeyser Data Type int Column Description Total referred to support services Wagner Peyser.
Column Name totalJobSearchActivitiesWagnerPeyser Data Type int Column Description Total job search activities Wagner Peyser.
Column Name totalReferredToEmploymentWagnerPeyser Data Type int Column Description Total referred to employment Wagner Peyser.
Column Name totalServiceReceivedWagnerPeyser Data Type int Column Description Total service received Wagner Peyser.
Column Name totalCareerGuidanceWagnerPeyser Data Type int Column Description Total career guidance Wagner Peyser.
Column Name totalWorkforceInfoServicesReceivedWagnerPeyser Data Type int Column Description Total workforce info services received Wagner Peyser.
Column Name totalEnteredEmploymentWagnerPeyser Data Type int Column Description Total entered employment Wagner Peyser.
Column Name totalExitersWagnerPeyser Data Type int Column Description Total exiters Wagner Peyser.
Column Name totalEERateBaseDenominatorWagnerPeyser Data Type int Column Description Total EE rate base denominator Wagner Peyser.
Column Name totalEERateWagnerPeyser Data Type varchar (16) Column Description Total EE rate Wagner Peyser.
Column Name totalEETotalApplicantsWagnerPeyser Data Type float Column Description Total EE total applicants Wagner Peyser.
Column Name totalEEReceivedReportableServicesWagnerPeyser Data Type float Column Description Total EE received reportable services Wagner Peyser.
Column Name totalReceivedReportableServicesApplicantsWagnerPeyser Data Type float Column Description Total received reportable services applicants Wagner Peyser.
Column Name totalActiveAppsUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Total active apps unemployment insurance eligible Wagner Peyser.
Column Name maleUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Male unemployment insurance eligible Wagner Peyser.
Column Name youthUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Youth unemployment insurance eligible Wagner Peyser.
Column Name adult18To22UnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Adult 18 to 22 unemployment insurance eligible Wagner Peyser.
Column Name adult18To44UnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Adult 18 to 44 unemployment insurance eligible Wagner Peyser.
Column Name adult45To54UnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Adult 45 to 54 unemployment insurance eligible Wagner Peyser.
Column Name adult55PlusUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Adult 55 and older unemployment insurance eligible Wagner Peyser.
Column Name referredToJtpaOrWiaUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Referred to JTPA or WIA unemployment insurance eligible Wagner Peyser.
Column Name referredToSupportUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Referred to support unemployment insurance eligible Wagner Peyser.
Column Name jobSearchActivitiesUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Job search activities unemployment insurance eligible Wagner Peyser.
Column Name referredToEmploymentUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Referred to employment unemployment insurance eligible Wagner Peyser.
Column Name receivedReportServiceUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Received report service unemployment insurance eligible Wagner Peyser.
Column Name careerGuidanceUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Career guidance unemployment insurance eligible Wagner Peyser.
Column Name receivedWorkforceInfoServicesUnemploymentInsuranceEligibeWagnerPeyser Data Type int Column Description Received workforce info services unemployment insurance eligibe Wagner Peyser.
Column Name enteredEmploymentUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Entered employment unemployment insurance eligible Wagner Peyser.
Column Name totalExitersUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description Total exiters unemployment insurance eligible Wagner Peyser.
Column Name eeRateBaseDenominatorUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description EE rate base denominator unemployment insurance eligible Wagner Peyser.
Column Name eeRateUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description EE rate unemployment insurance eligible Wagner Peyser.
Column Name eeTotalApplicantsUnemploymentInsuranceEligibleWagnerPeyser Data Type int Column Description EE total applicants unemployment insurance eligible Wagner Peyser.
Column Name eeReceivedReportableServicesUnemploymentInsuranceWagnerPeyser Data Type int Column Description EE received reportable services unemployment insurance Wagner Peyser.
Column Name receivedReportableServicesTotalApplicantsUnemploymentWagnerPeyser Data Type int Column Description Received reportable services total applicants unemployment Wagner Peyser.
Column Name totalActiveAppsEmployedWagnerPeyser Data Type int Column Description Total active apps employed Wagner Peyser.
Column Name maleEmployedWagnerPeyser Data Type int Column Description Male employed Wagner Peyser.
Column Name youthEmployedWagnerPeyser Data Type int Column Description Youth employed Wagner Peyser.
Column Name adult18To22EmployedWagnerPeyser Data Type int Column Description Adult 18 to 22 employed Wagner Peyser.
Column Name adult18To44EmployedWagnerPeyser Data Type int Column Description Adult 18 to 44 employed Wagner Peyser.
Column Name adult45To54EmployedWagnerPeyser Data Type int Column Description Adult 45 to 54 employed Wagner Peyser.
Column Name adult55PlusEmployedWagnerPeyser Data Type int Column Description Adult 55 and older employed Wagner Peyser.
Column Name referredToJtpaOrWiaEmployedWagnerPeyser Data Type int Column Description Referred to JTPA or WIA employed Wagner Peyser.
Column Name referredToSupportServiceEmployedWagnerPeyser Data Type int Column Description Referred to support service employed Wagner Peyser.
Column Name jobSearchActivitiesEmployedWagnerPeyser Data Type int Column Description Job search activities employed Wagner Peyser.
Column Name referredToEmploymentEmployedWagnerPeyser Data Type int Column Description Referred to employment employed Wagner Peyser.
Column Name receivedReportServiceEmployedWagnerPeyser Data Type int Column Description Received report service employed Wagner Peyser.
Column Name careerGuidanceEmployedWagnerPeyser Data Type int Column Description Career guidance employed Wagner Peyser.
Column Name receivedWorkforceInfoServicesEmployedWagnerPeyser Data Type int Column Description Received workforce info services employed Wagner Peyser.
Column Name enteredEmploymentEmployedWagnerPeyser Data Type int Column Description Entered employment employed Wagner Peyser.
Column Name totalExitersEmployedWagnerPeyser Data Type int Column Description Total exiters employed Wagner Peyser.
Column Name eeRateBaseDenominatorEmployedWagnerPeyser Data Type int Column Description EE rate base denominator employed Wagner Peyser.
Column Name eeRateEmployedWagnerPeyser Data Type int Column Description EE rate employed Wagner Peyser.
Column Name totalActiveAppsUnemployedWagnerPeyser Data Type int Column Description Total active apps unemployed Wagner Peyser.
Column Name maleUnemployedWagnerPeyser Data Type int Column Description Male unemployed Wagner Peyser.
Column Name youthUnemployedWagnerPeyser Data Type int Column Description Youth unemployed Wagner Peyser.
Column Name adult18To22UnemployedWagnerPeyser Data Type int Column Description Adult 18 to 22 unemployed Wagner Peyser.
Column Name adult18To44UnemployedWagnerPeyser Data Type int Column Description Adult 18 to 44 unemployed Wagner Peyser.
Column Name adult45To54UnemployedWagnerPeyser Data Type int Column Description Adult 45 to 54 unemployed Wagner Peyser.
Column Name adult55UnemployedWagnerPeyser Data Type int Column Description Adult 55 unemployed Wagner Peyser.
Column Name referredToJtpaOrWiaUnemployedWagnerPeyser Data Type int Column Description Referred to JTPA or WIA unemployed Wagner Peyser.
Column Name referredToSupportServiceUnemployedWagnerPeyser Data Type int Column Description Referred to support service unemployed Wagner Peyser.
Column Name jobSearchActivitiesUnemployedWagnerPeyser Data Type int Column Description Job search activities unemployed Wagner Peyser.
Column Name referredToEmploymentUnemployedWagnerPeyser Data Type int Column Description Referred to employment unemployed Wagner Peyser.
Column Name receivedReportServiceUnemployedWagnerPeyser Data Type int Column Description Received report service unemployed Wagner Peyser.
Column Name careerGuidanceUnemployedWagnerPeyser Data Type int Column Description Career guidance unemployed Wagner Peyser.
Column Name receivedWorkforceInfoServicesUnemployedWagnerPeyser Data Type int Column Description Received workforce info services unemployed Wagner Peyser.
Column Name enteredEmploymentUnemployedWagnerPeyser Data Type int Column Description Entered employment unemployed Wagner Peyser.
Column Name totalExitersUnemployedWagnerPeyser Data Type int Column Description Total exiters unemployed Wagner Peyser.
Column Name eeRateBaseDenominatorUnemployedWagnerPeyser Data Type int Column Description EE rate base denominator unemployed Wagner Peyser.
Column Name eeRateUnemployedWagnerPeyser Data Type int Column Description EE rate unemployed Wagner Peyser.
Column Name esObligation Data Type int Column Description Employment service obligation.
Column Name esExpenditure Data Type int Column Description Employment service expenditure.
Column Name totalAdult Data Type int Column Description Total adult.
Column Name male Data Type int Column Description Male.
Column Name female Data Type int Column Description Female.
Column Name age18To21 Data Type int Column Description Age 18 to 21.
Column Name age22To44 Data Type int Column Description Age 22 to 44.
Column Name age45To54 Data Type int Column Description Age 45 to 54.
Column Name age55 Data Type int Column Description Age 55 and older.
Column Name lowerThanhighschool Data Type int Column Description Lower than high school.
Column Name ged Data Type int Column Description GED.
Column Name hsgrad Data Type int Column Description High school graduate.
Column Name somecoll Data Type int Column Description Some College.
Column Name cert Data Type int Column Description Certificate.
Column Name assoc Data Type int Column Description Associates degree.
Column Name ba Data Type int Column Description Bachelor's degree.
Column Name beyondba Data Type int Column Description Beyond Bachelor's degree.
Column Name employed Data Type int Column Description Employed.
Column Name uiclaimant Data Type int Column Description UI Claimant.
Column Name uiexhaustee Data Type int Column Description UI exhaustee.
Column Name adult_l Data Type int Column Description Adult l.
Column Name adult_st Data Type int Column Description Adult st.
Column Name wagner Data Type int Column Description Wagner Peyser.
Column Name ss Data Type int Column Description SS.
Column Name selfcore Data Type int Column Description Self Core.
Column Name staffcore Data Type int Column Description Staff Core.
Column Name wis Data Type int Column Description WIS.
Column Name ita_trn Data Type int Column Description ITA TRN.
Column Name prevoc Data Type int Column Description Prevoc.
Column Name intserv Data Type int Column Description Intserv.
Column Name enttrain Data Type int Column Description Enttrain.
Column Name comptrain Data Type int Column Description Comptrain.
Column Name trn_ojt Data Type int Column Description Training - on job training.
Column Name trn_skillupg Data Type int Column Description Training - skill upgrade.
Column Name trn_entrep Data Type int Column Description Training - entrep.
Column Name trn_abe_esl Data Type int Column Description Training - abe esl.
Column Name trn_custom Data Type int Column Description Training - Custom.
Column Name trn_othoccskill Data Type int Column Description Training - other CC Skills.
Column Name emp_q1 Data Type int Column Description Employed quarter 1.
Column Name emp_q2 Data Type int Column Description Employed quarter 2.
Column Name emp_q3 Data Type int Column Description Employed quarter 3.
Column Name emp_q4 Data Type int Column Description Employed quarter 4.
Column Name type_uiwage_q1 Data Type int Column Description Type UI wage quarter 1.
Column Name type_fedemp_q1 Data Type int Column Description Type Federally employed quarter 1.
Column Name type_milemp_q1 Data Type int Column Description Type military employed quarter 1.
Column Name type_othadm_q1 Data Type int Column Description Type other administrative employment quarter 1.
Column Name type_supple_q1 Data Type int Column Description Type supplemental employment quarter 1.
Column Name type_uiwage_q2 Data Type int Column Description Type UI wage quarter 2.
Column Name type_fedemp_q2 Data Type int Column Description Type Federally employed quarter 2.
Column Name type_milemp_q2 Data Type int Column Description Type military employed quarter 2.
Column Name type_othadm_q2 Data Type int Column Description Type other administrative employment quarter 2.
Column Name type_supple_q2 Data Type int Column Description Type supplemental employment quarter 2.
Column Name type_uiwage_q3 Data Type int Column Description Type UI wage quarter 3.
Column Name type_fedemp_q3 Data Type int Column Description Type Federally employed quarter 3.
Column Name type_milemp_q3 Data Type int Column Description Type military employed quarter 3.
Column Name type_othadm_q3 Data Type int Column Description Type other administrative employment quarter 3.
Column Name type_supple_q3 Data Type int Column Description Type supplemental employment quarter 3.
Column Name type_uiwage_q4 Data Type int Column Description Type UI wage quarter 4.
Column Name type_fedemp_q4 Data Type int Column Description Type Federally employed quarter 4.
Column Name type_milemp_q4 Data Type int Column Description Type military employed quarter 4.
Column Name type_othadm_q4 Data Type int Column Description Type other administrative employment quarter 4.
Column Name type_supple_q4 Data Type int Column Description Type supplemental employment quarter 4.
Column Name emp_trn Data Type int Column Description Employment training.
Column Name non_trad Data Type int Column Description Non-traditional.
Column Name empreg11 Data Type int Column Description Empreg11.
Column Name empreg10 Data Type int Column Description Empreg10.
Column Name empreg00 Data Type int Column Description Empreg00.
Column Name empreg01 Data Type int Column Description Empreg01.
Column Name attcred Data Type int Column Description Attcred.
Column Name performance Data Type int Column Description Performance.
Column Name adult_er Data Type int Column Description Adult ER.
Column Name d_adult_er Data Type int Column Description D adult ER.
Column Name adult_ret Data Type int Column Description Adult ret.
Column Name d_adult_ret Data Type int Column Description D adult ret.
Column Name adult_ret12 Data Type int Column Description Adult ret 12.
Column Name d_adult_ret12 Data Type int Column Description D adult ret 12.
Column Name emp_q5 Data Type int Column Description Emp q5.
Column Name type_uiwage_q5 Data Type int Column Description Type UI wage q5.
Column Name type_supple_q5 Data Type int Column Description Type supplemental q5.
Column Name type_othadm_q5 Data Type int Column Description Type other administrative q5

recessionPeriods

Recession Periods
Column Name Data Type Column Description
Column Name id Data Type int Column Description Record id. - Primary Key
Column Name year Data Type float Column Description Year.
Column Name period Data Type varchar (3) Column Description Period.
Column Name unemploymentRate Data Type float Column Description Unemployment rate.
Column Name recession Data Type bool Column Description Recession.