MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Medium = 19988

View and edit SQL

Suggested facets: Is Public Domain, Department, Culture, Artist Role, Object Date, Object Begin Date, Object End Date, Credit Line, Country, 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
94519 2009.300.4985 0 0 169207 Costume Institute 8 Fan 413 Fan American 1                           1890–1915 1890 1915 Wood, silk 19988   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Alice Pentlarge Kleeman in memory of Mrs. Rafael Pentlarge, 1957                           Metropolitan Museum of Art, New York, NY 1
334433 1978.492.1a,b 0 1 481844 Modern and Contemporary Art 4 Table 477 Table           Artist 2   Joseph Urban American (born Austria), Vienna 1872–1933 New York   Urban, Joseph 45032 American, born Austria 27 1872 1933 ca. 1920 1920 1920 Wood, silk 19988 H. 23-7/8, W. 16, D.16 in. (60.6 x 40.6 x 40.6 cm) Insert: H. 17, W. 17-1/2 in. (43.2 x 44.5 cm) Purchase, Gifts in memory of Emil Blasberg, 1978                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
347090 89.4.1167a, b 0 0 501738 Musical Instruments 18 Castanets 15873 Castanets French or Spanish 2161                           19th century 1801 1900 Wood, silk 19988 Length: +/- 8.0 cm, Diameter: +/-5.5 cm The Crosby Brown Collection of Musical Instruments, 1889         France or Spain 624             Idiophone-Concussion 929   Metropolitan Museum of Art, New York, NY 1
347888 89.4.1993 0 0 502572 Musical Instruments 18 Gogenkin 16360 Gogenkin Japanese 35                           19th century 1801 1900 Wood, silk 19988 L. 41 in.; W. 5-1/2 in. The Crosby Brown Collection of Musical Instruments, 1889         Japan 15             Chordophone-Zither-plucked-long zither 913   Metropolitan Museum of Art, New York, NY 1
347890 89.4.1995 0 0 502574 Musical Instruments 18 Yayoi Goto 16362 Yayoi Goto Japanese 35         Maker 1   Tōshichi, Asano 浅野藤七     Tōshichi, Asano 47815       19th century 1801 1900 Wood, silk 19988 L. 42 in.; W. 5 in. The Crosby Brown Collection of Musical Instruments, 1889   Kyoto 494     Japan 15             Chordophone-Zither-plucked-long zither 913   Metropolitan Museum of Art, New York, NY 1
347900 89.4.2005 0 0 502584 Musical Instruments 18 Zither 15586 Zither Japanese 35                           19th century 1801 1900 Wood, silk 19988 Overall: 16.5 x 68.6cm (6 1/2 x 27in.) The Crosby Brown Collection of Musical Instruments, 1889         Japan 15             Chordophone-Zither-bowed 976   Metropolitan Museum of Art, New York, NY 1
347970 89.4.2088 0 0 502655 Musical Instruments 18 Moso Biwa 16396 Moso Biwa Japanese 35                           19th century 1801 1900 Wood, silk 19988 36 × 6 in. (91.4 × 15.2 cm) The Crosby Brown Collection of Musical Instruments, 1889         Japan 15             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
348516 1982.171.11 0 0 503216 Musical Instruments 18 Wolgum 16571 Wolgum Korean 220                           20th century 1901 2000 Wood, silk 19988 L. 98.6 cm (38-13/16 in.); W. 34.9 cm (13-3/4 in.); D. 2.5 cm (1 in.) Gift of Korean Cultural Service, 1982         Korea 731             Chordophone-Lute-plucked-fretted 921   Metropolitan Museum of Art, New York, NY 1
348608 1986.467.45a, b 0 0 503315 Musical Instruments 18 Mokugyo 15520 Mokugyo Japanese 35                           20th century 1901 2000 Wood, silk 19988 L. 15½ in. (39.2 cm), W. 15 in. (38.2 cm) Gift of Herbert J. Harris, 1986         Japan 15             Idiophone-Struck-slit drum 939   Metropolitan Museum of Art, New York, NY 1
349036 89.4.2163 0 0 503765 Musical Instruments 18 Se 16792 Se (瑟 ) Chinese 10 Qing dynasty (1644-1911)       Maker 1   Fanfu Lou (Seal of Zha Youci)     Fanfu Lou (Seal of Zha Youci) 48090       19th century 1800 1899 Wood, silk 19988 72 × 17 in. (182.9 × 43.2 cm) The Crosby Brown Collection of Musical Instruments, 1889         China 13             Chordophone-Zither-plucked-long zither 913   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

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