Cincinnati Municipal Vendor Payments from Fiscal Year 2014

Records of payments made to vendors by the City of Cincinnati from fiscal year 2014 onward. The dataset is generated by the Cincinnati Financial System (CFS) and includes details such as department, payment reason, and vendor name. Data is updated weekly and undergoes processing including address verification and geocoding.

Use Cases

• Analyzing spending trends by department (DEPT_DESC) and fiscal year (FISCAL_YEAR) using the AMOUNT field.
• Identifying top vendors (VENDOR_NAME) and expenditure categories (EXP_ACCT_CAT_DESC) for budget oversight.
• Tracking payment transactions over time using RECORD_DATE and ACCT_PERIOD for fiscal auditing.
• Investigating fund allocation (FUND_DESC) and associated expense account categories (EXP_ACCT_CAT).

Strengths

• Continuous weekly updates ensure current data.
• Includes a detailed data dictionary for column definitions.
• Data undergoes processing for accuracy, including address verification and geocoding.

Limitations

• Unknown total row count and dataset size.
• Potential for incomplete historical coverage prior to fiscal year 2014.
• Lacks direct sample data for preliminary inspection of data quality.

Provenance

Source

Cincinnati Financial System (CFS), published by data.cincinnati-oh.gov.

Collection Method

Pulled directly from the city's centralized financial software.

Time Range

Fiscal year 2014 to present.

Freshness

Weekly

Geography

City of Cincinnati, Ohio, USA.