MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Is Highlight = 1 and Medium = 148

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Culture, Period, Object Date, Object Begin Date, Object End Date, Credit Line, Geography Type, Classification

Is Highlight

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
118040 1982.60.129 1 1 207032 European Sculpture and Decorative Arts 3 Statuette group 3389 Hercules and Achelous probably Austrian 284         Artist 2 Attributed to the Master of the Martyrdom of St. Sebastian Austrian   Master of the Martyrdom of St. Sebastian 11612 Austrian 66     probably mid-17th century 1630 1665 Ivory 148 Overall (confirmed): H. 11 x W. 6 1/4 x D. 4 3/8 in. (27.9 x 15.9 x 11.1 cm) The Jack and Belle Linsky Collection, 1982                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
149969 17.190.73 1 1 249186 Greek and Roman Art 12 Plaque with two women 11321 Ivory decorative plaque Greek 777 Archaic                         2nd half of 7th century B.C. -650 -600 Ivory 148 Overall: 5 3/8 x 2 3/4 x 5/8 in. (13.6 x 7 x 1.6 cm) Gift of J. Pierpont Morgan, 1917                       Miscellaneous-Bone, Ivory 426   Metropolitan Museum of Art, New York, NY 1
197083 1991.435a, b 1 1 316442 Arts of Africa, Oceania, and the Americas 10 Saltcellar 299 Lidded Saltcellar Sapi-Portuguese 4896                           15th–16th century 1400 1600 Ivory 148 H. 11 3/4 x Diam. 4 1/4 in. (29.8 x 10.8 cm) Gift of Paul and Ruth W. Tishman, 1991         Sierra Leone 175             Bone/Ivory-Containers 486   Metropolitan Museum of Art, New York, NY 1
203360 58.31.3 1 1 324739 Ancient Near Eastern Art 14 Relief 3917 Openwork furniture plaque with a grazing oryx in a forest of fronds Assyrian 5654 Neo-Assyrian                         ca. 9th–8th century B.C. -900 -700 Ivory 148 5 x 4.69 x 0.43 in. (12.7 x 11.91 x 1.09 cm) Rogers Fund, 1958           Mesopotamia 335 Nimrud (ancient Kalhu) 5         Ivory/Bone-Reliefs 624   Metropolitan Museum of Art, New York, NY 1
203678 60.145.11 1 1 325089 Ancient Near Eastern Art 14 Sculpture 100 Statuette of a man with an oryx, a monkey, and a leopard skin Assyrian 5654 Neo-Assyrian                         ca. 8th century B.C. -800 -700 Ivory 148 H. 5 5/16 x W. 3in. (13.5 x 7.6cm) Rogers Fund, 1960           Mesopotamia 335 Nimrud (ancient Kalhu) 5         Ivory/Bone-Sculpture 600   Metropolitan Museum of Art, New York, NY 1
204136 62.269.1 1 1 325562 Ancient Near Eastern Art 14 Sculpture 100 Furniture element carved in the round with the head of a roaring lion Assyrian 5654 Neo-Assyrian                         ca. 9th–8th century B.C. -900 -700 Ivory 148 H. 3 3/4 x W. 3 x D. 2 3/4in. (9.5 x 7.6 x 6.9cm) Rogers Fund, 1962           Mesopotamia 335 Nimrud (ancient Kalhu) 5         Ivory/Bone-Sculpture 600   Metropolitan Museum of Art, New York, NY 1
324648 17.190.38 1 1 464360 Medieval Art 6 Plaque 75 Plaque with Agnus Dei on a Cross between Emblems of the Four Evangelists South Italian 428                           1000–1050 1000 1050 Ivory 148 Overall: 9 1/4 x 5 3/8 x 3/8 in. (23.5 x 13.7 x 0.9 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Benevento (perhaps) 1900                   Ivories 181   Metropolitan Museum of Art, New York, NY 1
324713 17.190.44 1 1 464428 Medieval Art 6 Plaque 75 Icon with the Crucifixion Byzantine 1134                           mid-10th century 925 975 Ivory 148 5 15/16 × 3 1/2 × 5/16 in. (15.1 × 8.9 × 0.8 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 probably Constantinople 1883                   Ivories 181   Metropolitan Museum of Art, New York, NY 1
327339 41.100.157 1 1 467730 Medieval Art 6 Plaque 75 Plaque with Christ Receiving Magdeburg Cathedral from Emperor Otto I Ottonian 6020                           ca. 962–968 962 968 Ivory 148 Overall: 5 1/8 x 4 7/16 x 5/16in. (13 x 11.3 x 0.8cm) Gift of George Blumenthal, 1941 Made in 1 Milan (?) 1940                   Ivories 181   Metropolitan Museum of Art, New York, NY 1
346883 89.4.909 1 1 501520 Musical Instruments 18 Alto Recorder in F 15972 Alto Recorder in F German 27         Maker 1   Johann Benedikt Gahn German, Nuremberg 1674–1711 Nuremberg   Gahn, Johann Benedikt 47717 German 10 1674 1711 ca. 1700 1680 1720 Ivory 148 Height: 19 1/8 in. (48.6 cm) The Crosby Brown Collection of Musical Instruments, 1889   Nürnberg 1065     Germany 16             Aerophone-Whistle Flute-recorder 965   Metropolitan Museum of Art, New York, NY 1
348802 1999.74 1 0 503519 Musical Instruments 18 Side-blown Trumpet 16685 Side-blown Trumpet Mangbetu 6598                           19th century 1801 1900 Ivory 148 L. 50 × Diam. Largest 4 3/4 - smallest 1 1/2 in. (127 × 12.1 - 3.8 cm) Purchase, Bequest of Olive Huber, by exchange, and Brian and Anne Marie Todes Gift, 1999         Democratic Republic of the Congo 93             Aerophone-Lip Vibrated-trumpet / trombone 931   Metropolitan Museum of Art, New York, NY 1
351377 30.8.224 1 1 544067 Egyptian Art 19 Comb, ornamental (teeth missing) 17700 Hair Comb Decorated with Rows of Wild Animals   Predynastic, Late Naqada III                         ca. 3200–3100 B.C. -3200 -3100 Ivory 148 h. 5.5 cm (2 3/16 in); w. 3.9 cm (1 9/16 in); th. 0.5 cm (3/16 in) Theodore M. Davis Collection, Bequest of Theodore M. Davis, 1915 From 19       Egypt 104                 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 1358.02ms · Data license: CC0 · Data source: metmuseum/openaccess