Awesome

legislatoR: Interface to the Comparative <img src="images/sticker.jpg" width="160" align="right" /> <br /> Legislators Database

legislatoR is a package for the software environment R that facilitates access to the Comparative Legislators Database (CLD). The CLD includes political, sociodemographic, career, online presence, public attention, and visual information for over 67,000 contemporary and historical politicians from 16 countries. Data are also available for download in .csv and .sqlite formats at the CLD's Dataverse.

Content and data structure

The CLD covers the following countries and time periods:

* We only count legislators with a unique Wikipedia page or Wikidata ID. Sometimes legislators do not have either. Such cases are indicated by the string "miss" in the wikidataid or pageid.

For each legislature, the CLD holds nine tables:

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

The tables contain the following variables (see respective R help files for further details):

• Core: Country, Wikipedia page ID, Wikidata ID, Wikipedia Title, full name, sex, ethnicity, religion, date of birth and death, place of birth and death.
• Political: Wikipedia page ID, legislative session, party affiliation, lower constituency, upper constituency, constituency ID, start and end date of legislative session, period of service, majority status, leader positions.
• History: Wikipedia page ID, Wikipedia revision and previous revision ID, editor name/IP and ID, revision date and time, revision size, revision comment.
• Traffic: Wikipedia page ID, date, user traffic.
• Social: Wikidata ID, Twitter handle, Facebook handle, Youtube ID, Google Plus ID, Instagram handle, LinkedIn ID, personal website URL.
• Portraits: Wikipedia page ID, Wikipedia portrait URL.
• Offices: Wikidata ID, a range of offices such as attorney general, chief justice, mayor, party chair, secretary of state, etc.
• Professions: Wikidata ID, a range of professions such as accountant, farmer, historian, judge, mechanic, police officer, salesperson, teacher, etc.
• IDs: Wikidata ID, IDs for integration with various political science datsets as well as a range of other IDs such as parliamentary website IDs, Library of Congress or German National Library IDs, Notable Names Database or Project Vote Smart IDs, etc.

Note that for some legislatures or legislative periods, tables may only hold information for a subset of politicians or variables.

The 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. The figure below illustrates this structure and the CLD's content.

Installation

legislatoR is available through CRAN and GitHub. To install the package from CRAN, type:

install.packages("legislatoR")

To install the package from Github, type:

devtools::install_github("saschagobel/legislatoR")

Usage

A working Internet connection is required to access the CLD in R. This is because the data are stored online and not installed together with the package. The package provides table-specific function calls. These functions are named after the respective table (see above) and preceded by get_. To fetch the Core table, use the get_core() function, for the Political table, use the get_political() function. Call the package help file via ?legislatoR() to get an overview of all function calls. Tables are legislature-specific, so a three-letter country code must be passed as an argument to the function. Here is a breakdown of all country codes. You can also call the cld_content() function to get an overview of the CLD's scope and valid country codes.

Tables can be joined and subsetted while being fetched and memory is only allocated by the parts of a table assigned into the environment. Basic fetching, joining, and subsetting of data are illustrated below. See the Vignette Introducing legislatoR for a detailed tutorial.

# load and attach legislatoR and dplyr
library(legislatoR)
library(dplyr)

# assign entire Core table for the German Bundestag into the environment
deu_politicians <- get_core(legislature = "deu")

# assign data for the 8th legislative session into the environment
deu_politicians_subset <- semi_join(x = get_core(legislature = "deu"),
				                            y = filter(get_political(legislature = "deu"), session == 8), 
			                              by = "pageid")

# join deu_politicians_subset with respective traffic on Wikipedia biographies
deu_traffic <- left_join(x = deu_politicians_subset, 
               		       y = get_traffic(legislature = "deu"), 
		                     by = "pageid")

# assign birthdate for members of the political party 'SPD' into the environment
deu_birthdates_SPD <- semi_join(x = select(get_core(legislature = "deu"), pageid, birth),
                                y = filter(get_political(legislature = "deu"), party == "SPD"),
                                by = "pageid")$birth

News

See here for details on updates.

Glossary

See here for the full form of abbreviated country codes and party names and English translations of non-English party names.

Sources

The CLD was predominantly built using automated data extraction techniques. See the source code and this list of Web sources for more details.

Citation

Thank you for using the CLD and legislatoR! Please consider citing:

Göbel, Sascha and Simon Munzert. 2022. "The Comparative Legislators Database". British Journal of Political Science, 52(3), 1398-1408.

Support

The work on this package was in part funded by the Daimler and Benz Foundation (Funding period 2017/18; project "Citizen and Elite Activity on the Wikipedia Market Place of Political Information").

Many thanks to Anna Wunderling for designing legislatoR's logo.

Author information

Sascha Göbel (corresponding author and repository maintainer) <br /> Goethe University Frankfurt <br /> Faculty of Social Sciences <br /> Theodor-W.-Adorno-Platz 6 <br /> 60323 Frankfurt am Main, Germany <br /> Email: sascha.goebel@soz.uni-frankfurt.de

Simon Munzert <br /> Hertie School