Install Folio
bin/console folio:pull --dataset dc/6h442603m
Link Types
| Forward | Reverse | Links |
|---|---|---|
|
per
created
obj
created
|
obj
created_by
per
created_by
|
1,008 |
|
coll
contains
obj
contains
|
obj
belongs_to
coll
belongs_to
|
234 |
Observed Schema
| Name | Core | Type | Rows |
|---|---|---|---|
| dto_coll_collection | coll | collection | 1 |
| dto_document | obj | document | 234 |
| dto_per_org | per | org | 336 |
| dto_per_person | per | person | 405 |
Archive Docs
Folio Metadata
json
{
"folio": {
"code": "dc/6h442603m",
"label": "more",
"dataset_key": "dc/6h442603m",
"row_count": 976
},
"cores": [
{
"code": "coll",
"label": null,
"row_count": 1
},
{
"code": "obj",
"label": null,
"row_count": 234
},
{
"code": "per",
"label": null,
"row_count": 741
}
],
"dtoTables": [
{
"id": "dc/6h442603m: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": 1
},
{
"id": "dc/6h442603m: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": 234
},
{
"id": "dc/6h442603m: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": 336
},
{
"id": "dc/6h442603m: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": 405
}
],
"views": [
"dto_coll_collection",
"dto_document",
"dto_per_org",
"dto_per_person"
],
"generatedAt": "2026-06-29T18:31:32+00:00",
"metadata": {
"archivePreparedAt": "2026-06-29T18:31:32+00:00",
"schema": {
"tables": 7,
"properties": 48
},
"views": {
"views": 4
}
}
}
Overview
md
# Folio dc/6h442603m more - Dataset key: `dc/6h442603m` - Rows: 976 - Cores: 3 - Observed DTO tables: 4 ## Cores | Core | Label | Rows | | --- | --- | ---: | | `coll` | coll | 1 | | `obj` | obj | 234 | | `per` | per | 741 |
Observed Schema
md
# Observed Schema ## `dto_coll_collection` - Core: `coll` - DTO type: `collection` - Rows: 1 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_document` - Core: `obj` - DTO type: `document` - Rows: 234 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` | | | | `sourceUrl` | `?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 | | `citationUrl` | `?string` | | ItemField::CITATION_URL — deep link back to the source record (e.g. the NARA catalog page). Rendered as the "Original" link on the folio item page. | | `rights` | `?string` | | dcterms:rights | | `rightsUri` | `?string` | | dcterms:license URI (rightsstatements.org) | | `reuseAllowed` | `?string` | | dcterms:accessRights — e.g. "no restrictions", "creative commons" | | `language` | `?string` | | dcterms:language | | `identifierLocal` | `?string` | | dcterms:identifier — local accession number | | `creators` | `?array` | | dcterms:creator — array of names | | `institution` | `?string` | | Holding institution | | `collections` | `?array` | | Collection name(s) | | `subjects` | `?array` | filterable, facet | dcterms:subject — keyword/topical subjects (incl. AI keywords). A sidebar facet. | | `genreBasic` | `?array` | filterable, facet | Broad genre/form terms (MODS genre @basic) — e.g. ["Photographs"]. A sidebar facet. | | `genreSpecific` | `?array` | filterable, facet | Specific genre/form terms (MODS genre @specific) — e.g. ["Albumen prints"]. A facet. | | `typeOfResource` | `?array` | filterable, facet | MODS typeOfResource — coarse resource class, e.g. ["Still image"], ["Text"]. A facet. | | `iiifBase` | `?string` | | IIIF Image API base URL — use for AI vision and imgProxy resizing | | `thumbnailUrl` | `?string` | | | | `largeImageUrl` | `?string` | | | | `pageCount` | `?int` | sortable | Number of pages in the document. | | `source` | `string` | | Source of this data: import \| ai \| ocr \| human | | `extent` | `?string` | | | | `hasTranscription` | `bool` | | | | `subjectsGeographic` | `?array` | filterable, facet | dcterms:spatial — geographic subjects | | `country` | `?string` | filterable, facet | | | `city` | `?string` | filterable, facet | | | `state` | `?string` | | | | `county` | `?string` | | | ## `dto_per_org` - Core: `per` - DTO type: `org` - Rows: 336 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: 405 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` | | |
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_document limit 20; ``` ```sql select * from dto_per_org limit 20; ``` ```sql select * from dto_per_person limit 20; ```