Capital Improvements Program (CIP) Actuals by fiscal year
About this dataset
Actual expenditures for the City's Capital Improvements Program by fiscal year.
Get the data
Browse the table below for all files available for this dataset
Data Downloads
| File name | Download actions | File Format | File size |
|---|---|---|---|
| CIP Actuals | Download |
CSV |
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 |
|---|---|
| project_number_parent | AJA00001 |
| project_number_child | B00362 |
| report_fy | 11 |
| fund_type | Sewer Funds |
| fund_number | C700000 |
| asset_owning_dept | Public Utilities |
| project_name | Sewer Main Replacements |
| account | Overhead Billed |
| account_number | 512115 |
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. | |
| asset_owning_dept | Indicates the City department that owns the project asset | |
| project_name | Indicates the specific purpose of a project | |
| project_number | Uniquely identifies a Capital Improvement Project. The letter denotes the type of project, and the first two numbers represent the fiscal year the project began. | |
| 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 8, 2026
- Update Frequency As needed
- Date Issued Oct 15, 2018
- Available Formats .CSV
- License View License
Data & Analytics
data@sandiego.gov