MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Alpha Sort = 19137

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Object Begin 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
211151 1999.404 0 1 338539 Drawings and Prints 11 Print 731 A Massacre by the Triumvirate           Artist 2   Claude Vignon French, Tours 1593–1670 Paris   Vignon, Claude 19137 French 2 1593 1670 ca. 1624 1619 1629 Etching 26137 sheet: 10 x 14in. (25.4 x 35.6cm) Purchase, Walter E. Sachs and Mrs. Henry Bernheim Gift, by exchange; Harris Brisbane Dick Fund, by exchange; Charles Z. Offin Fund; Gift of Mrs. Gardner Cassatt, by exchange; purchase, by exchange; and The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1999                       Prints 13   Metropolitan Museum of Art, New York, NY 1
216021 2001.286 0 1 343452 Drawings and Prints 11 Drawing 23 Adoration of the Shepherds           Artist 2   Claude Vignon French, Tours 1593–1670 Paris   Vignon, Claude 19137 French 2 1593 1670 ca. 1620–30 1615 1635 Brush and black and brown wash over black chalk on buff paper 33631 13 15/16 x 9 3/16 in. (35.4 x 23.3 cm) Purchase, Guy Wildenstein Gift, 2001                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
258379 2010.158 0 1 387073 Drawings and Prints 11 Drawing 23 Cleopatra           Artist 2   Claude Vignon French, Tours 1593–1670 Paris   Vignon, Claude 19137 French 2 1593 1670 1647 1647 1647 Red and black chalk 29392 sheet: 12 5/8 x 8 1/2 in. (32 x 21.6 cm) Purchase, Charles and Jessie Price and Mrs. Howard J. Barnet Gifts, 2010                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
262010 1971.558.10 0 1 390922 Drawings and Prints 11 Print 731 The Martyrdom of St. Catherine           Artist 2   Claude Vignon French, Tours 1593–1670 Paris   Vignon, Claude 19137 French 2 1593 1670 ca. 1627 1622 1632 Etching; second state of two (Pacht Bassani) 42266 sheet: 8 1/4 x 10 3/8 in. (21 x 26.3 cm) Purchase, The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1971                       Prints 13   Metropolitan Museum of Art, New York, NY 1
262011 17.50.15-45 0 1 390923 Drawings and Prints 11 Print 731 The Adoration of the Magi           Artist 2   Claude Vignon French, Tours 1593–1670 Paris   Vignon, Claude 19137 French 2 1593 1670 1619 1619 1619 Etching in reverse; first state of two (Pacht Bassani) 42267 sheet: 9 7/16 x 6 9/16 in. (24 x 16.7 cm) Purchase, Joseph Pulitzer Bequest, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
266277 2011.28 0 1 395254 Drawings and Prints 11 Print 731 The Martyrdom of Saint Andrew           Artist 2   Claude Vignon French, Tours 1593–1670 Paris   Vignon, Claude 19137 French 2 1593 1670 1623 1623 1623 Etching 26137 sheet: 7 3/8 x 10 3/8 in. (18.8 x 26.4 cm) A. Hyatt Mayor Purchase Fund, Marjorie Phelps Starr Bequest, 2011                       Prints 13   Metropolitan Museum of Art, New York, NY 1
270507 2011.449.1–.13 0 0 399633 Drawings and Prints 11 Print 731 The Miracles of Our Lord Jesus Christ (Les Miracles de notre Seigneur Jésus-Christ)           Artist 2   Claude Vignon French, Tours 1593–1670 Paris   Vignon, Claude 19137 French 2 1593 1670 1638–43 1638 1643 Suite of 13 etchings 43159 Each approx. 22 x 16 cm (see attached list) Purchase, Phyllis D. Massar Gift, 2011                       Prints 13   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 130.163ms · Data license: CC0 · Data source: metmuseum/openaccess