About this Dataset

City-Parish Employee Annual Salaries

City-Parish employees' annual salaries and other payroll related information. Information is calculated after the last payroll is run for the year specified. Some fields, such as job title and department, are accurate as of the time the data was captured for Open Data BR. For example, if an employee worked for three departments throughout the year, only the department they worked for at the time we collected the data will be shown.

***In November of 2018, the City-Parish switched to a new payroll system. This data contains employee information from 2018 onward. For prior year data, please see the Legacy City-Parish Employee Annual Salaries https://data.brla.gov/Government/Legacy-City-Parish-Employee-Annual-Salaries/g5c2-myyj
Organization: City of Baton Rouge
Last updated: 2020-11-12T14:59:58.904867
Tags: annual, department, employee, salary

Tables

Table 1

@usgov.city_of_baton_rouge_city_parish_employee_annual_salaries.table_1

1.73 MB
33,262 rows
39 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_init" VARCHAR,
  "department_number" BIGINT,
  "department_name" VARCHAR,
  "pay_location_code" BIGINT,
  "pay_location_description" VARCHAR,
  "job_code" BIGINT,
  "job_title" VARCHAR,
  "current_hire_date" TIMESTAMP,
  "employment_end_date" TIMESTAMP,
  "employment_status" VARCHAR,
  "base_pay" DOUBLE,
  "gross_pay" DOUBLE,
  "total_ot_hours" DOUBLE,
  "total_ot_pay" DOUBLE,
  "severance_pay" DOUBLE,
  "shift_differential_pay" DOUBLE,
  "pay_adjustments" DOUBLE,
  "car_allowance" DOUBLE,
  "meal_allowance" DOUBLE,
  "state_supplemental_jp" DOUBLE,
  "education_pay" DOUBLE,
  "transfer_compensation" DOUBLE,
  "special_assignment" DOUBLE,
  "engineer_license" DOUBLE,
  "police_suit_allowance" DOUBLE,
  "workers_comp" DOUBLE,
  "employee_reimbursement" DOUBLE,
  "state_2_percent" DOUBLE,
  "prison_assignment" DOUBLE,
  "hazardous_pay" DOUBLE,
  "employee_refund" DOUBLE,
  "longevity" DOUBLE,
  "commander_pay" DOUBLE,
  "field_training_pay" DOUBLE,
  "aviation_pay" DOUBLE,
  "uniqueid" VARCHAR
);