- A
‘Baltimore City Employee Salaries’ analyzed by Analyst-2
- analyst-2.ai
Updated Oct 29, 2021
Share
Facebook
Twitter
EmailClick to copy linkLink copiedCiteAnalyst-2 (analyst-2.ai) / Inspirient GmbH (inspirient.com) (2021). ‘Baltimore City Employee Salaries’ analyzed by Analyst-2 [Dataset]. https://analyst-2.ai/analysis/data-gov-baltimore-city-employee-salaries-ac87/latestDataset updatedOct 29, 2021Dataset authored and provided byAnalyst-2 (analyst-2.ai) / Inspirient GmbH (inspirient.com)LicenseAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automaticallyArea coveredBaltimoreDescriptionAnalysis of ‘Baltimore City Employee Salaries’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/09dd5c6e-6cc5-4322-adf7-8c0a6616dbc7 on 12 February 2022.
--- Dataset description provided by original source is as follows ---
This dataset includes Baltimore City employee salaries and gross pay from fiscal year 2011 through last fiscal year and includes employees who were employed on June 30 of the last fiscal year. For fiscal years 2020 and prior, data are extracted from the ADP payroll system. For fiscal year 2021, the data are combined from the ADP system and the Workday enterprise resource planning system which now includes payroll.
Change Log
2021-10-29:
- Added FY2021 data
- Metadata added
- Columns renamed to a standard format
- Youth workers not employed by City removed
- Agency names reformatted with Workday conventionsData Dictionary
field_name description data_type range_of_possible_values example_values firstName The first name of the employee. Text N/A middleInitial The middle initial of the employee. Text N/A lastName The last name of the employee. Text N/A jobClass The job classification of the employee. Job classifications are a standardized system of job responsibilities and pay and are frequently not the same as an employee's functional title. Participants in Youthworks who were not employed by the City are not included in this dataset. Category There are 1,898 unique job classficiations in this dataset. "911 OPERATOR" ; "LABORER" ; "CDL DRIVER I" ; "OPERATIONS MANAGER III" agencyID A unique identifier for the agency or department the employee works for. There is a one-to-one relationship between the agencyID and agencyName fields. Text There are 73 unique agencyID values corresponding to 73 unique agencyName values. "A01" ; "A54"; "R01" agencyName The name of the agency or department the employee works for. There is a one-to-one relationship between the agencyID and agencyName fields. The agencyID is typically a letter followed by two numbers though there are a few exceptions. Text There are 73 unique agencyID values corresponding to 73 unique agencyName values. "Police Department" ; "Public Works - Solid Waste (weekly)" ; "Convention Center" hireDate The date the employee was hired. Date 6/23/1951 through 6/30/2021 4/3/1979 annualSalary The employee's base annual salary for the fiscal year. Number 0 through 276375 grossPay The total sum of compensation the employee received during the fiscal year. To be included in this dataset the employee must have earned more than $0.00 in the fiscal year. Number 1.71 through 373111.20 fiscalYear The fiscal year during which the employee worked for the city. Fiscal years for the City begin July 1 and end June 30 each year. Employees must have earned more than $0.00 during the fiscal year to be included for that year. Category FY2011 through FY2021 "FY2021" --- Original source retains full ownership of the source dataset ---
- A
‘Baltimore City Employee Salaries’ analyzed by Analyst-2
- analyst-2.ai
Updated Oct 29, 2021ShareFacebookTwitterEmailClick to copy linkLink copiedCiteAnalyst-2 (analyst-2.ai) / Inspirient GmbH (inspirient.com) (2021). ‘Baltimore City Employee Salaries’ analyzed by Analyst-2 [Dataset]. https://analyst-2.ai/analysis/data-gov-baltimore-city-employee-salaries-5404/41593ccf/?iid=005-376&v=presentationDataset updatedOct 29, 2021Dataset authored and provided byAnalyst-2 (analyst-2.ai) / Inspirient GmbH (inspirient.com)LicenseAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automaticallyArea coveredBaltimoreDescriptionAnalysis of ‘Baltimore City Employee Salaries’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/e35392a8-b2b3-4748-b696-1637b8e774a0 on 12 February 2022.
--- Dataset description provided by original source is as follows ---
This dataset includes Baltimore City employee salaries and gross pay from fiscal year 2011 through last fiscal year and includes employees who were employed on June 30 of the last fiscal year. For fiscal years 2020 and prior, data are extracted from the ADP payroll system. For fiscal year 2021, the data are combined from the ADP system and the Workday enterprise resource planning system which now includes payroll.
Change Log
2021-10-29:
- Added FY2021 data
- Metadata added
- Columns renamed to a standard format
- Youth workers not employed by City removed
- Agency names reformatted with Workday conventionsData Dictionary
field_name description data_type range_of_possible_values example_values firstName The first name of the employee. Text N/A middleInitial The middle initial of the employee. Text N/A lastName The last name of the employee. Text N/A jobClass The job classification of the employee. Job classifications are a standardized system of job responsibilities and pay and are frequently not the same as an employee's functional title. Participants in Youthworks who were not employed by the City are not included in this dataset. Category There are 1,898 unique job classficiations in this dataset. "911 OPERATOR" ; "LABORER" ; "CDL DRIVER I" ; "OPERATIONS MANAGER III" agencyID A unique identifier for the agency or department the employee works for. There is a one-to-one relationship between the agencyID and agencyName fields. Text There are 73 unique agencyID values corresponding to 73 unique agencyName values. "A01" ; "A54"; "R01" agencyName The name of the agency or department the employee works for. There is a one-to-one relationship between the agencyID and agencyName fields. The agencyID is typically a letter followed by two numbers though there are a few exceptions. Text There are 73 unique agencyID values corresponding to 73 unique agencyName values. "Police Department" ; "Public Works - Solid Waste (weekly)" ; "Convention Center" hireDate The date the employee was hired. Date 6/23/1951 through 6/30/2021 4/3/1979 annualSalary The employee's base annual salary for the fiscal year. Number 0 through 276375 grossPay The total sum of compensation the employee received during the fiscal year. To be included in this dataset the employee must have earned more than $0.00 in the fiscal year. Number 1.71 through 373111.20 fiscalYear The fiscal year during which the employee worked for the city. Fiscal years for the City begin July 1 and end June 30 each year. Employees must have earned more than $0.00 during the fiscal year to be included for that year. Category FY2011 through FY2021 "FY2021" --- Original source retains full ownership of the source dataset ---
Not seeing a result you expected?
Learn how you can add new datasets to our index.
FacebookTwitterEmailAttribution 4.0 (CC BY 4.0)https://creativecommons.org/licenses/by/4.0/
License information was derived automatically
Analysis of ‘Baltimore City Employee Salaries’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://catalog.data.gov/dataset/09dd5c6e-6cc5-4322-adf7-8c0a6616dbc7 on 12 February 2022.
--- Dataset description provided by original source is as follows ---
This dataset includes Baltimore City employee salaries
and gross pay from fiscal year 2011 through last fiscal year and
includes employees who were employed on June 30 of the last fiscal year.
For fiscal years 2020 and prior, data are extracted from the ADP
payroll system. For fiscal year 2021, the data are combined from the ADP
system and the Workday enterprise resource planning system which now
includes payroll.
Change Log
2021-10-29:
- Added FY2021 data
- Metadata added
- Columns renamed to a standard format
- Youth workers not employed by City removed
- Agency names reformatted with Workday conventions
Data Dictionary
| field_name | description | data_type | range_of_possible_values | example_values |
| firstName | The first name of the employee. | Text | N/A | |
| middleInitial | The middle initial of the employee. | Text | N/A | |
| lastName | The last name of the employee. | Text | N/A | |
| jobClass | The job classification of the employee. Job classifications are a standardized system of job responsibilities and pay and are frequently not the same as an employee's functional title. Participants in Youthworks who were not employed by the City are not included in this dataset. | Category | There are 1,898 unique job classficiations in this dataset. | "911 OPERATOR" ; "LABORER" ; "CDL DRIVER I" ; "OPERATIONS MANAGER III" |
| agencyID | A unique identifier for the agency or department the employee works for. There is a one-to-one relationship between the agencyID and agencyName fields. | Text | There are 73 unique agencyID values corresponding to 73 unique agencyName values. | "A01" ; "A54"; "R01" |
| agencyName | The name of the agency or department the employee works for. There is a one-to-one relationship between the agencyID and agencyName fields. The agencyID is typically a letter followed by two numbers though there are a few exceptions. | Text | There are 73 unique agencyID values corresponding to 73 unique agencyName values. | "Police Department" ; "Public Works - Solid Waste (weekly)" ; "Convention Center" |
| hireDate | The date the employee was hired. | Date | 6/23/1951 through 6/30/2021 | 4/3/1979 |
| annualSalary | The employee's base annual salary for the fiscal year. | Number | 0 through 276375 | |
| grossPay | The total sum of compensation the employee received during the fiscal year. To be included in this dataset the employee must have earned more than $0.00 in the fiscal year. | Number | 1.71 through 373111.20 | |
| fiscalYear | The fiscal year during which the employee worked for the city. Fiscal years for the City begin July 1 and end June 30 each year. Employees must have earned more than $0.00 during the fiscal year to be included for that year. | Category | FY2011 through FY2021 | "FY2021" |
--- Original source retains full ownership of the source dataset ---