Joining Paycheck Protection Loan and Department of Labor Violation Datasets

Placekey is an open entity matching service for places and addresses that helps with deduping, matching, syncing, and merging physical places. If you are interested in doing this join on your own sign up and use the join dataset tool in the developer dashboard.

Introduction: Combining Datasets with Placekey

If you are analyzing economic data in the United States, you're likely familiar with the Small Business Administration Paycheck Protection Program (PPP) loans and Department of Labor Wage and Hour Compliance datasets. These datasets provide insights into the financial support given to businesses over the pandemic and the enforcement of labor laws.

We wanted to explore how combining these two datasets could yield deeper insights into the economic landscape during the pandemic. Merging these datasets took just seconds with Placekey. By merging these datasets, we can quickly see which businesses both received PPP loans and had wage violations.

We used the join datasets tool available in the developer dashboard. This enables us to uncover insights in a few clicks related to paycheck protection program violations and COVID-19 labor law compliance, shedding light on the broader implications for employee rights and labor law protections during and after the pandemic.

Insights from Joining the Datasets

Placekeys were applied to 9,599,738 addresses in the Paycheck Protection Program Loan dataset and 347,864 addresses of the Department of Labor Wage & Hour Compliance dataset. 20,939 Placekeys overlapped between the two datasets.

Here are some key insights from the join:

Department of Labor Wage and Hour Compliance data:

• ~6% of Department of Labor Wage and Hour Compliance data matched to Paycheck Protection Program Loan entries
• Department of Labor Wage and Hour Compliance data added 20,939 values for ‘Fair Labor Standards Act (FLSA) Homeworkers Violation Count’' and MSPA Compliance Assessed Amount'  to Paycheck Protection Program Loan Data

Paycheck Protection Program Loan Data:

• ~0.25% of Paycheck Protection Program Loan Data matched to Department of Labor Wage and Hour Compliance data (of its 9 million entries)
• Paycheck Protection Program Loan Data added 20,939 values for 'BorrowerAddress' and 'Ethnicity' to Department of Labor Wage and Hour Compliance data

These insights can help us understand the overlap between businesses who received a PPP loan and are involved in Department of Labor violations.

How to Perform the Join Yourself

You can replicate this process in minutes:

1. Sign up and navigate to the Join Dataset section in the dashboard.
2. Both datasets are already Placekey-enabled and free to join and download.
3. Upload additional datasets if needed, append Placekeys, and join them to existing datasets.

The Placekey API offers up to 10k Placekeys per day for free, making it easy for developers and analysts to perform these joins programmatically.

About the Datasets

The Paycheck Protection Program (PPP) Loan Data offers a comprehensive look at loans distributed to small businesses as part of the pandemic relief effort. This dataset, maintained by the U.S. Small Business Administration (SBA), includes details about loan amounts, recipients, and industries, providing valuable insights into how financial assistance was distributed and its economic impact during COVID-19.

The Department of Labor Wage & Hour Compliance Data sheds light on workplace fairness by tracking violations of wage and hour laws across various industries. This dataset highlights patterns in labor law enforcement and helps identify sectors where workers' rights may require additional protections.

What is Placekey?

Placekey is an open entity matching service for places and addresses, designed for deduping, matching, and syncing location data. With Placekey, you can easily join address based datasets, like the ones discussed here, to streamline data analysis. For a deeper dive into how Placekey works, explore the documentation. You can apply a Placekey to data that has fields like street address, city, region, postal code, and country code, or latitude and longitude.

Use Cases and Further Analysis

The joined datasets offer numerous opportunities for further exploration. Potential use cases include:

• Identifying common violations related to COVID-19 paycheck loans.
• Analyzing the impact of PPP loans on labor law compliance.
• Building machine learning models to predict potential violations based on loan data.

These analyses can help us answer pressing questions like "What are the common violations related to COVID-19 paycheck loans?" and "How do paycheck protection loans affect labor law compliance?"

Conclusion

The ability to join datasets quickly and efficiently with Placekey opens the door to new insights and analyses. By understanding the interaction between PPP loans and labor law compliance, we can better navigate the complexities of pandemic-related financial assistance and its implications on employee rights. Try Placekey for yourself, explore these datasets, and uncover insights that matter to you.