Capital Improvements Program (CIP) Actuals project to date

Department of Finance Updated May 8, 2026 As needed

About this dataset

Actual expenditures for the City's Capital Improvements Program by project.

Get the data

Browse the table below for all files available for this dataset

Data Downloads

File name Download actions File Format File size
Project-to-date CIP Actuals Download

Copy URL

CSV

View a data sample

Showing 1 transposed sample row. Download the full dataset or a view to get the data.

Data Sample

Data preview - first row of dataset transposed
Field Sample Value
project_number_parentABK00001
project_number_childB00144
fiscal_year2011
report_fy14
fund_typeOther Funding
fund_numberCD10000
asset_owning_deptPublic Utilities
project_nameDams and Reservoirs
accountUndistributed Budget
account_number512117

Understand the data

Each field in the data is defined in the table below. Use this information to inform usage of the data.

Download dictionary

Data Dictionary

Data dictionary - field definitions for this dataset
fielddescriptionpossible_values
amountAmount spent
fund_typeGroups funds by general purpose
fund_numberUniquely identifies the fund. Capital funds are preceded by the letter C in the data.
asset_owning_deptIndicates the City department that owns the project asset
project_nameIndicates the specific purpose of a project
project_numberUniquely identifies a Capital Improvement Project. The letter denotes the type of project, and the first two numbers represent the fiscal year the project began.
accountDescribes the smallest subset of an account group, typically defined by a specific function, service, or item
account_numberUniquely identifies an expense or revenue account. Revenue accounts begin with a 4 while expense accounts begin with a 5.

Data & Analytics

data@sandiego.gov