Data Models

Linked Open Exhibition

Entity-relationship model for artworks, exhibitions, artists and catalogues, mapped to Wikidata, CIDOC CRM, Linked Art and LIDO, and loaded into Wikibase
Authors
Affiliations

Simon Worthington

HsH

TIB

Chloë Farr

University of Victoria

Published

November 5, 2026 00:00

Abstract

Catalogue exhibition contents using Linked Open Data and AI LLM assistants.

Keywords

Data Science, GLAM, Open Science

Overview

This page describes all entities of the Linked Open Exhibition model in one place:

Section Entity CSV template
Artwork artwork (with its terms: material, object type, place) import/artwork.csv, import/term.csv
Item in Exhibition the Exhibited at statement of an artwork import/exhibition-item.csv
Exhibition exhibition import/exhibition.csv
Artist person (artist, author) import/person.csv
Catalogue exhibition catalogue (book), publisher import/catalogue.csv, import/scan-location.csv

The single source of truth is wikibase-model.json. The class and property tables on this page are generated from it, and the same file drives the creation of Wikibase properties and class items (see catalogues/wikibase-artwork-load.ipynb). The CSV-to-property tables describe what the load notebook does with each template column.

Note

The field list is provisional (version 0.1). Properties are mapped to four schemas: Wikidata, CIDOC CRM 7.1.3, Linked Art and LIDO. Iconclass and AAT are used as controlled vocabularies for subjects and terms. The earlier Wikibase4Research column is no longer part of the model.

ER Diagram

