portfolio_allocations: Data on portfolio allocations
In jfjelstul/ecio: The European Commission Internal Organization (ECIO) Database

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

1	portfolio_allocations

A data frame with 28 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.
portfolio: string. The Commissioner's portfolio. If the portfolio has multiple components, they are listed, separated by a semi-colon.
departments: string. A list of the departments that the portfolio includes, separated by a semi-colon.