Database structure

The Comparative Legislators Database (CLD) comes as a relational database. This means that all tables can be joined with the Core table via one of two keys - the Wikipedia page ID or the Wikidata ID. These keys uniquely identify individual politicians.

For each legislature, the CLD holds nine tables:

• Core (sociodemographic data)
• Political (political data)
• History (full revision records of individual Wikipedia biographies)
• Traffic (daily user traffic on individual Wikipedia biographies starting from July 2007)
• Social (social media handles and personal website URLs)
• Portraits (URLs to portraits)
• Offices (public offices)
• Professions (professions)
• IDs (identifiers linking politicians to other files, databases, or websites)

The figure below illustrates this structure and the CLD’s content.