MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Culture = 52 and Department = 18

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City, County, Country, Classification

Department

  • Musical Instruments · 6
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
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
347488 89.4.1591 0 0 502155 Musical Instruments 18 Mass Bell 16235 Mass Bell Flemish 52                           19th century 1801 1900 Metal 772 Height 11.3 cm, Diameter 12.6 cm, Weight 186 g The Crosby Brown Collection of Musical Instruments, 1889       Flanders 819 Belgium 576             Idiophone-Struck-bell-clapper 950   Metropolitan Museum of Art, New York, NY 1
347489 89.4.1592 0 0 502156 Musical Instruments 18 Mass Bell 16235 Mass Bell Flemish 52                           19th century 1801 1900 Metal 772 Height 14.6 cm, Diameter 13.8 cm, Weight 176 g The Crosby Brown Collection of Musical Instruments, 1889       Flanders 819 Belgium 576             Idiophone-Struck-bell-clapper 950   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 235.5ms · Data license: CC0 · Data source: metmuseum/openaccess