Install Folio
bin/console folio:pull --dataset smith/eepa
Objects
obj
Link Types
| Forward | Reverse | Links |
|---|---|---|
|
per
created
obj
created
|
obj
created_by
per
created_by
|
1,249 |
|
coll
contains
obj
contains
|
obj
belongs_to
coll
belongs_to
|
2,281 |
Observed Schema
| Name | Core | Type | Rows |
|---|---|---|---|
| dto_coll_collection | coll | collection | 107 |
| dto_negative | obj | negative | 3 |
| dto_object | obj | object | 1,171 |
| dto_per_org | per | org | 17 |
| dto_per_person | per | person | 22 |
| dto_photograph | obj | photograph | 10 |
| dto_postcard | obj | postcard | 24 |
| dto_slide | obj | slide | 11 |
Archive Docs
Folio Metadata
json
{
"folio": {
"code": "smith/eepa",
"label": "EEPA",
"dataset_key": "smith/eepa",
"row_count": 1365
},
"cores": [
{
"code": "coll",
"label": null,
"row_count": 107
},
{
"code": "obj",
"label": null,
"row_count": 1219
},
{
"code": "per",
"label": null,
"row_count": 39
}
],
"dtoTables": [
{
"id": "smith/eepa: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": 107
},
{
"id": "smith/eepa:dto_negative",
"name": "dto_negative",
"kind": "dto",
"core_code": "obj",
"dto_type": "negative",
"label": "Negative",
"description": null,
"row_count": 3
},
{
"id": "smith/eepa: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": 1171
},
{
"id": "smith/eepa: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": 17
},
{
"id": "smith/eepa: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": 22
},
{
"id": "smith/eepa:dto_photograph",
"name": "dto_photograph",
"kind": "dto",
"core_code": "obj",
"dto_type": "photograph",
"label": "Photograph",
"description": null,
"row_count": 10
},
{
"id": "smith/eepa:dto_postcard",
"name": "dto_postcard",
"kind": "dto",
"core_code": "obj",
"dto_type": "postcard",
"label": "Postcard",
"description": null,
"row_count": 24
},
{
"id": "smith/eepa:dto_slide",
"name": "dto_slide",
"kind": "dto",
"core_code": "obj",
"dto_type": "slide",
"label": "Slide",
"description": null,
"row_count": 11
}
],
"views": [
"dto_coll_collection",
"dto_negative",
"dto_object",
"dto_per_org",
"dto_per_person",
"dto_photograph",
"dto_postcard",
"dto_slide"
],
"generatedAt": "2026-06-29T18:03:14+00:00",
"metadata": {
"archivePreparedAt": "2026-06-29T18:03:13+00:00",
"schema": {
"tables": 11,
"properties": 67
},
"views": {
"views": 8
}
}
}
Overview
md
# Folio smith/eepa EEPA - Dataset key: `smith/eepa` - Rows: 1,365 - Cores: 3 - Observed DTO tables: 8 ## Cores | Core | Label | Rows | | --- | --- | ---: | | `coll` | coll | 107 | | `obj` | obj | 1,219 | | `per` | per | 39 |
Observed Schema
md
# Observed Schema ## `dto_coll_collection` - Core: `coll` - DTO type: `collection` - Rows: 107 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_negative` - Core: `obj` - DTO type: `negative` - Rows: 3 | 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 | ## `dto_object` - Core: `obj` - DTO type: `object` - Rows: 1,171 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 | | `cul` | `?array` | filterable, facet | MuseumVocab::CULTURE — cultural attribution, e.g. ['Mochica', 'Inca'] | ## `dto_per_org` - Core: `per` - DTO type: `org` - Rows: 17 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: 22 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: 10 | 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 | ## `dto_postcard` - Core: `obj` - DTO type: `postcard` - Rows: 24 | 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 | | `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 | ## `dto_slide` - Core: `obj` - DTO type: `slide` - Rows: 11 | 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_coll_collection limit 20; ``` ```sql select * from dto_negative 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; ``` ```sql select * from dto_postcard limit 20; ``` ```sql select * from dto_slide limit 20; ```