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

Privacy rules

privacy_rulesrelease v0.7.1CC0 1.0

About

Names of private people are public after N years: sf 75, van 92.

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
privacy_rules
Rows
2 (San Francisco 1; Vancouver 1)
Columns
6
Parquet
privacy_rules.parquet, < 0.1 MB
Version
v0.7.1, 21 October 2026
Licence
CC0 1.0. Sources keep their own rights.

Rows

Rows by basis

ValueRowsShare
US: names of private people shown publicly only for records older than ~75 years (census-style); public officials and companies always; everything kept, flagged150.0%
Canada: 92 years (census release rule); public officials and companies always; everything kept, flagged150.0%

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 6

ColumnTypeCan be emptyPrivacyPublic copyDescription
cityVARCHARnononeas issf or van.
Values sf, van
Can be empty no · Privacy none · Public copy as is
applies_toVARCHARyesnoneas isprivate_person.
Values private_person
Can be empty yes · Privacy none · Public copy as is
embargo_yearsINTEGERyesnoneas isYears after a record's date before a private person's name is shown: 75 (SF), 92 (Vancouver).
Can be empty yes · Privacy none · Public copy as is
basisVARCHARyesnoneas isThe rule and its reason, in words.
Values Canada: 92 years (census release rule); public officials and companies always; everything kept, flagged, US: names of private people shown publicly only for records older than ~75 years (census-style); public officials and companies always; everything kept, flagged
Can be empty yes · Privacy none · Public copy as is
as_of_yearINTEGERyesnoneas isThe year the embargo is counted to, pinned per release (qipu_data/cutoff.py AS_OF_YEAR), never today's date: nothing moves by itself on 1 January.
Can be empty yes · Privacy none · Public copy as is
last_open_yearINTEGERyesnoneas isThe last fully open year: as_of_year minus embargo_years (SF 1951, Vancouver 1934). Every qipu product (data, site, search, agent tools, map) uses this one number.
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

cityapplies_toembargo_yearsbasisas_of_yearlast_open_year
sfprivate_person75US: names of private people shown publicly only for record…20261951
vanprivate_person92Canada: 92 years (census release rule); public officials a…20261934

Eight rows sampled at build time. Hover a shortened value for all of it.

Download

FormatFileSize
Parquetprivacy_rules.parquet ↗< 0.1 MB
SQLite (all tables)qipu_sf.db ↗6.44 GB

SQL

SELECT * FROM privacy_rules 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/privacy_rules.parquet' LIMIT 5").show()