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

Hurricane Sandy Expense and Capital Estimate by Agency

h5f7-3btzCity Government6 columns
This dataset contains the funding amount for Hurricane Sandy expenses, Capital Repair, and Capital Mitigation expenditures by agency. The reporting unit for expenses is listed in whole dollars. This information is reviewed and updated quarterly.
View on NYC Open Data↗

Quality

C72.6 / 100

From a 23-row sample across 6 columns.

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

Related datasets

  • CDBG-DR Program Categories0.45
    joins onfisc_yrpub_dt
  • Expense Actuals By Funding Source0.44
    joins onfisc_yragy_nmpub_dt
  • Headcount Actuals By Funding Source0.42
    joins onfisc_yragy_nmpub_dt
  • Total City, Transit and Housing Police Force Headcount0.41
    joins onfisc_yrpub_dt
  • DOE Funding Sources0.40
    joins onfisc_yr

Sample rows

pub_dtfisc_yragy_nmexpcap_reprcap_mgtn
202004162021Health and Hospitals Corporation122866046.78983458701.05756873320.48
202004162021Department of Parks and Recreation94473680.30999999774866378.5500002245143459.75
202004162021Department of Environmental Protection616903698.5263527391.59000003294856303.48

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 publication (e. g. 20200416)0%2020041620210430of 2
fisc_yrtext4-digit year to identify a period of twelve months that begins July 1 and ends the following June 300%2021of 1
agy_nmcategoricalIdentifies the Related New York City Agency0%Police DepartmentOther City AgenciesDepartment of Education …of 13
expfloatDisbursement of Funding0%202164028.73000002

Query this from your own app

GET /api/datasets/h5f7-3btz
GET /api/datasets/h5f7-3btz/quality
GET /api/datasets/h5f7-3btz/related
GET /api/columns?dataset=h5f7-3btz
pub_dt
  • CUNY Community College Expenditures By Source0.40
    joins onfisc_yrpub_dt
  • Additional Costs Allocation0.37
    joins onfisc_yragy_nmpub_dt
  • Debt Issuance by Issuer0.37
    joins onpub_dt
  • 202004162021Department of Education / School Construction Authority94888194.50999999544386854.6400001191622407.91000003
    202004162021Department of Transportation10499502.94127404685.259999994604212.07
    202004162021Police Department202164028.7300000280800282.0000000111322063.38
    202004162021Fire Department25471567.4199616872.100000024047178.14
    202004162021Department of Sanitation177123593.2399999529051893.511006132.97
    202004162021Department of Cultural Affairs1169096.64121830590.7600000269266315.22
    202004162021Department of Corrections3375761.1270479189.3614985383
    202164029
    3375761.12
    cap_reprfloatFunding Used to Provide Emergency Capital Repairs0%207934941758658144129190017.09000002
    cap_mgtnfloatFunding Used on Projects to Reduce Future Disaster Costs and Losses0%1458092002245023095120006979