NYPD Borough Staffing

Precinct staffing summed by patrol borough since January 2023: officers assigned, field training, DV squads, detective squads, and time on the job.

Precincts Patrol boroughs

John Hall · Precinct staffing · Crime data vintages · Related essay: Does the NYPD Need to Hire More Cops? ·

viewof sel = Inputs.select(unitList, {
  label: "Patrol borough",
  format: d => d.menu,
  value: unitList.find(d => d.code === initPb) ?? unitList[0]
})

data = FileAttachment("data/precinct_staffing.json").json()
pbOrder = ["PBMS", "PBMN", "PBBX", "PBBS", "PBBN", "PBQS", "PBQN", "PBSI"]
initPb = (new URL(location).searchParams.get("pb") || "ALL").toUpperCase()
parseM = d3.utcParse("%Y-%m")
fmtM = d3.utcFormat("%b %Y")
fmtN = d3.format(",.0f")
fmtD = d3.format("+,.0f")
fmtPct = d3.format("+.1%")
fmtR = d3.format(".1f")
asOf = d3.utcFormat("%B %-d, %Y")(d3.utcParse("%Y-%m-%d")(data.snapshot_date))
change = (a, b) => !b ? "—" : a === b ? "±0" : `${fmtD(a - b)} (${fmtPct((a - b) / b)})`
// Every unit — all boroughs, one borough, one precinct — gets the same shape.
prep = u => ({
  ...u,
  series: u.series.map(d => ({...d, date: parseM(d.m)})),
  ds_series: u.ds_series.map(d => ({...d, date: parseM(d.m)}))
})
allUnit = {
  const cw = data.citywide;
  return prep({
    code: "ALL", short: "All patrol boroughs", label: "All patrol boroughs",
    menu: "All patrol boroughs", memberNoun: "patrol borough",
    series: cw.series, ds_series: cw.ds_series, now: cw.now, yos: cw.yos,
    sgt: cw.sgt, ds_sgt: cw.ds_sgt,
    members: pbOrder.map(c => prep({...data.patrol_boroughs[c], name: data.patrol_boroughs[c].short}))
  });
}
pbUnits = pbOrder.map(c => {
  const b = data.patrol_boroughs[c];
  return prep({
    ...b, menu: `${b.code} · ${b.short}`, memberNoun: "precinct",
    members: b.precincts.map(p => {
      const q = data.precincts[String(p).padStart(3, "0")];
      return prep({...q, name: q.label});
    })
  });
})
unitList = [allUnit, ...pbUnits]
u = sel
isAll = u.code === "ALL"
series = u.series
first = series[0]
last = series[series.length - 1]
latestMM = last.m.slice(5)
sameMonth = series.filter(d => d.m.slice(5) === latestMM)
priorSame = sameMonth.slice(0, -1)
cwSeries = allUnit.series
cwFirst = cwSeries[0]
cwLast = cwSeries[cwSeries.length - 1]
ds = u.ds_series
dsFirst = ds[0]
dsLast = ds[ds.length - 1]
dsSameMonth = ds.filter(d => d.m.slice(5) === latestMM)
dsPriorSame = dsSameMonth.slice(0, -1)
cwDsLast = allUnit.ds_series[allUnit.ds_series.length - 1]
cwDsFirst = allUnit.ds_series[0]
dvStart = series.find(d => d.dv > 0) ?? last
dvSeries = series.filter(d => d.m >= dvStart.m)
cwDvStart = cwSeries.find(d => d.dv > 0) ?? cwLast
// Change for one member (borough or precinct) from a given month to the latest.
at = (arr, m) => arr.find(d => d.m === m)
chgAt = (mem, key, baseM) => {
  const b = at(mem.series, baseM), l = mem.series[mem.series.length - 1];
  return b && b[key] ? change(l[key], b[key]) : "—";
}
dsChgAt = (mem, baseM) => {
  const b = at(mem.ds_series, baseM), l = mem.ds_series[mem.ds_series.length - 1];
  return b && b.n && l ? change(l.n, b.n) : "—";
}
memLast = mem => mem.series[mem.series.length - 1]
memDsLast = mem => mem.ds_series[mem.ds_series.length - 1] ?? {n: 0}
memHref = mem => isAll ? `staffing-boroughs.html?pb=${mem.code}` : `staffing.html?pct=${mem.pct}`
syncUrl = { const url = new URL(location); if (isAll) url.searchParams.delete("pb"); else url.searchParams.set("pb", u.code); history.replaceState(null, "", url); }

