City Of Somerville Weekly Payroll Gross Wages Over 50K_2015

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.somervillema.gov
Id gby8-rz93
Name City Of Somerville Weekly Payroll Gross Wages Over 50K_2015
Attribution Somerville Personnel Department, Payroll Division
Category Finance
Tags wages, payroll, personnel, budget, salaries, salary, 2015
Created 2016-02-12T19:31:04Z
Publication Date 2016-02-12T19:33:14Z

Description

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

Columns

| Included | Schema Type    | Field Name       | Name             | Data Type | Render Type |
| ======== | ============== | ================ | ================ | ========= | =========== |
| Yes      | series tag     | name             | Name             | text      | text        |
| Yes      | series tag     | dept_name        | Dept Name        | text      | text        |
| Yes      | series tag     | title            | Title            | text      | text        |
| Yes      | numeric metric | total_gross      | Total Gross      | money     | money       |
| Yes      | numeric metric | 5_2_bb           | 5/2 BB           | number    | number      |
| Yes      | numeric metric | perf_att         | Perf Att         | number    | number      |
| Yes      | numeric metric | auto_allow       | Auto Allow       | number    | number      |
| Yes      | numeric metric | birthdaynr       | BirthdayNR       | number    | number      |
| Yes      | series tag     | bereave          | Bereave          | text      | text        |
| Yes      | numeric metric | clothing         | Clothing         | number    | number      |
| No       |                | court_time       | Court Time       | number    | number      |
| Yes      | numeric metric | cpr              | CPR              | number    | number      |
| Yes      | numeric metric | defib_pay        | Defib Pay        | number    | number      |
| Yes      | numeric metric | detail           | Detail           | number    | number      |
| Yes      | numeric metric | shift_diff       | Shift Diff       | number    | number      |
| No       |                | dt               | DT               | number    | number      |
| Yes      | numeric metric | educ_inc         | Educ Inc         | number    | number      |
| Yes      | numeric metric | elect_pay        | Elect Pay        | number    | number      |
| Yes      | numeric metric | emd              | EMD              | number    | number      |
| Yes      | numeric metric | emt              | EMT              | number    | number      |
| Yes      | series tag     | ex_other         | Ex Other         | text      | text        |
| Yes      | numeric metric | fluen_bon        | Fluen Bon        | number    | number      |
| Yes      | numeric metric | fsd              | FSD              | number    | number      |
| Yes      | numeric metric | gas_allowance    | Gas Allowance    | number    | number      |
| Yes      | numeric metric | o_g              | O/G              | number    | number      |
| Yes      | numeric metric | grant_ot         | Grant OT         | number    | number      |
| Yes      | numeric metric | haz_duty         | Haz Duty         | number    | number      |
| Yes      | numeric metric | hol              | Hol              | number    | number      |
| Yes      | numeric metric | jury_duty        | Jury Duty        | number    | number      |
| Yes      | series tag     | matron_pay       | Matron Pay       | text      | text        |
| Yes      | numeric metric | meals            | Meals            | number    | number      |
| Yes      | numeric metric | master_fao       | Master FAO       | number    | number      |
| Yes      | numeric metric | master_ff        | Master FF        | number    | number      |
| No       |                | ot               | OT               | number    | number      |
| Yes      | numeric metric | ot2              | OT2              | number    | number      |
| Yes      | numeric metric | othernr          | OtherNR          | number    | number      |
| Yes      | numeric metric | personal         | Personal         | number    | number      |
| Yes      | numeric metric | reg              | Reg              | number    | number      |
| Yes      | numeric metric | retro            | Retro            | number    | number      |
| Yes      | numeric metric | retronr          | RetroNR          | number    | number      |
| Yes      | numeric metric | sickbank         | SickBank         | number    | number      |
| Yes      | numeric metric | sick             | Sick             | number    | number      |
| Yes      | numeric metric | sick_buy_back    | Sick Buy Back    | number    | number      |
| Yes      | numeric metric | stipr            | StipR            | number    | number      |
| Yes      | numeric metric | stipnr           | StipNR           | number    | number      |
| Yes      | numeric metric | uniform          | Uniform          | number    | number      |
| Yes      | numeric metric | vacation         | Vacation         | number    | number      |
| Yes      | numeric metric | weapons          | Weapons          | number    | number      |
| Yes      | numeric metric | wmd              | WMD              | number    | number      |
| Yes      | numeric metric | extra_hol_nr     | Extra Hol NR     | number    | number      |
| Yes      | series tag     | hls              | HLS              | text      | text        |
| Yes      | numeric metric | senior_longevity | Senior Longevity | number    | number      |
| Yes      | numeric metric | longevity        | Longevity        | number    | number      |
| Yes      | series tag     | adm_leave        | Adm Leave        | text      | text        |
| Yes      | series tag     | furlough         | Furlough         | text      | text        |
| Yes      | numeric metric | training_ot      | Training OT      | number    | number      |
| Yes      | numeric metric | snow_ot          | Snow OT          | number    | number      |
| Yes      | numeric metric | snow_ot2         | Snow OT2         | number    | number      |
| Yes      | numeric metric | snow_dt          | Snow DT          | number    | number      |
| Yes      | numeric metric | gym_reim         | Gym Reim         | number    | number      |
| Yes      | numeric metric | opti             | OptI             | number    | number      |
| Yes      | numeric metric | optf             | OptF             | number    | number      |
| Yes      | series tag     | no_pay           | No Pay           | text      | text        |
| Yes      | numeric metric | trans            | Trans            | number    | number      |

