MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Medium = 20614

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Artist Role, Artist Prefix, Object Date, Object Begin Date, Object End Date, Credit Line, Classification

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
100126 92.10.94a, b 0 0 187483 European Sculpture and Decorative Arts 3 Medal 148 To C.W. Fields, and his Telegraph Companies, Universal Exhibition, Paris, 1867 French 7         Artist 2 Medalist: François-Joseph-Hubert Ponscarme French, Belmont-les-Monthureaux, Vosges 1827–1903 Malakoff, Hauts-de-Seine   Ponscarme, François-Joseph-Hubert 8149   1827 1903 1867 1867 1867 Copper gilt 20614 Diameter: 2 5/8 in. (67 mm) Gift of Cyrus W. Field, 1892                       Medals and Plaquettes-Reproductions 310   Metropolitan Museum of Art, New York, NY 1
100127 92.10.95a, b 0 1 187484 European Sculpture and Decorative Arts 3 Medal 148 To Cyrus W. Field from the American Chamber of Commerce, Liverpool, on the Laying of the Atlantic Cable, 1866 British 6         Artist|Artist 13 Medalist:|Medalist: Joseph Shepherd Wyon|Alfred Benjamin Wyon British, 1836–1873|British, 1837–1884   Wyon Joseph Shepherd|Wyon Alfred Benjamin 8152 British|British 9 1836 |1837 1873 |1884 1866 1866 1866 Copper gilt 20614 Diameter: 3 in. (76 mm) Gift of Cyrus W. Field, 1892                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
103551 09.43.2 0 1 191105 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the Universal Exhibition at Amsterdam, 1895 Dutch 4         Artist 2 Medalist: J. M.     M. J. 8643   1850 1950 1895 1895 1895 Copper gilt 20614 Diameter: 2 3/16 in. (5.6 cm) Gift of James B. Hammond, 1909                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
105560 17.101.41 0 1 193381 European Sculpture and Decorative Arts 3 Repeating watch 7583 Repeating watch Swiss, Geneva 2143         Maker 1 Watchmaker: Firm of Wiss Brothers ca. 1775   Wiss Brothers 9006   1770 1780 ca. 1775–85 1770 1790 Copper gilt 20614 Diameter: 1 3/4 in. (4.4 cm) Bequest of Laura Frances Hearn, 1917                       Horology 316   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
108668 30.135.78 0 1 196705 European Sculpture and Decorative Arts 3 Mirror 3984 Mirror French 7                           1600–1650 1600 1650 Copper gilt 20614 Overall: 7 3/4 × 5 1/16 in. (19.7 × 12.9 cm) Gift of Mrs. Edward S. Harkness, 1930                       Metalwork-Copper 324   Metropolitan Museum of Art, New York, NY 1
111547 47.133.1 0 1 199810 European Sculpture and Decorative Arts 3 Table clock 7044 Table clock German 27         Maker 1 Clockmaker: Karl Schmidt German, ca. 1590–1635/36, working 1614   Schmidt, Karl (or Carol) 9272   1590 1636 ca. 1600 1595 1605 Copper gilt 20614 Height: 11 1/4 in. (28.6 cm) Gift of Mrs. George C. Bryant, 1947                       Horology 316   Metropolitan Museum of Art, New York, NY 1
111562 48.14.14 0 1 199825 European Sculpture and Decorative Arts 3 Medal 148 Commemorating the Marriage of Louis XVIII as Count Louis-Stanislas-Xavier, Count of Provence, and Marie-Josephine-Louise, daughter of King of Sardinia, in 1771 French 7         Artist 2   Ginsburg & Levy, Inc.     Ginsburg & Levy, Inc. 9907       1771 1771 1771 Copper gilt 20614 Diameter: 3 5/8 in. (9.2 cm) Gift of James Hazen Hyde, 1948                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
115647 64.164.134 0 1 204235 European Sculpture and Decorative Arts 3 Crèche figure 8210 Censer Italian, Naples 427                           second half 18th century 1750 1799 Copper gilt 20614 H. 3 9/16 in. (9 cm.); H. (with chains) 15 1/2 in. (39.4 cm.) Gift of Loretta Hines Howard, 1964                       Crèche 361   Metropolitan Museum of Art, New York, NY 1
115669 64.164.156 0 1 204257 European Sculpture and Decorative Arts 3 Crèche figure 8210 Censer Italian, Naples 427                           second half 18th century 1750 1799 Copper gilt 20614 H. 2 1/2 in. (6.4 cm.); H. (with chains) 9 1/4 in. (23.5 cm.) Gift of Loretta Hines Howard, 1964                       Crèche 361   Metropolitan Museum of Art, New York, NY 1
115674 64.164.161 0 1 204262 European Sculpture and Decorative Arts 3 Crèche figure 8210 Censer Italian, Naples 427                           second half 18th century 1750 1799 Copper gilt 20614 H. 2 1/8 in. (5.4 cm.); H. (with chains) 8 1/4 in. (21 cm.) Gift of Loretta Hines Howard, 1964                       Crèche 361   Metropolitan Museum of Art, New York, NY 1
328560 1994.270a, b 0 1 469950 The Cloisters 17 Beaker 58 Covered Beaker German 27         Artist 2 Attributed to the Workshop of Sebastian Lindenast the Elder German, Nuremberg 1460–1526 Nuremberg   Lindenast the Elder, Sebastian 44725 German 10 1460 1526 ca. 1490–1500 1490 1500 Copper gilt 20614 Overall: 9 1/16 x 3 3/4 in. (23 x 9.5 cm) The Cloisters Collection, 1994 Made in 1 Nuremberg 149     Germany 16             Metalwork-Copper 324   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 140.346ms · Data license: CC0 · Data source: metmuseum/openaccess