Qipudata
San Francisco · v0.7.1

Claim properties

propertiesrelease v0.7.1CC0 1.0

About

The claim property vocabulary (spec/vocab/properties.csv).

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
properties
Rows
85
Columns
13
Parquet
properties.parquet, < 0.1 MB
Version
v0.7.1, 21 October 2026
Licence
CC0 1.0. Sources keep their own rights.

Rows

Rows by domain

Rows by range_kind

Rows by allowed_qualifiers

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.

Methodology · Accuracy

Columns 13

ColumnTypeCan be emptyPrivacyPublic copyDescription
propertyVARCHARnononeas isProperty name, as used in claims.property.
Can be empty no · Privacy none · Public copy as is
domainVARCHARyesnoneas isWhat the subject is (decision, place, person | org, ...).
Values decision, decision | case, decision | instrument, decision | instrument | case, decision | instrument | case | source | media, event | story | decision, instrument, person, person | name, person | org, place, place (historic address)
Can be empty yes · Privacy none · Public copy as is
rangeVARCHARyesnoneas isWhat the object or value is.
Can be empty yes · Privacy none · Public copy as is
range_kindVARCHARyesnoneas isThe range in a closed machine form: alternatives joined by |, each one of entity:<class> (place, person, org, decision, instrument, media, source, event), enum:<v1/v2/...>, name (a printed name not resolved to an entity), money, number, date, text, bool.
Can be empty yes · Privacy none · Public copy as is
allowed_qualifiersVARCHARyesnoneas isThe claims.qualifiers keys seen on this property in the last release (every key seen, most used first), joined by |; empty when its claims carry none.
Can be empty yes · Privacy none · Public copy as is
claim_kindVARCHARnononeas isevent, observation or interval.
Values event, interval, observation
Can be empty no · Privacy none · Public copy as is
definitionVARCHARyesnoneas isWhat the property means.
Can be empty yes · Privacy none · Public copy as is
wikidata_propertyVARCHARyesnoneas isClosest Wikidata property (P127, ...).
Can be empty yes · Privacy none · Public copy as is
wikidata_matchVARCHARyesnoneas isHow close the Wikidata property is: exact, close, close (inverse), verify, none.
Values close, close (inverse), exact, none, verify
Can be empty yes · Privacy none · Public copy as is
use_caseVARCHARyesnoneas isThe question the property answers (Who owned it, Follow the money).
Can be empty yes · Privacy none · Public copy as is
since_specVARCHARyesnoneas isSpec version that added it (v0.1, v0.2, 1.0).
Values 1.0, v0.1, v0.2
Can be empty yes · Privacy none · Public copy as is
deprecated_byVARCHARyesnoneas isThe property that replaces it.
Values concerns_place
Can be empty yes · Privacy none · Public copy as is
sourcesVARCHARyesnoneas isSources or runs that give it.
Can be empty yes · Privacy none · Public copy as is

Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.

Preview

propertydomainrangerange_kindallowed_qualifiersclaim_kinddefinitionwikidata_property
votedperson | namedecision; value_text yes|no|absent|excused|not_votingentity:decisionrepointed_fromeventOne member's vote in a printed roll call. No Wikidata prop…—
demolishedplaceyear or textdate|text—eventA building on the place was demolished, or listed to be de…P576
alteredplacetexttext—eventAn alteration or addition (permit, building contract for w…P793
buildingplacetexttext—observationThe building(s) on the place as described in the source (s…—
depicted_inplacemediaentity:mediadistance_m|moved_from|whyobservationThe place appears in this media item (photo, film, map, TV).P180
part_ofplaceplaceentity:place—observationDeclared membership (a parcel listed in a redevelopment ar…P361
appeal_ofdecisiontext (body); qualifiers.numbertext—eventThe item is an appeal of another body's decision (Planning…—
pursuant_todecisioninstrument | charter sectionentity:instrument|text—observationThe decision is made under another law or charter section.—

8 of 13 columns shown. Eight rows sampled at build time. Hover a shortened value for all of it.

Download

FormatFileSize
Parquetproperties.parquet ↗< 0.1 MB
SQLite (all tables)qipu_sf.db ↗6.44 GB

SQL

SELECT * FROM properties 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/properties.parquet' LIMIT 5").show()