MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Country = 1006

View and edit SQL

Suggested facets: Object Name, Object Date, Object Begin Date, Object End Date, Medium, 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
390774 SL.12.2016.43.2 0 0 642267 Islamic Art 9 Candlestick 163 Candlestick with the Labors of the Months                             late 13th–14th century 1275 1399 Brass; cast, engraved, incised, inlaid with silver 58538 Height: 7 7/8 in. (20 cm) Museo Nazionale del Palazzo di Venezia, Rome Country of Origin|Attributed to 102   | 96   Turkey|Anatolia 1006             Metal 1   Metropolitan Museum of Art, New York, NY 1
390782 SL.12.2016.18.3 0 0 642283 Islamic Art 9 Mace head 10159 Dragon-Head Mace                             12th–13th century 0 0 Copper alloy, iron; cast 58544 Height: 13 3/4 in. (35 cm) Furusiyya Art Foundation (R-113) Country of Origin|Attributed to 102   | 96   Turkey|Anatolia 1006             Metal 1   Metropolitan Museum of Art, New York, NY 1
390806 SL.12.2016.27.3a–h 0 0 642326 Islamic Art 9 Architectural fragments 11809 Eight Fragments from a Frieze Depicting Chasing Animals                             ca. 1160s–1170s 1135 1195 Stucco; molded 45684 2 1/4 in. × 20 in. (5.7 × 50.8 cm) The Los Angeles County Museum of Art, The Madina Collection of Islamic Art, gift of Camilla Chandler Frost (M.2002.1.683a-h) Country of Origin|Attributed to 102 Konya 1538 | 96   Turkey|Anatolia 1006             Stucco 784   Metropolitan Museum of Art, New York, NY 1
390813 SL.12.2016.28.1 0 0 642342 Islamic Art 9 Textile; fragment 26673 Textile Fragments with the Name of 'Ala' al-Din Kay Qubad I, Mounted as a Cope                             ca. 1219–1237 1194 1262 Silk, gold thread; weft-faced compound twill 58557 Length: 40 3/16 in. (102 cm) Width: 29 5/16 in. (74.5 cm) Le musée des Tissus de Lyon (MT 23475) Country of Origin|Attributed to 102   | 96   Turkey|Anatolia 1006             Textiles 16   Metropolitan Museum of Art, New York, NY 1
395892 SL.12.2016.15.1 0 0 648998 Islamic Art 9 Non-illustrated manuscript 14150 Rum Seljuq Qur'an                             dated A.H. end of Rabi' II 677 / A.D. September 1278 1253 1303 Ink and gold on paper 45262 Height: 4 1/8 in. (10.5 cm) Width: 3 1/8 in. (8 cm) Trustees of the Chester Beatty Library (Is. 1466) Country of Origin|Made in 111 Konya 1538 | 96   Turkey|Anatolia 1006             Works on Paper 170   Metropolitan Museum of Art, New York, NY 1
402820 SL.12.2016.26.8 0 0 658484 Islamic Art 9 Relief fragment 4038 Fragment of a Rider                             ca. 1160s–70s 1135 1195 Stucco; molded 45684 4 3/4 × 3 1/8 × 13/16 in. (12 × 8 × 2 cm) Victoria and Albert Museum, London (374:1-1906) Country of Origin|From 124 Konya 1538 | 96   Turkey|Anatolia 1006             Stucco 784   Metropolitan Museum of Art, New York, NY 1
409687 SL.12.2016.5.10 0 0 671392 Islamic Art 9 Mortar 4468 Mortar with Sphinxes                             13th century 1200 1299 Bronze; cast 44734 Diameter: 7 7/8 in. (20 cm) Museum für Islamische Kunst, Staatliche Museen zu Berlin (I.1287) Country of Origin|Attributed to 102   | 96   Turkey|Anatolia 1006             Metal 1   Metropolitan Museum of Art, New York, NY 1
421407 SL.12.2016.5.8 0 0 698042 Islamic Art 9 Tile 101 Six-Pointed Star Tile Ensemble with Lute Player                             ca. 1160s–1170s 1135 1195 stonepaste; inglaze- and overglaze-painted, gilded 60223 Diam: 4 7/16 in. (11.3 cm) Museum für Islamische Kunst, Staatliche Museen zu Berlin (I.936 a-f) Country of Origin|Probably from 114   | 96 Konya 570 Turkey|Anatolia 1006             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
421410 SL.12.2016.5.9 0 0 698045 Islamic Art 9 Tile 101 Tile with a Rosette Once Decorating an Upper Corner of the Mihrab in the Sircali Madrasa                             late 13th century 1250 1299   10 1/4 × 10 1/4 in. (26 × 26 cm) Museum für Islamische Kunst, Staatliche Museen zu Berlin (KONYA99a) Country of Origin|Possibly from 100 Konya 1538 | 96   Turkey|Anatolia 1006             Ceramics-Tiles 776   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 130.697ms · Data license: CC0 · Data source: metmuseum/openaccess