{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Using Pandas (and IPython/Jupyter Notebooks)!" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "One of the things I like most about IPython notebooks is the amazing accesability of documentation. If you hit the tab key while typing, a great autocompletion window comes up. If you pause once the word you are typing is complete, you receive documentation on the finction in a popup window. In newer versions it seems the same functionality is acheived by hitting shift then tab instead of tab. Hitting the tab key gives even more documentation in the popup window, and hitting it once more will give all the documentation on the word you have typed in a window below the current input cell. Another great feature is the re-evaluatable cell, which is great for making mistakes and learning from them. It allows you to type something, view the output immediately, and rapidly and iteratively change the input until you finally get the desired output (if you make tons of small mistakes like me). The built in documentation features, in combination with re-evaluatable cells are extremely helpful when using a new tool or library (like Pandas)." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "%matplotlib inline\n", "import pandas as pd" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Code written using the Pandas Library, when compared to Python Lists or similar native container data types, is much more compact and often times can avoid loops in places where Python can't (at least in pretty or compact ways).\n", "Some of the most useful methods include reading csv files readcsv() and excel files, plotting .plot(), statistics .median(), bar graphs, slicing by columns, conditional returning of data (like SQL query), adding new columns, groupby and aggregate (like SQL versions)." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#What can you do with this tool? " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Pandas is a Python library for data exploration, manipulation, and analysis. Primarily it includes data tables and time series data structures, along with methods for manipulating them. Dataframes are the central objects in the library, which are similar to excel spreadsheets. Pandas was inspired largely by a statistical programming language called R, and maintains many of the basic data structures and methods included in R, such as data frames. The creators of Pandas are Financial Data Analysts. One of the reasons some prefer Pandas to R is the fact you're coding in Python. Another reason is that it interfaces very well with other great python packages (matplotlib, numpy, etc...); in many cases you can just drop a Pandas dataframe into your favorite matplotlib or numpy functions and get the desired behavior, which is great! It's alwo quite fast on many tasks, as it uses numpy for many basic dataframe methods. Dataframe's ability to handle missing data makes it an invaluable tool when dealing with any kind of data. " ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#Getting Started" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Here are some resources for getting started:\n", "\n", "Using pip or anaconda to install pandas is the safest/best way to get started:\n", "\n", "http://pandas.pydata.org/pandas-docs/stable/install.html\n", "\n", " Pandas Website:\n", "\n", "http://pandas.pydata.org/\n", "\n", "Quick Pandas tutorial video:\n", "\n", "https://vimeo.com/59324550\n", "\n", "Julia Evans PyCon Pandas Tutorial for Data Analysis:\n", "\n", "https://www.youtube.com/watch?v=rEalbu8UGeo\n", "\n", " \n", "\n", "Tons of IPython Notebooks:\n", "\n", "http://nbviewer.ipython.org/github/twiecki/financial-analysis-python-tutorial/blob/master/1.%20Pandas%20Basics.ipynb\n", "\n", "http://nbviewer.ipython.org/github/jvns/talks/blob/master/pyconca2013/pistes-cyclables.ipynb\n", "\n", "http://nbviewer.ipython.org/gist/fonnesbeck/5850375\n", "\n", "https://github.com/ipython/ipython/wiki/A-gallery-of-interesting-IPython-Notebooks#pandas-for-data-analysis\n" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "It is very easy to read data (CSV, Excel, SQL, JSON, etc...) into a pandas dataframe and get started exploring. I'm going to do this for this City of Boston employee earnings dataset: https://data.cityofboston.gov/City-Services/Closed-Pothole-Cases/wivc-syw7" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | NAME | \n", "TITLE | \n", "DEPARTMENT NAME | \n", "REGULAR | \n", "RETRO | \n", "OTHER | \n", "OVERTIME | \n", "INJURED | \n", "DETAIL | \n", "QUINN | \n", "TOTAL EARNINGS | \n", "ZIP | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Adario,Anthony J | \n", "Supvising Claims Agent (Asd) | \n", "ASD Human Resources | \n", "$98538.32 | \n", "$0.00 | \n", "$1842.87 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100381.19 | \n", "02132 | \n", "
1 | \n", "Baker,Katherine E. | \n", "Nurse Case Manager | \n", "ASD Human Resources | \n", "$83942.21 | \n", "$0.00 | \n", "$225.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$84167.21 | \n", "02136 | \n", "
2 | \n", "Braga,Ann Hess | \n", "HumanResourcesComplianceOffcr | \n", "ASD Human Resources | \n", "$98538.34 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$98538.34 | \n", "02126 | \n", "
3 | \n", "Calobrisi,Jane Ellen | \n", "Personnel Analyst | \n", "ASD Human Resources | \n", "$70073.81 | \n", "$0.00 | \n", "$225.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$70298.81 | \n", "02090 | \n", "
4 | \n", "Castillo-Cook,Wendolyn M. | \n", "Alcholism Coord I | \n", "ASD Human Resources | \n", "$79253.11 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$79253.11 | \n", "02121 | \n", "
5 | \n", "Curran,Liam Patrick | \n", "Asst Corp Counsel III | \n", "ASD Human Resources | \n", "$69266.69 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$69266.69 | \n", "02122 | \n", "
6 | \n", "De Jesus,Winnie Yam | \n", "Affirm Action Monitor | \n", "ASD Human Resources | \n", "$42061.21 | \n", "$0.00 | \n", "$487.21 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$42548.42 | \n", "02458 | \n", "
7 | \n", "Donnelly,Jennifer P. | \n", "Prin Clerk | \n", "ASD Human Resources | \n", "$44080.61 | \n", "$0.00 | \n", "$300.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$44380.61 | \n", "02129 | \n", "
8 | \n", "Donovan,Carol Anne | \n", "Prin Admin Analyst | \n", "ASD Human Resources | \n", "$73547.25 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$73547.25 | \n", "02127 | \n", "
9 | \n", "Donovan,John J | \n", "Exec Asst (EAP/OHR) | \n", "ASD Human Resources | \n", "$15019.39 | \n", "$0.00 | \n", "$10250.05 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$25269.44 | \n", "02132 | \n", "
10 | \n", "Ettingoff,Kimberly | \n", "Intern I | \n", "ASD Human Resources | \n", "$4960.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$4960.00 | \n", "02144 | \n", "
11 | \n", "Figueroa Ortiz,Irene | \n", "Intern I | \n", "ASD Human Resources | \n", "$4960.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$4960.00 | \n", "02138 | \n", "
12 | \n", "Firicano,Frank P. | \n", "Sr Admin Asst (OHR) | \n", "ASD Human Resources | \n", "$91743.12 | \n", "$0.00 | \n", "$225.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$91968.12 | \n", "02189 | \n", "
13 | \n", "Flemming,Teresia K | \n", "Head Account Clerk | \n", "ASD Human Resources | \n", "$47455.39 | \n", "$0.00 | \n", "$856.78 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$48312.17 | \n", "02128 | \n", "
14 | \n", "Gee,Xing-Bing | \n", "Data Proc Sys Analyst | \n", "ASD Human Resources | \n", "$76393.46 | \n", "$0.00 | \n", "$3082.44 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$79475.90 | \n", "02130 | \n", "
15 | \n", "Grant,Michael Scott | \n", "Sr Data Proc Sys Anl | \n", "ASD Human Resources | \n", "$106594.16 | \n", "$0.00 | \n", "$2620.06 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$109214.22 | \n", "02136 | \n", "
16 | \n", "Green,Allison Camille | \n", "Intern I | \n", "ASD Human Resources | \n", "$4960.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$4960.00 | \n", "02143 | \n", "
17 | \n", "Green,Kathleen M | \n", "Health Insurance Coordinator | \n", "ASD Human Resources | \n", "$91938.06 | \n", "$0.00 | \n", "$4765.38 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$96703.44 | \n", "02129 | \n", "
18 | \n", "Guante,Celiana | \n", "Admin Asst | \n", "ASD Human Resources | \n", "$23934.49 | \n", "$0.00 | \n", "$998.34 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$24932.83 | \n", "02121 | \n", "
19 | \n", "Hanson,Sheila A | \n", "Head Clerk | \n", "ASD Human Resources | \n", "$42311.33 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$42311.33 | \n", "02136 | \n", "
20 | \n", "Jackson-Rodgers,Jacqueline N. | \n", "Sr Admin Asst (OHR) | \n", "ASD Human Resources | \n", "$91744.59 | \n", "$0.00 | \n", "$627.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$92371.59 | \n", "02126 | \n", "
21 | \n", "Kessler,William | \n", "Asst Dir (Human Resources) | \n", "ASD Human Resources | \n", "$117411.06 | \n", "$0.00 | \n", "$4391.66 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$121802.72 | \n", "02132 | \n", "
22 | \n", "Killarney,Bernard | \n", "Director of Operations | \n", "ASD Human Resources | \n", "$9608.45 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$9608.45 | \n", "02136 | \n", "
23 | \n", "Lanchester,Diane | \n", "Office Manager | \n", "ASD Human Resources | \n", "$65169.15 | \n", "$0.00 | \n", "$787.25 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$65956.40 | \n", "02131 | \n", "
24 | \n", "Lee,Winnie | \n", "Sr Admin Asst | \n", "ASD Human Resources | \n", "$76393.49 | \n", "$0.00 | \n", "$1653.72 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$78047.21 | \n", "02170 | \n", "
25 | \n", "Leonard,Vivian | \n", "Supv of Personnel | \n", "ASD Human Resources | \n", "$115982.88 | \n", "$0.00 | \n", "$2230.44 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$118213.32 | \n", "02136 | \n", "
26 | \n", "Marshall,Leah A. | \n", "Human Resources Representative | \n", "ASD Human Resources | \n", "$46423.61 | \n", "$0.00 | \n", "$300.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$46723.61 | \n", "02126 | \n", "
27 | \n", "McNeil,Jean M | \n", "Supv-Management Svcs | \n", "ASD Human Resources | \n", "$71139.91 | \n", "$0.00 | \n", "$865.37 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$72005.28 | \n", "02136 | \n", "
28 | \n", "Melle,Laura | \n", "Intern I | \n", "ASD Human Resources | \n", "$5580.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$5580.00 | \n", "02139 | \n", "
29 | \n", "Morant,Darius | \n", "Prin Clerk | \n", "ASD Human Resources | \n", "$5710.80 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$5710.80 | \n", "02119 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
22203 | \n", "Wilson,Jeffrey | \n", "Fire Fighter-AdvanceTechnician | \n", "Boston Fire Department | \n", "$88662.18 | \n", "$12890.60 | \n", "$550.00 | \n", "$12730.82 | \n", "$6633.81 | \n", "$128.00 | \n", "$0.00 | \n", "$121595.41 | \n", "02136 | \n", "
22204 | \n", "Wilson,Keith Michael | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$53235.90 | \n", "$2999.38 | \n", "$550.00 | \n", "$5352.20 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$62137.48 | \n", "02132 | \n", "
22205 | \n", "Wilson,Marlon | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$88461.02 | \n", "$13602.82 | \n", "$550.00 | \n", "$13775.17 | \n", "$4855.79 | \n", "$8326.75 | \n", "$0.00 | \n", "$129571.55 | \n", "02136 | \n", "
22206 | \n", "Wilson,Ryan Jon | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$21364.38 | \n", "$0.00 | \n", "$275.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$21639.38 | \n", "02132 | \n", "
22207 | \n", "Wilson,Sean E | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$78538.07 | \n", "$7593.22 | \n", "$550.00 | \n", "$6989.46 | \n", "$49.23 | \n", "$8462.25 | \n", "$0.00 | \n", "$102182.23 | \n", "02136 | \n", "
22208 | \n", "Wilson,Wayne A | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$96178.88 | \n", "$10010.18 | \n", "$2157.24 | \n", "$24629.94 | \n", "$4337.00 | \n", "$561.00 | \n", "$0.00 | \n", "$137874.24 | \n", "02026 | \n", "
22209 | \n", "Wirtz,Eric M | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$71911.66 | \n", "$7198.69 | \n", "$550.00 | \n", "$3892.15 | \n", "$7678.90 | \n", "$0.00 | \n", "$0.00 | \n", "$91231.40 | \n", "02122 | \n", "
22210 | \n", "Wong,Connie S | \n", "Dep Comm-Labor & Legal | \n", "Boston Fire Department | \n", "$28750.02 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$28750.02 | \n", "02111 | \n", "
22211 | \n", "Wong,Robert | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$15670.19 | \n", "$8210.82 | \n", "$11065.36 | \n", "$2127.66 | \n", "$84109.32 | \n", "$0.00 | \n", "$0.00 | \n", "$121183.35 | \n", "02118 | \n", "
22212 | \n", "Wong,William | \n", "Asst Prin accountant | \n", "Boston Fire Department | \n", "$39974.95 | \n", "$0.00 | \n", "$747.72 | \n", "$38029.14 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$78751.81 | \n", "02132 | \n", "
22213 | \n", "Woodbury,Dennis A | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$96764.06 | \n", "$14814.32 | \n", "$2157.24 | \n", "$21890.55 | \n", "$718.99 | \n", "$2401.50 | \n", "$0.00 | \n", "$138746.66 | \n", "02124 | \n", "
22214 | \n", "Woods,Patrick J | \n", "Fire Lieutenant | \n", "Boston Fire Department | \n", "$110597.16 | \n", "$16537.28 | \n", "$2451.66 | \n", "$18038.47 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$147624.57 | \n", "02129 | \n", "
22215 | \n", "Wornum,Dwight H | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$149.99 | \n", "$6261.44 | \n", "$3063.63 | \n", "$0.00 | \n", "$100310.76 | \n", "$0.00 | \n", "$0.00 | \n", "$109785.82 | \n", "02136 | \n", "
22216 | \n", "Wornum,John W | \n", "FF (FPDInspLevl1Certification) | \n", "Boston Fire Department | \n", "$98109.51 | \n", "$13524.14 | \n", "$6243.64 | \n", "$4866.68 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$122743.97 | \n", "02121 | \n", "
22217 | \n", "Wornum,Phillip B. | \n", "FF LEP Title 3 Inspector - ADR | \n", "Boston Fire Department | \n", "$1195.32 | \n", "$1188.70 | \n", "$85430.84 | \n", "$0.00 | \n", "$103564.81 | \n", "$0.00 | \n", "$0.00 | \n", "$191379.67 | \n", "02186 | \n", "
22218 | \n", "Worrell,David E | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$0.00 | \n", "$1013.60 | \n", "$0.00 | \n", "$0.00 | \n", "$1425.72 | \n", "$0.00 | \n", "$0.00 | \n", "$2439.32 | \n", "02121 | \n", "
22219 | \n", "Wosny,Joseph Andrew | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$21364.38 | \n", "$0.00 | \n", "$275.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$21639.38 | \n", "02132 | \n", "
22220 | \n", "Wright,Alexander E | \n", "Fire Fighter-Technician | \n", "Boston Fire Department | \n", "$94499.10 | \n", "$14911.41 | \n", "$2151.24 | \n", "$19095.59 | \n", "$0.00 | \n", "$5132.75 | \n", "$0.00 | \n", "$135790.09 | \n", "02072 | \n", "
22221 | \n", "Wright,Ballin L | \n", "Fire Fighter-AdvanceTechnician | \n", "Boston Fire Department | \n", "$84536.18 | \n", "$14204.17 | \n", "$3721.05 | \n", "$18540.90 | \n", "$13082.71 | \n", "$1488.00 | \n", "$0.00 | \n", "$135573.01 | \n", "02125 | \n", "
22222 | \n", "Wright,Christopher D | \n", "Fire Fighter-Technician | \n", "Boston Fire Department | \n", "$93427.63 | \n", "$14077.81 | \n", "$550.00 | \n", "$17740.79 | \n", "$448.65 | \n", "$0.00 | \n", "$0.00 | \n", "$126244.88 | \n", "02132 | \n", "
22223 | \n", "Wright,James | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$0.00 | \n", "$6499.01 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$6499.01 | \n", "02368 | \n", "
22224 | \n", "Wuschke,Barbara | \n", "Fire Alarm Operator | \n", "Boston Fire Department | \n", "$95154.82 | \n", "$13596.87 | \n", "$550.00 | \n", "$9325.59 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$118627.28 | \n", "02124 | \n", "
22225 | \n", "Wyman,George L | \n", "District Fire Chief Tech-ADR | \n", "Boston Fire Department | \n", "$0.00 | \n", "$3699.29 | \n", "$0.00 | \n", "$0.00 | \n", "$2845.81 | \n", "$0.00 | \n", "$0.00 | \n", "$6545.10 | \n", "02360 | \n", "
22226 | \n", "Wyzard,Keith T | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$94460.92 | \n", "$14055.44 | \n", "$1466.23 | \n", "$11700.05 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$121682.64 | \n", "02368 | \n", "
22227 | \n", "Yanosick,Justin Timothy | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$92646.90 | \n", "$14250.84 | \n", "$550.00 | \n", "$28269.86 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$135717.60 | \n", "02132 | \n", "
22228 | \n", "Yee,Jacob | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$80073.63 | \n", "$13529.71 | \n", "$550.00 | \n", "$15560.09 | \n", "$13353.47 | \n", "$7245.75 | \n", "$0.00 | \n", "$130312.65 | \n", "02136 | \n", "
22229 | \n", "Yetman,Patrick | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$69886.18 | \n", "$5191.64 | \n", "$550.00 | \n", "$8227.25 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$83855.07 | \n", "02127 | \n", "
22230 | \n", "Young,Allan M | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$97234.17 | \n", "$14091.91 | \n", "$3050.00 | \n", "$6193.76 | \n", "$0.00 | \n", "$4464.00 | \n", "$0.00 | \n", "$125033.84 | \n", "02136 | \n", "
22231 | \n", "Young,Michael L | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$95694.84 | \n", "$13973.38 | \n", "$550.00 | \n", "$10678.12 | \n", "$0.00 | \n", "$132.00 | \n", "$0.00 | \n", "$121028.34 | \n", "02121 | \n", "
22232 | \n", "Zagami,Anthony J | \n", "Fire Alarm Operator | \n", "Boston Fire Department | \n", "$0.00 | \n", "$5494.93 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$5494.93 | \n", "02124 | \n", "
22233 rows × 12 columns
\n", "\n", " | NAME | \n", "TITLE | \n", "DEPARTMENT NAME | \n", "REGULAR | \n", "RETRO | \n", "OTHER | \n", "OVERTIME | \n", "INJURED | \n", "DETAIL | \n", "QUINN | \n", "TOTAL EARNINGS | \n", "ZIP | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
16758 | \n", "Linnenbank,Kristen Laura | \n", "Director (D) (non-ac) | \n", "UP Academy Dorchester | \n", "$99999.90 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99999.90 | \n", "01970 | \n", "
13686 | \n", "Iatrou,Kyriaki | \n", "Teacher | \n", "Curley K-8 | \n", "$99393.58 | \n", "$0.00 | \n", "$600.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99993.58 | \n", "02167 | \n", "
8769 | \n", "Rice,Juli | \n", "Teacher | \n", "BPS Manning Elementary | \n", "$99992.65 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99992.65 | \n", "02130 | \n", "
6432 | \n", "Cartagena,Angel L. | \n", "Teacher | \n", "BPS East Boston High | \n", "$95554.68 | \n", "$0.00 | \n", "$4436.50 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99991.18 | \n", "02149 | \n", "
16246 | \n", "Gantt,Danielle | \n", "Coordinator 7 | \n", "Teaching & Learning | \n", "$99989.77 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99989.77 | \n", "02121 | \n", "
8179 | \n", "Lonergan,Mark J | \n", "Teacher | \n", "BPS Human Resource Team | \n", "$99989.33 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99989.33 | \n", "02131 | \n", "
9637 | \n", "Pinkney-Chase,LaTrelle Natosha | \n", "Teacher | \n", "BPS MPH\\Health Academy | \n", "$94444.78 | \n", "$0.00 | \n", "$5537.60 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99982.38 | \n", "02132 | \n", "
5938 | \n", "O'Connell,Bebhinn | \n", "Teacher | \n", "BPS Cl#10 Lee Academy | \n", "$98979.47 | \n", "$0.00 | \n", "$1000.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99979.47 | \n", "02062 | \n", "
13786 | \n", "McIsaac,Stephen J. | \n", "Teacher | \n", "Dorchester Academy | \n", "$98778.83 | \n", "$0.00 | \n", "$1200.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99978.83 | \n", "02155 | \n", "
13480 | \n", "Torres-Vivas,Odalis | \n", "Teacher | \n", "BPS Winship Elementary | \n", "$97960.72 | \n", "$0.00 | \n", "$2015.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99975.72 | \n", "02135 | \n", "
15797 | \n", "Tippett,Jodi L | \n", "Nurse | \n", "Lyon K-8 | \n", "$99971.35 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99971.35 | \n", "02421 | \n", "
9063 | \n", "Holland,Mary F | \n", "Teacher | \n", "BPS McCormack Middle | \n", "$99952.22 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99952.22 | \n", "02072 | \n", "
5939 | \n", "Purple,Keri L | \n", "Specialist (BTU) | \n", "BPS Cl#10 Lee Academy | \n", "$99429.05 | \n", "$0.00 | \n", "$500.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99929.05 | \n", "02131 | \n", "
6249 | \n", "Ward-Wilson,Stephanie A | \n", "School Psychologist(1) | \n", "BPS Counseling Service | \n", "$98778.83 | \n", "$0.00 | \n", "$1150.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99928.83 | \n", "02043 | \n", "
17515 | \n", "Burns,Nolan R | \n", "Police Officer | \n", "Boston Police Department | \n", "$69251.35 | \n", "$2936.57 | \n", "$807.33 | \n", "$12722.97 | \n", "$0.00 | \n", "$14207.00 | \n", "$0.00 | \n", "$99925.22 | \n", "02129 | \n", "
16865 | \n", "Peddie,Jabari | \n", "Principal Elementary | \n", "UP Academy Holland | \n", "$99924.65 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99924.65 | \n", "02126 | \n", "
6644 | \n", "Galvin,Janice M. | \n", "Teacher | \n", "BPS Ellis Elementary | \n", "$99322.59 | \n", "$0.00 | \n", "$600.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99922.59 | \n", "02132 | \n", "
12560 | \n", "Gomes,Idalina | \n", "Teacher | \n", "BPS Sumner Elementary | \n", "$99405.43 | \n", "$0.00 | \n", "$500.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99905.43 | \n", "02189 | \n", "
10478 | \n", "Donovan,Amy M | \n", "Teacher | \n", "BPS Rogers Middle | \n", "$98901.87 | \n", "$0.00 | \n", "$1000.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99901.87 | \n", "02184 | \n", "
4204 | \n", "McCabe,James B | \n", "Workers Comp Job Classificatn | \n", "Workers Compensation Service | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$999.31 | \n", "$0.00 | \n", "$0.00 | \n", "$999.31 | \n", "02132 | \n", "
4775 | \n", "Hart,Allyson N. | \n", "Director (Basas 10B) | \n", "BPS Blackstone Elementary | \n", "$99898.99 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99898.99 | \n", "02062 | \n", "
10948 | \n", "Couture,Aaron | \n", "SpEd Support Svcs Supervisor | \n", "BPS Special Education | \n", "$99898.99 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99898.99 | \n", "02081 | \n", "
7506 | \n", "Yee,James | \n", "Sen Supv Schl Bldg Electrical | \n", "BPS Facility Mgmt/A & R | \n", "$83106.38 | \n", "$663.16 | \n", "$3842.00 | \n", "$12280.31 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99891.85 | \n", "02467 | \n", "
4651 | \n", "Gangemi,Josephine C. | \n", "Teacher | \n", "BPS Bates Elementary | \n", "$99886.57 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99886.57 | \n", "02131 | \n", "
13448 | \n", "Feuerstein,Tia Marie | \n", "Teacher | \n", "BPS Winship Elementary | \n", "$99886.57 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99886.57 | \n", "02124 | \n", "
21153 | \n", "Hardy,Brett R. | \n", "Fire Fighter-Technician | \n", "Boston Fire Department | \n", "$82685.69 | \n", "$8492.91 | \n", "$550.00 | \n", "$8128.65 | \n", "$27.31 | \n", "$0.00 | \n", "$0.00 | \n", "$99884.56 | \n", "02122 | \n", "
16087 | \n", "Chang,Sarah | \n", "Teacher | \n", "Quincy Upper School | \n", "$96884.16 | \n", "$0.00 | \n", "$3000.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99884.16 | \n", "02118 | \n", "
5272 | \n", "Amoroso,Rita A | \n", "Nurse | \n", "BPS Bradley Elementary | \n", "$99883.34 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99883.34 | \n", "02151 | \n", "
15985 | \n", "Adam,S.Farhan | \n", "Teacher | \n", "Newcomers Academy | \n", "$98778.83 | \n", "$0.00 | \n", "$1102.80 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99881.63 | \n", "02124 | \n", "
15315 | \n", "Gallivan,Ellen E | \n", "Teacher | \n", "Jackson/Mann K-8 | \n", "$99378.91 | \n", "$0.00 | \n", "$500.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$99878.91 | \n", "01746 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
4855 | \n", "Gonzalez,Ramiro G | \n", "Teacher | \n", "BPS Boston Arts Academy | \n", "$70885.98 | \n", "$0.00 | \n", "$29248.02 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100134.00 | \n", "02908 | \n", "
21347 | \n", "Kelly,Michael Joseph | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$65265.15 | \n", "$3402.52 | \n", "$550.00 | \n", "$9819.90 | \n", "$765.59 | \n", "$20330.75 | \n", "$0.00 | \n", "$100133.91 | \n", "02124 | \n", "
6091 | \n", "Petruccelli,Carol A | \n", "Teacher | \n", "BPS Condon Elementary | \n", "$99378.91 | \n", "$0.00 | \n", "$755.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100133.91 | \n", "02115 | \n", "
4648 | \n", "Fitzgerald,Christine L. | \n", "Teacher | \n", "BPS Bates Elementary | \n", "$100128.45 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100128.45 | \n", "02760 | \n", "
16089 | \n", "Chen,Yuyu | \n", "Teacher | \n", "Quincy Upper School | \n", "$87374.84 | \n", "$0.00 | \n", "$12750.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100124.84 | \n", "02155 | \n", "
18397 | \n", "Goodband,Clifford | \n", "Prin Admin Asst | \n", "Boston Police Department | \n", "$73768.58 | \n", "$0.00 | \n", "$1520.58 | \n", "$24831.84 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100121.00 | \n", "02132 | \n", "
15474 | \n", "Moody,Kathyann R | \n", "Teacher | \n", "Kennedy, JF Elementary | \n", "$97716.46 | \n", "$0.00 | \n", "$2401.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100117.46 | \n", "02126 | \n", "
3428 | \n", "Pham,Tan V | \n", "Sr Civil Engineer | \n", "Public Works Department | \n", "$82568.29 | \n", "$0.00 | \n", "$4124.83 | \n", "$13412.71 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100105.83 | \n", "02124 | \n", "
4660 | \n", "Kelley,Noreen M | \n", "Teacher | \n", "BPS Bates Elementary | \n", "$100101.93 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100101.93 | \n", "02124 | \n", "
18941 | \n", "Lewis,Janet P. | \n", "Police Officer | \n", "Boston Police Department | \n", "$80225.99 | \n", "$10171.54 | \n", "$5164.95 | \n", "$4348.43 | \n", "$189.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100099.91 | \n", "02131 | \n", "
16910 | \n", "Capone-Cameron,Teresa | \n", "Teacher | \n", "Warren/Prescott K-8 | \n", "$99348.35 | \n", "$0.00 | \n", "$750.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100098.35 | \n", "02155 | \n", "
8283 | \n", "Galac,Mitchelle A. | \n", "Teacher | \n", "BPS Irving Middle | \n", "$99833.53 | \n", "$0.00 | \n", "$250.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100083.53 | \n", "02170 | \n", "
6668 | \n", "Murad,Lynda J. | \n", "Teacher | \n", "BPS Ellis Elementary | \n", "$99833.53 | \n", "$0.00 | \n", "$250.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100083.53 | \n", "02131 | \n", "
2820 | \n", "Towle,David | \n", "Summer Youth Worker | \n", "Parks Department | \n", "$10008.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$10008.00 | \n", "02131 | \n", "
4358 | \n", "Jar-Curran,Lena | \n", "Teacher | \n", "Baldwin ELC | \n", "$98078.91 | \n", "$0.00 | \n", "$2000.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100078.91 | \n", "02141 | \n", "
21668 | \n", "Moran,Patrick | \n", "Fire Fighter-Technician | \n", "Boston Fire Department | \n", "$82668.55 | \n", "$8595.18 | \n", "$550.00 | \n", "$8255.26 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100068.99 | \n", "02132 | \n", "
1899 | \n", "Alvarez,Indira C | \n", "Exec Asst (ISD) | \n", "Inspectional Services Dept | \n", "$99414.58 | \n", "$0.00 | \n", "$0.00 | \n", "$641.96 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100056.54 | \n", "02121 | \n", "
13768 | \n", "Fitzpatrick,Marcia E | \n", "SpEd Support Svcs Coordinator | \n", "Dorchester Academy | \n", "$93744.08 | \n", "$0.00 | \n", "$6310.80 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100054.88 | \n", "02122 | \n", "
8167 | \n", "Kelley,Daniel W | \n", "Teacher | \n", "BPS Human Resource Team | \n", "$100052.06 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100052.06 | \n", "02122 | \n", "
16987 | \n", "Erilus,Yves F. | \n", "Teacher | \n", "West Roxbury Academy | \n", "$100048.89 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100048.89 | \n", "02760 | \n", "
5134 | \n", "Freeman,Judi H | \n", "Teacher | \n", "BPS Boston Latin | \n", "$100048.89 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100048.89 | \n", "02118 | \n", "
13942 | \n", "Gothie,Megan M | \n", "Teacher | \n", "Edison K-8 | \n", "$100048.89 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100048.89 | \n", "02494 | \n", "
13978 | \n", "O'Rourke,Kerry A | \n", "Teacher | \n", "Edison K-8 | \n", "$100044.60 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100044.60 | \n", "02122 | \n", "
7841 | \n", "Jean,Maria T | \n", "Teacher | \n", "BPS Hennigan Elementary | \n", "$98593.76 | \n", "$0.00 | \n", "$1438.98 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100032.74 | \n", "02136 | \n", "
10523 | \n", "Smith,Maya S. | \n", "School Disciplinary Officer | \n", "BPS Rogers Middle | \n", "$96574.76 | \n", "$0.00 | \n", "$3450.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100024.76 | \n", "02131 | \n", "
9987 | \n", "Johnson,Anita | \n", "Attendant | \n", "BPS Office Of Budget Mgmt | \n", "$7692.21 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$2310.00 | \n", "$0.00 | \n", "$0.00 | \n", "$10002.21 | \n", "02126 | \n", "
8023 | \n", "Chace,Jennifer A | \n", "Teacher | \n", "BPS Horace Mann | \n", "$100012.37 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100012.37 | \n", "02135 | \n", "
5600 | \n", "Scott,Tarek | \n", "Over-Time Stipend Other | \n", "BPS Business Service | \n", "$0.00 | \n", "$0.00 | \n", "$1000.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$1000.00 | \n", "02119 | \n", "
14664 | \n", "Morin,Kristen Marie | \n", "Community Field Coordinator | \n", "Greenwood, E Leadership Acad | \n", "$0.00 | \n", "$0.00 | \n", "$100.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$100.00 | \n", "02130 | \n", "
6762 | \n", "Larievy,Arthur F. | \n", "Program Director (Basas 9A) | \n", "BPS English High | \n", "$0.00 | \n", "$10.82 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$10.82 | \n", "02118 | \n", "
22233 rows × 12 columns
\n", "\n", " | NAME | \n", "TITLE | \n", "DEPARTMENT NAME | \n", "REGULAR | \n", "RETRO | \n", "OTHER | \n", "OVERTIME | \n", "INJURED | \n", "DETAIL | \n", "QUINN | \n", "TOTAL EARNINGS | \n", "ZIP | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Adario,Anthony J | \n", "Supvising Claims Agent (Asd) | \n", "ASD Human Resources | \n", "$98538.32 | \n", "$0.00 | \n", "$1842.87 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "100381.19 | \n", "02132 | \n", "
1 | \n", "Baker,Katherine E. | \n", "Nurse Case Manager | \n", "ASD Human Resources | \n", "$83942.21 | \n", "$0.00 | \n", "$225.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "84167.21 | \n", "02136 | \n", "
2 | \n", "Braga,Ann Hess | \n", "HumanResourcesComplianceOffcr | \n", "ASD Human Resources | \n", "$98538.34 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "98538.34 | \n", "02126 | \n", "
3 | \n", "Calobrisi,Jane Ellen | \n", "Personnel Analyst | \n", "ASD Human Resources | \n", "$70073.81 | \n", "$0.00 | \n", "$225.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "70298.81 | \n", "02090 | \n", "
4 | \n", "Castillo-Cook,Wendolyn M. | \n", "Alcholism Coord I | \n", "ASD Human Resources | \n", "$79253.11 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "79253.11 | \n", "02121 | \n", "
5 | \n", "Curran,Liam Patrick | \n", "Asst Corp Counsel III | \n", "ASD Human Resources | \n", "$69266.69 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "69266.69 | \n", "02122 | \n", "
6 | \n", "De Jesus,Winnie Yam | \n", "Affirm Action Monitor | \n", "ASD Human Resources | \n", "$42061.21 | \n", "$0.00 | \n", "$487.21 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "42548.42 | \n", "02458 | \n", "
7 | \n", "Donnelly,Jennifer P. | \n", "Prin Clerk | \n", "ASD Human Resources | \n", "$44080.61 | \n", "$0.00 | \n", "$300.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "44380.61 | \n", "02129 | \n", "
8 | \n", "Donovan,Carol Anne | \n", "Prin Admin Analyst | \n", "ASD Human Resources | \n", "$73547.25 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "73547.25 | \n", "02127 | \n", "
9 | \n", "Donovan,John J | \n", "Exec Asst (EAP/OHR) | \n", "ASD Human Resources | \n", "$15019.39 | \n", "$0.00 | \n", "$10250.05 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "25269.44 | \n", "02132 | \n", "
10 | \n", "Ettingoff,Kimberly | \n", "Intern I | \n", "ASD Human Resources | \n", "$4960.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "4960.00 | \n", "02144 | \n", "
11 | \n", "Figueroa Ortiz,Irene | \n", "Intern I | \n", "ASD Human Resources | \n", "$4960.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "4960.00 | \n", "02138 | \n", "
12 | \n", "Firicano,Frank P. | \n", "Sr Admin Asst (OHR) | \n", "ASD Human Resources | \n", "$91743.12 | \n", "$0.00 | \n", "$225.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "91968.12 | \n", "02189 | \n", "
13 | \n", "Flemming,Teresia K | \n", "Head Account Clerk | \n", "ASD Human Resources | \n", "$47455.39 | \n", "$0.00 | \n", "$856.78 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "48312.17 | \n", "02128 | \n", "
14 | \n", "Gee,Xing-Bing | \n", "Data Proc Sys Analyst | \n", "ASD Human Resources | \n", "$76393.46 | \n", "$0.00 | \n", "$3082.44 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "79475.90 | \n", "02130 | \n", "
15 | \n", "Grant,Michael Scott | \n", "Sr Data Proc Sys Anl | \n", "ASD Human Resources | \n", "$106594.16 | \n", "$0.00 | \n", "$2620.06 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "109214.22 | \n", "02136 | \n", "
16 | \n", "Green,Allison Camille | \n", "Intern I | \n", "ASD Human Resources | \n", "$4960.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "4960.00 | \n", "02143 | \n", "
17 | \n", "Green,Kathleen M | \n", "Health Insurance Coordinator | \n", "ASD Human Resources | \n", "$91938.06 | \n", "$0.00 | \n", "$4765.38 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "96703.44 | \n", "02129 | \n", "
18 | \n", "Guante,Celiana | \n", "Admin Asst | \n", "ASD Human Resources | \n", "$23934.49 | \n", "$0.00 | \n", "$998.34 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "24932.83 | \n", "02121 | \n", "
19 | \n", "Hanson,Sheila A | \n", "Head Clerk | \n", "ASD Human Resources | \n", "$42311.33 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "42311.33 | \n", "02136 | \n", "
20 | \n", "Jackson-Rodgers,Jacqueline N. | \n", "Sr Admin Asst (OHR) | \n", "ASD Human Resources | \n", "$91744.59 | \n", "$0.00 | \n", "$627.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "92371.59 | \n", "02126 | \n", "
21 | \n", "Kessler,William | \n", "Asst Dir (Human Resources) | \n", "ASD Human Resources | \n", "$117411.06 | \n", "$0.00 | \n", "$4391.66 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "121802.72 | \n", "02132 | \n", "
22 | \n", "Killarney,Bernard | \n", "Director of Operations | \n", "ASD Human Resources | \n", "$9608.45 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "9608.45 | \n", "02136 | \n", "
23 | \n", "Lanchester,Diane | \n", "Office Manager | \n", "ASD Human Resources | \n", "$65169.15 | \n", "$0.00 | \n", "$787.25 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "65956.40 | \n", "02131 | \n", "
24 | \n", "Lee,Winnie | \n", "Sr Admin Asst | \n", "ASD Human Resources | \n", "$76393.49 | \n", "$0.00 | \n", "$1653.72 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "78047.21 | \n", "02170 | \n", "
25 | \n", "Leonard,Vivian | \n", "Supv of Personnel | \n", "ASD Human Resources | \n", "$115982.88 | \n", "$0.00 | \n", "$2230.44 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "118213.32 | \n", "02136 | \n", "
26 | \n", "Marshall,Leah A. | \n", "Human Resources Representative | \n", "ASD Human Resources | \n", "$46423.61 | \n", "$0.00 | \n", "$300.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "46723.61 | \n", "02126 | \n", "
27 | \n", "McNeil,Jean M | \n", "Supv-Management Svcs | \n", "ASD Human Resources | \n", "$71139.91 | \n", "$0.00 | \n", "$865.37 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "72005.28 | \n", "02136 | \n", "
28 | \n", "Melle,Laura | \n", "Intern I | \n", "ASD Human Resources | \n", "$5580.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "5580.00 | \n", "02139 | \n", "
29 | \n", "Morant,Darius | \n", "Prin Clerk | \n", "ASD Human Resources | \n", "$5710.80 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "5710.80 | \n", "02119 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
22203 | \n", "Wilson,Jeffrey | \n", "Fire Fighter-AdvanceTechnician | \n", "Boston Fire Department | \n", "$88662.18 | \n", "$12890.60 | \n", "$550.00 | \n", "$12730.82 | \n", "$6633.81 | \n", "$128.00 | \n", "$0.00 | \n", "121595.41 | \n", "02136 | \n", "
22204 | \n", "Wilson,Keith Michael | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$53235.90 | \n", "$2999.38 | \n", "$550.00 | \n", "$5352.20 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "62137.48 | \n", "02132 | \n", "
22205 | \n", "Wilson,Marlon | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$88461.02 | \n", "$13602.82 | \n", "$550.00 | \n", "$13775.17 | \n", "$4855.79 | \n", "$8326.75 | \n", "$0.00 | \n", "129571.55 | \n", "02136 | \n", "
22206 | \n", "Wilson,Ryan Jon | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$21364.38 | \n", "$0.00 | \n", "$275.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "21639.38 | \n", "02132 | \n", "
22207 | \n", "Wilson,Sean E | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$78538.07 | \n", "$7593.22 | \n", "$550.00 | \n", "$6989.46 | \n", "$49.23 | \n", "$8462.25 | \n", "$0.00 | \n", "102182.23 | \n", "02136 | \n", "
22208 | \n", "Wilson,Wayne A | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$96178.88 | \n", "$10010.18 | \n", "$2157.24 | \n", "$24629.94 | \n", "$4337.00 | \n", "$561.00 | \n", "$0.00 | \n", "137874.24 | \n", "02026 | \n", "
22209 | \n", "Wirtz,Eric M | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$71911.66 | \n", "$7198.69 | \n", "$550.00 | \n", "$3892.15 | \n", "$7678.90 | \n", "$0.00 | \n", "$0.00 | \n", "91231.40 | \n", "02122 | \n", "
22210 | \n", "Wong,Connie S | \n", "Dep Comm-Labor & Legal | \n", "Boston Fire Department | \n", "$28750.02 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "28750.02 | \n", "02111 | \n", "
22211 | \n", "Wong,Robert | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$15670.19 | \n", "$8210.82 | \n", "$11065.36 | \n", "$2127.66 | \n", "$84109.32 | \n", "$0.00 | \n", "$0.00 | \n", "121183.35 | \n", "02118 | \n", "
22212 | \n", "Wong,William | \n", "Asst Prin accountant | \n", "Boston Fire Department | \n", "$39974.95 | \n", "$0.00 | \n", "$747.72 | \n", "$38029.14 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "78751.81 | \n", "02132 | \n", "
22213 | \n", "Woodbury,Dennis A | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$96764.06 | \n", "$14814.32 | \n", "$2157.24 | \n", "$21890.55 | \n", "$718.99 | \n", "$2401.50 | \n", "$0.00 | \n", "138746.66 | \n", "02124 | \n", "
22214 | \n", "Woods,Patrick J | \n", "Fire Lieutenant | \n", "Boston Fire Department | \n", "$110597.16 | \n", "$16537.28 | \n", "$2451.66 | \n", "$18038.47 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "147624.57 | \n", "02129 | \n", "
22215 | \n", "Wornum,Dwight H | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$149.99 | \n", "$6261.44 | \n", "$3063.63 | \n", "$0.00 | \n", "$100310.76 | \n", "$0.00 | \n", "$0.00 | \n", "109785.82 | \n", "02136 | \n", "
22216 | \n", "Wornum,John W | \n", "FF (FPDInspLevl1Certification) | \n", "Boston Fire Department | \n", "$98109.51 | \n", "$13524.14 | \n", "$6243.64 | \n", "$4866.68 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "122743.97 | \n", "02121 | \n", "
22217 | \n", "Wornum,Phillip B. | \n", "FF LEP Title 3 Inspector - ADR | \n", "Boston Fire Department | \n", "$1195.32 | \n", "$1188.70 | \n", "$85430.84 | \n", "$0.00 | \n", "$103564.81 | \n", "$0.00 | \n", "$0.00 | \n", "191379.67 | \n", "02186 | \n", "
22218 | \n", "Worrell,David E | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$0.00 | \n", "$1013.60 | \n", "$0.00 | \n", "$0.00 | \n", "$1425.72 | \n", "$0.00 | \n", "$0.00 | \n", "2439.32 | \n", "02121 | \n", "
22219 | \n", "Wosny,Joseph Andrew | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$21364.38 | \n", "$0.00 | \n", "$275.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "21639.38 | \n", "02132 | \n", "
22220 | \n", "Wright,Alexander E | \n", "Fire Fighter-Technician | \n", "Boston Fire Department | \n", "$94499.10 | \n", "$14911.41 | \n", "$2151.24 | \n", "$19095.59 | \n", "$0.00 | \n", "$5132.75 | \n", "$0.00 | \n", "135790.09 | \n", "02072 | \n", "
22221 | \n", "Wright,Ballin L | \n", "Fire Fighter-AdvanceTechnician | \n", "Boston Fire Department | \n", "$84536.18 | \n", "$14204.17 | \n", "$3721.05 | \n", "$18540.90 | \n", "$13082.71 | \n", "$1488.00 | \n", "$0.00 | \n", "135573.01 | \n", "02125 | \n", "
22222 | \n", "Wright,Christopher D | \n", "Fire Fighter-Technician | \n", "Boston Fire Department | \n", "$93427.63 | \n", "$14077.81 | \n", "$550.00 | \n", "$17740.79 | \n", "$448.65 | \n", "$0.00 | \n", "$0.00 | \n", "126244.88 | \n", "02132 | \n", "
22223 | \n", "Wright,James | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$0.00 | \n", "$6499.01 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "6499.01 | \n", "02368 | \n", "
22224 | \n", "Wuschke,Barbara | \n", "Fire Alarm Operator | \n", "Boston Fire Department | \n", "$95154.82 | \n", "$13596.87 | \n", "$550.00 | \n", "$9325.59 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "118627.28 | \n", "02124 | \n", "
22225 | \n", "Wyman,George L | \n", "District Fire Chief Tech-ADR | \n", "Boston Fire Department | \n", "$0.00 | \n", "$3699.29 | \n", "$0.00 | \n", "$0.00 | \n", "$2845.81 | \n", "$0.00 | \n", "$0.00 | \n", "6545.10 | \n", "02360 | \n", "
22226 | \n", "Wyzard,Keith T | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$94460.92 | \n", "$14055.44 | \n", "$1466.23 | \n", "$11700.05 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "121682.64 | \n", "02368 | \n", "
22227 | \n", "Yanosick,Justin Timothy | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$92646.90 | \n", "$14250.84 | \n", "$550.00 | \n", "$28269.86 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "135717.60 | \n", "02132 | \n", "
22228 | \n", "Yee,Jacob | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$80073.63 | \n", "$13529.71 | \n", "$550.00 | \n", "$15560.09 | \n", "$13353.47 | \n", "$7245.75 | \n", "$0.00 | \n", "130312.65 | \n", "02136 | \n", "
22229 | \n", "Yetman,Patrick | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$69886.18 | \n", "$5191.64 | \n", "$550.00 | \n", "$8227.25 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "83855.07 | \n", "02127 | \n", "
22230 | \n", "Young,Allan M | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$97234.17 | \n", "$14091.91 | \n", "$3050.00 | \n", "$6193.76 | \n", "$0.00 | \n", "$4464.00 | \n", "$0.00 | \n", "125033.84 | \n", "02136 | \n", "
22231 | \n", "Young,Michael L | \n", "Fire Fighter | \n", "Boston Fire Department | \n", "$95694.84 | \n", "$13973.38 | \n", "$550.00 | \n", "$10678.12 | \n", "$0.00 | \n", "$132.00 | \n", "$0.00 | \n", "121028.34 | \n", "02121 | \n", "
22232 | \n", "Zagami,Anthony J | \n", "Fire Alarm Operator | \n", "Boston Fire Department | \n", "$0.00 | \n", "$5494.93 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "$0.00 | \n", "5494.93 | \n", "02124 | \n", "
22233 rows × 12 columns
\n", "