MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Nationality = 66 and Medium = 148

View and edit SQL

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

Artist Nationality

  • Austrian · 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
118040 1982.60.129 1 1 207032 European Sculpture and Decorative Arts 3 Statuette group 3389 Hercules and Achelous probably Austrian 284         Artist 2 Attributed to the Master of the Martyrdom of St. Sebastian Austrian   Master of the Martyrdom of St. Sebastian 11612 Austrian 66     probably mid-17th century 1630 1665 Ivory 148 Overall (confirmed): H. 11 x W. 6 1/4 x D. 4 3/8 in. (27.9 x 15.9 x 11.1 cm) The Jack and Belle Linsky Collection, 1982                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
122486 2003.235 0 1 212210 European Sculpture and Decorative Arts 3 Plaque 75 Hercules and Achelous (in the form of a bull) Austrian 184         Maker 1 Attributed to the Master of the Martyrdom of St. Sebastian Austrian   Master of the Martyrdom of St. Sebastian 11612 Austrian 66     ca. 1670 1665 1675 Ivory 148 Overall: 3 × 2 1/2 in. (7.6 × 6.4 cm) Purchase, Mrs. Sid R. Bass, Mrs. Oscar de la Renta and Mrs. Walter Annenberg Gifts, in honor of Mrs. Charles Wrightsman, 2003                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
139019 2004.127 0 1 231015 European Sculpture and Decorative Arts 3 Relief statuette 8367 Standing man representing a statue Austrian 184         Artist 2 Attributed to Master of the Martyrdom of St. Sebastian Austrian   Master of the Martyrdom of St. Sebastian 11612 Austrian 66     1657 1657 1657 Ivory 148 Overall (confirmed): 8 1/16 × 3 1/4 × 7/8 in. (20.5 × 8.3 × 2.2 cm) Purchase, Malcolm Hewitt Wiener Foundation, Alexis Gregory and Friends of European Sculpture and Decorative Arts Gifts, 2004                       Sculpture-Miniature 311   Metropolitan Museum of Art, New York, NY 1
339665 23.38.1 0 0 487356 Modern and Contemporary Art 4 Pendant 1129 Pendant Austrian 184         Manufacturer|Designer 18   Wiener Werkstätte in America|Dagobert Peche Austrian, St. Michael im Lungau 1887–1923 Mödling bei Wien   Wiener Werkstätte in America|Peche, Dagobert 46469 Austrian 66 1887 1923 20th century 1900 1920 Ivory 148 H. 2-1/4, W. 1-1/8 in. (5.7 x 2.9 cm) Purchase, Edward C. Moore Jr. Gift, 1923                       Jewelry 10   Metropolitan Museum of Art, New York, NY 1
339666 23.38.2 0 0 487357 Modern and Contemporary Art 4 Pendant 1129 Pendant Austrian 184         Manufacturer|Designer 18   Wiener Werkstätte in America|Dagobert Peche Austrian, St. Michael im Lungau 1887–1923 Mödling bei Wien   Wiener Werkstätte in America|Peche, Dagobert 46469 Austrian 66 1887 1923 20th century 1900 1920 Ivory 148 H. 2, W. 1 inches (5.1 x 2.5 cm) Purchase, Edward C. Moore Jr. Gift, 1923                       Jewelry 10   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 1075.289ms · Data license: CC0 · Data source: metmuseum/openaccess