html`<div class="kpis four">
  <div class="kpi"><div class="v">${fmtN(last.total)}</div><div class="l">officers, ${fmtM(last.date)}<br><span class="meta"><strong>${change(last.total, first.total)}</strong> since ${fmtM(first.date)}${isAll ? ` · ${u.members.reduce((s, m) => s + m.precincts.length, 0)} precincts` : ` · all patrol boroughs ${change(cwLast.total, cwFirst.total)}`}</span></div></div>
  <div class="kpi"><div class="v">${fmtN(dsLast.n)}</div><div class="l">precinct detective squads<br><span class="meta"><strong>${change(dsLast.n, dsFirst.n)}</strong> since ${fmtM(dsFirst.date)}${isAll ? "" : ` · all patrol boroughs ${change(cwDsLast.n, cwDsFirst.n)}`}</span></div></div>
  <div class="kpi"><div class="v">${fmtR(u.yos.median)}<span class="u">yrs</span></div><div class="l">median time on the job, pooled<br><span class="meta">${isAll ? "" : `all precincts ${fmtR(allUnit.yos.median)} · `}department ${fmtR(data.citywide.dept_yos.median)}</span></div></div>
  <div class="kpi"><div class="v">${fmtN(last.dv)}</div><div class="l">DV squad officers<br><span class="meta">precinct squads since ${fmtM(dvStart.date)}${isAll ? "" : ` · all patrol boroughs ${fmtN(cwLast.dv)}`}</span></div></div>
</div>`

What is counted. Patrol borough totals include precincts, their field training units, and domestic violence squads. They exclude borough specialty units, task forces, and borough administration. Precinct detective squads are totaled separately. Compare the same month across years. Monthly shifts mostly reflect roster timing.

Officers assigned

html`<table class="same-month">
  <caption>${u.short} · same month, each year</caption>
  <thead><tr><th></th>${sameMonth.map(d => html`<th>${fmtM(d.date)}</th>`)}</tr></thead>
  <tbody>
    <tr><th>Officers</th>${sameMonth.map(d => html`<td>${fmtN(d.total)}</td>`)}</tr>
    <tr><th>vs. prior year</th>${sameMonth.map((d, i) => html`<td class="meta">${i ? change(d.total, sameMonth[i - 1].total) : "—"}</td>`)}</tr>
  </tbody>
</table>`

stacked = series.flatMap(d => [
  {date: d.date, component: "Precinct", n: d.core},
  {date: d.date, component: "Field Training Unit", n: d.ftu},
  {date: d.date, component: "DV Squad", n: d.dv}
])
Plot.plot({
  width,
  height: 330,
  marginLeft: 50,
  style: {fontFamily: "inherit", fontSize: "13px", background: "transparent", color: "#29251f"},
  x: {label: null},
  y: {label: "Officers assigned", grid: true, tickFormat: ",.0f"},
  color: {
    domain: ["Precinct", "Field Training Unit", "DV Squad"],
    range: ["#7a2e2e", "#bc8563", "#cbb489"],
    legend: true
  },
  marks: [
    Plot.areaY(stacked, {x: "date", y: "n", fill: "component", order: null}),
    Plot.lineY(series, {x: "date", y: "total", stroke: "#29251f", strokeWidth: 1}),
    Plot.ruleY([0]),
    Plot.tip(series, Plot.pointerX({
      x: "date", y: "total",
      title: d => `${fmtM(d.date)}\nTotal ${fmtN(d.total)}\nPrecinct ${fmtN(d.core)} · FTU ${fmtN(d.ftu)} · DV squad ${fmtN(d.dv)}`
    }))
  ]
})

Officers assigned to the precincts of each month. Field training units and DV squads are stacked inside the total; the thin line is the total itself.

By

