Description
This dataset includes all expenditures by agency, with additional data including funding source, vendor name, and amount invoiced. The dates for this dataset are for Fiscal Year 2024. A Fiscal Year starts July 1 and runs through June 30 of the given fiscal year. For example, Fiscal Year 2024 would include July 1, 2023 through June 30, 2024.
Data Dictionary:
Field Name | Description |
Fiscal_Year | fiscal year of the date of payment |
Invoice_date | Date listed on the invoice received |
Invoice_Number | Unique identifier used on the invoice |
Invoice_Amount | Amount invoiced by the supplier |
Payee | Recipient of payment amount |
Payment_Date | Date of transaction or date check printed |
Payment_Number | Transaction ID or check number |
Extended_Amount | dollar amount paid to payee |
Expenditure_Type | budget type (Operating or Capital) |
Fund | funding source for the expense |
Financing_Source | identifies the funding source (ex. debt funded, forfeiture funds, agency receipts, etc.); a subset of capital expenses |
Agency | agency or department who purchased product or service |
Cost Center | unit within a department the expenses are charged; a subset of the agency |
Expenditure_Category | broad grouping of expenditures |
Spend_Category | subcategory of the broad grouping of expenditures |
Project | optional tag used to identify related expenses |
Program | optional tag used to identify related expenses |
Grant | optional tag used to identify funding from external resources |
Region | council district |
Resources
| Name | Format | Description | Link |
|---|---|---|---|
| CSV | CSV | Open resource | |
| Excel | XLS | Open resource | |
| Feature Collection | Text | Open resource | |
| File Geodatabase | ZIP | Open resource | |
| GeoJSON | GeoJSON | Open resource | |
| GeoPackage | Unknown | Open resource | |
| KML | KML | Open resource | |
| Shapefile | ZIP | Open resource | |
| SQLite Geodatabase | Unknown | Open resource | |
| ArcGIS Hub Dataset | HTML | Open resource | |
| ArcGIS GeoService | ArcGIS GeoServices REST API | Open resource |