event: 4
This data as json
| rowid | event_uid | kind | year | month | day | time | raw_date | uid | allegation_uid | appeal_uid | uof_uid | agency | badge_no | employee_id | department_code | department_desc | division_desc | unit_desc | unit_sub_desc | employee_class | rank_code | rank_desc | employment_status | sworn | officer_inactive | salary | overtime_annual_total | overtime_location | overtime_freq | salary_freq | award | award_comments | left_reason | left_reason_desc | years_of_service | source_agency | brady_uid |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 00020a54acbfa81542f947804bae490a | officer_pay_effective | 2010 | 1 | 1 | 20100101 | 4d40769238c5743eb25c1b3dfab32575 | louisiana-state-pd | lsp troop b/region 1 | trooper | 48009.26 | yearly |