About this Dataset

City-Parish Employees

City-Parish employees, both active and inactive, that exist in the City-Parish Payroll System. The information includes employee current pay information, including any special pay. Special pay is earned per pay period.

***In November of 2018, the City-Parish switched to a new payroll system. This dataset contains employee information from this new system. For data prior to 2018, please see the Legacy City-Parish Employees at https://data.brla.gov/Government/Legacy-City-Parish-Employees/gyhq-w3h3
Organization: City of Baton Rouge
Last updated: 2020-11-12T14:59:55.434699
Tags: department, employees, job-title, salary

Tables

Table 1

@usgov.city_of_baton_rouge_city_parish_employees.table_1

548.46 kB
7,118 rows
27 columns

CREATE TABLE table_1 (
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_init" VARCHAR,
  "department_number" BIGINT,
  "deaprtment_name" VARCHAR,
  "pay_location_code" BIGINT,
  "pay_location_description" VARCHAR,
  "job_code" BIGINT,
  "job_title" VARCHAR,
  "pay_range" DOUBLE,
  "pay_step" DOUBLE,
  "current_hire_date" TIMESTAMP,
  "employment_end_date" TIMESTAMP,
  "years_of_service" DOUBLE,
  "scheduled_hours" DOUBLE,
  "hourly_rate" DOUBLE,
  "annual_salary" DOUBLE,
  "education_pay" DOUBLE,
  "engineer_license" DOUBLE,
  "car_allowance" DOUBLE,
  "meal_allowance" DOUBLE,
  "state_2_percent" DOUBLE,
  "prison_assignment" DOUBLE,
  "personnel_status" VARCHAR,
  "personnel_status_description" VARCHAR,
  "employment_status" VARCHAR,
  "uniqueid" VARCHAR
);