MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 3615

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, 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 Metadata Date Repository
17649 17649 13.112.9 0 1 22157 Arms and Armor 5 Helmet 1349 Helmet Japanese 35                           17th century 1601 1700 Iron, lacquer, silk 3615 H. 12 3/8 in. (30.1 cm); W. 12 5/8 in. (31.1 cm); Wt. 5 lb. 3 oz. (2421 g) Rogers Fund, 1913                       Helmets 37   http://www.metmuseum.org/art/collection/search/22157 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17933 17933 14.100.1a–e 0 1 22444 Arms and Armor 5 Armor fragments (scales and cords) 1558 Armor Fragments (Scales and Cords) Japanese 35                           11th Century 1000 1099 Iron, lacquer, silk 3615 14.100.1a: L. 3 in. (7.62 cm); 14.100.1b: L. 2 7/8 in. (7.29 cm); 14.100.1c: L. 2 in. (5.08 cm); 14.100.1d: L. 1 1/2 in. (3.81 cm); 14.100.1e: L. 1 7/8 in. (4.75 cm) Gift of Bashford Dean, 1914                       Armor Parts 47   http://www.metmuseum.org/art/collection/search/22444 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18061 18061 14.100.412 0 0 22576 Arms and Armor 5 Helmet (kabuto) 1375 Helmet (Kabuto) Japanese 35                           18th century 1700 1799 Iron, lacquer, silk 3615 H. 10 1/2 in. (26.7 cm); W. 13 1/2 in. (34.3 cm) Gift of Bashford Dean, 1914                       Helmets 37   http://www.metmuseum.org/art/collection/search/22576 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19550 19550 36.25.181 0 0 24074 Arms and Armor 5 Folding helmet 2032 Folding Helmet Japanese 35                           ca. 1615–1868 1590 1900 Iron, lacquer, silk 3615   Bequest of George C. Stone, 1935                       Helmets 37   http://www.metmuseum.org/art/collection/search/24074 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
21192 21192 04.5.2 0 0 25808 Arms and Armor 5 Fragment of a shoulder guard (Sode) 2435 Fragment of a Shoulder Guard (Sode) Japanese 35                           11th century 1001 1100 Iron, lacquer, silk 3615 2 1/2 x 2 5/8 in. (6.35 x 6.7 cm) Gift of Bashford Dean, 1904                       Armor Parts-Arms & Shoulders 36   http://www.metmuseum.org/art/collection/search/25808 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
21202 21202 13.112.1a–s 0 0 25821 Arms and Armor 5 Armor (Gusoku) 1373 Armor (Gusoku) Japanese 35         Armorer 98 Signed on the shoulder guards by Miochin Oye Ki Muneyasu Japanese, Tosa, active 17th century   Miochin Oye Ki Muneyasu 2975 Japanese 74 1601 1700 17th century 1601 1700 Iron, lacquer, silk 3615   Rogers Fund, 1913       Tosa province 198               Armor for Man 44   http://www.metmuseum.org/art/collection/search/25821 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
21203 21203 13.112.3a–m 0 0 25822 Arms and Armor 5 Armor (Gusoku) 1373 Armor (Gusoku) Japanese 35                           18th century 1701 1800 Iron, lacquer, silk 3615   Rogers Fund, 1913                       Armor for Man 44   http://www.metmuseum.org/art/collection/search/25822 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22730 22730 14.100.378a–c 0 0 27647 Arms and Armor 5 Cuirass and shoulder guards (Sode) 2798 Cuirass and Shoulder Guards (Sode) Japanese 35                           late 15th–early 16th century 1450 1550 Iron, lacquer, silk 3615 as mounted: H. approx. 24 in. (61 cm) Gift of Bashford Dean, 1914                       Armor Parts 47   http://www.metmuseum.org/art/collection/search/27647 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
24644 24644 36.120.407a, b 0 1 29684 Arms and Armor 5 Helmet (Hoshi kabuto) in the 16th-century style 2918 Helmet (Hoshi- Kabuto) in the 16th-Century Style Japanese 35         Armorer 98 Inscribed by Saotame Iesuek Japanese, Miyazaki Prefecture, active late 17th–early 18th century   Iesuek, Saotame 3064 Japanese 74 1650 1750 probably late 17th–early 18th century 1625 1775 Iron, lacquer, silk 3615 H. 11 3/4 in. (29.9 cm); W. 13 in. (33 cm) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       Helmets 37   http://www.metmuseum.org/art/collection/search/29684 4/23/2018 8:00:01 AM 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 131.847ms · Data license: CC0 · Data source: metmuseum/openaccess