search

chicago-police-violence / data

Dataset about the personnel, use of force, and complaints in the Chicago Police Department
MIT License
7 stars 0 forks source link

promotions #26

Closed trevorcampbell closed 3 years ago

trevorcampbell commented 3 years ago

Are actually in the salary data, which is quite neat. Leaving an issue here (nothing to do on this yet) just to remind myself to make some sort of documentation of this later.

e.g. you will see records with the same year like so (when the officer is promoted I suppose their salary record is updated to reflect the new position and pay grade)

{'last_name': 'CORCORAN', 'first_name': 'JAMES', 'middle_initial': 'F', 'gender': 'Male', 'age_at_hire': '32', 'title': 'POLICE OFFICER', 'appointment_date': '1998-05-26', 'start_date_present_position': '1998-05-26', 'start_date_as_city_employee': '1998-05-26', 'salary': '73968', 'pay_grade': 'D|1', 'employee_status': 'CAREER SERVICE', 'salary_year': '2007'}, 

{'last_name': 'CORCORAN', 'first_name': 'JAMES', 'middle_initial': 'F', 'gender': 'Male', 'age_at_hire': '32', 'title': 'POLICE OFFICER (ASSIGNED AS DETECTIVE)', 'appointment_date': '1998-05-26', 'start_date_present_position': '2007-04-01', 'start_date_as_city_employee': '1998-05-26', 'salary': '73968', 'pay_grade': 'D|2A', 'employee_status': 'CAREER SERVICE', 'salary_year': '2007'},
trevorcampbell commented 3 years ago

This is now contained in final/salary.csv -- basically I just order the rows for each salary record such that one can easily reconstruct promotions from it if needed.