Mentions
x_mentionsrelease v0.7.1CC0 1.0
About
Democracy's Library items and the neighbourhoods and streets they mention (one row per mention; from the DL place tags, x_dl_tags).
- 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_mentions
- Rows
- 915
- Columns
- 7
- Parquet
- x_mentions.parquet, < 0.1 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by mention_kind
Rows by doc_type
| Value | Rows | Share | |
|---|---|---|---|
| study or report | 483 | 52.8% | |
| plan | 149 | 16.3% | |
| environmental impact report | 93 | 10.2% | |
| other | 76 | 8.3% | |
| annual report | 53 | 5.8% | |
| ordinance or legislation | 48 | 5.2% | |
| city-owned property report | 7 | 0.8% | |
| minutes or proceedings | 6 | 0.7% |
Rows by scope
| Value | Rows | Share | |
|---|---|---|---|
| neighbourhoods | 393 | 43.0% | |
| site | 282 | 30.8% | |
| citywide | 227 | 24.8% | |
| regional | 13 | 1.4% |
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 7
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| run_id | VARCHAR | no | none | as is | the tagging run Values dl-tags-haiku55-2026-10 |
| document_id | VARCHAR | no | none | as is | ia:<identifier> of the item |
| seq | BIGINT | yes | none | as is | the tag row |
| mention_text | VARCHAR | yes | free text | private people's names withheld under the embargo | the neighbourhood or street as tagged |
| mention_kind | VARCHAR | no | none | as is | hood or streetValues hood, street |
| doc_type | VARCHAR | yes | none | as is | the item's document type and scope (citywide, neighbourhood ...) Values annual report, city-owned property report, environmental impact report, minutes or proceedings, ordinance or legislation, other, plan, study or report |
| scope | VARCHAR | yes | none | as is | the item's document type and scope (citywide, neighbourhood ...) Values citywide, neighbourhoods, regional, site |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| run_id | document_id | seq | mention_text | mention_kind | doc_type | scope |
|---|---|---|---|---|---|---|
| dl-tags-haiku55-2026-10 | ia:C101696845 ↗ | 247 | Mission | hood | study or report | citywide |
| dl-tags-haiku55-2026-10 | ia:C124886545 ↗ | 264 | Oceanview/Merced/Ingleside | hood | environmental impact report | site |
| dl-tags-haiku55-2026-10 | ia:C101737381 ↗ | 340 | Presidio | hood | ordinance or legislation | neighbourhoods |
| dl-tags-haiku55-2026-10 | ia:C124919865 ↗ | 748 | Hayes Valley | hood | environmental impact report | site |
| dl-tags-haiku55-2026-10 | ia:C124921078 ↗ | 936 | Sunset/Parkside | hood | environmental impact report | site |
| dl-tags-haiku55-2026-10 | ia:C123307561 ↗ | 108 | Third Street | street | plan | neighbourhoods |
| dl-tags-haiku55-2026-10 | ia:C124902184 ↗ | 945 | Mission Street | street | study or report | neighbourhoods |
| dl-tags-haiku55-2026-10 | ia:C124889033 ↗ | 1,069 | Doyle Drive | street | study or report | site |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | x_mentions.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).