cincinnati-oh-gov/city-of-cincinnati-employees-w-salaries-wmj4-ygbf
Icon for Socrata external plugin
 
Preview
  • city_of_cincinnati_employees_w_salaries
     
 
Readme
Updated 10 hours ago
Indexed 41 minutes ago

City of Cincinnati Employees w/ Salaries

Data Description: This dataset lists all current City of Cincinnati employees, including full names, department, position title, full-time employee status, employee age range, employee race, and annual salary rate.

Data Creation: This data is pulled directly from the City's HR software; which centralizes all department HR actions city wide.

Data Created By: City Human Resource Information System (CHRIS)

Refresh Frequency: Daily

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/Employee-Profile/wjqv-hgc9/

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
AGE_RANGEage_rangeage_rangeTextEmployee age range
HIRE_DATEhire_datehire_dateCalendar date
POSITION_NBRposition_nbrposition_nbrText
JOBCODEjobcodejobcodeText
NAMEnamenameText
DEPTNAME_ABBRVdeptname_abbrvdeptname_abbrvText
DEPTNAMEdeptnamedeptnameTextDepartment/Agency
BUSINESS_TITLEbusiness_titlebusiness_titleText
JOBTITLEjobtitlejobtitleText
ANNUAL_RTannual_rtannual_rtNumberAnnual salary by employee.
SAL_ADMIN_PLANsal_admin_plansal_admin_planText
FTEftefteNumberIndicates whether an employee is full-time (1.0) or part-time (any number below 1.0).
JOB_ENTRY_DTjob_entry_dtjob_entry_dtCalendar date
JOBTITLE_ABBRVjobtitle_abbrvjobtitle_abbrvText
GRADEgradegradeText
STEPstepstepNumber
STD_HOURSstd_hoursstd_hoursNumber
DEPTIDdeptiddeptidText
GENDERsexsexTextIndicates whether employee identifies as male (M) or female (F)
PAYGROUPpaygrouppaygroupText
LOCATIONlocationlocationText
JOB_FAMILYjob_familyjob_familyText
RACEraceraceText
EEO_JOB_GROUPeeo_job_groupeeo_job_groupText