ACAH

Install Folio

bin/console folio:pull --dataset smith/acah

Objects

obj

3,959

Grid List Slideshow

Object · 3,914 Photograph · 39 Book · 2 Audio · 1 Correspondence · 1 Document · 1 +1 more

Persons

per

1,616

Grid List Slideshow

Person · 861 Org · 755

Collections

coll

1,513

Grid List Slideshow

Collection · 1,513

Link Types

Forward	Reverse	Links
per created obj created	obj created_by per created_by	12,233
coll contains obj contains	obj belongs_to coll belongs_to	6,402

Observed Schema

Name	Core	Type	Rows
dto_audio	obj	audio	1
dto_book	obj	book	2
dto_coll_collection	coll	collection	1,513
dto_correspondence	obj	correspondence	1
dto_document	obj	document	1
dto_manuscript	obj	manuscript	1
dto_object	obj	object	3,914
dto_per_org	per	org	755
dto_per_person	per	person	861
dto_photograph	obj	photograph	39

Generated SQLite views

dto_audio dto_book dto_coll_collection dto_correspondence dto_document dto_manuscript dto_object dto_per_org dto_per_person dto_photograph

Archive Docs

Folio Metadata json

{
    "folio": {
        "code": "smith/acah",
        "label": "ACAH",
        "dataset_key": "smith/acah",
        "row_count": 7088
    },
    "cores": [
        {
            "code": "coll",
            "label": null,
            "row_count": 1513
        },
        {
            "code": "obj",
            "label": null,
            "row_count": 3959
        },
        {
            "code": "per",
            "label": null,
            "row_count": 1616
        }
    ],
    "dtoTables": [
        {
            "id": "smith/acah:dto_audio",
            "name": "dto_audio",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "audio",
            "label": "Audio",
            "description": "Sound recordings: oral histories, music, radio broadcasts, and field recordings.",
            "row_count": 1
        },
        {
            "id": "smith/acah:dto_book",
            "name": "dto_book",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "book",
            "label": "Book",
            "description": "Bound volumes: monographs, pamphlets, albums, and catalogues.",
            "row_count": 2
        },
        {
            "id": "smith/acah:dto_coll_collection",
            "name": "dto_coll_collection",
            "kind": "dto",
            "core_code": "coll",
            "dto_type": "collection",
            "label": "Collection",
            "description": "A collection / series \u2014 an aggregation of items rather than a single object.\nTwo producers: the \"folio of folios\" (each row is a whole folio) and aggregators like the\nSmithsonian that expose collections and series alongside objects. Unlike a generic item, a\ncollection is browsed by its dataset-level descriptors \u2014 provider, country, language, size \u2014\nso those are promoted to facets here. `subjects` (a parent facet) carries the dtoType mix.\n/",
            "row_count": 1513
        },
        {
            "id": "smith/acah:dto_correspondence",
            "name": "dto_correspondence",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "correspondence",
            "label": "Correspondence",
            "description": "Letters, telegrams, memos, and other written communications between identified parties.",
            "row_count": 1
        },
        {
            "id": "smith/acah:dto_document",
            "name": "dto_document",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "document",
            "label": "Document",
            "description": "Generic text-primary item: broadsides, lists, clippings, forms, and any textual work that does not fit a more specific type.",
            "row_count": 1
        },
        {
            "id": "smith/acah:dto_manuscript",
            "name": "dto_manuscript",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "manuscript",
            "label": "Manuscript",
            "description": "Handwritten or typed manuscripts: diaries, journals, ledgers, legal documents, and field notes.",
            "row_count": 1
        },
        {
            "id": "smith/acah:dto_object",
            "name": "dto_object",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "object",
            "label": "Artifact",
            "description": "Three-dimensional physical objects and artifacts that do not fit a more specific type: tools, vessels, garments, specimens, etc.",
            "row_count": 3914
        },
        {
            "id": "smith/acah:dto_per_org",
            "name": "dto_per_org",
            "kind": "dto",
            "core_code": "per",
            "dto_type": "org",
            "label": "Org",
            "description": "Concrete BaseItemDto for subjects whose content type is unknown or mixed.\nUse when no domain-specific DTO subclass applies.\n/",
            "row_count": 755
        },
        {
            "id": "smith/acah:dto_per_person",
            "name": "dto_per_person",
            "kind": "dto",
            "core_code": "per",
            "dto_type": "person",
            "label": "Person",
            "description": "People associated with collection records: creators, contributors, subjects, interviewees, performers, and other named agents.",
            "row_count": 861
        },
        {
            "id": "smith/acah:dto_photograph",
            "name": "dto_photograph",
            "kind": "dto",
            "core_code": "obj",
            "dto_type": "photograph",
            "label": "Photograph",
            "description": null,
            "row_count": 39
        }
    ],
    "views": [
        "dto_audio",
        "dto_book",
        "dto_coll_collection",
        "dto_correspondence",
        "dto_document",
        "dto_manuscript",
        "dto_object",
        "dto_per_org",
        "dto_per_person",
        "dto_photograph"
    ],
    "generatedAt": "2026-06-29T18:01:59+00:00",
    "metadata": {
        "archivePreparedAt": "2026-06-29T18:01:58+00:00",
        "schema": {
            "tables": 13,
            "properties": 92
        },
        "views": {
            "views": 10
        }
    }
}

