MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Role = 1 and Culture = 52

View and edit SQL

Suggested facets: Is Highlight, Department, Object Name, Title, Artist Nationality, Object Begin Date, Credit Line, City, Country

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
104330 12.137.7 0 1 191950 European Sculpture and Decorative Arts 3 Roundel 760 Allegory of Rout and Pillage Flemish 52         Maker 1 Style of Dirck Vellert Netherlandish, Amsterdam (?) ca. 1480/85–ca. 1547   Vellert, Dirck 8777 Netherlandish 179 1475 1552 ca. 1520 1515 1525 Colorless glass, vitreous paint and silver stain 21119 Diameter: 9 3/4 in. (24.8 cm) Rogers Fund, 1912                       Glass-Stained 147   Metropolitan Museum of Art, New York, NY 1
107190 24.80.95a, b 0 1 195125 European Sculpture and Decorative Arts 3 Cup 107 Cup Flemish 52         Maker 1 Possibly by Lukas Faydherbe Flemish, Mechelen 1617–1697 Mechelen   Faydherbe, Lukas 9482   1617 1697 17th century 1600 1699 Ivory 148 17 3/4 × 4 3/4 in. (45.1 × 12.1 cm) Bequest of Mary Clark Thompson, 1923                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
129172 17.120.121 0 1 219963 European Sculpture and Decorative Arts 3 Tapestry fragment 8745 Garden and Hunting Scene Flemish 52         Maker 1   Unidentified Weaver's Mark     Unidentified Weaver's Mark 12354       late 16th century 1585 1599 Wool, silk (16-19 warps per inch, 7 per cm.) 24649 H. 69 x W. 78 inches (175.3 x 198.1 cm) Mr. and Mrs. Isaac D. Fletcher Collection, Bequest of Isaac D. Fletcher, 1917                       Textiles-Tapestries 186   Metropolitan Museum of Art, New York, NY 1
139631 2008.196a, b 0 1 236190 European Sculpture and Decorative Arts 3 Statuette 14 Mercury Flemish 52         Maker 1   Gert van Egen Flemish (active Denmark), documented 1568, died 1611 or 1612   Egen Gert van 12738   1511 1612 1611 1611 1611 Alabaster, partly polychromed and gilded 25372 Overall on base (confirmed): H. 13 x W. 4 11/16 x D. 3 9/16 in. (33 x 11.9 x 9 cm); Overall figure only: H. 9 7/8 x W. 4 1/16 x D. 3 3/8 in. (25.1 x 10.3 x 8.6 cm) European Sculpture and Decorative Arts Fund, 2008                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
347116 89.4.1196 1 1 501767 Musical Instruments 18 Double Virginal 16090 Double Virginal Flemish 52         Maker 1   Lodewijck Grouwels Flemish, active Middelburg, Zeeland, The Netherlands 1593–1600   Grouwels Lodewijck 47776 Flemish, active The Netherlands 3498 1593 1600 1600 1600 1600 Pine, spruce, paint, gilding, ivory 54383 W. 75 × D. 20 in. (190.5 × 50.8 cm) The Crosby Brown Collection of Musical Instruments, 1889   Middelburg 2197   Zeeland 923 The Netherlands 443             Chordophone-Zither-plucked-virginal 919   Metropolitan Museum of Art, New York, NY 1
348894 89.4.2363 0 1 503614 Musical Instruments 18 Harpsichord 8383 Harpsichord Flemish 52         Maker 1   Jan Couchet the Elder Flemish, Antwerp 1615–1655 Antwerp   Couchet, Jan, the Elder 48045 Flemish 87 1615 1655 ca. 1650 1650 1650 Wood and various materials 53951 L. 229 cm (90 1/8 in.); W. 85.5 cm (33 3/4 in.); D. 26.9 cm (10 1/2 in.); 3-octave span 50.1 cm (19 3/4 in.) Sounding length (longer 8' choir, plucking points): 8' 4' FF 169.3 (15.1) 92.5 (5.9) c2 33.1 (6.1) 15.3 (2.8) c3 16.9 (4.4) 7.7 (2.5) The Crosby Brown Collection of Musical Instruments, 1889   Antwerp 504     Flemish 882             Chordophone-Zither-plucked-harpsichord 923   Metropolitan Museum of Art, New York, NY 1
348953 29.90 0 1 503676 Musical Instruments 18 Double Virginal 16090 Double Virginal Flemish 52         Maker 1   Hans Ruckers the Elder Flemish, Mechelen ca. 1545–1598 Antwerp   Ruckers Hans the Elder 48068 Flemish 87 1545 1598 1581 1550 1625 Pine, beech, poplar, mahogany, paint, gesso, metal, parchment, brass 54982 Width: 71 3/4 in. (182.2 cm) Depth: 19 1/2 in. (49.5 cm) Gift of B. H. Homan, 1929   Antwerp 504     Flemish 882             Chordophone-Zither-plucked-virginal|Paintings 1016   Metropolitan Museum of Art, New York, NY 1
350141 11.176.1 0 1 505004 Musical Instruments 18 Muselar Virginal 17217 Muselar Virginal Flemish 52         Maker 1   Joannes (Jan) Ruckers Flemish, Antwerp 1578–1642 Antwerp   Ruckers, Joannes (Jan) 48353 Flemish 87 1578 1642 1622 1622 1622 Wood, paint, bone, metal, beech, leather 55335 Height: 9 7/16 in. (24 cm) Width (parallel to keyboard): 67 1/4 in. (170.8 cm) Depth (perpendicular to keyboard): 19 3/16 in. (48.8 cm) Gift of Bernardus Boekelman, 1911         Belgium 576             Chordophone-Zither-plucked 926   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 227.09ms · Data license: CC0 · Data source: metmuseum/openaccess