MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Nationality = 57 and Culture = 70

View and edit SQL

Suggested facets: Is Public Domain, Department, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Medium, Classification

Artist Nationality

  • Russian · 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 Repository
72064 2003.196 0 0 87375 Costume Institute 8 Evening dress 5874 Evening dress Russian 70         Designer 5   Valentin Yudaskin Russian, born 1963   Yudaskin Valentin 6033 Russian 57 1963 2063 fall/winter 1998–99 1998 1999 silk, plastic 15181   Gift of Valentin Yudashkin, 2003                           Metropolitan Museum of Art, New York, NY 1
88319 2006.380a, b 0 0 130128 Costume Institute 8 Dress 5877 "King Sun" Russian 70         Designer 5   Valentin Yudaskin Russian, born 1963   Yudaskin Valentin 6033 Russian 57 1963 2063 fall/winter 2005–6 2005 2006 a) silk; b) silk, synthetic 17237   Gift of Valentin Yudaskin, 2006                           Metropolitan Museum of Art, New York, NY 1
90976 2009.300.2186 0 0 156983 Costume Institute 8 Evening shirt 6231 Evening shirt Russian 70         Designer 5   Maullé Russian   Maullé 7096 Russian 57     ca. 1900 1898 1902 linen 15098   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Alastair Bradley Martin, 1977                           Metropolitan Museum of Art, New York, NY 1
104053 11.47 0 1 191640 European Sculpture and Decorative Arts 3 Bust 5 Count Tolstoy Russian 70         Artist 2   Leo Tolstoy Russian, 1828–1910   Tolstoy, Leo 8727 Russian 57 1828 1910 1911 1911 1911 Bronze 23 Height: 17 1/8 in. (43.5 cm) Gift of the sculptor, 1911                       Sculpture-Bronze 304   Metropolitan Museum of Art, New York, NY 1
120101 32.72 0 1 209287 European Sculpture and Decorative Arts 3 Icon 4044 Christ Preaching Russian 70         Artist 2   Russian Painter   , ca. 1890 Russian Painter 12012 Russian 57     ca. 1890 1885 1895 Gold, enamel, pearls; oil on wood 23870 4 3/4 x 4 1/4 in. (12.1 x 10.8 cm) Gift of the Estate of Mary Harrison McKee, 1932                       Metalwork-Gold and Platinum|Paintings 334   Metropolitan Museum of Art, New York, NY 1
120829 1999.452 0 0 210058 European Sculpture and Decorative Arts 3 Medal 148 Medal of Boris Piotrovsky (1908-1990) Russian 70         Maker 1   A. Koroluk Russian   Koroluk A. 12085 Russian 57     1990 1990 1990 Bronze 23 Diam. 2-5/8 in. (6.7 cm.) Gift of State Hermitage Museum, 1999                       Medals and Plaquettes 306   Metropolitan Museum of Art, New York, NY 1
139088 10.129 0 1 231245 European Sculpture and Decorative Arts 3 Statue 3890 Universal Peace Russian 70         Artist|Founder 355 Cast by Jules Leon Butensky|Roman Bronze Works Russian, 1871–1947   Butensky Jules Leon|Roman Bronze Works 12642 Russian 57 1871 1947 ca. 1909–10 1904 1915 Bronze 23 Overall: 106 1/4 in. (269.9 cm) Crate (base): 44 x 75 x 66 in., 8400 lb. ? (111.8 x 190.5 x 167.6 cm, 3810.215kg) Gift of Jacob H. Schiff, 1910                       Sculpture-Bronze 304   Metropolitan Museum of Art, New York, NY 1
347669 89.4.1894 0 1 502342 Musical Instruments 18 Ohotniche Rogi sounding D 16292 Ohotniche Rogi sounding D Russian 70         Maker 1   Nicolas N. Fedorov Russian, flourished ca. 1867–1889   Fedorov, Nicolas N. 47831 Russian 57 1867 1889 1873–89 1873 1889 Brass 12 Height (Perpendicular to bell): 33 1/16 in. (84 cm) Diameter (Of bell): 4 5/16 in. (11 cm) The Crosby Brown Collection of Musical Instruments, 1889   Moscow 1182     Russia 60             Aerophone-Lip Vibrated-horn 912   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 213.671ms · Data license: CC0 · Data source: metmuseum/openaccess