Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Total City, Transit and Housing Police Force Headcount

wpnz-dpupCity Government5 columns
Yearly average City, Transit, and Housing uniform headcount updated yearly with the Mayor's Message.
View on NYC Open Data↗

Quality

C76.0 / 100

From a 16-row sample across 5 columns.

completeness100/ 25% weight
consistency70/ 20% weight
accuracy100/ 20% weight
timeliness0/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • New York City Personal Income Tax Collections By Component0.44
    joins onfisc_yrpub_dt
  • DOE Funding Sources0.43
    joins onfisc_yractl_frctpub_dt
  • Headcount Actuals By Funding Source0.42
    joins onfisc_yrpub_dt
  • CUNY Community College Expenditures By Source0.41
    joins onfisc_yrpub_dt
  • New York City Tax Revenue Actuals0.41
    joins onfisc_yr

Sample rows

pub_dtfisc_yractl_frcttypavg_hc
202104262005ACTUALTOTAL36054
202104262006ACTUALTOTAL36285
202104262007ACTUALTOTAL36091
202104262008ACTUALTOTAL35754

Columns

5 queryable · 5 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
pub_dttext8-digit number for date of publication0%20210426of 1
fisc_yrcategoricalFiscal year0%201320142016of 16
actl_frcttextActual yearly average uniform headcount0%ACTUALof 1
typtextYearly average City, Transit, and Housing uniform headcount0%TOTALof 1
avg_hccategoricalAverage yearly uniform headcount

Query this from your own app

GET /api/datasets/wpnz-dpup
GET /api/datasets/wpnz-dpup/quality
GET /api/datasets/wpnz-dpup/related
GET /api/columns?dataset=wpnz-dpup
pub_dt
  • Hurricane Sandy Expense and Capital Estimate by Agency0.41
    joins onfisc_yrpub_dt
  • New York City Settlement Payments0.39
    joins onpub_dt
  • New York City Employment Forecast0.38
    joins onpub_dt
    • 20210426
    2009
    ACTUAL
    TOTAL
    35929
    202104262010ACTUALTOTAL35161
    202104262011ACTUALTOTAL34831
    202104262012ACTUALTOTAL34873
    202104262013ACTUALTOTAL35047
    202104262014ACTUALTOTAL35095
    0%
    360913509535161of 16