MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Classification = 1 and Geography Type = 23

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Country, Region

Geography Type

  • Country of Origin · 16
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
311347 10.130.3127a, b 0 1 446090 Islamic Art 9 Pendant 1129 Pendant                             3rd–12th century 200 1199 Bronze 23 A: H. 9/16 in. (1.4 cm) W. 1/4 in. (0.6 cm) D. 1/8 in. (0.3 cm) Wt. 0.01 oz. (0.3 g) B: H. 1/2 in. (1.2 cm) W. 1/4 in. (0.6 cm) D. 1/8 in. (0.3 cm) Wt. 0.02 oz. (0.6 g) Gift of Helen Miller Gould, 1910 Country of Origin 23       Egypt 104             Metal 1   Metropolitan Museum of Art, New York, NY 1
319510 2006.544.1 0 0 455308 Islamic Art 9 Pendant 1129 Cordiform Pendant                             mid–late 19th century 1825 1899 Silver; fire-gilded and chased, with niello inlay, decorative wire, and table-cut carnelians 47377 10 x 6 1/8 in. (25.4 x 15.6 cm) Gift of Marshall and Marilyn R. Wolf, 2006 Country of Origin 23 Teke 1775     Turkmenistan 88             Metal 1   Metropolitan Museum of Art, New York, NY 1
319511 2006.544.2 0 0 455309 Islamic Art 9 Pendant 1129 Cordiform Pendant                             late 19th–early 20th century 1875 1925 Silver with applied decoration, decorative wire, synthetic resin inlays, blue and red glass beads, and table-cut and cabochon cornelians. 47378 H. 12 in. (30.5 cm) W. 7 in. (17.8 cm) D. 3/4 in. (1.9 cm) Wt. 15.6 oz. (442.3 g) Gift of Marshall and Marilyn R. Wolf, 2006 Country of Origin 23         Central Asia or Northern Afghanistan 521           Metal 1   Metropolitan Museum of Art, New York, NY 1
319513 2006.544.4 0 0 455311 Islamic Art 9 Crown 1282 Crown                             late 19th–early 20th century 1875 1925 Silver, with openwork, decorative wire, and slightly domed and tablecut carnelians and turquoises; cotton foundation 47380 7 x 7 3/8 in. (17.8 x 18.7 cm) Gift of Marshall and Marilyn R. Wolf, 2006 Country of Origin 23         Central Asia or Iran 437           Metal 1   Metropolitan Museum of Art, New York, NY 1
319516 2006.544.7 0 0 455314 Islamic Art 9 Crown 1282 Crown                             late 19th–early 20th century 1875 1925 Silver, with decorative wire and stamped decoration, table-cut incised carnelians, turquoise, beads, openwork, and silver coins; quilted cotton lining, cotton cords and tassels with beads, and velvet strip with metal ornaments  47383 tassels: 12 x 3 in. (30.5 x 7.6 cm) crown: 5 7/8 x 7 1/8 in. (14.9 x 18.1 cm) Gift of Marshall and Marilyn R. Wolf, 2006 Country of Origin 23         Central Asia or Iran 437           Metal 1   Metropolitan Museum of Art, New York, NY 1
319517 2006.544.8 0 0 455315 Islamic Art 9 Crown 1282 Crown                             late 19th–early 20th century 1875 1925 Silver; with silver shot, table-cut carnelians, turquoise beads, and gilded loop-in-loop chains with pendants  47384 9 x 11 1/2 in. (22.9 x 29.2 cm) Gift of Marshall and Marilyn R. Wolf, 2006 Country of Origin 23         Central Asia or Iran 437           Metal 1   Metropolitan Museum of Art, New York, NY 1
319518 2006.544.9 0 0 455316 Islamic Art 9 Amulet holder 14473 Triangular Amulet Holder                             late 19th–early 20th century 1875 1925 Silver with stamped beading, decorative wire, ram's-head terminals, glass inlays over red foil, lacquer, or cloth, wire chains, and spherical beads. 47385 11 1/2 x 9 3/8 in. (29.2 x 23.8 cm) Gift of Marshall and Marilyn R. Wolf, 2006 Country of Origin 23         Central Asia 400           Metal 1   Metropolitan Museum of Art, New York, NY 1
319519 L.2011.34.9 0 0 455317 Islamic Art 9 Pectoral ornament 5153 Pectoral Ornament                             late 19th–early 20th century 1875 1925 Silver, fire-gilded, with decorative wire, openwork, and table-cut carnelians 47386 5 1/8 x 5 1/4 in. (13 x 13.3 cm)   Country of Origin 23         Central Asia or Iran 437           Metal 1   Metropolitan Museum of Art, New York, NY 1
319980 2009.484 0 1 457019 Islamic Art 9 Bowl 106 Engraved Bowl                             early 17th century 1600 1625 Copper; cast, engraved, tinned, and inlaid with a black compound 47604 Diam. 10 3/4 in. (12.7cm) H. 5 in. (12.7 cm) Purchase, Patti Cadby Birch Gift, funds from various donors, and W. Graham Arader III Gift, 2009 Country of Origin 23       India 27             Metal 1   Metropolitan Museum of Art, New York, NY 1
320662 2012.207.2a, b 0 1 457784 Islamic Art 9 Standard 2427 Fragment of a Processional Standard ('Alam)                             late 16th century 1575 1599 Brass with relief and pierced decoration 47626 H. 40 in (101.6 cm) W. 24 in (61 cm) Gift of Terence McInerney, 2012 Country of Origin 23 probably Hyderabad 1488   Deccan 594 India 27             Metal 1   Metropolitan Museum of Art, New York, NY 1
390779 SL.12.2016.44.4 0 0 642279 Islamic Art 9 Medical saw 26662 Surgical Saw with Lion-Shaped Handle                             10th–12th century 900 1199 Bronze; cast 44734 4 3/4 × 1 3/16 × 14 1/4 in. (12.1 × 3 × 36.2 cm) Seattle Art Museum, Eugene Fuller Memorial Collection (57.94) Country of Origin 23       Iran 59             Metal 1   Metropolitan Museum of Art, New York, NY 1
400268 2014.589 0 1 655036 Islamic Art 9 Dish 110 Mamluk Philae Dish                             ca. 1345–1360 1320 1385 Brass; inlaid with silver and gold 45460 H. 1.5 in (3.8 cm) x Diam. 11.4 in (29 cm) Purchase, James and Diane Burke Gift, in honor of Dr. Marilyn Jenkins-Madina, 2014 Country of Origin 23       Egypt or Syria 120             Metal 1   Metropolitan Museum of Art, New York, NY 1
405357 2014.689 0 1 662008 Islamic Art 9 Ewer 227 Spouted Vessel with Qur'anic Verses and the Names of the Shi'a Imams                             17th century 1500 1699 Chased and worked copper alloy 59163 H.: 5.1 inches (13 cm) x Diam.: 4.5 inches (11.5 cm) Purchase, Friends of Islamic Art Gifts, 2014 Country of Origin 23       India (Golconda or Bidar) 1039             Metal 1   Metropolitan Museum of Art, New York, NY 1
420801 L.2015.69.1 0 0 696949 American Decorative Arts 1 Andiron 12 Andiron American 1         Maker 1   Herter Brothers German, active New York, 1864–1906   Herter Brothers 31   1864 1906 ca. 1882 1877 1887 Brass 12   Collection of Barrie A. and Deedee Wigmore Country of Origin 23       United States 3             Metal 1   Metropolitan Museum of Art, New York, NY 1
421712 2015.796.52 0 1 698570 Islamic Art 9 Mirror 3984 Mirror with Fishes                             ca. 13th century 1200 1299 Leaded bronze alloy 60254 Diameter: 3 in (7.7 cm) Bequest of Carolyn Kane, 2015 Country of Origin 23       Central Asia or Iran 474             Metal 1   Metropolitan Museum of Art, New York, NY 1
424170 L.2015.69.2 0 0 704667 American Decorative Arts 1 Andiron 12 Andiron American 1         Maker 1   Herter Brothers German, active New York, 1864–1906   Herter Brothers 31   1864 1906 ca. 1882 1877 1887 Brass 12   Collection of Barrie A. and Deedee Wigmore Country of Origin 23       United States 3             Metal 1   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 778.243ms · Data license: CC0 · Data source: metmuseum/openaccess