Time Field

Value = 2015
Format & Zone = yyyy

Series Fields

Excluded Fields = court_time,dt,ot

Data Commands

series e:gby8-rz93 d:2015-01-01T00:00:00.000Z t:title=Captain t:name="Cabral, Michael" t:dept_name=POLICE m:hol=9176.6 m:detail=59680.5 m:shift_diff=7272.66 m:5_2_bb=2307.26 m:training_ot=786.57 m:reg=129869.08 m:weapons=600 m:total_gross=217763.36 m:wmd=500

series e:gby8-rz93 d:2015-01-01T00:00:00.000Z t:title="Police Chief" t:name="Fallon, David" t:dept_name=POLICE m:optf=3999.96 m:reg=190379.01 m:total_gross=195104.74 m:extra_hol_nr=725.77

series e:gby8-rz93 d:2015-01-01T00:00:00.000Z t:title="Lieutenant +25%" t:name="Lavey Jr, Richard" t:dept_name=POLICE m:hol=7394.45 m:detail=38515.54 m:shift_diff=6994.78 m:training_ot=669.42 m:reg=105060.35 m:weapons=500 m:total_gross=194834.2 m:o_g=199.4 m:wmd=500

Meta Commands

metric m:total_gross p:double l:"Total Gross" t:dataTypeName=money

metric m:5_2_bb p:float l:"5/2 BB" t:dataTypeName=number

metric m:perf_att p:float l:"Perf Att" t:dataTypeName=number

metric m:auto_allow p:float l:"Auto Allow" t:dataTypeName=number

metric m:birthdaynr p:float l:BirthdayNR t:dataTypeName=number

metric m:clothing p:float l:Clothing t:dataTypeName=number

metric m:cpr p:float l:CPR t:dataTypeName=number

metric m:defib_pay p:float l:"Defib Pay" t:dataTypeName=number

metric m:detail p:float l:Detail t:dataTypeName=number

metric m:shift_diff p:float l:"Shift Diff" t:dataTypeName=number

metric m:educ_inc p:float l:"Educ Inc" t:dataTypeName=number

metric m:elect_pay p:float l:"Elect Pay" t:dataTypeName=number

metric m:emd p:float l:EMD t:dataTypeName=number

metric m:emt p:float l:EMT t:dataTypeName=number

metric m:fluen_bon p:float l:"Fluen Bon" t:dataTypeName=number

metric m:fsd p:float l:FSD t:dataTypeName=number

metric m:gas_allowance p:long l:"Gas Allowance" t:dataTypeName=number

metric m:o_g p:float l:O/G t:dataTypeName=number

metric m:grant_ot p:float l:"Grant OT" t:dataTypeName=number

metric m:haz_duty p:float l:"Haz Duty" t:dataTypeName=number

metric m:hol p:float l:Hol t:dataTypeName=number

metric m:jury_duty p:float l:"Jury Duty" t:dataTypeName=number

metric m:meals p:float l:Meals t:dataTypeName=number

metric m:master_fao p:float l:"Master FAO" t:dataTypeName=number

metric m:master_ff p:float l:"Master FF" t:dataTypeName=number

metric m:ot2 p:float l:OT2 t:dataTypeName=number

metric m:othernr p:float l:OtherNR t:dataTypeName=number

metric m:personal p:float l:Personal t:dataTypeName=number

metric m:reg p:double l:Reg t:dataTypeName=number

metric m:retro p:float l:Retro t:dataTypeName=number

