MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

127 rows where Country = 111

View and edit SQL

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
316814 60.23.99 0 1 451592 Islamic Art 9 Fragment 486 Fragment                             9th–10th century 800 999 Earthenware; glazed 44669 H. 13/16 in. (2.1 cm) W. 2 3/16 in. (5.6 cm) D. 1 7/16 in. (3.7 cm) Wt. 0.8 oz. (22.7 g) Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316815 60.23.100 0 1 451593 Islamic Art 9 Fragment 486 Fragment                             9th–10th century 800 999 Earthenware; splash glazed 46755   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316816 60.23.101 0 1 451594 Islamic Art 9 Fragment 486 Fragment                             9th–10th century 800 999 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316817 60.23.102 0 1 451595 Islamic Art 9 Fragment 486 Fragment                             9th–10th century 800 999 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316818 60.23.103 0 1 451596 Islamic Art 9 Fragment 486 Fragment                             9th–10th century 800 999 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316819 60.23.104 0 1 451597 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316820 60.23.105 0 1 451598 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316821 60.23.106 0 1 451599 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316822 60.23.107 0 1 451600 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; incised and glazed 45861   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316823 60.23.108 0 1 451601 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; incised 45866   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316824 60.23.109 0 1 451602 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; incised and glazed 45861   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316825 60.23.110 0 1 451603 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316826 60.23.111 0 1 451604 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316827 60.23.112 0 1 451605 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316828 60.23.113 0 1 451606 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
316829 60.23.114 0 1 451607 Islamic Art 9 Fragment 486 Fragment                             probably 11th century 1000 1099 Earthenware; incised 45866   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
318176 1980.306a–f 0 0 452961 Islamic Art 9 Beads 3963 Beads                             19th–early 20th century 1800 1925 Gold, fabricated from sheet, wire, and swaged wire, decorated with granulation, set with turquoise 47084 Max. L. of bead 1 3/5 in. (4.05 cm), Max. Diam. 4/5 in. (2 cm) Purchase, Mobil Foundation Inc. Gift, 1980 Attributed to 20       Saudi Arabia 111             Jewelry 10   Metropolitan Museum of Art, New York, NY 1
318463 1985.38 0 0 453252 Islamic Art 9 Head ornament 13302 Head Ornament                             19th–early 20th century 1800 1925 Gold, turquoise, garnets, and pearls 47146 H. 4 3/4 in.(12 cm) W. 3 7/8 in. (9.8 cm) D. 9/16 in. (1.5 cm) Purchase, UBAF Arab American Bank, Hajji Baba Club, Eva D. Balamuth, Wendy Findlay, and Edward Ablat Gifts; The Friends of the Islamic Department Fund; and Louis E. and Theresa S. Seley Purchase Fund for Islamic Art, 1985 Attributed to 20       Saudi Arabia 111             Jewelry 10   Metropolitan Museum of Art, New York, NY 1
319409 60.23.25 0 1 455152 Islamic Art 9 Fragment 486 Fragment                             9th century 800 899 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
319410 60.23.46 0 1 455153 Islamic Art 9 Fragment 486 Fragment                             10th–11th century 900 1099 Earthenware; luster-painted 45060   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
319413 60.23.68 0 1 455173 Islamic Art 9 Fragment 486 Fragment                             9th century 800 899 Earthenware; painted and glazed 44683   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
319414 60.23.69 0 1 455174 Islamic Art 9 Fragment 486 Fragment                             9th century 800 899 Earthenware; glazed 44669   Gift of Mr. and Mrs. Wendell M. Hastings, 1960 Found 34 Dhahran 1719     Saudi Arabia 111             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
345944 89.2.174a,b 0 1 500567 Musical Instruments 18 Rebab 15416 Rebab Saudi Arabian 6176                           late 19th century 1875 1889 Wood, leather, shells 53954 Overall: 73.7 cm (29 in.) Gift of Joseph W. Drexel, 1889         Saudi Arabia 111             Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
345945 89.2.176 0 1 500568 Musical Instruments 18 Guenbri 15417 Guenbri Saudi Arabian 6176                           late 19th century 1875 1899 Gourd, wood, parchment decorated with floral designs 53955 Overall: 15.2 x 61cm (6 x 24in.) Gift of Joseph W. Drexel, 1889         Saudi Arabia 111             Chordophone-Lute-plucked-unfretted 905   Metropolitan Museum of Art, New York, NY 1
345946 89.2.177 0 1 500569 Musical Instruments 18 Gumuri 15418 Gumuri Saudi Arabian 6176                           late 19th century 1875 1899 Wood, parchment, hide 53956 L. 65.4 cm (25-3/4 in.), Diam. 12.1 cm (4-3/4 in.) Gift of Joseph W. Drexel, 1889         Saudi Arabia 111             Chordophone-Lute-plucked-unfretted 905   Metropolitan Museum of Art, New York, NY 1
345947 89.2.178 0 1 500570 Musical Instruments 18 Gunibri 15419 Guenbri Saudi Arabian 6176                           late 19th century 1875 1899 Tortoise shell and wood. Floral design in white, yellow, and pink. 53957 L. 21-1/2 in. Diam. of body 4-3/4 in. Gift of Joseph W. Drexel, 1889         Saudi Arabia 111             Chordophone-Lute-plucked-unfretted 905   Metropolitan Museum of Art, New York, NY 1
349045 89.4.2859 0 0 503774 Musical Instruments 18 Arghul 16795 Arghul Saudi Arabian 6176                           19th century 1800 1899 cane 54247 Longest pipe 109.2 cm (43 in); shortest pipe 37.5 cm (14 3/4 in) The Crosby Brown Collection of Musical Instruments, 1889         Saudi Arabia 111             Aerophone-Reed Vibrated-single reed cylindrical 953   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 45.691ms · Data license: CC0 · Data source: metmuseum/openaccess