City of Somerville Weekly Payroll Gross Wages over 50k_2017

data.somervillema.gov | Last Updated 17 May 2018

Under Massachusetts G. L. c. 66, § 10(d), an employee’s name and place of employment may be exempt from public records disclosure if the employee or a family member was a victim of an adjudicated crime or is a victim of domestic violence, including but not limited to sexual assault or rape, or provide family planning services or provide training in family planning services, or have a court order protecting you from having your name disclosed in such a manner

Tags: 2017, wages, payroll, personnel, budget, finance

This dataset has the following 159 columns:

Column NameAPI Column NameData TypeSample Values
EEeenumber
Employee Nameemployee_nametext
Job Classjob_classtext
Positionpositiontext
Primary Locationprimary_locationtext
Total Grosstotal_grossnumber
101 - FULL TIME SALARY - EXEMPT_101_full_time_salary_exemptnumber
106 - FULL TIME SALARY NONEXEMPT_106_full_time_salary_nonexemptnumber
107 - SALARY (PER DIEM) - SCHOOL_107_salary_per_diem_schoolnumber
108 - SALARY (HOUR BASED) - SCHOOL_108_salary_hour_based_schoolnumber
119 - HOURLY (NO BENEFITS) - SCHOOL_119_hourly_no_benefits_schoolnumber
120 - HOURLY - SCHOOL_120_hourly_schoolnumber
121 - PART TIME SALARY_121_part_time_salarynumber
122 - PART TIME HOURLY_122_part_time_hourlynumber
123 - FULL TIME HOURLY_123_full_time_hourlynumber
124 - DAILY RATE_124_daily_ratenumber
126 - BOARD/COMMISSION SALARY_126_board_commission_salarynumber
201 - OVERTIME_201_overtimenumber
202 - OVERTIME-SCHOOL_202_overtime_schoolnumber
203 - OVERTIME LABOR_203_overtime_labornumber
210 - DOUBLE TIME LABOR_210_double_time_labornumber
211 - DOUBLE TIME_211_double_timenumber
212 - POLICE OVERTIME_212_police_overtimenumber
213 - PD TRAINING OVERTIME_213_pd_training_overtimenumber
214 - PD GRANT OVERTIME_214_pd_grant_overtimenumber
216 - GRANT OVERTIME_216_grant_overtimenumber
221 - COURT TIME_221_court_timenumber
222 - TRAINING OVERTIME_222_training_overtimenumber
223 - OVERTIME 2_223_overtime_2number
224 - DOUBLE TIME WINTER RATE_224_double_time_winter_ratenumber
225 - SNOW OVERTIME_225_snow_overtimenumber
226 - SNOW DOUBLE TIME_226_snow_double_timenumber
227 - SNOW OVERTIME WINTER_227_snow_overtime_winternumber
228 - SNOW DOUBLE TIME WINTER RATE_228_snow_double_time_winter_ratenumber
302 - GAME WORKER NON PENSION_302_game_worker_non_pensionnumber
303 - EXTRA CURRICULAR ACTIVITIES_303_extra_curricular_activitiesnumber
304 - OTHER NON RETIREMENT_304_other_non_retirementnumber
352 - COACH PENSIONABLE_352_coach_pensionablenumber
353 - EXTRA CURRICULAR PENSIONABLE_353_extra_curricular_pensionablenumber
354 - INSTRUCTIONAL LEAD TEACHER_354_instructional_lead_teachernumber
355 - LEAD TEACHER_355_lead_teachernumber
356 - MENTOR_356_mentornumber
357 - PARA SUBSTITUTE_357_para_substitutenumber
358 - OTHER RETIREMENT_358_other_retirementnumber
359 - REGULAR 2_359_regular_2number
401 - VACATION HOURS-CITY_401_vacation_hours_citynumber
403 - VACATION HOURS-PUBLIC SAFETY_403_vacation_hours_public_safetynumber
406 - SICK HOURS-CITY_406_sick_hours_citynumber
408 - SICK HOURS-PUBLIC SAFETY_408_sick_hours_public_safetynumber
409 - SICK BANK USED_409_sick_bank_usednumber
411 - PERSONAL HOURS-CITY_411_personal_hours_citynumber
413 - PERSONAL HOURS-PUBLIC SAFETY_413_personal_hours_public_safetynumber
414 - PERSONAL HOURS-PS ADMIN_414_personal_hours_ps_adminnumber
416 - FLOATING HOLIDAY HOURS-CITY_416_floating_holiday_hours_citynumber
419 - HOLIDAY PAY POLICE_419_holiday_pay_policenumber
420 - HOLIDAY PAY E911_420_holiday_pay_e911number
421 - HOLIDAY HOURS_421_holiday_hoursnumber
422 - HOLIDAY PAY ADDITIONAL_422_holiday_pay_additionalnumber
423 - HOLIDAY PAY FIRE_423_holiday_pay_firenumber
424 - HOLIDAY PAY FIRE ALARM_424_holiday_pay_fire_alarmnumber
427 - DEDUCT DAYS_427_deduct_daysnumber
428 - SICK BUY BACK_428_sick_buy_backnumber
429 - VACATION PAYOUT_429_vacation_payoutnumber
430 - BIRTHDAY PAY - SCHOOL CUSTODIA_430_birthday_pay_school_custodianumber
431 - BIRTHDAY HOURS_431_birthday_hoursnumber
432 - BEREAVEMENT_432_bereavementnumber
434 - MILITARY DUTY_434_military_dutynumber
435 - EXCUSED OTHER_435_excused_othernumber
436 - UNION BUSINESS_436_union_businessnumber
437 - CANCER SCREEN_437_cancer_screennumber
438 - WELLNESS_438_wellnessnumber
439 - CONFERENCE/SEMINAR_439_conference_seminarnumber
440 - 111F SICK TIME TAKEN_440_111f_sick_time_takennumber
441 - WORKMANS COMPENSATION-CITY_441_workmans_compensation_citynumber
442 - ADMIN LEAVE WITH PAY_442_admin_leave_with_paynumber
448 - FURLOUGH REPAY_448_furlough_repaynumber
449 - JURY DUTY_449_jury_dutynumber
452 - 5/2 DAYS_452_5_2_daysnumber
502 - PARENTAL LEAVE_502_parental_leavenumber
503 - FMLA SICK_503_fmla_sicknumber
504 - FMLA PERSONAL_504_fmla_personalnumber
505 - FMLA VACATION_505_fmla_vacationnumber
507 - FMLA SICK BANK_507_fmla_sick_banknumber
601 - SHIFT DIFF SPEA & SPSOA_601_shift_diff_spea_spsoanumber
602 - SHIFT DIFFERENTIAL 10%_602_shift_differential_10number
603 - SHIFT DIFFERENTIAL E911 3%_603_shift_differential_e911_3number
604 - SHIFT DIFFERENTIAL E911 3.5%_604_shift_differential_e911_3_5number
605 - SHIFT DIFFERENTIAL E911 4%_605_shift_differential_e911_4number
608 - CPR_608_cprnumber
609 - DEFIBRILLATOR PAY_609_defibrillator_paynumber
610 - EMERGENCY MEDICAL TECHNICIAN_610_emergency_medical_techniciannumber
611 - HAZARDOUS DUTY_611_hazardous_dutynumber
612 - MASTER FIRE FIGHTER_612_master_fire_fighternumber
613 - FIRE SERVICE DISPATCH_613_fire_service_dispatchnumber
614 - EMERGENCY MEDICAL DISPATCH_614_emergency_medical_dispatchnumber
615 - MASTER FIRE ALARM OPERATOR_615_master_fire_alarm_operatornumber
616 - OUT OF GRADE_616_out_of_gradenumber
617 - 5/2 BUY BACK_617_5_2_buy_backnumber
618 - WEAPONS PROFICIENCY_618_weapons_proficiencynumber
619 - WEAPONS OF MASS DESTRUCTION_619_weapons_of_mass_destructionnumber
620 - LONGEVITY SMEA A_620_longevity_smea_anumber
621 - LONGEVITY SMEA B_621_longevity_smea_bnumber
622 - LONGEVITY SMEA D_622_longevity_smea_dnumber
623 - LONGEVITY SCHOOL CUSTODIANS_623_longevity_school_custodiansnumber
624 - LONGEVITY FIRE_624_longevity_firenumber
625 - LONGEVITY FIRE ALARM_625_longevity_fire_alarmnumber
626 - LONGEVITYE911_626_longevitye911number
628 - LONGEVITY PATROL PRIOR 5/23/83_628_longevity_patrol_prior_5_23_83number
629 - LONGEVITY PATROL POST 5/23/83_629_longevity_patrol_post_5_23_83number
631 - LONGEVITY SPSOA POST 5/23/83_631_longevity_spsoa_post_5_23_83number
632 - SENIOR LONGEVITY_632_senior_longevitynumber
641 - ELECTION PAY (UNION)_641_election_pay_unionnumber
642 - ELECTION PAY (NON UNION)_642_election_pay_non_unionnumber
643 - FLUENCY BONUS_643_fluency_bonusnumber
644 - TRANSLATION BONUS_644_translation_bonusnumber
645 - STIPEND NO RETIREMENT_645_stipend_no_retirementnumber
646 - EDUCATION_646_educationnumber
647 - STIPEND RETIREMENT_647_stipend_retirementnumber
648 - WEATHER STIPEND_648_weather_stipendnumber
649 - BIRTHDAY PAY_649_birthday_paynumber
650 - EDUCATION STIP FIRE_650_education_stip_firenumber
651 - S-STIPEND NO RETIREMENT_651_s_stipend_no_retirementnumber
652 - S-STIPEND RETIREMENT_652_s_stipend_retirementnumber
653 - SCH - SUMMER SALARY STIPEND_653_sch_summer_salary_stipendnumber
654 - SCH - SUMMER HOURLY STIPEND_654_sch_summer_hourly_stipendnumber
700 - WINTER DIFFERENTIAL 10%_700_winter_differential_10number
802 - FOOD SERVICE OUT OF GRADE_802_food_service_out_of_gradenumber
852 - LONGEVITY STA PARA_852_longevity_sta_paranumber
853 - LONGEVITY SAA POST 7/1/16_853_longevity_saa_post_7_1_16number
855 - LONGEVITY - AFSCME FOOD SVC_855_longevity_afscme_food_svcnumber
857 - LONGEVITY SCALE PA_857_longevity_scale_panumber
859 - LONGEVITY NON UNION_859_longevity_non_unionnumber
860 - LONGEVITY - AFSCME CLERICAL_860_longevity_afscme_clericalnumber
861 - LONGEVITY NON UNION (LUMP SUM)_861_longevity_non_union_lump_sumnumber
896 - PEN SUBSTITUTE COORDINATOR_896_pen_substitute_coordinatornumber
901 - AUTO ALLOWANCE_901_auto_allowancenumber
902 - PERFECT ATTENDANCE_902_perfect_attendancenumber
903 - CLOTHING ALLOWANCE_903_clothing_allowancenumber
904 - UNIFORM ALLOWANCE FIRE_904_uniform_allowance_firenumber
905 - UNIFORM ALLOWANCE FIRE ALARM_905_uniform_allowance_fire_alarmnumber
906 - UNIFORM ALLOWANCE E911_906_uniform_allowance_e911number
911 - UNIFORM ALLOWANCE FOOD SVC_911_uniform_allowance_food_svcnumber
913 - GYM REIMBURSEMENT_913_gym_reimbursementnumber
914 - OPT OUT FAMILY_914_opt_out_familynumber
915 - OPT OUT INDIVIDUAL_915_opt_out_individualnumber
916 - SCHOOL AUTO ALLOWANCE_916_school_auto_allowancenumber
949 - GAS ALLOWANCE_949_gas_allowancenumber
951 - RETROACTIVE PAY_951_retroactive_paynumber
952 - RETROACTIVE PAY NR_952_retroactive_pay_nrnumber
953 - SERVICE RECOGNITION_953_service_recognitionnumber
954 - MEAL ALLOWANCE_954_meal_allowancenumber
955 - DETAIL FIRE1_955_detail_fire1number
956 - DETAIL FIRE2_956_detail_fire2number
957 - DETAIL POLICE_957_detail_policenumber
958 - DETAIL SCHOOL CUST CITY_958_detail_school_cust_citynumber
959 - DETAIL SCHOOL CUST SCHOOL_959_detail_school_cust_schoolnumber
960 - DETAIL SCHOOL CUST CITY SPLIT_960_detail_school_cust_city_splitnumber
981 - EDUCATION - FRINGE_981_education_fringenumber
996 - SNOW MEAL ALLOWANCE_996_snow_meal_allowancenumber