MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Nationality = 74 and Object Name = 110

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Dimensions, Credit Line

Artist Nationality ✖

  • Japanese · 8 ✖
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 Metadata Date Repository
38775 38775 17.118.89 0 1 44929 Asian Art 7 Dish 110 乾山様式　色絵竹文皿|Kenzan-style Dish with Bamboo Leaves Japan 46 Edo period (1615–1868)       Artist 2 In the style of Ogata Kenzan Japanese, 1663–1743 (?) Ogata Kenzan 3650 Japanese 74 1663 1743 17th–18th century 1600 1799 Stoneware painted with cobalt blue and cream slip under a transparent glaze, and iron-brown slip; gold lacquer repair (kintsugi)  9254 H. 1 3/8 in. (3.5 cm); Diam. 6 7/8 in. (17.5 cm) Rogers Fund, 1917                       Ceramics 5   http://www.metmuseum.org/art/collection/search/44929 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
39261 39261 17.118.90 0 1 45514 Asian Art 7 Dish 110 乾山様式　色絵竹文皿|Kenzan-style Dish with Bamboo Leaves Japan 46 Edo period (1615–1868)       Artist 2 In the style of Ogata Kenzan Japanese, 1663–1743 (?) Ogata Kenzan 3650 Japanese 74 1663 1743 17th–18th century 1600 1799 Stoneware painted with cobalt blue and cream slip under a transparent glaze, and iron-brown slip; gold lacquer repair (kintsugi) 9450 H. 1 3/8 in. (3.5 cm); Diam. 6 7/8 in. (17.5 cm) Rogers Fund, 1917                       Ceramics 5   http://www.metmuseum.org/art/collection/search/45514 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
41142 41142 23.225.343 0 1 47761 Asian Art 7 Dish 110   Japan 46 Edo period (1615–1868)       Artist 2   Kikko Japanese,   Kikko 3953 Japanese 74     1850 1850 1850 Faience covered with glaze and decorated with incised medallions (Raku ware) 10284 H. 2 1/2 in. (6.4 cm); W. sq. 4 1/2 in. (11.4 cm) Gift of Mrs. V. Everit Macy, 1923                       Ceramics 5   http://www.metmuseum.org/art/collection/search/47761 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
41201 41201 91.1.355 0 1 47848 Asian Art 7 Dish 110   Japan 46         Artist 2   Toyosuke IV Japanese,   Toyosuke IV 3955 Japanese 74     1840 1840 1840 Pottery covered with rich green glaze; green over white at handles 10321 L. 9 1/2 in. (24.1 cm) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Ceramics 5   http://www.metmuseum.org/art/collection/search/47848 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
48791 48791 64.86 0 0 56585 Asian Art 7 Dish 110   Japan 46         Artist 2   Kitaoji Rosanjin 1883–1959   Kitaoji Rosanjin 4485 Japanese 74 1883 1959 first half of the 20th century 1900 1949 Earthenware with iron decoration  11837 H. 3 1/8 in. (7.9 cm); Diam. 14 in. (35.6 cm) Gift of Alice Boney, 1964                       Ceramics 5   http://www.metmuseum.org/art/collection/search/56585 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
50221 50221 X.127 0 1 58286 Asian Art 7 Dish 110   Japan 46 Edo period (1615–1868)       Artist 2 Style of Ogata Kenzan Japanese, 1663–1743   Ogata Kenzan 3650 Japanese 74 1663 1743 19th century 1800 1899 Stoneware with colored enamels (Kyoto ware) 12102 H. 1 1/2 in. (3.8 cm); W. 6 7/8 in. (17.5 cm) Museum Accession                       Ceramics 5   http://www.metmuseum.org/art/collection/search/58286 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
54256 54256 93.1.34 0 1 62625 Asian Art 7 Dish 110   Japan 46 Edo period (1615–1868)       Artist 2   Shuntai Japanese, 1799–1878   Shuntai 3776 Japanese 74 1799 1799 19th century 1800 1899 Glazed stoneware (Seto ware, Oribe Revival type)  13256 H. 2 1/4 in. (5.7 cm); W. 9 in. square (22.9 cm square) Gift of Mr. and Mrs. Samuel Colman, 1893                       Ceramics 5   http://www.metmuseum.org/art/collection/search/62625 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
65285 65285 SL.21.2012.5.2a–h 0 0 76964 Asian Art 7 Dish 110   Japan 46 Edo period (1615–1868)       Artist 2   Ogata Kenzan Japanese, 1663–1743   Ogata Kenzan 3650 Japanese 74 1663 1743 1712–30 1712 1730 Earthenware with white slip, iron oxide and underglaze cobalt-blue (Nijō Chōjiya-machi kiln, Kyoto) 14731 Diam. of rim (each): 4 7/16 in. (11.2 cm) Collection of Peggy and Richard M. Danziger                       Ceramics 5   http://www.metmuseum.org/art/collection/search/76964 4/23/2018 8:00:01 AM 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 1247.71ms · Data license: CC0 · Data source: metmuseum/openaccess