Cities
citiesrelease v0.7.1CC0 1.0
About
City configuration (config/cities/*.json): namespace, currency, privacy embargo, address authority.
- 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
- cities
- Rows
- 2 (San Francisco 1; Vancouver 1)
- Columns
- 9
- Parquet
- cities.parquet, < 0.1 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by name
| Value | Rows | Share | |
|---|---|---|---|
| San Francisco | 1 | 50.0% | |
| Vancouver | 1 | 50.0% |
Rows by country
Rows by jurisdiction_id
| Value | Rows | Share | |
|---|---|---|---|
| qipu:sf/place/city | 1 | 50.0% | |
| qipu:van/place/city | 1 | 50.0% |
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 9
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| city | VARCHAR | no | none | as is | City code used in ids: sf, van.Values sf, van |
| name | VARCHAR | yes | none | as is | City name. Values San Francisco, Vancouver |
| country | VARCHAR | yes | none | as is | Country code (US, CA).Values CA, US |
| jurisdiction_id | VARCHAR | no | none | as is | The city's place id (qipu:<city>/place/city).Values qipu:sf/place/city, qipu:van/place/city |
| currency | VARCHAR | yes | none | as is | Currency of amounts (USD, CAD).Values CAD, USD |
| privacy_embargo_years | INTEGER | yes | none | as is | Years after a record's date before private people's names are shown: 75 (SF), 92 (Vancouver). |
| address_authority | VARCHAR | yes | none | as is | The address register places are matched to. Values City of Vancouver property addresses (open data), DataSF Enterprise Addressing System |
| wikidata | VARCHAR | yes | none | as is | Wikidata id. Values Q24639, Q62 |
| bbox | DOUBLE[] | yes | none | as is | [west, south, east, north] in degrees. |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| city | name | country | jurisdiction_id | currency | privacy_embargo_years | address_authority | wikidata |
|---|---|---|---|---|---|---|---|
| sf | San Francisco | US | place/city | USD | 75 | DataSF Enterprise Addressing System | Q62 |
| van | Vancouver | CA | qipu:van/place/city | CAD | 92 | City of Vancouver property addresses (open data) | Q24639 |
8 of 9 columns shown. Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | cities.parquet ↗ | < 0.1 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM cities
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/cities.parquet' LIMIT 5").show()