MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Classification = 413 and Medium = 160

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Period, Object Date, Object Begin Date, Object End Date

Classification

  • Cesnola Inscriptions · 15
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
142897 74.51.2353 0 1 241907 Greek and Roman Art 12 Disk, inscribed 9541 Terracotta disk Cypriot 3578                             -3900 100 Terracotta 160 Diam.: 1 3/4 x 1/4 in. (4.4 x 0.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142907 74.51.2363 0 1 241917 Greek and Roman Art 12 Statuette of a votary, female 9363 Terracotta female figurine fragment Cypriot 3578 Cypro-Archaic II                         ca. 600–480 B.C. -600 -480 Terracotta 160 H. 3 1/8 in. (8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142908 74.51.2364 0 1 241918 Greek and Roman Art 12 Lamp 558 Terracotta lamp representing Bes Cypriot 3578 Cypro-Archaic II                         end of 6th century B.C. -550 -500 Terracotta 160 H. 9 3/8 in. (23.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142961 74.51.2417 0 0 241971 Greek and Roman Art 12 Handle of an amphora, stamped 9580 Terracotta stamped handle of an amphora Greek, Rhodian 3998 Hellenistic                           -7000 -30 Terracotta 160 H.: 3 1/8 in. (7.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142962 74.51.2418 0 1 241972 Greek and Roman Art 12 Handle of an amphora, stamped 9580 Terracotta amphora handle with stamp Greek, Rhodian 3998 Hellenistic                         2nd half of 2nd century B.C. -150 -100 Terracotta 160 Other: 4 7/16 in. (11.3 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142963 74.51.2419 0 1 241973 Greek and Roman Art 12 Handle of an amphora, stamped 9580 Terracotta amphora handle with stamp Greek, Rhodian 3998 Hellenistic                         ca. 220–180 B.C. -220 -180 Terracotta 160 Other: 4 7/8 in. (12.4 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142964 74.51.2420 0 1 241974 Greek and Roman Art 12 Handle of an amphora, stamped 9580 Terracotta amphora fragment with stamped handle Greek, Rhodian 3998 Hellenistic                         ca. 180 B.C. -199 -160 Terracotta 160 Other: 5 1/8 in. (13 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142966 74.51.2422 0 1 241976 Greek and Roman Art 12 Handle of an amphora, stamped 9580 Terracotta amphora handle with stamp Greek, Rhodian 3998 Hellenistic                         ca. 220–180 B.C. -220 -180 Terracotta 160 Other: 4 in. (10.2 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142967 74.51.2423 0 0 241977 Greek and Roman Art 12 Handle of an amphora, stamped 9580 Terracotta stamped handle of an amphora Greek, Rhodian 3998 Hellenistic                           -7000 -30 Terracotta 160 H.: 4 1/8 in. (10.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142968 74.51.2424 0 1 241978 Greek and Roman Art 12 Handle of an amphora, stamped 9580 Terracotta stamped amphora handle Greek, Rhodian 3998 Hellenistic                         ca. 220–180 B.C. -220 -180 Terracotta 160 Other: 4 5/16 in. (11 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142970 74.51.2426 0 1 241980 Greek and Roman Art 12 Mortarium rim fragment, stamped 9582 Terracotta mortarium fragment Roman, North Syrian 4030 Late Imperial                         late 3rd–4th century A.D. 275 399 Terracotta 160 Overall: 5 1/8 x 2 3/4 in. (13 x 7 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142972 74.51.2428 0 1 241982 Greek and Roman Art 12 Mortarium rim fragment, stamped 9582 Terracotta stamped mortarium fragment Roman, North Syrian 4030 Late Imperial                         late 3rd–4th century A.D. 275 399 Terracotta 160 Other: 2 5/8 x 2 3/4 x 1 13/16 in. (6.7 x 7 x 4.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142974 74.51.2430 0 1 241984 Greek and Roman Art 12 Statue base, inscribed 9523 Terracotta figurine fragment with base Cypriot ? 4027                             -3900 100 Terracotta 160 H.: 3 1/4 x 2 1/4 x 1 3/8 in. (8.3 x 5.7 x 3.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142978 74.51.2434 0 1 241988 Greek and Roman Art 12 Amphora, inscribed 9586 Terracotta amphora Roman, Cypriot (?) 4031 Late Imperial                         ca. 3rd century A.D. 200 299 Terracotta 160 Diam.: 14 1/2 in. (36.8 cm) H.: 26 in. (66 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142983 74.51.2439 0 0 241993 Greek and Roman Art 12 Mortarium rim fragment, stamped 9582 Stamped terracotta mortarium fragment Roman, North Syrian 4030 Late Imperial                         late 3rd–4th century A.D. 275 399 Terracotta 160 Other: 2 1/4 x 2 3/8 x 1 3/8 in. (5.7 x 6 x 3.5 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   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 2007.04ms · Data license: CC0 · Data source: metmuseum/openaccess