html`<div class="table-scroll"><table class="rank-table members">
  <caption>${fmtM(last.date)} roster, with the change from earlier months · precinct detective squads are separate commands, counted in their own table below · ${isAll ? "click a borough for its precincts" : "click a precinct for its own page"}</caption>
  <thead><tr>
    <th>${isAll ? "Patrol borough" : "Precinct"}</th>
    <th class="total">Officers</th>
    <th>vs. ${fmtM(first.date)}</th>
    ${priorSame.map(d => html`<th>vs. ${fmtM(d.date)}</th>`)}
    <th>FTU</th>
    <th>DV squad</th>
    <th>Median yrs</th>
  </tr></thead>
  <tbody>
    ${u.members.map(m => {
      const l = memLast(m);
      return html`<tr>
        <th><a href="${memHref(m)}">${m.name}</a>${isAll ? html`<span class="code">${m.code}</span>` : ""}</th>
        <td class="total">${fmtN(l.total)}</td>
        <td class="meta">${chgAt(m, "total", first.m)}</td>
        ${priorSame.map(d => html`<td class="meta">${chgAt(m, "total", d.m)}</td>`)}
        <td>${l.ftu ? fmtN(l.ftu) : html`<span class="zero">–</span>`}</td>
        <td>${l.dv ? fmtN(l.dv) : html`<span class="zero">–</span>`}</td>
        <td>${fmtR(m.yos.median)}</td>
      </tr>`;
    })}
  </tbody>
  <tfoot><tr>
    <th>${u.short}</th>
    <td class="total">${fmtN(last.total)}</td>
    <td class="meta">${change(last.total, first.total)}</td>
    ${priorSame.map(d => html`<td class="meta">${change(last.total, d.total)}</td>`)}
    <td>${fmtN(last.ftu)}</td>
    <td>${fmtN(last.dv)}</td>
    <td>${fmtR(u.yos.median)}</td>
  </tr></tfoot>
</table></div>`

“vs.” columns give the change from that month to . A dash means the command did not exist in the base month: DV squads were carved out of precinct rosters in October 2025, and the 116th Precinct opened in December 2024. Median years on the job pool the officers counted in that row — precinct, field training unit, and DV squad — and exclude the detective squads, whose investigators are far more senior.

viewof facetMode = Inputs.radio(["Officers", "Index, Jan 2023 = 100"], {label: "Show", value: "Officers"})

facetCols = u.members.length <= 4 ? u.members.length : (u.members.length === 9 ? 3 : 4)
facetRows = Math.ceil(u.members.length / facetCols)
facetLabels = u.members.map((m, i) => ({name: m.name, col: i % facetCols, row: Math.floor(i / facetCols)}))
facetData = u.members.flatMap((m, i) => {
  const base = (at(m.series, first.m) ?? m.series[0]).total;
  return m.series.map(d => ({date: d.date, m: d.m, total: d.total, index: 100 * d.total / base,
    name: m.name, col: i % facetCols, row: Math.floor(i / facetCols)}));
})
indexMode = facetMode !== "Officers"
Plot.plot({
  width,
  height: 150 * facetRows + 50,
  marginLeft: 44,
  marginRight: 10,
  insetTop: 16,
  style: {fontFamily: "inherit", fontSize: "12px", background: "transparent", color: "#29251f"},
  fx: {label: null, axis: null, padding: 0.12},
  fy: {label: null, axis: null, padding: 0.18},
  x: {label: null, ticks: 3, tickFormat: "%Y"},
  y: indexMode
    ? {label: "Index (Jan 2023 = 100)", grid: true}
    : {label: "Officers", grid: true, domain: [0, d3.max(facetData, d => d.total) * 1.12], tickFormat: ",.0f"},
  marks: [
    Plot.ruleY([indexMode ? 100 : 0], {stroke: "#a89a7b"}),
    Plot.lineY(facetData, {x: "date", y: indexMode ? "index" : "total", fx: "col", fy: "row", stroke: "#7a2e2e", strokeWidth: 1.3}),
    Plot.text(facetLabels, {fx: "col", fy: "row", frameAnchor: "top-left", dx: 4, dy: 2, text: "name", fontWeight: 600, fill: "#29251f"}),
    Plot.tip(facetData, Plot.pointerX({
      x: "date", y: indexMode ? "index" : "total", fx: "col", fy: "row",
      title: d => `${d.name}\n${fmtM(d.date)}\n${fmtN(d.total)} officers · index ${fmtR(d.index)}`
    }))
  ]
})

