MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

3 rows where Artist Role = 532

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
113840	113840	58.75.58	1	202164	European Sculpture and Decorative Arts 3	Wall clock-thermometer 8136	Wall clock-thermometer (pendule et thermomètre en cartel)	French, Paris 114	Factory\|Maker\|Decorator 532	Porcelain plaques by\|Clockmaker:	Sèvres Manufactory\|Claude-Siméon Passemant\|Charles Nicolas Dodin	French, 1740–present\|1702–1769\|French, Versailles 1734–1803 Sèvres	Sèvres Manufactory\|Passemant Claude-Siméon\|Dodin, Charles Nicolas 10859	French 2	1740 \|1702 \|1734	9999 \|1769 \|1803	1764–70	1764	1770	Gilt bronze, porcelain, enamel, steel, oak 22697	Overall: 40 1/2 × 11 × 3 3/8 in. (102.9 × 27.9 × 8.6 cm)	Gift of Samuel H. Kress Foundation, 1958	Horology 316	http://www.metmuseum.org/art/collection/search/202164	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
117584	117584	1976.155.106	1	206496	European Sculpture and Decorative Arts 3	Candlestand and worktable 8448	Candelstand and worktable (table à ouvrage en guéridon)	French, Sèvres 2212	Factory\|Maker\|Decorator 532	Porcelain plaques by\|Attributed to\|Porcelain plaques decorated by	Sèvres Manufactory\|Roger Vandercruse, called Lacroix\|Charles Vandé	French, 1740–present\|French, 1727–1799\|French, active 1785–91	Sèvres Manufactory\|Vandercruse Roger called Lacroix\|Vandé, Charles 11526	French\|French\|French 103	1740 \|1727 \|1785	9999 \|1799 \|1791	ca. 1785	1780	1790	Oak veneered with tulipwood, boxwood, holly and ebonized holly, sycamore, and other woods; soft-paste porcelain, gilt bronze, silk 23362	H. 31-1/8 in. (79.1 cm); Diam. of top 14-5/8 in. (37.1 cm)	Gift of Mr. and Mrs. Charles Wrightsman, 1976	Woodwork-Furniture 321	http://www.metmuseum.org/art/collection/search/206496	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
139277	139277	58.75.49	1	231857	European Sculpture and Decorative Arts 3	Desk 89	Small writing desk (bonheur-du-jour)	French, Paris and Sèvres 3089	Factory\|Maker\|Decorator 532	Porcelain plaques by	Sèvres Manufactory\|Martin Carlin\|Jean-Jacques Pierre the Younger	French, 1740–present\|French, near Freiburg im Breisgau ca. 1730–1785 Paris\|French, active 1763–1800	Sèvres Manufactory\|Carlin, Martin\|Pierre, Jean-Jacques jeune 12668	French\|French 21	1740 \|1725 \|1763	9999 \|1785 \|1800	ca. 1774	1769	1779	Oak veneered with tulipwood, amaranth, and stained sycamore; mahogany; seventeen soft-paste porcelain plaques; gilt-bronze mounts; velvet (not original) 25321	Overall: 32 1/2 × 25 7/8 × 16 in. (82.6 × 65.7 × 40.6 cm)	Gift of Samuel H. Kress Foundation, 1958	Woodwork-Furniture 321	http://www.metmuseum.org/art/collection/search/231857	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");