Qipudata
San Francisco · v0.7.1
qipu data›San Francisco›Datasets›org_merges

Org merges

org_mergesrelease v0.7.1CC0 1.0

About

v0.6.2 stub (empty in the release): the merge log of organisation names. One row per printed name variant folded into an organisation, with the rule that did it, so every merge can be checked and undone. Filled by the graph slice (graph_slice/, not yet in the release); organisation ids there are provisional until frozen (STABLE_IDS_AND_VERSIONING.md).

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

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 9

ColumnTypeCan be emptyPrivacyPublic copyDescription
variantVARCHARnoan organisationas isThe name as printed (C P T & T Co).
Can be empty no · Privacy an organisation · Public copy as is
org_idVARCHARnononeas isThe organisation it was folded into: a minted qipu:sf/org/... id, never re-derived from the name.
Can be empty no · Privacy none · Public copy as is
ruleVARCHARnononeas isWhich rule merged it (normaliser step, alias table, hand).
Can be empty no · Privacy none · Public copy as is
confidenceDOUBLEyesnoneas isThe rule's score, 0-1; a prior unless confidence_kind is measured.
Values 0..1
Can be empty yes · Privacy none · Public copy as is
confidence_kindVARCHARyesnoneas ismeasured (from a hand-checked sample) or prior (a hand-set value for the rule).
Values measured, prior
Can be empty yes · Privacy none · Public copy as is
whoVARCHARnononeas isThe rule name, or the initials of the person.
Can be empty no · Privacy none · Public copy as is
merged_onDATEnononeas isWhen the merge was made.
Can be empty no · Privacy none · Public copy as is
statusVARCHARnononeas isunreviewed until a person checks it; ambiguous for generic names (City, the city) that stay name mentions.
Values unreviewed, accepted, rejected, ambiguous
Can be empty no · Privacy none · Public copy as is
reversibleBOOLEANnononeas isTrue when undoing it is a row change only (every rule merge); the variant's mentions keep their printed text.
Can be empty no · 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

variantorg_idruleconfidenceconfidence_kindwhomerged_onstatus

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

Download

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

SQL

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