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

Capital Plan Funding Source

4utb-pisgCity Government10 columns
This dataset describes the type and amounts of capital funding sources in each plan. This includes debt issuances through financing entities and other cash sources. This dataset is updated four times per year after publication of the First Quarter, Preliminary, Executive and Adopted Financial Plan, usually in November, January, April and June respectively.
View on NYC Open Data↗

Quality

B87.2 / 100

From a 188-row sample across 10 columns.

completeness98/ 25% weight
consistency60/ 20% weight
accuracy100/ 20% weight
timeliness92/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • Quarterly Borrowing Schedule0.67
    joins onpub_dt
  • Projection of Cash Source and Use0.58
  • Financial Plan Baseline & Initiatives By Funding0.48
    joins onfy5_amtfy4_amtfy2_amt+2
  • Financial Plan Statements - Personal Service Expenditures0.41
    joins onpub_dt
  • Financial Plan Statements - Obligation0.40
    joins onpub_dt
  • Financial Plan Statements - Revenue

Sample rows

pub_dtcap_src_catcap_srcyrs_rptedfy1_yrfy1_amtfy2_amtfy3_amtfy4_amtfy5_amt
20200630Long TermGO Bonds5202037803820458054205760
20200630Long TermTFA-FTS5202035763820

Columns

10 queryable · 10 profiled

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

FieldTypeDescriptionNullValues
pub_dtinteger8-digit number for date of publication0%202001162019112220240630
cap_src_catcategoricalCategory describing the type of capital funding source0%Long TermReimbursable CaptialFinancial Planof 4
cap_srccategoricalFurther description of the capital fund source0%Other Non-City FundsFinancial Plan AdjGO Bondsof 8
yrs_rptedcategoricalNumber of Plan Year data reported in that line of the dataset0%

Query this from your own app

GET /api/datasets/4utb-pisg
GET /api/datasets/4utb-pisg/quality
GET /api/datasets/4utb-pisg/related
GET /api/columns?dataset=4utb-pisg
0.38
joins onpub_dt
  • Financial Plan Statements - Revenue and Obligation Forecast0.38
    joins onpub_dt
  • Expense Budget Funding - All Source0.37
    • 4580
    5420
    5760
    20200630Long TermWater Authority5202023671689171116491692
    20200630Reimbursable CaptialTFA-Building Aid Revenue Bonds52020250394178155201
    20200630Reimbursable CaptialOther State Funded Financing5202000000
    20200630Reimbursable CaptialChange in Non-City Cash52020-11-200000
    20200630Reimbursable CaptialOther Non-City Funds52020662121913601023798
    20200630Financial PlanFinancial Plan Adj52020-888341302303326
    20200416Long TermGO Bonds5202037803820458054205760
    20200416Long TermTFA-FTS5202036003820458054205760
    5
    4
    of 2
    fy1_yrcategoricalIdentifies the first fiscal year of the dataset which is the same fiscal year of the publication date0%202120202022of 7
    fy1_amtintegerRepresents the amount, in millions, to be displayed for the current/first fiscal year of the plan period.0%06900200
    fy2_amtintegerRepresents the amount, in millions, to be displayed for the second fiscal year of the plan period.0%048203820
    fy3_amtintegerRepresents the amount, in millions, to be displayed for the third fiscal year of the plan period.0%085605140
    fy4_amtintegerRepresents the amount, in millions, to be displayed for the fourth fiscal year of the plan period.0%060507316
    fy5_amtintegerRepresents the amount, in millions, to be displayed for the fifth fiscal year of the plan period.22%08465980