Spencer Database Views and Fields

dvAddress
  • AdrId
  • Institution
  • FirstName
  • LastName
  • Department
  • StreetAddress
  • City
  • State
  • ZipCode
  • Country
dvArtistDating
  • KudID
  • Type
  • Sorting
  • Date
  • Country
  • Places
  • Remarks
  • KueID
dvCollection
  • ObjID
  • Title
  • YearFrom
  • YearTo
  • Date
  • ObjectType
  • Dimensions
  • MaterialTechnique
  • Continent
  • Subgroup
  • GeogAssoc
  • AccessionNum
  • CreditLine
  • KueID
  • MulID
dvExhibition
  • AusID
  • ExhibitionName
  • ExhibLocation
  • ExhibitionYear
  • DateFrom
  • DateTo
  • ExhibitionType
  • RecordType
  • CuratedBy
  • ExhibitionDescription
dvExhibitionObjectLinks
  • AobID
  • AusID
  • ObjID
  • DidacticLabel
dvObjectKeyword
  • StiID
  • Keyword
dvObjectKeywordLinks
  • OstID
  • ObjID
  • StiID
dvParticipants
  • KueID
  • SortName
  • FirstName
  • RecordType
  • Ethnicity
  • Gender
  • AdrID
dvParticipantsObjectLinks
  • OkuID
  • Role
  • ObjID
  • KueID
dvParticipantsMultipleNames
  • KmuID
  • KueID
  • ArtistAlias

Fields that are enumerated types:

dvArtistDating.Type: { Active Country, Date of Birth, Date of Death, Life/Active Dates, Location, Place of Birth, Place of Death }
 