Overview md

# Folio smith/acah

ACAH

- Dataset key: `smith/acah`
- Rows: 7,088
- Cores: 3
- Observed DTO tables: 10

## Cores

| Core | Label | Rows |
| --- | --- | ---: |
| `coll` | coll | 1,513 |
| `obj` | obj | 3,959 |
| `per` | per | 1,616 |

Observed Schema md

# Observed Schema

## `dto_audio`

- Core: `obj`
- DTO type: `audio`
- Rows: 1

Sound recordings: oral histories, music, radio broadcasts, and field recordings.

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `year` | `?int` | filterable, facet, sortable | Coverage/production year. |
| `creators` | `?array` |  | dcterms:creator — array of names |
| `genreSpecific` | `?array` | filterable, facet | Specific genre/form terms (MODS genre @specific) — e.g. ["Albumen prints"]. A facet. |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `hasTranscription` | `bool` |  |  |

## `dto_book`

- Core: `obj`
- DTO type: `book`
- Rows: 2

Bound volumes: monographs, pamphlets, albums, and catalogues.

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `creators` | `?array` |  | dcterms:creator — array of names |
| `genreSpecific` | `?array` | filterable, facet | Specific genre/form terms (MODS genre @specific) — e.g. ["Albumen prints"]. A facet. |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `hasTranscription` | `bool` | filterable, facet |  |
| `year` | `?int` | filterable, facet, sortable | Coverage/production year. |

## `dto_coll_collection`

- Core: `coll`
- DTO type: `collection`
- Rows: 1,513

A collection / series — an aggregation of items rather than a single object.
Two producers: the "folio of folios" (each row is a whole folio) and aggregators like the
Smithsonian that expose collections and series alongside objects. Unlike a generic item, a
collection is browsed by its dataset-level descriptors — provider, country, language, size —
so those are promoted to facets here. `subjects` (a parent facet) carries the dtoType mix.
/

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |

## `dto_correspondence`

- Core: `obj`
- DTO type: `correspondence`
- Rows: 1

Letters, telegrams, memos, and other written communications between identified parties.

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `year` | `?int` | filterable, facet, sortable | Coverage/production year. |
| `creators` | `?array` |  | dcterms:creator — array of names |
| `genreSpecific` | `?array` | filterable, facet | Specific genre/form terms (MODS genre @specific) — e.g. ["Albumen prints"]. A facet. |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `hasTranscription` | `bool` |  |  |

## `dto_document`

- Core: `obj`
- DTO type: `document`
- Rows: 1

