Numbers printed in decisions
decision_numbersrelease v0.7.1CC0 1.0
About
Decision -> number(s) printed in its text.
- Where it comes from
- The numbers printed in the text of the Board's decisions.
- How it was read
- Found in the decision text by pattern.
- 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
- decision_numbers
- Rows
- 88,876
- Columns
- 10
- Parquet
- decision_numbers.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 | 60,760 | 68.4% | |
| ordinance | 28,116 | 31.6% |
Rows by series
| Value | Rows | Share | |
|---|---|---|---|
| (empty) | 57,120 | 64.3% | |
| (New Series) | 25,925 | 29.2% | |
| (Series of 1939) | 5,825 | 6.6% | |
| (Series of 1933) | 2 | < 0.1% | |
| (Series of 1993) | 1 | < 0.1% | |
| (Series of 1989) | 1 | < 0.1% | |
| (Series of 1039) | 1 | < 0.1% | |
| (Series of 9139) | 1 | < 0.1% |
Method and accuracy
Found in the decision text by pattern.
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 10
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| decision_id | VARCHAR | no | none | as is | The decision whose text prints the number (see decisions). |
| kind | VARCHAR | no | none | as is | resolution or ordinance.Values ordinance, resolution |
| number | VARCHAR | yes | none | as is | The number as printed at the start of the item. |
| number_year | INTEGER | yes | none | as is | Full year from a printed suffix (No. 627-91 -> 1991). |
| series | VARCHAR | yes | none | as is | Series as printed: (New Series), (Series of 1939).Values (New Series), (Series of 1039), (Series of 1933), (Series of 1939), (Series of 1989), (Series of 1993), (Series of 9139) |
| file_no | VARCHAR | yes | none | as is | Board file number as printed (File No. ...). |
| number_check | VARCHAR | yes | none | as is | v0.6.1 check of the number against the page: cited (printed only after words that cite another act: not this item's number, no link), not_found (printed nowhere on the page: no link), seq_outlier (far from the numbers around it: kept, flagged), legistar: N-YY (corrected from the Legistar matter), legistar: not this number (...) (no link); empty when nothing was found against it. |
| year | BIGINT | yes | none | as is | Year of the Journal volume. |
| source_url | VARCHAR | yes | none | as is | Link to the source page. |
| instrument_id | VARCHAR | no | none | as is | qipu:sf/instrument/<res|ord|bill>/<year>-<n> when the number prints its year, s<year>-<n> for "(Series of 1939)", ns-<n> for "(New Series)", else y<journal year>-<n>. |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| decision_id | kind | number | number_year | series | file_no | number_check | year |
|---|---|---|---|---|---|---|---|
| decision/jour…sanfrich|1051 | resolution | 2573 | — | (New Series) | — | — | 1908 |
| decision/jour…9sanfrich|666 | ordinance | 4078 | — | — | — | — | 1919 |
| decision/jour…7sanfrich|162 | resolution | 2471 | — | — | — | — | 1942 |
| decision/jour…7sanfrich|402 | ordinance | 4080 | — | (New Series) | — | — | 1917 |
| decision/jour…sanfrich|2736 | ordinance | 4742 | — | (New Series) | — | not_found | 1925 |
| decision/jour…sanfrich|2700 | resolution | 24793 | — | (New Series) | — | — | 1925 |
| decision/jour…sanfrich|2459 | resolution | 26439 | — | (New Series) | — | — | 1926 |
| decision/jour…3sanfrich|413 | resolution | 28482 | — | (New Series) | — | — | 1928 |
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 | decision_numbers.parquet ↗ | 0.9 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM decision_numbers
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/decision_numbers.parquet' LIMIT 5").show()