Officers assigned, by , on one shared scale. The index view divides each month by January 2023 (or the first month on record), so the panels read as percent change.

Detective squads

html`<table class="same-month">
  <caption>${u.short} · precinct detective squads · same month, each year</caption>
  <thead><tr><th></th>${dsSameMonth.map(d => html`<th>${fmtM(d.date)}</th>`)}</tr></thead>
  <tbody>
    <tr><th>Investigators</th>${dsSameMonth.map(d => html`<td>${fmtN(d.n)}</td>`)}</tr>
    <tr><th>vs. prior year</th>${dsSameMonth.map((d, i) => html`<td class="meta">${i ? change(d.n, dsSameMonth[i - 1].n) : "—"}</td>`)}</tr>
    <tr><th>vs. ${fmtM(dsFirst.date)}</th>${dsSameMonth.map(d => html`<td class="meta">${d.m === dsFirst.m ? "—" : change(d.n, dsFirst.n)}</td>`)}</tr>
  </tbody>
</table>`

Plot.plot({
  width,
  height: 200,
  marginLeft: 50,
  style: {fontFamily: "inherit", fontSize: "13px", background: "transparent", color: "#29251f"},
  x: {label: null},
  y: {label: "Detective squads", grid: true, domain: [0, d3.max(ds, d => d.n) * 1.15], tickFormat: ",.0f"},
  marks: [
    Plot.areaY(ds, {x: "date", y: "n", fill: "#7a2e2e", fillOpacity: 0.12}),
    Plot.lineY(ds, {x: "date", y: "n", stroke: "#7a2e2e", strokeWidth: 1.5}),
    Plot.ruleY([0]),
    Plot.tip(ds, Plot.pointerX({x: "date", y: "n", title: d => `${fmtM(d.date)}\n${fmtN(d.n)} in precinct squads`}))
  ]
})

Investigators assigned to the precinct detective squads of — separate commands, not counted in the officer total above. Borough detective units and specialty squads are not included.

html`<div class="table-scroll"><table class="rank-table members">
  <caption>Precinct detective squads · ${fmtM(dsLast.date)} roster, with the change from earlier months · ${isAll ? "click a borough for its precincts" : "click a precinct for its own page"}</caption>
  <thead><tr>
    <th>${isAll ? "Patrol borough" : "Precinct"}</th>
    <th class="total">Investigators</th>
    <th>vs. ${fmtM(dsFirst.date)}</th>
    ${dsPriorSame.map(d => html`<th>vs. ${fmtM(d.date)}</th>`)}
    <th>Share of officers</th>
  </tr></thead>
  <tbody>
    ${u.members.map(m => {
      const dl = memDsLast(m), l = memLast(m);
      return html`<tr>
        <th><a href="${memHref(m)}">${m.name}</a>${isAll ? html`<span class="code">${m.code}</span>` : ""}</th>
        <td class="total">${fmtN(dl.n)}</td>
        <td class="meta">${dsChgAt(m, dsFirst.m)}</td>
        ${dsPriorSame.map(d => html`<td class="meta">${dsChgAt(m, d.m)}</td>`)}
        <td class="meta">${l.total ? d3.format(".1%")(dl.n / l.total) : "—"}</td>
      </tr>`;
    })}
  </tbody>
  <tfoot><tr>
    <th>${u.short}</th>
    <td class="total">${fmtN(dsLast.n)}</td>
    <td class="meta">${change(dsLast.n, dsFirst.n)}</td>
    ${dsPriorSame.map(d => html`<td class="meta">${change(dsLast.n, d.n)}</td>`)}
    <td class="meta">${d3.format(".1%")(dsLast.n / last.total)}</td>
  </tr></tfoot>
</table></div>`

“vs.” columns give the change from that month to . Share of officers is the squad against the precinct officers counted above, which do not include it.

Time on the job

