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

Roles

rolesrelease v0.7.1CC0 1.0

About

Supervisor terms (contiguous years served, from the roster).

Where it comes from
The list of members of the Board of Supervisors on Wikipedia, and the roll calls for supervisors missing from it.
How it was read
Each supervisor's years on the Board, joined into terms.
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
roles
Rows
318
Columns
6
Parquet
roles.parquet, < 0.1 MB
Version
v0.7.1, 21 October 2026
Licence
CC0 1.0. Sources keep their own rights.

Rows

Rows by source

ValueRowsShare
votes in the Journal roll calls (v0.6.1)24175.8%
Wikipedia: Members of the San Francisco Board of Supervisors7724.2%

Method and accuracy

Each supervisor's years on the Board, joined into terms.

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
person_idVARCHARnononeas isThe person (see persons).
Can be empty no · Privacy none · Public copy as is
roleVARCHARyesnoneas issupervisor.
Values supervisor
Can be empty yes · Privacy none · Public copy as is
org_idVARCHARnononeas isThe body (see orgs).
Values qipu:sf/org/board-of-supervisors
Can be empty no · Privacy none · Public copy as is
fromINTEGERyesnoneas isFirst year of an unbroken run of years served.
Can be empty yes · Privacy none · Public copy as is
toINTEGERyesnoneas isLast year of that run.
Can be empty yes · Privacy none · Public copy as is
sourceVARCHARyesnoneas isWikipedia: Members of the San Francisco Board of Supervisors, or printed in the Journal roll calls only.
Values Wikipedia: Members of the San Francisco Board of Supervisors, printed in the Journal roll calls only, votes in the Journal roll calls (v0.6.1)
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

person_idroleorg_idfromtosource
person/sean-elsberndsupervisororg/board-of-supervisors2,0052,012Wikipedia: Members of the San Francisco Board of Supervisors
person/ed-jewsupervisororg/board-of-supervisors2,0072,007Wikipedia: Members of the San Francisco Board of Supervisors
person/katy-tangsupervisororg/board-of-supervisors2,0132,018Wikipedia: Members of the San Francisco Board of Supervisors
person/eugene-schmitzsupervisororg/board-of-supervisors1,9181,925votes in the Journal roll calls (v0.6.1)
person/p-j-mcmurraysupervisororg/board-of-supervisors1,9461,952votes in the Journal roll calls (v0.6.1)
person/john-i-nolansupervisororg/board-of-supervisors1,9111,911votes in the Journal roll calls (v0.6.1)
person/john-j-sullivansupervisororg/board-of-supervisors1,9441,953votes in the Journal roll calls (v0.6.1)
person/james-l-gallaghersupervisororg/board-of-supervisors1,9051,907votes in the Journal roll calls (v0.6.1)

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

Download

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

SQL

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