MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Medium = 21393 and Object Name = 557

View and edit SQL

Suggested facets: Is Public Domain, Culture, Artist Role, Artist Prefix, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Dimensions

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
105888 17.190.1012 0 1 193724 European Sculpture and Decorative Arts 3 Watch 557 Watch Swiss, Geneva 2143         Maker 1 Watchmaker: J. Patron     Patron J. 9093   1700 1800 18th century 1700 1799 Metal, enamel 21393 Height: 1 1/2 in. (3.8 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106172 17.190.1416 0 0 194010 European Sculpture and Decorative Arts 3 Watch 557 Watch French, Paris 114                           19th century 1800 1899 Metal, enamel 21393 Diameter: 1 3/4 in. (4.4 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106192 17.190.1437 0 1 194030 European Sculpture and Decorative Arts 3 Watch 557 Watch Flemish, Brussels 2489         Enameler|Maker 402 Possibly by|Watchmaker: Henri Toutin|P. Landré French, 1614–1684|active mid-17th century   Toutin, Henri|Landré P. 9205   1614 |1635 1684 |1665 ca. 1630 1625 1635 Metal, enamel 21393 Diameter: 2 3/8 in. (6 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106315 17.190.1562 0 1 194153 European Sculpture and Decorative Arts 3 Watch 557 Watch French, Paris 114                           ca. 1805 1800 1810 Metal, enamel 21393 Diameter: 1 3/4 in. (4.4 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106324 17.190.1571 0 1 194162 European Sculpture and Decorative Arts 3 Watch 557 Watch French 7         Maker 1 Watchmaker: Pierre Duet ca. 1730   Duet Pierre 9290   1700 1760 17th–18th century 1600 1799 Metal, enamel 21393 Diameter: 1 5/8 in. (4.1 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106336 17.190.1585 0 1 194174 European Sculpture and Decorative Arts 3 Watch 557 Watch French, Paris 114         Maker 1 Watchmaker: Robert Robin French, 1749–1799   Robin, Robert 9300   1749 1799 ca. 1790 1785 1795 Metal, enamel 21393 Diameter: 2 1/8 in. (5.4 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106343 17.190.1592 0 1 194181 European Sculpture and Decorative Arts 3 Watch 557 Watch French, Paris 114         Maker 1 Watchmaker: Gridin     GRIDIN 9307   1700 1800 ca. 1730–50 1725 1755 Metal, enamel 21393 Diameter: 1 5/8 in. (4.1 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106349 17.190.1598 0 1 194187 European Sculpture and Decorative Arts 3 Watch 557 Watch Swiss, Geneva 2143         Maker|Maker 6 Watchmaker:|Case maker: Étienne Oltramare|Christophe Morliêre 1643–1693|French   Oltramare Étienne|Morliêre, Christophe 9313   1643 |1600 1693 |1700 ca. 1680–90 1675 1695 Metal, enamel 21393 Diameter: 2 1/4 in. (5.7 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106351 17.190.1601 0 1 194189 European Sculpture and Decorative Arts 3 Watch 557 Watch Austrian, Vienna 349         Maker 1 Watchmaker: Monée w. ca. 1770   MONÉE 9315   1740 1800 19th century 1800 1899 Metal, enamel 21393 1 3/4 × 1 in. (4.4 × 2.5 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106363 17.190.1613 0 1 194201 European Sculpture and Decorative Arts 3 Watch 557 Watch French, Angoulême 2686         Maker 1 Watchmaker: Abraham Yver ca. 1620–1680   Yver Abraham 9326   1620 1680 17th century 1600 1699 Metal, enamel 21393 Diameter: 1 1/4 in. (3.2 cm) Gift of J. Pierpont Morgan, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
106375 17.190.1625 0 1 194213 European Sculpture and Decorative Arts 3 Watch 557 Watch French, Paris 114         Maker 1 Watchmaker: G. Gamot French, ca. 1646   Gamot, G. 9335   1641 1651 ca. 1650 1645 1655 Metal, enamel 21393 Diameter: 2 1/2 in. (6.4 cm) Gift of J. Pierpont Morgan, 1917                       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 243.789ms · Data license: CC0 · Data source: metmuseum/openaccess