MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Object Name = 10231

View and edit SQL

Suggested facets: Is Public Domain, Title, Culture, Period, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line

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
145311 74.51.5448 0 1 244327 Greek and Roman Art 12 Handle of a hydria 10231 Handle of a hydria Cypriot 3578                           5th–4th century B.C. -499 -300 Bronze 23 Other: 2 5/8in. (6.7cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145315 74.51.5452 0 1 244331 Greek and Roman Art 12 Handle of a hydria 10231 Handle of a hydria Cypriot 3578                           5th–4th century B.C. -499 -300 Bronze 23 Other: 2 5/8in. (6.7cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145326 74.51.5463 0 1 244342 Greek and Roman Art 12 Handle of a hydria 10231 Bronze handle from a hydria (water jar) Greek 777 Hellenistic                         2nd half of 2nd century B.C. -150 -100 Bronze 23 w. 9 7/8 in. (25.1cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
148356 06.1093 0 1 247511 Greek and Roman Art 12 Handle of a hydria 10231 Bronze handle of a hydria (water jar) Greek 777 Archaic                         early 6th century B.C. -599 -575 Bronze 23 Overall: 10 1/2 x 9 13/16in. (26.7 x 25cm) Rogers Fund, 1906                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
148963 09.221.12 0 1 248149 Greek and Roman Art 12 Handle of a hydria 10231 Bronze handle of a hydria (water jar) Greek 777 Classical                         ca. 460–450 B.C. -460 -450 Bronze 23 Other: 8 3/8 in. (21.3 cm) Rogers Fund, 1909                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
155446 56.11.2 0 1 254844 Greek and Roman Art 12 Handle of a hydria 10231 Bronze handle of a hydria (water jar) Greek 777 Archaic                         1st quarter of the 5th century B.C. -499 -475 Bronze 23 Other: 3 7/16 in. (8.7 cm) Purchase, Walter C. Baker Gift, 1956                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
155801 65.165 0 1 255209 Greek and Roman Art 12 Handle of a hydria 10231 Bronze handle Greek 777 Classical                         late 5th century B.C. -450 -400 Bronze 23 H.: 7 3/4 x 4 3/8 x 2 1/2 in. (19.7 x 11.1 x 6.4 cm) Gift of Dietrich von Bothmer, 1965                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
155854 68.11.2 0 1 255263 Greek and Roman Art 12 Handle of a hydria 10231 Bronze handle Greek 777 Classical                         5th century B.C. -499 -400 Bronze 23 Other: 6 9/16 in. (16.7 cm) Rogers Fund, 1968                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
156461 1989.11.1 0 0 255904 Greek and Roman Art 12 Handle of a hydria 10231 Bronze handle of a hydria (water jar) Greek, Laconian 4052 Archaic                         1st quarter of the 6th century B.C. -599 -575 Bronze 23 Overall: 10 1/4 x 8 1/4 in. (26 x 21 cm) The Bothmer Purchase Fund, 1989                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
156718 1993.133 0 1 256168 Greek and Roman Art 12 Handle of a hydria 10231 Vertical handle of a bronze hydria (water jar) Greek 777 Classical                         mid-5th century B.C. -475 -425 Bronze 23 H. 11 1/4 in. (28.5 cm) width from gorgon to gorgon 7 7/16 in. (18.9 cm) Gift of Christos G. Bastis, 1993                       Bronzes 419   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.268ms · Data license: CC0 · Data source: metmuseum/openaccess