Organisations
orgsrelease v0.7.1CC0 1.0
About
Organisations (v1: the Board).
- 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
- orgs
- Rows
- 1
- Columns
- 4
- Parquet
- orgs.parquet, < 0.1 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
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.
Columns 4
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| org_id | VARCHAR | no | none | as is | qipu:sf/org/<slug>.Values qipu:sf/org/board-of-supervisors |
| name | VARCHAR | yes | an organisation | as is | Name. |
| kind | VARCHAR | no | none | as is | agency.Values agency |
| wikidata | VARCHAR | yes | none | as is | Wikidata id. Values Q3658756 |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| org_id | name | kind | wikidata |
|---|---|---|---|
| org/board-of-supervisors | San Francisco Board of Supervisors | agency | Q3658756 |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | orgs.parquet ↗ | < 0.1 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM orgs
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/orgs.parquet' LIMIT 5").show()