MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Artist Prefix = "Clockmaker:" and Object Name = 6

View and edit SQL

Suggested facets: Is Public Domain, Title, Culture, Artist Role, Object Begin Date, Medium, Credit Line

Artist Prefix

  • Clockmaker: · 12
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 Repository
101037 00.12.4a, b 0 1 188492 European Sculpture and Decorative Arts 3 Clock 6 Clock with bracket French, Paris 114         Maker 1 Clockmaker: Gernier     Gernier 8296   1700 1800 mid-18th century 1730 1765 Wood, brass, enamel 20742 Height: 14 1/2 in. (36.8 cm); Diameter (dial): 2 1/8 in. (5.4 cm) Bequest of Thomas Egleston, 1900                       Horology 316   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
107521 26.223.5 0 1 195491 European Sculpture and Decorative Arts 3 Clock 6 Clock French, Paris 114         Maker 1 Clockmaker: Chapsal l'ainé working 1812–20   Chapsal 9564   1782 1850 ca. 1815–30 1810 1835 Gilt bronze 30 Overall: 16 3/4 × 12 3/4 × 4 5/8 in. (42.5 × 32.4 × 11.7 cm) Rogers Fund, 1926                       Horology 316   Metropolitan Museum of Art, New York, NY 1
108372 29.52.1 0 1 196389 European Sculpture and Decorative Arts 3 Clock 6 Clock German, Wasserburg 2859         Maker 1 Clockmaker: Joh Georg Wagner     Wagner Joh Georg 9713   1625 1725 late 17th century 1685 1699 Gilt bronze, leather, wood 21888 Overall: 1 1/4 × 4 1/8 × 2 1/2 in. (3.2 × 10.5 × 6.4 cm) Gift of Mrs. Simon Guggenheim, 1929                       Horology 316   Metropolitan Museum of Art, New York, NY 1
108389 29.52.17 0 1 196406 European Sculpture and Decorative Arts 3 Clock 6 Clock French, Fontainebleau 2283         Maker 1 Clockmaker: Le Febvre, Fils active 1759   Le Febvre, Fils 9717   1759 1759 18th century 1700 1799 Brass gilt 20741 Overall: 8 × 4 3/4 × 3 1/2 in. (20.3 × 12.1 × 8.9 cm) Gift of Mrs. Simon Guggenheim, 1929                       Horology 316   Metropolitan Museum of Art, New York, NY 1
108522 30.58.14 0 1 196547 European Sculpture and Decorative Arts 3 Clock 6 Clock French, Paris 114         Maker 1 Clockmaker: Festau Le Jeune (probably Simon-François) active 1776–81   Festau Le Jeune, probably Simon-François 9743   1776 1781 ca. 1770–90 1765 1795 Gilt bronze and marble 21922 16 1/4 × 6 1/2 in. (41.3 × 16.5 cm) Bequest of Edward C. Post, 1930                       Horology 316   Metropolitan Museum of Art, New York, NY 1
109041 32.100.225 0 1 197085 European Sculpture and Decorative Arts 3 Clock 6 Clock German, Augsburg 126         Maker 1 Clockmaker: Martin Zoller active 1590–1633   Zoller Martin 9802   1590 1633 late 16th–early 17th century 1585 1615 Gilt bronze, crystal 22001 Height: 8 5/8 in. (21.9 cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931                       Horology 316   Metropolitan Museum of Art, New York, NY 1
110515 41.41 0 1 198697 European Sculpture and Decorative Arts 3 Clock 6 Clock French, Paris 114         Maker 1 Clockmaker: Jean-André Lepaute French, 1720–1789   Lepaute, Jean-André 10132   1720 1789 1770–80 1770 1780 Bronze, gilt bronze, enamel 22232 Height: 20 1/2 in. (52.1 cm) Rogers Fund, 1941                       Horology 316   Metropolitan Museum of Art, New York, NY 1
110733 41.190.61 0 1 198935 European Sculpture and Decorative Arts 3 Clock 6 Clock French, Paris 114         Maker|Enameler 403 Clockmaker: Drouot|Dubuisson French, active 1807   Drouot|Dubuisson 10176   1807 |1775 1807 |1875 first quarter 19th century 1800 1825 Marble, gilt bronze 22277 22 1/2 × 23 in. (57.2 × 58.4 cm) Bequest of George Blumenthal, 1941                       Horology 316   Metropolitan Museum of Art, New York, NY 1
111394 45.60.33 0 1 199641 European Sculpture and Decorative Arts 3 Clock 6 Clock French, Paris 114         Maker 1 Clockmaker: Jean Martin active 1737–81, died 1786   Martin, Jean 10264   1737 1786 ca. 1780 1775 1785 Case: Carrara marble, gilt-bronze mounts; Movement: brass, steel 22345 H. 15-1/2 x W. 16 x D. 6-1/2 in. (39.4 x 40.6 x 16.5 cm) Fletcher Fund, 1945                       Horology 316   Metropolitan Museum of Art, New York, NY 1
113162 52.206.9 0 1 201452 European Sculpture and Decorative Arts 3 Clock 6 Boudoir clock British, London with Swiss, Geneva case 3137         Maker 1 Clockmaker: Firm of Jaquet-Droz & Leschot, London and Geneva 1752–1791   Jaquet-Droz & Leschot 10722   1752 1791 ca. 1784–91 1779 1796 Gold, enamel 959 8 7/16 × 5 1/4 in. (21.4 × 13.3 cm) Gift of Mrs. Bernice Chrysler Garbisch, 1952                       Horology 316   Metropolitan Museum of Art, New York, NY 1
114003 59.208.80 0 1 202376 European Sculpture and Decorative Arts 3 Clock 6 Clock French, Paris 114         Maker 1 Clockmaker: Bouchet French   Bouchet 10916   1775 1875 early 19th century 1800 1815 Gilt bronze 30 Overall: 22 7/8 × 15 1/2 × 9 in. (58.1 × 39.4 × 22.9 cm) Gift of Estate of James Hazen Hyde, 1959                       Horology 316   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 136.051ms · Data license: CC0 · Data source: metmuseum/openaccess