metric m:retronr p:float l:RetroNR t:dataTypeName=number

metric m:sickbank p:float l:SickBank t:dataTypeName=number

metric m:sick p:float l:Sick t:dataTypeName=number

metric m:sick_buy_back p:float l:"Sick Buy Back" t:dataTypeName=number

metric m:stipr p:float l:StipR t:dataTypeName=number

metric m:stipnr p:float l:StipNR t:dataTypeName=number

metric m:uniform p:float l:Uniform t:dataTypeName=number

metric m:vacation p:float l:Vacation t:dataTypeName=number

metric m:weapons p:float l:Weapons t:dataTypeName=number

metric m:wmd p:float l:WMD t:dataTypeName=number

metric m:extra_hol_nr p:float l:"Extra Hol NR" t:dataTypeName=number

metric m:senior_longevity p:float l:"Senior Longevity" t:dataTypeName=number

metric m:longevity p:float l:Longevity t:dataTypeName=number

metric m:training_ot p:float l:"Training OT" t:dataTypeName=number

metric m:snow_ot p:float l:"Snow OT" t:dataTypeName=number

metric m:snow_ot2 p:float l:"Snow OT2" t:dataTypeName=number

metric m:snow_dt p:float l:"Snow DT" t:dataTypeName=number

metric m:gym_reim p:float l:"Gym Reim" t:dataTypeName=number

metric m:opti p:float l:OptI t:dataTypeName=number

metric m:optf p:float l:OptF t:dataTypeName=number

metric m:trans p:float l:Trans t:dataTypeName=number

entity e:gby8-rz93 l:"City Of Somerville Weekly Payroll Gross Wages Over 50K_2015" t:attribution="Somerville Personnel Department, Payroll Division" t:url=https://data.somervillema.gov/api/views/gby8-rz93

property e:gby8-rz93 t:meta.view v:id=gby8-rz93 v:category=Finance v:attributionLink=http://www.somervillema.gov/departments/personnel v:averageRating=0 v:name="City Of Somerville Weekly Payroll Gross Wages Over 50K_2015" v:attribution="Somerville Personnel Department, Payroll Division"

property e:gby8-rz93 t:meta.view.license v:name="Open Data Commons Open Database License" v:termsLink=http://opendatacommons.org/licenses/odbl/1.0/

property e:gby8-rz93 t:meta.view.owner v:id=x7b9-bdhv v:screenName=SStewart v:displayName=SStewart

property e:gby8-rz93 t:meta.view.tableauthor v:id=x7b9-bdhv v:screenName=SStewart v:roleName=administrator v:displayName=SStewart

Top Records

