MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

20 rows where Is Public Domain = 0 and Object Name = 6

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Is Public Domain

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 Metadata Date Repository
1924 1924 1974.214.23 0 0 2093 American Decorative Arts 1 Clock 6 Clock American 1                           1890–1905 1890 1905 Bronze 23 18 5/16 x 9 in. (46.5 x 22.9 cm) Gift of Mr. and Mrs. Hugh J. Grant, 1974 Possibly made in 5       United States 3             Metal 1   http://www.metmuseum.org/art/collection/search/2093 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
16175 16175 2004.24 0 0 17730 American Decorative Arts 1 Clock 6 Clock American 1         Maker 1   Robert Joyce     Joyce, Robert 2485     9999 ca. 1795 1792 1798 Mahogany, mahogany veneers, and tulip poplar 3049 78 x 28 in. (198.1 x 71.1 cm) Bequest of Miriam Thorne Gilpatric, 2004 Made in 1 New York 3     United States 3             Furniture 4   http://www.metmuseum.org/art/collection/search/17730 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
16661 16661 2009.147 0 0 20105 American Decorative Arts 1 Clock 6 Clock French 7         Maker 1   Gaspard Cachard active 1792/95–1802   Cachard, Gaspard 2583   1792 1802 ca. 1800 1795 1805 Black marble, ormolu, gilt bronze and/or brass, enamel dial, and clock mechanism 3210 26 15/16 x 17 x 6 1/8 in. (68.4 x 43.2 x 15.6 cm) Purchase, Morris K. Jesup Fund, by exchange, and Jan and Warren Adelson Gift, 2009 Probably made in 2 Paris 27     France 9             Furniture 4   http://www.metmuseum.org/art/collection/search/20105 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
54446 54446 00.12.13 0 0 62827 Asian Art 7 Clock 6   Japan 46                           19th century 1800 1899 Brass and wood 13409 H. 6 1/4 in. (15.9 cm); Diam. of dial 2 1/2 in. (6.4 cm) Bequest of Thomas Egleston, 1900                       Horology-Clocks 233   http://www.metmuseum.org/art/collection/search/62827 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
54447 54447 00.12.14 0 0 62828 Asian Art 7 Clock 6   Japan 46                           19th century 1800 1899 Wood, gilt brass 13412 H. 4 1/2 in. (11.4 cm); Diam. of dial 2 in. (5.1 cm) Bequest of Thomas Egleston, 1900                       Horology-Clocks 233   http://www.metmuseum.org/art/collection/search/62828 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
54448 54448 00.12.15 0 0 62829 Asian Art 7 Clock 6   Japan 46                           19th century 1800 1899 Wood, gilt brass 13412 H. 6 1/4 in. (15.9 cm); Diam. of dial 2 5/8 in. (6.7 cm) Bequest of Thomas Egleston, 1900                       Horology-Clocks 233   http://www.metmuseum.org/art/collection/search/62829 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
54449 54449 00.12.16 0 0 62830 Asian Art 7 Clock 6   Japan 46                           19th century 1800 1899 Wood, gilt brass 13412 H. 6 3/4 in. (17.1 cm); Diam. of dial 2 5/8 in. (6.7 cm) Bequest of Thomas Egleston, 1900                       Horology-Clocks 233   http://www.metmuseum.org/art/collection/search/62830 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
54451 54451 00.12.18 0 0 62832 Asian Art 7 Clock 6   Japan 46                           19th century 1800 1899 Wood, gilt brass 13412 H. 2 5/8 in. (6.7 cm); Diam. of dial 1 3/4 in. (4.4 cm) Bequest of Thomas Egleston, 1900                       Horology-Clocks 233   http://www.metmuseum.org/art/collection/search/62832 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
105772 105772 17.190.638 0 0 193608 European Sculpture and Decorative Arts 3 Clock 6 Clock German, Dresden 207         Maker 1 Clockmaker: Andreas Müller German   Müller Andreas 9078       movement 17th century, case 19th century 1600 1899 Gilt bronze 30 Overall: 13 1/4 × 9 5/8 × 7 3/8 in. (33.7 × 24.4 × 18.7 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   http://www.metmuseum.org/art/collection/search/193608 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
108376 108376 29.52.5 0 0 196393 European Sculpture and Decorative Arts 3 Clock 6 Clock German 27                           17th century 1600 1699 Brass gilt, ebony 21890 Overall: 10 1/4 × 6 1/2 × 6 1/4 in. (26 × 16.5 × 15.9 cm) Gift of Mrs. Simon Guggenheim, 1929                       Horology 316   http://www.metmuseum.org/art/collection/search/196393 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
108380 108380 29.52.9 0 0 196397 European Sculpture and Decorative Arts 3 Clock 6 Clock German 27                           17th century 1600 1699 Base metal silver plated, iron, brass 21892 10 1/2 × 3 3/8 in. (26.7 × 8.6 cm) Gift of Mrs. Simon Guggenheim, 1929                       Horology 316   http://www.metmuseum.org/art/collection/search/196397 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
108381 108381 29.59.10a, b 0 0 196398 European Sculpture and Decorative Arts 3 Clock 6 Clock German 27                           early 17th century 1600 1615 Brass gilt, ebony, ivory 21893 Clock (a): 8-7/8 x 4-1/8 in. (22.5 x 10.5 cm) Base (b): 4 x 6 in. (10.2 x 15.2 cm) Gift of Mrs. Simon Guggenheim, 1929                       Horology 316   http://www.metmuseum.org/art/collection/search/196398 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
108384 108384 29.52.12 0 0 196401 European Sculpture and Decorative Arts 3 Clock 6 Clock German 27                           early 17th century 1600 1615 Copper gilt 20614 Overall: 12 × 6 1/2 × 5 5/8 in. (30.5 × 16.5 × 14.3 cm) Gift of Mrs. Simon Guggenheim, 1929                       Horology 316   http://www.metmuseum.org/art/collection/search/196401 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
121120 121120 61.78.18 0 0 210678 European Sculpture and Decorative Arts 3 Clock 6 Clock British, London 222                           late 19th century 1885 1899 Silver 2 Overall: 4 1/2 x 4 3/4 x 1 3/8 in. (11.4 x 12.1 x 3.5 cm) Gift of Mrs. Amos L. Beaty, 1961                       Metalwork-Silver 313   http://www.metmuseum.org/art/collection/search/210678 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
140200 140200 L.2011.66.10 0 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
337479 337479 1988.236.4 0 0 485052 Modern and Contemporary Art 4 Clock 6 Tantalo Clock           Designer|Manufacturer 3   Richard Sapper|Artemide S.p.A. German, born Munich, 1932   Sapper, Richard|ARTEMIDE SPA 45869 German 10 1932 2032 late 1960s–1970s 1965 1979 White lacquer 51858 6 in. × 3 1/4 in. × 2 1/4 in. (15.2 × 8.3 × 5.7 cm) Gift of Artemide S.p.A., Italy, 1988                       Horology 316   http://www.metmuseum.org/art/collection/search/485052 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
390880 390880 SL.14.2015.5.1a–k 0 0 642427 American Decorative Arts 1 Clock 6 Tall case clock, probably from the William Clark House, Newark, New Jersey American 1         Maker|Maker|Maker 29 Clock movement by|Case by George A. Schastey|Tiffany & Co.|George A. Schastey & Co. 1839–1894|1837–present|1873–97   Schastey, George A.|Tiffany & Co.|George A. Schastey & Co. 49825   1839 |1837 |1873 1894 |9999 |1897 ca. 1882 1877 1887 Ebonized oak, leaded glass, and brass 58576 Approx. 8 x 1 1/2 x 1 1/2 ft. Collection of Brian A. Emery                       Furniture 4   http://www.metmuseum.org/art/collection/search/642427 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
390887 390887 SL.14.2015.4.1 0 0 642440 American Decorative Arts 1 Clock 6 Wall clock American 1         Maker|Maker|Maker 29 Clock movement by George A. Schastey|Tiffany & Co.|George A. Schastey & Co. 1839–1894|1837–present|1873–97   Schastey, George A.|Tiffany & Co.|George A. Schastey & Co. 49825   1839 |1837 |1873 1894 |9999 |1897 1881 1881 1881 Walnut, pine, glass, brass, and silver-plated brass 58577 40 × 25 × 11 1/2 in., appx. 100 lb. (101.6 × 63.5 × 29.2 cm, 45359.702g) Private Collection, Houston, Texas                       Furniture 4   http://www.metmuseum.org/art/collection/search/642440 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
421979 421979 SL.3.2018.47.13 0 0 699733 European Sculpture and Decorative Arts 3 Clock 6 Mantle Clock French 7         Maker|Artist 39 Movement by|Case by Joseph Juhel|François Caranda French, 1728–1803|French, Paris 1704–after 1789 Paris, master in 1741   Juhel, Joseph|Caranda, François 53767   1728 |1704 1803 |1789 1784 (case) 1784 1784 Patinated bronze, gilt bronze, white marble, enamel, glass 60321 23 5/8 × 16 15/16 × 11 1/8 in. (60 × 43 × 28.3 cm) Musée National des Châteaux de Versailles et de Trianon (V5057)                       Horology 316   http://www.metmuseum.org/art/collection/search/699733 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
422236 422236 L.2015.74 0 0 700211 American Decorative Arts 1 Clock 6 Wall clock from the Japanese parlor of the William H. Vanderbilt House French 7         Designer 5 Design attributed to Marcelle Lancelot French, 1849–1942   Lancelot, Marcelle 53819   1849 1942 ca. 1882 1877 1887 Bronze, gilded bronze, and cloisonné enamel 60453 38 × 15 1/2 in. (96.5 × 39.4 cm) Collection of Margot Johnson Country of Origin 23       France 9             Furniture 4   http://www.metmuseum.org/art/collection/search/700211 4/23/2018 8:00:01 AM 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 7640.708ms · Data license: CC0 · Data source: metmuseum/openaccess