Place mentions
place_mentionsrelease v0.7.1CC0 1.0
About
v0.7: every place string a statement was read with, one row per page and string; claims.place_mention_id points here. The input to place resolution, like name_mentions for names.
- 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
- place_mentions
- Rows
- 892,915 (San Francisco 892,915)
- Columns
- 8
- Parquet
- place_mentions.parquet, 17.1 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by place_precision
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 8
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| mention_id | VARCHAR | no | none | as is | pm: + sha1(page_id|place_text)[:16].Values e.g. pm:c4ca4238a0b92382 |
| city | VARCHAR | yes | none | as is | The city. |
| place_text | VARCHAR | yes | free text | private people's names withheld under the embargo | The place as given with the statement (claims.place_label; the resolved place id when the reading gave no text). |
| page_id | VARCHAR | no | none | as is | The page it was read on. |
| place_id | VARCHAR | yes | none | as is | The place it was resolved to (when one string was placed two ways on a page, one of them). |
| place_precision | VARCHAR | yes | none | as is | How exactly it was placed. |
| year | BIGINT | yes | none | as is | The year of the earliest statement using it. |
| n_claims | BIGINT | no | none | as is | Statements that point to it. |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| mention_id | city | place_text | page_id | place_id | place_precision | year | n_claims |
|---|---|---|---|---|---|---|---|
| pm:8dbc71ed47688890 | sf | Mission District streets | C101744336:1424 | place/hood/mission | area | 1910 | 1 |
| pm:ad263e753d2a533e | sf | 5653 CALIFORNIA ST | andrewsrealprope1943andr:102 | place/address/eas-441907 | address | 1943 | 1 |
| pm:93b72aefb75444dd | sf | 49 DRUMM ST | andrewsrealprope1943andr:188 | place/address/eas-280425 | address | 1943 | 1 |
| pm:d098eb7ca47278c4 | sf | 507 FELL ST | andrewsrealprope1943andr:218 | place/address/eas-452662 | address | 1943 | 1 |
| pm:242c876fb534586d | sf | 2133 FILBERT ST | andrewsrealprope1943andr:222 | place/address/eas-497954 | address | 1943 | 1 |
| pm:5caa9a621bbcaeb5 | sf | 935 GEARY ST | andrewsrealprope1943andr:255 | place/address/eas-287882 | address | 1943 | 1 |
| pm:d1223e16e5cd0286 | sf | 1335 GILMAN AVE | andrewsrealprope1943andr:262 | place/address/eas-373351 | address | 1943 | 1 |
| pm:b172b305570f2dcc | sf | 1109 GRANT AVE | andrewsrealprope1943andr:274 | place/address/eas-279079 | address | 1943 | 1 |
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 | place_mentions.parquet ↗ | 17.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).