MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

32 rows where "Artist End Date" is on date -4707-06-27 and Culture = 6

View and edit SQL

Suggested facets: Object Name, Title, 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
66749 1996.486.1a, b 0 0 79328 Costume Institute 8 Pumps 5885 Pumps British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 probably 1980s 1980 1989 suede, snakeskin 15208   Gift of Claire Bloom, 1996                           Metropolitan Museum of Art, New York, NY 1
66766 1996.491.5a, b 0 0 79345 Costume Institute 8 Boots 5898 Boots British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1987 1982 1992 suede, astrakhan fur 15211   Gift of Amy Fine Collins, 1996                           Metropolitan Museum of Art, New York, NY 1
66993 1997.226a, b 0 0 79592 Costume Institute 8 Pumps 5885 Pumps British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 1989–90 1989 1990 leather 15128   Gift of Anne H. Bass, 1997                           Metropolitan Museum of Art, New York, NY 1
67194 1995.205.21a–d 0 0 79803 Costume Institute 8 Boots 5898 Boots British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1989 1984 1994 suede 15107   Gift of Amy Fine Collins, 1995                           Metropolitan Museum of Art, New York, NY 1
67195 1995.205.22a, b 0 0 79804 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1988 1983 1993 leather 15128   Gift of Amy Fine Collins, 1995                           Metropolitan Museum of Art, New York, NY 1
67196 1995.205.23a, b 0 0 79805 Costume Institute 8 Sandals 4088 Sandals British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1988 1983 1993 leather 15128   Gift of Amy Fine Collins, 1995                           Metropolitan Museum of Art, New York, NY 1
67197 1995.205.24a, b 0 0 79806 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1988 1983 1993 suede 15107   Gift of Amy Fine Collins, 1995                           Metropolitan Museum of Art, New York, NY 1
67198 1995.205.25a, b 0 0 79807 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1993 1988 1995 suede 15107   Gift of Amy Fine Collins, 1995                           Metropolitan Museum of Art, New York, NY 1
67199 1995.205.26a, b 0 0 79808 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1993 1988 1995 cotton, leather 15333   Gift of Amy Fine Collins, 1995                           Metropolitan Museum of Art, New York, NY 1
67200 1995.205.27a, b 0 0 79809 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1990 1985 1995 plastic 15143   Gift of Amy Fine Collins, 1995                           Metropolitan Museum of Art, New York, NY 1
67742 1994.472.14a, b 0 0 80455 Costume Institute 8 Pumps 5885 Pumps British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 1988 1988 1988 suede, leather 15431   Gift of Carol R. Reiss, 1994                           Metropolitan Museum of Art, New York, NY 1
67761 1994.490.8a, b 0 0 80474 Costume Institute 8 Pumps 5885 Pumps British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1990 1985 1995 linen 15098   Gift of Amy Fine Collins, 1994                           Metropolitan Museum of Art, New York, NY 1
67762 1994.490.9a, b 0 0 80475 Costume Institute 8 Sandals 4088 Sandals British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1992 1987 1994 leather, Mylar 15434   Gift of Amy Fine Collins, 1994                           Metropolitan Museum of Art, New York, NY 1
67763 1994.490.10a, b 0 0 80476 Costume Institute 8 Sandals 4088 Sandals British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1991 1986 1994 leather 15128   Gift of Amy Fine Collins, 1994                           Metropolitan Museum of Art, New York, NY 1
67764 1994.490.11a, b 0 0 80477 Costume Institute 8 Pumps 5885 Pumps British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1989 1984 1994 leather 15128   Gift of Amy Fine Collins, 1994                           Metropolitan Museum of Art, New York, NY 1
68247 1993.512.15a, b 0 0 81051 Costume Institute 8 Pumps 5885 Pumps British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 late 1980s 1985 1989 leather, linen 15538   Gift of Stella Fischbach, 1993                           Metropolitan Museum of Art, New York, NY 1
72158 2002.561.14a, b 0 0 87930 Costume Institute 8 Boots 5898 Boots British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1990 1985 1995 (a, b) leather 16307   Gift of Holly Brubach, 2002                           Metropolitan Museum of Art, New York, NY 1
72198 2003.74.3a, b 0 0 87992 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1985 1980 1990 a,b) leather 16601   Gift of Tina S. Perlmutter, 2003                           Metropolitan Museum of Art, New York, NY 1
72199 2003.74.4a, b 0 0 87993 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 1985 1980 1990 a,b) leather, plastic 16602   Gift of Tina S. Perlmutter, 2003                           Metropolitan Museum of Art, New York, NY 1
74148 1992.396a, b 0 0 94172 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 spring/summer 1992 1992 1992 synthetic 15169   Gift of Manolo Blahnik, 1992                           Metropolitan Museum of Art, New York, NY 1
79279 2004.332a, b 0 0 106214 Costume Institute 8 Boots 5898 Boots British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 ca. 2003 1998 2004 a,b) leather, wood, cotton 17710   Anonymous Gift, 2004                           Metropolitan Museum of Art, New York, NY 1
83449 1986.125a, b 0 0 115762 Costume Institute 8 Mules 5926 Mules British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 1985 1985 1985 silk 15101   Gift of Mrs. John H. Gutfreund, 1986                           Metropolitan Museum of Art, New York, NY 1
88234 2006.512.1a, b 0 0 129844 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 fall/winter 2005–6 2005 2006 a, b) silk, leather 18781   Gift of Manolo Blahnik, 2006                           Metropolitan Museum of Art, New York, NY 1
88235 2006.512.2a, b 0 0 129846 Costume Institute 8 Boots 5898 "Circus" British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 spring/summer 1997 1997 1997 a, b) silk, leather, metal, rubber 18782   Gift of Manolo Blahnik, 2006                           Metropolitan Museum of Art, New York, NY 1
88239 2006.512.3a, b 0 0 129860 Costume Institute 8 Shoes 5896 Jene British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 spring/summer 1996 1996 1996 a,b) plastic, silk, metal, rubber 18783   Gift of Manolo Blahnik, 2006                           Metropolitan Museum of Art, New York, NY 1
88396 2006.512.4a, b 0 0 130667 Costume Institute 8 Boots 5898 "Modena" British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 spring/summer 1998 1998 1998 a,b) leather 16601   Gift of Manolo Blahnik, 2006                           Metropolitan Museum of Art, New York, NY 1
88397 2006.512.5 0 0 130668 Costume Institute 8 Shoes 5896 "Torna" British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 spring/summer 1994 1994 1994 silk, jet, leather 18850   Gift of Manolo Blahnik, 2006                           Metropolitan Museum of Art, New York, NY 1
88398 2006.512.6 0 0 130669 Costume Institute 8 Shoes 5896 "Bhutan" British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 spring/summer 2006 2006 2006 leather, metal 15127   Gift of Manolo Blahnik, 2006                           Metropolitan Museum of Art, New York, NY 1
88414 2007.46a, b 0 0 130766 Costume Institute 8 Shoes 5896 "Micamu" British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 spring/summer 2006 2006 2006 cotton, silk, rhinestones, leather 18855   Gift of Manolo Blahnik, 2006                           Metropolitan Museum of Art, New York, NY 1
88755 2008.292a, b 0 0 139907 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 2007 2007 2007 (a, b) silk, feathers 18982   Gift of Ricky Serbin, 2008                           Metropolitan Museum of Art, New York, NY 1
90362 2009.300.1630a, b 0 0 156367 Costume Institute 8 Evening pumps 5900 Evening pumps British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 1990–92 1990 1992 silk, leather, rhinestones 19299   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Manolo Blahnik, 1992                           Metropolitan Museum of Art, New York, NY 1
95592 2009.300.6065a, b 0 0 170280 Costume Institute 8 Evening mules 6694 Evening mules British 6         Designer 5   Manolo Blahnik British, born Spain, 1942   Blahnik Manolo 5379 Spanish 76 1942 2042 1990–92 1990 1992 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Manolo Blahnik, 1992                           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 1799.826ms · Data license: CC0 · Data source: metmuseum/openaccess