MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

17 rows where Medium = 45926

View and edit SQL

Suggested facets: Is Highlight, Object Name, Title, Object Date, Object Begin Date, Object End Date, Credit Line, Geography Type, City, Country

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
314297 36.20.28 0 1 449059 Islamic Art 9 Bowl 106 Bowl with Black and White Geometric Decoration                             9th century 800 899 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 3 1/2 (8.9 cm) Diam. 10 1/4 in. (26 cm) Rogers Fund, 1936 Excavated in|Attributed to 51 Nishapur 1514 | 96   Iran|Iran or Central Asia 408             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
314331 36.20.62 0 1 449093 Islamic Art 9 Bowl 106 Bowl                             late 9th–early 10th century 875 925 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 2 15/16 in. (7.5 cm) Diam. 9 3/4 in. (24.8 cm) Rogers Fund, 1936 Probably from 22 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
314561 38.40.111 0 1 449323 Islamic Art 9 Bowl 106 Three Bowls with Floriated Kufic Inscriptions                             late 9th–early 10th century 875 925 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 1 7/8 in. (4.8 cm) Diam. 5 3/4 in. (14.6 cm) Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
314568 38.40.118 1 1 449330 Islamic Art 9 Bowl 106 Bowl with Inscription, "Sovereignty is God's"                             late 9th–early 10th century 875 925 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 3 3/4 in. (9.5 cm) Diam. 12 in. (30.5 cm) Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
314587 38.40.138 0 1 449349 Islamic Art 9 Bowl 106 Bowl with Repeating Inscription, "Oh, Abundant!"                             late 9th century 875 899 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 4 in. (10.2 cm) Diam. 13 3/8 in. (34 cm) Rogers Fund, 1938 Excavated in|Attributed to 51 Nishapur|Nishapur 1663 | 96   Iran|Iran 351             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
314598 38.40.149 0 1 449360 Islamic Art 9 Fragment 486 Fragment of a Bowl with Inscription                             late 9th century 875 899 Earthenware; white slip with black slip decoration under transparent glaze 45926 D. 9 1/2 in. (24.1 cm) Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
314612 38.40.164 0 1 449374 Islamic Art 9 Bowl 106 Bowl                             9th century 800 899 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 1 13/16 in (4.6 cm) Diam. 4 3/4 in. (12.1 cm) Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
314620 38.40.172 0 1 449382 Islamic Art 9 Bowl 106 Bowl with Black and White Decoration                             late 9th–10th century 875 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 2 3/8 in. (6 cm) Diam. 9 in. (22.9 cm) Rogers Fund, 1938 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
314963 40.170.29 0 1 449725 Islamic Art 9 Plate 356 Plate                             10th century 900 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 2 3/8 in. (6 cm) Diam.16 9/16 in. (42 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
315025 40.170.93 0 1 449787 Islamic Art 9 Bowl 106 Spouted Bowl, Inscribed "Sovereignty is God's"                             late 10th century 975 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 2 15/16 in. (7.4 cm) D. 7 1/16 in. (18 cm) Base: 3 3/8 in. (8.5 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
315463 40.170.561 0 1 450226 Islamic Art 9 Fragment 486 Fragment                             10th century 900 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 2 3/8 in. (6 cm) W. 2 9/16 in. (6.5 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
315467 40.170.565 0 1 450230 Islamic Art 9 Fragment of a bowl 2498 Fragment of a Bowl                             9th–10th century 800 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 3 15/16 in. (10 cm) W. 4 1/8 in. (10.5 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
315468 40.170.566 0 1 450231 Islamic Art 9 Fragment of a bowl 2498 Fragment of a Bowl                             9th–10th century 800 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 3 1/16 in. (7.8 cm) W. 3 1/4 in. (8.2 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
315477 40.170.575 0 1 450240 Islamic Art 9 Fragment of a bowl 2498 Fragment of a Bowl                             10th century 900 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 4 15/16 x 2 3/4 in. (12.5 x 7 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
315478 40.170.576a–c 0 1 450241 Islamic Art 9 Plate fragment 6814 Plate Fragment                             10th century 900 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 4 3/4 in. (12 cm) W. 7 7/8 in. (20 cm) Rogers Fund, 1940 Excavated in 45 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
317163 67.178.2 0 1 451944 Islamic Art 9 Plate 356 Plate                             10th century 900 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 1 1/2 in (3/8 cm) Diam 12 in. (30.5 cm) Wt. 25.1 oz (711.7 g) Purchase, Joseph Pulitzer Bequest, 1967 Attributed to 20 Nishapur 1514     Iran 59             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
318516 1988.114.3 0 1 453306 Islamic Art 9 Ewer 227 Ewer with Arabic proverb, "Devotion fortifies action"                             10th century 900 999 Earthenware; white slip with black slip decoration under transparent glaze 45926 H. 5 3/8 in. (13.7 cm) Diam. at rim 3 3/4 in. (9.5 cm) Gift of Ernest Erickson Foundation, 1988 Probably from 22 Nishapur or Samarqand 1707     Iran or present-day Uzbekistan 427             Ceramics 5   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 121.138ms · Data license: CC0 · Data source: metmuseum/openaccess