MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

20 rows where Classification = 972

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Country, Artist Begin Date (date), Artist End Date (date)

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
346360 89.4.369 0 0 500991 Musical Instruments 18 Tabbalat Arrakeb 15713 Tabbalat Arrakeb Arabian 397                           late 19th century 1850 1900 Metal, wood, skin, felt 54122 H. 6.4 cm (2-1/2 in.), Diam. of head 12.7 (5 in.) The Crosby Brown Collection of Musical Instruments, 1889         Arabia 755             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
347161 89.4.1251 0 0 501817 Musical Instruments 18 Drum 2181 Drum European 12                           late 19th century 1850 1900 pottery, parchment 54399 H. 9 in., Diam. 5 in. The Crosby Brown Collection of Musical Instruments, 1889                       Membranophone 972   Metropolitan Museum of Art, New York, NY 1
347198 89.4.1289 0 0 501855 Musical Instruments 18 Lalis 16122 Lalis Melanesian 6351                           late 19th century 1850 1900 Wood 25 L. 2 ft. 5-1/2 in. (28 in.? at top of card), Width 4 in., Thickness, 3 in. The Crosby Brown Collection of Musical Instruments, 1889         Fiji 172             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
347218 89.4.1310 1 0 501876 Musical Instruments 18 Tombak 15676 Tombak Iranian (Persian) 6206                           late 19th century 1850 1900 Various woods, bone, brass, skin 54416 Height: 18 in. (45.7 cm) Width: 11 in. (27.9 cm) Diameter (At widest point): 35 1/2 in. (90.2 cm) Diameter (Of base): 31 in. (78.7 cm) The Crosby Brown Collection of Musical Instruments, 1889         Iran (Persia) 746             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
347242 89.4.1334 0 0 501900 Musical Instruments 18 Tab'l Bel'Edee 16140 Tab'l Bel'Edee Turkish 68                           late 19th century 1850 1900 Wood, skin, cord 54023 H. 12 in., Diam. 22 in., L. of stick 14 in. The Crosby Brown Collection of Musical Instruments, 1889         Turkey 61             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
347267 89.4.1359 0 0 501925 Musical Instruments 18 Tar 15685 Tar Morrocan 6215                           late 19th century 1850 1900 Wood, skin, metal 53971 Diam. 1 ft., D. 3 in. The Crosby Brown Collection of Musical Instruments, 1889         Morocco 75             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
347447 89.4.1538 0 0 502113 Musical Instruments 18 Dumbellek 16216 Dumbellek Turkish 68                           late 19th century 1850 1900 earthenware 46537 L. 11-1/2 in., Diam. 6-1/2 in., H. 6 in. The Crosby Brown Collection of Musical Instruments, 1889         Turkey 61             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
347856 89.4.1961a,b 0 0 502540 Musical Instruments 18 Tsuri Daiko 16354 Tsuri Daiko Japanese 35                           late 19th century 1850 1900 Various Materials 54590 H. of stand 6 ft. 8 in., W. of stand 2 ft. 6 in., Diam. of drum 20 in. The Crosby Brown Collection of Musical Instruments, 1889       East 894 Japan 15             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
347942 89.4.2060 0 0 502627 Musical Instruments 18 Drum 2181 Drum Native American (Apache) 6286                           late 19th century 1850 1900   H. 11-1/2 in., Diam. 10 in. The Crosby Brown Collection of Musical Instruments, 1889         United States 3             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
348027 89.4.2275 0 0 502715 Musical Instruments 18 Target Drum 16410 Target Drum Japanese 35                           19th century 1801 1900 Wood, skin 27238 H. 27-1/2 in.; W. 8-1/8 in. The Crosby Brown Collection of Musical Instruments, 1889         Japan 15             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
348135 89.4.2856 0 0 502824 Musical Instruments 18 Drum 2181 Drum Native American (Zuni, probably) 6507                           19th century 1801 1900 Wood 25   The Crosby Brown Collection of Musical Instruments, 1889       New Mexico 191 United States: N.A. 743             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
348152 89.4.3120a,b 0 0 502842 Musical Instruments 18 European Type Drum 16441 European Type Drum American 1                           19th century 1801 1900 Wood, skin 27238   The Crosby Brown Collection of Musical Instruments, 1889         United States 3             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
349034 2001.321 0 0 503763 Musical Instruments 18 Drum 2181 Drum Indonesian (Lombak) 6629                           late 19th century 1850 1899 Wood, paint 4879 L. 38 cm (15 in.); Diam. 15 cm ( 6 in.) Purchase, Gift of Herbert J. Harris, by exchange, 2001       Lombak 991 Indonesia 106             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
349375 1990.130.2 0 0 504152 Musical Instruments 18 Double-headed drum 16930 Double-headed drum possibly Indonesian 6664                           19th century 1800 1899 Hide, various materials 55117 L.: 46,6 cm (18-1.4 in.); Diam.: 22.3 cm (8-3/4 in.) Purchase, Gift of Mrs. Norma F. Finer Perll, by exchange; Gift of Mrs. Mark Leithauser, by exchange; funds from various donors, 1990         Indonesia? 903             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
349476 89.4.2523 0 1 504262 Musical Instruments 18 Bass Drum 16964 Bass Drum American 1         Maker 1   John G. Pike American, Plymouth, New York 1815–1884 Norwich, New York   Pike, John G. 48254 American 1 1815-12-23 1884-07-01 1860–80 1860 1880 Wood, parchment, leather, metal 55176 Diameter ±68.7cm (±27 1/16 in.); Depth 44.3 cm (17 7/16 in.) The Crosby Brown Collection of Musical Instruments, 1889   Norwich 5   New York 126 United States 3             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
350100 06.1253 0 0 504958 Musical Instruments 18 Hand drum 17207 Hand drum New Zealander 6453                             0 0     The Crosby Brown Collection of Musical Instruments, 1889         New Zealand 199             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
350120 09.69.2 0 0 504982 Musical Instruments 18 Drum 2181 Drum Cambodian 333                           19th century 1800 1899 Metal 772 D. 8 1/2 × L. 17 in. (21.6 × 43.2 cm) The Crosby Brown Collection of Musical Instruments, 1889         Cambodia 889             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
350351 46.34.25 0 0 505249 Musical Instruments 18 Damaru 15583 Damaru Tibetan 309                           late 19th–early 20th century 1870 1910 Bone, fabric, vellum, wax 55398 H. 7 1/2 × W. 5 1/8 in. (19.1 × 13 cm) Gift of Miss Alice Getty, 1946         Tibet 729             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
350362 46.34.51 0 0 505260 Musical Instruments 18 Drum 2181 Drum Chinese 10                           late 19th–early 20th century 1870 1910 Wood, metal 6120 Overall: Diam. 10 1/2 × L. 28 1/2 in. (26.7 × 72.4 cm) Gift of Miss Alice Getty, 1946         China 13             Membranophone 972   Metropolitan Museum of Art, New York, NY 1
350540 89.4.3104 0 0 505482 Musical Instruments 18 Tanbour, or Tamboura (reproduction) 17396 Tanbour, or Tamboura Turkish or Persian 6740                           late 19th century 1870 1910   L. 38 in. (96.5 cm) The Crosby Brown Collection of Musical Instruments, 1889         Persia or Turkey 962             Membranophone 972   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 122.606ms · Data license: CC0 · Data source: metmuseum/openaccess