MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Country = 599

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Date, Object Begin Date, Object End Date, Medium, Classification

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
327953 61.247 0 1 468577 Medieval Art 6 Bottle 48 Yellow-Green Hexagonal Glass Bottle with a Stylite Saint Byzantine 1134                           mid-5th–7th century 450 699 Moulded glass 49111 Overall: 8 9/16 x 2 1/2 x 2 9/16 in. (21.7 x 6.4 x 6.5 cm) Gift of Mrs. Carleton S. Coon, 1961 Made in 1       Syria (?) 599             Glass-Vessels 143   Metropolitan Museum of Art, New York, NY 1
331715 isl713 0 0 477460 The Cloisters 17   Token with Stylite, Baptism of Christ, and Adoration of the Magi                             6th-7th century 500 699 Terracotta 160 1/4 x 1 in. (0.7 x 2.5 cm) Malcove Collection, University of Toronto Art Centre, Toronto (M82.242) Made in 1       Syria (?) 599             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
331731 isl517 0 0 477507 The Cloisters 17   Rabbula Gospels                             completed 586 586 586 Ink and colors on parchment; 292 folios 50598 13 3/16 x 10 7/16 in. (33.5 x 26.5 cm) Biblioteca Medicea Laurenziana, Florence (Plut. I. 56) Made in 1       Syria (?) 599             Manuscripts 188   Metropolitan Museum of Art, New York, NY 1
331741 isl447 0 0 477566 The Cloisters 17   Pyxis with Vine Scrolls and Birds                             7th–8th century 600 799 Ivory and red, blue, and black paint; beechwood lid, painted and gilded, with rock crystal knob and gilt copper fittings, added later 50605 H: 5 1/2 in. (14 cm); diam: 3 3/8 in. (8.5 cm) Victoria and Albert Museum, London (136-1866) Made in 1       Syria (?) 599             Ivories 181   Metropolitan Museum of Art, New York, NY 1
331742 isl448 0 0 477567 The Cloisters 17   Pyxis with Vine Scrolls                             7th–8th century 600 799 Ivory; metal rim around lid added later 50606 H: 3 3/4 in. (9.5 cm); diam: 3 9/16 in. (9 cm) Stiftung Preußischer Kulturbesitz, Staatliche Museen zu Berlin—Skulpturensammlung und Museum für Byzantinische Kunst, Berlin (2977) Made in 1       Syria (?) 599             Ivories 181   Metropolitan Museum of Art, New York, NY 1
331830 isl538 0 0 478131 The Cloisters 17   Folio from a Qur'an                             late 7th-early 8th century (?) 650 750 Brown ink and pigments on parchment; the back side has been reinked with a black carbon ink; decorative details in red, green, yellow, and white 50640 18 5/16 x 15 11/16 in. (46.5 x 39.9 cm) The David Collection, Copenhagen (26 / 2003) Made in 1       Syria (?) 599             Manuscripts 188   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
332369 isl1728 0 0 479064 The Cloisters 17   Pyxis with Crosses and Vine Scrolls                             7th–8th century 600 800 Ivory with red paint added later 50713 H: 3 3/8 in. (8.5 cm); diam: 2 11/16 in. (6.8 cm) Stiftung Preußischer Kulturbesitz, Staatliche Museen zu Berlin—Skulpturensammlung und Museum für Byzantinische Kunst, Berlin (11531) Made in 1       Syria (?) 599             Ivories 181   Metropolitan Museum of Art, New York, NY 1
332379 isl1733 0 0 479079 The Cloisters 17   Group of Six Pilgrim Tokens                             6th-7th century 500 700 Terracotta 160 Diam (1973,0501.1): 11/16 in. (1.8 cm); diam (1973,0501.4): 11/16 in. (1.7 cm); diam (1973,0501.19): 11/16 in. (1.7 cm); diam (1973,0501.30): 11/16 in. (1.7 cm); diam (1973,0501.47): 5/8 in. (1.6 cm); diam (1973,0501.78): 11/16 in. (1.7 cm) The British Museum, London (1973.0501.1, .4, .19, .30, .47, .78) Made in 1       Syria (?) 599             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
332616 isl390 0 0 479335 The Cloisters 17   Token with Stylite                             6th-7th century 500 699 Terracotta 160 1 1/16 x 15/16 in. (2.7 x 2.4 cm) Tsolozidis Collection, Thessaloniki (S?169) Made in 1       Syria (?) 599             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 120.789ms · Data license: CC0 · Data source: metmuseum/openaccess