MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Nationality = 138 and Object End Date = 1967

View and edit SQL

Suggested facets: Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, 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
66828 1996.254a–c 0 0 79416 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer|Manufacturer 3   Rudi Gernreich|Harmon Knitwear American (born Austria), Vienna 1922–1985 Los Angeles, California|American   Gernreich, Rudi|Harmon Knitwear 5323 American, born Austria|American 138 1922 1985 1963–67 1963 1967 synthetics 15103   Gift of Joy Craft, 1996                           Metropolitan Museum of Art, New York, NY 1
70070 1988.74.1a–f 0 0 83915 Costume Institute 8 Ensemble 5875 Ensemble American 1         Designer|Design House 202 (a–d) Rudi Gernreich|Capezio Inc. American (born Austria), Vienna 1922–1985 Los Angeles, California|American, founded 1887   Gernreich, Rudi|Capezio Inc. 5865 American, born Austria|American 138 1922 |1887 1985 |2050 1967 1967 1967 (a, c, d) wool, plastic (b) wool (e,f) leather 16114   Gift of Léon Bing and Oreste F. Pucciani, 1988                           Metropolitan Museum of Art, New York, NY 1
70135 C.I.68.20.3a, b 0 0 83987 Costume Institute 8 Bikini 5880 Bikini American 1         Designer|Manufacturer 3   Rudi Gernreich|Harmon Knitwear American (born Austria), Vienna 1922–1985 Los Angeles, California|American   Gernreich, Rudi|Harmon Knitwear 5323 American, born Austria|American 138 1922 1985 1967 1967 1967 wool, plastic 15276   Gift of Rudi Gernreich, 1968                           Metropolitan Museum of Art, New York, NY 1
82838 1985.374.14a, b 0 0 114314 Costume Institute 8 Mules 5926 Mules American 1         Designer|Design House 202   Rudi Gernreich|Capezio Inc. American (born Austria), Vienna 1922–1985 Los Angeles, California|American, founded 1887   Gernreich, Rudi|Capezio Inc. 5865 American, born Austria|American 138 1922 |1887 1985 |2050 fall/winter 1966–67 1966 1967 leather 15128   Gift of Rudi Gernreich Revocable Trust, 1985                           Metropolitan Museum of Art, New York, NY 1
91777 2009.300.2933a–c 0 0 157814 Costume Institute 8 Beachwear 5881 Beachwear American 1         Designer|Manufacturer 3   Rudi Gernreich|Westwood Knitting Mills American (born Austria), Vienna 1922–1985 Los Angeles, California|American   Gernreich, Rudi|Westwood Knitting Mills 5265 American, born Austria|American 138 1922 1985 ca. 1965 1963 1967 wool 15104   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998                           Metropolitan Museum of Art, New York, NY 1
98038 2009.300.8423 0 0 175419 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Designer|Manufacturer 3   Rudi Gernreich|Westwood Knitting Mills American (born Austria), Vienna 1922–1985 Los Angeles, California|American   Gernreich, Rudi|Westwood Knitting Mills 5265 American, born Austria|American 138 1922 1985 ca. 1965 1963 1967 Wool 2116   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Barbara Jakobson, 1998                           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 135.307ms · Data license: CC0 · Data source: metmuseum/openaccess