MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Department = 4 and Medium = 25 sorted by Dimensions

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Role, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Classification, Rights and Reproduction

Department

  • Modern and Contemporary Art · 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
334182 1976.67.39 0 0 481586 Modern and Contemporary Art 4 Serving platter 15099 Oceana           Designer|Manufacturer 3   Russel Wright|Klise Wood Working Company American, Lebanon, Ohio 1904–1976 New York|Grand Rapids, Michigan   Wright, Russel|Klise Wood Working Company 44956 American 1 1904 1976 ca. 1935 1930 1940 Wood 25 1 x 34 1/2 x 8 5/8 in. (2.5 x 87.6 x 21.9 cm) Gift of Russel Wright, 1976                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
338299 1991.78 0 0 485915 Modern and Contemporary Art 4 Sculpture 100 The Sacred Flame           Artist 2   Jean-Gabriel Chauvin French, 1889–1976   Chauvin, Jean-Gabriel 46107 French 2 1889 1976 ca. 1929 1929 1929 Wood 25 23 1/4 x 12 x 6 1/2 in. (59.1 x 30.5 x 16.5 cm) Purchase, Anonymous Gifts, 1991                       Sculpture 12 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
338278 1991.439 0 0 485891 Modern and Contemporary Art 4 Charger 209 Charger           Designer 5   Léon Jallot French, 1874–1967   Jallot, Leon 46095 French 2 1874 1967 ca. 1909 1909 1909 Wood 25 Diam. 16-1/8, D. 1-1/2 in. (41 x 3.8 cm.) Gift of Lloyd and Barbara Macklowe, 1991                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
341494 66.75.1 0 0 489509 Modern and Contemporary Art 4 Sculpture 100 African head           Artist 2   Alexander Calder American, Philadelphia, Pennsylvania 1898–1976 New York   Calder, Alexander 37663 American 1 1898 1976 ca. 1928 1928 1928 Wood 25 H. 15-1/2, W. 5-1/2, D. 8 inches (39.4 x 14 x 20.3 cm.) Gift of Charles Oppenheim, Jr., 1966                       Sculpture 12 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
338733 1994.221.2 0 0 486362 Modern and Contemporary Art 4 Vase box 15238 Vase box           Designer 5   Zenji Miyashita Japanese, Kyoto 1939–2012   Miyashita, Zenji 46212 Japanese 74 1939 2012 ca. 1990 1990 1990 Wood 25 H. 18, W. 12, D. 5-1/2 inches (45.7 x 30.5 x 14 cm.) Purchase, Lita Annenberg Hazen Charitable Trust Gift, 1994                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
340196 42.14 0 0 488026 Modern and Contemporary Art 4 Sculpture 100 Girl on Wheel           Artist 2   Chaim Gross American (born Austria), Wolow 1904–1991 New York   Gross, Chaim 45181 American, born Austria 27 1904 1991 1940 1940 1940 Wood 25 H. 29, W. 10, D. 10 inches (73.7 x 25.4 x 25.4 cm.) Morris K. Jesup Fund, 1942                       Sculpture 12 © 2016 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
335082 1982.354 0 1 482541 Modern and Contemporary Art 4 Armchair 21 Armchair           Designer 5   Joseph Maria Olbrich Austrian, Opava 1867–1908 Düsseldorf   Olbrich, Joseph Maria 45280 Austrian 66 1867 1908 1898 1898 1898 Wood 25 H. 35, W. 22-1/2, D. 20-1/2 in. (88.9 x 57.2 x 52.1 cm.) Purchase, Friends of Twentieth Century Decorative Arts Gifts, 1982                       Furniture 4   Metropolitan Museum of Art, New York, NY 1
341662 68.70.12 0 1 489720 Modern and Contemporary Art 4 Table 477 Table           Designer 5   Jules Bouy American (born France), 1872–1937   Bouy, Jules 45077 American, born France 35 1872 1937 ca. 1930 1930 1930 Wood 25 H.13-1/4, W.17-7/8, D.11-5/8 in. (33.7 x 45.4 x 29.5 cm) Gift of Juliette B. Castle and Mrs. Paul Dahlstrom, 1968                       Furniture 4   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 1012.84ms · Data license: CC0 · Data source: metmuseum/openaccess