MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Classification = 725

View and edit SQL

Suggested facets: Is Public Domain, Department, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, 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
227912 42.21(1–26) 0 0 355536 Drawings and Prints 11 Sketchbook 991 A Sketch Book Containing Drawings on Twenty-six Leaves           Artist 2   Frederic, Lord Leighton British, Scarborough 1830–1896 London   Leighton, Frederic, Lord 8444 British 7 1830 1896 1845–60 1845 1860 Graphite, ink and wash; gouache and graphite 35862 sheet (page): 7 7/8 x 10 7/8 in. (20 x 27.6 cm) sheet (book): 8 1/8 x 11 in. (20.6 x 27.9 cm) Fletcher Fund, 1942                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
227989 18.121(1-182) 0 1 355616 Drawings and Prints 11 Sketchbook 991 Sketch Book Containing 182 drawings on 91 leaves. One of a series used by the artist on his Italian trip, 1750–52; Sketches made in Milan, Turin, Florence, and Rome.           Artist|Artist|Artist 53 Some leaves after|Some leaves after Sir Joshua Reynolds|Guercino (Giovanni Francesco Barbieri)|Michelangelo Buonarroti British, Plympton 1723–1792 London|Italian, Cento 1591–1666 Bologna|Italian, Caprese 1475–1564 Rome   Reynolds, Joshua, Sir|Guercino (Giovanni Francesco Barbieri)|Michelangelo Buonarroti 28760 British|Italian|Italian 904 1723 |1591 |1475 1792 |1666 |1564 1750–52 1750 1752 Graphite on paper  35886 binding: 7 11/16 x 5 1/4 x 11/16 in. (19.5 x 13.4 x 1.8 cm) pages: 7 3/8 x 5 1/8 in. (18.8 x 13 cm) Gift of William A. White, 1918                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
230949 57.102.2(1–94) 0 0 358649 Drawings and Prints 11 Sketchbook 991 Large Italian Sketchbook (containing 11 drawings on 94 leaves)           Artist 2   Joseph Wright (Wright of Derby) British, Derby 1734–1797 Derby   Wright, Joseph (Wright of Derby) 30683 British 7 1734 1797 1774–75 1774 1775 Graphite, pen, ink, gray wash 36395 Overall: 11 1/2 x 8 1/4 x 15/16 in. (29.2 x 21 x 2.4 cm) Sheet: 10 5/8 x 7 13/16 in. (27 x 19.9 cm) Rogers Fund, 1957                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
234333 57.102.1(1–44) 0 1 362089 Drawings and Prints 11 Sketchbook 991 Smaller Italian Sketchbook (containing 43 drawings on 44 leaves)           Artist 2   Joseph Wright (Wright of Derby) British, Derby 1734–1797 Derby   Wright, Joseph (Wright of Derby) 30683 British 7 1734 1797 1774–75 (?) 1774 1775 Graphite, pen and ink, grey and yellow wash 37047 Overall: 9 7/16 x 7 1/16 x 1/2 in. (24 x 18 x 1.3 cm) Sheet: 9 3/16 x 6 3/4 in. (23.4 x 17.1 cm) Rogers Fund, 1957                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
255078 2008.337a–ee 0 1 383706 Drawings and Prints 11 Sketchbook 991 Sketchbook of a Journey to the Château d'Eu           Artist 2   Pierre François Léonard Fontaine French, Pontoise 1762–1853 Paris   Fontaine, Pierre François Léonard 18218 French 2 1762 1853 1811 1811 1811 Sketchbook with thirty watercolors, with pen and ink 40902 Overall: 7 1/2 x 6 1/16 x 1/2 in. (19 x 15.4 x 1.3 cm) Gift of The Apollo Circle, in honor of Philippe de Montebello, 2008                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
255136 2008.328.1 0 0 383770 Drawings and Prints 11 Sketchbook 991 Sketchbook           Artist 2   Mary Beth McKenzie American, born Cleveland, Ohio, 1946   Mckenzie, Mary Beth 18527 American 1 1946 2046 ca. 2001–2 1996 2007 Graphite, color pencil and pastel 40915 10 x 8 inches (25-1/2 x 20-1/4 cm) each Gift of the artist, 2008                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
255137 2008.328.2 0 0 383771 Drawings and Prints 11 Sketchbook 991 Sketchbook           Artist 2   Mary Beth McKenzie American, born Cleveland, Ohio, 1946   Mckenzie, Mary Beth 18527 American 1 1946 2046 20th–21st century 1946 2008 Graphite, colored pencil and pastel 40916 Each 10 x 8 in. (25.4 x 20.3 cm) Gift of the artist, 2008                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
255454 2008.540 0 0 384101 Drawings and Prints 11 Sketchbook 991 Sketchbook           Artist 2   Mary Beth McKenzie American, born Cleveland, Ohio, 1946   Mckenzie, Mary Beth 18527 American 1 1946 2046 1998–2002 1998 2002 Graphite, colored pencil and pen 41010 Overall: 6 x 4 in. (15.2 x 10.2 cm) Gift of the artist, 2008                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
266106 18.121(120) 0 1 395074 Drawings and Prints 11 Sketchbook 991 Diana (leaf in Italian Sketch Book, 1750–52)           Artist 2   Sir Joshua Reynolds British, Plympton 1723–1792 London   Reynolds, Joshua, Sir 19829 British 7 1723 1792 1750–52 1750 1752 Graphite 28967 sheet: 7 3/8 x 5 1/8 in. (18.8 x 13 cm) Gift of William A. White, 1918                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
301453 65.713.205 0 0 431232 Drawings and Prints 11 Sketchbook 991 Sketchbook, Havana 1949           Artist 2   Emilio Sanchez American, born Cuba 1921–1999   Sanchez, Emilio 38711 American 1 1921 1999 1949 1949 1949 Graphite 28967 Sheet: 5 5/16 × 3 13/16 in. (13.5 × 9.7 cm) Gift of Emilio Sanchez, 1965                       Sketchbooks 725   Metropolitan Museum of Art, New York, NY 1
431697 2016.420 0 0 716810 American Paintings and Sculpture 2 Sketchbook 991 Sketchbook           Artist 2   John Wesley Jarvis American (born England), South Shield 1780–1840 New York   Jarvis, John Wesley 1536   1780 1840 ca. 1830 1825 1835 Leather bound book with marbleized endpapers  61301 8 1/4 × 5 1/4 in. (21 × 13.3 cm) Gift of Jessica Anne Murphey, 2016 (none assigned) 9 New York 3     United States 3             Sketchbooks 725   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 160.661ms · Data license: CC0 · Data source: metmuseum/openaccess