Corrections
correctionsrelease v0.7.1CC0 1.0
About
The human layer (empty in v0.3): edits applied on top of claims, never replacing extractions.
- 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
- corrections
- Rows
- 0
- Columns
- 8
- Parquet
- corrections.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 8
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| correction_id | VARCHAR | yes | none | as is | Empty in v0.4 (no corrections yet). Meant for the id of a human correction, applied on top of the claims (claims_effective). |
| target_kind | VARCHAR | yes | none | as is | Empty in v0.4 (no corrections yet). Meant for what kind of row is corrected. |
| target_id | VARCHAR | yes | none | as is | Empty in v0.4 (no corrections yet). Meant for the id of the corrected row. |
| field | VARCHAR | yes | none | as is | Empty in v0.4 (no corrections yet). Meant for the corrected column. |
| new_value | VARCHAR | yes | free text | private people's names withheld under the embargo | Empty in v0.4 (no corrections yet). Meant for the corrected value. |
| at_time | TIMESTAMP | yes | none | as is | Empty in v0.4 (no corrections yet). Meant for when it was made. |
| why | VARCHAR | yes | free text | private people's names withheld under the embargo | Empty in v0.4 (no corrections yet). Meant for the reason. |
| review | VARCHAR | yes | none | as is | Empty in v0.4 (no corrections yet). Meant for its review state. |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| correction_id | target_kind | target_id | field | new_value | at_time | why | review |
|---|
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | corrections.parquet ↗ | < 0.1 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM corrections
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/corrections.parquet' LIMIT 5").show()