Votes in printed roll calls, 1906–1998
x_roll_call_votesrelease v0.7.1CC0 1.0
About
One row per name in a roll call: the vote, the name as printed, the person it was matched to and how (surname, surname+given, fuzzy, fuzzy_low, surname_widened, journal_only, or ambiguous/unmatched with no person).
- Where it comes from
- The roll calls printed in the Journal of Proceedings (see x_roll_calls).
- How it was read
- Each name in a roll call is matched by rules to a supervisor on the official roster, by surname and years served; match says how. Names that fit no one, or more than one person, are left without a person.
- 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
- x_roll_call_votes
- Rows
- 2,084,507
- Columns
- 5
- Parquet
- x_roll_call_votes.parquet, 3.8 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by vote
| Value | Rows | Share | |
|---|---|---|---|
| aye | 1,740,423 | 83.5% | |
| absent | 262,138 | 12.6% | |
| no | 81,003 | 3.9% | |
| excused | 921 | < 0.1% | |
| not_voting | 22 | < 0.1% |
Rows by match
| Value | Rows | Share | |
|---|---|---|---|
| printed name | 1,723,320 | 82.7% | |
| surname | 330,876 | 15.9% | |
| unmatched | 12,701 | 0.6% | |
| fuzzy | 6,342 | 0.3% | |
| surname_widened | 3,451 | 0.2% | |
| surname (ocr) | 3,250 | 0.2% | |
| surname+given | 2,358 | 0.1% | |
| journal_only | 1,481 | 0.1% | |
| ambiguous | 659 | < 0.1% | |
| fuzzy+given | 61 | < 0.1% | |
| fuzzy_low | 8 | < 0.1% |
Method and accuracy
Each name in a roll call is matched by rules to a supervisor on the official roster, by surname and years served; match says how. Names that fit no one, or more than one person, are left without a person.
| Field | Made by | How well it is known |
|---|---|---|
| x_roll_call_votes.person_id (who voted) | rules: surname + years served, official roster | 99.4% of 2,084,507 printed names matched to a person (659 ambiguous, left empty). Gold names: 536/541 matched. Correctness of each match: unmeasured (no gold of names to persons yet); confidence in claims drops to 0.6 when the counts do not match. |
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 5
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| rollcall_id | VARCHAR | no | none | as is | The roll call (see x_roll_calls). |
| vote | VARCHAR | no | none | as is | aye, no, absent, excused or not_voting.Values aye, no, absent, excused, not_voting |
| name_printed | VARCHAR | yes | a public official | as is | The name as printed in the roll call. |
| person_id | VARCHAR | yes | none | as is | The supervisor the name was matched to (see persons); empty when unmatched or ambiguous. |
| match | VARCHAR | yes | none | as is | How the name was matched: surname, surname+given, fuzzy, fuzzy+given, fuzzy_low, surname_widened, journal_only, ambiguous, unmatched.Values ambiguous, fuzzy, fuzzy+given, fuzzy_low, journal_only, surname, surname+given, surname_widened, unmatched |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| rollcall_id | vote | name_printed | person_id | match |
|---|---|---|---|---|
| 78212d22dd37 | aye | George E. Gallagher | person/george-e-gallagher | surname+given |
| 0b54f3946a39 | aye | McLeran | person/ralph-mcleran | surname |
| f161344e4596 | aye | Wolfe | person/edward-i-wolfe | surname |
| 292e5c16e54c | no | Mulvihill | person/joseph-mulvihill | surname |
| 978212327f8e | aye | Deasy | person/cornelius-deasy | surname |
| cb99b1ed17a7 | aye | Gallagher | — | ambiguous |
| f15ef10a273d | aye | Murdock | person/charle…lbert-murdock | surname_widened |
| 45cffbd8402b | absent | March | — | unmatched |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | x_roll_call_votes.parquet ↗ | 3.8 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
Run in the SQL console (DuckDB in the browser, over the Parquet file).