MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Classification = 1 and Is Highlight = 1

View and edit SQL

Suggested facets: Object End Date, Credit Line, Geography Type, Country

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
309714 91.1.535a–h 1 1 444408 Islamic Art 9 Astrolabe 14162 Astrolabe of ‘Umar ibn Yusuf ibn ‘Umar ibn ‘Ali ibn Rasul al-Muzaffari           Maker 1   ‘Umar ibn Yusuf ibn ‘Umar ibn ‘Ali ibn Rasul al-Muzaffari     ‘Umar ibn Yusuf ibn ‘Umar ibn ‘Ali ibn Rasul al-Muzaffari 44049       dated A.H. 690/ A.D. 1291 1266 1316 Brass; cast and hammered, pierced, chased, inlaid with silver 44817 Case (a): Max. W. 7 5/8 in. (19.4 cm) Diam. 6 1/8 in. (15.6 cm) D. 1/4 in. (0.6 cm) Bar with attached nail (b): Max. H. 1 7/8 in. (4.8 cm) Max. W. 1 1/8 in. (2.9 cm) L. 5 in. (12.7 cm) Net (c): Diam. 5 in. (12.7 cm) Plates (d-g): Diam. 5 in. (12.7 cm) Pin (h): L. 1 3/4 in. (4.4 cm) W. 1/2 in. (1.3 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891 Made in 1       Yemen 315             Metal 1   Metropolitan Museum of Art, New York, NY 1
309842 91.1.540 1 1 444540 Islamic Art 9 Brazier 127 Brazier of Sultan al-Malik al-Muzaffar Shams al-Din Yusuf ibn 'Umar                             second half 13th century 1250 1299 Brass; cast, chased, inlaid with silver and black compound 44864 H. 13 7/8 in. (35.2 cm) W. 15 1/2 in. (39.4 cm) Max Depth. 16 3/8 in. (41.6 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891 From 19       Egypt 104             Metal 1   Metropolitan Museum of Art, New York, NY 1
309909 91.1.607 1 1 444607 Islamic Art 9 Ewer 227 Dragon-Handled Jug with Inscription                             late 15th– first quarter 16th century 1475 1525 Brass; cast and turned, engraved, and inlaid with silver, gold, and black organic compound 44890 Ht. 5 5/8 in. (14.3 cm) Max. Diam. 6 1/8 in. (15.6 cm) Diam. of Rim: 3 3/8 in. (8.6 cm) Diam. of base: 5 1/2 in. (14 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891 Attributed to 20 probably Herat 1496     present-day Afghanistan 85             Metal 1   Metropolitan Museum of Art, New York, NY 1
312335 19.135.3 1 1 447086 Islamic Art 9 Finial 3921 Finial in the Form of a Parrot                             17th–18th century 1600 1799 Brass 12 H. 5 3/4 in. (14.6 cm) L. 11 in. (27.9 cm) Gift of Robert W. and Lockwood De Forest, 1919 Attributed to 20       Northern India 343             Metal 1   Metropolitan Museum of Art, New York, NY 1
315749 44.15 1 1 450513 Islamic Art 9 Ewer 227 Ewer                             ca. 1180–1210 1155 1235 Brass; raised, repoussé, inlaid with silver and a black compound 46465 H. 15 3/4 in. (40 cm) Diam 7 1/2 in. (19.1 cm) Rogers Fund, 1944 Attributed to 20       Iran or Afghanistan 409 Khurasan or Herat 495           Metal 1   Metropolitan Museum of Art, New York, NY 1
315984 47.100.90 1 1 450748 Islamic Art 9 Ewer 227 Ewer with a Feline-Shaped Handle                             7th century 600 699 Bronze; cast, chased, and inlaid with copper 46525 Max. H. 19 1/8 in. (48.5 cm); Max. Diam. 8 1/4 in. (21.1 cm) Fletcher Fund, 1947 Attributed to 20       Iran 59             Metal 1   Metropolitan Museum of Art, New York, NY 1
316277 51.56 1 1 451042 Islamic Art 9 Incense burner 4170 Incense Burner of Amir Saif al-Dunya wa’l-Din ibn Muhammad al-Mawardi           Maker 1   Ja`far ibn Muhammad ibn `Ali     Ja'far ibn Muhammad ibn `Ali 44132       dated A.H. 577/ A.D. 1181–82 1166 1207 Bronze; cast, engraved, chased, pierced 46649 OveralL. H. 33 1/2 in. (85.1 cm) L. 32 1/2 in. (82.6 cm) W. 9 in. (22.9 cm) L. from heel of back foot to toe of front foot: 22 in. (55.9 cm) L. from toe of front foot to tip of nose: 4 in. (10.2 cm) L. from heel of back foot to tip of taiL. 7 in. (17.8 cm) Rogers Fund, 1951 Found 34 Taybad 1700     Iran 59             Metal 1   Metropolitan Museum of Art, New York, NY 1
318454 1984.221 1 1 453243 Islamic Art 9 Water pipe base 14174 Base for a Water Pipe (Huqqa) with Irises                             late 17th century 1675 1699 Zinc alloy; cast, engraved, inlaid with brass (bidri ware) 44878 H. 6 7/8 in. (17.5 cm) Diam. 6 1/2 in. (16.5 cm) Louis E. and Theresa S. Seley Purchase Fund for Islamic Art and Rogers Fund, 1984 Attributed to 20 Bidar 1495     India 27 Deccan 459           Metal 1   Metropolitan Museum of Art, New York, NY 1
318489 1987.14 1 1 453279 Islamic Art 9 Plaque 75 Calligraphic Plaque                             probably late 17th century 1675 1699 Steel; forged and pierced 47031 H. 6 1/2 in. (16.5 cm) W. 15 in. (38.1 cm) Rogers Fund, 1987 Attributed to 20       Iran 59             Metal 1   Metropolitan Museum of Art, New York, NY 1
319241 2004.244a–d 1 1 454738 Islamic Art 9 Goa stone and container 14455 Goa Stone and Gold Case                             late 17th–early 18th century 1675 1725 Container: gold; pierced, repoussé, with cast legs and finials Goa stone: compound of organic and inorganic materials 47312 Goa stone: Diam. 1 3/16 in. (3 cm) container: H. 2 5/8 in. (6.7 cm) Diam. 5 11/16 in. (14.4 cm) Rogers Fund, 2004 Probably made in 2       India 27 Goa 513           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 2416.202ms · Data license: CC0 · Data source: metmuseum/openaccess