MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Medium = 7306

View and edit SQL

Suggested facets: Is Public Domain, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Credit Line

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
30616 1986.267.160 0 0 36231 Asian Art 7 Folding fan 2170 近代 郭蘭祥 梅花 扇面|Plum China 51         Artist 2   Guo Lanxiang Chinese, 1865–1938   Guo Lanxiang 3333 Chinese 116 1865 1938 dated 1931 1931 1931 Folding fan; ink and color on paper 7306 7 3/8 x 19 3/8 in. (18.7 x 49.2 cm) Gift of Robert Hatfield Ellsworth, in memory of La Ferne Hatfield Ellsworth, 1986                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
39088 1975.268.122 0 1 45333 Asian Art 7 Folding fan 2170   Japan 46 Edo period (1615–1868)       Artist 2   Tsubaki Kakoku Japanese, 1823–1848   Tsubaki Kakoku 3820 Japanese 74 1823 1848   1823 1848 Folding fan; ink and color on paper 7306 10 1/4 x 17 3/8 in. (26 x 44.1 cm) The Harry G. C. Packard Collection of Asian Art, Gift of Harry G. C. Packard, and Purchase, Fletcher, Rogers, Harris Brisbane Dick, and Louis V. Bell Funds, Joseph Pulitzer Bequest, and The Annenberg Fund Inc. Gift, 1975                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
42743 1989.363.166 0 0 49631 Asian Art 7 Folding fan 2170   China 51         Artist 2   Zhu Zeyuan Chinese, 20th century   Zhu Zeyuan 4084 Chinese 116 1900 1999 20th century 1900 1999 Folding fan; ink and color on paper 7306 7 1/8 x 20 1/2 in. (18.1 x 52.1 cm) Bequest of John M. Crawford Jr., 1988                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
44659 51.14 0 1 51770 Asian Art 7 Folding fan 2170   China 51         Artist|Calligrapher 184   Giuseppe Castiglione|Wang Yudun Italian, Milan 1688–1766 Beijing|Chinese, 1692–1758   Castiglione, Giuseppe|Wang Yudun 4246 Italian|Chinese 127 1688 |1692 1766 |1758 18th century 1700 1766 Folding fan; ink and color on paper 7306 H. (sticks) 12 1/4 in. (31.1 cm); W. (open) 20 in. (50.8 cm) Rogers Fund, 1951                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
65316 SL.8.2012.3.11 0 0 77010 Asian Art 7     China 51         Artist 2   Fu Baoshi Chinese, 1904–1965   Fu Baoshi 3374 Chinese 116 1904 1965 dated 1947 1947 1947 Folding fan; ink and color on paper 7306 Image: 5 1/2 x 16 1/8 in. (14 x 41 cm) Lent by a private collection, New York                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
65317 SL.8.2012.3.12 0 0 77011 Asian Art 7     China 51         Artist 2   Fu Baoshi Chinese, 1904–1965   Fu Baoshi 3374 Chinese 116 1904 1965 dated 1953 1953 1953 Folding fan; ink and color on paper 7306 Image: 7 1/2 x 19 13/16 in. (19 x 50.3 cm) Lent by a private collection, New York                       Paintings 11   Metropolitan Museum of Art, New York, NY 1
409523 2015.300.189 0 1 670893 Asian Art 7 Folding fan 2170   Japan 46 Edo period (1615–1868)       Artist 2   Yamamoto Baiitsu Japanese, 1783–1856   Yamamoto Baiitsu 3728   1783 1783 1832 1832 1832 Folding fan; ink and color on paper 7306 Image: 6 11/16 × 18 11/16 in. (17 × 47.5 cm) Mary Griggs Burke Collection, Gift of the Mary and Jackson Burke Foundation, 2015                       Paintings 11   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 119.115ms · Data license: CC0 · Data source: metmuseum/openaccess