MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Nationality = 229 and Object Name = 97

View and edit SQL

Suggested facets: Artist Role, Medium, Credit Line, City

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
220099 36.2.9 0 0 347630 Drawings and Prints 11 Book 97 Third List from the Bookshop of Douglas Cleverdon           Artist|Subject of book 2125 Vignette on cover by Jean-Émile Laboureur|Douglas Cleverdon French, Nantes 1877–1943 Penestin|British, Bristol 1903–1987 London   Laboureur, Jean Émile|Cleverdon, Douglas 23058 French|British 229 1877 |1903 1943 |1987 1927 1927 1927   Overall: 9 3/4 x 6 3/4 x 1/2 in. (24.8 x 17.1 x 1.3 cm) Gift of Harold Bell, 1936   Bristol 2                   Books 442   Metropolitan Museum of Art, New York, NY 1
221242 27.99 0 0 348786 Drawings and Prints 11 Book 97 Historical Cartoons           Artist|Publisher 710   Gustave Doré|John Camden Hotten French, Strasbourg 1832–1883 Paris|British, Clerkenwell 1832–1873 Hampstead   Doré, Gustave|Hotten, John Camden 23830 French|British 229 1832 |1832 1883 |1873 1868 1868 1868 Illustrations: reproductions of drawings 29127 10 3/8 x 13 13/16 x 9/16 in. (26.3 x 35.1 x 1.5 cm) Gift of Samuel P. Avery, 1927   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
221255 69.589.13 0 0 348802 Drawings and Prints 11 Book 97 Two Hundred Sketches, Humorous and Grotesque           Artist|Publisher 710   Gustave Doré|Frederick Warne & Co. French, Strasbourg 1832–1883 Paris London Doré, Gustave|Warne, Frederick & Co. 23835 French|British 229 1832 |1850 1883 |1950 1867 1867 1867     The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1969   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
221370 1970.565.216 0 0 348918 Drawings and Prints 11 Book 97 Perspective Practical. Or, A Plain and Easie Method of True and Lively Representing all Things to the Eye at a Distance, by the Exact Rules of Art           Author|Translator 1496 Translated and published by Jean DuBreuil|Robert Pricke French, 1602–1670|British, ca. 1642–1708   DuBreuil, Jean|Pricke Robert 23903 French|British 229 1602 |1642 1670 |1708 1698 1698 1698 Illustrations: engraving 28942 9 3/16 x 6 7/8 x 1 in. (23.4 x 17.5 x 2.5 cm) Gift of Lincoln Kirstein, 1970                       Books 442   Metropolitan Museum of Art, New York, NY 1
221469 1970.565.99 0 0 349021 Drawings and Prints 11 Book 97 The Principles of Painting           Author|Publisher 44   Roger de Piles|J. Osborn French, Clamecy 1635–1709 Paris|London   Piles, Roger de|Osborn, J. 23954 French|British 229 1635 |1700 1709 |1899 1743 1743 1743 Illustrations: etching and engraving 29021 8 1/4 x 5 1/4 in. (21 x 13.3 cm) Gift of Lincoln Kirstein, 1970   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
226579 24.90.1914 0 0 354192 Drawings and Prints 11 Book 97 A Voyage to North America and West Indies in 1817           Author|Publisher 44   Edouard de Montulé|Sir Richard Phillips & Co. French, active early 19th century|London   Montulé, Edouard de|Phillips, Sir Richard & Co. 27789 French|British 229 1800 |1800 1850 |1900 1821 1821 1821 Illustrations: engraving 28942 9 1/8 x 5 7/8 x 1/2 in. (23.2 x 15 x 1.2 cm) Bequest of Charles Allen Munn, 1924                       Books 442   Metropolitan Museum of Art, New York, NY 1
230561 63.601.2 0 0 358250 Drawings and Prints 11 Book 97 The Sunshade, the Glove -- the Muff           Illustrator|Publisher 1092   Paul Avril|J. C. Nimmo and Bain French, born 1843|London   Avril, Paul|Nimmo, J. C. and Bain 30480 French|British 229 1843 |1875 1943 |1899 1884 1884 1884 Illustrations: lithography, engraving 34456 10 13/16 x 7 5/16 x 13/16 in. (27.5 x 18.5 x 2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Books 442   Metropolitan Museum of Art, New York, NY 1
231481 53.604 0 0 359218 Drawings and Prints 11 Book 97 La Tres Plaisante Histoire de Magis d'Aigremont, et Vivian son Frere           Publisher|Binder 1265 Published by|Bound by Nicolas Gay|Lloyd, Wallis & Lloyd British, active London after 1821 , Lyon Gay, Nicolas|Lloyd, Wallis & Lloyd 30892 French|British 229 1821 1900 1643 1643 1643   8-1/4 x 6-1/4 The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Books 442   Metropolitan Museum of Art, New York, NY 1
239920 32.46.9(1-22, 110-114) 0 0 368006 Drawings and Prints 11 Book 97 La Mode Artistique           Engraver|Printer 1413 Engraved by Gustave Janet|Samuel Miller French, born Paris, 1829|London   Janet, Gustave|Miller, Samuel 33214 French|British 229 1829 |1850 1929 |1900 19th century 1800 1900 plates: color lithography 33979 Overall: 15 3/8 x 12 13/16 x 9/16 in. (39 x 32.5 x 1.5 cm) Harris Brisbane Dick Fund, 1932                       Books 442   Metropolitan Museum of Art, New York, NY 1
240228 57.548(3) 0 0 368318 Drawings and Prints 11 Book 97 La Saison: Journal Illustré des Dames           Publisher|Publisher 17   M. J. Baudry|William Heinemann Ltd. Paris|London   Baudry, M. J.|Heinemann,William Ltd. 33291 French|British 229 1800 |1850 1900 |1950 1873 1873 1873 plates: engraving 33820 Overall: 14 15/16 x 10 5/8 in. (38 x 27 cm) Purchase, Myra Carter Church Fund, 1957                       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 131.711ms · Data license: CC0 · Data source: metmuseum/openaccess