4 ms·
The data is scraped from this (which is paywalled, apologies): https://www.wsj.com/graphics/ceo-pay-for-the-sp500/?mod=hp_lead_pos10 https://www.wsj.com/graphic
by kpmcc 6y ago
The data is scraped from this (which is paywalled, apologies): https://www.wsj.com/graphics/ceo-pay-for-the-sp500/?mod=hp_lead_pos10 https://www.wsj.com/graphics/ceo-pay-for-the-sp500/?mod=hp_l...
Edit: Seeing a lot of people complaining about the data quality. A lot of the more interesting breakdown on salary vs stock etc was only available by clicking on each row. Maybe a more advanced scrape could reveal that stuff.
- coderintherye 6y agoThis is a great idea and the Google Sheet share is a great format, but there are many flaws in the representation of the data. A great, immediate change would be to add a row at the top indicating some of the flaws, and then start making incremental changes to fix them (e.g. create a column for stock based compensation). Cause overall this is a great topic, just needs some work so people can focus on the topic at hand rather then get bogged down in the data quality issue.
- kpmcc 6y agoAppreciate it. Meant it mostly as a "Wow didn't know X company had 1000 to 1 CEO to median pay ratio". I'll see if I can get some more data / detail on what goes into the pay numbers.