Qipudata
San Francisco · v0.7.1
qipu data›San Francisco›Datasets›x_business_locations

Registered business locations

x_business_locationsrelease v0.7.1CC0 1.0

About

One registered business location (DataSF g8m3-pdis, PDDL) resolved to today's EAS address and block, with start and end years. Owner names are not carried; the business name is shown when it reads as a firm name and withheld under the privacy rule when it reads as a person's. Not from the Internet Archive (DataSF open data, PDDL).

How far to trust it
The release passed its automatic checks before it was published (what is checked). A hand check by the editor of qipu data is under way: 36 of 38 items checked so far were right, on votes, money, places and the map. A row says what the record states; the scanned page is the authority. Details
Licence
CC0 1.0: use it for anything, no permission needed. The scans and other sources keep their own rights.
Version
v0.7.1, published 21 October 2026. A published release is never changed; corrections come as a new release.
Technical details
Table
x_business_locations
Rows
248,990
Columns
15
Parquet
x_business_locations.parquet, 6.5 MB
Version
v0.7.1, 21 October 2026
Licence
CC0 1.0. Sources keep their own rights.

Rows

Rows by group

ValueRowsShare
(empty)219,33288.1%
food10,3074.1%
shop9,1143.7%
service7,2942.9%
leisure1,6210.7%
lodging1,0200.4%
worship3020.1%

Method and accuracy

No accuracy measure for this table yet.

The release passed its automatic checks before it was published (what is checked). A hand check by the editor of qipu data is under way: 36 of 38 items checked so far were right, on votes, money, places and the map. A row says what the record states; the scanned page is the authority.

Methodology · Accuracy

Columns 15

ColumnTypeCan be emptyPrivacyPublic copyDescription
record_idVARCHARnononeas isDataSF uniqueid (record link: data.sf.gov/resource/g8m3-pdis.json?uniqueid=...).
Can be empty no · Privacy none · Public copy as is
blockVARCHARyesnoneas isAssessor block.
Can be empty yes · Privacy none · Public copy as is
address_place_idVARCHARnononeas isEAS address place.
Can be empty no · Privacy none · Public copy as is
addressVARCHARyesnoneas isAddress as in EAS.
Can be empty yes · Privacy none · Public copy as is
address_exactBOOLEANyesnoneas isTrue when the door number exists today.
Can be empty yes · Privacy none · Public copy as is
start_yearBIGINTyesnoneas isLocation start year.
Can be empty yes · Privacy none · Public copy as is
start_is_register_floorBOOLEANyesnoneas isTrue when the start is the register floor date 1968-10-01 (read: by 1968).
Can be empty yes · Privacy none · Public copy as is
end_yearBIGINTyesnoneas isLocation end year (null: still open).
Can be empty yes · Privacy none · Public copy as is
administratively_closedBOOLEANyesnoneas isClosed by the Tax Collector rather than by the business.
Can be empty yes · Privacy none · Public copy as is
naicsVARCHARyesnoneas isSelf-reported NAICS code.
Can be empty yes · Privacy none · Public copy as is
naics_titleVARCHARyescatalogue textas isNAICS 2022 title.
Can be empty yes · Privacy catalogue text · Public copy as is
kindVARCHARyesnoneas isPlain kind used on the map (a laundromat, a bar ...), null when not a storefront.
Can be empty yes · Privacy none · Public copy as is
groupVARCHARyesnoneas isfood, shop, service, lodging, leisure, worship.
Values food, leisure, lodging, service, shop, worship
Can be empty yes · Privacy none · Public copy as is
business_nameVARCHARyesa person's nameofficials and organisations shown; private people withheld under the embargoThe DBA name as registered. A firm name is always shown; a name that reads as a person's is withheld for 75 years after the location start year (the privacy rule), so almost all personal DBA names are withheld. Owner names are never carried.
Can be empty yes · Privacy a person's name · Public copy officials and organisations shown; private people withheld under the embargo
hoodVARCHARyesnoneas isAnalysis neighborhood (DataSF).
Can be empty yes · Privacy none · Public copy as is

Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.

Preview

record_idblockaddress_place_idaddressaddress_exactstart_yearstart_is_register_floorend_year
0146610-04-001-0146610qipu:sf/place/block/1226place/address/eas-2977691890 PAGE STtrue2006false—
0152856-01-001-0152856qipu:sf/place/block/2381place/address/eas-3366123431 TARAVAL STtrue1985false2015
0310528-01-001-0310528qipu:sf/place/block/3636place/address/eas-3637891195 VALENCIA STfalse1997false2017
0326114-03-001-0326114qipu:sf/place/block/3755place/address/eas-493226343 08TH STfalse2014false2022
0349267-06-001-0349267qipu:sf/place/block/2406place/address/eas-4855372411 19TH AVEfalse2008false2022
0360987-05-001-0360987qipu:sf/place/block/0193place/address/eas-458256703 JACKSON STfalse2013false2012
0369495-01-005-0369495qipu:sf/place/block/2695place/address/eas-344386556 CASTRO STtrue2002false2014
0378380-01-001-0378380qipu:sf/place/block/5720place/address/eas-383434233 RICHLAND AVEtrue2004false2018

8 of 15 columns shown. Eight rows sampled at build time. Hover a shortened value for all of it.

Download

FormatFileSize
Parquetx_business_locations.parquet ↗6.5 MB
SQLite (all tables)qipu_sf.db ↗6.44 GB

SQL

SELECT * FROM x_business_locations LIMIT 100

Run in the SQL console (DuckDB in the browser, over the Parquet file).

Python

import duckdb duckdb.sql("SELECT * FROM 'https://tiles.qipu.org/data/releases/v0.7.1/parquet/x_business_locations.parquet' LIMIT 5").show()