MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where City = 1629

View and edit SQL

Suggested facets: Object Name, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Geography Type

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
313053 25.83.7 0 1 447805 Islamic Art 9 Illustrated single work 14140 Hero and Dragon                             third quarter 16th century 1550 1575 Ink, watercolor, and gold on paper 45228 H. 8 11/16 in. (22 cm) W. 5 5/8 in. (14.3 cm) Gift of George D. Pratt, 1925 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
314246 34.72 0 1 449008 Islamic Art 9 Folio from an illustrated manuscript 14202 "Birth of Zal", Folio from a Shahnama (Book of Kings)           Author|Artist|Dedicatee 4870 Attributed to Abu'l Qasim Firdausi|Siyavush|Shah Isma'il 935–1020|ca. 1536–1610|r. 1576–77   Abu'l Qasim Firdausi|Siyavush|Isma'il Shah 44118   0935 |1510 |1576 1020 |1635 |1577 1576–77 1551 1602 Ink, opaque watercolor, and gold on paper 7497 H. 17 3/4 in. (45.1 cm) W. 12 1/8 in. (30.8 cm) Harris Brisbane Dick Fund, 1934 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
314258 35.48 0 1 449020 Islamic Art 9 Folio from an illustrated manuscript 14202 "Luhrasp Hears from the Returning Paladins of the Vanishing Kai Khusrau", Folio from a Shahnama (Book of Kings) of Firdausi           Author|Artist|Dedicatee 4870 Painting attributed to Abu'l Qasim Firdausi|Siyavush|Shah Isma'il 935–1020|ca. 1536–1610|r. 1576–77   Abu'l Qasim Firdausi|Siyavush|Isma'il Shah 44118   0935 |1510 |1576 1020 |1635 |1577 1576–77 1551 1602 Ink, opaque watercolor, and gold on paper 7497 H. 18 1/2 in. (47 cm) W. 12 5/8 in. (32.1 cm) Rogers Fund, 1935 Made in 1 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
314264 35.64.3 0 1 449026 Islamic Art 9 Folio from an illustrated manuscript 14202 "The Seven Sleepers of Ephesus", Folio from a Falnama (Book of Omens)                             1550s 1525 1575 Ink, opaque watercolor, and gold on paper 7497 Painting: H. 23 in. (58.4 cm) W. 17 3/4 in. (45.1 cm) Mat : H. 28 in. (71.1 cm) W. 22 in. (55.9 cm) Frame: H. 30 1/2 in. (77.5 cm) W. 24 1/2 in. (62.2 cm) Rogers Fund, 1935 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
315834 45.174.16 0 1 450598 Islamic Art 9 Illustrated single work 14140 Hunting Scene                             late 16th century 1575 1599 Ink and watercolor on paper 174 H. 9 in. (22.9 cm) W. 5 1/4 in. (13.3 cm) Bequest of George D. Pratt, 1935 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
316251 50.23.1 0 1 451016 Islamic Art 9 Folio from an illustrated manuscript 14202 "Muhammad Revives the Sick Boy", Folio from a Falnama (Book of Omens) of Ja'far al-Sadiq                             1550s 1525 1575 Ink, opaque watercolor, and gold on paper 7497 Painting: H. 23 1/16 in. (58.6 cm) W. 17in. (43.2cm) Mat : H. 28 in. (71.1 cm) W. 22 in. (55.9 cm) Frame: H. 30 1/2 in. (77.5 cm) W. 24 1/2 in. (62.2 cm) Purchase, Francis M. Weld Gift, 1950 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
316252 50.23.2 0 1 451017 Islamic Art 9 Folio from an illustrated manuscript 14202 "Coffin of Imam 'Ali", Folio from a Falnama (The Book of Omens) of Ja'far al-Sadiq                             mid-1550s–early 1560s 1530 1585 Ink, opaque watercolor, and gold on paper 7497 Painting: H. 22 5/16 in. (56.7 cm) W. 16 7/8 in. (42.8 cm) Mat : H. 28 in. (71.1 cm) W. 22 in. (55.9 cm) Frame: H. 30 1/2 in. (77.5 cm) W. 24 1/2 in. (62.2 cm) Purchase, Francis M. Weld Gift, 1950 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
317115 67.18 0 1 451896 Islamic Art 9 Illustrated single work 14140 Dragon                             16th–17th century 1500 1699 Ink and opaque watercolor on paper 7506 H. 4 7/8 in. .(12.4 cm) W. 8 3/4 in. (22.2 cm) Rogers Fund, 1967 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
317269 69.114.2 0 1 452051 Islamic Art 9 Folio from an illustrated manuscript 14202 Prince Swooning and Two Ladies in a Landscape                             second half 16th century 1550 1599 Ink, opaque watercolor, silver, and gold on paper 7525 11.25 in. high 8.00 in. wide (28.5 cm high 20.3 cm wide) Gift of Edith and Herbert Lehman Foundation, 1969 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
317719 1973.92 0 1 452501 Islamic Art 9 Illustrated single work 14140 Kneeling Youth                             late 16th century 1575 1599 Ink, watercolor, and gold on paper 45228 6.37 in. high 3.50 in. wide (16.5 cm high 8.9 cm wide) Rogers and Fletcher Funds, 1973 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   Metropolitan Museum of Art, New York, NY 1
318526 1990.51 0 1 453316 Islamic Art 9 Illustrated single work 14140 Young Lovers Embracing                             16th century 1500 1599 Watercolor, opaque watercolor, ink, silver, and gold on paper 47171 14 5/16 x 9 1/2in. (36.4 x 24.1cm) Dimensions of decorated leaf: 8 9/16 x 5 5/8in. (21.8 x 14.3cm) Dimensions of drawing: 3 3/4 x 2 3/16in. (9.5 x 5.5cm) Purchase, Elizabeth S. Ettinghausen Gift, in memory of Richard Ettinghausen, 1990 Attributed to 20 Qazvin 1629     Iran 59             Codices 779   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 715.372ms · Data license: CC0 · Data source: metmuseum/openaccess