Identifier redirects
id_redirectsrelease v0.7.1CC0 1.0
About
Stable-id policy: a merged or retired id keeps resolving through this table (empty in v0.1, the first release).
- 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
- id_redirects
- Rows
- 135,661
- Columns
- 4
- Parquet
- id_redirects.parquet, 1.5 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by reason
Rows by since_release
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 |
|---|---|---|---|---|---|
| old_id | VARCHAR | no | none | as is | An id an earlier release published. |
| new_id | VARCHAR | yes | none | as is | The id it now resolves to; empty when the id was retired. |
| reason | VARCHAR | yes | none | as is | decisions v2 reading attached to the same v1 decision, or retired in <release>: no longer produced by the build.Values decisions v2 reading attached to the same v1 decision, retired in v0.3: no longer produced by the build (see CHANGELOG) |
| since_release | VARCHAR | yes | none | as is | Release that added the redirect. Values v0.3, v0.4 |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| old_id | new_id | reason | since_release |
|---|---|---|---|
| decision/meet…6sanf_3:314/1 | decision/meet…6sanf_3:313/4 | decisions v2 reading attached to the same v1 decision | v0.5 |
| decision/jour…anfrich:856/1 | decision/jour…anfrich:855/6 | decisions v2 reading attached to the same v1 decision | v0.5 |
| decision/jour…nfrich:1408/1 | decision/jour…nfrich:1407/2 | decisions v2 reading attached to the same v1 decision | v0.5 |
| decision/jour…anfrich:129/1 | decision/jour…anfrich:128/1 | decisions v2 reading attached to the same v1 decision | v0.5 |
| decision/meet…anfrich:275/5 | decision/meet…sanfrich|g896 | decisions v2 reading attached to the same v1 decision | v0.5 |
| decision/jour…nfrich:1148/4 | decision/jour…7sanfrich|457 | decisions v2 reading attached to the same v1 decision | v0.5 |
| decision/5min…1999sanf:54/4 | decision/5min…s1999sanf|g26 | decisions v2 reading attached to the same v1 decision | v0.5 |
| decision/jour…anfrich:318/5 | decision/jour…anfrich|g1113 | decisions v2 reading attached to the same v1 decision | v0.5 |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | id_redirects.parquet ↗ | 1.5 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM id_redirects
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/id_redirects.parquet' LIMIT 5").show()