Install Folio
bin/console folio:pull --dataset smith/fbr
Objects
obj
Link Types
| Forward | Reverse | Links |
|---|---|---|
|
per
created
obj
created
|
obj
created_by
per
created_by
|
554 |
|
coll
contains
obj
contains
|
obj
belongs_to
coll
belongs_to
|
3,404 |
Observed Schema
| Name | Core | Type | Rows |
|---|---|---|---|
| dto_coll_collection | coll | collection | 345 |
| dto_correspondence | obj | correspondence | 66 |
| dto_drawing | obj | drawing | 64 |
| dto_map | obj | map | 73 |
| dto_object | obj | object | 1,284 |
| dto_per_org | per | org | 256 |
| dto_per_person | per | person | 15 |
| dto_photograph | obj | photograph | 29 |
| dto_postcard | obj | postcard | 1 |
Archive Docs
Folio Metadata
json
{
"folio": {
"code": "smith/fbr",
"label": "FBR",
"dataset_key": "smith/fbr",
"row_count": 2133
},
"cores": [
{
"code": "coll",
"label": null,
"row_count": 345
},
{
"code": "obj",
"label": null,
"row_count": 1517
},
{
"code": "per",
"label": null,
"row_count": 271
}
],
"dtoTables": [
{
"id": "smith/fbr: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": 345
},
{
"id": "smith/fbr: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": 66
},
{
"id": "smith/fbr:dto_drawing",
"name": "dto_drawing",
"kind": "dto",
"core_code": "obj",
"dto_type": "drawing",
"label": "Drawing",
"description": "DTO for drawn works: pencil, ink, charcoal, watercolour, pastel, etc.\nCovers any work where drawing is the primary medium.\nSubclass for more specific drawn types (CartoonDto, SketchDto, etc.)\n/",
"row_count": 64
},
{
"id": "smith/fbr:dto_map",
"name": "dto_map",
"kind": "dto",
"core_code": "obj",
"dto_type": "map",
"label": "Map",
"description": null,
"row_count": 73
},
{
"id": "smith/fbr: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": 1284
},
{
"id": "smith/fbr: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": 256
},
{
"id": "smith/fbr: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": 15
},
{
"id": "smith/fbr:dto_photograph",
"name": "dto_photograph",
"kind": "dto",
"core_code": "obj",
"dto_type": "photograph",
"label": "Photograph",
"description": null,
"row_count": 29
},
{
"id": "smith/fbr:dto_postcard",
"name": "dto_postcard",
"kind": "dto",
"core_code": "obj",
"dto_type": "postcard",
"label": "Postcard",
"description": null,
"row_count": 1
}
],
"views": [
"dto_coll_collection",
"dto_correspondence",
"dto_drawing",
"dto_map",
"dto_object",
"dto_per_org",
"dto_per_person",
"dto_photograph",
"dto_postcard"
],
"generatedAt": "2026-06-29T18:03:18+00:00",
"metadata": {
"archivePreparedAt": "2026-06-29T18:03:17+00:00",
"schema": {
"tables": 12,
"properties": 81
},
"views": {
"views": 9
}
}
}
Overview
md
# Folio smith/fbr FBR - Dataset key: `smith/fbr` - Rows: 2,133 - Cores: 3 - Observed DTO tables: 9 ## Cores | Core | Label | Rows | | --- | --- | ---: | | `coll` | coll | 345 | | `obj` | obj | 1,517 | | `per` | per | 271 |
Observed Schema
md
# Observed Schema ## `dto_coll_collection` - Core: `coll` - DTO type: `collection` - Rows: 345 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: 66 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 | | `rights` | `?string` | | dcterms:rights | | `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` | | | | `creators` | `?array` | | dcterms:creator — array of names | ## `dto_drawing` - Core: `obj` - DTO type: `drawing` - Rows: 64 DTO for drawn works: pencil, ink, charcoal, watercolour, pastel, etc. Covers any work where drawing is the primary medium. Subclass for more specific drawn types (CartoonDto, SketchDto, 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 | | `rights` | `?string` | | dcterms:rights | | `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 | | `creators` | `?array` | | dcterms:creator — array of names | ## `dto_map` - Core: `obj` - DTO type: `map` - Rows: 73 | 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 | | `rights` | `?string` | | dcterms:rights | | `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 | ## `dto_object` - Core: `obj` - DTO type: `object` - Rows: 1,284 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 | | `rights` | `?string` | | dcterms:rights | | `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 | | `iiifBase` | `?string` | | IIIF Image API base URL — use for AI vision and imgProxy resizing | | `largeImageUrl` | `?string` | | | ## `dto_per_org` - Core: `per` - DTO type: `org` - Rows: 256 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: 15 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: 29 | 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 | | `rights` | `?string` | | dcterms:rights | | `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: 1 | 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 | | `rights` | `?string` | | dcterms:rights | | `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_correspondence limit 20; ``` ```sql select * from dto_drawing limit 20; ``` ```sql select * from dto_map 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; ```