MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Culture = 63 and Department = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Date, Object Begin Date, Object End Date, Medium, 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
17433 17433 04.3.23a, b 0 1 21935 Arms and Armor 5 Rapier with scabbard 1324 Rapier with Scabbard French or Italian 63         Goldsmith 101 Decoration attributed to Gasparo Mola Italian, Coldre ca. 1580–1640 Rome   Mola, Gasparo 2682 Italian  75 1575 1640 ca. 1620–30 1595 1655 Steel, gold, silver, leather, wood 3507 L. 49 1/4 in. (125.1 cm); W. 8 3/4 in. (22.2 cm); Wt. of scabbard 7.5 oz. (212.6 g) Rogers Fund, 1904                       Swords 29   http://www.metmuseum.org/art/collection/search/21935 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17732 17732 14.25.659 0 0 22241 Arms and Armor 5 Falling buffe 1460 Falling Buffe French or Italian 63                           ca. 1550–60 1525 1585 Steel, brass 323   Gift of William H. Riggs, 1913                       Armor Parts-Buffes 83   http://www.metmuseum.org/art/collection/search/22241 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17767 17767 14.25.719a–j, m–p 0 0 22278 Arms and Armor 5 Composed amor for a youth or small boy 1485 Composed Armor for a Youth or Small Boy French or Italian 63                           ca. 1590 and later 1565 1900 Steel, brass, leather 3632 Wt. approx. 22 lb. 1 oz. (10 kg) Gift of William H. Riggs, 1913                       Armor for Child 81   http://www.metmuseum.org/art/collection/search/22278 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17808 17808 14.25.868 0 1 22319 Arms and Armor 5 Cuirass 1446 Cuirass French or Italian 63                           ca. 1800 1775 1825 Steel, gold, textile, leather 3635   Gift of William H. Riggs, 1913                       Armor Parts-Cuirasses 61   http://www.metmuseum.org/art/collection/search/22319 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17809 17809 14.25.869a, b 0 0 22320 Arms and Armor 5 Bretelles 1507 Bretelles French or Italian 63                           ca. 1800 1775 1825 Textile, steel, gold 3641   Gift of William H. Riggs, 1913                       Armor Parts-Cuirasses 61   http://www.metmuseum.org/art/collection/search/22320 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18382 18382 26.80.1–.2 0 0 22904 Arms and Armor 5 Spurs 1540 Pair of Rowel Spurs French or Italian 63                           ca. 1350 1325 1375 Copper alloy, enamel, gold, glass, glass paste 3828 L. 5 1/4 in. (13.34 cm); spread of sides, 3 1/2 in. (8.89 cm); Wt. 6 oz. (170.1 g) Gift of Amory S. Carhart, in memory of his father, Amory S. Carhart, 1926   Villandraut 474                   Equestrian Equipment-Spurs 94   http://www.metmuseum.org/art/collection/search/22904 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
21710 21710 14.25.619 0 1 26541 Arms and Armor 5 Cabasset 1346 Cabasset French or Italian 63                           16th century; embossed decoration, probably 18th–19th century 1501 1925 Steel, brass, leather 3632 H. 11 1/4 in. (28.6 cm); W. 9 in. (22.9 cm); D. 13 1/4 in. (33.7 cm); Wt. 2 lb. 13.3 oz. (1284.2 g) Gift of William H. Riggs, 1913                       Forgeries 144   http://www.metmuseum.org/art/collection/search/26541 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
24574 24574 37.189.10 0 0 29614 Arms and Armor 5 Mace 1328 Mace French or Italian 63                           16th century 1501 1600 Steel, gold 3497 L. 23 3/4 in. (60.3 cm) Gift of Christian A. Zabriskie, 1937                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/29614 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30190 30190 2011.307 0 0 35717 Arms and Armor 5 Drawing 23 Album Page with Designs for Floral Ornament and Two Gunlocks French or Italian 63                           18th century 1701 1800 Pen, black and blue ink, blue wash on paper 7200 7 1/2 x 5 1/8 in. (19 x 13 cm) Purchase, Arthur Ochs Sulzberger Gift, 2011                       Works on Paper-Drawings 129   http://www.metmuseum.org/art/collection/search/35717 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 125.765ms · Data license: CC0 · Data source: metmuseum/openaccess