Accounts in the City's annual budget

Department of Finance Updated May 8, 2026 As needed

About this dataset

Additional information about expense and revenue accounts in the City's annual budget. Use this to supplement the Operating and CIP budget datasets.

Get the data

Browse the table below for all files available for this dataset

Data Downloads

File name Download actions File Format File size
Accounts hierarchy 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
account_classCapital Expenditures
account_groupCapital Expenditures
accountAuC - CIP Projects
account_number560020

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
account_typeIndicates the purpose of the account. Typically, expense accounts are used to purchase goods and services, while revenue accounts are used to receive funds from taxes and fees.
account_classDescribes the general classification of an account as a subset of expenses or revenues
account_groupDescribes a subset of an account class, typically defined by a general function, service, or category of items
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