MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Alpha Sort = 18669

View and edit SQL

Suggested facets: Department, Object Name, Object Date, Object End Date, Medium, 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 Repository
209821 1975.131.116 0 1 337203 Drawings and Prints 11 Drawing 23 Standing Gentleman, three-quarter length profile facing right           Artist 2 Attributed to Anne Louis Girodet-Trioson French, Montargis 1767–1824 Paris   Girodet-Trioson, Anne Louis 18669 French 2 1767 1824 n.d. 1780 1824 Black chalk, heightened with white on dark brown paper 30854 15 13/16 x 5 11/16 in. (40.1 x 14.5 cm) Bequest of Harry G. Sperling, 1971                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
209823 1993.21 0 1 337205 Drawings and Prints 11 Drawing 23 Male Nude Reclining on a Divan           Artist 2   Anne Louis Girodet-Trioson French, Montargis 1767–1824 Paris   Girodet-Trioson, Anne Louis 18669 French 2 1767 1824 ca. 1793 1788 1798 Black chalk, rubbed 30856 6 7/8 x 9 1/2 in. (17.4 x 24.2 cm) Harry G. Sperling Fund, 1993                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
209824 1996.567 0 1 337206 Drawings and Prints 11 Drawing 23 The Mourning of Pallas           Artist 2   Anne Louis Girodet-Trioson French, Montargis 1767–1824 Paris   Girodet-Trioson, Anne Louis 18669 French 2 1767 1824 ca.1790–93 1785 1795 Pen and brown ink, brush and gray and brown wash, heightened with white 30857 8 7/16 x 6 1/2 in. (21.5 x 16.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1996                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
226423 2003.5 0 1 354035 Drawings and Prints 11 Drawing 23 Comedy and Tragedy           Artist 2   Anne Louis Girodet-Trioson French, Montargis 1767–1824 Paris   Girodet-Trioson, Anne Louis 18669 French 2 1767 1824 1814 1814 1814 Black chalk and stumping 30241 9 1/4 x 12 1/2 in. (23.5 x 31.8 cm) Karen B. Cohen Fund, 2003                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
231872 2003.184 0 1 359615 Drawings and Prints 11 Drawing 23 Portrait of Louis-Francois Bertin, l'ainé           Artist 2   Anne Louis Girodet-Trioson French, Montargis 1767–1824 Paris   Girodet-Trioson, Anne Louis 18669 French 2 1767 1824 n.d. 1775 1824 Black chalk on off-white wove paper 31152 5 1/2 x 6 in. (13.9 x 15.2 cm) Purchase, Stephen A. Geiger, and Susan H. Seidel Gifts, 2003                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
266687 2011.86 0 1 395686 Drawings and Prints 11 Drawing 23 A French Dragoon, Study for "The Revolt of Cairo"           Artist 2   Anne Louis Girodet-Trioson French, Montargis 1767–1824 Paris   Girodet-Trioson, Anne Louis 18669 French 2 1767 1824 ca. 1809 1804 1814 Pastel and conté crayon, with some stumping, on gold-colored dyed laid paper 42844 sheet: 23 3/8 x 18 1/2 in. (59.4 x 47 cm) Purchase, Lila Acheson Wallace, David T. Schiff, Jean A. Bonna, and Guy Wildenstein Gifts, 2011                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
307827 1997.371 0 1 438032 European Paintings 15 Painting 69 Study for "Portrait of an Indian"           Artist 2   Anne Louis Girodet-Trioson French, Montargis 1767–1824 Paris   Girodet-Trioson, Anne Louis 18669 French 2 1767 1824 ca. 1807 1802 1812 Oil on canvas 953 16 x 12 7/8 in. (40.6 x 32.7 cm) Purchase, Gift of Joanne Toor Cummings, by exchange, 1997                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
307871 1999.101 0 1 438389 European Paintings 15 Painting 69 Madame Jacques-Louis-Étienne Reizet (Colette-Désirée-Thérèse Godefroy, 1782–1850)           Artist 2   Anne Louis Girodet-Trioson French, Montargis 1767–1824 Paris   Girodet-Trioson, Anne Louis 18669 French 2 1767 1824 1823 1823 1823 Oil on canvas 953 23 3/4 x 19 1/2 in. (60.3 x 49.5 cm) Purchase, Gifts of Joanne Toor Cummings, Mr. and Mrs. Richard Rodgers, Raymonde Paul, and Estate of Dorothy Lichtensteiger, by exchange, 1999                       Paintings 11   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 122.286ms · Data license: CC0 · Data source: metmuseum/openaccess