Persons
personsrelease v0.7.1CC0 1.0
About
People resolved in v1: the members of the Board of Supervisors (official roster: the Wikipedia list, with Wikidata ids), plus four supervisors printed in the Journals but missing from that list (journal_only).
- Where it comes from
- The list of members of the San Francisco Board of Supervisors on Wikipedia, with their Wikidata ids, plus a few supervisors printed in the Journals but missing from that list.
- How it was read
- Taken from the list as it stands; roster_source says which rows come from the Journals instead.
- 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
- persons
- Rows
- 294
- Columns
- 11
- Parquet
- persons.parquet, < 0.1 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by roster_source
| Value | Rows | Share | |
|---|---|---|---|
| wikipedia | 288 | 98.0% | |
| journal_only | 6 | 2.0% |
Method and accuracy
Taken from the list as it stands; roster_source says which rows come from the Journals instead.
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.
Columns 11
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| person_id | VARCHAR | no | none | as is | qipu:sf/person/<slug>. |
| display_name | VARCHAR | yes | a public official | as is | Name as on the roster. |
| born | VARCHAR | yes | none | as is | Empty in v0.4. |
| died | VARCHAR | yes | none | as is | Empty in v0.4. |
| wikidata | VARCHAR | yes | none | as is | Wikidata id. |
| is_public_official | BOOLEAN | yes | none | as is | True on every row: all are supervisors. |
| wikipedia | VARCHAR | yes | a public official | as is | Title of the English Wikipedia article. |
| roster_source | VARCHAR | yes | none | as is | wikipedia (the Wikipedia list of SF supervisors) or journal_only (a surname printed in 100+ roll calls that the list lacks).Values journal_only, wikipedia |
| first_year | BIGINT | yes | none | as is | First year served (journal_only: first year the name is printed). |
| last_year | BIGINT | yes | none | as is | Last year served (journal_only: last year the name is printed). |
| aka | VARCHAR[] | yes | a public official | as is | Other names on the roster. |
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_id | display_name | born | died | wikidata | is_public_official | wikipedia | roster_source |
|---|---|---|---|---|---|---|---|
| person/bernard-faymonville | Bernard Faymonville | — | — | — | true | Bernard Faymonville | wikipedia |
| person/charle…lbert-murdock | Charles Albert Murdock | — | — | Q5075016 | true | Charles Albert Murdock | wikipedia |
| person/j-j-o-neill | J.J. O'Neill | — | — | — | true | J.J. O'Neill | wikipedia |
| person/cornelius-j-deasy | Cornelius J. Deasy | — | — | — | true | Cornelius J. Deasy | wikipedia |
| person/franck-r-havenner | Franck R. Havenner | — | — | Q1442456 | true | Franck R. Havenner | wikipedia |
| person/harold-dobbs | Harold Dobbs | — | — | Q15458154 | true | Harold Dobbs | wikipedia |
| person/gordon-mar | Gordon Mar | — | — | Q60736815 | true | Gordon Mar | wikipedia |
| person/stephen-sherrill | Stephen Sherrill | — | — | Q131467292 | true | Stephen Sherrill | wikipedia |
8 of 11 columns shown. Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | persons.parquet ↗ | < 0.1 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
Run in the SQL console (DuckDB in the browser, over the Parquet file).