MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

18 rows where Department = 12 and Medium = 5548

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

Department

  • Greek and Roman Art · 18
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
142842 74.51.2298a, b 0 1 241852 Greek and Roman Art 12 Amphora with Phoenician inscription 9509 Terracotta amphora with Phoenician inscription Cypriot 3578 Cypro-Archaic I                         2nd half of 7th century B.C. -650 -600 Clay 5548 H.: 18 15/16 in. (48.1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142843 74.51.2299 0 1 241853 Greek and Roman Art 12 Amphora with Phoenician inscription 9509 Terracotta amphora with Phoenician inscription Cypriot 3578 Classical                         4th century B.C. -399 -300 Clay 5548 Height: 28 x 9 1/2 in. (71.1 x 24.1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142844 74.51.2300 0 1 241854 Greek and Roman Art 12 Amphora with Phoenician inscription 9509 Terracotta amphora with Phoenician inscription Cypriot 3578                           6th–5th century B.C. -599 -400 Clay 5548 H.: 22 3/4 in. (57.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142898 74.51.2354 0 1 241908 Greek and Roman Art 12 Vase fragment 9542 Terracotta vase fragment Cypriot 3578                             -3900 100 Clay 5548 H.: 4 1/2 x 7 x 1/4 in. (11.4 x 17.8 x 0.6 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
142918 74.51.2374 0 0 241928 Greek and Roman Art 12 Tile 101 Terracotta pan tile Roman, Cypriot 3987 Imperial                         ca. 2nd–3rd century A.D. 100 299 Clay 5548 Other: 13 3/8 x 1 x 27 1/2 in. (34 x 2.5 x 69.9 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Cesnola Inscriptions 413   Metropolitan Museum of Art, New York, NY 1
144802 74.51.4544 0 1 243812 Greek and Roman Art 12 Plaque, unglazed 10130 Terracotta foil mold of the son of Horus Egyptian 797 Third Intermediate–Late Dynastic                           -1069 -664 Clay 5548 Other: 2 7/16 x 1 x 3/8 in. (6.2 x 2.5 x 1 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Gold and Silver 408   Metropolitan Museum of Art, New York, NY 1
147451 96.9.526 0 1 246521 Greek and Roman Art 12 Clay object 10638 Clay object                               -7000 330 Clay 5548 3/4 × 1 in. (1.9 × 2.6 cm) Purchase, 1896                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
147452 96.9.527 0 1 246522 Greek and Roman Art 12 Spindle whorl, reel 10639 Spindle whorl, reel                               -7000 330 Clay 5548 2 3/16 × 1 7/16 in. (5.6 × 3.6 cm) Purchase, 1896                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
147453 96.9.528 0 1 246523 Greek and Roman Art 12 Clay object 10638 Clay object                               -7000 330 Clay 5548 6 9/16 in. (16.7 cm) Purchase, 1896                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
147454 96.9.529 0 1 246524 Greek and Roman Art 12 Roundel, disk 9934 Roundel, disk                               -7000 330 Clay 5548 3/4 × 1 1/2 in. (1.9 × 3.8 cm) Purchase, 1896                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
147455 96.9.530 0 1 246525 Greek and Roman Art 12 Spindle whorl, reel 10639 Spindle whorl, reel                               -7000 330 Clay 5548 Other: 1 13/16 × 1 1/16 in. (4.6 × 2.6 cm) Purchase, 1896                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
147456 96.9.531 0 1 246526 Greek and Roman Art 12 Spindle whorl, reel 10639 Spindle whorl, reel                               -7000 330 Clay 5548 Other: 1 11/16 × 1 1/16 in. (4.3 × 2.6 cm) Purchase, 1896                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
151886 22.20.1 0 1 251167 Greek and Roman Art 12 Ball, sling 11721 Ball, sling Carthaginian 4140 Punic                         ca. 1st half of 2nd century BC -200 -146 Clay 5548 1 7/16 × 1 7/8 × 1 1/8 in. (3.6 × 4.7 × 2.8 cm) Gift of Homer E. McKittrick, 1922                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
151887 22.20.2 0 1 251168 Greek and Roman Art 12 Ball, sling 11721 Ball, sling Carthaginian 4140 Punic                         ca. 1st half of 2nd century BC -200 -146 Clay 5548 1 7/16 × 1 13/16 × 1 in. (3.6 × 4.5 × 2.5 cm) Gift of Homer E. McKittrick, 1922                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
153005 26.31.409 0 1 252335 Greek and Roman Art 12 Sealing, three-sided 11977 Clay Sealing Minoan 4162 Late Minoan I                         ca. 1600–1450 B.C. -1600 -1450 Clay 5548 Other: 3/4 x 1 5/16 in. (1.9 x 3.4 cm) Bequest of Richard B. Seager, 1926                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
153006 26.31.410 0 1 252336 Greek and Roman Art 12 Shell 5274 Terracotta shell Minoan 4162 Middle or Late Bronze Age                         ca. 2200–1050 B.C. -2200 -1050 Clay 5548 L. 1 1/4 in. (3.3 cm) Bequest of Richard B. Seager, 1926                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
153007 26.31.411 0 1 252337 Greek and Roman Art 12 Shell 5274 Terracotta shell Minoan 4162 Middle or Late Bronze Age                         ca. 2200–1050 B.C. -2200 -1050 Clay 5548 L. 7/8 in. (2.2 cm) Bequest of Richard B. Seager, 1926                       Miscellaneous-Clay 431   Metropolitan Museum of Art, New York, NY 1
157555 07.147.5, .6 0 0 257554 Greek and Roman Art 12 Tablets 4872 Tablets                               -7000 330 Clay 5548 .5: 5 5/16 × 1 13/16 × 3/8 in. (13.5 × 4.7 × 1 cm) .6: 2 9/16 × 1 7/8 × 3/8 in. (6.4 × 4.8 × 0.9 cm) Rogers Fund, 1907                       Miscellaneous-Clay 431   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 236.192ms · Data license: CC0 · Data source: metmuseum/openaccess