Highest Paid City Employees

#9989

Find the top 2 highest paid City employees for each job title. Use totalpaybenefits column for their ranking. Output the job title along with the corresponding highest and second-highest paid employees.

table name: sf_public_salaries


Solution:

--section 1
select jobtitle,[1],[2] from
--section 2
(
	select row_number() over (partition by jobtitle order by totalpaybenefits desc) as rnk, jobtitle,employeename from sf_public_salaries
)as pivotData
--section 3
pivot 
(
	max(employeename) for rnk in ([1],[2]) 
)as pivotTable

Output:


SQL Script:

USE [StraScratch]
GO
/****** Object:  Table [dbo].[sf_public_salaries]    Script Date: 26-09-2024 17:24:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sf_public_salaries](
	[id] [int] NULL,
	[employeename] [varchar](50) NULL,
	[jobtitle] [varchar](50) NULL,
	[basepay] [float] NULL,
	[overtimepay] [float] NULL,
	[otherpay] [float] NULL,
	[benefits] [float] NULL,
	[totalpay] [float] NULL,
	[totalpaybenefits] [float] NULL,
	[year] [int] NULL,
	[notes] [datetime] NULL,
	[agency] [varchar](50) NULL,
	[status] [varchar](50) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (120566, N'Teresa L Cavanaugh', N'EMT/Paramedic/Firefighter', 100952.41, 0, 4254.88, 34317.37, 105207.29, 139524.66, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72002, N'Ray Torres', N'Public Service Trainee', 1121.28, 0, 0, 185.77, 1121.28, 1307.05, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (122662, N'Rizaldy T Tabada', N'Deputy Sheriff', 92403.77, 138.18, 2903.94, 33625.27, 95445.89, 129071.16, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140133, N'Gregory B Bovo', N'Firefighter', 23757.5, 0, 0, 9982.21, 23757.5, 33739.71, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (87502, N'Jason L Landivar', N'EMT/Paramedic/Firefighter', 82115.61, 666.79, 5220.34, 28933.91, 88002.74, 116936.65, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71770, N'Fernando Barajas', N'Public Svc Aide-Public Works', 1585.6, 0, 0, 178.07, 1585.6, 1763.67, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144682, N'George Fudge', N'Transit Operator', 4390.15, 1059.31, 12.11, 2846.74, 5461.57, 8308.31, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148136, N'Jose F Granados', N'Public Svc Aide-Public Works', 661.2, 0, 0, 6.61, 661.2, 667.81, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72175, N'Linda Pizzorno', N'Registered Nurse', 0, 0, 795.01, 230.64, 795.01, 1025.65, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110316, N'Sophia  Wu', N'Public Service Trainee', 295.41, 0, 0, 2.95, 295.41, 298.36, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110441, N'Maria E Zuniga', N'Transit Operator', NULL, 0, 114.54, 0, 114.54, 114.54, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (57726, N'Sara Paredes', N'Registered Nurse', 65061.57, 0, 975, 23477.4, 66036.57, 89513.97, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (135711, N'Adina M Diamond', N'Registered Nurse', 52901.45, 3307.79, 2286.95, 19383.18, 58496.19, 77879.37, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (139629, N'Terry L Johnson', N'Transit Operator', 21183.22, 3841.15, 510.61, 13384.77, 25534.98, 38919.75, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64401, N'Sherry Mahoney', N'EMT/Paramedic/Firefighter', 29579, 0, 2402.7, 11785.19, 31981.7, 43766.89, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148022, N'Kari A Johnson', N'Firefighter', 688.71, 0, 0, 143.39, 688.71, 832.1, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (114356, N'Joseph M Salazar', N'Sergeant 3', 124770.09, 14167.98, 7510.15, 40182.2, 146448.22, 186630.42, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (104037, N'Annette  Kess', N'Transit Operator', NULL, 0, 11808, 7959.18, 11808, 19767.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71779, N'Ayala Mirande', N'Special Nurse', 367.73, 942.38, 44.11, 388.96, 1354.22, 1743.18, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143075, N'George L Abrams Jr', N'Transit Operator', 7316.62, 1622.58, 30.95, 4742.85, 8970.15, 13713, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64411, N'Seaborn Chiles', N'EMT/Paramedic/Firefighter', 29579, 551.46, 1626.46, 11871.64, 31756.92, 43628.56, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69659, N'Gwen Ferdinand', N'Transit Operator', 4506.51, 391.87, 46.56, 2806.53, 4944.94, 7751.47, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144573, N'Robert E Lee Jr', N'Transit Operator', 4390.16, 1258.02, 9.08, 2847.85, 5657.26, 8505.11, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72720, N'Andre Thomas', N'Public Svc Aide-Public Works', 155.85, 0, 2.44, 13.84, 158.29, 172.13, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (60447, N'James Lockhart', N'EMT/Paramedic/Firefighter', 58842, 0, 3801.37, 17031.18, 62643.37, 79674.55, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148014, N'Eric J Chen', N'Public Service Trainee', 800.13, 0, 35.66, 8.35, 835.79, 844.14, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109041, N'Paul J Ortiz', N'Special Nurse', 1768.55, 0, 243.6, 451.01, 2012.15, 2463.16, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (142145, N'Victor N Yeung', N'Transit Operator', 11889.93, 0, 0, 6285.35, 11889.93, 18175.28, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (39463, N'Steven Stocker', N'Sergeant 3', 135977.79, 1044, 12934.3, 36523.7, 149956.09, 186479.79, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (46861, N'Theresa Courtney', N'Deputy Sheriff', 88374, 3897.86, 6778.32, 34097.49, 99050.18, 133147.67, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (83706, N'Donald V Ortiz', N'Deputy Sheriff', 95126.53, 57.21, 6787.65, 33016.42, 101971.39, 134987.81, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (108749, N'Vivian A Showers', N'Transit Operator', 2056.09, 0, 0, 982.35, 2056.09, 3038.44, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (108321, N'Lenora  Hamilton', N'Transit Operator', 2529.28, 0, 0, 1464.59, 2529.28, 3993.87, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (125043, N'Ryan J Jamison', N'EMT/Paramedic/Firefighter', 81789.51, 1750.43, 2791.35, 31039.42, 86331.29, 117370.71, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102647, N'Alvin  Sosa', N'Transit Operator', 19331.12, 484.95, 460.37, 11349.44, 20276.44, 31625.88, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71309, N'Ernanie Rasquero', N'Special Nurse', 1831.8, 0, 61.06, 847.08, 1892.86, 2739.94, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144513, N'Ben D Malone', N'Transit Operator', 381.69, 0, 8103.54, 196.19, 8485.23, 8681.42, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (67873, N'Niem Tran', N'Transit Operator', 8975.38, 162.14, 51.1, 5794.22, 9188.62, 14982.84, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (66561, N'Nicole Freeney', N'Transit Operator', 9877.98, 2607.74, 3446.78, 6295.89, 15932.5, 22228.39, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (47109, N'Stephen Kendall', N'Deputy Sheriff', 81967.01, 8984.59, 6725.08, 34177.42, 97676.68, 131854.1, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109107, N'Elizabeth J Dayrit', N'Special Nurse', 1783.94, 0, 178.39, 371.87, 1962.33, 2334.2, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (125930, N'Andrew G Chen', N'Estate Investigator', 82052.03, 0, 0, 31796.98, 82052.03, 113849.01, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143254, N'Larry J Davis', N'Transit Operator', 813.86, 0, 11803.87, 418.32, 12617.73, 13036.05, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (39456, N'Melonee Alvarez', N'Sergeant 3', 135977.71, 5929.86, 6457.7, 38170.25, 148365.27, 186535.52, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102938, N'Pelzie L Smith', N'Transit Operator', 17563.25, 490.1, 121.01, 10229.59, 18174.36, 28403.95, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (56967, N'Denise Alexander', N'Estate Investigator', 61663.37, 0, 187.2, 30295.13, 61850.57, 92145.7, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71790, N'David Fleming', N'Special Nurse', 1294.4, 0, 63.5, 371.94, 1357.9, 1729.84, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (105663, N'Brian E Oconnor', N'Deputy Sheriff', 10433.32, 0, 742.59, 0, 11175.91, 11175.91, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109201, N'Jesus J Aromin', N'Public Svc Aide-Public Works', 2123.47, 0, 0, 21.23, 2123.47, 2144.7, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (68610, N'Liane Angus', N'Registered Nurse', 9456.38, 0, 0, 2042.66, 9456.38, 11499.04, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147868, N'Alma Rosa Garcia', N'Special Nurse', 849.45, 0, 28.32, 191.27, 877.77, 1069.04, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106739, N'Joann G Siobal', N'Registered Nurse', NULL, 0, 0, 7959.18, 0, 7959.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (122121, N'Michael Mason', N'EMT/Paramedic/Firefighter', 79486.03, 11570.7, 7049.8, 33573.17, 98106.53, 131679.7, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72890, N'Grace Salud', N'Special Nurse', 0, 0, 37.36, 8.91, 37.36, 46.27, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (135574, N'Raffaella V Wilson', N'Registered Nurse', 60506.68, 701.61, 0, 17555.43, 61208.29, 78763.72, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (120935, N'Lance A Obtinalla Jr', N'Deputy Sheriff', 93795.43, 1738.87, 6970.54, 35014.44, 102504.84, 137519.28, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140150, N'Ryan C Crow', N'Firefighter', 23757.5, 0, 0, 9982.21, 23757.5, 33739.71, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106686, N'Tracy Y Higgins', N'Transit Operator', NULL, 0, 0, 8014.34, 0, 8014.34, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (120469, N'Alexander M Lamond', N'EMT/Paramedic/Firefighter', 80143, 19393.4, 6783.04, 33498.66, 106319.44, 139818.1, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147667, N'Justina Dizon', N'Special Nurse', 989.1, 0, 164.85, 214.11, 1153.95, 1368.06, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (103394, N'Daniel Phillip Boutote', N'Eligibility Worker', 18943, 0, 967.4, 4468.04, 19910.4, 24378.44, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147540, N'Ivan Y Castillo', N'Public Svc Aide-Public Works', 1597.9, 0, 0, 15.98, 1597.9, 1613.88, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (105493, N'Willie  Daigle Jr', N'Transit Operator', 7064.29, 455.11, 32.56, 4364.12, 7551.96, 11916.08, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (66543, N'Margarita Herrera', N'Registered Nurse', 17973.09, 80.08, 21.36, 4245.6, 18074.53, 22320.13, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147284, N'Alan K Tolbert', N'Public Svc Aide-Public Works', 2070.29, 0, 0, 20.7, 2070.29, 2090.99, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (76558, N'Kathryn  Waaland', N'Sergeant 3', 141389.04, 4981.45, 2832.11, 40661.65, 149202.6, 189864.25, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143223, N'Luana D Beavers-Deloach', N'Transit Operator', 7159.17, 1303.18, 39.68, 4640.62, 8502.03, 13142.65, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143124, N'Marie E Monsen', N'Transit Operator', 7316.8, 1426.95, 52.85, 4747.43, 8796.6, 13544.03, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71858, N'Arnitial Donely', N'Public Svc Aide-Public Works', 1506.55, 0, 0, 116.64, 1506.55, 1623.19, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (63919, N'Christopher Wilcox', N'Registered Nurse', 19711.37, 3004.88, 16478.15, 10172.15, 39194.4, 49366.55, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106654, N'Ira  Newman', N'Transit Operator', NULL, 0, 115.72, 7959.18, 115.72, 8074.9, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (70958, N'Mandisa Mabrey', N'Eligibility Worker', 3165.48, 11.22, 109.29, 286.43, 3285.99, 3572.42, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72067, N'Juliet Palarca', N'Special Nurse', 981.72, 0, 0, 283.6, 981.72, 1265.32, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (46086, N'Arnel Maracha', N'Deputy Sheriff', 88374, 0, 12448.42, 36413.52, 100822.42, 137235.94, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147504, N'Jamie J Dwyer', N'Special Nurse', 1285.05, 0, 63.5, 324.83, 1348.55, 1673.38, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69902, N'Jacquelyn Vassar', N'Transit Operator', 4017.09, 278.96, 16.37, 2641.41, 4312.42, 6953.83, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (135122, N'Melinda Wong', N'Junior Administrative Analyst', 53190.53, 0, 0, 27849.12, 53190.53, 81039.65, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (122772, N'Graham P Hoffman', N'EMT/Paramedic/Firefighter', 80031.97, 11455.35, 5163.82, 31853, 96651.14, 128504.14, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71420, N'Kevin Clark', N'Public Svc Aide-Public Works', 2337.75, 0, 0, 204.3, 2337.75, 2542.05, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109069, N'Antionette L Riley', N'Public Svc Aide-Public Works', 2396.21, 0, 0, 23.97, 2396.21, 2420.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (141349, N'Audrey Ngo', N'Registered Nurse', 18725.55, 0, 160.31, 4351.3, 18885.86, 23237.16, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (68980, N'Robert Martinez', N'Registered Nurse', 8862.65, 0, 365.99, 740.47, 9228.64, 9969.11, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148626, N'Renato C Gurion', N'Registered Nurse', 0, 0, 6, 1.24, 6, 7.24, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (39539, N'Omar Bueno', N'Sergeant 3', 135967.55, 3237.59, 9032.26, 37389.65, 148237.4, 185627.05, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106805, N'Georgina M Pineda', N'Transit Operator', NULL, 0, 0, 7959.18, 0, 7959.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140237, N'Beverly Bagdorf', N'Registered Nurse', 14958.86, 0, 12311.86, 5538.93, 27270.72, 32809.65, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (141997, N'Emmanuel R Borja', N'Transit Operator', 10841.17, 950.95, 235.79, 7082.09, 12027.91, 19110, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110465, N'Vanessa E Almaguer', N'Special Nurse', 72.98, 0, 0, 15.2, 72.98, 88.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64823, N'Lilly Fung', N'Registered Nurse', 28586.7, 0, 0, 10105.75, 28586.7, 38692.45, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (65683, N'Mo Ching Wan', N'Registered Nurse', 22650, 0, 0, 6714.77, 22650, 29364.77, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (107962, N'Leanne Abrigo  Johnson', N'Registered Nurse', 4015, 0, 0, 876.07, 4015, 4891.07, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (141206, N'Wallina C Pellette', N'Transit Operator', 14872.99, 4598.75, 87.52, 4652.55, 19559.26, 24211.81, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (101991, N'Tretha T Stroughter', N'Eligibility Worker', 24282.43, 2048.88, 1851.05, 10164.46, 28182.36, 38346.82, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109207, N'Yolanda  Ramirez', N'Special Nurse', 1505.7, 0, 239.96, 383.43, 1745.66, 2129.09, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48994, N'Sarah Silva', N'Deputy Sheriff', 78346.64, 7001.85, 4451.18, 33280, 89799.67, 123079.67, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (143534, N'Monique C Jacobs', N'Transit Operator', 7781.96, 0, 0, 4026.55, 7781.96, 11808.51, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102585, N'Arturo  Galarza', N'Eligibility Worker', 23928.01, 0, 360, 7988.84, 24288.01, 32276.85, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71498, N'Willie Collins', N'Public Svc Aide-Public Works', 2129.95, 0, 43.92, 190.04, 2173.87, 2363.91, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (133757, N'Kathryn L Fowler', N'Registered Nurse', 61942.6, 0, 1959.8, 22291.87, 63902.4, 86194.27, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72151, N'Jack O''Sullivan', N'Public Service Trainee', 999.36, 0, 2.05, 78.01, 1001.41, 1079.42, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (113634, N'Mark F Obrochta', N'Sergeant 3', 137982.17, 9196.03, 5670.36, 43038.5, 152848.56, 195887.06, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (46516, N'Petra Hahn', N'Deputy Sheriff', 78353.8, 22953.71, 1062.13, 32704.29, 102369.64, 135073.93, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (121337, N'Yvette R Gay', N'Deputy Sheriff', 91439.78, 1048.86, 8289.84, 34442.81, 100778.48, 135221.29, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144559, N'Jarrett L Louie', N'Transit Operator', 4390.16, 1307.11, 9.08, 2848.36, 5706.35, 8554.71, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64262, N'Emily Anderson', N'EMT/Paramedic/Firefighter', 29175.65, 2139.69, 2169.08, 11825.59, 33484.42, 45310.01, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147049, N'Darryl L Armstrong', N'Transit Operator', 1934.15, 0, 0, 566.71, 1934.15, 2500.86, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109290, N'Claire M Leflore', N'Eligibility Worker', 1994, 0, 0, 19.94, 1994, 2013.94, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102042, N'Mary R Carr', N'Eligibility Worker', 24628.57, 2161.28, 191.17, 10922.03, 26981.02, 37903.05, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71488, N'Maiza Padilla', N'Public Svc Aide-Public Works', 1871.39, 0, 0, 499.62, 1871.39, 2371.01, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72135, N'Joannie Keys', N'Transit Operator', 595.12, 0, 0, 532.1, 595.12, 1127.22, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109293, N'Orlando M Gonzalez', N'Public Svc Aide-Public Works', 1987.09, 0, 0, 19.87, 1987.09, 2006.96, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (100543, N'Kenia C Coronado', N'Eligibility Worker', 37992.28, 909, 765, 15763.21, 39666.28, 55429.49, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (145535, N'Wing C Kwan', N'Transit Operator', 3421.96, 0, 0, 2195.47, 3421.96, 5617.43, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (97613, N'Natalia Y Castillo Villegas', N'Junior Administrative Analyst', 56813.75, 0, 0, 23206.44, 56813.75, 80020.19, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48079, N'Ceasar Garcia', N'Deputy Sheriff', 87677.95, 1035.25, 3699.04, 34871.11, 92412.24, 127283.35, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148357, N'Darrel A Lachapelle', N'Public Service Trainee', 320, 0, 0, 3.2, 320, 323.2, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71849, N'Shickola Ricks', N'Eligibility Worker', 1508.8, 0, 0, 125.89, 1508.8, 1634.69, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (65793, N'Linda Edwards', N'Transit Operator', 16724.27, 1738.13, 243.39, 9592.84, 18705.79, 28298.63, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72341, N'Reuben Reyes', N'Special Nurse', 531.94, 0, 36.64, 157.95, 568.58, 726.53, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (65175, N'Barry Hyun', N'Eligibility Worker', 22931.02, 0, 0, 12170.84, 22931.02, 35101.86, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (145323, N'Heather E Gutierres', N'Eligibility Worker', 6276.49, 0, 0, 62.78, 6276.49, 6339.27, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (106404, N'Carolyn E Robinson', N'Transit Operator', 5904, 0, 0, 2771.21, 5904, 8675.21, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (64637, N'Matthew Lu', N'Transit Operator', 25938.35, 435.95, 443.99, 14046.65, 26818.29, 40864.94, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (144555, N'Lawrence C Blakes Jr', N'Transit Operator', 4390.16, 1314.78, 9.08, 2848.42, 5714.02, 8562.44, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140998, N'Miguel J Gonzalez Jr', N'Transit Operator', 17505.51, 0, 57.7, 8358.89, 17563.21, 25922.1, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (142304, N'Tara A Amado', N'Transit Operator', 11672.8, 0, 46.16, 5552.79, 11718.96, 17271.75, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110444, N'Brighton M Leung', N'Public Svc Aide-Public Works', 104.9, 0, 2.46, 1.07, 107.36, 108.43, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (138094, N'Nicole J Lafata Shark', N'EMT/Paramedic/Firefighter', 40315.5, 0, 2418.93, 13642.43, 42734.43, 56376.86, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (142597, N'Ernest E Hayles', N'Firefighter', 11180, 0, 0, 4572.32, 11180, 15752.32, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109955, N'David A Fleming', N'Special Nurse', 618.19, 0, 24.72, 134.27, 642.91, 777.18, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109056, N'Melinda  Kuoch', N'Eligibility Worker', 1994, 0, 0, 445.06, 1994, 2439.06, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (102861, N'Jeanne M D''Arcy', N'Registered Nurse', 5119, 0, 22525.52, 1568.43, 27644.52, 29212.95, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109510, N'Iesha M Jones', N'Public Svc Aide-Public Works', 1542.97, 0, 0, 15.43, 1542.97, 1558.4, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71485, N'Clarence Walker', N'Public Svc Aide-Public Works', 2129.95, 0, 43.92, 201.85, 2173.87, 2375.72, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (105484, N'Michaela T Womack', N'Transit Operator', 7239.23, 177.59, 32.02, 4494.45, 7448.84, 11943.29, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (135721, N'Mary C Huston', N'Registered Nurse', 58997.59, 50.29, 1868.27, 16918.73, 60916.15, 77834.88, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (138726, N'Christina A Couch', N'EMT/Paramedic/Firefighter', 30732, 1446.58, 2370.77, 13848.34, 34549.35, 48397.69, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71342, N'Roy Hill', N'Public Svc Aide-Public Works', 2461.14, 0, 9.01, 213.86, 2470.15, 2684.01, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147588, N'Jessica H Lee', N'Special Nurse', 1278.2, 0, 0, 238.96, 1278.2, 1517.16, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (70927, N'Kennis Grant', N'Transit Operator', 0, 0, 106.86, 3511.8, 106.86, 3618.66, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69443, N'John Hunt', N'Transit Operator', 6150.2, 1171.18, 537.12, 634.77, 7858.5, 8493.27, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (49188, N'Richard Kendall', N'Deputy Sheriff', 77550.95, 470.78, 10965.66, 33357.41, 88987.39, 122344.8, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72441, N'Marcus Duty', N'Public Svc Aide-Public Works', 519.5, 0, 12.2, 46.49, 531.7, 578.19, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72129, N'Glenn Daniels', N'Public Svc Aide-Public Works', 1026.05, 0, 0, 112.75, 1026.05, 1138.8, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71886, N'David Ayers Jr', N'Public Svc Aide-Public Works', 1428.63, 0, 0, 131.48, 1428.63, 1560.11, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (138822, N'Neal K Rodil', N'EMT/Paramedic/Firefighter', 30732, 1351.53, 1480.38, 13838.47, 33563.91, 47402.38, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110421, N'Blesilda P Huypungco', N'Special Nurse', NULL, 0, 113.94, 24, 113.94, 137.94, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72498, N'Catheryn Williams', N'Special Nurse', 338.51, 0, 33.84, 102.19, 372.35, 474.54, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (139203, N'Merter Bozkurt', N'Transit Operator', 24987.15, 1725.24, 885.43, 15697.82, 27597.82, 43295.64, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72603, N'Connie Love-Miles', N'Special Nurse', 143.65, 0, 14.37, 174.21, 158.02, 332.23, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (84282, N'Jared F Cooper', N'EMT/Paramedic/Firefighter', 87205.86, 2826.74, 10520.93, 31800.92, 100553.53, 132354.45, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (71389, N'Alicia Brown', N'Public Svc Aide-Public Works', 2337.75, 0, 48.8, 210.77, 2386.55, 2597.32, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109715, N'Sen Cheong  Lai', N'Transit Operator', 729.44, 0, 30.32, 405.15, 759.76, 1164.91, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110275, N'Graciela M Arevalo', N'Special Nurse', 263.29, 0, 26.33, 60.77, 289.62, 350.39, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147814, N'Iris J Lett', N'Transit Operator', 756.92, 170.31, 0, 223.48, 927.23, 1150.71, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (142199, N'Tim C Ghigliazza', N'Transit Operator', 10305.1, 694.2, 121.82, 6700.23, 11121.12, 17821.35, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (148472, N'Jimmy Tang', N'Public Service Trainee', 182.58, 0, 0, 1.83, 182.58, 184.41, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48811, N'Aaron Schmidt', N'Deputy Sheriff', 76558.8, 13435.42, 1909.7, 32108.71, 91903.92, 124012.63, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147204, N'Mario Armbrister', N'Public Svc Aide-Public Works', 2180.13, 0, 47.64, 22.29, 2227.77, 2250.06, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109353, N'Elizabeth M Leahy', N'Firefighter', NULL, 0, 1886.38, 0, 1886.38, 1886.38, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110036, N'Carla R Greenblatt', N'Special Nurse', 494.55, 0, 49.45, 108.2, 544, 652.2, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (140786, N'Dhakir R Zaki', N'Transit Operator', 13976.1, 4093.11, 326.18, 9176.93, 18395.39, 27572.32, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147840, N'Alondra Correa Almanza', N'Public Service Trainee', 1074, 0, 32.64, 11.06, 1106.64, 1117.7, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48199, N'Otha Cotton', N'Deputy Sheriff', 87947.57, 501, 4056.2, 34352.07, 92504.77, 126856.84, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (39202, N'Lawrence Chan', N'Sergeant 3', 135977.76, 7718.7, 7733.28, 38259.83, 151429.74, 189689.57, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (63024, N'Ying Ying Hui', N'Registered Nurse', 39599.08, 1085.78, 1997.48, 17396.06, 42682.34, 60078.4, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (105463, N'Terri L Mathis', N'Transit Operator', 7611.73, 772.69, 60.12, 3579.36, 8444.54, 12023.9, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (139849, N'Sedrick M Mcarthur', N'Transit Operator', 18880.5, 7842.37, 250.28, 9910.61, 26973.15, 36883.76, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (136970, N'Karen M Gomez', N'Registered Nurse', 49186.88, 125.89, 575, 18126.1, 49887.77, 68013.87, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (48564, N'Thomas Ro', N'EMT/Paramedic/Firefighter', 74118.62, 15060.35, 7864.68, 28169.55, 97043.65, 125213.2, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (97623, N'Francis J Monsada', N'Junior Administrative Analyst', 53325.01, 1147.97, 0, 25475.22, 54472.98, 79948.2, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69338, N'Samer Bouri', N'Transit Operator', 5997.16, 0, 0, 2797.37, 5997.16, 8794.53, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (87033, N'Robert J Loberg', N'Deputy Sheriff', 83331.6, 4224.52, 1119.79, 30403.68, 88675.91, 119079.59, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (72081, N'John Donnelly', N'Special Nurse', 930.75, 0, 31.02, 270.55, 961.77, 1232.32, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110299, N'Silas D Moultrie Jr', N'Public Svc Aide-Public Works', 311.7, 0, 7.32, 3.19, 319.02, 322.21, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (130622, N'Dennis J Gerbino', N'IS Programmer Analyst', 67667.55, 0, 0, 29304.77, 67667.55, 96972.32, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (54798, N'Frankie Johnson', N'Senior Eligibility Worker', 68977.7, 0, 612.6, 31204.72, 69590.3, 100795.02, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (69063, N'Nina Davis', N'PS Aide Health Services', 8928.12, 0, 0, 766.22, 8928.12, 9694.34, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (70438, N'Pecola Jones', N'Public Svc Aide-Public Works', 4511.81, 0, 0, 460.53, 4511.81, 4972.34, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (88467, N'Grace  Lin', N'Estate Investigator', 82901.08, 0, 0, 30165.72, 82901.08, 113066.8, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (56140, N'Clark Bell', N'IS Programmer Analyst-Senior', 48945.1, 0, 23100.3, 23354.1, 72045.4, 95399.5, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (714, N'YEVA JOHNSON', N'SENIOR PHYSICIAN SPECIALIST', 177810.58, 0, 950, NULL, 178760.58, 178760.58, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (29865, N'LEA YAMAGATA', N'LIBRARY PAGE', 16863.33, 0, 201.09, NULL, 17064.42, 17064.42, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (147636, N'Russell Patrick Mangahas', N'Special Nurse', 0, 0, 1153.78, 277.75, 1153.78, 1431.53, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (110161, N'Patrick F Mcpartland', N'Public Service Trainee', 501.13, 0, 0, 5.01, 501.13, 506.14, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (47639, N'Patrick Crane', N'Deputy Sheriff', 84356.51, 5334.96, 5764.75, 34143.72, 95456.22, 129599.94, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (51908, N'Patrick Martinez', N'Estate Investigator', 77454, 0, 0, 33194.97, 77454, 110648.97, 2012, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (85769, N'Patrick T Truong', N'Deputy Sheriff', 86758.9, 877.32, 6484.64, 31360.09, 94120.86, 125480.95, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (115360, N'Patrick Kennedy', N'Sergeant 3', 124770.11, 4709.34, 8031.28, 40093.21, 137510.73, 177603.94, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (109179, N'Emilia C Patrick', N'Special Nurse', 1824.38, 0, 0, 373.71, 1824.38, 2198.09, 2013, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (125793, N'Patrick S Renshaw', N'EMT/Paramedic/Firefighter', 72637.09, 6033.4, 5105.38, 30691.14, 83775.87, 114467.01, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (133413, N'Emilia C Patrick', N'Registered Nurse', 65992.6, 0, 296.7, 21067.97, 66289.3, 87357.27, 2014, NULL, N'San Francisco', N'PT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (121116, N'Patrick T Truong', N'Deputy Sheriff', 90269, 4330.78, 7372.09, 34506.78, 101971.87, 136478.65, 2014, NULL, N'San Francisco', N'FT')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (84, N'EDWARD REISKIN', N'GENERAL MANAGER-METROPOLITAN TRANSIT AUTHORITY', 230827.12, 0, 0, NULL, 230827.12, 230827.12, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (1, N'NATHANIEL FORD', N'GENERAL MANAGER-METROPOLITAN TRANSIT AUTHORITY', 167411.18, 0, 400184.25, NULL, 567595.43, 567595.43, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (12, N'PATRICIA JACKSON', N'CAPTAIN III (POLICE DEPARTMENT)', 99722, 87082.62, 110804.3, NULL, 297608.92, 297608.92, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (371, N'TERESA BARRETT', N'CAPTAIN III (POLICE DEPARTMENT)', 188328.08, 0, 4586.42, NULL, 192914.5, 192914.5, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (62, N'ANNA BROWN', N'CAPTAIN III (POLICE DEPARTMENT)', 102571.24, 7437, 128543.64, NULL, 238551.88, 238551.88, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (304, N'DOUGLAS MCEACHERN', N'CAPTAIN III (POLICE DEPARTMENT)', 194566.01, 1109.1, 819.03, NULL, 196494.14, 196494.14, 2011, NULL, N'San Francisco', N'')
GO
INSERT [dbo].[sf_public_salaries] ([id], [employeename], [jobtitle], [basepay], [overtimepay], [otherpay], [benefits], [totalpay], [totalpaybenefits], [year], [notes], [agency], [status]) VALUES (367, N'JOHN LOFTUS', N'CAPTAIN III (POLICE DEPARTMENT)', 188341.62, 0, 4609.75, NULL, 192951.37, 192951.37, 2011, NULL, N'San Francisco', N'')
GO



Comments (0)
Questions List