MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Medium = 45454

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Credit Line, Geography Type, City, Country, 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
312241 17.190.219 0 1 446986 Islamic Art 9 Fragment of an oliphant 14255 Fragment of an Oliphant                             11th–12th century 1075 1125 Ivory; carved 45454 Overall: L. 8 3/4 in. (22.2 cm) W. 4 1/8 (10.5 cm) D. 3 9/16 in. (9 cm) Gift of J. Pierpont Morgan, 1917 Attributed to 20       Italy 14 Sicily 480           Ivories and Bone 777   Metropolitan Museum of Art, New York, NY 1
312245 17.190.241 1 1 446990 Islamic Art 9 Casket 1230 Morgan Casket                             11th–12th century 1000 1199 Ivory; carved 45454 Overall: H. 8 7/8 in. (22.3 cm) W. 15 3/16 in. (38.6 cm) D. 7 7/8 in. (20 cm) Lid: H. 2 3/4 in. (7 cm) W. 14 5/16 in. (36.4 cm) D. 8 1/16 in. (20.5 cm) Container: H. 5 5/16 in. (13.5 cm) W. 15 3/16 in. (38.6 cm) D. 8 7/8 in. (22.5 cm) Gift of J. Pierpont Morgan, 1917 From 19       Southern Italy 367             Ivories and Bone 777   Metropolitan Museum of Art, New York, NY 1
313684 30.95.175 0 1 448443 Islamic Art 9 Box 114 Cylindrical Box (Pyxis)                             10th century 900 999 Ivory; carved 45454 H. 2 5/8 in. (6.7 cm) Diam. 3 1/4 in. (8.3 cm) Theodore M. Davis Collection, Bequest of Theodore M. Davis, 1915 From 19       Spain 5             Ivories and Bone 777   Metropolitan Museum of Art, New York, NY 1
315079 40.170.150 0 1 449842 Islamic Art 9 Chess piece 2722 Chess Piece, King                             9th–12th century 800 1199 Ivory; carved 45454 H. 1 1/8 in. (2.8 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Gaming pieces 782   Metropolitan Museum of Art, New York, NY 1
315080 40.170.151 0 1 449843 Islamic Art 9 Chess piece 2722 Chess Piece, King                             9th–12th century 800 1199 Ivory; carved 45454 H. 1 5/16 in. (3.3 cm) W. 13/16 in. (2 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Gaming pieces 782   Metropolitan Museum of Art, New York, NY 1
317555 1972.9.23 0 1 452337 Islamic Art 9 Chess piece 2722 Chess Piece, King                             11th–12th century 1000 1199 Ivory; carved 45454 H. 1 1/2 in. (3.8 cm) W. 7/8 in. (2.2 cm) L. 1 in. (2.5 cm) Pfeiffer Fund, 1972 Attributed to 20 probably Nishapur 1669     Iran 59             Gaming pieces 782   Metropolitan Museum of Art, New York, NY 1
317837 1974.207 0 1 452619 Islamic Art 9 Chess piece 2722 Chess Piece, Rook                             11th–12th century 1000 1199 Ivory; carved 45454 H. 1 3/4 in. (4.5 cm) W. 3/4 in. (1.9 cm) Purchase, Rogers Fund and Mr. and Mrs. Jerome A. Straka Gift, 1974 Attributed to 20         Western Islamic Lands 474           Glass 3   Metropolitan Museum of Art, New York, NY 1
318840 17.190.46 0 1 453638 Islamic Art 9 Oliphant 14254 Tusk Fragment with the Ascension                             720–970 Radiocarbon date, 95% probability 720 970 Ivory; carved 45454 H. 7 3/4 in. (19.7 cm) W. 4 15/16 in. (12.5 cm) D. 2 3/8 in. (6 cm) Max. Th. 1 1/16 in. (2.7 cm) Gift of J. Pierpont Morgan, 1917 Attributed to 20       Egypt or Palestine 353             Ivories and Bone 777   Metropolitan Museum of Art, New York, NY 1
318855 17.190.48 0 1 453653 Islamic Art 9 Tusk fragment 14445 Tusk Fragment with Christ Enthroned                             810–1010 810 1010 Ivory; carved 45454 H. 4 5/8 in. (11.7 cm) W. 3 7/8 in. (9.8 cm) D. 1 5/16 in. (3.3 cm) Max. Th. 5/8 in. (1.6 cm) Gift of J. Pierpont Morgan, 1917 Attributed to 20       Egypt 104             Ivories and Bone 777   Metropolitan Museum of Art, New York, NY 1
396737 SL.1.2015.34.1 0 0 650300 Islamic Art 9 Sculpture 100 Christ Child as the Bom Pastor (Good Shepherd)                             ca. 1700 1695 1705 Ivory; carved 45454 H. 10 5/8 in. (27 cm) W. 3 9/16 in. (9 cm) D. 2 3/16 in. (5.5 cm) On Loan from The Hispanic Society of America, New York, NY (none assigned) 9 Goa 1524     India 27             Ivory 1053   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 127.445ms · Data license: CC0 · Data source: metmuseum/openaccess