yosRows = u.members.map(m => ({who: m.name, med: m.yos.median, n: m.yos.n}))
Plot.plot({
  width,
  height: 24 * yosRows.length + 60,
  marginLeft: 130,
  style: {fontFamily: "inherit", fontSize: "13px", background: "transparent", color: "#29251f"},
  x: {label: "Median years since appointment", grid: true, domain: [0, Math.max(10, d3.max(yosRows, d => d.med) * 1.2)]},
  y: {label: null, domain: yosRows.map(d => d.who)},
  marks: [
    Plot.barX(yosRows, {x: "med", y: "who", fill: "#7a2e2e", fillOpacity: 0.8}),
    Plot.text(yosRows, {x: "med", y: "who", text: d => fmtR(d.med), dx: 6, textAnchor: "start"}),
    Plot.ruleX([u.yos.median], {stroke: "#29251f", strokeDasharray: "3,3"}),
    Plot.ruleX([0]),
    Plot.tip(yosRows, Plot.pointer({x: "med", y: "who", title: d => `${d.who}\nmedian ${fmtR(d.med)} yrs · ${fmtN(d.n)} officers`}))
  ]
})

Bars: median time on the job by , pooling every officer counted above — precinct, field training unit, and DV squad — and excluding the precinct detective squads. Dashed line: pooled, yrs. All precincts pooled: yrs. Whole department, including headquarters and specialized commands: yrs. Roster on .

Domestic violence squads

html`<table class="same-month">
  <caption>${u.short} · precinct DV squads, pooled · same month, each year</caption>
  <thead><tr><th></th>${sameMonth.map(d => html`<th>${fmtM(d.date)}</th>`)}</tr></thead>
  <tbody>
    <tr><th>Officers</th>${sameMonth.map(d => html`<td>${d.dv ? fmtN(d.dv) : html`<span class="zero">–</span>`}</td>`)}</tr>
    <tr><th>vs. prior year</th>${sameMonth.map((d, i) => html`<td class="meta">${i && sameMonth[i - 1].dv ? change(d.dv, sameMonth[i - 1].dv) : "—"}</td>`)}</tr>
    <tr><th>vs. ${fmtM(dvStart.date)}</th>${sameMonth.map(d => html`<td class="meta">${d.m <= dvStart.m ? "—" : change(d.dv, dvStart.dv)}</td>`)}</tr>
  </tbody>
</table>`

Plot.plot({
  width,
  height: 200,
  marginLeft: 50,
  style: {fontFamily: "inherit", fontSize: "13px", background: "transparent", color: "#29251f"},
  x: {label: null},
  y: {label: "DV squad officers", grid: true, domain: [0, d3.max(dvSeries, d => d.dv) * 1.15], tickFormat: ",.0f"},
  marks: [
    Plot.areaY(dvSeries, {x: "date", y: "dv", fill: "#cbb489", fillOpacity: 0.3}),
    Plot.lineY(dvSeries, {x: "date", y: "dv", stroke: "#7a2e2e", strokeWidth: 1.5}),
    Plot.ruleY([0]),
    Plot.tip(dvSeries, Plot.pointerX({x: "date", y: "dv", title: d => `${fmtM(d.date)}\n${fmtN(d.dv)} in precinct DV squads`}))
  ]
})

Officers in the precinct domestic violence squads of , from , when the squads were carved out of precinct rosters. Counted in the officer total. The Domestic Violence Unit’s own commands above the precinct level are not included, so there is no 2023 baseline for this series.

Definitions. Assigned means listed under the command in the public records and confirmed as still active. A precinct’s total is the precinct proper plus its Field Training Unit (precinct-named since August 2025) and its Domestic Violence Squad (carved out of precinct rosters in October 2025); the Times Square FTU is split 52/48 between the Midtown precincts. A patrol borough is the sum of its precincts on that definition. Not included: borough specialty units and task forces, the patrol borough’s administrative command, borough detective units, and seasonal details carried under a precinct’s name. Detective squads are separate commands and are never in the officer total. Years on the job run from appointment date and are pooled across each row’s precincts.

Continuity. The series is continuous from January 2023; each month’s count is taken at month end. Precinct-level detail, rank tables, and supervision ratios are on the precinct staffing dashboard. The latest month is as of .

Hall, J. (2026). NYPD Borough Staffing Dashboard. https://johnjhallresearch.com/staffing-boroughs. Accessed [date].

Data as of · page built · series to