MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Alpha Sort = 18845

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Credit Line, 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 Metadata Date Repository
210425 210425 59.23.25 0 1 337808 Drawings and Prints 11 Drawing 23 The Cook and Her Dog (La Cuisinière et son chien)           Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845 French 2 1799 1877 1865 1865 1865 Pen and brown and black ink, and watercolor over traces of black chalk on paper 31205 7 11/16 x 4 5/16 in. (19.5 x 11 cm) Bequest of Alexandrine Sinsheimer, 1958                       Drawings 9   http://www.metmuseum.org/art/collection/search/337808 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
210426 210426 59.23.59 0 1 337809 Drawings and Prints 11 Drawing 23 The Two Gossips (Les Deux Commères)           Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845 French 2 1799 1877 1832 1832 1832 Pen and black ink, and watercolor on paper 31206 5 1/16 x 4 1/2 in. (12.8 x 11.5 cm) Bequest of Alexandrine Sinsheimer, 1958                       Drawings 9   http://www.metmuseum.org/art/collection/search/337809 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
210427 210427 59.23.60 0 1 337810 Drawings and Prints 11 Drawing 23 Tea Party at the Prince de Conti's           Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845 French 2 1799 1877 mid-19th century 1820 1877 Pen and black ink, brush and gray wash, watercolor, over graphite 31003 11 x 24 9/16 in. (28 x 62.4 cm) Bequest of Alexandrine Sinsheimer, 1958                       Drawings 9   http://www.metmuseum.org/art/collection/search/337810 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
210428 210428 59.23.61 0 1 337811 Drawings and Prints 11 Drawing 23 The Society Man (Monsieur Joseph Prudhomme)           Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845 French 2 1799 1877 1874 1874 1874 Pen and brown and black ink with watercolor and touches of white on gray-green paper. 31207 8 7/8 x 6 11/16 in. (22.6 x 17 cm) Bequest of Alexandrine Sinsheimer, 1958                       Drawings 9   http://www.metmuseum.org/art/collection/search/337811 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
228900 228900 1985.1082.5 0 0 356539 Drawings and Prints 11 Print 731 Les Artistes sont d'assez bons diables, ils reçoivent toutes sortes de gens, on s'y amuse, ça fait passer le temps         Les Gens sans façon 396 Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845 French 2 1799 1877 1820–77 1820 1877 Lithograph on wove paper 29142 sheet: 9 1/4 x 12 1/16 in. (23.5 x 30.7 cm) image: 7 1/16 x 8 11/16 in. (18 x 22.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1985                       Prints 13   http://www.metmuseum.org/art/collection/search/356539 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
262592 262592 61.590.39 0 0 391528 Drawings and Prints 11 Print 731 Fish Market at Billingsgate, from the series Voyage en Angleterre by Eugène Lamy and Henry Monnier         Voyage en Angleterre 1447 Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845 French 2 1799 1877 1829 1829 1829 Pen and ink lithograph on china paper 42306 sheet: 6 9/16 x 9 5/8 in. (16.7 x 24.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1961                       Prints 13   http://www.metmuseum.org/art/collection/search/391528 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
262593 262593 61.590.38 0 0 391529 Drawings and Prints 11 Print 731 An artist painting a family portrait           Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845 French 2 1799 1877 1820–77 1820 1877 Pen and ink lithograph on wove paper 42307 sheet: 2 3/4 x 8 1/4 in. (7 x 21 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1961                       Prints 13   http://www.metmuseum.org/art/collection/search/391529 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
291623 291623 2012.446.1 0 1 420955 Drawings and Prints 11 Drawings 2611 Self-Portrait as Monsieur Prudhomme           Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845 French 2 1799 1877 1861 1861 1861 Watercolor and gouache over graphite with pen and brown ink 43852 Sheet: 10 1/2 x 6 1/2 in. (26.7 x 16.5 cm) Gift of Eric G. Carlson, in honor of Patricia Mainardi, 2012                       Drawings 9   http://www.metmuseum.org/art/collection/search/420955 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
422388 422388 2015.750.1 0 1 700404 Drawings and Prints 11 Drawing 23 Self-Portrait as Monsieur Prudhomme           Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845   1799 1877 1858 1858 1858 Pen and brown ink 25596 Sheet: 7 11/16 × 6 7/8 in. (19.5 × 17.4 cm) Gift of Eric G. Carlson in honor of Patricia Mainardi                       Drawings 9   http://www.metmuseum.org/art/collection/search/700404 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
422389 422389 2015.750.2 0 1 700405 Drawings and Prints 11 Drawing 23 Self-Portrait as Monsieur Prudhomme           Artist 2   Henry-Bonaventure Monnier French, Paris 1799–1877 Paris   Monnier, Henry-Bonaventure 18845   1799 1877 ca. 1850–60 1845 1865 Pen and black ink 29164 Sheet: 2 13/16 × 2 13/16 in. (7.2 × 7.2 cm) Gift of Eric G. Carlson in honor of Patricia Mainardi                       Drawings 9   http://www.metmuseum.org/art/collection/search/700405 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 127.083ms · Data license: CC0 · Data source: metmuseum/openaccess