Generic text-primary item: broadsides, lists, clippings, forms, and any textual work that does not fit a more specific type.

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `year` | `?int` | filterable, facet, sortable | Coverage/production year. |
| `creators` | `?array` |  | dcterms:creator — array of names |
| `genreSpecific` | `?array` | filterable, facet | Specific genre/form terms (MODS genre @specific) — e.g. ["Albumen prints"]. A facet. |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `hasTranscription` | `bool` |  |  |

## `dto_manuscript`

- Core: `obj`
- DTO type: `manuscript`
- Rows: 1

Handwritten or typed manuscripts: diaries, journals, ledgers, legal documents, and field notes.

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `creators` | `?array` |  | dcterms:creator — array of names |
| `genreSpecific` | `?array` | filterable, facet | Specific genre/form terms (MODS genre @specific) — e.g. ["Albumen prints"]. A facet. |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `hasTranscription` | `bool` |  |  |

## `dto_object`

- Core: `obj`
- DTO type: `object`
- Rows: 3,914

Three-dimensional physical objects and artifacts that do not fit a more specific type: tools, vessels, garments, specimens, etc.

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `year` | `?int` | filterable, facet, sortable | Coverage/production year. |
| `creators` | `?array` |  | dcterms:creator — array of names |
| `genreSpecific` | `?array` | filterable, facet | Specific genre/form terms (MODS genre @specific) — e.g. ["Albumen prints"]. A facet. |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `accession` | `?string` |  | MuseumVocab::ACCESSION — local accession / catalog number |

## `dto_per_org`

- Core: `per`
- DTO type: `org`
- Rows: 755

Concrete BaseItemDto for subjects whose content type is unknown or mixed.
Use when no domain-specific DTO subclass applies.
/

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |

## `dto_per_person`

- Core: `per`
- DTO type: `person`
- Rows: 861

People associated with collection records: creators, contributors, subjects, interviewees, performers, and other named agents.

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` | searchable, sortable |  |
| `contentType` | `?string` | filterable, facet |  |
| `name` | `?string` | searchable, sortable |  |
| `source` | `string` |  |  |
| `confidence` | `?float` |  |  |

## `dto_photograph`

- Core: `obj`
- DTO type: `photograph`
- Rows: 39

| Field | Type | Flags | Description |
| --- | --- | --- | --- |
| `id` | `?string` |  |  |
| `contentType` | `?string` |  |  |
| `stage` | `?string` | filterable, facet | Pipeline processing stage (raw / normalized / enriched). A facet so you can filter to enriched items; later this can be made dev-only. |
| `title` | `?string` |  | dcterms:title |
| `description` | `?string` |  | dcterms:description — short curatorial text from the source institution |
| `year` | `?int` | filterable, facet, sortable | Coverage/production year. |
| `creators` | `?array` |  | dcterms:creator — array of names |
| `genreSpecific` | `?array` | filterable, facet | Genre specific terms (TGM) e.g. "Portrait photographs", "Architectural photographs". A facet. |
| `pageCount` | `?int` | sortable | Number of pages in the document. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |

Query Guide md

# Query Guide

This folio stores canonical rows in `item` and observed field metadata in `schema_table` / `schema_property`.

```sql
select * from schema_table where kind = 'dto';
select * from schema_property where table_id = ? order by position;
select local_id, label, dto_type, dto_data, extras from item limit 20;
```

Convenience views are generated from observed DTO fields:

```sql
select * from dto_audio limit 20;
```

```sql
select * from dto_book limit 20;
```

```sql
select * from dto_coll_collection limit 20;
```

```sql
select * from dto_correspondence limit 20;
```

```sql
select * from dto_document limit 20;
```

```sql
select * from dto_manuscript limit 20;
```

```sql
select * from dto_object limit 20;
```

```sql
select * from dto_per_org limit 20;
```

```sql
select * from dto_per_person limit 20;
```

```sql
select * from dto_photograph limit 20;
```

Survos folio show

Install Folio

Link Types

Observed Schema

Archive Docs