Public Org-Structure Database
This prototype site hosts documentation and (optionally) public snapshots of a research database on senior management team structure. Use the downloads below or browse the navigation for the codebook, coverage, and methods.
About
We introduce a public, hand-collected organizational-structure database covering 521 S&P 500 firms (1993–2020) with 161,028 executive-firm-year observations across 11,658 firm-years. Executive lists were manually extracted from annual reports, 10-K filings, and DEF 14A proxy statements, then titles were categorized into six managerial role groups and twelve hierarchical levels using fine-tuned large language models. The data are linkable to standard sources via CUSIP, GVKEY, and ticker, enabling longitudinal and cross-industry research on top-management team composition and firm structure.
- Coverage: 1993–2020, 521 firms, 11,658 firm-years, 161,028 executive-firm-year observations
- Identifiers:
GVKEY,CUSIP,ticker - Sources: 10-K, DEF 14A (proxy statements), Annual Reports
- Motivation: Public provision of a large hand-collected dataset on top-management team roles and hierarchy to enable organization-design/strategy research
This database is freely available and provided for general informational, educational, and research purposes only.
This database is provided “as is” and may contain errors. Errors naturally occur in the research process and, for this database, can come from sources such as:
• Incorrect manual entry of data
• Revisions of financial statements not captured in the database
• LLM models incorrectly coding roles into different categoriesWe have endeavored to limit these errors but recognize the database is not error free.
To the fullest extent permitted by law, the maintainers and contributors disclaim all warranties, whether expressed or implied (including but not limited to accuracy, completeness, merchantability, fitness for a particular purpose, and non-infringement). We will not be liable for any claim, loss, or damages arising from use of or reliance on the data. Users assume all risk.
Public use or distribution of a substantial portion or derivative work from the database requires clear acknowledgment of XXXX as the source.
Downloads
License: Data are released under CC BY-NC 4.0. See the LICENSE file and our Terms & Disclaimer.