dvCollection.ObjectType: { Asian paintings, Decorative Arts, Decorative arts, General, Textile, agricultural equipment, animal procurement equipment, animal work equipment, architectural elements, armor, artists' books, books, calligraphy, clocks and watches, coins/currency, containers, costume, costume accessories, coverings, culinary containers, culinary equipment, cut-paper work, cutlery and flatware, digital art, drawings, firearms, footwear, furniture and furnishings, general, hair ornaments, hardware, inro and netsuke, installations, jewelry, lighting devices, masks, measuring devices, medals, mosaics, musical instruments, paintings, periodicals, photographs, plaques, plaquettes, portfolio boxes, printmaking equipment, prints, raw material, recreational artifacts, rubbings, rugs, sculpture, seals, smoking and tobacco equipment, stencils, textile fragments, tools, undefined, video art, watercolors and gouaches, watercraft and equipment, weapons }
 
dvCollection.MaterialTechnique: { à la poupée, abalone shell, acetate film, acorn, acrylic, acrylic paint, acrylic urethane, adhesive tape, agate, agate ware, airbrushing, alabaster, albumen print, alkaline glazing, alpaca skin, alpaca wool, aluminum, amate paper, amber, Amberina glass, ambrotype, amethyst, angora fur, aniline dye, animal fiber, animal hair, anteater hair, antelope hide, antimony, antler, appliqué, aquatint, armadillo, ash glaze, asphaltum, autochrome print, aventurine glass, Bakelite™, bald eagle feather, bald eagle feathers, ballpoint pen, balsa wood, bamboo, banana fiber, banana fiber cloth, bark, bark cloth, bark string, bas-relief, bast, batik, batiste, beading, beads, bean tree bark, bean tree wood, beans, bear grass, bear skin, beech wood, beeswax, Berlin woolwork, bighorn sheep horn, bingata, birch bark, bird quill, bird skin, bird’s-eye maple wood, bison hair, Bizen ware, black-on-black pottery, blind embossing, blind stamping, blister pearl, block printing, blown glass, boar bristle, boar hair, boar tusk, board, bone, boxwood, braiding, brass, brass tacks, bristle, britannia metal, brocade, brocading, brocatelle, bronze, buckskin, buffalo hide leather, buffalo horn, burlap, burning, burnishing, cabochons, calico, calotype, camel dung, camel hide, cameo glass, cane, canvas, canvas board, caraguata fiber, carbon print, cardboard, carving, case binding, casein, cashmere, cashmere wool, cassowary quills, cast iron, casting, catlinite, cedar bark, cedar bark string, cedar root, cedar wood, celadon glazing, ceramic, chalcedony, charcoal, charcoal pencil, chenille, cherry bark, cherry wood, chestnut wood, chiaroscuro, chiffon, chine collé, Chinese ink, chintz, chiné technique, chipping, chromogenic color print, chromolithograph, Cibachrome™, claw, clay, cliché-verre, cloisonné, cloth, cobalt glass, coconut, coconut fiber, codfish skin, coiling, collage, collagraph, collodion, collodion print, collotype, color aquatint, color engraving, color etching, color intaglio, color linocut, color lithograph, color mezzotint, color monotype, color offset lithograph, color print, color screen print, color transparency, color wood engraving, color woodcut, colored pencil, composite photograph, composition board, computer-assisted, contact print, Conté crayon, copper, copy paper, Cor-Ten steel, coral, cord, cork, cornhusk, cotton, cotton thread, cottonwood, couching, counterproof, cow hide, crayon, creamware, crepe, crewelwork, crocheting, Cromargan®, cross-stitching, crystal, crystal glass, cut glass, cutting, cyanotype, daguerreotype, damask, darning, decal, deer antler, deer fur, deer hair, deer hoof, deer skin, deerskin, Dehua porcelain, delftware, demantoid garnet, diamond, digital photograph, dilute albumen print, dimity, Ding ware, dot matrix print, dry collodion negative, drying, drypoint, duan stone, dung, DVD, dye, dye transfer print, dyeing, dôgubori, earthenware, East Indian rosewood, ebony wood, egg tempera, Ektachrome™, eland tail hair, elephant hide, elephant ivory, elephant tail hair, elephant tusk, elk fur, elk teeth, elk tooth, elm wood, embossing, embroidering, emu feather, enamel, engraving, ermine fur, etching, faience, faille, Favrile glass™, feathers, felt, fiber, filigree, fish skin, flint glass, flowers, foam rubber, foil, freshwater pearl, Fresson print, frottage, fruitwood, fur, garnet, gauze, gelatin dry plate negative, gelatin silver print, gesso, giclée, gilding, gillotage, gimp, giraffe tail, glass, glazing, glitter, glyphograph, goat horn, goat skin, goat skin leather, gold, gold chloride print, gold leaf, gold plating, gouache, gourd, graphite, grass, grease pencil, gum bichromate print, gum resin, gypsograph, gypsum, Hagi, hair, hairseal fur, halftone, hammering, hand coloring, hardboard, harmonograph, heightening, heliogravure, heliotype, hemp, hemp fiber, heron feathers, hide, hikibori, hiramaki-e, Hispano-Moresque ware, hoof, hooking, horn, hornbill ivory, horse hair, horsetail root, humba fiber, ikat, illustration board, Imari porcelain, imbricating, impressed watermark, impressing, incising, India ink, ink, inkjet print, inlay, inorganic pigment, intaglio, Iris print, iron, ironstone, Ives polychrome, ivory, Jackfield ware, jacquard, jade, jadeite, Japanese ink, Japanese paper, jasperware, jelutong wood, jet, Jian ware, Kakiemon porcelain, kallitype, kangaroo fur, kangaroo hide, Karatsu ware, katazome, kesi, kiribori, knitting, knotting, Kodachrome™, Kodalith, lace, lacquer, laid paper, laminating, lampas, lampblack, lamé, lapis lazuli, lawn, lead, lead glass, lead glaze, leather, leopard hide, letterpress, lift-ground, light-and-shade watermark, lime glass, limestone, linden wood, line block (photomechanical relief print), line engraving, linen, lining, linocut, lithograph, lizard skin, llama skin, llama wool, loom beading, lusterware, lājvardina, macrame, maculature, maguey yarn, mahogany wood, maiolica, maple wood, marble, marquisette, marsupial fur, martynia, Masonite™, mesh, mesquite wood, metal, metal cut, metal-wrapped thread, mezzotint, mica, mixed media, mohair, mold-blown glass, molding, monkey teeth, monkey tooth, monkeypod wood, monofilament, monoprint, monotype, montage, moose hair, moose hide, mother of pearl, mountain goat horn, mountain goat wool, mountain lion skin, mulberry paper, muskrat fur, muslin, Mylar™, narwhal ivory, needlepoint, needleworking, neon, nephrite, net, netting, nickel alloy, nickel silver, niello print, nylon, oak, oak fiber, obsidian, offset lithograph, oil, on board, on canvas, on cardboard, on cotton, on gauze, on hardboard, on illustration board, on linen, on panel, on paper, on silk, on wool, onionskin paper, onyx glass, opal glass, opaque white glass, opossum fur, Oribe stoneware, otter fur, otter skin, overglazing, ox tail hair, paint, palladium print, palm fiber, palm leaf fiber, paper, paper negative, papier-mâché, papyrus, parian, parrot feathers, pastel, patchwork, patent leather, patina, pear wood, pearl, peccary hair, peccary tusk, pelt, pen, pencil, persimmon wood, pewter, peyote, photochrom, photocopying, photoengraving, photogenic drawing, photogram, photograph, photogravure, photolithograph, photomechanical print, photomontage, piecing, piercing, pig hoof, pigment, piping, pitch, plant fiber, plant pigment, plaster, plaster of Paris, plastic, platinum print, Plexiglas™, plique-à-jour, plywood, pochoir, polar bear fur, Polaroid™ print, polychromy, polyurethane, poplar wood, porcelain, porcupine hair, porcupine quills, pottery, pressed glass, printing, printing-out paper, punching, quartz, quartz crystal, quilting, rabbit fur, rabbitbrush, radiograph, raffia, raku, ramie, rattan, rawhide, rayon, ready-made, red ocher, redware, reed, reindeer hide, relief, relief print, relief watermark, Resingrave® engraving, restrike, retroussage, reverse painting on glass, rhinoceros hide, ribbon, rice paper, rock, roller printing, rosewood, roulette, rubber cement, rubbing, rush grass, rye grass, salmon skin, salt glaze, salted paper print, sand, sandalwood, sandblasting, sandstone, sandwich glass, sang de boeuf, sanguine chalk, sateen, satin, Satsuma ware, schist, screen print, seagrass, seal fur, sealskin, seeds, selenium toned, sequin, serpentine, sgraffito, shaded watermark, sheep wool, sheet metal, shell, shibori, Shigaraki ware, silk, silk thread, silver, silver bromide print, silver chloride print, silver leaf, silver-dye bleach print, sinew, skin, slate, slip, slit tapestry, soda lime glass, soft ground, soft paste porcelain, solarization, spit biting, staining, stamping, steel, steel wool, stenciling, sterling silver, stippling, stitching, stone, stoneware, stretching, string, stucco, stuffing, Styrofoam™, Sue, suede, sulfide toned, sulphur print, sweetgrass, synthetic fur, synthetic hair, synthetic string, synthetic yarn, tacks, taffeta, takamaki-e, tapestry, tapir skin, tartan, tatting, teak wood, tempera, tendon, terracotta, thread, threading, tin, tinning, tintype, toning, tooth, tortoise shell, tourmaline, tracing paper, transferware, tsukibori, tsutsugaki, tulle, turquoise, tusk, twill, twine, twining, tying, typography, uncut velvet, underglazing, varnish, veener, velvet, vinyl, walnut wood, walrus ivory, walrus tusk, wash, watercolor, waterless lithography, watermark, wax, waxed-paper negative, weaving, welding, western red cedar wood, wet collodion negative, whale bone, white oak fiber, whitewash, wicker, wild currant, wild pig tusk, willow, wire, wire watermark, wolverine fur, wood, wood block, wood engraving, woodburytype, woodcut, wool, wool thread, wool yarn, wove paper, wrought iron, xerography, yarn, yew wood, zinc, zincograph }
 
dvExhibition.ExhibitionType: { Assignment Database, Classroom Collection, Exhibition type unknown, External exhibition, Internal Exhibition (Virtual), Internal exhibition, tour script }
 
dvParticipants.RecordType: { Company or Group of Artists, Cultural Group, Individual, Unknown Maker }
 
dvParticipantsObjectLinks.Role: { Attributed to, Designer, Manufacturer, Publisher, art director, artist, artist and printer, artist and publisher, assistant, assistant printer, associate editor, audio engineer, author, calligrapher, carver, casting supervisor, composer, contributor, decorator, designer, editor, editor and publisher, engraver, etcher, illustrator, inscriber, lettering, letterpress printer, lithographer, maker, manufacturer, modeler, musician, organizer, painter, photographer, poet, potter, printer, printer and designer, printer and publisher, printer, publisher and producer, producer, publisher, retailer, supervising printer, translator, workmaster }