Operating Actuals
About this dataset
Operating actuals by fiscal year
The Operating actuals show dollars spent throughout the City to fund operations and services. Rows in this dataset show actuals at the expense or revenue account level. Each row includes the corresponding department and fund type, but additional corresponding information is available in separate reference datasets. Read our explanation on how to join the reference datasets to the actuals datasets.
For the actuals that include dollars spent to build and upgrade City infrastructure, see the dataset for the Capital Improvement Projects (CIP) Actuals.
Get the data
Browse the table below for all files available for this dataset
Data Downloads
| File name | Download actions | File Format | File size |
|---|---|---|---|
| Operating Actuals | Download |
CSV |
65.90 MB |
View a data sample
Showing 1 transposed sample row. Download the full dataset or a view to get the data.
Data Sample
| Field | Sample Value |
|---|---|
| report_fy | 20 |
| fund_type | Other Funds |
| fund_number | 810000 |
| dept_name | Retirement |
| funds_center_number | 1213000021 |
| account | Transit Pass Subsidy |
| account_number | 512112 |
Understand the data
Each field in the data is defined in the table below. Use this information to inform usage of the data.
Download dictionaryData Dictionary
| Field | Description | Possible_values |
|---|---|---|
| amount | Amount spent | |
| fund_type | Groups funds by general purpose | |
| fund_number | Uniquely identifies the fund. Capital funds are preceded by the letter C in the data. | |
| dept_name | Department name | |
| funds_center_number | Unique identifier for a funds center. A funds center represents the lowest level of organizational detail within a department and can represent a team, function, or facility within a department. Department group, name, division, and section represent groupings of funds centers. | |
| account | Describes the smallest subset of an account group, typically defined by a specific function, service, or item | |
| account_number | Uniquely identifies an expense or revenue account. Revenue accounts begin with a 4 while expense accounts begin with a 5. |
- PublisherDepartment of Finance
- Last Updated May 22, 2026
- Update Frequency As needed
- Date Issued Oct 15, 2018
- Available Formats .CSV
- License View License
Data & Analytics
data@sandiego.gov