MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Department = 6 and Medium = 50

View and edit SQL

Suggested facets: Object Name, Culture, Object Date, Object Begin Date, Object End Date, Credit Line, Geography Type, 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
323599 05.17.2 0 1 462773 Medieval Art 6 Chest front 7094 Chest Front French 7                           15th century 1400 1499 Walnut 50 Overall: 26 1/2 x 71 3/8 x 1 5/8 in. (67.3 x 181.3 x 4.1 cm) Rogers Fund, 1905                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
324242 16.32.210 0 1 463813 Medieval Art 6 Relief 3917 Death of the Virgin German 27                           early 16th century 1500 1525 Walnut 50 Overall: 29 1/2 x 31 7/8 x 7 1/2 in. (74.9 x 81 x 19.1 cm) Gift of J. Pierpont Morgan, 1916 Made in 1     Calcar 633               Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
324643 17.190.375 0 1 464355 Medieval Art 6 Statuette 14 Man French 7                           15th century 1400 1499 Walnut 50 Overall: 13 1/8 x 4 1/8 x 2 5/8 in. (33.4 x 10.4 x 6.7 cm) Gift of J. Pierpont Morgan, 1917                       Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
324871 17.190.736 0 1 464605 Medieval Art 6 Relief 3917 Scenes from the Life of Christ Spanish 13         Artist 2   Gil de Siloe Spanish, active 1475–1505 (?) Siloe, Gil de 44653 Spanish 76 1475 1505 15th–18th century 1400 1799 Walnut 50 Overall: 33 1/2 x 22 x 5 1/2 in. (85.1 x 55.9 x 14 cm) Gift of J. Pierpont Morgan, 1917 Made in 1     Castile-Burgos 656 Spain 5             Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
327309 41.100.123 0 1 467695 Medieval Art 6 Table 477 Table, Polygonal Franco-Netherlandish 6001                           15th century 1400 1499 Walnut 50 28 1/2 x 25 1/4 x 41 1/2 in. (72.4 x 64.1 x 105.4 cm) Gift of George Blumenthal, 1941                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
327311 41.100.125 0 1 467697 Medieval Art 6 Chair 197 Chair French 7                           15th century 1400 1499 Walnut 50 Overall: 32 x 28 x 17 3/4 in. (81.3 x 71.1 x 45.1 cm) Gift of George Blumenthal, 1941                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
327322 41.100.136 0 1 467709 Medieval Art 6 Folding lectern 14831 Lectern, Folding Spanish 13                           15th century 1400 1499 Walnut 50 9 3/4 x 14 1/8 x 11 1/2 in. (24.8 x 35.9 x 29.2 cm) Gift of George Blumenthal, 1941                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
327356 41.100.176 0 1 467748 Medieval Art 6 Chest 214 Chest Northern European 545                           early 16th century 1500 1525 Walnut 50 32 x 25 x 65 1/2 in. (81.3 x 63.5 x 166.4 cm) Gift of George Blumenthal, 1941                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
327371 41.100.197 0 1 467769 Medieval Art 6 Table 477 Table, Octagonal Northern European 545                           late 16th century 1575 1599 Walnut 50 31 1/4 x 39 x 40 in. (79.4 x 99.1 x 101.6 cm) Gift of George Blumenthal, 1941                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
327375 41.100.203 0 1 467775 Medieval Art 6 Statuette 14 Virgin and Child South Netherlandish or French 6017                           ca. 1400–20 1395 1425 Walnut 50 Overall: 5 15/16 x 4 1/16 x 3 1/4 in. (15.1 x 10.3 x 8.3 cm) Gift of George Blumenthal, 1941 Made in|Made in 6 Burgundy 1985 | 96   French|Belgium 583             Sculpture-Miniature-Wood 820   Metropolitan Museum of Art, New York, NY 1
327479 41.190.81 0 1 468041 Medieval Art 6 Statuette 14 Saint George and the Dragon French 7                           early 16th century 1500 1525 Walnut 50 Overall: 35 1/4 x 31 in. (89.5 x 78.7 cm) Bequest of George Blumenthal, 1941                       Sculpture-Wood 166   Metropolitan Museum of Art, New York, NY 1
327743 50.64 0 1 468353 Medieval Art 6 Statuette 14 Saint Catherine of Alexandria German 27                           ca. 1530 1530 1530 Walnut 50 Overall: 14 15/16 x 7 3/16 x 5 1/4 in. (38 x 18.3 x 13.3 cm) Gift of Edith Sachs, 1950                       Sculpture-Wood 166   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 139.199ms · Data license: CC0 · Data source: metmuseum/openaccess