MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Medium = 28939

View and edit SQL

Suggested facets: Is Public Domain, Portfolio, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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
206442 16.4.9 0 1 333786 Drawings and Prints 11 Print 731 Plate 17 from 'Los Caprichos': It is nicely stretched (Bien tirada está.)         Los Caprichos 2 Artist 2   Goya (Francisco de Goya y Lucientes) Spanish, Fuendetodos 1746–1828 Bordeaux   Goya (Francisco de Goya y Lucientes) 15462 Spanish 76 1746 1828 1797–98 1797 1798 Etching, aquatint, drypoint, and burin 28939 Sheet: 9 13/16 x 5 15/16 in. (24.99 x 15.01cm) Gift of Walter E. Sachs, 1916                       Prints 13   Metropolitan Museum of Art, New York, NY 1
206457 18.64(1-80) 0 1 333801 Drawings and Prints 11 Print 731 The Caprices (Los Caprichos), plates 1-80         Complete set of the first edition 5 Artist 2   Goya (Francisco de Goya y Lucientes) Spanish, Fuendetodos 1746–1828 Bordeaux   Goya (Francisco de Goya y Lucientes) 15462 Spanish 76 1746 1828 1799 1799 1799 Etching, aquatint, drypoint, and burin 28939   Gift of M. Knoedler & Co., 1918                       Prints 13   Metropolitan Museum of Art, New York, NY 1
206793 50.558.33 0 1 334137 Drawings and Prints 11 Print 731 Plate 1 from 'Los Caprichos': Self-portrait of Goya (Franco. Goya e Lucientes, Pintor)         Los Caprichos 2 Sitter|Artist 392   Goya (Francisco de Goya y Lucientes)|Goya (Francisco de Goya y Lucientes) Spanish, Fuendetodos 1746–1828 Bordeaux|Spanish, Fuendetodos 1746–1828 Bordeaux   Goya (Francisco de Goya y Lucientes)|Goya (Francisco de Goya y Lucientes) 17416 Spanish|Spanish 85 1746 |1746 1828 |1828 1799 1799 1799 Etching, aquatint, drypoint, and burin 28939 Plate: 8 9/16 × 5 7/8 in. (21.7 × 15 cm) Sheet: 12 5/16 × 8 3/16 in. (31.2 × 20.8 cm) Gift of Mrs. Francis Ormond, 1950                       Prints 13   Metropolitan Museum of Art, New York, NY 1
206802 51.530.1 0 0 334146 Drawings and Prints 11 Print 731 Bound set of 'Los Caprichos'           Artist and engraver 1025   Goya (Francisco de Goya y Lucientes) Spanish, Fuendetodos 1746–1828 Bordeaux   Goya (Francisco de Goya y Lucientes) 15462 Spanish 76 1746 1828 1881–86 1881 1886 Etching, aquatint, drypoint, and burin 28939 Plate: 8 9/16 x 5 15/16 in. (21.8 x 15.1 cm) Sheet: 12 5/16 x 8 1/4 in. (31.3 x 20.9 cm) Gift of Mrs. Grafton H. Pyne, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
206975 1972.507.1–6 0 0 334319 Drawings and Prints 11 Print 731 Late Caprichos of Goya         Bordeaux Etchings. Bound text by Eleanor Sayre and six plates printed by Emiliano Sorini, 1971 45 Artist|Author|Printer 947   Goya (Francisco de Goya y Lucientes)|Eleanor Sayre|Emiliano Sorini Spanish, Fuendetodos 1746–1828 Bordeaux|American, active 20th century   Goya (Francisco de Goya y Lucientes)|Sayre, Eleanor|Sorini, Emiliano 17512 Spanish|American|American 240 1746 |1916 |1900 1828 |2001 |1999 ca. 1824–28 1819 1833 Etching, aquatint, drypoint, and burin 28939   Administrative Purchase Fund, 1972                       Prints 13   Metropolitan Museum of Art, New York, NY 1
211085 18.64(43) 0 1 338473 Drawings and Prints 11 Print 731 Plate 43 from 'Los Caprichos': The sleep of reason produces monsters (El sueño de la razon produce monstruos)         Los Caprichos 2 Artist 2   Goya (Francisco de Goya y Lucientes) Spanish, Fuendetodos 1746–1828 Bordeaux   Goya (Francisco de Goya y Lucientes) 15462 Spanish 76 1746 1828 1799 1799 1799 Etching, aquatint, drypoint, and burin 28939 Plate: 8 3/8 x 5 15/16 in. (21.2 x 15.1 cm) Sheet: 11 5/8 x 8 1/4 in. (29.5 x 21 cm) Gift of M. Knoedler & Co., 1918                       Prints 13   Metropolitan Museum of Art, New York, NY 1
211086 18.64(44) 0 1 338474 Drawings and Prints 11 Print 731 Plate 44 from 'Los Caprichos': They spin finely (Hilan delgado.)         Los Caprichos 2 Artist 2   Goya (Francisco de Goya y Lucientes) Spanish, Fuendetodos 1746–1828 Bordeaux   Goya (Francisco de Goya y Lucientes) 15462 Spanish 76 1746 1828 1799 1799 1799 Etching, aquatint, drypoint, and burin 28939 Plate: 8 7/16 × 5 15/16 in. (21.4 × 15.1 cm) Sheet: 11 9/16 x 8 1/4 in. (29.4 x 21 cm) Gift of M. Knoedler & Co., 1918                       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 289.705ms · Data license: CC0 · Data source: metmuseum/openaccess