Claim support
claim_supportrelease v0.7.1CC0 1.0
About
One row per staged extraction row behind a claim: the same statement read by several runs or layers is one claim with several supports.
- 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
- claim_support
- Rows
- 6,594,525
- Columns
- 6
- Parquet
- claim_support.parquet, 137.7 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by extraction_table
| Value | Rows | Share | |
|---|---|---|---|
| x_decisions_v2 | 4,209,725 | 63.8% | |
| assessor_roll | 735,855 | 11.2% | |
| bos_records | 445,054 | 6.7% | |
| x_realprop_dir | 331,052 | 5.0% | |
| x_business_locations | 248,990 | 3.8% | |
| x_dl_facts | 181,197 | 2.7% | |
| resweep | 112,079 | 1.7% | |
| site_decisions | 98,458 | 1.5% | |
| map_blocks | 95,790 | 1.5% | |
| dbi_permits | 31,037 | 0.5% | |
| map_block_items | 23,436 | 0.4% | |
| x_block_tract | 20,389 | 0.3% |
Rows by run_id
| Value | Rows | Share | |
|---|---|---|---|
| sf-v21-haiku-1014 | 4,209,725 | 63.8% | |
| assessor-roll-2025 | 735,855 | 11.2% | |
| bos-corpus-2026-09 | 445,054 | 6.7% | |
| andrews-sonnet55-2026-10 | 331,052 | 5.0% | |
| rbl-2026-10-14 | 248,990 | 3.8% | |
| dl-sf-facts-v1.1-haiku55-2026-10 | 181,197 | 2.7% | |
| site-street-layer-2026-10 | 98,458 | 1.5% | |
| map-blocks-2026-10 | 95,790 | 1.5% | |
| resweep-d1970-haiku55-2026-10 | 42,505 | 0.6% | |
| dbi-notable-2026-10 | 31,037 | 0.5% | |
| resweep-d2010-haiku55-2026-10 | 25,476 | 0.4% | |
| map-blocks-items-2026-10 | 23,436 | 0.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 6
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| claim_id | VARCHAR | no | none | as is | Stable id: c: + 32 hex (128 bits, hashed from the slot: subject, property, object, page, role); votes v:<rollcall_id>:<n>. |
| extraction_table | VARCHAR | yes | none | as is | Which table or file the reading came from. Values bos_records, dateline, dl_documents, doors, hand_decisions, hood_stories, hood_timelines, map_block_items, map_blocks, media, resweep, showcase_search ... |
| row_key | VARCHAR | no | raw text | private people's names withheld under the embargo | The row inside that table or file (its seq, else the staged claim id). |
| run_id | VARCHAR | no | none | as is | The extraction run (see runs).Values bos-corpus-2026-09, dateline-2026-10, dl-tags-haiku55-2026-10, doors-2026-10, hand-2026-10, hood-stories-2026-10, hood-timelines-2026-10, ia-fulltext-places-2026-07, map-blocks-2026-10, map-blocks-items-2026-10, media-registry-2026-10, resweep-d1960-haiku55-2026-10 ... |
| confidence | DOUBLE | yes | none | as is | 0-1 where the run gives one. |
| agrees | BOOLEAN | yes | none | as is | true on every row in v0.4. |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| claim_id | extraction_table | row_key | run_id | confidence | agrees |
|---|---|---|---|---|---|
| c:fad6044f6cbefd54d9756b0040dd4a33 | x_decisions_v2 | decision/meet…anfrich:105/2 | sf-v21-haiku-1014 | 0.7 | true |
| c:296e3662f161a5f429757faebc3a5c6d | x_decisions_v2 | decision/meet…anfrich:351/2 | sf-v21-haiku-1014 | 1.0 | true |
| c:42f32424a89dff3b1ee1c35c4177ff55 | x_decisions_v2 | decision/jour…nfrich:2486/1 | sf-v21-haiku-1014 | 1.0 | true |
| c:409f2f46888dd31c88d89042802818a8 | x_decisions_v2 | decision/jour…nfrich:1677/1 | sf-v21-haiku-1014 | 1.0 | true |
| c:2fac12d77da58d9d740f454733e96f3d | x_decisions_v2 | decision/jour…anfrich:438/1 | sf-v21-haiku-1014 | 1.0 | true |
| c:8c332ba12744bfe4df0bbbf815920003 | x_decisions_v2 | decision/jour…nfrich:2439/2 | sf-v21-haiku-1014 | 0.7 | true |
| c:e3d309e1d76b4a62896c8ae82e864944 | x_decisions_v2 | decision/jour…anfrich:330/3 | sf-v21-haiku-1014 | 1.0 | true |
| c:76007a47b2a9920ec8a7a08b865f3c1c | x_decisions_v2 | decision/meet…11sanf_2:12/1 | sf-v21-haiku-1014 | 1.0 | true |
Eight rows sampled at build time. Hover a shortened value for all of it.
Download
| Format | File | Size |
|---|---|---|
| Parquet | claim_support.parquet ↗ | 137.7 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM claim_support
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/claim_support.parquet' LIMIT 5").show()