MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Classification = 3 and Department = 17

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Date, Object Begin Date, Object End Date, 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 Metadata Date Repository
331612 331612 isl707 0 0 477218 The Cloisters 17   Luster-Painted Bottle                             9th–10th century 800 1000 Glass, yellowish; gold and silver foil; blue enamel; facet-cut neck 50580 H: 5 11/16 in. (14.5 cm); 4 1/8 in. (10.4 cm) The British Museum, London (1978,1011.2) Made in 1       Syria 69             Glass 3   http://www.metmuseum.org/art/collection/search/477218 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
331613 331613 isl708 0 0 477220 The Cloisters 17   Flask with Green Cameo Decoration                             9th–10th century 800 1000 Translucent glass with green glass overlays, relief cut, incised 50581 H: 6 1/8 in. (15.5 cm); diam: 3 3/8 in. (8.5 cm) The British Museum, London (1967,1211.1) Made in 1       Probably Iran 467             Glass 3   http://www.metmuseum.org/art/collection/search/477220 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
331716 331716 isl714 0 0 477463 The Cloisters 17   Hexagonal Bottle with Stylite                             mid-5th–7th century 450 699 Glass, mold-blown, dull green 50596 10 1/16 x 2 9/16 in. (25.5 x 6.5 cm) The British Museum, London (1911,0513.1) Made in 1       Syria (?) 599             Glass 3   http://www.metmuseum.org/art/collection/search/477463 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
331814 331814 isl769 0 0 478034 The Cloisters 17   Luster-Painted Cup                             786/787 786 787 Bluish colorless glass, with dark brown and yellow stains; free blown and stained, tooled on the pontil 50626 H: 3 15/16 (10 cm), diam: 5 3/16 in. (13.2 cm) The Corning Museum of Glass, Corning, New York (69.1.1) Made in 1       Syria, Damascus 662             Glass 3   http://www.metmuseum.org/art/collection/search/478034 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
331815 331815 isl770 0 0 478035 The Cloisters 17   Luster-Painted Flask                             9th–10th century 800 999 Glass, bluish; free blown; dark brown and silver stains; tooled on pontil 50627 H: 5 5/16 in (13.5cm); diam: 3 9/16 in. (9 cm) The David Collection, Copenhagen (1/1985) Made in 1       Probably Egypt 461             Glass 3   http://www.metmuseum.org/art/collection/search/478035 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
332348 332348 isl1708 0 0 479005 The Cloisters 17   Jug with Stylite                             5th–7th century 400 699 Glass, mold-blown, light green with dark green handle and thread decoration; trailed-on handle and neck ring 50706 H: 5 9/16 in. (14.2 cm) Yale University Art Gallery, The Hobart and Edward Small Moore Memorial Collection (1955.6.149) Made in 1       Syria (?) 599             Glass 3   http://www.metmuseum.org/art/collection/search/479005 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
332362 332362 isl1723 0 0 479057 The Cloisters 17   Chalice with Scenes of the Adoration of the Cross                             6th–7th century 500 699 Glass 31 H: 5 7/8 in.; diam. at rim: 6 in. (H: 14.9 cm; diam. at rim: 15.3 cm) Byzantine Collection, Dumbarton Oaks, Washington, D.C. (BZ.1937.21) Made in 1       Syria or Byzantine Palestine 683             Glass 3   http://www.metmuseum.org/art/collection/search/479057 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
332696 332696 isl1765 0 0 479460 The Cloisters 17   Hexagonal Pilgrim Jug                             late 7th–early 8th century 650 750 Glass, molded 25881 5 5/16 x 2 3/8 in. (13.5 x 6 cm) The Ashmolean Museum, Oxford (AN1949.144.a) Made in 1       Palestine 74             Glass 3   http://www.metmuseum.org/art/collection/search/479460 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 411.348ms · Data license: CC0 · Data source: metmuseum/openaccess