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

OCR files

ocr_filesrelease v0.7.1CC0 1.0

About

The OCR files on archive.org behind each source item (the manifest the page texts were read from), so a reader can fetch and check them.

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
ocr_files
Rows
11,323
Columns
7
Parquet
ocr_files.parquet, 0.6 MB
Version
v0.7.1, 21 October 2026
Licence
CC0 1.0. Sources keep their own rights.

Rows

Rows by format

ValueRowsShare
OCR Page Index1,42212.6%
Page Numbers JSON1,42212.6%
chOCR1,42212.6%
DjVuTXT1,42212.6%
Djvu XML1,42212.6%
hOCR1,42212.6%
OCR Search Text1,42212.6%
Scandata1,36912.1%

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 7

ColumnTypeCan be emptyPrivacyPublic copyDescription
source_idVARCHARnononeas isthe archive.org identifier
Can be empty no · Privacy none · Public copy as is
fileVARCHARyesnoneas isthe file name and archive.org format (hOCR, DjVu text ...)
Can be empty yes · Privacy none · Public copy as is
md5VARCHARyesnoneas isarchive.org's checksums, size and modification time
Can be empty yes · Privacy none · Public copy as is
sha1VARCHARyesnoneas isarchive.org's checksums, size and modification time
Can be empty yes · Privacy none · Public copy as is
sizeVARCHARyesnoneas isarchive.org's checksums, size and modification time
Can be empty yes · Privacy none · Public copy as is
mtimeVARCHARyesnoneas isarchive.org's checksums, size and modification time
Can be empty yes · Privacy none · Public copy as is
formatVARCHARyesnoneas isthe file name and archive.org format (hOCR, DjVu text ...)
Values DjVuTXT, Djvu XML, OCR Page Index, OCR Search Text, Page Numbers JSON, Scandata, chOCR, hOCR
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

source_idfilemd5sha1sizemtimeformat
C124877653C124877653_chocr.html.gz829fe0b677c7c6b91a5663ed7fa83723c76e06267a64c2b521fef8fcec6989cedcb5366020323091743579338chOCR
C124878745C124878745_scandata.xml8af72505d0b44baac204e24fb749fc08f3acb13e76fe07dbf2a317010b1490019ea8811c525931727867059Scandata
C124882558C124882558_hocr.html8f8802da80fba397fadbe5842d0287569a61d36ccac512ae0d17ea315e9e5beb5ac614612817971746089922hOCR
C124917867C124917867_hocr.html6bc2fe63590cfce75081d10b7bcfbad43623a769d0d69198216b48cbef0b07b64a80ae4919184431750254783hOCR
C124922522C124922522_djvu.txtd9b0253fffa01c56cedee532b02a2b9b7570b1b75b34b7a04101de8c897c512bcf6bb55210223811755094777DjVuTXT
meetingminutesjanmay97sanfrichmeetingminutesjanmay97sanfrich_hocr_searchtext.txt.gz7b7a5718437c102eb596e68fa13941de89f8a034046e89d4f7c628f669b16e1300c756323149151638073687OCR Search Text
minutesofregular1976sanfminutesofregular1976sanf_djvu.txt252da7025c7c2355818bc58702de252a4d97ab160492b27d0b3b4a6eca418dae280d1d824424561701090756DjVuTXT
reportofbureauof19261927sreportofbureauof19261927s_chocr.html.gz26cd5b97ff4b64c41a877cbf0a3567ae3deb5b1660eba85355c8d64f97522986fa7d852431637141702624179chOCR

Eight rows sampled at build time. Hover a shortened value for all of it.

Download

FormatFileSize
Parquetocr_files.parquet ↗0.6 MB
SQLite (all tables)qipu_sf.db ↗6.44 GB

SQL

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