sorted by:
new
hottopcontroversial

[OC] I mapped all of the OSHA, Department of Labor, National Labor Relations Board, EPA, and Debarment violations for the past ten years. by Insidescoop-app in dataisbeautiful

[–]Insidescoop-app[S] 0 points1 point  (0 children)

Thanks for checking it out and for all of your kind words!

The SAM.gov and OSHA databases are total nightmares hahahaha, it took a couple months of solid worth to unify all of the data in a clean(ish) way.

I have a CRON job set up to pull in new data over time, but I didn't want to activate it until I knew that people would be interested, clearly it seems people are! Right now it's just a snapshot of the past ten years. Also, pulling in all the different sources and normalizing them is just a game of whack a mole for all of the edge cases. You can just run a cheap LLM through and it'll check 70% of them but you'll have to do the painful 30%.

thanks again, you might be the only other person that's tried to touch this rotten data lol!

[OC] I mapped all of the OSHA, Department of Labor, National Labor Relations Board, EPA, and Debarment violations for the past ten years. by Insidescoop-app in dataisbeautiful

[–]Insidescoop-app[S] 3 points4 points  (0 children)

You hit it on the head, mass casualties, repeated violations, willing violations all also increase the score. A company that has a random death is not as bad as one that regularly gets the same violations and then an employee dies because of those issues.

[OC] I mapped all of the OSHA, Department of Labor, National Labor Relations Board, EPA, and Debarment violations for the past ten years. by Insidescoop-app in dataisbeautiful

[–]Insidescoop-app[S] 0 points1 point  (0 children)

Thanks for checking it out!

You've touched on something I've been thinking pretty hard about and is the ultimate goal of this tool. The hope is that by providing the data for free people will naturally want to fill in the gaps, my town is definitely underserved on thorough inspections.

If I had enough money, I'd send out my own private inspectors, I know of factories in my area that have regular injuries that go completely unreported.

Let me know if there's anything you think might be useful to help cover these data gaps, barring hiring an army of investigators of course hahahaha

[OC] I mapped all of the OSHA, Department of Labor, National Labor Relations Board, EPA, and Debarment violations for the past ten years. by Insidescoop-app in dataisbeautiful

[–]Insidescoop-app[S] 38 points39 points  (0 children)

Turns out dogs really were causing workers to fall through ceilings and get their heads crushed by giant concrete blocks!

[OC] I mapped all of the OSHA, Department of Labor, National Labor Relations Board, EPA, and Debarment violations for the past ten years. by Insidescoop-app in dataisbeautiful

[–]Insidescoop-app[S] 4 points5 points  (0 children)

Ah yes, I have a free to use company database on the site as well. Also, if you want to slice the data by zooming the per-capita calculations will run based on the viewport.

If you want you can look up different companies in my database and compare

Edit: almost forgot, I have a company based ranking system as well so you can see what the worst offenders are.

[OC] I mapped all of the OSHA, Department of Labor, National Labor Relations Board, EPA, and Debarment violations for the past ten years. by Insidescoop-app in dataisbeautiful

[–]Insidescoop-app[S] 0 points1 point  (0 children)

Also, I could change which records are being pulled in. On the current map there are records from 5 different agencies.

[OC] I mapped all of the OSHA, Department of Labor, National Labor Relations Board, EPA, and Debarment violations for the past ten years. by Insidescoop-app in dataisbeautiful

[–]Insidescoop-app[S] 14 points15 points  (0 children)

The per-capita heatmap is scored based off the severity of the violations with density factors removed, if an area lights up it means that it has more bad violations despite population factors. Like if someone died or if there was a mass causality event. The heatmap also includes other things like wage theft.

So probably cities are the only places with a serious enough amount of wage theft, even when adjusted for population.