{
    "folio": {
        "code": "nara/black-soldier-pensions",
        "label": "NARA \u2014 USCT (United States Colored Troops) records",
        "dataset_key": "nara/black-soldier-pensions",
        "row_count": 6
    },
    "cores": [
        {
            "code": "doc",
            "label": null,
            "row_count": 6
        }
    ],
    "dtoTables": [
        {
            "id": "nara/black-soldier-pensions:dto_doc_document",
            "name": "dto_doc_document",
            "kind": "dto",
            "core_code": "doc",
            "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": 6
        }
    ],
    "views": [
        "dto_doc_document"
    ],
    "generatedAt": "2026-06-26T18:30:51+00:00",
    "metadata": {
        "builtAt": "2026-06-26T18:30:50+00:00",
        "schema": {
            "tables": 2,
            "properties": 11
        },
        "views": {
            "views": 1
        }
    }
}

# Folio nara/black-soldier-pensions

NARA — USCT (United States Colored Troops) records

- Dataset key: `nara/black-soldier-pensions`
- Rows: 6
- Cores: 1
- Observed DTO tables: 1

## Cores

| Core | Label | Rows |
| --- | --- | ---: |
| `doc` | doc | 6 |

# Observed Schema

## `dto_doc_document`

- Core: `doc`
- DTO type: `document`
- Rows: 6

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` |  |  |
| `title` | `?string` |  | dcterms:title |
| `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. |
| `thumbnailUrl` | `?string` |  |  |
| `largeImageUrl` | `?string` |  |  |
| `imageCount` | `?int` | filterable, facet, sortable | Number of images associated with the item. |
| `hasImages` | `?bool` | filterable, facet | Whether the item has at least one image; facet for filtering out image-less objects. |
| `source` | `string` |  | Source of this data: import \| ai \| ocr \| human |
| `hasTranscription` | `bool` |  |  |

# 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_doc_document limit 20;
```