Title: | Tools to Retrieve Economic Policy Institute Data Library Extracts |
---|---|
Description: | The Economic Policy Institute (<http://www.epi.org/>) provides researchers, media, and the public with easily accessible, up-to-date, and comprehensive historical data on the American labor force. It is compiled from Economic Policy Institute analysis of government data sources. Use it to research wages, inequality, and other economic indicators over time and among demographic groups. Data is usually updated monthly. |
Authors: | Bob Rudis [aut, cre] |
Maintainer: | Bob Rudis <[email protected]> |
License: | AGPL |
Version: | 0.4.0 |
Built: | 2025-01-01 02:49:12 UTC |
Source: | https://github.com/hrbrmstr/epidata |
Annual, weekly, and hourly wages and work hours show the average wages and work hours of wage and salary workers using data from the CPS ASEC (also known as the March CPS). Note that this data is not directly comparable to the CPS ORG data in median/average hourly wage.
get_annual_wages_and_work_hours()
get_annual_wages_and_work_hours()
tbl_df
data frame
CPS ASEC | Murphy and Welch (1989)
Economic Policy Institute Data Library
get_annual_wages_and_work_hours()
get_annual_wages_and_work_hours()
Return the average annual salaries for select wage groups, with particular focus on the highest wage earners. Note that this data is not directly comparable to wage deciles/percentiles.
get_annual_wages_by_wage_group()
get_annual_wages_by_wage_group()
Wages are in 2017 dollars. Population sample: All workers.
The average annual wages by wage group are taken from a 2010 article by Wojciech Kopczuk, Emmanuel Saez, and Jae Song. To extend this series, data for 2006 through 2017 are extrapolated from 2004 data using changes in wage shares computed from Social Security Administration wage statistics. We employ the midpoint of the bracket to compute total wage income in each bracket and sum all brackets. We then use interpolation to derive percentile cutoffs building from the bottom up to obtain the 0–90th percentile bracket and then estimate the remaining categories. This allows us to estimate the wage shares for upper wage groups. We use these wage shares computed for 2004 and later years to extend the Kopczuk, Saez, and Song series by adding the changes in share between 2004 and the relevant year to their series. To obtain absolute wage trends we use the SSA data on the total wage pool and employment and compute the real wage per worker (based on t heir share of wages and employment) in the different groups in 2017 dollars. For a detailed explanation, see the methodology for annual wages and hours.
tbl_df
with data filtered by the selected criteria.
data frame
Data source: SSA | Kopczuk, Saez, and Song (2010)
Economic Policy Institute Data Library
if (not_dos()) get_annual_wages_by_wage_group()
if (not_dos()) get_annual_wages_by_wage_group()
The black-white wage gap is the percent by which hourly wages of black workers are less than hourly wages of white workers. It is also often expressed as a wage ratio (black workers' share of white workers' wages) by subtracting the gap from 100 percent.
get_black_white_wage_gap(by = NULL)
get_black_white_wage_gap(by = NULL)
by |
|
A median black-white wage gap of 26.2 percent means that a typical black worker is paid 26.2 percent less per hour than a typical white worker.
An average black-white wage gap of 26.6 percent means that on average black workers are paid 26.6 percent less per hour than white workers.
A regression-based black-white wage gap of 15.2 percent means that on average black workers are paid 15.2 percent less per hour than white workers, all else held equal (controlling for gender, race and ethnicity, education, experience, and geographic location).
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
get_black_white_wage_gap() get_black_white_wage_gap("g")
get_black_white_wage_gap() get_black_white_wage_gap("g")
Return the nonwage payments, referred to as fringe benefits, and wages. Compensation includes employer payments for health insurance, pensions, and payroll taxes (primarily payments toward Social Security and unemployment insurance).
get_compensation_wages_and_benefits()
get_compensation_wages_and_benefits()
Wages are in 2016 dollars. Wage and salary workers (NIPA) | Private-sector workers (ECEC)
tbl_df
with data filtered by the selected criteria.
data frame
Data source: NIPA | ECEC
Economic Policy Institute Data Library
if (not_dos()) get_compensation_wages_and_benefits()
if (not_dos()) get_compensation_wages_and_benefits()
Retreive the share of the civilian noninstitutional population that is employed
get_employment_to_population_ratio(by = NULL)
get_employment_to_population_ratio(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
data frame
Economic Policy Institute Data Library
if (not_dos()) get_employment_to_population_ratio() if (not_dos()) get_employment_to_population_ratio("r") if (not_dos()) get_employment_to_population_ratio("grae")
if (not_dos()) get_employment_to_population_ratio() if (not_dos()) get_employment_to_population_ratio("r") if (not_dos()) get_employment_to_population_ratio("grae")
The gender wage gap is the percent by which hourly wages of female workers are less than hourly wages of male workers. It is also often expressed as a wage ratio (women's share of men's wages) by subtracting the gap from 100 percent.
get_gender_wage_gap(by = NULL)
get_gender_wage_gap(by = NULL)
by |
|
A median gender wage gap of 17.3 percent means that a typical woman is paid 17.3 percent less per hour than a typical man.
An average gender wage gap of 19.7 percent means that on average women are paid 19.7 percent less per hour than men.
A regression-based gender wage gap of 21.7 percent means that on average women are paid 21.7 percent less per hour than men, all else held equal (controlling for gender, race and ethnicity, education, experience, and geographic location).
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
get_gender_wage_gap() get_gender_wage_gap("r")
get_gender_wage_gap() get_gender_wage_gap("r")
Employer-sponsored health insurance (ESI) coverage shows the share of workers who received health insurance from their own job for which their employer paid for at least some of their health insurance coverage.
get_health_insurance_coverage(by = NULL)
get_health_insurance_coverage(by = NULL)
by |
|
Population sample: Private-sector workers age 18–64 & at least 20 hours/week and 26 weeks/year
tbl_df
with data filtered by the selected criteria.
data frame
Data source: CPS ASEC
Economic Policy Institute Data Library
if (not_dos()) get_health_insurance_coverage() if (not_dos()) get_health_insurance_coverage("r") if (not_dos()) get_health_insurance_coverage("gr")
if (not_dos()) get_health_insurance_coverage() if (not_dos()) get_health_insurance_coverage("r") if (not_dos()) get_health_insurance_coverage("gr")
The Hispanic-white wage gap is the percent by which hourly wages of Hispanic workers are less than hourly wages of white workers. It is also often expressed as a wage ratio (Hispanic workers' share of white workers' wages) by subtracting the gap from 100 percent.
get_hispanic_white_wage_gap(by = NULL)
get_hispanic_white_wage_gap(by = NULL)
by |
|
A median Hispanic-white wage gap of 29.6 percent means that a typical Hispanic worker is paid 29.6 percent less per hour than a typical white worker.
An average Hispanic-white wage gap of 30.1 percent means that on average Hispanic workers are paid 30.1 percent less per hour than white workers.
A regression-based Hispanic-white wage gap of 11.1 percent means that on average Hispanic workers are paid 11.1 percent less per hour than white workers, all else held equal (controlling for gender, race and ethnicity, education, experience, and geographic location).
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
get_hispanic_white_wage_gap() get_hispanic_white_wage_gap("g")
get_hispanic_white_wage_gap() get_hispanic_white_wage_gap("g")
(i.e., working or looking for work)
get_labor_force_participation_rate(by = NULL)
get_labor_force_participation_rate(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
get_labor_force_participation_rate() get_labor_force_participation_rate("r") get_labor_force_participation_rate("grae")
get_labor_force_participation_rate() get_labor_force_participation_rate("r") get_labor_force_participation_rate("grae")
Retreive the share of the labor force that has been unemployed for six months or longer
get_long_term_unemployment(by = NULL)
get_long_term_unemployment(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
get_long_term_unemployment() get_long_term_unemployment("r") get_long_term_unemployment("grae")
get_long_term_unemployment() get_long_term_unemployment("r") get_long_term_unemployment("grae")
The median wage is the hourly wage in the middle of the wage distribution; 50 percent of wage earners earn less and 50 percent earn more. The average wage is the arithmetic mean of hourly wages; or, the sum of all workers' hourly wages divided by the number of workers.
get_median_and_mean_wages(by = NULL)
get_median_and_mean_wages(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
get_median_and_mean_wages() get_median_and_mean_wages("r") get_median_and_mean_wages("gr")
get_median_and_mean_wages() get_median_and_mean_wages("r") get_median_and_mean_wages("gr")
Return tthe hourly minimum wage set by federal law. The real minimum wage is the federal hourly minimum wage adjusted for inflation.
get_minimum_wage()
get_minimum_wage()
Wages are in 2016 dollars, excluding the nominal federal minimum wage. Share of average wages based on the average wages of production and nonsupervisory workers. For state minimum wages, see EPI’s minimum wage tracker.
Population sample: Production and nonsupervisory workers (average wages)
tbl_df
with data filtered by the selected criteria.
data frame
Data source: U.S. Department of Labor Wage and Hour Division | CES
Economic Policy Institute Data Library
if (not_dos()) get_minimum_wage()
if (not_dos()) get_minimum_wage()
A regression-based non-high school wage penalty of 21.8 percent means that on average workers without a high school diploma are paid 21.8 percent less per hour than workers with a high school diploma, all else held equal (controlling for gender, race and ethnicity, education, experience, and geographic location).
get_non_high_school_wage_penalty(by = NULL)
get_non_high_school_wage_penalty(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
## Not run: get_non_high_school_wage_penalty() get_non_high_school_wage_penalty("g") ## End(Not run)
## Not run: get_non_high_school_wage_penalty() get_non_high_school_wage_penalty("g") ## End(Not run)
Employer-provided pension coverage shows the share of workers included in an employer-provided plan for which the employer paid for at least some of their pension coverage.
get_pension_coverage(by = NULL)
get_pension_coverage(by = NULL)
by |
|
Population sample: Private-sector workers age 18–64 & at least 20 hours/week and 26 weeks/year
tbl_df
with data filtered by the selected criteria.
data frame
Data source: CPS ASEC
Economic Policy Institute Data Library
if (not_dos()) get_health_insurance_coverage() if (not_dos()) get_health_insurance_coverage("r") if (not_dos()) get_health_insurance_coverage("gr")
if (not_dos()) get_health_insurance_coverage() if (not_dos()) get_health_insurance_coverage("r") if (not_dos()) get_health_insurance_coverage("gr")
Return the share of workers earning equal to or less than the poverty-level wage, or the hourly wage that a full-time, year-round worker must earn to sustain a family of four with two children at the official poverty threshold.
get_poverty_level_wages(by = NULL)
get_poverty_level_wages(by = NULL)
by |
|
Population sample: Wage and salary workers age 18–64. Data source: CPS ORG | Census Bureau (poverty threshold)
tbl_df
with data filtered by the selected criteria.
data frame
Economic Policy Institute Data Library
if (not_dos()) get_poverty_level_wages() if (not_dos()) get_poverty_level_wages("r") if (not_dos()) get_poverty_level_wages("gr")
if (not_dos()) get_poverty_level_wages() if (not_dos()) get_poverty_level_wages("r") if (not_dos()) get_poverty_level_wages("gr")
Productivity is how much workers produce per hour, or the growth of output of goods and services minus depreciation per hour worked. Compensation is made up of both nonwage payments and wages.
get_productivity_and_hourly_compensation(by = NULL)
get_productivity_and_hourly_compensation(by = NULL)
by |
|
Wages are in 2015 dollars. Median compensation is calculated using hourly wage medians from the CPS ORG and compensation from NIPA.
Population sample: All workers & Production and nonsupervisory workers
tbl_df
with data filtered by the selected criteria.
data frame
Data source: NIPA (compensation) | BLS Productivity Data
Economic Policy Institute Data Library
if (not_dos()) get_productivity_and_hourly_compensation() if (not_dos()) get_productivity_and_hourly_compensation("g")
if (not_dos()) get_productivity_and_hourly_compensation() if (not_dos()) get_productivity_and_hourly_compensation("g")
Underemployment is the share of the labor force that either 1) is unemployed, 2) is working part time but wants and is available to work full time (an "involuntary" part timer), or 3) wants and is available to work and has looked for work in the last year but has given up actively seeking work in the last four weeks ("marginally attached" worker).
get_underemployment(by = NULL)
get_underemployment(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
get_underemployment() get_underemployment("r") get_underemployment("grae")
get_underemployment() get_underemployment("r") get_underemployment("grae")
Retreive the share of the labor force without a job
get_unemployment(by = NULL)
get_unemployment(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
See get_unemployment_by_state()
for information on retrieving unemployment by state+race.
Economic Policy Institute Data Library
get_unemployment() get_unemployment("r") get_unemployment("grae")
get_unemployment() get_unemployment("r") get_unemployment("grae")
Retreive the share of the labor force without a job (by state)
get_unemployment_by_state(by = NULL)
get_unemployment_by_state(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
See get_unemployment()
for other unemployment extracts..
Economic Policy Institute Data Library
get_unemployment_by_state() get_unemployment_by_state("r")
get_unemployment_by_state() get_unemployment_by_state("r")
The union coverage rate shows the percentage of the workforce covered by a collective bargaining agreement.
get_union_coverage()
get_union_coverage()
tbl_df
data frame
Data source: CPS ORG | Hirsch and Macpherson (2003)
Economic Policy Institute Data Library
if (interactive()) get_union_coverage()
if (interactive()) get_union_coverage()
Wage inequality data shows the overall wage inequality and the within-group and between-group wage inequality over time. These measures allow an examination of how much of the change in overall wage inequality in particular periods was due to changes in within-group and between-group wage inequality.
get_wage_decomposition(by = NULL)
get_wage_decomposition(by = NULL)
by |
|
Population sample: Wage and salary workers age 18–64
tbl_df
with data filtered by the selected criteria.
data frame
Data source: CPS ORG
Economic Policy Institute Data Library
get_wages_by_percentile() get_wages_by_percentile("g")
get_wages_by_percentile() get_wages_by_percentile("g")
The 95–50 and 50–10 wage ratios are representations of the level of inequality within the hourly wage distribution. The larger the ratio, the greater the gap between the top and the middle or the middle and the bottom of the wage distribution.
get_wage_ratios(by = NULL)
get_wage_ratios(by = NULL)
by |
|
A 50–10 wage ratio of 1.91 means that workers at the 50th percentile of the wage distribution are paid 1.91 times more per hour than the workers at the 10th percentile.
A 95–50 wage ratio of 3.28 means that workers at the 95th percentile of the wage distribution are paid 3.28 times more per hour than the workers at the 50th percentile.
tbl_df
with data filtered by the selected criteria.
data frame
Economic Policy Institute Data Library
if (not_dos()) get_wage_ratios() if (not_dos()) get_wage_ratios("r") if (not_dos()) get_wage_ratios("gr")
if (not_dos()) get_wage_ratios() if (not_dos()) get_wage_ratios("r") if (not_dos()) get_wage_ratios("gr")
Wages by education are the average hourly wages of workers disaggregated by the highest level of education attained. Employment shares provide the distribution of educational attainment for workers of each gender, racial, and ethnic group as a share of total employed for each group.
get_wages_by_education(by = NULL)
get_wages_by_education(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
Economic Policy Institute Data Library
get_wages_by_education() get_wages_by_education("r") get_wages_by_education("gr")
get_wages_by_education() get_wages_by_education("r") get_wages_by_education("gr")
Wage percentiles are wages at ten distinct points in the wage distribution: deciles and the 95th percentile. The 95–50 and 50–10 wage ratios show how much greater wages are at the top than the middle, and at the middle than the bottom, respectively.
get_wages_by_percentile(by = NULL)
get_wages_by_percentile(by = NULL)
by |
|
tbl_df
with data filtered by the selected criteria.
data frame
Economic Policy Institute Data Library
get_wages_by_percentile() get_wages_by_percentile("r") get_wages_by_percentile("gr")
get_wages_by_percentile() get_wages_by_percentile("r") get_wages_by_percentile("gr")
Not DoS'ing EPI/Cloudflare
not_dos()
not_dos()
logical