MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 71 and Department = 3

View and edit SQL

Suggested facets: Object Name, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, 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
104175 11.133.1 0 1 191782 European Sculpture and Decorative Arts 3 Figure 9 Boy British, Burslem, Staffordshire 2356         Artist|Maker|Maker 71 After a model by|Style of|Style of Paul-Louis Cyfflé|Ralph Wood the Elder|Ralph Wood the Younger French, Bruges 1724–1806 Brussels|British, Burslem 1715–1772 Burslem|British, Burslem 1748–1795 Burslem   Cyfflé, Paul-Louis|Wood, Ralph, the Elder|Wood, Ralph, the Younger 8741   1724 |1715 |1748 1806 |1772 |1795 18th century 1700 1799 Lead-glazed earthenware 20492 Height: 8 3/4 in. (22.2 cm) Frederick C. Hewitt Fund, 1911                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
108930 32.75.37a, b 0 1 196972 European Sculpture and Decorative Arts 3 Pair-case repeating watch 7631 Pair-case watch with repeating mechanism British, London 222         Artist|Maker|Maker 71 Engraved scene on outer case based on an etching by|Watchmaker:|Case maker: Sébastien Leclerc I|Charles Cabrier II|Frederick Wieland French, Metz 1637–1714 Paris|British, 1719–1765|British, active ca. 1731–after 1759   Leclerc, Sébastien, I|Cabrier, Charles II|Wieland, Frederick 9775   1637 |1719 |1700 1714 |1765 |1831 1741–42 1741 1742 Outer case: gold; Inner case: pierced and engraved gold; Dial: white enamel 21978 Overall (watch with bail, confirmed): 2 3/8 × 1 9/16 × 1 1/8 in. (6 × 4 × 2.8 cm); Overall (outer case, confirmed): 1 7/8 × 1 7/8 × 7/8 in. (4.8 × 4.8 × 2.2 cm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Horology 316   Metropolitan Museum of Art, New York, NY 1
128721 11.148.3 0 1 219369 European Sculpture and Decorative Arts 3 Tapestry 1084 Christ Washing the Feet of His Disciples from a set of The Passion German, Alsace, possibly Strasbourg 3698         Artist|Maker|Maker 71 Design based on a woodcut by||and Albrecht Dürer|Unidentified Weaver's Mark|Unidentified Weaver's Mark German, Nuremberg 1471–1528 Nuremberg , from the Small Passion|(ICM)|(AR) Dürer, Albrecht|Unidentified Weaver's Mark|Unidentified Weaver's Mark 12319 German 10 1471 1528 1595 1595 1595 Wool, silk, metal thread (20 warp threads per inch, 8 per cm.) 24607 39 1/2 x 29 3/4 in. (100.3 x 75.6 cm) Gift of J. Pierpont Morgan, 1911                       Textiles-Tapestries 186   Metropolitan Museum of Art, New York, NY 1
128722 11.148.4 0 1 219370 European Sculpture and Decorative Arts 3 Tapestry 1084 The Baptism of Christ from a set of The Passion German, Alsace, possibly Strasbourg 3698         Artist|Maker|Maker 71 Design based on an engraving by||and Martin Schongauer|Unidentified Weaver's Mark|Unidentified Weaver's Mark German, Colmar ca. 1435/50–1491 Breisach (The Baptism of Christ)|(AR)|(ICM) Schongauer, Martin|Unidentified Weaver's Mark|Unidentified Weaver's Mark 12321 German 10 1435 1491 1595 1595 1595 Wool, silk, metal thread (20 warp threads per inch, 8 per cm.) 24607 39 1/2 x 29 3/4 in. (100.3 x 75.6 cm) Gift of J. Pierpont Morgan, 1911                       Textiles-Tapestries 186   Metropolitan Museum of Art, New York, NY 1
128723 11.148.5 0 1 219371 European Sculpture and Decorative Arts 3 Tapestry 1084 Christ Carrying the Cross from a set of The Passion German, Alsace, possibly Strasbourg 3698         Artist|Maker|Maker 71 Design based on a woodcut by||and Albrecht Dürer|Unidentified Weaver's Mark|Unidentified Weaver's Mark German, Nuremberg 1471–1528 Nuremberg , from the Small Passion|(AR)|(ICM) Dürer, Albrecht|Unidentified Weaver's Mark|Unidentified Weaver's Mark 12319 German 10 1471 1528 1598 1598 1598 Wool, silk, metal thread (20 warp threads per inch, 8 per cm.) 24607 39 1/2 x 29 3/4 in. (100.3 x 75.6 cm) Gift of J. Pierpont Morgan, 1911                       Textiles-Tapestries 186   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 4624.438ms · Data license: CC0 · Data source: metmuseum/openaccess