Table 1
Artists.3
| VARIABLE | TYPE | DESCRIPTION AND REASONING |
|---|---|---|
| Person Key | Text | A unique identification code for each artist. Same field as Person Key in the Artworks table. |
| Family Name | Text | Parsed from the original Name field (which became Full Name for this research) provided in the Open Data table. |
| Full Name | Text | Name used for the artist or the group of artists (collective). |
| Given Name | Text | Parsed from the original Name field (which became Full Name for this research) provided in the Open Data table. |
| Name Iterations | Text | Other names for the same artist that were encountered during this research. |
Table 2
Artworks.
| VARIABLE | TYPE | DESCRIPTION AND REASONING |
|---|---|---|
| Acquisition Initiative | Text | Indicates whether the artwork was acquired as part of a special acquisition initiative. |
| Artwork Key(ID Number) | Text | A unique identifier assigned by the Art Bank to each work in the collection. Same field as Artwork Key in the Artists table. |
| Artwork Title | Text | Title of the artwork as given by the artist(s). |
| Dated-ness | Text | Retainer for any ambiguity from the Year of Creation. |
| Divested? | Text | Used to identify artworks no longer in the Art Bank’s collection. |
| Full Name | Text | Name used for the artist or the group of artists (collective). |
| Image | Hyperlink | A link to an image for each artwork currently in the collection. |
| Medium | Text | The medium of the artwork, as specified by the artist(s). |
| Person Key | Text | A unique identification code for each artist. Same field as Person Key in the Artists table. |
| Series Name | Text | Used for artworks that are a series of individually entered pieces. |
| Year of Acquisition | Number | The year that the artwork was acquired by the Art Bank. ID Number was used to extract the Year of Acquisition for each artwork. |
| Year of Creation | Number | When the artwork was created, as specified by the artist(s). See Dated-ness as this data was cleaned. |
| Year of Creation vs. Year of Acquisition | Number | Measures the difference between an artwork’s Year of Acquisition and their creation. |
Table 3
Events.
| VARIABLE | TYPE | DESCRIPTION AND REASONING |
|---|---|---|
| Artwork Key(ID Number) | Text | A unique identifier assigned by the Art Bank to each work in the collection. Same field as Artwork Key in the Artists table. |
| Client | Text | The name of the institution/partner involved with the event. |
| Display Instance | Number | The number of times the artwork has been displayed, including the focus event. |
| Event Name | Text | The name of the display event. If the event was not one of the 38 focus events, it is named “Other”. |
| Installation Date | Number | The date that the artwork was installed for the event. |
| Link | Hyperlink | A link associated with the event. |
Location
| Text & Number | Various levels of data for the location where the event took place. |
| Notes | Text | Any notes encountered on the event during research that do not fit in with other fields. |
| Phase | Text | The thesis research phase that the event aligns with. |
| Return Date | Number | The date that the artwork was returned from the event. |
| Sources | Text | Resources referenced in researching this event. |
| Status | Text | The type of event. Types include exhibitions, special projects, rentals, and loans. |
Figure 1
Relationships between tables in Access. The TrackingHistory query extracts data for the 38 events this project focuses on.