Withdrawn
withdrawnrelease v0.7.1CC0 1.0
About
v0.7: record time. Every id that was in an earlier release and is gone from this one, with why and what replaced it; carried forward from release to release (append-only). Valid time is t_from / t_to / t_lo / t_hi on the claims.
- 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
- withdrawn
- Rows
- 54,652
- Columns
- 7
- Parquet
- withdrawn.parquet, 0.3 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by kind
| Value | Rows | Share | |
|---|---|---|---|
| claim | 54,152 | 99.1% | |
| instrument | 500 | 0.9% |
Rows by reason
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 7
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| id | VARCHAR | no | none | as is | The claim or entity id. |
| kind | VARCHAR | no | none | as is | What the id named. Values claim, place, person, decision, instrument, org, media |
| release_added | VARCHAR | yes | none | as is | The release it first appeared in (claims). |
| release_removed | VARCHAR | no | none | as is | The first release without it. |
| reason | VARCHAR | no | none | as is | reread (a new reading of the same page replaced it), merge (folded into another record: a duplicate roll call, a renumbered instrument), error (a misreading, no replacement), privacy, rights (takedowns), retired.Values reread, error, merge, privacy, rights, retired |
| replaced_by | VARCHAR | yes | none | as is | The id that replaces it in this release, if any. |
| note | VARCHAR | yes | none | as is | The reason in words. |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| id | kind | release_added | release_removed | reason | replaced_by | note |
|---|---|---|---|---|---|---|
| v:2b3f3c247310:11 | claim | v0.4 | v0.6.1 | merge | v:648b7c0500a9:11 | vote of a roll call marked duplicate_of 648b7c0500a9 (the … |
| v:2ca345952f9b:4 | claim | v0.4 | v0.6.1 | merge | v:7eef0b54ef71:5 | vote of a roll call marked duplicate_of 7eef0b54ef71 (the … |
| v:4f07a66561f2:3 | claim | v0.4 | v0.6.1 | merge | v:a11ac3c9d732:3 | vote of a roll call marked duplicate_of a11ac3c9d732 (the … |
| v:5dc2bb8e76f3:17 | claim | v0.4 | v0.6.1 | merge | v:1eeea84212b1:17 | vote of a roll call marked duplicate_of 1eeea84212b1 (the … |
| v:7420b95944db:8 | claim | v0.4 | v0.6.1 | merge | v:9428f3a96867:8 | vote of a roll call marked duplicate_of 9428f3a96867 (the … |
| v:824bc4f68291:9 | claim | v0.4 | v0.6.1 | merge | v:34249010641c:9 | vote of a roll call marked duplicate_of 34249010641c (the … |
| v:8c4915c75362:3 | claim | v0.4 | v0.6.1 | merge | v:62c263c3593a:3 | vote of a roll call marked duplicate_of 62c263c3593a (the … |
| v:981bd7b1033a:6 | claim | v0.4 | v0.6.1 | merge | v:bf51a75f50bd:7 | vote of a roll call marked duplicate_of bf51a75f50bd (the … |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | withdrawn.parquet ↗ | 0.3 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
Run in the SQL console (DuckDB in the browser, over the Parquet file).