MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Medium = 39698

View and edit SQL

Suggested facets: Is Public Domain, Title, Artist Prefix, Artist Nationality, Object Date, Object Begin Date, Object End Date, Dimensions, 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
248304 17.3.454 0 0 376606 Drawings and Prints 11 Print 731 The Whole Offspring of James and Mary Woodmason           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Charles Reuben Ryley|Robert Wilkinson Italian, Florence 1728–1815 Lisbon|British, London ca. 1752–1798 London|British, active 1760–1825 , London Bartolozzi, Francesco|Ryley, Charles Reuben|Wilkinson, Robert 35196 Italian|British|British 1105 1728 |1747 |1760 1815 |1798 |1825 January 1, 1798 1798 1798 Etching and engraving; second state of five 39698 image: 5 7/8 x 4 9/16 in. (15 x 11.6 cm) sheet: 11 5/16 x 8 11/16 in. (28.7 x 22.1 cm) Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
267523 32.35(134) 0 1 396566 Drawings and Prints 11 Print 731 Hudibras Vanquished by Trulla (Twelve Large Illustrations for Samuel Butler's Hudibras, Plate 5)           Author|Artist|Printer|Publisher 2869 Illustrates Samuel Butler|William Hogarth|Philip Overton|John Cooper British, baptized Strensham, Worcestershire 1613–1680 Covent Garden|British, London 1697–1764 London|British, active from 1707, died 1744|London   Butler, Samuel|Hogarth, William|Overton, Philip|Cooper, John 39492 British|British|British|British 177 1580 |1697 |1700 |1700 1680 |1764 |1744 |1800 February 1725–26 1725 1726 Etching and engraving; second state of five 39698 sheet: 9 7/8 x 12 7/8 in. (25.1 x 32.7 cm) (trimmed within platemark) Harris Brisbane Dick Fund, 1932                       Prints 13   Metropolitan Museum of Art, New York, NY 1
267531 32.35(132) 0 1 396574 Drawings and Prints 11 Print 731 Hudibras' First Adventure (Twelve Large Illustrations for Samuel Butler's Hudibras, Plate 3)           Publisher|Publisher|Artist|Author 4520 Illustrates Philip Overton|John Cooper|William Hogarth|Samuel Butler British, active from 1707, died 1744|London|British, London 1697–1764 London|British, baptized Strensham, Worcestershire 1613–1680 Covent Garden   Overton, Philip|Cooper, John|Hogarth, William|Butler, Samuel 38413 British|British|British|British 177 1700 |1700 |1697 |1580 1744 |1800 |1764 |1680 February 1725–26 1725 1726 Etching and engraving; second state of five 39698 sheet: 9 7/8 x 12 7/8 in. (25.1 x 32.7 cm) (trimmed within platemark) Harris Brisbane Dick Fund, 1932                       Prints 13   Metropolitan Museum of Art, New York, NY 1
456729 51.501.7164 0 1 770860 Drawings and Prints 11 Print 731 The education of the Virgin, with Saint Anne and the Virgin Mary reading with two putti overhead and Saint Joachim behind them at right           Publisher|Artist|Artist 878 After Martinus van den Enden|Schelte Adams à Bolswert|Peter Paul Rubens Flemish, active 1630–54|Dutch, Bolsward 1581–1659 Antwerp|Flemish, Siegen 1577–1640 Antwerp   Enden, Martinus van den|Bolswert, Schelte Adams à|Rubens, Peter Paul 58454   1630 |1581 |1577 1654 |1659 |1640 ca. 1630–54 1625 1654 Etching and engraving; second state of five 39698 Sheet (Trimmed): 15 11/16 × 11 15/16 in. (39.8 × 30.4 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
456734 17.3.2667 0 1 770866 Drawings and Prints 11 Print 731 The education of the Virgin, with Saint Anne and the Virgin Mary reading with two putti overhead and Saint Joachim behind them at right           Artist|Publisher|Artist 867 After Schelte Adams à Bolswert|Martinus van den Enden|Peter Paul Rubens Dutch, Bolsward 1581–1659 Antwerp|Flemish, active 1630–54|Flemish, Siegen 1577–1640 Antwerp   Bolswert, Schelte Adams à|Enden, Martinus van den|Rubens, Peter Paul 58455   1581 |1630 |1577 1659 |1654 |1640 ca. 1630–54 1625 1654 Etching and engraving; second state of five 39698 Sheet (Trimmed): 17 13/16 × 12 15/16 in. (45.3 × 32.8 cm) Harris Brisbane Dick Fund, 1917                       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 123.22ms · Data license: CC0 · Data source: metmuseum/openaccess