MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

35 rows where Classification = 412 and Medium = 160

View and edit SQL

Suggested facets: Object Name, Title, Culture, Period, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line

Classification

  • Vases|Terracottas · 35
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
141486 74.51.904 0 1 240493 Greek and Roman Art 12 Spindle whorl 9202 Conical-hemispherical spindle-whorl with flat base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 7/8 in. (4.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141487 74.51.905 0 1 240494 Greek and Roman Art 12 Spindle whorl 9202 Truncated-biconical spindle-whorl with flat base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 15/16 in. (4.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141488 74.51.906 0 1 240495 Greek and Roman Art 12 Spindle whorl 9202 Conical-hemispherical spindle-whorl Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 11/16 in. (4.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141489 74.51.907 0 1 240496 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl with flat base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 9/16 in. (4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141490 74.51.908 0 1 240497 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl with slightly rounded base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 15/16 in. (4.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141491 74.51.909 0 1 240498 Greek and Roman Art 12 Spindle whorl 9202 Terracotta spindle whorls Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 11/16 in. (4.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141492 74.51.910 0 1 240499 Greek and Roman Art 12 Spindle whorl 9202 Conical spindle-whorl with flat base Cypriot 3578 Middle Cypriot I-II                         ca. 1900–1725 B.C. -1900 -1725 Terracotta 160 H. 1 5/8 in. (4.1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141493 74.51.911 0 1 240500 Greek and Roman Art 12 Spindle whorl 9202 Terracotta truncated-biconical spindle-whorl with angular base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 9/16 in. (4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141494 74.51.912 0 1 240501 Greek and Roman Art 12 Spindle whorl 9202 Spherical spindle-whorl with flat base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 1/2 in. (3.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141495 74.51.913 0 1 240502 Greek and Roman Art 12 Spindle whorl 9202 Terracotta spindle whorl Cypriot 3578 Middle Cypriot                         ca. 1900–1600 B.C. -1900 -1600 Terracotta 160 H. 1 1/2 in. (3.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141496 74.51.914 0 1 240503 Greek and Roman Art 12 Spindle whorl 9202 Terracotta spindle whorl Cypriot 3578 Middle Cypriot I-II                         ca. 1900–1725 B.C. -1900 -1725 Terracotta 160 H. 1 1/4 in. (3.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141497 74.51.915 0 1 240504 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl with flat base and rounded top Cypriot 3578 Middle Cypriot I–II                         ca. 1900–1725 B.C. -1900 -1725 Terracotta 160 H. 1 1/4 in. (3.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141498 74.51.916 0 1 240505 Greek and Roman Art 12 Spindle whorl 9202 Conical-hemispherical spindle-whorl with flat base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 3/8 in. (3.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141499 74.51.917 0 1 240506 Greek and Roman Art 12 Spindle whorl 9202 Spherical spindle-whorl with broad top and base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 1/4 in. (3.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141500 74.51.918 0 1 240507 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl with rounded base Cypriot 3578 Early Cypriot III–Middle Cypriot I                         ca. 2000–1800 B.C. -2000 -1800 Terracotta 160 H. 1 5/16 in. (3.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141501 74.51.919 0 1 240508 Greek and Roman Art 12 Spindle whorl 9202 Spherical spindle-whorl Cypriot 3578 Early Cypriot III–Middle Cypriot I                         ca. 2000–1800 B.C. -2000 -1800 Terracotta 160 H. 1 3/8 in. (3.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141502 74.51.920 0 1 240509 Greek and Roman Art 12 Spindle whorl 9202 Conical-hemispherical spindle-whorl with slightly rounded base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 11/16 in. (4.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141513 74.51.931 0 1 240520 Greek and Roman Art 12 Spindle whorl 9202 Terracotta spindle whorl Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 13/16 in. (4.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141514 74.51.932 0 1 240521 Greek and Roman Art 12 Spindle whorl 9202 Spindle-whorl Cypriot 3578 Late Cypriot ?                         ca. 1600–1050 B.C. -1600 -1050 Terracotta 160 H. 1 1/16 in. (2.7 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141515 74.51.933 0 1 240522 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl with rounded base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 1/2 in. (3.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141516 74.51.934 0 1 240523 Greek and Roman Art 12 Spindle whorl 9202 Spherical spindle-whorl with broad flat top and base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 1/4 in. (3.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141517 74.51.935 0 1 240524 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl with flat base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 1/2 in. (3.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141518 74.51.936 0 1 240525 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl with flat base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 5/8 in. (4.1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141519 74.51.937 0 1 240526 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl with flat base Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 5/16 in. (3.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141520 74.51.938 0 1 240527 Greek and Roman Art 12 Spindle whorl 9202 Terracotta conical-hemispherical spindle-whorl Cypriot 3578 Early Cypriot III–Middle Cypriot II                         ca. 2000–1725 B.C. -2000 -1725 Terracotta 160 H. 1 1/2 in. (3.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141521 74.51.939 0 1 240528 Greek and Roman Art 12 Spindle whorl 9202 Terracotta biconical spindle-whorl Cypriot 3578 Middle Cypriot                         ca. 1900–1600 B.C. -1900 -1600 Terracotta 160 H. 1 5/16 in. (3.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141522 74.51.940 0 1 240529 Greek and Roman Art 12 Spindle whorl 9202 Terracotta biconical spindle-whorl with flat top Cypriot 3578 Early Cypriot I                         ca. 2500–2075 B.C. -2500 -2075 Terracotta 160 H. 1 7/8 in. (4.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141523 74.51.941 0 1 240530 Greek and Roman Art 12 Spindle whorl 9202 Terracotta biconical spindle-whorl Cypriot 3578 Possibly Late Cypriot I–II                         ca. 1600–1200 B.C. -1600 -1200 Terracotta 160 H. 1 5/8 in. (4.1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141524 74.51.942 0 1 240531 Greek and Roman Art 12 Spindle whorl 9202 Terracotta biconical spindle-whorl Cypriot 3578 Possibly Late Cypriot I–II                         ca. 1600–1200 B.C. -1600 -1200 Terracotta 160 H. 1 3/16 in. (3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
141525 74.51.943 0 1 240532 Greek and Roman Art 12 Spindle whorl 9202 Small terracotta biconical spindle-whorl Cypriot 3578 Late Cypriot ?                         ca. 1600–1050 B.C. -1600 -1050 Terracotta 160 H. 7/8 in. (2.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
150990 17.194.1755 0 1 250229 Greek and Roman Art 12 Lamp, saucer-shaped 9487 Lamp, saucer-shaped Roman 736 Imperial                         ca. A.D. 1–300 1 300 Terracotta 160 1 3/8 × 3 1/8 × 3 1/4 in. (3.5 × 8 × 8.2 cm) Gift of J. Pierpont Morgan, 1917                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
151214 17.194.2115 0 1 250456 Greek and Roman Art 12 Lamp handle 11492 Terracotta lamp handle Roman 736 Imperial                         2nd century A.D. 100 199 Terracotta 160 L. 2 5/8 in. (6.7 cm.) Gift of J. Pierpont Morgan, 1917                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
151739 20.263.5 0 1 251014 Greek and Roman Art 12 Lamp, miniature 11677 Lamp, miniature Greek 777                             -7000 -30 Terracotta 160 Other: 1 1/4in. (3.1cm) Gift of G.M.A. Richter, 1920                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
154201 38.20 0 1 253568 Greek and Roman Art 12 Lamp 558 Terracotta lamp Greek, Attic 4006 Classical                         5th century B.C. -499 -400 Terracotta 160 length with spout 4 5/16in. (10.9cm) Gift of Gisela M. A. Richter, 1938                       Vases|Terracottas 412   Metropolitan Museum of Art, New York, NY 1
156101 1973.174 0 1 255515 Greek and Roman Art 12 Lamp 558 Lamp Greek, Attic 4006 Late Archaic–Early Classical                         ca. 500–460 B.C. -500 -460 Terracotta 160 Overall: 15/16 in. (2.4 cm) Other: 3 5/8 in. (9.2 cm) Diameter: 2 15/16 in. (7.5 cm) Gift of Heidi Vollmoeller, 1973                       Vases|Terracottas 412   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 2112.671ms · Data license: CC0 · Data source: metmuseum/openaccess