Rows
48
Employee
DAVID JOHNSON
This page groups payroll rows by normalized employee name slug for v1. The source data does not guarantee perfect entity resolution across years, so interpret cross-year aggregation carefully.
This employee slug spans 10 agencys and 13 titles.
Agencies
10
Titles
13
Total Compensation
$4,279,885.96
Agencies Worked For
Titles Held
Fiscal Year 2017
4 records, 4 agencys, 4 titles
Year total: $228,222.81
| Agency | Title | Status | Base Salary | Regular Gross | OT Hours | OT Paid | Other Pay | Total |
|---|---|---|---|---|---|---|---|---|
| BOARD OF ELECTION POLL WORKERS | ELECTION WORKER | ACTIVE | $1.00 | $305.00 | 0.00 | $0.00 | $0.00 | $305.00 |
| DEPARTMENT OF CORRECTION | CORRECTION OFFICER | ACTIVE | $82,808.00 | $141,953.44 | 632.50 | $39,454.30 | $21,003.88 | $202,411.62 |
| DEPARTMENT OF FINANCE | ADMINISTRATIVE ACCOUNTANT | ACTIVE | $85,000.00 | $8,150.68 | 0.00 | $0.00 | $0.00 | $8,150.68 |
| HRA/DEPT OF SOCIAL SERVICES | CASEWORKER | ACTIVE | $38,617.00 | $15,842.49 | 0.00 | $0.00 | $1,513.02 | $17,355.51 |
Fiscal Year 2016
4 records, 2 agencys, 3 titles
Year total: $181,457.67
| Agency | Title | Status | Base Salary | Regular Gross | OT Hours | OT Paid | Other Pay | Total |
|---|---|---|---|---|---|---|---|---|
| DEPARTMENT OF CORRECTION | CORRECTION OFFICER | ACTIVE | $58,960.00 | $59,777.09 | 662.23 | $29,126.89 | $5,359.72 | $94,263.70 |
| DEPARTMENT OF CORRECTION | CORRECTION OFFICER | ACTIVE | $58,960.00 | $59,775.59 | 400.25 | $17,856.61 | $5,358.91 | $82,991.11 |
| POLICE DEPARTMENT | POLICE OFFICER | CEASED | $78,026.00 | $1,659.82 | 0.00 | $62.16 | $327.88 | $2,049.86 |
| POLICE DEPARTMENT | SCHOOL SAFETY AGENT | CEASED | $36,033.00 | $2,153.00 | 0.00 | $0.00 | $0.00 | $2,153.00 |
Fiscal Year 2015
5 records, 4 agencys, 4 titles
Year total: $184,563.62
| Agency | Title | Status | Base Salary | Regular Gross | OT Hours | OT Paid | Other Pay | Total |
|---|---|---|---|---|---|---|---|---|
| ADMIN FOR CHILDREN'S SVCS | CHILD WELFARE SPECIALIST SUPERVISOR | CEASED | $57,547.00 | $332.86 | 0.00 | $0.00 | $0.00 | $332.86 |
| DEPARTMENT OF CORRECTION | CORRECTION OFFICER | ACTIVE | $51,643.00 | $49,318.75 | 374.50 | $13,043.29 | $4,990.95 | $67,352.99 |
| DEPARTMENT OF CORRECTION | CORRECTION OFFICER | ACTIVE | $51,643.00 | $49,281.61 | 289.50 | $10,239.74 | $4,984.77 | $64,506.12 |
| DEPARTMENT OF EDUCATION ADMIN | SUBSTANCE ABUSE PREVENTION & INTERVENTION SPECIALIST | ACTIVE | $54,611.00 | $30,186.45 | 0.00 | $0.00 | $1,431.41 | $31,617.86 |
| HRA/DEPT OF SOCIAL SERVICES | ELIGIBILITY SPECIALIST | CEASED | $33,284.00 | $20,753.79 | 0.00 | $0.00 | $0.00 | $20,753.79 |
Fiscal Year 2014
3 records, 3 agencys, 3 titles
Year total: $184,874.69
| Agency | Title | Status | Base Salary | Regular Gross | OT Hours | OT Paid | Other Pay | Total |
|---|---|---|---|---|---|---|---|---|
| DEPARTMENT OF CORRECTION | CORRECTION OFFICER | ACTIVE | $46,785.00 | $90,270.50 | 281.00 | $9,616.95 | $9,475.49 | $109,362.94 |
| DEPARTMENT OF EDUCATION ADMIN | SUBSTANCE ABUSE PREVENTION & INTERVENTION SPECIALIST | ACTIVE | $52,186.00 | $70,335.52 | 0.00 | $0.00 | $1,935.61 | $72,271.13 |
| Police Department | SCHOOL SAFETY AGENT | CEASED | $35,323.00 | $0.00 | 0.00 | $0.00 | $3,240.62 | $3,240.62 |
Source and Caveats
Source for v1: NYC Open Data dataset k397-673e. Raw source rows are preserved as imported.
OT hours before FY2023 are not directly comparable to FY2023 and later because the source methodology changed. Some names, agencies, and other fields may be redacted in the source and are displayed as provided.