MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Alpha Sort = 20443

View and edit SQL

Suggested facets: Object Name, Artist Role, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

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
216066 1972.538.1 0 0 343497 Drawings and Prints 11 Print 731 A Lady in a Turkish Dress           Artist|Artist 13 After William Wynne Ryland|Angelica Kauffmann British, baptized London 1732–1783 London|Swiss, Chur 1741–1807 Rome   Ryland, William Wynne|Kauffmann, Angelica 20443 British|Swiss 295 1732 |1741 1783 |1807 1775 1775 1775 Stipple engraving, printed in color with hand-coloring 33644 sheet: 14 5/8 x 11 1/8 in. (37.1 x 28.3 cm) (cut to plate line) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434634 17.3.2424 0 0 722574 Drawings and Prints 11 Print 731 Hope           Engraver|Artist 629 After William Wynne Ryland|Angelica Kauffmann British, baptized London 1732–1783 London|Swiss, Chur 1741–1807 Rome   Ryland, William Wynne|Kauffmann, Angelica 20443   1732 |1741 1783 |1807 1775 1775 1775 Stipple engraving, printed in red ink 39701 Plate: 8 7/8 × 7 3/8 in. (22.5 × 18.7 cm) Sheet: 10 1/16 × 8 1/2 in. (25.6 × 21.6 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434715 20.93.5 0 0 722727 Drawings and Prints 11 Prints 5018 Venus Triumphant           Engraver|Artist 629 After William Wynne Ryland|Angelica Kauffmann British, baptized London 1732–1783 London|Swiss, Chur 1741–1807 Rome   Ryland, William Wynne|Kauffmann, Angelica 20443   1732 |1741 1783 |1807 1778 1778 1778 Stipple engraving and etching, printed in reddish brown ink 61530 Image: 12 × 12 in. (30.5 × 30.5 cm) Sheet (trimmed to round shape): 13 × 13 in. (33 × 33 cm) Gift of Mrs. Morris L. Chaim, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434730 20.93.2 0 0 722742 Drawings and Prints 11 Prints 5018 Porrigit Hic Veneri Lucida Dona Paris (The Judgment of Paris)           Engraver|Artist 629 After William Wynne Ryland|Angelica Kauffmann British, baptized London 1732–1783 London|Swiss, Chur 1741–1807 Rome   Ryland, William Wynne|Kauffmann, Angelica 20443   1732 |1741 1783 |1807 1778 1778 1778 Stipple engraving and etching, printed in reddish brown ink 61530 Image (circular): 11 3/16 × 11 3/16 in. (28.4 × 28.4 cm) Sheet (trimmed): 13 7/8 × 13 7/8 in. (35.2 × 35.2 cm) Gift of Mrs. Morris L. Chaim, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434767 20.93.4 0 0 722786 Drawings and Prints 11 Prints 5018 Venus Presenting Helen to Paris           Engraver|Artist 629 After William Wynne Ryland|Angelica Kauffmann British, baptized London 1732–1783 London|Swiss, Chur 1741–1807 Rome   Ryland, William Wynne|Kauffmann, Angelica 20443   1732 |1741 1783 |1807 1781 1781 1781 Stipple engraving, printed in reddish brown and pink 61537 Image (circular): 11 5/16 × 11 5/16 in. (28.7 × 28.7 cm) Sheet (trimmed to octagon): 13 1/8 in. × 13 in. (33.3 × 33 cm) Gift of Mrs. Morris L. Chaim, 1920                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434769 20.93.3 0 0 722791 Drawings and Prints 11 Print 731 The Flight of Paris and Helen           Engraver|Artist 629 After William Wynne Ryland|Angelica Kauffmann British, baptized London 1732–1783 London|Swiss, Chur 1741–1807 Rome   Ryland, William Wynne|Kauffmann, Angelica 20443   1732 |1741 1783 |1807 1781 1781 1781 Stipple engraving, printed in reddish brown and pink 61537 Image (circle): 7 1/4 × 7 1/4 in. (18.4 × 18.4 cm) Sheet (trimmed into circle): 12 7/8 × 12 7/8 in. (32.7 × 32.7 cm) Gift of Mrs. Morris L. Chaim, 1920                       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 149.279ms · Data license: CC0 · Data source: metmuseum/openaccess