About this Dataset

Legacy City-Parish Employee Annual Salaries

THIS DATASET IS NO LONGER UPDATED
In November 2018, the City-Parish switched to a new payroll system. This dataset contains annual salaries through 2017. For data from 2018 onward, visit https://data.brla.gov/Government/City-Parish-Employee-Annual-Salaries/g9vh-zeiw

City-Parish employees' annual salaries and other payroll related information. Information is calculated after the last payroll is run for the year specified.
Organization: City of Baton Rouge
Last updated: 2020-11-12T14:59:58.636973
Tags: department, employee, longevity, salary

Tables

Table 1

@usgov.city_of_baton_rouge_legacy_city_parish_employee_annual_salaries.table_1

2.11 MB
54,338 rows
23 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "employee_num" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_init" VARCHAR,
  "department_num" BIGINT,
  "department_name" VARCHAR,
  "division_num" BIGINT,
  "division_name" VARCHAR,
  "job_code" BIGINT,
  "job_title" VARCHAR,
  "current_hire_date" TIMESTAMP,
  "employment_end_date" TIMESTAMP,
  "scheduled_hours" BIGINT,
  "longevity_percentage" DOUBLE,
  "base_hourly_rate" DOUBLE,
  "total_hourly_rate" DOUBLE,
  "overtime_hourly_rate" DOUBLE,
  "employment_status" BIGINT,
  "total_base_pay" DOUBLE,
  "gross_pay" DOUBLE,
  "total_overtime_hours" DOUBLE,
  "total_overtime_pay" DOUBLE
);