MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Medium = 25847

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Period	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	Region	Subregion	Classification	Link Resource	Metadata Date	Repository
149709	149709	15.1.1	1	248914	Greek and Roman Art 12	Painted glass fragment with hunt scene 11279	Glass fragment with painted scene	Roman 736	Late Imperial										4th century A.D.	-30	364	Glass, paint 25847	1 1/4 × 1 7/16 × 1/4 in. (3.2 × 3.7 × 0.6 cm)	Rogers Fund, 1915			Glass 3	http://www.metmuseum.org/art/collection/search/248914	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
203030	203030	59.107.25	1	324384	Ancient Near Eastern Art 14	Painted glass fragment 11948	Painted glass fragment	Assyrian 5654	Neo-Assyrian										ca. 8th–7th century B.C.	-800	-600	Glass, paint 25847	H. 3/4 x W. 3/4 x D. 1/8 in. (1.8 x 1.9 x 0.3 cm)	Rogers Fund, 1959	Mesopotamia 335	Nimrud (ancient Kalhu) 5	Glass-Ornaments 562	http://www.metmuseum.org/art/collection/search/324384	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
203031	203031	59.107.26	1	324385	Ancient Near Eastern Art 14	Painted glass fragment 11948	Painted glass fragment	Assyrian 5654	Neo-Assyrian										ca. 8th–7th century B.C.	-800	-600	Glass, paint 25847	1.1 x 0.53 x 0.1 in. (2.79 x 1.35 x 0.25 cm)	Rogers Fund, 1959	Mesopotamia 335	Nimrud (ancient Kalhu) 5	Glass-Ornaments 562	http://www.metmuseum.org/art/collection/search/324385	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
338627	338627	1993.323	0	486253	Modern and Contemporary Art 4	Wine glass 978	Wine glass			Designer\|Designer\|Manufacturer 247	Pattern by\|Form by	Ludwig Heinrich Jungnickel\|Josef Hoffmann\|J. & L. Lobmeyr, Vienna, Austria	Austrian (born Germany), Wunsiedel 1881–1965 Vienna\|Austrian, Pirnitz 1870–1956 Vienna	for the Wiener Werkstätte	Jungnickel, Ludwig Heinrich\|Hoffmann, Josef\|Lobmeyr, J. & L. 46176	Austrian, born Germany\|Austrian\|Austrian 3443	1881 \|1870	1965 \|1956	1911	1911	1911	Glass, paint 25847	H. 7-1/4, Diam. 3-1/8 in. (18.4 x 7.9 cm.)	The Cynthia Hazen Polsky Fund, 1993			Glass 3	http://www.metmuseum.org/art/collection/search/486253	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
339899	339899	30.134.2	0	487678	Modern and Contemporary Art 4	Vase 7	Vase	Austrian (Vienna) 6162		Manufacturer\|Designer 18		J. & L. Lobmeyr, Vienna, Austria\|Ena Rottenberg	Austrian (born Hungary), Orawiczabanya 1893–1950 Vienna		Lobmeyr, J. & L.\|Rottenberg, Ena 46553	Austrian\|Austrian, born Hungary 3453	1893	1950	1928	1928	1928	Glass, paint 25847	H. 5-5/8, Diam. 5-1/16 inches	Purchase, Edward C. Moore Jr. Gift, 1929			Glass 3	http://www.metmuseum.org/art/collection/search/487678	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

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");