MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Classification = 314 and Medium = 160

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Culture	Artist Role	Artist Prefix	Artist Display Name	Artist Display Bio	Artist Alpha Sort	Artist Nationality	Artist Begin Date	Artist End Date	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Classification	Link Resource	Metadata Date	Repository
103494	103494	08.196.218	1	191045	European Sculpture and Decorative Arts 3	Tile 101	Tile	Dutch 4									1564	1564	1564	Terracotta 160	4 × 6 × 2 1/2 in. (10.2 × 15.2 × 6.4 cm)	Gift of W. R. Valentiner, 1908	Ceramics-Pottery 314	http://www.metmuseum.org/art/collection/search/191045	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
105313	105313	14.132.16a, b	0	193120	European Sculpture and Decorative Arts 3	Pastille burner with cover 7553	Pastille burner with cover	British, Staffordshire 2229	Maker 1		Josiah Wedgwood and Sons	1759–present	Wedgwood and Sons, Josiah 124		1759	9999	1790	1790	1790	Terracotta 160	Overall: 1 1/2 × 3 15/16 in. (3.8 × 10 cm)	Rogers Fund, 1914	Ceramics-Pottery 314	http://www.metmuseum.org/art/collection/search/193120	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
105322	105322	14.132.27	1	193130	European Sculpture and Decorative Arts 3	Medallion 72	Henry IV	British, Staffordshire 2229	Factory 328		Josiah Wedgwood	British, Burslem, Stoke-on-Trent 1730–1795 Burslem, Stoke-on-Trent	Wedgwood, Josiah 8583	British 7	1730	1795	18th century	1700	1799	Terracotta 160	Diameter: 1 9/16 in. (4 cm)	Rogers Fund, 1914	Ceramics-Pottery 314	http://www.metmuseum.org/art/collection/search/193130	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
109914	109914	37.172a–c	1	198015	European Sculpture and Decorative Arts 3	Soup tureen with cover and tray 7868	Soup tureen with cover and tray	French, Sceaux 2287									ca. 1750–65	1745	1770	Terracotta 160		Rogers Fund, 1937	Ceramics-Pottery 314	http://www.metmuseum.org/art/collection/search/198015	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
116436	116436	69.216.1, .2	1	205143	European Sculpture and Decorative Arts 3	Vases 4454	Pair of vases	Danish, Copenhagen 2273	Manufacturer\|Decorator\|Artist 562	After marble reliefs by	Frederick Sonne\|V. Wendrich\|Bertel Thorvaldsen	Danish, Copenhagen 1770–1844 Copenhagen	Sonne Frederick\|Wendrich V.\|Thorvaldsen, Bertel 11317	Danish 144	1800 \|1770	1900 \|1844	ca. 1875	1870	1880	Terracotta 160	Height (.1): 8 1/4 in. (21 cm); Height (.2): 8 5/16 in. (21.1 cm)	Gift of Mrs. B. V. Smith, 1969	Ceramics-Pottery 314	http://www.metmuseum.org/art/collection/search/205143	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
140548	140548	2013.239.3	1	239505	European Sculpture and Decorative Arts 3	Plaque 75	Plaque depicting a pottery workshop	British, Southall, London 3984	Maker 1		R. W. Martin and Brothers	British, 1873–1915	R. W. Martin and Brothers 12896	British 7	1873	1915	ca. 1882	1877	1887	Terracotta 160	Overall (confirmed): 7 1/4 × 17 × 2 1/8 in. (18.4 × 43.2 × 5.4 cm); Framed (confirmed): 16 1/4 × 19 3/4 × 2 5/8 in. (41.3 × 50.2 × 6.7 cm)	Robert A. Ellison Jr. Collection, Gift of Robert A. Ellison Jr., 2013	Ceramics-Pottery 314	http://www.metmuseum.org/art/collection/search/239505	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");