Business Tax Certificates

City Treasurer Updated Aug 14, 2026 Daily

About this dataset

All active and inactive business tax certificates issued since 1990. Businesses that operate within San Diego must get a business tax certificate issued by the City Treasurer.

Get the data

Browse the table below for all files available for this dataset

Data Downloads

File name	Download actions	File Format	File size
Active certificates	Download Copy URL	CSV	18.10 MB
Inactive certificates issued since 2015	Download Copy URL	CSV	31.40 MB
Inactive certificates issued 2010 to 2014	Download Copy URL	CSV	24.08 MB
Inactive certificates issued 2000 to 2009	Download Copy URL	CSV	47.25 MB
Inactive certificates issued 1990 to 1999	Download Copy URL	CSV	37.99 MB
Inactive certificates issued before 1990	Download Copy URL	CSV	33.34 MB

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_key	2009028689.0
account_status	Active
date_account_creation	2009-10-05 11:26:42
date_cert_expiration	2026-12-31 23:59:59
date_cert_effective	2026-01-01 23:59:59
business_owner_name	JORGE BORQUEZ
ownership_type	SOLE
date_business_start	2006-01-01 00:00:00
dba_name	JORGE BORQUEZ
naics_sector	54
naics_code	54199
naics_description	ALL OTH PROF, SCIENTIFIC & TECHNICAL SERVICES
address_no	628
address_pd	E
address_road	SAN YSIDRO
address_sfx	BLVD
address_no_fraction	1/2
address_city	SAN YSIDRO
address_state	CA
address_zip	92173-3113
address_suite	905
address_pmb_box
address_po_box
bid	26.0
council_district	8.0
lat	32.548583
lng	-117.035072

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
Field	Description	Possible_values
account_key	Primary Key
account_status	Whether the account is active or inactive	Active; Inactive
date_account_creation	Date when the business tax account was created.
date_cert_expiration	Date when the business tax certificate expires.
date_cert_effective	Date when the business tax certificate becomes effective.
business_owner_name	Business Owner
ownership_type	Ownership Type	Corp-Coporation,H-W-Married, LLC-Limited Liability Co (LLC), LP-Limited Partnership (LP), NO/PRF-Non-profit entity, Partnr-partnership, SCORP-S Corporation, Sole-Sole Propriethorship, Trust-Trust
date_business_start	Date when the business began operations.
dba_name	Doing Business As name
naics_sector	NAICS (North American Industry Classification System) sector	https://www.census.gov/cgi-bin/sssd/naics/naicsrch?chart=2012
naics_code	NAICS code
naics_description	NAICS code description
address_no	Street address number of the business location.
address_pd	Directional prefix of the business address.
address_road	Street name of the business location.
address_sfx	Street type or suffix of the business address.
address_no_fraction	Fractional component of the business address number.
address_city	City where the business is located.
address_state	State where the business is located.
address_zip	ZIP code of the business location.
address_suite	Suite or unit number of the business location.
address_pmb_box	Private mailbox number associated with the business address.
address_po_box	Post office box number associated with the business address.
bid	Business Improvement District, if business is located within one	https://www.sandiego.gov/sites/default/files/0313_bid_map_2018_final_landscape.pdf
council_district	City council district where the business is located.
lat	Latitude coordinate of the business location.
lng	Longitude coordinate of the business location.

PublisherCity Treasurer
Last Updated Aug 14, 2026
Update Frequency Daily
Date Issued May 9, 2016
Available Formats .CSV
License View License

Local businesses Taxes and fees Finances

Data & Analytics

data@sandiego.gov