MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Artist Prefix = "Painted by" and Department = 9

View and edit SQL

Suggested facets: Object Name, Artist Display Bio, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Credit Line, Geography Type, City, Country, Classification

Department

  • Islamic Art · 7

Artist Prefix

  • Painted by · 7
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
311821 13.228.31 0 1 446565 Islamic Art 9 Folio from an illustrated manuscript 14202 "A Bathhouse Keeper is Consumed by Passion for his Beloved", Folio from a Khamsa (Quintet) of Amir Khusrau Dihlavi           Poet|Artist 4864 Painted by Amir Khusrau Dihlavi|Nar Singh 1253–1325   Amir Khusrau Dihlavi|Nar Singh 44085   1228 1350 1597–98 1572 1623 Main support: Ink, opaque watercolor and gold on paper Margins: Gold on dyed paper 45347 Image: H. 10 in. (25.4 cm) W. 6 1/2 in. (16.5 cm) Page: H. 11 1/4 in. (28.6 cm) W. 7 7/8 in. (20 cm) Mat: H. 19 1/4 in. (48.9 cm) W. 14 1/4 in. (36.2 cm) Gift of Alexander Smith Cochran, 1913 Made in 1 Lahore 1473     present-day Pakistan 312             Codices 779   Metropolitan Museum of Art, New York, NY 1
311846 13.228.7.1 0 1 446590 Islamic Art 9 Illustrated manuscript 14151 Overflap and Inside Cover of a Khamsa (Quintet) of Nizami           Calligrapher|Calligrapher|Artist|Author 4865 Painted by Sultan Muhammad Nur|Mahmud Muzahhib|Shaikh Zada|Nizami (Ilyas Abu Muhammad Nizam al-Din of Ganja) ca. 1472–ca. 1536|probably 1141–1217   Sultan Muhammad Nur|Mahmud Muzahib|Shaykh Zada|Nizami (Ilyas Abu Muhammad Nizam al-Din of Ganja) 44090   1448 |1141 1561 |1217 dated A.H. 931/ A.D. 1524–25 1500 1550 Binding: leather; embossed; gold and color Manuscript: ink, opaque watercolor, and gold on paper  45349 12 5/8 x 8 3/4 in. (32.1 x 22.2 cm) Gift of Alexander Smith Cochran, 1913 Made in 1 Herat 1490     present-day Afghanistan 85             Codices 779   Metropolitan Museum of Art, New York, NY 1
311866 13.228.7.14 0 1 446610 Islamic Art 9 Folio from an illustrated manuscript 14202 "Bahram Gur in the White Palace on Friday", Folio 235 from a Khamsa (Quintet) of Nizami           Calligrapher|Artist|Author 4867 Painted by Sultan Muhammad Nur|Shaikh Zada|Nizami (Ilyas Abu Muhammad Nizam al-Din of Ganja) ca. 1472–ca. 1536|probably 1141–1217   Sultan Muhammad Nur|Shaykh Zada|Nizami (Ilyas Abu Muhammad Nizam al-Din of Ganja) 44092   1448 |1141 1561 |1217 A.H. 931/A.D. 1524–25 1500 1550 Opaque watercolor, ink and gold on paper 7524 Painting: H. 8 13/16 in. (22.4 cm) W. 4 1/2 in. (11.4 cm) Page: H. 12 5/8 in. (32.1 cm) W. 8 3/4 in. (22.2 cm) Mat: H. 19 1/4 in. (48.9 cm) W. 14 1/4 in. (36.2 cm) Gift of Alexander Smith Cochran, 1913 Made in 1 Herat 1490     present-day Afghanistan 85             Codices 779   Metropolitan Museum of Art, New York, NY 1
316555 55.121.42 0 1 451323 Islamic Art 9 Illustrated single work 14140 Portrait of a Lady Holding a Flower           Artist 2 Painted by Muhammadi of Herat active Qazvin, ca. 1570–78; Herat, ca. 1578–87   Muhammadi of Herat, Ustad 44162   1545 1613 1565–75 1540 1600 Opaque watercolor, ink, and gold on paper 12980 H. 4 5/8 in. (11.7 cm) W. 2 11/16 in. (6.8 cm) Rogers Fund, 1955 Attributed to 20 Herat 1490     present-day Afghanistan 85             Codices 779   Metropolitan Museum of Art, New York, NY 1
317175 67.266.1 0 1 451956 Islamic Art 9 Folio from an illustrated manuscript 14202 "Siege of Baghdad", Folio from a Dispersed copy of the Zafarnama (Book of Victories)           Author|Calligrapher|Artist 4876 Painted by Sharaf al-din 'Ali Yazdi|Ya'qub ibn Hasan, known as Siraj al-Husaini|Unknown 1424–54   Sharaf al-din 'Ali Yazdi|Yaqub ibn Hasan known as Siraj al-Husayni|Unknown 44177   1424 1454 Dhu'l Hijja 839 A.H./A.D. June–July 1436 1411 1461 Ink, opaque watercolor, silver, and gold on paper 7525 Page: 13 1/8 x 9 11/16in. (33.4 x 24.6cm) Measurements of text page with r: 9 5/16 x 6 3/16in. (23.7 x 15.7cm) Measurements of miniature withou: 7 13/16 x 6in. (19.8 x 15.2cm) Louis V. Bell Fund, 1967 Made in 1 Shiraz 1471     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
317889 1974.294.3 0 1 452671 Islamic Art 9 Folio from an illustrated manuscript 14202 "Interior Reception", Folio 36r from a Bustan of Sa`di           Artist|Author 709 Painted by Shaikh Zada|Sa'di 1213/19–92   Shaykh Zada|Sa'di 44217   1213 1292 ca. 1525–35 1500 1560 Ink, opaque watercolor, and gold on paper 7497 Painting: H. 8 3/4 in. (22.3 cm) W. 4 15/16 in. (12.5 cm) Page: H. 11 in. (27.9 cm) W. 7 1/4 in. (18.4 cm) Mat: H. 19 1/4 in. (48.9 cm) W. 14 1/4 in. (36.2 cm) Purchase, Louis V. Bell Fund and The Vincent Astor Foundation Gift, 1974 Attributed to 20 probably Bukhara 1720     present-day Uzbekistan 80             Codices 779   Metropolitan Museum of Art, New York, NY 1
320638 2011.184 0 1 457723 Islamic Art 9 Drawing 23 Painting of a Young Beauty           Artist|Illuminator 4883 Painted by Muhammad Sadiq|'Ali Akbar active 1740–90s   Muhammad Sadiq|Akbar, Ali 44294   1715 1805 1740s–50s 1715 1775 Ink, opaque watercolor, and gold on cloth 47618 Page: H. 12 1/2 in. (31.8 cm) W. 8 in. (20.3 cm) Painting: H. 5 1/2 in. (14 cm) W. 3 in. (7.6 cm) Purchase, Friends of Islamic Art Gifts, 2011 Country of Origin 23       Iran 59             Drawings 9   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 1987.496ms · Data license: CC0 · Data source: metmuseum/openaccess