Ordinances, resolutions and bills
instrumentsrelease v0.7.1CC0 1.0
About
Ordinances, resolutions and bills by printed number.
- Where it comes from
- The ordinance, resolution and bill numbers printed in the Board's decisions.
- How it was read
- Found in the decision text by pattern. A scanning error in a number (1G2 for 162) is not read.
- 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
- instruments
- Rows
- 72,224
- Columns
- 10
- Parquet
- instruments.parquet, 0.9 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by kind
| Value | Rows | Share | |
|---|---|---|---|
| resolution | 52,485 | 72.7% | |
| ordinance | 19,739 | 27.3% |
Rows by year_basis
| Value | Rows | Share | |
|---|---|---|---|
| printed | 64,671 | 89.5% | |
| year of the Journal (assumed) | 7,553 | 10.5% |
Method and accuracy
Found in the decision text by pattern. A scanning error in a number (1G2 for 162) is not read.
| Field | Made by | How well it is known |
|---|---|---|
| instruments (numbers) | regex on the item text | unmeasured. OCR can garble numbers (1G2 for 162); those are not parsed. |
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 10
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| instrument_id | VARCHAR | no | none | as is | qipu:sf/instrument/<res|ord|bill>/<year>-<n> when the number prints its year (627-91), s<year>-<n> for "(Series of 1939)", ns-<n> for "(New Series)", else y<journal year>-<n>. |
| kind | VARCHAR | no | none | as is | resolution or ordinance.Values ordinance, resolution |
| number | VARCHAR | yes | none | as is | The number as printed. |
| year | BIGINT | yes | none | as is | Year printed with the number, else the earliest Journal year it appears in (see year_basis). |
| year_basis | VARCHAR | yes | none | as is | printed, or the Journal year (assumed). Values printed, year of the Journal (assumed) |
| title | VARCHAR | yes | free text | private people's names withheld under the embargo | Empty in v0.4. |
| file_no | VARCHAR | yes | none | as is | Board file number printed with it. |
| first_page_id | VARCHAR | no | none | as is | Lowest page_id among the x_decisions rows that print the number; : when that row has no archive.org page. |
| n_decisions | BIGINT | yes | none | as is | Decisions that print the number. |
| note | VARCHAR | yes | none | as is | Warning on numbers printed at the head of more than 10 items (probably the ordinance they amend). Values printed at the head of many items: probably the ordinance they amend, not their own number |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| instrument_id | kind | number | year | year_basis | title | file_no | first_page_id |
|---|---|---|---|---|---|---|---|
| instrument/res/ns-34220 | resolution | 34220 | 1931 | printed | — | — | journalofproceed26sanfrich:833 |
| instrument/res/ns-26612 | resolution | 26612 | 1926 | printed | — | — | journalofproc…sanfrich:2107 |
| instrument/res/ns-11480 | resolution | 11480 | 1915 | printed | — | — | journalofproc…5sanfrich:125 |
| instrument/res/ns-31506 | resolution | 31506 | 1929 | printed | — | — | journalofproc…sanfrich:2042 |
| instrument/res/y1929-9 | resolution | 9 | 1929 | year of the Journal (assumed) | — | — | journalofproc…sanfrich:1852 |
| instrument/res/ns-29782 | resolution | 29782 | 1928 | printed | — | — | journalofproc…sanfrich:2339 |
| instrument/ord/ns-7238 | ordinance | 7238 | 1929 | printed | — | — | journalofproceed24sanfrich:127 |
| instrument/res/s1939-7632 | resolution | 7632 | 1948 | printed | — | — | journalofproceed43sanfrich:535 |
8 of 10 columns shown. Eight rows sampled at build time, from the years up to 1951. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | instruments.parquet ↗ | 0.9 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM instruments
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/instruments.parquet' LIMIT 5").show()