MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Nationality = 1 and Culture = 51

View and edit SQL

Suggested facets: Object Name, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Begin Date, Classification, Rights and Reproduction

Artist Nationality

  • American · 5
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
53683 52.40 0 0 62017 Asian Art 7 Medallion 72   China 51         Artist 2 Metalwork by Florence Cary Koehler American, 1861–1944   Koehler Florence Cary 4676 American 1 1861 1944 ca. 1905 1895 1915 Chalcedony, metal 13113 H. (incl. ring) 3 in. (7.6 cm); W. 3 in. (7.6 cm) Gift of Mrs. Emily C. Chadbourne, 1952                       Hardstone 192   Metropolitan Museum of Art, New York, NY 1
63701 2007.13 0 0 73601 Asian Art 7 Photographic album 5801 當代 秋麥 華山圖 冊 摄影 噴墨印 紙本|Bounded by Mountains: Mount Hua China 51 Contemporary       Artist 2   Michael Cherney American, born 1969   Cherney, Michael 4924 American 1 1969 9999 2005–6 2005 2006 Photographic album of twelve leaves; inkjet print on mica-flecked paper 14471 Image (each leaf): 10 1/4 x 14 15/16 in. (26 x 38 cm) Purchase, Josephine L. Berger-Nadler Gift, in honor of Marie-Hélène and Guy Weill, 2007                       Photographs 21 © © Michael Cherney Metropolitan Museum of Art, New York, NY 1
63760 2007.12 0 0 73671 Asian Art 7 Photographic album 5801 現代 秋麥 大足佛像圖 冊|Bounded by Mountains: Dazu China 51         Artist 2   Michael Cherney American, born 1969   Cherney, Michael 4924 American 1 1969 9999 2003–04 2003 2004 Photographic album of 12 leaves; ink on mica-flecked paper  14484 Fully open: 10 1/4 in. (26 cm) x 194 1/2 in. (494 cm) Purchase, The B. D. G. Leviton Foundation Gift, in honor of Marie-Hélène and Guy Weill, 2007                       Photographs 21 © Michael Cherney Metropolitan Museum of Art, New York, NY 1
64516 2008.644a–c 0 0 75280 Asian Art 7 Hanging scrolls 3893 現代 秋麥 影幔會集圖 軸三幅|Shadow Curtains-Gatherings #2 China 51         Artist 2   Michael Cherney American, born 1969   Cherney, Michael 4924 American 1 1969 9999 2007–8 2007 2008 Set of three photographic hanging scrolls; ink on paper 14589 Image (each): 50 7/8 x 17 9/16 in. (129.2 x 44.6 cm) Overall with mounting: 84 1/2 x 18 3/8 in. (214.6 x 46.7 cm) Certificate: 5 x 6 7/8 in. (12.7 x 17.5 cm) Original print: 6 3/8 x 7 1/2 in. (16.2 x 19.1 cm) Gift of the artist, in honor of Josephine Berger-Nadler, Diane Schafer, and Mary Wallach, 2008                       Paintings 11 © Michael Cherney Metropolitan Museum of Art, New York, NY 1
64534 2009.104 0 0 75345 Asian Art 7 Photograph 997 現代 秋麥 嵩山 攝影|Mount Song China 51         Artist 2   Michael Cherney American, born 1969   Cherney, Michael 4924 American 1 1969 9999 2007–9 2007 2009 Handscroll mounted with photographic images printed with pigment inks on mica-flecked xuan paper 14591 Image: 10 5/8 x 464 in. (27 x 1178.6 cm) Purchase, Diane Schafer and Mary and James G. Wallach Foundation Gifts, 2009                       Photographs 21 © Michael Cherney 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 2097.666ms · Data license: CC0 · Data source: metmuseum/openaccess