MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Artist Role = 229

View and edit SQL

Suggested facets: Object Name, Title, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

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
69250 1985.375.7 0 0 82567 Costume Institute 8 Sweater 5882 Sweater British 6         Designer|Designer|Retailer 229   Vivienne Westwood|Malcolm McLaren|Seditionaries British, born 1941|British, London 1946–2010 Switzerland|British, 1976–1980   Westwood, Vivienne|McLaren Malcolm|Seditionaries 5774 British|British|British 178 1941 |1946-01-22|1976 2041 |2010-04-08|1980 1976–80 1976 1980 wool 15104   Gift of Barbara and Gregory Reynolds, 1985                           Metropolitan Museum of Art, New York, NY 1
69252 1985.375.9 0 0 82569 Costume Institute 8 T-shirt 5916 T-shirt British 6         Designer|Designer|Retailer 229 Attributed to|Attributed to|Attributed to Malcolm McLaren|Vivienne Westwood|Seditionaries British, London 1946–2010 Switzerland|British, born 1941|British, 1976–1980   McLaren Malcolm|Westwood, Vivienne|Seditionaries 5776 British|British|British 178 1946-01-22|1941 |1976 2010-04-08|2041 |1980 1976–80 1976 1980 cotton 3340   Gift of Barbara and Gregory Reynolds, 1985                           Metropolitan Museum of Art, New York, NY 1
69253 1985.375.10 0 0 82570 Costume Institute 8 T-shirt 5916 T-shirt British 6         Designer|Designer|Retailer 229 Attributed to|Attributed to|Attributed to Malcolm McLaren|Vivienne Westwood|Seditionaries British, London 1946–2010 Switzerland|British, born 1941|British, 1976–1980   McLaren Malcolm|Westwood, Vivienne|Seditionaries 5776 British|British|British 178 1946-01-22|1941 |1976 2010-04-08|2041 |1980 1976–80 1976 1980 cotton 3340   Gift of Barbara and Gregory Reynolds, 1985                           Metropolitan Museum of Art, New York, NY 1
74908 1985.375.11 0 0 95812 Costume Institute 8 T-shirt 5916 T-shirt British 6         Designer|Designer|Retailer 229 Attributed to|Attributed to|Attributed to Malcolm McLaren|Vivienne Westwood|Seditionaries British, London 1946–2010 Switzerland|British, born 1941|British, 1976–1980 and McLaren Malcolm|Westwood, Vivienne|Seditionaries 5776 British|British|British 178 1946-01-22|1941 |1976 2010-04-08|2041 |1980 1976–80 1976 1980 cotton 3340   Gift of Barbara and Gregory Reynolds, 1985                           Metropolitan Museum of Art, New York, NY 1
76213 2003.479a–d 0 0 98013 Costume Institute 8 Trousers 5475 Trousers British 6         Designer|Designer|Retailer 229   Vivienne Westwood|Malcolm McLaren|Seditionaries British, born 1941|British, London 1946–2010 Switzerland|British, 1976–1980   Westwood, Vivienne|McLaren Malcolm|Seditionaries 5774 British|British|British 178 1941 |1946-01-22|1976 2041 |2010-04-08|1980 1976–80 1976 1980 a) cotton, metal; b,c) wool 17256   Purchase, Richard Martin Bequest, 2003                           Metropolitan Museum of Art, New York, NY 1
76546 2004.15a–c 0 0 98568 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer|Designer|Retailer 229   Vivienne Westwood|Malcolm McLaren|Seditionaries British, born 1941|British, London 1946–2010 Switzerland|British, 1976–1980   Westwood, Vivienne|McLaren Malcolm|Seditionaries 5774 British|British|British 178 1941 |1946-01-22|1976 2041 |2010-04-08|1980 1976–80 1976 1980 cotton, metal 15378   Purchase, Irene Lewisohn Bequest, 2004                           Metropolitan Museum of Art, New York, NY 1
88164 2006.253.1 0 0 129613 Costume Institute 8 T-shirt 5916 "Derek Jarman" British 6         Designer|Designer|Retailer 229 Attributed to|Attributed to|Attributed to Vivienne Westwood|Malcolm McLaren|Seditionaries British, born 1941|British, London 1946–2010 Switzerland|British, 1976–1980   Westwood, Vivienne|McLaren Malcolm|Seditionaries 5774 British|British|British 178 1941 |1946-01-22|1976 2041 |2010-04-08|1980 1978–80 1978 1980 cotton 3340   Purchase, Richard Martin Bequest and Friends of The Costume Institute Gifts, 2006                           Metropolitan Museum of Art, New York, NY 1
88172 2006.253.8 0 0 129621 Costume Institute 8 Shirt 5887 "Cowboys" British 6         Designer|Designer|Retailer 229 Attributed to|Attributed to|Attributed to Vivienne Westwood|Malcolm McLaren|SEX British, born 1941|British, London 1946–2010 Switzerland|British, 1974–1976   Westwood, Vivienne|McLaren Malcolm|SEX 6787 British|British|British 178 1941 |1946-01-22|1974 2041 |2010-04-08|1976 1974–76 1974 1976 cotton 3340   Purchase, Richard Martin Bequest and Friends of The Costume Institute Gifts, 2006                           Metropolitan Museum of Art, New York, NY 1
88173 2006.253.9 0 0 129622 Costume Institute 8 T-shirt 5916 "Cowboys" British 6         Designer|Designer|Retailer 229 Attributed to|Attributed to|Attributed to Vivienne Westwood|Malcolm McLaren|Seditionaries British, born 1941|British, London 1946–2010 Switzerland|British, 1976–1980   Westwood, Vivienne|McLaren Malcolm|Seditionaries 5774 British|British|British 178 1941 |1946-01-22|1976 2041 |2010-04-08|1980 1976–80 1976 1980 cotton 3340   Purchase, Richard Martin Bequest and Friends of The Costume Institute Gifts, 2006                           Metropolitan Museum of Art, New York, NY 1
88186 2006.253.15 0 0 129635 Costume Institute 8 T-shirt 5916 "Tits" British 6         Designer|Designer|Retailer 229   Vivienne Westwood|Malcolm McLaren|Seditionaries British, born 1941|British, London 1946–2010 Switzerland|British, 1976–1980   Westwood, Vivienne|McLaren Malcolm|Seditionaries 5774 British|British|British 178 1941 |1946-01-22|1976 2041 |2010-04-08|1980 1976–80 1976 1980 cotton 3340   Purchase, Richard Martin Bequest and Friends of The Costume Institute Gifts, 2006                           Metropolitan Museum of Art, New York, NY 1
88220 2006.253.26 0 0 129742 Costume Institute 8 Shirt 5887 "Cambridge Rapist" British 6         Designer|Designer|Retailer 229   Vivienne Westwood|Malcolm McLaren|Seditionaries British, born 1941|British, London 1946–2010 Switzerland|British, 1976–1980   Westwood, Vivienne|McLaren Malcolm|Seditionaries 5774 British|British|British 178 1941 |1946-01-22|1976 2041 |2010-04-08|1980 1976–80 1976 1980 cotton 3340   Purchase, Richard Martin Bequest and Friends of The Costume Institute Gifts, 2006                           Metropolitan Museum of Art, New York, NY 1
98462 2013.32a–d 0 0 181415 Costume Institute 8 Shirt 5887 Shirt British 6         Designer|Designer|Retailer 229   Malcolm McLaren|Vivienne Westwood|Seditionaries British, London 1946–2010 Switzerland|British, born 1941|British, 1976–1980   McLaren Malcolm|Westwood, Vivienne|Seditionaries 5776 British|British|British 178 1946-01-22|1941 |1976 2010-04-08|2041 |1980 1976–80 1976 1980 cotton, synthetic 15314   Millia Davenport and Zipporah Fleisher Fund, 2013                           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 136.651ms · Data license: CC0 · Data source: metmuseum/openaccess