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

Expense Actuals By Funding Source

nrik-v7wsCity Government6 columns
Funding of actual spending that appears in the Mayor's Message Agency Financial tables. Dollars are in Thousands. This dataset is updated annually.
View on NYC Open Data↗

Quality

B87.5 / 100

From a 500-row sample across 6 columns.

completeness100/ 25% weight
consistency67/ 20% weight
accuracy96/ 20% weight
timeliness87/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Headcount Actuals By Funding Source0.75
    joins onpub_dtfisc_yrfnding+2
  • Additional Costs Allocation0.51
    joins onpub_dtfisc_yragy_cd+1
  • New York City Tax Revenue Actuals0.48
    joins onpub_dtfisc_yramt
  • CUNY Community College Expenditures By Source0.47
    joins onpub_dtfisc_yramt
  • New York City Personal Income Tax Collections By Component0.46

Sample rows

pub_dtfisc_yragy_cdagy_nmfndingamt
202404242023035Research LibrariesC32989
202404242023035Research LibrariesOC0
202404242023035Research LibrariesS0
202404242023

Columns

6 queryable · 6 profiled

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

FieldTypeDescriptionNullValues
pub_dtcategorical8-digit number for date of publication0%202505012023042620240424of 6
fisc_yrcategoricalFiscal Year0%202020232022of 6
agy_cdtext3-digit code which identifies an agency (e.g. 056 is the Police Department).0%126260801
agy_nmtextDescriptive name associated with the 3-digit code (e.g. "Police Department, Fire Department").0%New York Public LibraryPolice Department

Query this from your own app

GET /api/datasets/nrik-v7ws
GET /api/datasets/nrik-v7ws/quality
GET /api/datasets/nrik-v7ws/related
GET /api/columns?dataset=nrik-v7ws
joins onpub_dtfisc_yramt
  • Financial Plan Statements - Revenue0.40
    joins onpub_dtfisc_yr
  • Expense Budget-Debt Service Agency OTPS Detail0.39
    joins onpub_dtfisc_yragy_cd+1
  • Total City, Transit and Housing Police Force Headcount0.39
    joins onpub_dtfisc_yr
    • 035
    Research Libraries
    F
    0
    202404242023035Research LibrariesCD0
    202404242023035Research LibrariesIFA0
    202404242023035Research LibrariesIC0
    202404242023037New York Public LibraryC171044
    202404242023037New York Public LibraryOC198
    202404242023037New York Public LibraryS0
    Department of Informatio…
    fndingcategoricalType of expenditure by funding (C: City, CD: Community Development; IFA: Inter Fund Agreement; OC: Other Categorical; F: Federal; S:State; IC: Intra-City)0%ICSCof 7
    amtintegerTotal dollars spent by funding0%011225432025