MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

30 rows where Department = 12 and Medium = 25713

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Period, 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
144865 74.51.5000 0 1 243879 Greek and Roman Art 12 Spindle whorl 9202 Chlorite spindle whorl Cypriot 3578 Late Cypriot III                         ca. 1200–1050 B.C. -1200 -1050 Chlorite 25713 Diam. 1 in. (2.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144866 74.51.5001 0 1 243880 Greek and Roman Art 12 Spindle whorl 9202 Chlorite spindle whorl Cypriot 3578 Late Cypriot III                         ca. 1200–1050 B.C. -1200 -1050 Chlorite 25713 H. 1/2 x 1 1/4 x 1 1/4 in. (1.3 x 3.2 x 3.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144868 74.51.5003 0 1 243882 Greek and Roman Art 12 Spindle whorl 9202 Chlorite spindle whorl Cypriot 3578 Late Cypriot III                         ca. 1200–1050 B.C. -1200 -1050 Chlorite 25713 H. 3/4 x 1 2/4 x 1 2/4 in. (1.9 x 3.8 x 3.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144869 74.51.5004 0 1 243883 Greek and Roman Art 12 Spindle whorl 9202 Chlorite spindle whorl Cypriot 3578 Late Cypriot III                         ca. 1200–1050 B.C. -1200 -1050 Chlorite 25713 Diam. 1 3/8 in. (3.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144871 74.51.5006 0 1 243885 Greek and Roman Art 12 Spindle whorl 9202 Chlorite spindle whorl Cypriot 3578 Late Cypriot III                         ca. 1200–1050 B.C. -1200 -1050 Chlorite 25713 H. 2/4 x 1 3/4 x 1 3/4 in. (1.3 x 4.4 x 4.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144872 74.51.5007 0 1 243886 Greek and Roman Art 12 Spindle whorl 9202 Chlorite spindle whorl Cypriot 3578 Late Cypriot III                         ca. 1200–1050 B.C. -1200 -1050 Chlorite 25713 H.: 3/4 in. (1.9 cm); Diam.: 1 1/2 in. (3.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144873 74.51.5008 0 1 243887 Greek and Roman Art 12 Box lid 3982 Chlorite box lid Cypriot 3578 Late Cypriot III                         ca. 1200–1050 B.C. -1200 -1050 Chlorite 25713 H. 3/8 in. (1 cm); Diam. 2 1/8 in. (5.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144874 74.51.5009 0 1 243888 Greek and Roman Art 12 Necklace with 36 biconical beads 10156 Chlorite necklace with 36 biconical beads Cypriot 3578 Late Bronze or Early Iron Age                         ca. 1600–600 B.C. -1600 -600 Chlorite 25713 Approximate length of whole 26 1/2 in. (67.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144875 74.51.5010 0 1 243889 Greek and Roman Art 12 Pendant in the form of a negro's head 10011 Chlorite pendant in the form of the head of an African (known as Ethiopian) Cypriot 3578 Iron Age                         9th–8th century B.C. -899 -700 Chlorite 25713 Overall: 3/16 x 1 x 3/4 in. (0.5 x 2.5 x 1.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144888 74.51.5023a 0 1 243902 Greek and Roman Art 12 Amphoriskos 9200 Chlorite amphoriskos (small jar) Cypriot 3578 Late Cypriot IIIA                         ca. 1200–1100 B.C. -1200 -1100 Chlorite 25713 Overall: 2 5/8 x 2 1/2 in. (6.7 x 6.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144889 74.51.5023b 0 1 243903 Greek and Roman Art 12 Lid of a vase 10160 Chlorite lid of a vase Cypriot 3578 Late Cypriot IIIA                         ca. 1200–1100 B.C. -1200 -1100 Chlorite 25713 Other: 1 7/8in. (4.7cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144890 74.51.5024 0 1 243904 Greek and Roman Art 12 Stemmed bowl 10161 Miniature chlorite stemmed bowl Cypriot 3578 Late Bronze Age                         ca. 1600–1200 B.C. -1600 -1200 Chlorite 25713 H.: 2 1/8 in. (5.4 cm) Diam.: 2 1/4 in. (5.7 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144891 74.51.5025 0 1 243905 Greek and Roman Art 12 Bathtub, miniature 10162 Chlorite miniature bathtub Cypriot 3578 Late Bronze Age                         12th or 11th century B.C. -1199 -1000 Chlorite 25713 Overall: 1 3/4 x 3 3/4 x 2 1/4 in. (4.4 x 9.5 x 5.7 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144892 74.51.5026 0 1 243906 Greek and Roman Art 12 Bowl, miniature 9243 Miniature chlorite bowl Cypriot 3578 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Chlorite 25713 H.: 3/4in. (1.9cm) Diam.: 2 1/8 in. (5.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144900 74.51.5034 0 1 243914 Greek and Roman Art 12 Pestle 4469 Chlorite pestle Cypriot 3578 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Chlorite 25713 H. 3 1/16 in. (7.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144901 74.51.5035 0 1 243915 Greek and Roman Art 12 Pestle 4469 Chlorite pestle Cypriot 3578 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Chlorite 25713 H. 2 11/16 in. (6.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144903 74.51.5037 0 1 243917 Greek and Roman Art 12 Pestle 4469 Chlorite pestle Cypriot 3578 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Chlorite 25713 H. 2 7/16 in. (6.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144904 74.51.5038 0 1 243918 Greek and Roman Art 12 Pestle 4469 Chlorite pestle Cypriot 3578 Late Bronze Age                         ca. 1600–1100 B.C. -1600 -1100 Chlorite 25713 H. 2 1/8 in. (5.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144905 74.51.5039 0 1 243919 Greek and Roman Art 12 Pestle 4469 Chlorite pestle Cypriot 3578 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Chlorite 25713 H. 2 3/8 x 1 1/2 in. (6 x 3.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone 420   Metropolitan Museum of Art, New York, NY 1
144908 74.51.5042 0 1 243922 Greek and Roman Art 12 Plate or palette 10164 Chlorite mortar or plate Cypriot 3578 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Chlorite 25713 Overall: H. 1 1/16 x D. 6 3/8 in. (2.7 x 16.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144909 74.51.5043 0 1 243923 Greek and Roman Art 12 Plate or palette 10164 Chlorite mortar or plate Cypriot 3578 Late Bronze Age                         ca. 1200–1050 B.C. -1200 -1050 Chlorite 25713 Diam. 6 1/8 in. (15.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144916 74.51.5050 0 1 243930 Greek and Roman Art 12 Jar, miniature 9276 Chlorite miniature jar Cypriot 3578 Late Bronze Age                         ca. 1600–1050 B.C. -1600 -1050 Chlorite 25713 Overall: 4 3/4 x 4 1/8 in. (12.1 x 10.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144917 74.51.5051 0 1 243931 Greek and Roman Art 12 Bowl, shallow 10166 Chlorite mortar Cypriot 3578 Late Bronze Age or Geometric                         ca. 1600–700 B.C. -1600 -700 Chlorite 25713 Overall: H.:2 1/2 x W.:5 1/4 in. (6.4 x 13.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144919 74.51.5053 0 1 243933 Greek and Roman Art 12 Bowl, shallow 10166 Chlorite mortar Cypriot 3578 Late Bronze Age or Geometric                         ca.1600–700 B.C. -1600 -700 Chlorite 25713 H. 1 1/2 in. (3.8 cm); Diam. 4 1/16 in. (10.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144921 74.51.5055 0 1 243935 Greek and Roman Art 12 Tripod 3986 Chlorite tripod Cypriot 3578 Late Cypriot II–III                         ca. 1450–1050 B.C. -1450 -1050 Chlorite 25713 H. 2 5/8 in. (6.7 cm); Diam. 4 3/4 in. (12.1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144922 74.51.5056 0 1 243936 Greek and Roman Art 12 Mortar, three-legged 10165 Chlorite mortar Cypriot 3578 Late Bronze Age or Geometric                         ca.1600–700 B.C. -1600 -700 Chlorite 25713 H. 3 in. (7.6 cm); Diam. 5 5/8 in. (14.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
144924 74.51.5057a 0 1 243938 Greek and Roman Art 12 Amphoriskos 9200 Chlorite amphoriskos (small jar) Cypriot 3578 Late Bronze Age                         early 12th century B.C. -1199 -1150 Chlorite 25713 H. 5 3/16 in. (13.1 cm); Diam. 2 in. (5.1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
152261 24.150.3 0 0 251551 Greek and Roman Art 12 Bowl with spout and flanges 11845 Chlorite spouted bowl with flanges Minoan 4162 Early Minoan II                         ca. 2600–2200 B.C. -2999 -2000 Chlorite 25713 H.: 2 in. (5.1 cm) Funds from various donors, 1924                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
152263 24.150.5 0 0 251553 Greek and Roman Art 12 Cup, spouted 11262 Chlorite spouted carinated cup Minoan 4162 Middle Minoan I                         ca. 2000–1800 B.C. -2000 -1800 Chlorite 25713 H. 2 in. (5.1 cm) Funds from various donors, 1924                       Miscellaneous-Stone Vases 423   Metropolitan Museum of Art, New York, NY 1
155330 53.5.1 0 1 254726 Greek and Roman Art 12 Bowl 106 Chlorite bowl Minoan 4162 Middle Minoan I                         ca. 2200–1900 B.C. -2200 -1900 Chlorite 25713 H. 1 5/8 in. (4.2 cm.) Diameter 3 3/4 in. (9.6 cm.) Gift of the Archaeological Institute of America, 1953                       Miscellaneous-Stone Vases 423   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 157.055ms · Data license: CC0 · Data source: metmuseum/openaccess