Data on department allocations

This dataset includes data on department allocations (1958-2021). There is one observation per department allocation per Commission (i.e., one observation per department per Commissioner per Commission). A new observation is created every time a change in the portfolio of a Commissioner leads to a change in who oversees a department. There can be multiple observations per individual per Commission if an individual oversees multiple departments or if the individual's portfolio changes during the Commission. Department allocations do not span Commissions. If a Commissioner oversees the same department for more than one Commission, there will be multiple observations, one for each Commission. The dataset indicates the start and end dates of each department allocation and the policy areas that correspond to each department.

department_allocations

Format

A data frame with 30 variables:

key_id

Numeric. An ID number that uniquely identifies each observation. Indicates the default sort order for the dataset.

commission_id

Numeric. The ID number that uniquely identifies each Commission. See the commissions dataset.

commission

String. The name of the Commission. See the commissions dataset.

commissioner_id

Numeric. An ID number that uniquely identifies each individual who was served as a Commissioner. See the commissioners dataset.

full_name

String. The full name of the Commissioner.

full_name_latin

String. The full name of the Commissioner using only basic Latin characters.

last_name

String. The last name of the Commissioner.

last_name_latin

String. The last name of the Commissioner using only basic Latin characters.

first_name

String. The first name of the Commissioner.

first_name_latin

String. The first name of the Commissioner using only basic Latin characters.

member_state_id

Numeric. An ID number that uniquely identifies each member state.

member_state

String. The name of the Commissioner's member state.

member_state_code

String. The two-letter code assigned by the Commission to the Commissioner's member state.

national_party_code

String. The common abbreviation of the Commissioner's national political party.

national_party_name

String. The name of the Commissioner's national political party in the Commissioner's member state's official language.

national_party_name_english

String. The name of the Commissioner's national political party in English.

political_group_code

String. The common abbreviation of the political group.

political_group_name

String. The name of the Commissioner's political group.

start_date

Date. The start date of the allocation. Allocations do not cross Commissions.

start_year

Numeric. The start year of the allocation. Allocations do not cross Commissions.

start_month

Numeric. The start month of the allocation. Allocations do not cross Commissions.

start_day

Numeric. The start day of the allocation. Allocations do not cross Commissions.

end_date

Date. The end date of the allocation. Allocations do not cross Commissions.

end_year

Numeric. The start year of the allocation. Allocations do not cross Commissions.

end_month

Numeric. The start month of the allocation. Allocations do not cross Commissions.

end_day

Numeric. The end day of the allocation. Allocations do not cross Commissions.

department_id

Numeric. An ID number that uniquely identifies each department. See the departments dataset.

department_name

String. The name of the department.

department_code

String. The common abbreviation of the department. Coded Not applicable of there is not an abbreviation for the department. Coded None for all Commissions prior to the Prodi Commission.

policy_area

String. The name of the policy area. See the policy_areas dataset.