erDiagram
    PERSON ||--o{ ARTWORK : "creates"
    OBJECT_TYPE ||--o{ ARTWORK : "classifies"
    MATERIAL }o--o{ ARTWORK : "made from"
    PLACE |o--o{ ARTWORK : "current location"
    PLACE |o--o{ EXHIBITION : "held at"
    ARTWORK ||--o{ EXHIBITED_AT : "has statement"
    EXHIBITION ||--o{ EXHIBITED_AT : "is referenced by"
    ARTWORK ||--o{ APPEARS_IN : "has statement"
    CATALOGUE ||--o{ APPEARS_IN : "is referenced by"
    EXHIBITION |o--o{ CATALOGUE : "documented in"
    PERSON }o--o{ CATALOGUE : "author"
    ORGANIZATION |o--o{ CATALOGUE : "publishes"

    ARTWORK {
        string local_id PK
        string instance_of
        string object_type
        string title
        string creator
        date inception
        string date_text
        string object_type_text
        string materials_text
        string main_subject
        string made_from_material
        string inventory_number
        string catalog_code
        string location
        decimal width
        decimal height
        decimal depth
        string part_of_series
        string depicts
        string iconclass
        url image_url
        string current_owner
        string commons_category
        string wikidata_qid
    }
    EXHIBITED_AT {
        string artwork_id FK
        string exhibition_id FK
        string catalogue_number "qualifier"
        string catalogue_page "qualifier"
        string title_as_exhibited "qualifier"
        string note "qualifier"
    }
    APPEARS_IN {
        string artwork_id FK
        string catalogue_id FK
        string scan_page "qualifier"
        string scan_region "qualifier"
        string extraction_method "qualifier"
        string review_status "qualifier"
        string note "qualifier"
    }
    EXHIBITION {
        string exhibition_id PK
        string title
        date start_date
        date end_date
        string venue_id FK
        string wikidata_qid
    }
    CATALOGUE {
        string catalogue_id PK
        string title
        string subtitle
        string publication_date
        string isbn13
        string dnb_edition_id
        url described_at_url
        url image_url
        string exhibition_id FK
        string wikidata_qid
    }
    PERSON {
        string person_id PK
        string name
        string wikidata_qid
        string gnd_id
    }
    ORGANIZATION {
        string term_id PK
        string label_en
        string label_de
        string wikidata_qid
    }
    MATERIAL {
        string term_id PK
        string label_en
        string label_de
        string aat_id
        string wikidata_qid
    }
    OBJECT_TYPE {
        string term_id PK
        string label_en
        string label_de
        string aat_id
        string wikidata_qid
    }
    PLACE {
        string term_id PK
        string label_en
        string label_de
        string wikidata_qid
    }

EXHIBITED_AT and APPEARS_IN are not items of their own. They are statements on the artwork whose value is the exhibition or catalogue, with the other columns as qualifiers. Multi-valued fields in the CSV files use ; as separator.

Properties for every class

These properties apply to all classes. They are not repeated in the sections below.

Property Label (EN / DE) Wikibase datatype Used on Wikidata CIDOC CRM Linked Art LIDO
local_id local ID / lokale ID external-id artwork, person, exhibition, catalogue, organization, material, object_type, place P1_is_identified_by (E42_Identifier) identified_by (Identifier) lido:lidoRecID
instance_of Type / Instanz von (Haupt-) wikibase-item artwork, person, exhibition, catalogue, organization, material, object_type, place P31 P2_has_type classified_as lido:category / lido:objectWorkType
wikidata_qid Wikidata item / Wikidata-QID external-id artwork, person, exhibition, catalogue, organization, material, object_type, place P1_is_identified_by (E42_Identifier) or owl:sameAs equivalent lido:objectID / lido:actorID / lido:conceptID (type wikidata)
equivalent_property equivalent property / äquivalente Eigenschaft url property, class

local_id is the ID from the CSV files (for example ART001, EXH001) and makes loads repeatable. IDs are unique across all files.

Artwork

An artwork is a human-made object created as a work of art. Persons, materials, object types and places are separate items that the artwork points to.

Classes

Class Label (EN / DE) Wikidata CIDOC CRM Linked Art LIDO
artwork artwork / Kunstwerk Q838948 E22_Human-Made_Object HumanMadeObject lido:category = Man-made object
person person / Person Q5 E21_Person Person lido:actorType = person
material material / Material Q214609 E57_Material Material lido:termMaterialsTech
object_type object type / Objekttyp Q151885 E55_Type Type lido:objectWorkType
place place / Ort Q17334923 E53_Place Place lido:placeID

Properties

Property Label (EN / DE) Wikibase datatype Used on Wikidata CIDOC CRM Linked Art LIDO
object_type Artwork type / Objekttyp (Art des Kunstwerks) wikibase-item artwork P31 (narrower instance of) P2_has_type (E55_Type) classified_as lido:objectWorkType
title Title / Titel monolingualtext artwork, exhibition, catalogue P1476 P102_has_title (E35_Title) identified_by (Name, classified_as title) lido:titleWrap/lido:titleSet/lido:appellationValue
creator Creator / Urheber/in wikibase-item artwork P170 P108i_was_produced_by > E12_Production > P14_carried_out_by produced_by.carried_out_by lido:eventSet (Production)/lido:eventActor
inception Date of creation / Entstehungsdatum time artwork P571 P108i_was_produced_by > E12_Production > P4_has_time-span produced_by.timespan lido:eventSet (Production)/lido:eventDate
date_text Date of creation (as stated) / Entstehungsdatum (Angabe) string artwork P3_has_note referred_to_by lido:eventDate/lido:displayDate
object_type_text Object type (as stated) / Objekttyp (Angabe) string artwork P3_has_note referred_to_by lido:objectWorkType/lido:term
materials_text Materials (as stated) / Material (Angabe) string artwork P3_has_note referred_to_by lido:eventMaterialsTech/lido:displayMaterialsTech
main_subject Subject / Hauptthema wikibase-item artwork P921 P129_is_about (E1_CRM_Entity) subject_of lido:subjectWrap/lido:subjectSet/lido:subject
materials Materials / Materialien wikibase-item artwork P186 P45_consists_of (E57_Material) made_of lido:eventMaterialsTech/lido:materialsTech
made_from_material Material / Material wikibase-item artwork P186 P45_consists_of (E57_Material) made_of lido:eventMaterialsTech/lido:materialsTech
height Height / Höhe quantity artwork P2048 P43_has_dimension (E54_Dimension, type height) dimension (classified_as height) lido:objectMeasurementsSet (measurementType height)
width Width / Breite quantity artwork P2049 P43_has_dimension (E54_Dimension, type width) dimension (classified_as width) lido:objectMeasurementsSet (measurementType width)
depth Depth / Tiefe quantity artwork P5524 P43_has_dimension (E54_Dimension, type depth) dimension (classified_as depth) lido:objectMeasurementsSet (measurementType depth)
inventory_number Inventory no. / Inventarnummer string artwork P217 P1_is_identified_by (E42_Identifier, type inventory number) identified_by (Identifier, classified_as inventory number) lido:repositorySet/lido:workID
catalog_code Catalogue no. / Katalogcode string artwork P528 P1_is_identified_by (E42_Identifier) identified_by (Identifier) lido:workID
location location / Standort wikibase-item artwork, exhibition P276 P55_has_current_location (E53_Place) current_location lido:repositorySet/lido:repositoryLocation
image_url Image / Bild url artwork, catalogue P6500 P138i_has_representation (E36_Visual_Item) representation (VisualItem, digitally_shown_by) lido:resourceWrap/lido:resourceSet/lido:resourceRepresentation/lido:linkResource
part_of_series Series / Teile einer Serie wikibase-item artwork P179 P108_has_produced (E65_Creation) part_of_series lido:relatedWorkSet/lido:relatedWork
depicts Depicted motif / Darstellt wikibase-item artwork P180 P129_is_about depicts lido:subjectWrap/lido:subjectSet/lido:subject
iconclass Iconclass / stellt Iconclass-Notation dar external-id artwork P1257 P62_depicts (E55_Type, Iconclass concept) shows.represents (Type) lido:subjectWrap/lido:subjectSet/lido:subject/lido:subjectConcept/lido:conceptID
exhibited_at Exhibited at / Ausgestellt in wikibase-item artwork P608 P9i_forms_part_of (E7_Activity) part_of / shown_at lido:eventSet/lido:event
current_owner Owner / Aktueller Eigentümer wikibase-item artwork P127 P50_has_current_keeper current_owner lido:repositorySet/lido:repositoryName
commons_category Commons category / Commons-Kategorie url artwork P373 P138i_has_representation related lido:resourceWrap/lido:resourceSet
appears_in_catalogue Appears in catalogue / Kommt im Katalog vor wikibase-item artwork P1343 P70i_is_documented_in referred_to_by

Controlled vocabularies

Vocabulary Used for Stored as
Iconclass Subject of an artwork (iconclass) External identifier, notation such as 71H7
AAT (Getty) Materials and object types (aat_id) External identifier, numeric ID
GND Persons (gnd_id) External identifier
Wikidata Cross-reference for all entity types (wikidata_qid) External identifier

Dimensions

Height, width and depth are stored as Wikibase quantity values in centimetres. The unit is a local item “centimetre” created by the load notebook, which links to Wikidata unit Q174728 through the equivalent-property mechanism.

Terms: materials, object types, places, organizations

Materials, object types, places and organizations are items of their own. They are listed in import/term.csv, one row per term.

CSV column Wikibase property (model key) Notes
term_id local ID (local_id) for example MAT001
term_type Type (instance_of) material, object_type, place or organization; the class item of that name
label_en, label_de item label German label falls back to the English one
aat_id AAT ID (aat_id) optional, for materials and object types
wikidata_qid Wikidata item (wikidata_qid) optional

CSV source fields

The artworks are loaded from import/artwork.csv, one row per artwork. Persons and terms are referenced by ID from import/person.csv and import/term.csv.

CSV column Wikibase property (model key) Required Notes
artwork_id local ID (local_id) Yes for example ART001
title Title (title) Yes monolingual text, language mul
object_type_id Type (instance_of) Yes ID from term.csv with term_type object_type; the loader adds it as a second Type statement next to the class artwork, and does not use the separate object_type property
creator_id Creator (creator) Yes ID from person.csv
date_created Date of creation (inception) Yes YYYY, YYYY-MM or YYYY-MM-DD; a range such as 1997-98 is loaded with its start year and a warning
material_ids Material (made_from_material) Yes ;-separated IDs from term.csv with term_type material, one statement each
height_cm Height (height) Yes centimetres
width_cm Width (width) Yes centimetres
depth_cm Depth (depth) No centimetres
inventory_number Inventory no. (inventory_number) No museum or collection ID
current_location_id location (location) No ID from term.csv with term_type place
image_url Image (image_url) No image URL
iconclass_notations Iconclass (iconclass) No ;-separated notations
wikidata_qid Wikidata item (wikidata_qid) No
date_text Date of creation (as stated) (date_text) No date exactly as printed in the source
object_type_text Object type (as stated) (object_type_text) No object type exactly as printed in the source
materials_text Materials (as stated) (materials_text) No materials and technique exactly as printed in the source

The *_text fields keep the source wording, so a reviewer can compare it with the normalised statements.

Fields in the model without a column in artwork.csv (main_subject, depicts, part_of_series, catalog_code, current_owner, commons_category) are defined in the Wikibase but not loaded yet. The link to an exhibition comes from exhibition-item.csv and the link to a catalogue from scan-location.csv.

Item in Exhibition

An artwork is linked to an exhibition with an Exhibited at statement on the artwork. The details that only the exhibition catalogue knows (catalogue number, catalogue page, the title as printed, a note) are added to that statement as qualifiers. There is no separate exhibition item. The model is the association between the Artwork and Exhibition models.

Why qualifiers instead of a separate item?

The catalogue details belong to one artwork in one exhibition. Qualifiers on the Exhibited at statement keep them next to the statement, work for artworks that appear in several exhibitions (one statement per exhibition), and follow the usual Wikidata pattern for exhibition history (P608).

Properties

Property Label (EN / DE) Wikibase datatype Used on Wikidata CIDOC CRM Linked Art LIDO
exhibited_at Exhibited at / Ausgestellt in wikibase-item artwork P608 P9i_forms_part_of (E7_Activity) part_of / shown_at lido:eventSet/lido:event
catalogue_number Catalogue number / Katalognummer string qualifier P528 P1_is_identified_by (E42_Identifier, type catalogue number) identified_by (Identifier, classified_as catalogue number) lido:workID (type catalogue number)
catalogue_page Page(s) / Seite(n) string qualifier P304 P3_has_note (E62_String, catalogue page) referred_to_by (LinguisticObject, classified_as page) lido:relatedWorkSet/lido:relatedWork
title_as_exhibited title as exhibited / Titel in der Ausstellung string qualifier P1_is_identified_by (E35_Title) on the showing identified_by (Name) on the part activity lido:titleSet (type exhibited as)
note note / Anmerkung string qualifier P3_has_note referred_to_by (LinguisticObject) lido:descriptiveNoteValue

Example

Baldessari catalogue (Sprengel Museum Hannover), artwork ART002:

Statement Value
Exhibited at EXH001 (John Baldessari, Sprengel Museum Hannover)
qualifier Page(s) 14; 51

CSV template

import/exhibition-item.csv lists which artwork was shown in which exhibition. The loader turns each row into an Exhibited at statement on the artwork, with the catalogue columns as qualifiers.

CSV column Wikibase property (model key) Remarks
artwork_id the artwork item ID from artwork.csv
exhibition_id Exhibited at (exhibited_at) ID from exhibition.csv
catalogue_number Catalogue number (catalogue_number) qualifier
catalogue_page Page(s) (catalogue_page) qualifier
title_as_exhibited Title as exhibited (title_as_exhibited) qualifier
notes note (note) qualifier

Corrections to the earlier draft

Earlier mapping Problem Now
Exhibited at: P1431 P1431 is “executive producer” P608 “exhibition history”
Depth: P2610 P2610 is “thickness” P5524 “depth”
Acquisition: P1830, provenance: P2670 Both properties have other meanings Removed from this model
Instance of: Q3305213 Q3305213 is “painting” Q838948 “work of art” plus an object type item
CIDOC location: P87 P87 is “is identified by” for places P55 “has current location”
Series: P108 P108 is “has produced” Removed from this model
Wikibase4Research column Dropped from scope Linked Art and LIDO columns

Exhibition

An exhibition is a temporary presentation of artworks at a venue. The artworks point to the exhibition with Exhibited at; the exhibition points to its catalogues with Exhibition catalogue.

Class

Class Label (EN / DE) Wikidata CIDOC CRM Linked Art LIDO
exhibition exhibition / Ausstellung Q464980 E7_Activity Activity lido:eventType = Exhibition (lido00045)

Properties

Property Label (EN / DE) Wikibase datatype Used on Wikidata CIDOC CRM Linked Art LIDO
title Title / Titel monolingualtext artwork, exhibition, catalogue P1476 P102_has_title (E35_Title) identified_by (Name, classified_as title) lido:titleWrap/lido:titleSet/lido:appellationValue
location location / Standort wikibase-item artwork, exhibition P276 P55_has_current_location (E53_Place) current_location lido:repositorySet/lido:repositoryLocation
start_date Start date / Beginn time exhibition P580 P4_has_time-span > P82a_begin_of_the_begin timespan.begin_of_the_begin lido:eventDate/lido:date/lido:earliestDate
end_date End date / Ende time exhibition P582 P4_has_time-span > P82b_end_of_the_end timespan.end_of_the_end lido:eventDate/lido:date/lido:latestDate
exhibition_catalogue Exhibition catalogue / Ausstellungskatalog wikibase-item exhibition P1343 P70i_is_documented_in subject_of

The shared properties local_id, instance_of and wikidata_qid are listed above.

Example

Exhibition EXH001 (Sprengel Museum Hannover, Q141747732):

Property Value
Title BALDESSARI : While something is happening here, something else is happening there : Works 1988–1999
Start date 1999-09-26
End date 2000-01-02
location PLC001 (Sprengel Museum Hannover)
Exhibition catalogue CAT001

CSV source fields

The exhibitions are loaded from import/exhibition.csv, one row per exhibition.

CSV column Wikibase property (model key) Required Notes
exhibition_id local ID (local_id) Yes for example EXH001
title Title (title) Yes monolingual text, language mul; also used as item label
start_date Start date (start_date) No YYYY, YYYY-MM or YYYY-MM-DD
end_date End date (end_date) No same formats
venue_id location (location) No ID from term.csv with term_type place
wikidata_qid Wikidata item (wikidata_qid) No

Exhibition catalogue has no column here. The loader adds it from the exhibition_id column of catalogue.csv, after the catalogues are loaded.

Not yet modelled

The earlier draft of this page listed further Wikidata properties. They are not in wikibase-model.json and are not loaded. They can be added to the JSON file when needed, which then also adds them to the tables above.

Field Wikidata CIDOC CRM
Curator P1640 P14_carried_out_by
Participant P710 P11_had_participant
Official website P856 P1_is_identified_by
Organizer P664 P14_carried_out_by
Country P17 P7_took_place_at
Language P407 P72_has_language
Theme P921 P129_is_about
Sponsor P859 none
Number of visitors P1174 none
Commons category P373 P1_is_identified_by

Artist

Artists, catalogue authors and other people are items of the class person. The class is deliberately small: a name (the item label) and identifiers. Biographical data stays in Wikidata and is reachable through wikidata_qid.

Class

Class Label (EN / DE) Wikidata CIDOC CRM Linked Art LIDO
person person / Person Q5 E21_Person Person lido:actorType = person

Properties

Property Label (EN / DE) Wikibase datatype Used on Wikidata CIDOC CRM Linked Art LIDO
gnd_id GND ID / GND-ID external-id person P227 P1_is_identified_by (E42_Identifier) equivalent / identified_by lido:actorID (type GND)

The shared properties local_id, instance_of and wikidata_qid are listed above. A person is used as creator of an artwork and as author of a catalogue.

Example

Person PER001:

Property Value
Label John Baldessari
Wikidata item Q683378
GND ID 118506153

CSV source fields

The persons are loaded from import/person.csv, one row per person.

CSV column Wikibase property (model key) Notes
person_id local ID (local_id) for example PER001
name item label used as English and German label
wikidata_qid Wikidata item (wikidata_qid) optional
gnd_id GND ID (gnd_id) optional

Not yet modelled

The earlier draft of this page listed biographical properties. They are not in wikibase-model.json and are not loaded; the Wikidata item is the place for them.

Field Wikidata CIDOC CRM
Given name P735 P1_is_identified_by (E82_Appellation)
Family name P734 P1_is_identified_by (E82_Appellation)
Occupation P106 P2_has_type (E55_Type)
Date of birth P569 P82_at_some_time_within (E52_Time-Span)
Date of death P570 P82_at_some_time_within (E52_Time-Span)
Citizenship P27 P2_has_type (E55_Type)
Getty ULAN P245 P1_is_identified_by (E42_Identifier)
VIAF P214 P1_is_identified_by (E42_Identifier)
ISNI P213 P1_is_identified_by (E42_Identifier)

Catalogue

A catalogue is a published book, for example the one that accompanies an exhibition. Catalogues are also the source of the artwork records: each artwork records the catalogue it was taken from.

Classes

Class Label (EN / DE) Wikidata CIDOC CRM Linked Art LIDO
catalogue catalogue / Katalog Q2352616 E31_Document LinguisticObject
organization organization / Organisation Q43229 E74_Group Group lido:actorType = corporation

Properties

Property Label (EN / DE) Wikibase datatype Used on Wikidata CIDOC CRM Linked Art LIDO
title Title / Titel monolingualtext artwork, exhibition, catalogue P1476 P102_has_title (E35_Title) identified_by (Name, classified_as title) lido:titleWrap/lido:titleSet/lido:appellationValue
image_url Image / Bild url artwork, catalogue P6500 P138i_has_representation (E36_Visual_Item) representation (VisualItem, digitally_shown_by) lido:resourceWrap/lido:resourceSet/lido:resourceRepresentation/lido:linkResource
subtitle Subtitle / Untertitel string catalogue P1680 P102_has_title (E35_Title)
author Author / Autor wikibase-item catalogue P50 E39_Actor created_by
publisher Publisher / Verleger wikibase-item catalogue P123 E39_Actor
publication_date Publication date / Erscheinungsdatum time catalogue P577 E52_Time-Span
isbn13 ISBN-13 / ISBN-13 external-id catalogue P212 E42_Identifier
dnb_edition_id DNB edition ID / DNB-Nummer external-id catalogue P1292 E42_Identifier
described_at_url Described at URL / Beschrieben unter URL url catalogue P973 E42_Identifier
catalogue_of Catalogue of / Katalog zu wikibase-item catalogue P921 P70_documents about

The shared properties local_id, instance_of and wikidata_qid are listed above.

CSV source fields

The fields above are loaded from import/catalogue.csv (one row per catalogue) by the notebook catalogues/wikibase-artwork-load.ipynb.

CSV column Wikibase property (model key) Remarks
catalogue_id local ID (local_id) for example CAT001
(class) Type (instance_of) the class item catalogue, equivalent to Wikidata Q2352616
title Title (title) monolingual text
subtitle Subtitle (subtitle) string, as printed
author_ids Author (author) ;-separated IDs from person.csv, one statement each
publisher_id Publisher (publisher) ID from term.csv with term_type organization
publication_date Publication date (publication_date) YYYY or YYYY-MM-DD
isbn13 ISBN-13 (isbn13) checked for a valid check digit
dnb_edition_id DNB edition ID (dnb_edition_id) Wikidata P1292; used instead of GND, because the DNB gives books an IDN, not a GND ID
described_at_url Described at URL (described_at_url) for example https://d-nb.info/957409494
image_url Image (image_url) cover image URL (optional)
exhibition_id Catalogue of (catalogue_of) links the catalogue to its exhibition from exhibition.csv; the exhibition gets the inverse statement Exhibition catalogue (exhibition_catalogue)
wikidata_qid Wikidata item (wikidata_qid) optional

The first entry, CAT001, is the catalogue of the exhibition EXH001 (“BALDESSARI : While something is happening here, something else is happening there : Works 1988–1999”), DNB record 957409494. The artworks point to the same exhibition with Exhibited at, so the exhibition item connects the artworks and the catalogue.

Which catalogue an artwork appears in, and where

Each artwork records the catalogue it appears in with an Appears in catalogue statement. For the Baldessari artworks this is CAT001, because that is the catalogue the records were taken from. The statements come from import/scan-location.csv, one row per artwork and catalogue (and per page, once pages are known). The columns after catalogue_id are optional. When they are filled in, they let a reviewer check the extraction against the scan. An artwork on several pages has several rows. The loader turns each row into a statement on the artwork (pointing to the catalogue item) with the other columns as qualifiers.

Property Label (EN / DE) Wikibase datatype Used on Wikidata CIDOC CRM Linked Art LIDO
appears_in_catalogue Appears in catalogue / Kommt im Katalog vor wikibase-item artwork P1343 P70i_is_documented_in referred_to_by
scan_page Scan page / Scanseite string qualifier P3_has_note (E62_String, scan page) part_of (Canvas)
scan_region Scan region / Scanbereich string qualifier P3_has_note (E62_String, region) FragmentSelector
extraction_method Extraction method / Extraktionsmethode string qualifier P3_has_note (E62_String, method)
review_status Review status / Prüfstatus string qualifier P3_has_note (E62_String, review status)
note note / Anmerkung string qualifier P3_has_note referred_to_by (LinguisticObject) lido:descriptiveNoteValue
CSV column Wikibase property (model key) Remarks
artwork_id the artwork item ID from artwork.csv
catalogue_id Appears in catalogue (appears_in_catalogue) ID from catalogue.csv
scan_page Scan page (scan_page) optional. Position of the page in the scan, first page = 1. This is not the printed page number, which stays in catalogue_page of exhibition-item.csv; the two usually differ by an offset
scan_region Scan region (scan_region) optional, see below
extraction_method Extraction method (extraction_method) for example plan-c qwen3-vl:8b, plan-b hocr, manual
review_status Review status (review_status) unreviewed, confirmed, corrected or rejected
notes note (note) optional comment from the reviewer

Region format. scan_region uses the W3C Media Fragments syntax xywh=percent:x,y,width,height, for example xywh=percent:10,20,40,8. Percent values refer to the page size, so they stay valid for any image resolution. xywh=pixel:x,y,width,height is also accepted. The same syntax is used by IIIF and the Web Annotation model, so the regions can later be shown on a viewer without conversion. The corners from hOCR (bbox x0 y0 x1 y1) or ALTO (HPOS, VPOS, WIDTH, HEIGHT) have to be converted to x, y, width, height first.

The rows in scan-location.csv currently only link every artwork to CAT001. Pages, regions, extraction method and review status will be added when the extraction data (plan B) is ready.

Best practices for catalogue records

  1. Use Wikidata items: link to existing Wikidata items for authors and organizations to enable cross-institutional discovery.
  2. ISBN validation: ISBN-13 numbers must have a valid check digit. Use the format with hyphens (978-X-XXXX-XXXX-X) for readability.
  3. Publication dates: use ISO 8601 (YYYY-MM-DD) where precise dates are available, or just YYYY for year-only precision.
  4. Multilingual titles: where a catalogue is published in several languages, add further title statements as monolingual text.
  5. URL persistence: prefer persistent URLs (DOI or similar) over temporary web links for described_at_url.

Related standards and references

For updates to this data model or suggestions for improvement, please contact the NFDI4Culture Linked Open Exhibition project team or contribute via GitHub.

This documentation was created with assistance from GitHub Copilot. The model was aligned against CIDOC CRM, Linked Art, LIDO and Wikidata through AI-assisted analysis and formatting.