1
2
3
4
5
#

Name:

Description:

While looking online for a clean dataset for minimum wage data by state, I was having trouble finding one. Thus, I decided to create one myself and provide it to the community! I truly believe that supporting a country's/state's workers is incredibly important, and support (or lack thereof) should be transparent.

I scraped the data from the US Department of Labor's website. The GitHub repository (with R Code for the cleaning process) can be found here!

Variables:

This is a cleaned data set of US state and federal minimum wages from 1968 to 2017 (including 2018 equivalency values).

The values in the dataset are as follows:

  • Year: The year of the data.

  • State: The state or territory of the data.

  • Table_Data: The scraped value from the source.

  • Footnote: The footnote associated with the Table_Data. See more below in the dataset description. You can alternatively find them at the bottom of the US Department of Labor's page.

  • High.Value: As there were some values in Table_Data that had multiple values (usually associated with footnotes), this is the higher of the two values in the table. It could be useful for viewing the proposed minimum wage, because in most cases, the higher value meant that all persons protected under minimum wage laws eventually had minimum wage set at that value.

  • Low.Value: This is the same as High.Value, but has the lower of the two values. This could be useful for viewing the effective minimum wage at the year of setting the minimum wage, as peoples protected under such minimum wage laws made that value during that year (although, in most cases, they had a higher minimum wage after that year).

  • CPI.Average: This is the Consumer Price Index associated with that year. It was used to calculate 2018-equivalent values.

  • High.2018: This is the 2018-equivalent dollars for High.Value.

  • Low.2018: This is the 2018-equivalent dollars for Low.Value.

Link To Google Sheets:

Rows:

Columns:

License Type:

References/Notes/Attributions:

R Dataset Upload:

Use the following R code to directly access this dataset in R.

d <- read.csv("https://www.key2stats.com/US_Minimum_Wage_by_State_from_1968_to_2017_1587_1.csv")

R Coding Interface:


Datasets Tag Questions & Instructional Blocks

NumberContentType
No results found.