MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Medium = 39797

View and edit SQL

Suggested facets: Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist 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
248731 42.66.8 0 0 377142 Drawings and Prints 11 Print 731 Portrait of a Peasant Woman           Artist|Artist|Publisher 895 After Francesco Bartolozzi|Hans Holbein the Younger|John Chamberlaine Italian, Florence 1728–1815 Lisbon|German, Augsburg 1497/98–1543 London|British, ca. 1745–1812 London   Bartolozzi, Francesco|Holbein, Hans, the Younger|Chamberlaine, John 35148 Italian|German|British 2792 1728 |1497 |1740 1815 |1543 |1812 August 1, 1799 1799 1799 Etching and stipple engraving, printed in color; second state 39797 plate: 17 x 11 in. (43.2 x 27.9 cm) sheet: 21 1/2 x 15 3/4 in. (54.6 x 40 cm) Gift of Mrs. Thomas T. Gaunt, 1942                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248736 42.66.13 0 0 377147 Drawings and Prints 11 Print 731 Portrait of an Unknown Girl           Publisher|Artist|Artist 878 After John Chamberlaine|Francesco Bartolozzi|Hans Holbein the Younger British, ca. 1745–1812 London|Italian, Florence 1728–1815 Lisbon|German, Augsburg 1497/98–1543 London   Chamberlaine, John|Bartolozzi, Francesco|Holbein, Hans, the Younger 35348 British|Italian|German 2825 1740 |1728 |1497 1812 |1815 |1543 February 15, 1800 1800 1800 Etching and stipple engraving, printed in color; second state 39797 plate: 13 3/8 x 9 1/16 in. (34 x 23 cm) sheet: 19 11/16 x 14 3/8 in. (50 x 36.5 cm) Gift of Mrs. Thomas T. Gaunt, 1942                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248739 42.66.16 0 0 377150 Drawings and Prints 11 Print 731 Elizabeth Dauncey           Artist|Artist|Publisher 895 After Francesco Bartolozzi|Hans Holbein the Younger|John Chamberlaine Italian, Florence 1728–1815 Lisbon|German, Augsburg 1497/98–1543 London|British, ca. 1745–1812 London   Bartolozzi, Francesco|Holbein, Hans, the Younger|Chamberlaine, John 35148 Italian|German|British 2792 1728 |1497 |1740 1815 |1543 |1812 September 22, 1795 1795 1795 Etching and stipple engraving, printed in color; second state 39797 plate: 16 1/2 x 11 1/2 in. (41.9 x 29.2 cm) sheet: 21 5/16 x 15 7/8 in. (54.1 x 40.3 cm) Gift of Mrs. Thomas T. Gaunt, 1942                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248771 42.66.48 0 0 377182 Drawings and Prints 11 Print 731 Sir John More           Publisher|Artist|Artist 878 After John Chamberlaine|Francesco Bartolozzi|Hans Holbein the Younger British, ca. 1745–1812 London|Italian, Florence 1728–1815 Lisbon|German, Augsburg 1497/98–1543 London   Chamberlaine, John|Bartolozzi, Francesco|Holbein, Hans, the Younger 35348 British|Italian|German 2825 1740 |1728 |1497 1812 |1815 |1543 March 1792 1792 1792 Etching and stipple engraving, printed in color; second state 39797 plate: 16 1/8 x 13 in. (41 x 33 cm) sheet: 21 3/4 x 15 7/8 in. (55.2 x 40.3 cm) Gift of Mrs. Thomas T. Gaunt, 1942                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248772 42.66.49 0 0 377183 Drawings and Prints 11 Print 731 Sir Thomas More, Lord Chancellor           Publisher|Artist|Artist 878 After John Chamberlaine|Francesco Bartolozzi|Hans Holbein the Younger British, ca. 1745–1812 London|Italian, Florence 1728–1815 Lisbon|German, Augsburg 1497/98–1543 London   Chamberlaine, John|Bartolozzi, Francesco|Holbein, Hans, the Younger 35348 British|Italian|German 2825 1740 |1728 |1497 1812 |1815 |1543 October 1, 1793 1793 1793 Etching and stipple engraving, printed in color; second state 39797 plate: 18 1/4 x 13 3/8 in. (46.4 x 34 cm) sheet: 19 7/8 x 15 in. (50.5 x 38.1 cm) Gift of Mrs. Thomas T. Gaunt, 1942                       Prints 13   Metropolitan Museum of Art, New York, NY 1
248841 17.3.3498 0 0 377252 Drawings and Prints 11 Print 731 Vigilance           Artist|Artist|Publisher 895 After|Published by Francesco Bartolozzi|Giovanni Battista Cipriani|Susannah Vivares Italian, Florence 1728–1815 Lisbon|Italian, Florence 1727–1785 Hammersmith (active London)|British, active 1781–1797 , London Bartolozzi, Francesco|Cipriani, Giovanni Battista|Vivares, Susannah 35329 Italian|Italian|British 1966 1728 |1727 |1781 1815 |1785 |1797 December 24, 1782 1782 1782 Etching and stipple engraving, printed in color; second state 39797 Sheet: 6 7/8 × 4 9/16 in. (17.5 × 11.6 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 147.006ms · Data license: CC0 · Data source: metmuseum/openaccess