Data on department histories

This dataset includes data on the histories of the current departments of the Commission, including Directorates-General and service departments (1958-2021). There is one observation per historical interval in which the nomenclature of a department is constant. Unlike allocations, intervals can span Commissions. By sorting the dataset by current department, you can see the evolution of each department over time. The dataset indicates the Commissions associated with each interval and the start and end dates of each interval.

department_histories

Format

A data frame with 21 variables:

key_id

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

current_deparment_id

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

current_department_name

String. The name of the current department. See the departments dataset.

current_department_code

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

current_department_type_id

Numeric. An ID number that uniquely identifies the type of the current department. Coded 1 for Directorate-General and 2 for Service department. See the variable department_type.

current_department_type

String. The type of the current department. Either Directorate-General or Service department.

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.

department_type_id

Numeric. An ID number that uniquely identifies the type of the department. Coded 1 for Directorate-General and 2 for Service department. See the variable department_type.

department_type

String. The type of the department. Either Directorate-General or Service department.

commissions

String. A list of the Commissions in which the department appeared, separated by a comma.

count_commissions

Numeric. The number of Commissions in which the department appeared.

start_date

Date. The start date of the historical interval. Historical intervals can cross Commissions.

start_year

Numeric. The start year of the historical interval. Historical intervals can cross Commissions.

start_month

Numeric. The start month of the historical interval. Historical intervals can cross Commissions.

start_day

Numeric. The start day of the historical interval. Historical intervals can cross Commissions.

end_date

Date. The end date of the historical interval. Historical intervals can cross Commissions.

end_year

Numeric. The start year of the historical interval. Historical intervals can cross Commissions.

end_month

Numeric. The start month of the historical interval. Historical intervals can cross Commissions.

end_day

Numeric. The end day of the historical interval. Historical intervals can cross Commissions.