Media
mediarelease v0.7.1CC0 1.0
About
Every photo, film, recording, clip and document the map shows (timelines, covers, hood stories, block items, films, clips), with its credit, licence, holder and a rights note. Claims depicted_in / recorded_at tie each to its place and year.
- 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
- media
- Rows
- 1,428 (San Francisco 1,428)
- Columns
- 24
- Parquet
- media.parquet, 0.1 MB
- Version
- v0.7.1, 21 October 2026
- Licence
- CC0 1.0. Sources keep their own rights.
Rows
Rows by kind
Rows by licence
| Value | Rows | Share | |
|---|---|---|---|
| (empty) | 733 | 51.3% | |
| No open licence: link and credit only; ask WNP before public use | 318 | 22.3% | |
| Public domain | 87 | 6.1% | |
| CC BY-SA 4.0 | 84 | 5.9% | |
| CC BY-SA 3.0 | 40 | 2.8% | |
| CC BY 2.0 | 32 | 2.2% | |
| public-domain | 23 | 1.6% | |
| CC BY-SA 2.0 | 22 | 1.5% | |
| http://creativecommons.org/licenses/by-nc-sa/1.0/ | 18 | 1.3% | |
| CC0 | 13 | 0.9% | |
| https://creativecommons.org/licenses/by-nc-nd/4.0/ | 11 | 0.8% | |
| http://creativecommons.org/licenses/publicdomain/ | 6 | 0.4% |
Rows by holder
| Value | Rows | Share | |
|---|---|---|---|
| OpenSFHistory / Western Neighborhoods Project | 985 | 69.0% | |
| Wikimedia Commons | 298 | 20.9% | |
| Internet Archive | 85 | 6.0% | |
| Internet Archive: Live Music Archive | 26 | 1.8% | |
| (empty) | 17 | 1.2% | |
| Internet Archive (scan); public domain | 11 | 0.8% | |
| Library of Congress | 6 | 0.4% |
Method and accuracy
| Field | Made by | How well it is known |
|---|---|---|
| media rights_note | rules by holder, on top of the licence the map recorded | rule output; the item page is the authority. 17 items have no holder rule (rights not recorded: link only). |
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 24
| Column | Type | Can be empty | Privacy | Public copy | Description |
|---|---|---|---|---|---|
| media_id | VARCHAR | no | none | as is | qipu:sf/media/<hash of its URL>, stable. |
| kind | VARCHAR | no | none | as is | Kind as the map records it: photo, film, audio, clip, text, document.Values audio, clip, document, film, photo, text |
| url | VARCHAR | yes | none | as is | The item's page at its holder. |
| file_url | VARCHAR | yes | none | as is | Direct file or image link (a thumbnail for films). |
| embed_url | VARCHAR | yes | none | as is | Embeddable player link (archive.org embed, with start time). |
| title | VARCHAR | yes | catalogue text | as is | Title or caption. |
| credit | VARCHAR | yes | catalogue text | as is | Credit line as the map shows it. |
| licence | VARCHAR | yes | none | as is | Licence as the map recorded it; text longer than 80 characters is moved to rights_note. |
| holder | VARCHAR | yes | catalogue text | as is | Who holds the rights or the copy. |
| rights_note | VARCHAR | yes | catalogue text | as is | What a reuser must know, by holder rule (e.g. WNP: ask before public use; Live Music Archive: non-commercial). |
| year | BIGINT | yes | none | as is | Year of the map moment the item illustrates, not when it was made (see created_edtf). |
| used_in | VARCHAR[] | yes | none | as is | Where the map uses it (timelines.json:<street>#<n>, blocks/<block>.json:<id>, ...). |
| source_identifier | VARCHAR | yes | none | as is | archive.org identifier, for archive.org items. |
| start_s | BIGINT | yes | none | as is | Films: start second in the map's player. |
| placed_because | VARCHAR | yes | catalogue text | as is | Films: why the film is placed where it is (archive.org description, shotlist or qipu's frame check). |
| distance_m | BIGINT | yes | none | as is | Distance in metres recorded for the item in the map's block files (dist). |
| end_s | BIGINT | yes | none | as is | Films: end second in the map's player. |
| derived_from | VARCHAR | yes | none | as is | Clips: the archive.org film the clip was cut from. Values https://archive.org/details/0779_Seeing_Americas_Greatest_Chinatown_San_Francisco_Part_I_09_49_35_00, https://archive.org/details/EmbarcaderoFreewayEntry1957, https://archive.org/details/SanFranc1906_2, https://archive.org/details/TripDown1905, https://archive.org/details/anti-vietnam-war-march-1969-llsf-2016-20-mbps-1, https://archive.org/details/barbary-coast-1914-from-lost-landscapes-no-1, https://archive.org/details/barbary-coast-c-1930s-w-purcells-llsf-2012, https://archive.org/details/casfmta_000020, https://archive.org/details/casfmta_000024, https://archive.org/details/cubanc_000212, https://archive.org/details/cubanc_000238, https://archive.org/details/moonalice20180805-16th-annual-jerry-day-jerry-garcia-amphitheater ... |
| clip_seconds | DOUBLE | yes | none | as is | Clips: length in seconds. |
| not_cut_because | VARCHAR | yes | none | as is | Clips: why no clip was cut (licence). Values CC no-derivatives: link only, licence not open (Copyright status unknown. This work may be protected by the ): link only, licence not open (Copyright status unknown; stream only (Bancroft Library / Ca): link only, licence not open (Not stated (Moonalice video archive on the Internet Archive)): link only |
| media_kind | VARCHAR | no | none | as is | photo, film, recording, clip, text, document (kind with audio -> recording).Values clip, document, film, photo, recording, text |
| created_edtf | VARCHAR | yes | none | as is | When it was made (EDTF), from a year in the title; ~ for circa; empty when the title has none. |
| use_policy | VARCHAR | yes | none | as is | How it may be used: open, attribution, noncommercial, stream_only, link_only, ask_holder, unknown.Values open, attribution, noncommercial, stream_only, link_only, ask_holder, unknown |
| city | VARCHAR | no | none | as is | sf.Values sf |
Privacy: what kind of text the column holds. Public copy: what the published file does with it; the embargo covers records after 1951.
Preview
| media_id | kind | url | file_url | embed_url | title | credit | licence |
|---|---|---|---|---|---|---|---|
| media/1974bb9a0955 | photo | opensfhistory.or…y/wnp14.4596.jpg ↗ | opensfhistory.or…0/wnp14.4596.jpg ↗ | — | Clay & Sansome Apr 1906 | OpenSFHistory / Western Neighborhoods Project (wnp14.4596) | No open licence: link and credit only; ask WNP before publ… |
| media/100bcb773c98 | photo | opensfhistory.or…/wnp59.00068.jpg ↗ | opensfhistory.or…/wnp59.00068.jpg ↗ | — | Duboce near WEbster 1906 | OpenSFHistory / Western Neighborhoods Project (wnp59.00068) | No open licence: link and credit only; ask WNP before publ… |
| media/f6bf3170d2b6 | photo | opensfhistory.or…y/wnp71.1364.jpg ↗ | opensfhistory.or…0/wnp71.1364.jpg ↗ | — | 5th & Folsom 1906 | OpenSFHistory / Western Neighborhoods Project (wnp71.1364) | No open licence: link and credit only; ask WNP before publ… |
| media/f4869ca29dab | film | archive.org/details/SanFranc1906_2 ↗ | archive.org/serv…g/SanFranc1906_2 ↗ | archive.org/embe…nc1906_2?start=0 ↗ | Days after the 1906 quake: riding east down a ruined Marke… | Internet Archive | creativecommons.…es/publicdomain/ ↗ |
| media/9f99549f37d5 | photo | opensfhistory.or…ay/wnp26.013.jpg ↗ | opensfhistory.or…00/wnp26.013.jpg ↗ | — | 19th Ave near Sloat Nov 5, 1937 | OpenSFHistory / Western Neighborhoods Project (wnp26.013) | No open licence: link and credit only; ask WNP before publ… |
| media/015d2c3e0f97 | photo | opensfhistory.or…y/wnp27.6454.jpg ↗ | opensfhistory.or…0/wnp27.6454.jpg ↗ | — | Steiner near Bush 1906 | OpenSFHistory wnp27.6454 | — |
| media/d5e9f111ae7e | photo | opensfhistory.or…y/wnp27.0209.jpg ↗ | opensfhistory.or…0/wnp27.0209.jpg ↗ | — | Fairmont Hotel ruins Apr 1906 | OpenSFHistory wnp27.0209 | — |
| media/54db02db16a8 | photo | opensfhistory.or…/wnp36.01199.jpg ↗ | opensfhistory.or…/wnp36.01199.jpg ↗ | — | Sansome near Broadway Feb 16, 1916 | OpenSFHistory wnp36.01199 | — |
8 of 24 columns shown. 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 | media.parquet ↗ | 0.1 MB |
| SQLite (all tables) | qipu_sf.db ↗ | 6.44 GB |
SQL
SELECT *
FROM media
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/media.parquet' LIMIT 5").show()