MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Medium = 12978

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Period, Object Date, Object Begin Date, Object End Date, Credit Line, County, 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
53144 1978.264.9 0 1 61419 Asian Art 7 Mirror 3984   China 51 Han dynasty (206 B.C.–A.D. 220)                         1st century B.C. -99 1 Cast bronze 12978 Diam. 8 7/8 in. (22.5 cm) Bequest of Ann Eden Woodward, (Mrs. William Woodward Jr.), 1975                       Mirrors 206   Metropolitan Museum of Art, New York, NY 1
53145 1978.264.10 0 0 61420 Asian Art 7 Mirror 3984   China 51 Han dynasty (206 B.C.–A.D. 221)                           -206 220 Cast bronze 12978 Diam. 5 15/16 in. (15.1 cm) Bequest of Ann Eden Woodward, (Mrs. William Woodward Jr.), 1975                       Mirrors 206   Metropolitan Museum of Art, New York, NY 1
121101 48.174.105a–p, aa–pp 0 1 210648 European Sculpture and Decorative Arts 3 Chessmen 7963 Chessmen (32) Indian 67                           early 19th century 1800 1815 Cast bronze 12978 Height (each king): 2 1/4 in. (5.7 cm); Height (each pawn): 1 1/8 in. (2.9 cm) Gift of Gustavus A. Pfeiffer, 1948                       Chess Sets 338   Metropolitan Museum of Art, New York, NY 1
140524 2013.254 0 1 239479 European Sculpture and Decorative Arts 3 Medallion 72 Madame Defly (1785–1875) French, Paris 114         Maker 1   Jean-Baptiste Carpeaux French, Valenciennes 1827–1875 Courbevoie   Carpeaux, Jean-Baptiste 8726 French 2 1827 1875 1863 1863 1863 Cast bronze 12978 Diameter: 7 1/4 in. (18.4 cm) Purchase, Stephen K. Scher Gift, 2013                       Sculpture-Bronze 304   Metropolitan Museum of Art, New York, NY 1
140562 2013.1127.1 0 1 239523 European Sculpture and Decorative Arts 3 Medallion 72 Victor Hugo (1802–1885) French 7         Artist 2 Medalist: Jean-Désiré Ringel d'Illzach Alsace 1847–1916 Strasbourg   Ringel d'Illzach Jean-Désiré 8196   1847 1916 1884 1884 1884 Cast bronze 12978 Diameter (confirmed): 6 5/8 in. (16.8 cm) Gift of David and Constance Yates, 2013                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
326119 1980.62 0 1 466066 Medieval Art 6 Armlet 4134 Armlet Celtic 664                           ca. 400 B.C. -405 -395 Cast bronze 12978 Overall: 3 15/16 x 3 1/4 x 1 1/16 in. (10 x 8.3 x 2.7 cm) gr. thickness (of band): 3/8 in. (1 cm) Rogers Fund, 1980 Made in 1     Early La Tène 675               Metalwork-Bronze 325   Metropolitan Museum of Art, New York, NY 1
338283 1991.441.3 0 0 485896 Modern and Contemporary Art 4 Chair 197 "Fourth Frond" Chair           Designer 5   Terence Main American, born Indianapolis, Indiana, 1954   Main, Terence 46098 American 1 1954 2054 1991 1991 1991 Cast bronze 12978 H. 34, W. 19-1/2, D. 21 in. (86.4 x 49.5 x 53.3 cm.) Gift of Loretta Michaelcheck, 1991                       Furniture 4   Metropolitan Museum of Art, New York, NY 1
350224 30.87.2 0 1 505106 Musical Instruments 18 Gheṇṭa (prayer bell) 17258 Gheṇṭa (prayer bell) Javanese 758 Eastern Javanese                         11th century 1000 1099 Cast bronze 12978 Height: 7 in. (17.8 cm) Diameter: 3 1/4 in. (8.3 cm) Weight: 24 oz. (680.5 g) Rogers Fund, 1930       East Java 1027 Indonesia 106             Idiophone-Struck-bell-clapper 950   Metropolitan Museum of Art, New York, NY 1
350226 30.87.4 0 1 505108 Musical Instruments 18 Gheṇṭa (prayer bell) 17258 Gheṇṭa (prayer bell) Javanese 758                           11th century 1000 1099 Cast bronze 12978 Height: 6 1/2 in. (16.5 cm) Diameter: 2 3/4 in. (7 cm) Weight: 15 oz. (425.3 g) Rogers Fund, 1930       East Java 1027 Indonesia 106             Idiophone-Struck-bell-clapper 950   Metropolitan Museum of Art, New York, NY 1
350227 30.87.5 0 1 505109 Musical Instruments 18 Gheṇṭa (prayer bell) 17258 Gheṇṭa (prayer bell) Javanese 758 Eastern Javanese                         11th century 1000 1099 Cast bronze 12978 Height: 6 1/2 in. (16.5 cm) Weight: 8 oz. (226.8 g) Rogers Fund, 1930                       Idiophone-Struck-bell-clapper 950   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 143.331ms · Data license: CC0 · Data source: metmuseum/openaccess