MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where City = 451

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Culture, 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
17853 14.25.1148 0 0 22364 Arms and Armor 5 Smallsword 1526 Smallsword Probably French, Paris 199                           ca. 1650–60 1625 1685 Steel, gold, wood 3520 L. 38 1/2 in. (97.8 cm); L. of blade 31 3/4 in. (80.7 cm); W. 3 3/4 in. (9.5 cm); D. 3 1/4 in. (8.3 cm); Wt. 1 lb. 5 oz. (595 g) Gift of William H. Riggs, 1913   probably Paris 451                   Swords 29   Metropolitan Museum of Art, New York, NY 1
17858 14.25.1200 0 1 22369 Arms and Armor 5 Rapier 1321 Rapier probably French, Paris 201         Hilt Maker|Bladesmith 113 Hilt signed Bouqueton|Johannes Wundes French, active early 17th century|German, Solingen, ca. 1560–1610   Bouqueton|Wundes, Johannes 2727 French|German 83 1600 |1535 1650 |1635 ca. 1610–20 1585 1645 Steel, silver, wood 3505 L. 48 1/8 in. (122.2 cm); L. of blade 41 1/2 in. (105.4 cm); W. 9 1/2 in. (24.1 cm); Wt. 3 lb. 6 oz. (1530.9 g) Gift of William H. Riggs, 1913   probably Paris 451                   Swords 29   Metropolitan Museum of Art, New York, NY 1
21708 1997.341 0 1 26539 Arms and Armor 5 Parade helmet à l'antique 2513 Parade Helmet à l'Antique French, probably Paris 485                           ca. 1630 1605 1655 Steel, copper alloy, paint, textile 4762 H. 14 7/8 in. (37.6 cm); W. 8 1/2 in. (21.6 cm); D. 14 1/2 in. (36.8 cm); Wt. 4 lb. 8 oz. (2167 g) Purchase, Gift of William H. Riggs, by exchange, 1997   probably Paris 451                   Helmets 37   Metropolitan Museum of Art, New York, NY 1
21719 1999.448 0 1 26550 Arms and Armor 5 Collar plate for a helmet 2518 Collar Plate for a Helmet of Henry III of France (1551–1589) French, probably Paris 485                           ca. 1570 1545 1595 Steel, copper alloy 3537 H. 6 in. (15 cm); W. 10 1/4 (25.9 cm); D. 5 in. (12.7 cm); Wt. 5.5 oz. (155.9 g) Gift of Prescott R. Andrews Jr., 1999   probably Paris 451                   Helmets Parts 107   Metropolitan Museum of Art, New York, NY 1
22978 26.145.288a, b 0 0 27956 Arms and Armor 5 Smallsword with scabbard 1641 Smallsword with Scabbard French, probably Paris 485                           ca. 1780–89 1755 1814 Steel, rayskin, silver, gold, wood 5260 L. with scabbard 38 3/8 in. (97.5 cm); L. without scabbard 38 3/8 in. (97.5 cm); L. of blade 31 1/2 in. (80 cm); W. 3 3/4 in. (9.5 cm); Wt. 12.6 oz. (357.2 g); Wt. of scabbard 2.4 oz. (68 g) Gift of Jean Jacques Reubell, in memory of his mother, Julia C. Coster, and of his wife, Adeline E. Post, both of New York City, 1926   probably Paris 451                   Swords 29   Metropolitan Museum of Art, New York, NY 1
30180 2011.63 0 1 35698 Arms and Armor 5 Smallsword 1526 Smallsword French, probably Paris 485                           ca. 1650–60 1625 1685 Steel, gold, wood, copper alloy 6498 L. 41 in. (104.1 cm); L. of blade 34 1/2 in. (87.5 cm) Purchase, Arthur Ochs Sulzberger Gift, 2011   probably Paris 451                   Swords 29   Metropolitan Museum of Art, New York, NY 1
324466 17.190.199 1 1 464156 Medieval Art 6 Plaque 75 Plaque with the Descent from the Cross French 7                           ca. 1320–40 1320 1340 Ivory, whale bone, traces of paint and gilding 49155 Overall: 9 1/8 x 7 3/16 x 13/16 in. (23.2 x 18.3 x 2.1 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 probably Paris 451     France 9             Ivories 181   Metropolitan Museum of Art, New York, NY 1
328593 1998.538.1 0 1 469985 Medieval Art 6 Bible; Manuscript leaf 14790 Manuscript Leaf with Opening of The Book of Nehemias, from a Bible French 7                           ca. 1280–1300 1280 1300 Tempera and gold on parchment 47797 Overall: 15 15/16 x 10 11/16 in. (40.5 x 27.2 cm) Mat size: 21 15/16 x 15 15/16 in. (55.7 x 40.5 cm) Gift of Mr. and Mrs. William D. Wixom, 1998 Made in 1 probably Paris 451     France 9             Manuscripts and Illuminations 162   Metropolitan Museum of Art, New York, NY 1
329902 1970.324.7a, b 1 1 471975 The Cloisters 17 Diptych 7532 Diptych with the Coronation of the Virgin and the Last Judgment French 7                           ca. 1260–70 1260 1270 Elephant ivory, with metal mounts 50422 Overall (opened): 5 x 5 1/8 x 3/4 in. (12.7 x 13 x 1.9 cm) The Cloisters Collection, 1970 Made in 1 probably Paris 451     France 9             Ivories 181   Metropolitan Museum of Art, New York, NY 1
330277 37.159 0 1 472389 The Cloisters 17 Statue 3890 Virgin and Child French 7                           ca. 1340–50 1337 1353 Limestone, paint, gilt, glass 50444 68 × 22 13/16 × 11 1/4 in. (172.7 × 58 × 28.5 cm) The Cloisters Collection, 1937 Made in 1 probably Paris 451   Île-de-France 330 France 9             Sculpture 12   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 180.684ms · Data license: CC0 · Data source: metmuseum/openaccess