Person names as printed
person_namesrelease v0.7.1CC0 1.0
About
Each name as printed in roll calls, with the years seen and the person it resolves to.
- Where it comes from
- The names printed in the roll calls of the Journal of Proceedings.
- How it was read
- Each printed form is matched by rules to a supervisor, by surname and years served; match says how.
- 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
- person_names
- Rows
- 9,251
- Columns
- 6
- Parquet
- person_names.parquet, < 0.1 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by match
| Value | Rows | Share | |
|---|---|---|---|
| fuzzy | 6,403 | 69.2% | |
| surname | 2,560 | 27.7% | |
| fuzzy+given | 146 | 1.6% | |
| surname+given | 85 | 0.9% | |
| surname_widened | 49 | 0.5% | |
| journal_only | 6 | 0.1% | |
| fuzzy_low | 2 | < 0.1% |
Method and accuracy
Each printed form is matched by rules to a supervisor, by surname and years served; match says how.
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 6
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| person_id | VARCHAR | no | none | as is | The supervisor (see persons). |
| name_printed | VARCHAR | yes | a public official | as is | The name as printed in the roll call. |
| from | BIGINT | yes | none | as is | First year this printed form appears in a roll call. |
| to | BIGINT | yes | none | as is | Last year this printed form appears in a roll call. |
| n | BIGINT | yes | none | as is | Roll-call votes with this printed form. |
| match | VARCHAR | yes | none | as is | How this printed form was matched (see x_roll_call_votes.match).Values fuzzy, fuzzy+given, fuzzy_low, journal_only, surname, surname+given, surname_widened |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| person_id | name_printed | from | to | n | match |
|---|---|---|---|---|---|
| person/george-christopher | Cbristopber | 1,948 | 1,948 | 1 | fuzzy |
| person/carol-ruth-silver | Silve | 1,980 | 1,981 | 2 | fuzzy |
| person/alfred-roncovieri | Ronco vieri | 1,924 | 1,939 | 47 | surname |
| person/p-j-mcmurray | McMvu-ray | 1,946 | 1,946 | 1 | fuzzy |
| person/frank-j-mcgovern | Mel Govern | 1,931 | 1,931 | 1 | fuzzy |
| person/paul-bancroft | I'.ancroft | 1,909 | 1,910 | 4 | fuzzy |
| person/james-b-mcsheehy | McGoveri McSheehy | 1,928 | 1,928 | 2 | surname |
| person/john-j-sullivan | John J. Sullivah | 1,947 | 1,947 | 1 | fuzzy+given |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | person_names.parquet ↗ | < 0.1 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
Run in the SQL console (DuckDB in the browser, over the Parquet file).