MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 6 and Object Name = 6

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
108507	108507	29.180.3	1	196532	European Sculpture and Decorative Arts 3	Clock 6	Clock	French, Paris 114	Maker\|Maker 6	Clockmaker:\|Case maker:	Joseph Charles Paul Bertrand\|Jean-Joseph de Saint Germain	master 1772–89\|French, 1719–1791	Bertrand Joseph Charles Paul\|Saint Germain, Jean Joseph de 9735		1772 \|1719	1789 \|1791	ca. 1765	1760	1770	Bronze and gilt bronze 21713	Overall: 29 1/4 × 17 1/2 × 9 3/4 in. (74.3 × 44.5 × 24.8 cm)	Bequest of Ogden Mills, 1929	Horology 316	http://www.metmuseum.org/art/collection/search/196532	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
109911	109911	37.160.9	1	198012	European Sculpture and Decorative Arts 3	Clock 6	Clock (pendule à console)	French, Paris 114	Maker\|Maker 6	Clockmaker: probably\|Case maker:	Jean-Philippe Gosselin\|Jean-Joseph de Saint Germain	French, recorded as master in Paris 1717, died 1766\|French, 1719–1791	Gosselin, Jean-Philippe\|Saint Germain, Jean Joseph de 10015		1666 \|1719	1766 \|1791	ca. 1750	1745	1755	Case: bronze, formerly gilded, silvered or lacquered; dial: white enamel, with black numerals; movement: brass and steel 22104	Overall: 16 × 12 in. (40.6 × 30.5 cm)	Bequest of Ogden Mills, 1929	Horology 316	http://www.metmuseum.org/art/collection/search/198012	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
114002	114002	59.208.79	1	202375	European Sculpture and Decorative Arts 3	Clock 6	Clock	French, Paris 114	Maker\|Maker 6	Casemaker: Attributed to\|Clockmaker:	Jules-Simon Deverberie\|Laurent Ridel	French, active 1788–1820, died ca. 1824\|French, active 1789	Deverberie, Jules-Simon\|Ridel, Laurent 10915		1724 \|1789	1824 \|1800	ca. 1800	1795	1805	Case: partly patinated and partly gilded bronze, gilded brass, and paste jewels; Dial: white enamel with gilded brass and steel hands; Movement: brass and steel 22731	Overall: 22 1/8 × 17 1/2 × 6 in. (56.2 × 44.5 × 15.2 cm); Diameter (back plate): 4 3/4 in. (12.1 cm)	Gift of Estate of James Hazen Hyde, 1959	Horology 316	http://www.metmuseum.org/art/collection/search/202375	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
114151	114151	61.69	1	202541	European Sculpture and Decorative Arts 3	Clock 6	Clock (pendule à console)	French, Paris 114	Maker\|Maker 6	Movement by\|Case attributed to	Louis Mÿnüel\|Charles Cressent	French, about 1675/80–1742\|French, Amiens 1685–1768 Paris	Mÿnüel, Louis\|Cressent, Charles 10937		1675 \|1685	1742 \|1768	ca. 1720–23	1715	1728	Case: oak veneered with brass and tortoiseshell with gilded-bronze mounts; Dial: gilded brass and enamel 22752	Overall: 38 1/4 × 22 1/2 × 9 1/2 in. (97.2 × 57.2 × 24.1 cm)	Fletcher Fund, 1961	Horology 316	http://www.metmuseum.org/art/collection/search/202541	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
121707	121707	2002.237	1	211388	European Sculpture and Decorative Arts 3	Clock 6	Clock	German, Neuwied am Rhein 2949	Maker\|Maker 6	Workshop of\|Movement attributed to	David Roentgen\|Elie Prudhomme	German, Herrnhaag 1743–1807 Wiesbaden, master 1780\|German, born Switzerland, first mentioned 1776	Roentgen, David\|Prudhomme Elie 12268	German\|German (b. Switzerland) 365	1743 \|1776	1807 \|1776	ca. 1780–90	1775	1795	Oak, pine, and mahogany, veneered with mahogany; brass, gilt bronze and enamel 24261	Overall: 18 1/4 × 12 1/2 × 8 1/4 in. (46.4 × 31.8 × 21 cm)	Gift of The Ruth Stanton Family Foundation, in honor of Wolfram Koeppe, 2002	Horology 316	http://www.metmuseum.org/art/collection/search/211388	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
140200	140200	L.2011.66.10	0	238696	European Sculpture and Decorative Arts 3	Clock 6	Spherical Clock	Russian, St. Petersburg 2372	Maker\|Maker 6	Workmaster:	House of Carl Fabergé\|Mikhail Evlampievich Perkhin	Russian, 1860–1903	FABERGÉ, HOUSE OF CARL\|Perkhin, Mikhail Evlampievich 12756	Russian 57	1860	1903	before 1899	1886	1899	Rose jasper, silver, silver gilt, gold, enamel, glass 25475	Overall: 3 7/8 x 2 3/4 (diam.) in. (9.8 x 7 cm)	Matilda Geddings Gray Foundation	Horology 316	http://www.metmuseum.org/art/collection/search/238696	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");