MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where City = 526 and Culture = 68

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, 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 Repository
26719 36.25.505 0 0 31871 Arms and Armor 5 Shaffron (Horse's head defense) 1377 Shaffron (Horse's Head Defense) Turkish 68                           16th century 1501 1600 Iron 13 H. 19 in. (48.3 cm); W. 7 1/2 in. (19 cm) Bequest of George C. Stone, 1935   Istanbul 526                   Equestrian Equipment-Shaffrons 59   Metropolitan Museum of Art, New York, NY 1
26793 36.25.449 0 0 31945 Arms and Armor 5 Thigh and Knee Defense 3334 Thigh and Knee Defense Turkish 68                           15th century 1401 1500 Iron 13 H. 20 1/4 in. (51.4 cm); W. 17 1/4 in. (43.8 cm); Wt. 2 lbs. 6.8 oz. (1100 g) Bequest of George C. Stone, 1935   Istanbul 526                   Armor Parts-Knee Defenses 87   Metropolitan Museum of Art, New York, NY 1
26794 36.25.455 0 1 31946 Arms and Armor 5 Leg Guard 3335 Right Leg Guard Turkish 68                           16th century 1501 1600 Steel, silver 3508 H. 15 in. (38.1 cm); W. 7 1/2 in. (19.1 cm); Wt. 1 lb. 0.6 oz. (470.6 g) Bequest of George C. Stone, 1935   Istanbul 526                   Armor Parts-Thigh and Leg Defense 115   Metropolitan Museum of Art, New York, NY 1
26795 36.25.456 0 1 31947 Arms and Armor 5 Leg Guard 3335 Left Leg Guard Turkish 68                           16th century 1501 1600 Steel, silver, copper 4351 H. 15 (38.1 cm); W. 7 1/2 in. (19.1 cm); Wt. 1 lb. 4.4 oz. (578.3 g) Bequest of George C. Stone, 1935   Istanbul 526                   Armor Parts-Thigh and Leg Defense 115   Metropolitan Museum of Art, New York, NY 1
26836 36.25.343 0 0 31988 Arms and Armor 5 Backplate 1371 Backplate for a Janissary Turkish 68                           15th century 1401 1500 Iron 13 laid flat, H. 12 in. (30.5 cm); W. 20 in. (50.8 cm); Diam. 8 1/2 in. (21.6 cm); Wt. 3 lb. 7 oz. (1559.2 g) Bequest of George C. Stone, 1935   Istanbul 526                   Armor Parts-Breastplates 62   Metropolitan Museum of Art, New York, NY 1
26837 36.25.344 0 0 31989 Arms and Armor 5 Fragment of a backplate 3352 Fragment of a Backplate for a Janissary Turkish 68                           15th century 1401 1500 Iron 13 laid flat, W. 22 1/4 in. (56.5 cm); Diam. 9 7/8 in. (25.1 cm); Wt. 2 lb. 7 oz. (1105.6 g) Bequest of George C. Stone, 1935   Istanbul 526                   Armor Parts-Breastplates 62   Metropolitan Museum of Art, New York, NY 1
26858 36.25.395 0 0 32010 Arms and Armor 5 Right arm guard (Bazu Band) 3354 Right Arm Guard (Bazu Band) Turkish 68                           17th century 1601 1700 Iron 13 L. 11 1/2 in. (29.2 cm); W. 3 1/4 in. (8.3 cm) Bequest of George C. Stone, 1935   Istanbul 526                   Armor Parts 47   Metropolitan Museum of Art, New York, NY 1
26859 36.25.396 0 1 32011 Arms and Armor 5 Left arm guard 3333 Left Arm Guard Turkish 68                           16th–17th century 1501 1700 Steel, copper 4673 L. 11 1/4 in. (28.6 cm); W. 3 1/4 in. (8.3 cm); Wt. 11.7 oz. (331.7 g) Bequest of George C. Stone, 1935   Istanbul 526                   Armor Parts 47   Metropolitan Museum of Art, New York, NY 1
26901 36.25.108 0 1 32053 Arms and Armor 5 Helmet 1349 Helmet Turkish 68                           second half 16th century 1550 1600 Steel, gold, copper alloy 3533 H. 11 1/4 in. (28.6 cm); Diam. 8 1/4 in. (21 cm); Wt. 3 lb. 4.3 oz. (1482.7 g) Bequest of George C. Stone, 1935   Istanbul 526                   Helmets 37   Metropolitan Museum of Art, New York, NY 1
26912 36.25.124 0 1 32064 Arms and Armor 5 Helmet 1349 Helmet Turkish 68                           16th century 1501 1600 Iron 13 H. including nasal 13 5/8 in. (34.6 cm); H. excluding nasal 9 5/8 in. (24.4 cm); W. 8 1/2 in. (21.6 cm); D. 9 1/4 in. (23.5 cm); Wt. 2 lb. 13.6 oz. (1292.7 g) Bequest of George C. Stone, 1935   Istanbul 526                   Helmets 37   Metropolitan Museum of Art, New York, NY 1
26959 36.25.59a–h 0 0 32111 Arms and Armor 5 Suit of mail and plate 3362 Suit of Mail and Plate Turkish 68                           15th century 1401 1500 Iron 13 Helmet (a); H. including mail 24 7/8 in. (63.2 cm); H. excluding mail 6 1/4 in. (15.9 cm); W. 8 in. (20.3 cm); D. 8 1/4 in. (21 cm) Wt. 4 lbs. 5.8 oz. (1978.8 g) Bequest of George C. Stone, 1935   Istanbul 526                   Cloisonné 157   Metropolitan Museum of Art, New York, NY 1
26961 36.25.61 0 0 32113 Arms and Armor 5 Breastplate (Krug) and backplate 3374 Breastplate (Krug) and Backplate Turkish 68                           16th century 1501 1600 Iron 13   Bequest of George C. Stone, 1935   Istanbul 526                   Armor Parts 47   Metropolitan Museum of Art, New York, NY 1
384516 36.25.443 0 0 634066 Arms and Armor 5 Thigh and knee defense 26622 Thigh and Knee Defense Turkish 68                           16th century 1501 1600 Steel 658 laid flat, H. 17 in. (43.2 cm); W. 15 3/4 in. (40 cm); D. 2 1/2 in. (6.4 cm); Wt. 2 lb. 1.9 oz. (961 g) Bequest of George C. Stone, 1936   Istanbul 526                   Armor Parts-Thigh and Leg Defense 115   Metropolitan Museum of Art, New York, NY 1
384540 36.25.444 0 1 634090 Arms and Armor 5 Thigh defense 26623 Thigh Defense Turkish 68                           15th century 1501 1600 Iron 13 H. including mail 10 in. (25.4 cm); H. excluding mail 2 3/4 in. (7 cm); Diam. 6 in. (15.2 cm); Wt. 1 lb. 10.5 oz. (751.3 g) Bequest of George C. Stone, 1936   Istanbul 526                   Armor Parts-Knee Defenses 87   Metropolitan Museum of Art, New York, NY 1
401836 2014.522a, b 0 1 656846 Musical Instruments 18 Ūd 15387 Ūd Turkish 68         Maker 1   Manol (Emmanuel Venios) Greek, active Turkey, Folegandros 1838–1915/16 Istanbul   Manol (Emmanuel Venios) 51030 Greek, active Turkey 3725 1830 1920 1916 1916 1916 Spruce, mulberry, various woods, mother-of-pearl, mastic 59030 31 1/2 × 14 5/16 × 7 7/16 in. (80 × 36.4 × 18.9 cm) Purchase, Amati Gifts, 2014   Istanbul 526     Turkey 61             Chordophone-Lute-plucked-unfretted 905   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 133.637ms · Data license: CC0 · Data source: metmuseum/openaccess