MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where City = 535

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, 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
20524 04.3.31 0 0 25062 Arms and Armor 5 Rapier 1321 Rapier hilt, Italian, possibly Venice; blade, Spanish 414                           early 17th century 1601 1650 Steel, silver 3508 L. 49 5/8 in. (126.1 cm); L. of blade 43 1/2 in. (110.5 cm); W. 6 in. (15.2 cm); D. 3 in. (7.6 cm); Wt. 2 lb. 2 oz. (963.9 g) Rogers Fund, 1904   possibly Venice 535                   Swords 29   Metropolitan Museum of Art, New York, NY 1
20595 04.3.133 0 0 25140 Arms and Armor 5 Basilard 1337 Basilard Italian, possibly Venice 423                           ca. 1550 1525 1575 Steel, bronze, silver, niello, gold 4479 L. 11 3/16 in. (28.5 cm); L. of blade 7 1/2 in. (19.1 cm); W. 1 7/8 in. (4.8 cm); W. of blade 1/2 in. (1.3 cm); thickness of blade 7/16 in. (1.1 cm); Wt. 6 oz. (170.1 g) Rogers Fund, 1904   possibly Venice 535                   Daggers 33   Metropolitan Museum of Art, New York, NY 1
28112 20.151.13–.14 0 1 33287 Arms and Armor 5 Bit boss 1561 Pair of Bit Bosses Italian, possibly Venice 423                           ca. 1600 1575 1625 Copper alloy, gold, enamel 6747 20.151.13; Diam. 2 1/2 in. (6.4 cm); Wt. 1.7 oz. (48.2 g); 20.151.14; Diam. 2 1/2 in. (6.4 cm); Wt. 1.6 oz. (45.4 g) Rogers Fund, 1920   possibly Venice 535                   Equestrian Equipment-Bits 56   Metropolitan Museum of Art, New York, NY 1
28878 29.158.658a 0 1 34077 Arms and Armor 5 Hilt of a dagger 3262 Hilt of a Dagger possibly Italian, Venice 1212                           ca. 1300 1275 1325 Ivory 148 L. 5 in. (12.7 cm); W. 2 5/16 (5.9 cm); D. 1 9/16 (4 cm); Wt. 5.4 oz (153.1 g) Bashford Dean Memorial Collection, Funds from various donors, 1929   possibly Venice 535                   Daggers 33   Metropolitan Museum of Art, New York, NY 1
29078 29.157.10 0 0 34284 Arms and Armor 5 Sword 379 Sword possibly Spanish or Italian, Venice 1224                           early 16th century 1500 1550 Steel 658 L. 28 3/4 in. (73 cm); L. of blade 23 1/2 in. (59.7 cm); W. 4 in. (10.2 cm); Wt. 1 lb. 11 oz. (765.4 g) Bashford Dean Memorial Collection, Gift of Mr. and Mrs. Robert W. de Forest, 1929   possibly Venice 535                   Swords 29   Metropolitan Museum of Art, New York, NY 1
323852 09.153b, c 0 1 463205 Medieval Art 6 Pilaster 1169 Pilasters North Italian 229                           10th–11th century 900 1099 Marble (Carrara and Parian marble) 49000 Overall (b): 40 3/8 x 9 5/8 x 6 3/4 in., 214lb. (102.6 x 24.4 x 17.1 cm, 97.1kg) Overall (c): 40 5/8 x 9 5/8 x 6 7/8 in., 202lb. (103.2 x 24.4 x 17.5 cm, 91.6kg) Rogers Fund, 1909 Made in 1 possibly Venice 535   Veneto 327 Italy 14             Sculpture-Architectural 336   Metropolitan Museum of Art, New York, NY 1
326558 23.280.13 0 1 466553 The Cloisters 17 Capital 176 Capital Northeast Italian 6070                           12th century 1100 1199 Marble (Parian marble from Chorodaki, island of Paros (Greece)) 49856 12 1/4 x 12 1/2 x 12 1/4 in. (31.1 x 31.8 x 31.1 cm) Bequest of Anne D. Thomson, 1923 Made in 1 possibly Venice 535     Italy 14             Sculpture-Architectural 336   Metropolitan Museum of Art, New York, NY 1
327544 46.156.36a, b 0 1 468129 Medieval Art 6 Textile 1143 Textile Fragment with Recumbent Harts, Eagles, Clouds, and Sunrays Italian 36                           1390s 1390 1399 Silk, metal thread 14027 Overall (a): 24 1/2 x 27 1/2 in. (62.2 x 69.8 cm) Overall (b): 6 1/2 x 27 1/4 in. (16.5 x 69.2 cm) Fletcher Fund, 1946 Made in 1 possibly Venice 535     Italy 14             Textiles-Woven 191   Metropolitan Museum of Art, New York, NY 1
405615 14.25.1162 0 0 662375 Arms and Armor 5 Rapier 1321 Rapier possibly German or Italian, Venice 6927                           1580 1580 1580 Steel, silver, copper 4351 L. 46 13/16 in. (118.9 cm); L. of blade 40 1/8 in. (101.9 cm); W. 9 1/8 in. (23.2 cm); D. 5 in. (12.7 cm); Wt. 2 lb. 14 oz. (1304.1 g) Gift of William H. Riggs, 1913   possibly Venice 535                   Swords 29   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 136.005ms · Data license: CC0 · Data source: metmuseum/openaccess