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.