MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

40 rows where Department = 12 and Medium = 13

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
144853 74.51.4606 0 1 243866 Greek and Roman Art 12 Arrowhead 2414 Arrowhead                               -7000 330 Iron 13 Width 8.26 cm. The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
144854 74.51.4608 0 1 243867 Greek and Roman Art 12 Arrowhead 2414 Arrowhead                               -7000 330 Iron 13 Width 6.65 cm. The Cesnola Collection, Purchased by subscription, 1874–76                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
145177 74.51.5313 0 1 244192 Greek and Roman Art 12 Spearhead 1690 Spearhead Cypriot 3578 Early Iron Age                         ca. 1050–1000 B.C. -1050 -1000 Iron 13 11 1/16in. (28.1cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145178 74.51.5314 0 1 244193 Greek and Roman Art 12 Spearhead 1690 Spearhead Cypriot 3578 Early Iron Age                         ca. 1050–1000 B.C. -1050 -1000 Iron 13 9 9/16in. (24.3cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145179 74.51.5315 0 1 244194 Greek and Roman Art 12 Spearhead 1690 Spearhead Cypriot 3578 Late Iron Age                         ca. 1000–900 B.C. -1000 -900 Iron 13 8 3/8in. (21.3cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145180 74.51.5316 0 1 244195 Greek and Roman Art 12 Spearhead 1690 Spearhead Cypriot 3578 Early Iron Age                         ca. 1050–1000 B.C. -1050 -1000 Iron 13 7 3/8in. (18.8cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145181 74.51.5317 0 1 244196 Greek and Roman Art 12 Spearhead 1690 Spearhead Cypriot 3578 Early Iron Age                         ca. 1050–1000 B.C. -1050 -1000 Iron 13 5 9/16in. (14.1cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145217 74.51.5353 0 1 244232 Greek and Roman Art 12 Knife 141 Knife Cypriot 3578                             -3900 100 Iron 13 Other: 8 1/16in. (20.5cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145219 74.51.5355 0 1 244234 Greek and Roman Art 12 Knife 141 Knife                               -7000 330 Iron 13 Other: 6 5/8in. (16.8cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145247 74.51.5383 0 1 244262 Greek and Roman Art 12 Spearhead 1690 Spearhead                               -7000 330 Iron 13 Other: 11in. (27.9cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145264 74.51.5400 0 1 244279 Greek and Roman Art 12 Axehead 10223 Axehead Cypriot 3578 Early Bronze Age                         ca. 3200–2000 B.C. -3200 -2000 Iron 13 Other: 6 1/8in. (15.5cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145328 74.51.5465 0 1 244344 Greek and Roman Art 12 Strigil 10233 Strigil Roman, Cypriot 3987                             50 400 Iron 13 Other: 9 3/4in. (24.8cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145330 74.51.5467 0 1 244346 Greek and Roman Art 12 Strigil 10233 Strigil Cypriot 3578                             -3900 100 Iron 13 Other: 9 1/4in. (23.5cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145497 74.51.5635 0 0 244514 Greek and Roman Art 12 Lampstand 10269 Lampstand Cypriot 3578                             -3900 100 Iron 13 6in. (15.2cm) Other (height of fragment): 9 1/8in. (23.2cm) Other (height of vase): 6in. (15.2cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145546 74.51.5686 0 1 244564 Greek and Roman Art 12 Spearhead or arrowhead 10286 Spearhead or arrowhead                               -7000 330 Iron 13 Other: 3 1/16 in. (7.8 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
145548 74.51.5688 0 1 244566 Greek and Roman Art 12 Axehead 10223 Axehead                               -7000 330 Iron 13 Other: 5 in. (12.7 cm) The Cesnola Collection, Purchased by subscription, 1874–76                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
147374 96.9.445 0 0 246442 Greek and Roman Art 12 Handle of a chariot, fragment 10625 Handle of a chariot, fragment Etruscan 4056 Archaic or later                         6th century B.C. or later -600 -100 Iron 13 Other: 5 11/16 in. (14.4 cm) Purchase, 1896                       Bronzes 419   Metropolitan Museum of Art, New York, NY 1
147377 96.9.449 0 0 246445 Greek and Roman Art 12 Strigil 10233 Strigil                               -7000 330 Iron 13 Storage: 5 × 3 in. (12.7 × 7.6 cm) Purchase, 1896                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147874 03.23.41–.44 0 1 247019 Greek and Roman Art 12 Spearheads 10795 Four iron spearheads Etruscan 4056 Archaic                         ca. 550 B.C. -550 -550 Iron 13 H. (.41): 18 7/8 in. (47.9 cm) H. (.42): 18 13/16 in. (47.8 cm) H. (.43): 19 7/8 in. (50.5 cm) H. (.44): 8 7/8 in. (22.5 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147913 03.23.38 0 1 247058 Greek and Roman Art 12 Fire dogs 10805 Iron fire-dog Etruscan 4056 Archaic                         ca. 550 B.C. -550 -550 Iron 13 length 39 1/4in. (99.7cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147914 03.23.39 0 1 247059 Greek and Roman Art 12 Fire dogs 10805 Iron fire-dog Etruscan 4056 Archaic                         ca. 550 B.C. -550 -550 Iron 13 length 37 7/8 in. (96.2 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147915 03.23.40 0 1 247060 Greek and Roman Art 12 Fire grate 423 Iron fire-grate Etruscan 4056 Archaic                         ca. 550 B.C. -550 -550 Iron 13 H. 3 1/4 in (8.3 cm) width 11 3/4 in (29.9 cm) length 14 5/16 in. (36.4 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147919 03.23.51 0 1 247065 Greek and Roman Art 12 Horse bit 10220 Iron horse bit Etruscan 4056 Archaic                         ca. 550 B.C. -550 -550 Iron 13 Other: 6 3/16 in. (15.7 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147920 03.23.52 0 1 247066 Greek and Roman Art 12 Horse bit 10220 Horse bit Etruscan 4056 Archaic                         ca. 550 B.C. -555 -545 Iron 13 Other: 7 1/2 in. (19.1 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147921 03.23.53 0 1 247067 Greek and Roman Art 12 Tripod 3986 Iron tripod Etruscan 4056 Archaic                         ca. 575–550 B.C. -550 -550 Iron 13 H.: 22 5/16 in. (56.7 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147923 03.23.55 0 1 247069 Greek and Roman Art 12 Spit 10804 Iron spit Etruscan 4056 Archaic                         ca. 550 B.C. -550 -550 Iron 13 Other: 29 3/4 in. (75.6 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147924 03.24.11, .12 0 1 247070 Greek and Roman Art 12 Fire-rake fragments 10809 Three fragmentary iron fire-rakes Etruscan 4056 Late Classical or Hellenistic                         late 4th or early 3rd century B.C. -330 -270 Iron 13 H. (.11): 12 in. (30.5 cm) H. (.12): 7 7/16 in. (18.9 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147935 03.24.10 0 1 247081 Greek and Roman Art 12 Thymiaterion 10181 Iron candelabrum Etruscan 4056 Hellenistic                         early 3rd century B.C. -299 -270 Iron 13 H.: 13 1/2 in. (34.3 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147936 03.24.13 0 1 247082 Greek and Roman Art 12 Knife blade 2870 Knife blade Etruscan 4056 Late Classical or Hellenistic                         late 4th or early 3rd century B.C. -330 -270 Iron 13 Other: 8 1/16 in. (20.5 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147937 03.24.14 0 1 247083 Greek and Roman Art 12 Spit 10804 Iron spit Etruscan 4056 Late Classical or Hellenistic                         late 4th or early 3rd century B.C. -330 -270 Iron 13 Other: 23 3/8 in. (59.4 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147938 03.24.15 0 1 247084 Greek and Roman Art 12 Fire-tongs 10816 Iron fire-tongs Etruscan 4056 Late Classical or Hellenistic                         late 4th or early 3rd century B.C. -330 -270 Iron 13 Other: 21 5/8 in. (54.9 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147939 03.24.16 0 1 247085 Greek and Roman Art 12 Fire, andiron 10817 Iron andiron Etruscan 4056 Late Classical or Hellenistic                         late 4th or early 3rd century B.C. -330 -270 Iron 13 Other: 14 1/16 in. (35.7 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147940 03.24.17 0 0 247086 Greek and Roman Art 12 Fire, andiron 10817 Iron andiron Etruscan 4056 Late Classical or Hellenistic                         late 4th or early 3rd century B.C. -330 -270 Iron 13 Other: 15 3/4 in. (40 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147941 03.24.18 0 0 247087 Greek and Roman Art 12 Fire, andiron 10817 Iron andiron Etruscan 4056 Late Classical or Hellenistic                         late 4th or early 3rd century B.C. -330 -270 Iron 13 Other: 14 15/16 in. (37.9 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147942 03.24.19 0 0 247088 Greek and Roman Art 12 Fire, andiron 10817 Iron andiron Etruscan 4056 Late Classical or Hellenistic                         late 4th or early 3rd century B.C. -330 -270 Iron 13 Other: 20 1/16 in. (51 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
147943 03.24.20 0 1 247089 Greek and Roman Art 12 Candelabrum 160 Bronze candelabrum Etruscan 4056 Hellenistic                         early 3rd century B.C. -299 -270 Iron 13 H. 42 in. (106.7 cm) Rogers Fund, 1903                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
152459 24.195.184 0 1 251750 Greek and Roman Art 12 Bar 4554 Iron bar Greek, Laconian 4052 Archaic ?                         7th–5th century B.C. ? -699 -400 Iron 13 15/16 × 3 11/16 × 3/4 in. (2.4 × 9.3 × 2 cm) Gift of A. J. B. Wace, 1924                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
153515 26.199.290 0 1 252853 Greek and Roman Art 12 Arrowhead ? with tang 12075 Arrowhead ? with tang                               -7000 330 Iron 13 Other: 7/8 x 3 7/16 x 5/16 in. (2.2 x 8.7 x 0.8 cm) Gift of The American Society for the Excavation of Sardis, 1926                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
157563 2001.346 0 1 257576 Greek and Roman Art 12 Sword, machaira 12921 Iron machaira (sword) Greek 777 Classical                         5th–4th century B.C. -499 -300 Iron 13 22 1/4 in., 1.5 lb. (56.5 cm, 0.7 kg) Rogers Fund, 2001                       Miscellaneous-Iron 422   Metropolitan Museum of Art, New York, NY 1
157568 2001.543 0 1 257585 Greek and Roman Art 12 Sword, machaira 12921 Iron machaira (sword) Greek 777 Classical                         5th–4th century B.C. -499 -300 Iron 13 21 1/2 in., 1.5 lb. (54.6 cm, 0.7 kg) Gift of Andrés A. Mata, in honor of Carlos A. Picon, 2001                       Miscellaneous-Iron 422   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 653.192ms · Data license: CC0 · Data source: metmuseum/openaccess