MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Role = 1885

View and edit SQL

Suggested facets: Is Public Domain, Artist Prefix, Artist Suffix, Artist Nationality, Medium, Dimensions, Credit Line

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 Repository
218738 1970.565.185 0 1 346246 Drawings and Prints 11 Book 97 Traité de la composition de l'ornement des jardins, avec 96 planches representant des plans de jardins           Author|Designer|Publisher|Printer 1885 Written by|Additional plates designed by|Published by|Printed by Pierre Boitard|Auguste Garneret|Audot|Caron-Duquenne French, 1789?–1859|French, 19th century , Paris|, Amiens Boitard|Garneret, Auguste|Audot|Caron-Duquenne 22085 French|French|French|French 95 1789 |1800 1859 |1900 1825 1825 1825 Engraving 7208 6 3/4 x 8 1/2 in. (17.1 x 21.6 cm) Gift of Lincoln Kirstein, 1970   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
219244 52.625.44 0 0 346762 Drawings and Prints 11 Book 97 Rabbi Ben Ezra           Author|Designer|Publisher|Printer 1885   Robert Browning|William Henry Bradley|The Sign of the Vine|Heintzemann Press British, London 1812–1889 Venice|American, Boston, Massachusetts 1868–1962 La Mesa, California|Concord, Massachusetts|Boston   Browning, Robert|Bradley, William Henry|Sign of the Vine|Heintzemann Press 22410 British|American|American 691 1812 |1868 |1880 |1850 1889 |1962 |1950 |1950 1910 1910 1910 Book with letterpress (relief process) illustrations 34017 6 3/16 × 4 1/8 in. (15.7 × 10.4 cm) The Will Bradley Collection, Gift of Fern Bradley Dufner, 1952                       Books 442   Metropolitan Museum of Art, New York, NY 1
219828 1986.1229.1 0 0 347353 Drawings and Prints 11 Book 97 Poèmes           Author|Designer|Publisher|Printer 1885 Written by|Designed by|Published at the expense of|Printed by René Char|Nicolas de Staël|Nicolas de Staël|Fequet et Baudier (Marthe Fequet et Pierre Baudier) French, born 1907|French, 1914–1955|French, 1914–1955|French   Char, René|Staël, Nicolas de|Staël, Nicolas de|Fequet et Baudier (Marthe Fequet et Pierre Baudier) 22862 French|French|French|French 95 1907 |1914 |1914 2007 |1955 |1955 November 1952 1952 1952 Woodcut; cover is lithograph 34560 Overall: 14 9/16 x 11 5/8 x 2 3/16 in. (37 x 29.5 x 5.5 cm) Gift of Theodore Schempp, 1986                       Books 442   Metropolitan Museum of Art, New York, NY 1
222502 1975.618.2 0 0 350063 Drawings and Prints 11 Book 97 Edmond van Offel           Author|Designer|Publisher|Printer 1885 Written by|Designed by|Published by|Printed by Frédéric de France|Edmond van Offel|Librairie L. Borel|Imprimerie J.-E. Buschmann Belgian, born 1871|Antwerp , Paris France, Frédéric de|Offel, Edmond van|Borel, Librairie L.|Imprimerie J.-E. Buschmann 24696 French|Belgian|French|Belgian 1634 1871 1871 1902 1902 1902 Wood engraving 29001 Overall: 12 1/16 x 11 7/16 x 13/16 in. (30.7 x 29 x 2 cm) Max G. Wildnauer Fund, 1975   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
225214 52.625.45 0 0 352808 Drawings and Prints 11 Book 97 A Dissertation upon Roast Pig           Author|Designer|Publisher|Printer 1885 Illustrated, designed and typeset by Charles Lamb|William Henry Bradley|The Sign of the Vine|Heintzemann Press British, London 1775–1834 Edmonton, Middlesex|American, Boston, Massachusetts 1868–1962 La Mesa, California|Concord, Massachusetts|Boston   Lamb, Charles|Bradley, William Henry|Sign of the Vine|Heintzemann Press 26821 British|American|American 691 1775 |1868 |1880 |1850 1834 |1962 |1950 |1950 ca. 1903 1898 1908 Book with letterpress (relief process) illustrations 34017 6 3/16 × 4 1/8 in. (15.7 × 10.4 cm) The Will Bradley Collection, Gift of Fern Bradley Dufner, 1952                       Books 442   Metropolitan Museum of Art, New York, NY 1
228086 1974.627 0 0 355714 Drawings and Prints 11 Book 97 Les Chiens Ont Soif           Author|Designer|Publisher|Printer 1885 Written by|Designed by|Published by|Printed by Jacques Prévert|Max Ernst|Au Pont Des Arts|Mourlot Fréres French, Neuilly-sur-Seine 1900–1977 Omonville-la-Petite|French (born Germany), Brühl 1891–1976 Paris , Paris|(lithos and etchings) Prévert, Jacques|Ernst, Max|Au Pont Des Arts|Mourlot Fréres 28805 French|French, born Germany|French|French 2149 1900 |1891 1977 |1976 1964 1964 1964 Etching and lithograph 33645 sheet: 17 1/8 x 12 3/16 in. (43.5 x 31 cm) John B. Turner Fund, 1974                       Books 442   Metropolitan Museum of Art, New York, NY 1
228406 1973.559.1, .2 0 0 356040 Drawings and Prints 11 Book 97 Contes Pour Chacun de Nous           Author|Designer|Publisher|Printer 1885 Written by|Designed by|Published by|Printed by Henri de Régnier|Arthur-Jules Mayeur|Editions Lapina (Collection les Panathénées)|Ateliers de Lapina French, 1864–1936|French, born 1871|French , Paris Régnier, Henri de|Mayeur, Arthur-Jules|Editions Lapina (Collection les Panathénées)|Lapina, Ateliers de 29001 French|French|French 103 1864 |1871 1936 |1971 February 15, 1926 1926 1926 Etching and woodcut 35108 Overall: 7 3/4 x 5 3/4 x 13/16 in. (19.7 x 14.6 x 2 cm) Purchase, Gift of Marcia Harrison in Memory of Alfred Chapin Rogers, 1973                       Books 442   Metropolitan Museum of Art, New York, NY 1
228482 1986.1240 0 0 356117 Drawings and Prints 11 Book 97 Au Soleil du Plafond           Author|Designer|Publisher|Printer 1885 Written by|Designed by|Published by|Printed by Pierre Reverdy|Juan Gris|Tériade|Fernand Mourlot French, 1889–1960|Spanish, Madrid 1887–1927 Boulogne-sur-Seine|French, 1895–1988 , Paris|Frères (Paris) Reverdy, Pierre|Gris, Juan|Tériade|Mourlot, Fernand 29048 French|Spanish|French|French 2170 1889 |1887 |1895 1960 |1927 |1988 1955 1955 1955 Lithographs (for both handwritten text and the illustrations) 35981 sheet: 16 9/16 x 12 5/8 in. (42 x 32 cm) Overall: 17 1/8 x 13 3/8 x 1 15/16 in. (43.5 x 34 x 5 cm) Gift of Judith Rothschild, 1986                       Books 442   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 128.285ms · Data license: CC0 · Data source: metmuseum/openaccess