MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where "Artist End Date" is on date -4708-12-23, Artist Nationality = 2 and Object Name = 23

✎ View and edit SQL

This data as json, CSV (advanced)

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
206740 206740 46.177.1 0 1 334084 Drawings and Prints 11 Drawing 23 Portrait of Jennins           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 1838 1838 1838 Graphite and touches of black chalk on beige laid paper 29081 Sheet: 12 1/2 x 9 1/4 in. (31.8 x 23.5cm) Rogers Fund, 1946                       Drawings 9   http://www.metmuseum.org/art/collection/search/334084 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
206915 206915 64.188 0 1 334259 Drawings and Prints 11 Drawing 23 Jewish Woman of Algiers Seated on the Ground           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 ca. 1846 1841 1851 Watercolor over graphite on wove paper (trimmed and laid down on blue wove paper) 29184 Sheet: 11 3/4 x 9 1/8 in. (29.8 x 23.2cm) Rogers Fund, 1964                       Drawings 9   http://www.metmuseum.org/art/collection/search/334259 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
206962 206962 1972.118.199 0 1 334306 Drawings and Prints 11 Drawing 23 The Baroness Duperré and Her Daughters           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 1841 1841 1841 Graphite on wove paper 1722 Sheet: 13 3/4 x 10 5/8 in. (35 x 27cm) Bequest of Walter C. Baker, 1971                       Drawings 9   http://www.metmuseum.org/art/collection/search/334306 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
206989 206989 1975.131.94 0 1 334336 Drawings and Prints 11 Drawing 23 Mass           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 ca. 1837–38 1832 1843 Brush, ink and gray wash, heightened with white over graphite on beige laid paper 29230 Sheet: 12 1/16 x 9 3/16 in. (30.7 x 23.4cm) Bequest of Harry G. Sperling, 1971                       Drawings 9   http://www.metmuseum.org/art/collection/search/334336 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
207129 207129 1989.286.1 0 1 334477 Drawings and Prints 11 Drawing 23 General Bonchamp Shown in a Pose Designed for His Tomb (Recto)           Artist 2   Pierre Jean David d'Angers French, Angers 1788–1856 Paris   David d'Angers, Pierre Jean 679 French 2 1788 1856 19th century 1800 1856 Graphite, pen and bown ink (recto); graphite (verso) 29305 8 7/16 x 11 in. (21.4 x 28 cm) Purchase, Karen B. Cohen Gift, 1989                       Drawings 9   http://www.metmuseum.org/art/collection/search/334477 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
207130 207130 1989.286.2 0 1 334478 Drawings and Prints 11 Drawing 23 The Allegorical Figure of France for the Tomb of General Bonchamp           Artist 2   Pierre Jean David d'Angers French, Angers 1788–1856 Paris   David d'Angers, Pierre Jean 679 French 2 1788 1856 19th century 1800 1856 graphite, pen and brown ink 29306 Sheet: 8 5/16 x 5 15/16 in. (21.1 x 15.1cm) Purchase, Karen B. Cohen Gift, 1989                       Drawings 9   http://www.metmuseum.org/art/collection/search/334478 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
207131 207131 1989.286.3 0 1 334479 Drawings and Prints 11 Drawing 23 Sheet of Studies: Three Male Heads, a Lion and a Mouse           Artist 2   Pierre Jean David d'Angers French, Angers 1788–1856 Paris   David d'Angers, Pierre Jean 679 French 2 1788 1856 1800–1856 1800 1856 pen and brown ink 29307 Sheet: 9 1/2 x 7 3/16 in. (24.1 x 18.3cm) Purchase, Karen B. Cohen Gift, 1989                       Drawings 9   http://www.metmuseum.org/art/collection/search/334479 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
207137 207137 1990.219 0 1 334485 Drawings and Prints 11 Drawing 23 Drapery Study for the Figure of the Dying Mary Magdalen           Draftsman 971   Paul (Hippolyte) Delaroche French, Paris 1797–1856 Paris   Delaroche, Paul (Hippolyte) 17576 French 2 1797 1856 1815–56 1815 1856 Black chalk, stumped, with touches of brownish red chalk 29312 Sheet: 14 1/4 x 22 1/4 in. (36.2 x 56.5cm) Purchase, Harry Leibovitz Bequest, 1990                       Drawings 9   http://www.metmuseum.org/art/collection/search/334485 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
255455 255455 2008.538.23 0 1 384103 Drawings and Prints 11 Drawing 23 Ernest Chassériau (?)           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 1851 1851 1851 Conté crayon, with touches of white chalk, on wove paper 41011 Sheet: 9 3/8 x 7 3/4 in. (23.8 x 19.7 cm) Gift of Mrs. Charles Wrightsman, 2008                       Drawings 9   http://www.metmuseum.org/art/collection/search/384103 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
255456 255456 2008.538.24 0 1 384104 Drawings and Prints 11 Drawing 23 Count Philibert-Oscar de Ranchicourt           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 ca. 1836 1831 1841 Graphite on wove paper 1722 Sheet: 11 3/4 x 9 1/2 in. (29.9 x 24.2 cm) Gift of Mrs. Charles Wrightsman, 2008                       Drawings 9   http://www.metmuseum.org/art/collection/search/384104 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
279815 279815 2012.150.18 0 1 409006 Drawings and Prints 11 Drawing 23 Portrait of a Young Woman Wearing a Cloak and Bonnet           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 1850 1850 1850 Graphite on wove paper 1722 Sheet: 9 5/8 x 7 1/2 in. (24.5 x 19 cm) Frame: 18 1/8 x 15 3/8 in. (46 x 39 cm) Gift of Mrs. Charles Wrightsman, 2012                       Drawings 9   http://www.metmuseum.org/art/collection/search/409006 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
294300 294300 2013.62 0 1 423643 Drawings and Prints 11 Drawing 23 Study for a figure of Fame, from the Hémicycle des Beaux-Arts, École des Beaux-Arts           Artist 2   Paul (Hippolyte) Delaroche French, Paris 1797–1856 Paris   Delaroche, Paul (Hippolyte) 17576 French 2 1797 1856 ca. 1837–41 1832 1842 Watercolor and gouache over black chalk 43996 Sheet: 17 11/16 × 10 13/16 in. (45 × 27.5 cm) Purchase, Guy Wildenstein Gift, 2013                       Drawings 9   http://www.metmuseum.org/art/collection/search/423643 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321369 321369 1975.1.581 0 1 459338 Robert Lehman Collection 16 Drawing 23 Portrait of Madame Gabrielle Marcotte de Quivières           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 1845 1845 1845 Graphite on white wove paper darkened to buff, mounted on stiff paper 47897 12 13/16 x 10 3/4 in. (32.5 x 27.3 cm); Rabbet: 22 x 16 in. (55.9 x 40.6 cm.); Overall Frame: H x W x D: 18 x 24 x 1 1/4 in. (45.7 x 61 x 3.2 cm.) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459338 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321370 321370 1975.1.582 0 1 459339 Robert Lehman Collection 16 Drawing 23 Portrait of Madame Ravaisson           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 1846 1846 1846 Graphite on white wove paper darkened to buff 47898 13 1/8 x 10 in. (35.1 x 26.9 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459339 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321371 321371 1975.1.583 0 1 459340 Robert Lehman Collection 16 Drawing 23 Portrait of Félix Ravaisson           Artist 2   Théodore Chassériau French, Le Limon, Saint-Domingue, West Indies 1819–1856 Paris   Chassériau, Théodore 17399 French 2 1819 1856 1846 1846 1846 Graphite on white wove paper darkened to buff 47898 13 1/8 x 10 in. (33.3 x 25.4 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459340 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 6873.374ms · Data license: CC0 · Data source: metmuseum/openaccess