cincinnati-oh-gov/city-of-cincinnati-vendor-payments-qrj9-83t8

  • budget
  • expenses
  • financial
  • fiscal year
  • money
  • + 2

City of Cincinnati Vendor Payments

City of Cincinnati Vendor Payments

Data Description: This data set contains all records of payments made to vendors by the City of Cincinnati from fiscal year 2014 to present. It includes information such as the department who paid for the service, the reason for payment, and vendor name.

Data Creation: This data is pulled directly from the City's financial software; which centralizes all department financial transactions city wide.

Data Created By: The Cincinnati Financial System (CFS)

Refresh Frequency: Weekly

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this data set.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
FUND_CODEfund_codefund_codeText
RECORD_DATErecord_daterecord_dateCalendar date
FUND_DESCfund_descfund_descText
FISCAL_YEARfiscal_yearfiscal_yearNumber
EXP_ACCT_CAT_DESCexp_acct_cat_descexp_acct_cat_descText
DEPT_CODEdept_codedept_codeText
AMOUNTamountamountNumber
CHECK_NOcheck_nocheck_noText
TRANS_IDtrans_idtrans_idText
DEPT_DESCdept_descdept_descText
EXP_ACCT_CATexp_acct_catexp_acct_catText
TRANS_LINE_NOtrans_line_notrans_line_noNumber
ACCT_PERIODacct_periodacct_periodNumber
VENDOR_NAMEvendor_namevendor_nameText