Create minimum wage measures at the zcta-year level

[santiagohermo]

In this issue we want to:

• Create residence and workplace minimum wage measures at the zcta-month level and aggregate at zcta-year level
• Create leave-one-out workplace minimum wage measure

[santiagohermo]

Hi @diegogentilepassaro! I started here. To recap, we need to:

1. Create a zcta-year statutory minimum wage variable in derived/min_wage_panels
2. Create the residence, workplace, and leave-out workplace minimum wage measures in derived/min_wage_measures

I started with the first step.

In https://github.com/diegogentilepassaro/min_wage_rent/commit/da2c34b48d75466b54c4ed094faf00dd93eba761 I duplicated the code that creates the usps zip panel in derived/min_wage_panels. Now, in that folder we have:

• build_usps.R: creates the statutory MW at the zipcode-month level, as before
• build_zcta.R: creates the statutory MW at the zcta-month and zcta-year levels

Unfortunately, I can't even load the census block master in my computer, so I need your help. Can you do the following?

First, can you check whether we need these lines of codes?

• These lines assign the federal mw to zip codes lower than 199, which are national parks and stuff.
• I'm not sure if something analogous exists for ZCTAs.

You need to check whether those zipcodes are also in zcta, and whether it makes sense to impute the federal MW for them. You also need to check whether there are any census blocks with missing minimum wage after you run the function in this line.

Second, and after you checked the previous step, can you run the full code?

[santiagohermo]

What to do:

• Check what is the zcta code of the zipcodes with code lower than 00199
• Run the code up to here, check whether some rows with valid zcta do not have a minimum wage
• Decide what to do with these lines which assign the federal MW to weird usps zip codes