MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where City = 526 and Medium = 13

View and edit SQL

Suggested facets: Is Public Domain, 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
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
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
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
26942 36.25.33 0 1 32094 Arms and Armor 5 Mail shirt 1547 Mail Shirt Possibly Turkish, Istanbul or Iranian 1044                           15th–16th century 1401 1600 Iron 13 H. 44 1/8 in. (112.0 cm); W. 44 7/8 in. (114.0 cm); W. of chest 25 5/8 in. (65.0 cm); Diam. (outside) of inscribed links 5/8 in. (15.8 mm); Diam. (inside) of inscribed links 7/16 in. (11.1 mm); Diam. (outside) of solid extension links 1/2 in. (12.6 mm); Diam. (inside) of solid extension links 11/32 in. (8.2 mm); Diam. (outside) of riveted links 17/32 in. (13.7 mm); Diam. (inside) of links 13/32 in. (9.9 mm); Wt. 23 lb. 8 oz. (10.66 kg). 36.25.33   Istanbul 526                   Mail 63   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
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

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.223ms · Data license: CC0 · Data source: metmuseum/openaccess