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

Asset Management Executive Summary - State of Good Repair Needs (Expense)

8sea-35e7City Government9 columns
This dataset contains information for a select number of agencies. It shows the estimated spending necessary to preserve the structural integrity for each of their fixed assets which meet the criteria for expense eligibility. The numbers can be summarized by Agency to match the Asset Management Executive Summary publication. Amounts are rounded to the nearest thousand. The dataset is updated once a year.
View on NYC Open Data↗

Quality

B84.1 / 100

From a 500-row sample across 9 columns.

completeness97/ 25% weight
consistency61/ 20% weight
accuracy93/ 20% weight
timeliness68/ 15% weight
usability95/ 20% weight

Related datasets

  • Asset Management Executive Summary - State of Good Repair Needs (Capital Eligible)0.85
    joins onpub_datediscpln_sysagy_name+1
  • Asset Management Executive Summary - Agency Assets by Project Type and Class0.57
    joins onpub_date
  • State of Good Repair Needs0.49
  • Expense Financial Plan - Qtr10.39
  • Preliminary Mayor's Management Report Spending and Budget0.37
  • Mayor's Management Report Spending and Budget0.35

Sample rows

pub_dateagy_numagy_namediscpln_sysfy1fy1_amtfy2_amtfy3_amtfy4_amt
20191211035NEW YORK PUBLIC LIBRARYExterior Architecture20212096000171000115000191000
20191211035NEW YORK PUBLIC LIBRARYInterior Architecture20213095000334000729000

Columns

9 queryable · 9 profiled

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

FieldTypeDescriptionNullValues
pub_datecategoricalThe date on which the report was published0%202105032019121120211201of 7
agy_numtextNumeric identifier of the owning Agency0%841846057
agy_nametextName identifying the owning Agency0%DEPARTMENT OF TRANSPORTA…DEPT. OF PARKS & RECREAT…FIRE DEPARTMENT
discpln_systextDescriptive identifier of structural element or system0%Interior Architecture

Query this from your own app

GET /api/datasets/8sea-35e7
GET /api/datasets/8sea-35e7/quality
GET /api/datasets/8sea-35e7/related
GET /api/columns?dataset=8sea-35e7
New York City Personal Income Tax Collections By Component0.32
  • Revenue Budget & Financial Plan--Qtr10.31
    • 2504000
    20191211035NEW YORK PUBLIC LIBRARYElectrical2021630000885000437000244000
    20191211035NEW YORK PUBLIC LIBRARYMechanical202111910006930001107000573000
    20191211035NEW YORK PUBLIC LIBRARYSite Enclosure2021150000000
    20191211035NEW YORK PUBLIC LIBRARYSite Pavements2021224000000
    20191211035NEW YORK PUBLIC LIBRARYElevators/Escalators2021314000314000314000314000
    20191211038BROOKLYN PUBLIC LIBRARYExterior Architecture2021119600016300016000219000
    20191211038BROOKLYN PUBLIC LIBRARYInterior Architecture20211193000120000108000107000
    20191211038BROOKLYN PUBLIC LIBRARYElectrical202136400015200076000742000
    Electrical
    Mechanical
    fy1categoricalFiscal Year 10%202220212023of 7
    fy1_amtintegerCumulative need in Year One of Fiscal Plan1%04200037000
    fy2_amtintegerCumulative need in Year Two of Fiscal Plan3%060001000
    fy3_amtintegerCumulative need in Year Three of Fiscal Plan3%040001000
    fy4_amtintegerCumulative need in Year Four of Fiscal Plan3%010006000