MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Department = 16 and Object Name = 75

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Classification

Department ✖

  • Robert Lehman Collection · 8 ✖
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
322365 322365 1975.1.1231 0 1 460524 Robert Lehman Collection 16 Plaque 75 Hope           Artist|Artist 13   Master IDC|Jean Cour (or Court) French, active Limoges 1614–27|French, Limoges, active 1598–1631 or Master IDC|Cour, Jean 44554 French, Limoges 3392 1598 1631 late 16th to early 17th century 1571 1635 Painted enamel, partly gilt, on copper. 48366 11 5/8 x 8 15/16 in. (29.8 x 22.7cm) Robert Lehman Collection, 1975                       Enamels 193   http://www.metmuseum.org/art/collection/search/460524 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322366 322366 1975.1.1229 0 1 460525 Robert Lehman Collection 16 Plaque 75 Minerva           Artist 2 probably Jean Limosin French, b. ca. 1580 Limoges–d. 1646   Limosin, Jean 44555 French, Limoges 3392 1580 1646 ca. 1605 1602 1608 Painted enamel on copper, partly gilt. 47827 H. 24.4 cm, w. 19.1cm Robert Lehman Collection, 1975                       Enamels 193   http://www.metmuseum.org/art/collection/search/460525 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322640 322640 1975.1.1230 0 1 460804 Robert Lehman Collection 16 Plaque 75 Faith           Artist|Artist 13   Master IDC|Jean Cour (or Court) French, active Limoges 1614–27|French, Limoges, active 1598–1631 or Master IDC|Cour, Jean 44554 French, Limoges 3392 1598 1631 late 16th century or early 17th century 1571 1635 Painted enamel, partly gilt, on copper 48536 11 5/8 x 9 1/8 in. (29.8 x 23.2 cm) Robert Lehman Collection, 1975                       Enamels 193   http://www.metmuseum.org/art/collection/search/460804 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322696 322696 1975.1.1222 0 1 460862 Robert Lehman Collection 16 Plaque 75 Virgin and Child French 7                           middle or second half of 19th century, in the style of a mid-13th century Limoges original 1836 1900 Appliqué relief from a chasse. Cast copper, engraved and gilded; the eyes, crown, and border of Mary's clothes are decorated with dark blue and turquoise enameled beads. 48576 H. 19.8 cm Robert Lehman Collection, 1975                       Metalwork 177   http://www.metmuseum.org/art/collection/search/460862 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323088 323088 1975.1.1228 0 1 461261 Robert Lehman Collection 16 Plaque 75 Mars           Artist 2 probably Jean Limosin French, b. ca. 1580 Limoges–d. 1646   Limosin, Jean 44555 French, Limoges 3392 1580 1646 ca. 1605 1602 1608 Painted enamel on copper, partly gilt. 47827 H. 24.8 cm, w. 19.8 cm. Robert Lehman Collection, 1975                       Enamels 193   http://www.metmuseum.org/art/collection/search/461261 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323168 323168 1975.1.1556 0 1 461346 Robert Lehman Collection 16 Plaque 75 Adoration of the Shepherds Italian 36                           late 16th century 1575 1600 Rock crystal. Cut, polished, reverse painted, reverse gilt. 48793 H. 5 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/461346 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323294 323294 1975.1.1557 0 1 461472 Robert Lehman Collection 16 Plaque 75 The Deposition Italian 36                           late 16th century 1575 1600 Rock crystal. Cut, polished, reverse painted, reverse gilt. 48793 H. 5 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/461472 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323361 323361 1975.1.1226 0 1 461543 Robert Lehman Collection 16 Plaque 75 Nativity probably French 203                           second half 19th century–early 20th century 1850 1935 Painted enamel, partly gilt, on copper; silver-gilt frame set with pearls, gemstones, and ronde-bosse enamels. 48862 H. with frame 21.2 cm, w. with frame 18.4 cm, d. with frame 3.1 cm. Robert Lehman Collection, 1975                       Enamels 193   http://www.metmuseum.org/art/collection/search/461543 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 379.751ms · Data license: CC0 · Data source: metmuseum/openaccess