Release v0.7.1
The published state of qipu data for San Francisco. A release never changes after it is published; corrections ship as a new version.
- Version
- v0.7.1
- Published
- 21 October 2026
- Licence
- CC0 1.0 for the facts; the scans keep their own rights
- Coverage
- San Francisco Board of Supervisors, 1906–2026
- Files
- Download page · manifest.json (sha256 of every file)
- Changes
- Changelog
- Earlier releases
- Withdrawn; they are no longer published.
Coverage
By decade
| 1900s | 15,954 | |
| 1910s | 45,542 | |
| 1920s | 56,718 | |
| 1930s | 37,092 | |
| 1940s | 36,102 | |
| 1950s | 34,604 | |
| 1960s | 25,376 | |
| 1970s | 40,724 | |
| 1980s | 43,713 | |
| 1990s | 45,288 | |
| 2000s | 79,733 | |
| 2010s | 46,766 | |
| 2020s | 31,580 |
By decade
| 1900s | 3,261 | |
| 1910s | 13,810 | |
| 1920s | 14,770 | |
| 1930s | 9,932 | |
| 1940s | 22,176 | |
| 1950s | 27,676 | |
| 1960s | 18,906 | |
| 1970s | 23,547 | |
| 1980s | 22,266 | |
| 1990s | 14,779 |
Headline numbers 29
Each is a query on the published tables; run any of them in the SQL console.
| What | Count | SQL |
|---|---|---|
facts (the claims table) | 8,367,105 | SELECT count(*) FROM claims |
| share of facts citing an archive.org item (%) | 86.3 | SELECT round(100.0 * count(*) FILTER (WHERE source_id NOT LIKE 'web:%') / count(*), 1) FROM claims |
votes (in the claims table) | 4,724,389 | SELECT count(*) FROM claims WHERE property = 'voted' |
| yes votes | 4,014,743 | SELECT count(*) FROM claims WHERE property = 'voted' AND value_text = 'yes' |
| no votes | 148,174 | SELECT count(*) FROM claims WHERE property = 'voted' AND value_text = 'no' |
| absent | 560,569 | SELECT count(*) FROM claims WHERE property = 'voted' AND value_text = 'absent' |
| printed roll calls | 171,123 | SELECT count(*) FROM x_roll_calls |
| decisions (printed items; v0.7 counting rule: one per decision_group, however many passes read it) | 539,192 | SELECT count(DISTINCT coalesce(decision_group, decision_id)) FROM decisions |
| readings of decisions (rows from several extraction passes) | 718,093 | SELECT count(*) FROM decisions |
| decision rows from the main reading (one per printed item) | 344,936 | SELECT count(*) FROM decisions WHERE origin = 'v2' |
| officials | 294 | SELECT count(*) FROM persons |
| persons with a Wikidata id | 122 | SELECT count(*) FROM persons WHERE wikidata IS NOT NULL |
| places with stable ids | 470,596 | SELECT count(*) FROM places |
| dated geometries | 459,992 | SELECT count(*) FROM place_geometries |
| facts placed at an address, parcel or building | 1,543,612 | SELECT count(*) FROM claims WHERE place_precision IN ('address', 'parcel', 'building') |
| share of facts placed citywide (%) | 26.1 | SELECT round(100.0 * count(*) FILTER (WHERE place_precision = 'city') / count(*), 1) FROM claims |
| sources | 6,377 | SELECT count(*) FROM sources |
| sources in Democracy's Library | 698 | SELECT count(*) FROM sources WHERE in_democracys_library |
| cited archive.org pages | 183,888 | SELECT count(*) FROM pages |
| cited pages with their scan page number | 182,845 | SELECT count(*) FROM pages WHERE leaf_num IS NOT NULL |
| media items | 1,428 | SELECT count(*) FROM media |
| accuracy scores | 36 | SELECT count(*) FROM field_scores |
| readings (rule sets, hand work, model runs) | 43 | SELECT count(*) FROM runs |
| old identifiers that redirect | 135,661 | SELECT count(*) FROM id_redirects |
| corrections | 0 | SELECT count(*) FROM corrections |
| facts verified | 889 | SELECT count(*) FROM claim_reliability WHERE tier = 'verified' |
| facts quoted from their page | 2,962,695 | SELECT count(*) FROM claim_reliability WHERE tier = 'quoted' |
| facts not yet verified | 5,403,521 | SELECT count(*) FROM claim_reliability WHERE tier = 'unverified' |
| distinct decisions (one per printed item, v0.6.1 decision_group) | 539,192 | SELECT count(DISTINCT decision_group) FROM decisions |
Cite this release
qipu (2026). San Francisco public records, release v0.7.1 [data set]. 21 October 2026. https://data.qipu.org/usa/san-francisco/. CC0 1.0.