MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Culture = 512

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Artist Display Name, Artist Alpha Sort, 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
21793 1999.120 0 1 26628 Arms and Armor 5 Helmet (Rmog) 2560 Helmet (Rmog) Mongolian 512                           15th–17th century 1401 1700 Iron, gold, silver, copper 4063 H. 7 5/8 in. (19.5 cm) Purchase, Gift of William H. Riggs, by exchange, 1999                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
22779 2005.34 0 0 27698 Arms and Armor 5 Miniature snaphaunce gun 2807 Miniature Snaphaunce Gun Mongolian 512                           17th–19th century 1601 1900 Iron, wood, silver, brass, copper 5163 L. 16¼ in. (41.3 cm) Fletcher Fund, 2005                       Firearms-Guns-Snaphaunce 154   Metropolitan Museum of Art, New York, NY 1
22845 2005.271 0 1 27805 Arms and Armor 5 Helmet 1349 Helmet Mongolian 512                           15th–17th century 1401 1700 Iron 13 H. 11 3/4 in. (29.8 cm); W. 7 15/16 in. (20.2 cm); D. 9 in. (22.9 cm); Wt. 2 lb. 7 oz. (1105.6 g) Purchase, Arthur Ochs Sulzberger Gift, 2005                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
348847 2003.9 0 0 503566 Musical Instruments 18 Falcon Whistle 16706 Falcon Whistle Mongolian 512                           19th century 1801 1900 Brass, copper 6713 Overall: 2.2 x 1.5 x 7.3cm (7/8 x 9/16 x 2 7/8in.) Funds from various donors, 2003         Mongolia 879             Aerophone 955   Metropolitan Museum of Art, New York, NY 1
348860 2003.43 0 0 503579 Musical Instruments 18 Scroll with Musical Notation 16717 Scroll with Musical Notation Mongolian 512                           19th century 1800 1900 Parchment, ink 54934 Overall: 21.6 x 167 cm (8 1/2 x 65 3/4 in.) Purchase, Kenneth and Andrea Miron Gift, 2003         Mongolia 879             Accessory 256   Metropolitan Museum of Art, New York, NY 1
348861 2003.44 0 0 503580 Musical Instruments 18 Manuscript 266 Manuscript Mongolian 512                           20th century 1800 1900 Paper, cloth 2250 Storage: 7.7 x 18cm (3 1/16 x 7 1/16in.) Other: 15.4 x 18cm (6 1/16 x 7 1/16in.) Purchase, Kenneth and Andrea Miron Gift, 2003         Mongolia 879             Accessory 256   Metropolitan Museum of Art, New York, NY 1
349063 2002.128a–c 0 0 503800 Musical Instruments 18 Morin Khuur 16800 Morin Khuur Mongolian 512         Maker 1   Purevadavaa Baigalgav Mongolian   Baigalgav Purevadavaa 48098 Mongolian 3518     2001 2001 2001 Wood, horsehair, polychrome 55036 51 3/8 × 11 5/16 × 1 9/16 in. (130.5 × 28.7 × 4 cm) Purchase, The Crosby Brown Collection of Musical Instruments, by exchange, 2002   Ulaanbaatar 2310     Mongolia 879             Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
349214 2000.143 0 0 503987 Musical Instruments 18 Bishgüür 16882 Bishgüür Mongolian 512         Maker 1   Ulan Baran Mongolian   Baran Ulan 48154 Mongolian 3518     1987 1987 1987 Birch, copper 55091 Height: 27 9/16 in. (70 cm) Diameter: 6 1/4 in. (15.9 cm) Purchase, Gift of Herbert J. Harris, by exchange, 2000   Ulaanbaatar 2310     Mongolia 879             Aerophone-Reed Vibrated-single reed conical 974   Metropolitan Museum of Art, New York, NY 1
349219 2001.186a, b 0 0 503992 Musical Instruments 18 Morin Khuur 16800 Morin Khuur Mongolian 512         Maker 1   Purevadavaa Baigalgav Mongolian   Baigalgav Purevadavaa 48098 Mongolian 3518     2000 2000 2000 Wood, horsehair, polychrome 55036 L. 103.5 cm (40-3/4 in.), W. 27.5 cm (10-7/8 in.), D. 15 cm (6 in.) ; bow L. 87 cm ((34-1/4 in.) Purchase, Gift of Herbert J. Harris, by exchange, 2001   Ulaanbaatar 2310     Mongolia 879             Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
349220 2001.198 0 0 503993 Musical Instruments 18 Topshuur 16884 Topshuur Mongolian 512         Maker 1   Purevadavaa Baigalgav Mongolian   Baigalgav Purevadavaa 48098 Mongolian 3518     2000 2000 2000 Wood, silk 19988 L. 97.7 cm (38 7/16 in.), W. 24.7 cm (9 3/4 in.), D. 16 cm (6 5/16 in.) Purchase, Gift of Herbert J. Harris, by exchange, 2001   Ulaanbaatar 2310     Mongolia 879             Chordophone-Lute-plucked 960   Metropolitan Museum of Art, New York, NY 1
453442 2017.313a, b 0 1 762162 Arms and Armor 5 Pair of stirrups 1406 Pair of Stirrups Mongolian 512                           late 18th–mid-19th century 1775 1875 Silver 2 H. of each 6 1/2 in. (16.5 cm); W. of each 5 3/4 in. (12.1 cm); Wt. of 2017.313a, 2 lb. 5.1 oz. (1053 g); Wt. of 2017.313b, 2 lb. 5.8 oz. (1073 g) Purchase, Kenneth Lam Gift and Funds from Various Donors, 2017                       Equestrian Equipment-Stirrups 68   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 128.798ms · Data license: CC0 · Data source: metmuseum/openaccess