MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Role = 5 and Medium = 25

View and edit SQL

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

Artist Role

  • Designer · 9
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
16247 2004.540.1a, b 0 1 18561 American Decorative Arts 1 Architectural elements 16 Panel with Detached Piece American 1         Designer 5   Louis Comfort Tiffany American, New York 1848–1933 New York   Tiffany, Louis Comfort 21 American 1 1848 1933   1848 1933 Wood 25 28 1/4 x 14 x 1/2 in. (71.8 x 35.6 x 1.3 cm) Gift of Eric Streiner, 2004                       Architecture 8   Metropolitan Museum of Art, New York, NY 1
16248 2004.540.2 0 1 18562 American Decorative Arts 1 Panel fragment 1173 Panel Fragment American 1         Designer 5   Louis Comfort Tiffany American, New York 1848–1933 New York   Tiffany, Louis Comfort 21 American 1 1848 1933   1848 1933 Wood 25 5 1/2 x 7 1/4 x 1/2 in. (14 x 18.4 x 1.3 cm) Gift of Eric Streiner, 2004                       Architecture 8   Metropolitan Museum of Art, New York, NY 1
16249 2004.540.3 0 1 18563 American Decorative Arts 1 Architecture element 1174 Carved Fragment American 1         Designer 5   Louis Comfort Tiffany American, New York 1848–1933 New York   Tiffany, Louis Comfort 21 American 1 1848 1933   1848 1933 Wood 25 4 1/2 x 19 x 6 in. (11.4 x 48.3 x 15.2 cm) Gift of Eric Streiner, 2004                       Architecture 8   Metropolitan Museum of Art, New York, NY 1
16283 2004.540.26 0 1 18800 American Decorative Arts 1 Architectural elements 16 Decorative Carved Wood Panel from Laurelton Hall American 1         Designer 5   Louis Comfort Tiffany American, New York 1848–1933 New York   Tiffany, Louis Comfort 21 American 1 1848 1933   1848 1933 Wood 25 21 x 19 in. (53.3 x 48.3 cm) Gift of Eric Streiner, 2004                       Architecture 8   Metropolitan Museum of Art, New York, NY 1
111679 48.174.64a–p, aa–pp, r 0 0 199947 European Sculpture and Decorative Arts 3 Chess set 212 Chess set German, Weimar 3024         Designer 5   Josef Hartwig German, Munich 1880–1955 Frankfurt   Hartwig, Josef 10329 German 10 1880 1955 1924 1924 1924 Wood 25 Height (each king, confirmed): 1 7/8 in. (4.8 cm); Height (each pawn, confirmed): 13/16 × 13/16 × 13/16 in. (2.1 × 2.1 × 2.1 cm) Gift of Gustavus A. Pfeiffer, 1948                       Chess Sets 338   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
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
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
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 2099.573ms · Data license: CC0 · Data source: metmuseum/openaccess