MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Role = 2113

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Classification

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
220033 220033 48.180.80 0 0 347561 Drawings and Prints 11 Book 97 In Revue de l'Exposition Universelle de 1889, Paris, Motteroz. May-November, 2 vols.           Designer|Publisher|Engraver|Engraver 2113   Charles Christofle & Cie.|Motteroz|Auguste-Louis Lepère|Felicien Myrbach-Rheinfeld French|French, Paris 1849–1918 Domme|Austrian, Zaleszczyki 1853–1909 Klagenfurt , Paris Christofle Charles & Cie.|Motteroz|Lepère, Auguste-Louis|Myrbach-Rheinfeld, Felicien 23003 French|French|French|Austrian 1426 1849 |1853 1918 |1909 1889 1889 1889     Gift of Edwin De T. Bechtel, 1948   Paris 27                   Books 442   http://www.metmuseum.org/art/collection/search/347561 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
223041 223041 29.58.19-.24 0 0 350611 Drawings and Prints 11 Book Ornament and architecture 13817 Ornaments in the Modern French & Chinese Taste Consisting of Various designs for Mantles & Chimney Pieces           Designer|Publisher|Engraver|Engraver 2113   P. Glazier|John Bowles|J. Couse|Henry Roberts French, active London mid 18th century|British, 1701?–1779|British, active ca. 1750|British, before 1710–after 1790   Glazier, P.|Bowles, John|Couse, J.|Roberts, Henry 25150 French|British|British|British 959 1740 |1700 |1700 |1710 1780 |1766 |1800 |1790 1740–49 1740 1749 Illustrations: engraving, etching 34157 13 9/16 x 9 7/16 x 1/16 in. (34.5 x 24 x 0.2 cm) Harris Brisbane Dick Fund, 1929   London 14                   Books|Ornament & Architecture 665   http://www.metmuseum.org/art/collection/search/350611 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
224970 224970 31.15.4 0 0 352564 Drawings and Prints 11 Book 97 Representation du Chateau de Chasse de S.A. Sme. Mons. L'Eveque de Bamberg Nomé Marquardsbourg...           Designer|Publisher|Engraver|Engraver 2113 Designed by|Published by|Engraved by|Engraved by Salomon Kleiner|Heirs of Jeremiah Wolff|Johann Matthias Steidlin|Jakob Andreas Fridrich the Elder German, Augsburg 1700/1703–1761 Vienna|German, active 18th century|German, Nürnberg, 1684–1751 , Augsburg Kleiner, Salomon|Wolff, Jeremiah Heirs of|Steidlin, Johann Matthias|Fridrich, Jakob Andreas the Elder 26628 German|German|German 80 1700 |0018 |1684 1761 |0018 |1751 1731 1731 1731 Engraving 7208 Overall: 13 3/16 x 20 1/2 x 3/8 in. (33.5 x 52 x 1 cm) Harris Brisbane Dick Fund, 1931                       Books 442   http://www.metmuseum.org/art/collection/search/352564 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
227652 227652 56.565 0 0 355272 Drawings and Prints 11 Book ; Ornament and architecture 13811 Porte d'architettura rustica d'Oratio Perucci           Designer|Publisher|Engraver|Engraver 2113   Orazio Perucci|Vittorio Serena|Francesco Curti|Giovanbattista Coriolano Italian, ca. 1548–1624|Italian, 1603–1670|Italian, Bologna 1590–1649 Bologna   Perucci, Orazio|Serena, Vittorio|Curti, Francesco|Coriolano, Giovanbattista 28531 Italian|Italian|Italian|Italian 315 1548 |1603 |1590 1624 |1670 |1649 1634 1634 1634 Printed book with engraved illustrations 29332 15 13/16 x 10 13/16 x 7/16 in. (40.1 x 27.5 x 1.1 cm) Antiquarian Bookseller's Fund, 1955   Reggio 674                   Books|Ornament & Architecture 665   http://www.metmuseum.org/art/collection/search/355272 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 133.806ms · Data license: CC0 · Data source: metmuseum/openaccess