| name               | dept_name | title               | total_gross | 5_2_bb  | perf_att | auto_allow | birthdaynr | bereave | clothing | court_time | cpr | defib_pay | detail   | shift_diff | dt | educ_inc | elect_pay | emd | emt | ex_other | fluen_bon | fsd | gas_allowance | o_g     | grant_ot | haz_duty | hol     | jury_duty | matron_pay | meals | master_fao | master_ff | ot       | ot2 | othernr | personal | reg       | retro | retronr | sickbank | sick | sick_buy_back | stipr | stipnr | uniform | vacation | weapons | wmd    | extra_hol_nr | hls | senior_longevity | longevity | adm_leave | furlough | training_ot | snow_ot | snow_ot2 | snow_dt | gym_reim | opti | optf    | no_pay | trans | 
| ================== | ========= | =================== | =========== | ======= | ======== | ========== | ========== | ======= | ======== | ========== | === | ========= | ======== | ========== | == | ======== | ========= | === | === | ======== | ========= | === | ============= | ======= | ======== | ======== | ======= | ========= | ========== | ===== | ========== | ========= | ======== | === | ======= | ======== | ========= | ===== | ======= | ======== | ==== | ============= | ===== | ====== | ======= | ======== | ======= | ====== | ============ | === | ================ | ========= | ========= | ======== | =========== | ======= | ======== | ======= | ======== | ==== | ======= | ====== | ===== | 
| Cabral, Michael    | POLICE    | Captain             | 217763.36   | 2307.26 |          |            |            |         |          |            |     |           | 59680.50 | 7272.66    |    |          |           |     |     |          |           |     |               |         |          |          | 9176.60 |           |            |       |            |           | 7570.69  |     |         |          | 129869.08 |       |         |          |      |               |       |        |         |          | 600.00  | 500.00 |              |     |                  |           |           |          | 786.57      |         |          |         |          |      |         |        |       | 
| Fallon, David      | POLICE    | Police Chief        | 195104.74   |         |          |            |            |         |          |            |     |           |          |            |    |          |           |     |     |          |           |     |               |         |          |          |         |           |            |       |            |           |          |     |         |          | 190379.01 |       |         |          |      |               |       |        |         |          |         |        | 725.77       |     |                  |           |           |          |             |         |          |         |          |      | 3999.96 |        |       | 
| Lavey Jr, Richard  | POLICE    | Lieutenant +25%     | 194834.20   |         |          |            |            |         |          | 3096.06    |     |           | 38515.54 | 6994.78    |    |          |           |     |     |          |           |     |               | 199.40  |          |          | 7394.45 |           |            |       |            |           | 31904.20 |     |         |          | 105060.35 |       |         |          |      |               |       |        |         |          | 500.00  | 500.00 |              |     |                  |           |           |          | 669.42      |         |          |         |          |      |         |        |       | 
| Cicerone, Fernando | POLICE    | Police Officer      | 193137.48   |         |          |            |            |         |          | 10840.68   |     |           | 65851.32 | 7141.44    |    |          |           |     |     |          |           |     |               |         | 2767.71  |          | 5381.94 |           |            |       |            |           | 21681.54 |     |         |          | 76166.30  |       |         |          |      |               |       |        |         |          | 500.00  | 500.00 |              |     |                  |           |           |          | 2306.55     |         |          |         |          |      |         |        |       | 
| Hallinan, William  | FIRE      | Deputy Chief        | 185989.93   |         | 400.00   |            |            |         |          |            |     |           | 8379.50  |            |    |          |           |     |     |          |           |     |               |         |          | 9000.00  | 8484.11 |           |            |       |            |           | 30040.71 |     |         |          | 128473.59 |       |         |          |      |               |       |        |         |          |         |        |              |     |                  |           |           |          | 1212.02     |         |          |         |          |      |         |        |       | 
| Vivolo, Carmine    | POLICE    | Lieutenant +25%     | 185871.54   | 1338.83 | 500.00   |            |            |         |          |            |     |           |          | 6189.34    |    |          |           |     |     |          |           |     |               |         | 1338.88  |          | 7809.86 |           |            |       |            |           | 46942.96 |     |         |          | 110526.73 |       |         |          |      |               |       |        |         |          | 600.00  | 500.00 |              |     |                  |           |           |          | 10124.94    |         |          |         |          |      |         |        |       | 
| Dervishian, George | POLICE    | Police Officer      | 183734.51   |         |          |            |            |         |          |            |     |           | 97207.73 | 9028.63    |    |          |           |     |     |          |           |     |               |         |          |          | 4305.56 |           |            |       |            |           | 4059.55  |     |         |          | 60933.04  |       |         |          |      |               |       |        |         |          | 600.00  | 500.00 |              |     | 3200.00          | 3900.00   |           |          |             |         |          |         |          |      |         |        |       | 
| Ward, Christopher  | POLICE    | Sergeant            | 179485.91   |         |          |            |            |         |          | 1139.44    |     |           | 51856.03 | 7178.43    |    |          |           |     |     |          |           |     |               | 265.88  |          |          | 6646.70 |           |            |       |            |           | 16094.53 |     |         |          | 94065.46  |       |         |          |      |               |       |        |         |          | 600.00  | 500.00 |              |     |                  |           |           |          | 1139.44     |         |          |         |          |      |         |        |       | 
| Breen Jr, Charles  | FIRE      | Deputy Chief        | 176199.54   |         | 500.00   |            |            |         |          |            |     |           | 2752.00  |            |    | 853.02   |           |     |     |          |           |     |               | 3158.69 |          | 1000.00  | 8330.91 |           |            |       |            |           | 31283.41 |     |         |          | 126153.78 |       |         |          |      |               |       |        |         |          |         |        |              |     |                  |           |           |          | 2167.73     |         |          |         |          |      |         |        |       | 
| Berrouet, Wolff    | POLICE    | Police Officer +25% | 175384.18   |         |          |            |            |         |          | 749.61     |     |           | 57142.07 | 8153.44    |    |          |           |     |     |          |           |     |               |         | 2998.32  |          | 5381.94 |           |            |       |            |           | 22431.19 |     |         |          | 76166.30  |       |         |          |      |               |       |        |         |          | 600.00  | 500.00 |              |     | 800.00           |           |           |          | 461.31      |         |          |         |          |      |         |        |       |