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

COVID-19 Expenditures Report (Historical)

thut-5mdgCity Government20 columns
This dataset is made up of expenditure transactions incurred by City agencies and recorded to a “CV” or “CR” expense budget code in the City's Financial Management System (FMS). The dataset includes accounting entries such as automated accruals and journals. Dollar amounts are in actual dollars.
View on NYC Open Data↗

Quality

B88.5 / 100

From a 500-row sample across 20 columns.

completeness95/ 25% weight
consistency85/ 20% weight
accuracy94/ 20% weight
timeliness67/ 15% weight
usability95/ 20% weight

Related datasets

  • COVID-19 Loan/Grant Report (Historical)0.45
    joins onpub_dtagy_name
  • Position Schedule0.33
  • Community Boards Geographic Report0.32
    joins onpub_dt
  • Expense Budget-Debt Service Agency OTPS Detail0.30
    joins onpub_dt
  • New York City Tax Revenue Actuals0.30
    joins onpub_dt
  • New York City Personal Income Tax Collections By Component0.30

Sample rows

pub_dtagy_nameagy_codefiscal_yearu_a_codeu_a_descobj_codeobj_typeobj_descexp_typebcbc_desc
20221231Department of Health and Mental Hygiene8162020112DISEASE CONTROL - OTPS100OTPSSUPPLIES + MATERIALS - GENERALExpenseCV12SUPPLIES + MATERIALS - GENERAL
20221231

Columns

20 queryable · 20 profiled

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

FieldTypeDescriptionNullValues
pub_dtcategorical8-digit number for date of publication0%202312312023093020230630of 10
agy_nametextThe name of the City agency incurring the cost.0%Department of EducationDepartment of Health and…Department of Sanitation
agy_codetextUnique three-digit code representing each Agency in the City's Financial Management System (FMS).0%40816827
fiscal_yearcategoricalThe Fiscal Year (June - July) that the cost is associated with.0%

Query this from your own app

GET /api/datasets/thut-5mdg
GET /api/datasets/thut-5mdg/quality
GET /api/datasets/thut-5mdg/related
GET /api/columns?dataset=thut-5mdg
joins onpub_dt
  • Headcount Actuals By Funding Source0.30
    joins onpub_dt
  • Capital Project Detail Data - Milestones0.29
    • Department of Health and Mental Hygiene
    816
    2020
    112
    DISEASE CONTROL - OTPS
    451
    OTPS
    NON OVERNIGHT TRVL EXP-GENERAL
    Expense
    CV12
    NON OVERNIGHT TRVL EXP-GENERAL
    20221231Department of Health and Mental Hygiene8162020112DISEASE CONTROL - OTPS451OTPSNON OVERNIGHT TRVL EXP-GENERALExpenseCV12NON OVERNIGHT TRVL EXP-GENERAL
    20221231Department of Health and Mental Hygiene8162020112DISEASE CONTROL - OTPS110OTPSFOOD & FORAGE SUPPLIESExpenseCV12FOOD & FORAGE SUPPLIES
    20221231Department of Health and Mental Hygiene8162020112DISEASE CONTROL - OTPSNAOTPSSUPPLIES + MATERIALS - GENERALExpenseCV12SUPPLIES + MATERIALS - GENERAL
    20221231Office of Emergency Management1720202OTHER THAN PERSONAL SERVICESNAOTPSSUPPLIES + MATERIALS - GENERALExpenseCV02SUPPLIES + MATERIALS - GENERAL
    20221231Office of Emergency Management1720202OTHER THAN PERSONAL SERVICESNAOTPSSUPPLIES + MATERIALS - GENERALExpenseCV02SUPPLIES + MATERIALS - GENERAL
    20221231Office of Emergency Management1720202OTHER THAN PERSONAL SERVICESNAOTPSSUPPLIES + MATERIALS - GENERALExpenseCV02SUPPLIES + MATERIALS - GENERAL
    20221231Office of Emergency Management1720202OTHER THAN PERSONAL SERVICESNAOTPSSUPPLIES + MATERIALS - GENERALExpenseCV02SUPPLIES + MATERIALS - GENERAL
    20221231Office of Emergency Management1720202OTHER THAN PERSONAL SERVICESNAOTPSSUPPLIES + MATERIALS - GENERALExpenseCV02SUPPLIES + MATERIALS - GENERAL

    Showing 12 of 17 columns. All of them are listed below.

    2022
    2021
    2020
    of 5
    u_a_codetextHighest level measure of spending that has been authorized in the budget by the City Council for specific purposes,0%436102110
    u_a_desctextBrief description of the Unit of Appropriation0%SCHOOL FACILITIES - OTPSDISEASE CONTROL - PSWASTE DISPOSAL-OTPS
    obj_codetextObject Codes are part of the accounting structure on payment requests that represent the type of services that are being paid to a City agency's Vendor/Customer.0%1001101
    obj_typecategoricalIdentifies whether the cost is Personnel Service (PS) or Other Than Personnel Service (OTPS)0%OTPSPSof 2
    obj_desctextBrief description of the Object Code0%SUPPLIES + MATERIALS - G…FOOD & FORAGE SUPPLIESFULL YEAR POSITIONS
    exp_typecategoricalIdentifies whether the cost is an Expense or Capital cost.0%ExpenseCapitalof 2
    cap_idcategoricalFor a Capital cost, the unique ID for the associated Capital Project.72%NATABLETSCV19BUCOEof 7
    cap_id_desccategoricalBrief description of the project.72%NATABLETSCenters of Excellence: B…of 7
    bctextAgency created code allocating funds and associating revenue within a Unit of Appropriation. For COVID-19 related costs, all Budget Codes must start with "CV".0%CV36CR37CV03
    bc_desctextBrief description of the Budget Code0%SUPPLIES + MATERIALS - G…FOOD & FORAGE SUPPLIESFULL YEAR POSITIONS
    proj_fund_sourcetextThe expected revenue source to be used to cover these costs, including both Federal, State, and City sources.27%FEMAN/ACSLFRF
    vendortextThe legal entity or payee (if available) for the expenditure.22%SDI INCNEW YORK STATE INDUSTRIE…NEW YORK CITY DEPARTMENT…
    date_of_expdatetimeDate at which the expenditure is incurred0%2021-06-17T00:00:00.0002021-07-20T00:00:00.0002020-05-13T00:00:00.000
    doc_idtextUnique identifier for the expenditure document in FMS0%EFTDSB20200407801EFTDSB20200418591EFTDSB20200418592
    contract_idtextUnique identifier for the contract document in FMS44%CT106920201416456CT182720191424857CT107120201424350
    exp_amountfloatDollar amount transacted by the City within this expenditure0%159.00106.00212.00