MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Role = 2, Classification = 791 and Department = 16

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Artist Prefix, Artist Display Name, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
322355 322355 1975.1.2497 0 1 460514 Robert Lehman Collection 16 Collar 1038 Collar of the Most Distinguished Order of Saint Michael and Saint George British, London 222         Artist 2   Garrard & Company founded 1735   Garrard & Company 44552   1735 2035 20th century 1900 1950 Silver gilt and enamel 20512 L. 129 cm Robert Lehman Collection, 1975                       Jewelry, Precious Metals and Precious Stones 791   http://www.metmuseum.org/art/collection/search/460514 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322359 322359 1975.1.1505 0 1 460518 Robert Lehman Collection 16 Bowl 106 Bowl with Handles German, Augsburg 126         Artist 2   Marx Merzenbach German (Augsberg), active 1642-died 1688   Merzenbach, Marx 44553 German 10 1642 1688 ca. 1680 1677 1683 Jasper, silver gilt and enamel. 48361 H. 18.4 cm, w. 14 cm, d. 9.5 cm. Robert Lehman Collection, 1975                       Jewelry, Precious Metals and Precious Stones 791   http://www.metmuseum.org/art/collection/search/460518 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322373 322373 1975.1.1529 0 1 460532 Robert Lehman Collection 16 Necklace 237 Necklace Formed of Fifteen Dress Ornaments probably Transylvanian, possibly South Germany 5812         Artist 2 probably Transylvania   , possibly South Germany Transylvania 44558   1600 1893 ca.1600 1597 1603 Gold, enamel, ruby and pearls. 48371 L. 45 cm. Robert Lehman Collection, 1975                       Jewelry, Precious Metals and Precious Stones 791   http://www.metmuseum.org/art/collection/search/460532 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322374 322374 1975.1.1528 0 1 460533 Robert Lehman Collection 16 Necklace 237 Necklance Formed of Eight Dress Ornaments with Eight Links probably Transylvanian, possibly South German or Vienna 5813         Artist 2 Probably Transylvania   , or possibly South German or Vienna Transylvania 44558   1600 1893 ca. 1600 (with 19th century additions) 1600 1893 Gold, enamel, rubies, pearls 21372 L. 42 cm Robert Lehman Collection, 1975                       Jewelry, Precious Metals and Precious Stones 791   http://www.metmuseum.org/art/collection/search/460533 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322642 322642 1975.1.1523 0 1 460806 Robert Lehman Collection 16 Hat Badge 14575 Hat Badge Mounted as a Pendant with the Flaying of Marsyas           Artist 2   Albert André French, Lyons 1869–1954 Laudun   André, Albert 44522 French 2 1869 1954 first half 16th century and 1859–86 1500 1886 Gold, enamel and diamonds 23650 H. 6.7 cm, w. 5.7 cm Robert Lehman Collection, 1975                       Jewelry, Precious Metals and Precious Stones 791   http://www.metmuseum.org/art/collection/search/460806 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322643 322643 1975.1.1534 0 1 460807 Robert Lehman Collection 16 Scent-bottle pendant 14576 Pendant scent bottle           Artist 2   Reinhold Vasters German, Erkelenz 1827–1909 Aachen   Vasters, Reinhold 8904 German 10 1827 1909 ca. 1870–90 1870 1890 Enameled gold and agate. 48538 H. 6.7 cm Robert Lehman Collection, 1975                       Jewelry, Precious Metals and Precious Stones 791   http://www.metmuseum.org/art/collection/search/460807 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322967 322967 1975.1.1510 0 1 461140 Robert Lehman Collection 16 Pendant 1129 Pendant with Fortuna France, Paris 5914         Artist 2 probably Alfred André French, 1839–1919   André, Alfred 9086 French 2 1839 1919 1859–1907 1859 1907 enameled gold, baroque pearl, rubies and diamonds. 48699 H. 12.5 cm; w. 5 cm Robert Lehman Collection, 1975                       Jewelry, Precious Metals and Precious Stones 791   http://www.metmuseum.org/art/collection/search/461140 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323288 323288 1975.1.1501 0 1 461466 Robert Lehman Collection 16 Ostensorium 14609 Reliquary(?) probably Spanish 217         Artist 2 probably Spanish late 19th century, perhaps with earlier elements   Spanish 44439       late 19th century 1871 1900 Gold, enamels, and rock crystal. 48832 H. 29 cm, w. 12 cm, d. 12 cm. Robert Lehman Collection, 1975                       Jewelry, Precious Metals and Precious Stones 791   http://www.metmuseum.org/art/collection/search/461466 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 485.736ms · Data license: CC0 · Data source: metmuseum/openaccess