MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

25 rows where "Artist Begin Date" is on date -4707-04-06 and Culture = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, 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 Metadata Date Repository
66600 66600 1996.258.5 0 0 79164 Costume Institute 8 Shirt 5887 Shirt British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 spring/summer 1995 1995 1995 cotton/polyester blend 15173   Gift of Matthew P. Hammerle, 1996                           http://www.metmuseum.org/art/collection/search/79164 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
67376 67376 1995.433.1 0 0 80038 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 1994–95 1994 1995 silk 15101   Gift of Richard Martin, 1995                           http://www.metmuseum.org/art/collection/search/80038 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
67377 67377 1995.433.2 0 0 80039 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 spring/summer 1994 1994 1994 silk 15101   Gift of Richard Martin, 1995                           http://www.metmuseum.org/art/collection/search/80039 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
69533 69533 2001.562.18a, b 0 0 83050 Costume Institute 8 Evening ensemble 5879 Evening ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 spring/summer 1994 1994 1994 (a, b) silk  15932   Gift of Anne H. Bass, 2001                           http://www.metmuseum.org/art/collection/search/83050 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72307 72307 2004.154a–c 0 0 88535 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 spring/summer 2001 2001 2001 a) polyester, viscose/synthetic blend, cotton; b,c) leather, synthetic, cotton 16638   Gift of John Galliano S.A., 2004                           http://www.metmuseum.org/art/collection/search/88535 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72462 72462 2003.203.1a, b 0 0 89682 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 ca. 2000 1995 2003 a) cotton/cashmere blend, rabbit, wood; b) cotton/cashmere blend, rabbit 16692   Gift of Barbara Rochelle Kaplan, 2003                           http://www.metmuseum.org/art/collection/search/89682 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
72463 72463 2003.203.2a, b 0 0 89683 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 ca. 2000 1995 2003 Silk, cotton, rabbit fur 16693   Gift of Barbara Rochelle Kaplan, 2003                           http://www.metmuseum.org/art/collection/search/89683 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74072 74072 2000.168 0 0 93744 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 spring/summer 1999 1999 1999 nylon 15130   Gift of John Galliano, 2000                           http://www.metmuseum.org/art/collection/search/93744 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
80999 80999 2005.46 0 0 109315 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 fall/winter 1996–97 1996 1997 leather 15128   Gift of John Galliano S.A., 2004                           http://www.metmuseum.org/art/collection/search/109315 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
81000 81000 2004.410 0 0 109316 Costume Institute 8 Coat 4973 Coat British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 fall/winter 1996–97 1996 1997 wool, silk 15161   Purchase, Irene Lewisohn Bequest, 2004                           http://www.metmuseum.org/art/collection/search/109316 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
85472 85472 2006.376a–g 0 0 120386 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 fall/winter 2004–5 2004 2005 a) cotton, rubber, plastic; b) cotton, silk, plastic; c,d) cotton; e,f) leather, wood; g) fur, cotton, wool, plastic 18354   Gift of John Galliano S. A., 2006                           http://www.metmuseum.org/art/collection/search/120386 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88752 88752 2012.122 0 0 139697 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 spring/summer 1997 1997 1997 silk, synthetic 15328   Gift of John Galliano, 2012                           http://www.metmuseum.org/art/collection/search/139697 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
92901 92901 2009.300.580 0 0 159127 Costume Institute 8 Trousers 5475 Trousers British 6         Retailer|Designer 222   Susanne Bartsch|Richard Torry American|British, born 1960   Bartsch, Susanne|Torry Richard 7373 American|British 28 1960 2060 ca. 1984 1982 1986 linen, synthetic 17169   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mark Isaacson, 1992                           http://www.metmuseum.org/art/collection/search/159127 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
97997 97997 2009.300.8367 0 0 175378 Costume Institute 8 Shirt 5887 Shirt British 6         Designer|Retailer 51   Richard Torry|Susanne Bartsch British, born 1960|American   Torry Richard|Bartsch, Susanne 7938 British|American 33 1960 2060 ca. 1985 1983 1987 Silk 165   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mark Isaacson, 1992                           http://www.metmuseum.org/art/collection/search/175378 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
402333 402333 2014.504a–c 0 0 657392 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328 British 7 1960 2060 fall/winter 1986–87 1986 1987 wool, silk, metal 15268   Purchase, Gould Family Foundation Gift, in memory of Jo Copeland, 2014                           http://www.metmuseum.org/art/collection/search/657392 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
418401 418401 2015.528a, b 0 0 692443 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 fall/winter 1987–88 1987 1988 cotton, polyester, viscose, silk, metal 60051   Purchase, Funds from various donors, by exchange, 2015                           http://www.metmuseum.org/art/collection/search/692443 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
418849 418849 2016.54 0 0 693849 Costume Institute 8 Evening dress 5874 Evening dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 spring/summer 2000 2000 2000 silk, metal, cotton 17005   Purchase, Various Donors, by exchange, 2015                           http://www.metmuseum.org/art/collection/search/693849 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
434690 434690 2016.541 0 0 722701 Costume Institute 8 Coat 4973 Coat British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 1984 1984 1984 cotton, silk, metal, plastic 61528   Purchase, Friends of The Costume Institute Gifts, 2016                           http://www.metmuseum.org/art/collection/search/722701 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
434703 434703 2016.542a, b 0 0 722714 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 fall/winter 1987–1988 1987 1988 (a) wool, silk, synthetic; (b) wool, mother-of-pearl 61529   Purchase, Friends of The Costume Institute Gifts, 2016                           http://www.metmuseum.org/art/collection/search/722714 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
434716 434716 2016.543 0 0 722728 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 spring/summer 1988 1988 1988 nylon, silk, synthetic 61531   Purchase, Friends of The Costume Institute Gifts, 2016                           http://www.metmuseum.org/art/collection/search/722728 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
445061 445061 2017.42a, b 0 0 744207 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 fall/winter 1985–1986 1985 1986 (a) wool, synthetic, mohair, wood; (b) wool, synthetic, mohair 62232   Purchase, Friends of The Costume Institute Gifts, 2017                           http://www.metmuseum.org/art/collection/search/744207 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
445065 445065 2017.43a, b 0 0 744211 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 fall/winter 1985–1986 1985 1986 (a) cotton, silk, cork, shell, wool; (b) cotton, synthetic 62235   Purchase, Friends of The Costume Institute Gifts, 2017                           http://www.metmuseum.org/art/collection/search/744211 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
445067 445067 2017.45 0 0 744213 Costume Institute 8 Shirt 5887 Shirt British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 fall/winter 1985–1986 1985 1986 cotton, linen, mother-of-pearl 62236   Purchase, The Dorothy Strelsin Foundation Inc. Gift, 2017                           http://www.metmuseum.org/art/collection/search/744213 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
445069 445069 2017.44 0 0 744215 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 spring/summer 1986 1986 1986 wool 15104   Purchase, The Dorothy Strelsin Foundation Inc. Gift, 2017                           http://www.metmuseum.org/art/collection/search/744215 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
445070 445070 2017.46 0 0 744216 Costume Institute 8 Jacket 4399 Jacket British 6         Designer 5   John Galliano British, born Gibraltar, 1960   Galliano John 5328   1960 2060 spring/summer 1993 1993 1993 viscose, polyamide, elastane 62237   Purchase, The Dorothy Strelsin Foundation Inc. Gift, 2017                           http://www.metmuseum.org/art/collection/search/744216 4/23/2018 8:00:01 AM 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 2869.479ms · Data license: CC0 · Data source: metmuseum/openaccess