MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

18 rows where Medium = 33026

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Prefix, Artist Display Name, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Credit Line, 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
213933 50.535.13 0 0 341352 Drawings and Prints 11 Drawing 23 La France et la Religion           Artist 2   Jean Charles Delafosse French, Paris 1734–1789 Paris   Delafosse, Jean Charles 18214 French 2 1734 1789 1750–89 1750 1789 Pen and gray ink, brush and gray wash 33026 10 1/4 x 7 3/8 in. (26 x 18.7 cm) *the sheet is cut irregularly at the bottom* The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1950                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
215934 68.557.3 0 1 343364 Drawings and Prints 11 Drawing 23 Elevation of a Wall           Artist 2 Attributed to Jean Guillaume Moitte French, Paris 1746–1810 Paris   Moitte, Jean Guillaume 12868 French 2 1746 1810 1776 1776 1776 Pen and gray ink, brush and gray wash 33026 20 3/8 x 13 15/16 in. (51.8 x 35.4 cm) Gift of Stephen Spector, 1968                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
216343 1971.513.38 0 1 343774 Drawings and Prints 11 Drawing Collection Ornament & Architecture 13830 Design for an Arabesque with Cupid and Psyche           Artist 2 Circle of Claude Gillot French, Langres 1673–1722 Paris   Gillot, Claude 17909 French 2 1673 1722 1720–40 1720 1740 Pen and gray ink, brush and gray wash 33026 12 1/2 x 8 5/16 in. (31.8 x 21.1 cm) Purchase, Harris Brisbane Dick Fund and Joseph Pulitzer Bequest, 1971                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
216793 61.680.5.1 0 1 344276 Drawings and Prints 11 Drawing 23 Design for Ornamented Stair Railing           Artist 2   Anonymous, French, 18th century     Anonymous, French, 18th century 19522 French 2 1700 1800 ca. 1770–90 1765 1795 Pen and gray ink, brush and gray wash 33026 10 7/16 x 8 3/8 in. (26.5 x 21.2 cm) Gift of Raphael Esmerian, 1961                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
216794 61.680.5.2 0 1 344277 Drawings and Prints 11 Drawing 23 Design for Ornamented Stair Railing           Artist 2   Anonymous, French, 18th century     Anonymous, French, 18th century 19522 French 2 1700 1800 ca. 1770–90 1765 1795 Pen and gray ink, brush and gray wash 33026 10 1/2 x 8 3/8 in. (26.6 x 21.3 cm) Gift of Raphael Esmerian, 1961                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
219894 1974.204 0 1 347421 Drawings and Prints 11 Drawing 23 Europe           Artist 2   Godfried Maes Antwerp 1649–1700 Antwerp   Maes, Godfried 18332 Flemish 87 1649 1700 17th century 1660 1700 Pen and gray ink, brush and gray wash 33026 sheet: 10 3/4 x 8 1/4in. (27.3 x 21cm) Gift of the Estate of James Hazen Hyde, 1959                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
223307 1971.513.79 0 1 350883 Drawings and Prints 11 Drawing 23 Design for an Overdoor           Artist 2   Anonymous, French, 17th century     Anonymous, French, 17th century 17516 French 2 1600 1700 ca. 1640 1635 1645 Pen and gray ink, brush and gray wash 33026 11 1/2 x 9 1/2 in. (29.2 x 24.1 cm) Purchase, Harris Brisbane Dick Fund and Joseph Pulitzer Bequest, 1971                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
234312 50.576.4 0 1 362068 Drawings and Prints 11 Drawing 23 Façade of the Madeleine, Paris           Artist 2   Jean-Arnould Léveil French, Paris 1806–1866 Paris   Léveil, Jean-Arnould 31729 French 2 1806 1866 mid-19th century 1820 1866 Pen and gray ink, brush and gray wash 33026 19 13/16 x 26 3/8 in. (50.3 x 67 cm) Gift of Joseph Verner Reed, 1950                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
234313 83.2.1105 0 1 362069 Drawings and Prints 11 Drawing 23 Boston Harbor           Artist 2   Pierre Ozanne French, Brest 1737–1813 Brest   Ozanne, Pierre 18274 French 2 1737 1813 1778 1778 1778 Pen and gray ink, brush and gray wash 33026 11 11/16 x 24 3/16 in. (29.7 x 61.4 cm) Gift of William H. Huntington, 1883                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
235181 34.78.2(62) 0 1 362940 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Ceiling Vault of Palazzo Mattei, Rome           Artist 2   Sir William Chambers British (born Sweden), Göteborg 1723–1796 London   Chambers, William Sir 22836 British, born Sweden 486 1723 1796 1750–59 1750 1759 Pen and gray ink, brush and gray wash 33026 sheet: 14 5/16 x 9 11/16 in. (36.4 x 24.6 cm) Harris Brisbane Dick Fund, 1934                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
243808 2006.296 0 1 372015 Drawings and Prints 11 Drawing 23 Marketplace of Delft with the Nieuwekerk           Artist 2   Gerrit Toorenburgh Dutch, Amsterdam 1732–1785 Nijerk   Toorenburgh, Gerrit 34298 Dutch 11 1732 1785 18th century 1740 1785 Pen and gray ink, brush and gray wash 33026 sheet: 8 3/8 x 7 7/16 in. (21.3 x 18.9 cm) Purchase, Jean A. Bonna Gift, 2006                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
245680 2007.275 0 1 373910 Drawings and Prints 11 Drawing 23 Study of Two Women Grieving           Artist 2   John Flaxman British, York 1755–1826 London   Flaxman, John 10727 British 7 1755 1826 before 1787 1775 1787 Pen and gray ink, brush and gray wash 33026 sheet: 13 3/8 x 9 7/16 in. (34 x 24 cm) Purchase, Catherine G. Curran, Jeffrey L. Berenson, PECO Foundation, and Susan H. Seidel Gifts, 2007                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
249257 2007.278 0 1 377673 Drawings and Prints 11 Drawing 23 Design for an Ornamental Frame           Artist 2   Pieter Tanjé Dutch, Bolsward 1706–1761 Amsterdam   Tanjé, Pieter 18313 Dutch 11 1706 1761 18th century 1715 1761 Pen and gray ink, brush and gray wash 33026 sheet: 13 15/16 x 8 11/16 in. (35.4 x 22.1 cm) Purchase, Oscar de la Renta Ltd. Gift, Van Day Truex Fund, and funds from various donors, 2007                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
254537 Scholz 1955.1 0 1 383156 Drawings and Prints 11 Drawing 23 The Invitation           Artist 2 Attributed to Anonymous, French, 18th century     Anonymous, French, 18th century 19522 French 2 1700 1800 18th century 1700 1799 Pen and gray ink, brush and gray wash 33026 sheet: 4 1/16 x 2 1/4 in. (10.3 x 5.7 cm) Gift of Janos Scholz, 1955                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
254538 Scholz 1955.2 0 1 383157 Drawings and Prints 11 Drawing 23 Magna Carta           Artist 2 Attributed to Anonymous, French, 18th century     Anonymous, French, 18th century 19522 French 2 1700 1800 18th century 1700 1799 Pen and gray ink, brush and gray wash 33026 sheet: 3 3/8 x 2 1/8 in. (8.5 x 5.4 cm) Gift of Janos Scholz, 1955                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
254715 61.658.41 0 1 383339 Drawings and Prints 11 Collection Ornament & Architecture 13829 Triumphal Entry of King           Artist 2   Anonymous, German, 17th century     Anonymous, German, 17th century 11385 German 10 1600 1700 17th century 1600 1700 Pen and gray ink, brush and gray wash 33026 sheet: 10 3/4 x 16 5/16 in. (27.3 x 41.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1961                       Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
254728 63.712.52 0 1 383352 Drawings and Prints 11 Drawing 23 Architectural design in Roman order           Artist 2 Attributed to Anonymous, 18th century     Anonymous, 18th century 25532   1700 1800 18th century 1700 1800 Pen and gray ink, brush and gray wash 33026 sheet: 4 7/16 x 4 15/16 in. (11.3 x 12.6 cm) Gift of Regina Slatkin, 1963                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
256572 2009.401 0 1 385249 Drawings and Prints 11 Drawing 23 Standing Roman           Artist 2 In the style of Sir Lawrence Alma-Tadema British (born The Netherlands), Dronrijp 1836–1912 Wiesbaden   Alma-Tadema, Lawrence, Sir 12597 British, born The Netherlands 298 1836 1912 1875–90 1875 1890 Pen and gray ink, brush and gray wash 33026 sheet: 10 1/2 x 7 1/16 in. (26.6 x 18 cm) Harry G. Sperling Fund, 2009                       Drawings 9   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 126.911ms · Data license: CC0 · Data source: metmuseum/openaccess