MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Artist Alpha Sort = 18930

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Artist Prefix, Object Date, Object Begin Date, Object End Date, Medium, 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 Repository
210703 2000.519.3 0 0 338087 Drawings and Prints 11 Drawing 23 Washerwomen           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush and gray and brown washes 31364 6-5/8 x 9-5/8 in. (16.8 x 24.4 cm) Partial and Promised Gift of Mary Tavener Holmes, 2000                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213402 61.2.2 0 1 340798 Drawings and Prints 11 Drawing 23 Caricature of a Seated Man Reading           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush and brown wash 29439 9 11/16 x 7 3/8in. (24.6 x 18.7cm) Rogers Fund, 1960                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213403 65.131.6 0 1 340799 Drawings and Prints 11 Drawing 23 Artists Drawing and Painting in a Studio           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush and brown wash 29439 2-7/8 x 7-7/8 in. (7.3 x 20 cm) Rogers Fund, 1965                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213404 80.3.298 0 1 340800 Drawings and Prints 11 Drawing 23 Four Caricatured Heads           Artist 2 attributed to Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink 25596 3 1/4 x 10 1/4in. (8.3 x 26cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213405 80.3.324 0 1 340801 Drawings and Prints 11 Drawing 23 Youth Reading           Artist 2 Circle of Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush and brown wash 29439 8 3/4 x 7 11/16in. (22.3 x 19.5cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213406 80.3.454 0 1 340802 Drawings and Prints 11 Drawing 23 Figure of a Man           Artist 2 attributed to Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush and brown wash 29439 10 13/16 x 9 11/16in. (27.4 x 24.6cm) Gift of Cornelius Vanderbilt, 1880                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213407 1975.131.36 0 1 340803 Drawings and Prints 11 Drawing 23 Forest Scene, a Halt at the Left, a Hunt at the Center           Artist 2 attributed to Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush and brown wash, highlighted with white gouache, over black chalk 31941 6 3/8 x 14 13/16in. (16.2 x 37.7cm) Bequest of Harry G. Sperling, 1971                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213409 1991.184.1 0 1 340805 Drawings and Prints 11 Drawing 23 Saint John the Baptist Preaching.           Artist 2 attributed to Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush with brown and red wash, red chalk 32848 sheet: 7 7/8 x 10 13/16 in. (20 x 27.4 cm) Gift of Jacob Bean, in memory of Donald P. Gurney, 1991                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213410 1992.221 0 1 340806 Drawings and Prints 11 Drawing 23 Conversion of Saint Paul           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush and brown wash, over black chalk 29736 8 5/8 x 11in. (21.9 x 27.9cm) Gift of Professor Richard Krautheimer, in honor of Jacob Bean, 1992                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
213411 1992.303 0 1 340807 Drawings and Prints 11 Drawing 23 Landscape with Two Men Under a Tree.           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, brush and brown wash 29439 sheet: 7 1/2 x 9 11/16 in. (19 x 24.6 cm) Harry G. Sperling Fund, 1992                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
217642 59.644.48 0 1 345136 Drawings and Prints 11 Drawing 23 Framed Sketch for a Man, a Dog and a Tree           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 1612–66 1612 1666 Pen and brown ink, black and red chalk and light brown-gray wash 34099 5-3/8 x 7-3/8 in. (13.7 x 18.7 cm) irregular borders Gift of Harry G. Friedman, 1959                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
307016 1993.20 0 1 437101 European Paintings 15 Painting 69 The Rest on the Flight into Egypt           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666   1632 1666 Oil on copper 1953 9 x 11 in. (22.9 x 27.9 cm) Wrightsman Fund, 1993                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
308122 2009.400.88 0 0 440358 European Paintings 15 Painting 69 Coastal Landscape with Tower           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930 Italian 6 1612 1666 ca. 1651–52 1651 1652 Oil over red chalk on paper 44646 6 7/8 x 10 3/8 in. (17.5 x 26.4 cm) Thaw Collection, Jointly Owned by The Metropolitan Museum of Art and The Morgan Library & Museum, Gift of Eugene V. Thaw, 2009                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
405796 SL.6.2016.55.1 0 0 662703 Modern and Contemporary Art 4   Portrait of Alessandro VII Chigi           Artist 2   Pier Francesco Mola Italian, Coldrerio 1612–1666 Rome   Mola, Pier Francesco 18930   1612 1666 1659 1659 1659 Oil on canvas 953 46 7/8 × 37 3/8 in. (119 × 95 cm) Frame: 57 1/2 × 48 1/16 × 3 9/16 in. (146 × 122 × 9 cm) Private collection Country of Origin 23       Italy 14             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 200.924ms · Data license: CC0 · Data source: metmuseum/openaccess