MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Department = 16 and Object Name = 116

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Culture, Artist Suffix, Object Date, Object Begin Date, Object End Date, Medium, Classification

Department ✖

  • Robert Lehman Collection · 12 ✖
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 Metadata Date Repository
322399 322399 1975.1.1582 0 1 460558 Robert Lehman Collection 16 Jar 116 Jar with two handles Roman 736                           1st century 1 100 Transparent blue glass. Blown, tooled, the rim finished at the furnace, the handles applied. 48388 H. 13,6 cm; diam. of rim 3.8 cm; diam. of shoulder 6.2 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/460558 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322409 322409 1975.1.1598 0 1 460568 Robert Lehman Collection 16 Jar 116 Jar Roman 736                           possibly 2nd–4th century 100 399 Transparent blue glass. Blown (the body probably blown in a mold), the rim finished at the furnace. 48397 H. 6.8 cm; diam. of rim 3.9 cm; diam. of shoulder 5 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/460568 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322410 322410 1975.1.1599 0 1 460569 Robert Lehman Collection 16 Jar 116 Jar Roman 736                           3rd–4th century 200 399 Almost colorless glass with a yellowish green tint. Blown, the rim finished at the furnace. 48398 H. 9.1 cm; diam. of rim 8 cm; diam. of body 9.8 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/460569 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322495 322495 1975.1.1666 0 1 460659 Robert Lehman Collection 16 Jar 116 Jar, Jun ware Chinese 10         Artist 2   Chinese   , Jin/Yuan Dynasty Chinese 44503       ca. 13th century 1197 1303 Stoneware with splashed blue glaze. 48448 Height 3 9/16 in. (9 cm.) Robert Lehman Collection, 1975                       Ceramics 5   http://www.metmuseum.org/art/collection/search/460659 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322496 322496 1975.1.1665 0 1 460660 Robert Lehman Collection 16 Jar 116 Two-eared jar, Jun ware Chinese 10         Artist 2   Chinese   , Jin/Yuan Dynasty Chinese 44503       ca. 13th century 1197 1303 Stoneware with flushed blue glaze. 48449 Height 4 7/8 in. (12.3cm.) Robert Lehman Collection, 1975                       Ceramics 5   http://www.metmuseum.org/art/collection/search/460660 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322502 322502 1975.1.1664 0 1 460666 Robert Lehman Collection 16 Jar 116 Wine jar (Guan), Cizhou ware Chinese 10         Artist 2   Chinese   , Yuan Dynasty Chinese 44503       late 13th–early 14th century 1271 1300 Stoneware painted in brown on a white ground. 48453 H. 31 cm. Robert Lehman Collection, 1975                       Ceramics 5   http://www.metmuseum.org/art/collection/search/460666 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322651 322651 1975.1.1586 0 1 460815 Robert Lehman Collection 16 Jar 116 Jar Roman 736                           possibly 3rd century 200 299 Almost colorless glass with a green or brown tint. Blown, the rim finished at the furnace. 48545 H. 10.8 cm; diam. of rim 3.2 cm; diam. of shoulder 4.8 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/460815 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322652 322652 1975.1.1589 0 1 460816 Robert Lehman Collection 16 Jar 116 Jar Roman 736                           late 3rd–5th century 275 499 Apparently colorless glass with a very pale green or yellowish green tint. Blown, the rim finished at the furnace. 48546 H. 12.4 cm; diam. of rim 3.8 cm; diam. of body 7.6 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/460816 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322655 322655 1975.1.1597 0 1 460819 Robert Lehman Collection 16 Jar 116 Jar with sixteen handles Roman 736                           4th century or later 300 399 Apparently very pale translucent green glass with translucent deep bluish green glass handles. Blown, tooled, the rim finished at the furnace, the trail and handles applied. 48549 H. 6.9 cm; diam. of rim 8 cm; diam. of body 9.4 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/460819 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
322656 322656 1975.1.1600 0 1 460820 Robert Lehman Collection 16 Jar 116 Jar Roman 736                           about 4th century 300 399 Apparently almost colorless glass with a brown or yellowish tint. Blown, the body inflated in a dip mold, the rim finished at the furnace. 48550 H. 6.6 cm; diam. of rim 4.4 cm; diam. of body 6.5 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/460820 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323145 323145 1975.1.1593 0 1 461323 Robert Lehman Collection 16 Jar 116 Jar Islamic 4198                           7th–11th century 600 1100 Probably almost colorless glass. Blown (the body blown in a dip mold), the rim finished at the furnace. 48783 H. 5.8 cm; diam. of rim 3.3 cm; diam. of body 5.3 cm Robert Lehman Collection, 1975                       Glass 3   http://www.metmuseum.org/art/collection/search/461323 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
323313 323313 1975.1.1663 0 1 461493 Robert Lehman Collection 16 Jar 116 Two-eared jar, Jun ware Chinese 10         Artist 2   Chinese   , Jin/Yuan Dynasty Chinese 44503       ca. 13th century 1197 1303 Stoneware with flushed blue glaze. 48449 Height: 4 15/16 in. (12.5cm.) Robert Lehman Collection, 1975                       Ceramics 5   http://www.metmuseum.org/art/collection/search/461493 4/23/2018 8:00:01 AM 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 369.12ms · Data license: CC0 · Data source: metmuseum/openaccess