Code Monkey home page Code Monkey logo

historicalminwage's Introduction

State and sub-state historical minimum wage data

The repository creates daily, monthly, quarterly, and annual panel datasets of historical state and sub-state minimum wages.

Latest data

Do you just want the data? Go here for the latest release containing data through December 31, 2022.

The data is available as Excel .xlsx spreadsheets or Stata .dta files, along with .pdf files of the sources for all of the historical changes.

Documentation

This replication package contains the Stata code and raw spreadsheets needed to create state-level and sub-state-level minimum wage datasets.

The original release of this data is described in Vaghul and Zipperer (2016), available here.

To replicate the data, clone this repository, set your Stata working directory to the code/ directory, and run state_mw.do and then substate_mw.do. Running the code will update and replace the contents of the exports/ and release/ folders.

File contents

code/

These do-files create all of the datasets.

  • state_mw.do - creates a state-level data
  • substate_mw.do - creates substate-level data (requires output of state_mw.do)

rawdata/

The do-files require the following spreadsheets:

  • SubstateMinimumWage_Changes.xlsx - substate-level changes
  • StateMinimumWage_Changes.xlsx - state-level changes
  • FederalMinimumWage_Changes.xlsx - federal changes
  • FIPS_crosswalk.xlsx - state geography

historicalminwage's People

Contributors

benzipperer avatar kvaghul avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

historicalminwage's Issues

zipfile function call fails to name files

Running STATA SE 14.2

Line 253 of "state_mw.do" when run as is generates the following error:

specify at least one file or folder to include in the zip file
r(198);

The following replacement seems to fix and allow for the whole file to run without error:
zipfile ${exports}mw_state_annual.dta ${exports}mw_state_quarterly.dta ${exports}mw_state_monthly.dta ${exports}mw_state_daily.dta ${exports}mw_state_changes.dta, saving(${exports}mw_state_stata.zip, replace)

The removal calls in lines 255 - 259 also require ${exports} appended to each name

A similar fix is needed for line 263 and onward

Note: My first thought was that I had a space somewhere in my directory path, but I didn't. My version of STATA doesn't naturally parse !cp or !mv. I added a new line to save these files elsewhere as a workaround, I'm not familiar enough with these calls to suggest fixes

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.