MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, Artist Display Name, Artist Display Bio, Artist Alpha Sort, 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
66827 66827 1996.193a, b 0 0 79415 Costume Institute 8 Boots 5898 Boots British 6         Designer 5   Mary Quant British, born London, 1936   Quant, Mary 5407 British 7 1936 2036 1965 1965 1965 plastic, synthetic 15231   Gift of Harold Koda, 1996                           http://www.metmuseum.org/art/collection/search/79415 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
66842 66842 1997.59.7a, b 0 0 79430 Costume Institute 8 Suit 5876 Suit British 6         Designer 5   Barbara Hulanicki British, born 1936   Hulanicki Barbara 5413 British 7 1936 2036 ca. 1972 1967 1977 synthetics 15103   Gift of the Estate of Luciana Martinez de la Rosa, 1997                           http://www.metmuseum.org/art/collection/search/79430 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
67043 67043 1997.462 0 0 79643 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Mary Quant British, born London, 1936   Quant, Mary 5407 British 7 1936 2036 ca. 1968 1963 1973 wool 15104   Gift of Sylvia Mann Rose in Memory of George Mann, 1997                           http://www.metmuseum.org/art/collection/search/79643 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
69737 69737 C.I.69.10.1 0 0 83351 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Mary Quant British, born London, 1936   Quant, Mary 5407 British 7 1936 2036 1966–67 1966 1967 wool 15104   Gift of Maxime McKendry (Mrs. John McKendry), 1969                           http://www.metmuseum.org/art/collection/search/83351 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
70402 70402 1989.336a–c 0 0 84354 Costume Institute 8 Ensemble 5875 Ensemble British 6         Designer 5   Mary Quant British, born London, 1936   Quant, Mary 5407 British 7 1936 2036 ca. 1968 1963 1973 wool, acetate 16214   Gift of Paula A. Heidelman, 1989                           http://www.metmuseum.org/art/collection/search/84354 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74773 74773 1981.338.2 0 0 95300 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Mary Quant British, born London, 1936   Quant, Mary 5407 British 7 1936 2036 1965–68 1965 1968 PVC vinyl 17040   Gift of Patricia Healy Dunbar, 1981                           http://www.metmuseum.org/art/collection/search/95300 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
77234 77234 2005.374.13a, b 0 0 101182 Costume Institute 8 Shoes 5896 Shoes British 6         Designer 5   Barbara Hulanicki British, born 1936   Hulanicki Barbara 5413 British 7 1936 2036 ca. 1969 1964 1974 a,b) leather, synthetic 17114   Gift of Rosalind Jacobs, 2005                           http://www.metmuseum.org/art/collection/search/101182 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
79200 79200 C.I.69.10.2 0 0 105703 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Mary Quant British, born London, 1936   Quant, Mary 5407 British 7 1936 2036 1966–67 1966 1967 wool 15104   Gift of Maxime McKendry (Mrs. John McKendry), 1969                           http://www.metmuseum.org/art/collection/search/105703 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83178 83178 2005.94.1 0 0 115274 Costume Institute 8 Jacket 4399 Jacket British 6         Designer 5   Barbara Hulanicki British, born 1936   Hulanicki Barbara 5413 British 7 1936 2036 ca. 1969 1964 1974 cotton, silk, synthetic 16451   Gift of Bernice Shaftan, 2005                           http://www.metmuseum.org/art/collection/search/115274 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83179 83179 2005.94.2 0 0 115275 Costume Institute 8 Coat 4973 Coat British 6         Designer 5   Barbara Hulanicki British, born 1936   Hulanicki Barbara 5413 British 7 1936 2036 ca. 1969 1964 1974 cotton 3340   Gift of Bernice Shaftan, 2005                           http://www.metmuseum.org/art/collection/search/115275 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83180 83180 2005.94.3 0 0 115276 Costume Institute 8 T-shirt 6487 T-shirt British 6         Designer 5   Barbara Hulanicki British, born 1936   Hulanicki Barbara 5413 British 7 1936 2036 ca. 1969 1964 1974 cotton, synthetic 15314   Gift of Bernice Shaftan, 2005                           http://www.metmuseum.org/art/collection/search/115276 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83181 83181 2005.94.4 0 0 115277 Costume Institute 8 Bracelet 119 Bracelet British 6         Designer 5   Barbara Hulanicki British, born 1936   Hulanicki Barbara 5413 British 7 1936 2036 ca. 1969 1964 1974 metal 6962   Gift of Bernice Shaftan, 2005                           http://www.metmuseum.org/art/collection/search/115277 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
455967 455967 2017.721 0 0 768838 Costume Institute 8 Dress 5877 Dress British 6         Designer 5   Mary Quant British, born London, 1936   Quant, Mary 5407   1936 2036 ca. 1966 1961 1969 wool 15104   Purchase, The Dorothy Strelsin Foundation Inc. Gift, 2017                           http://www.metmuseum.org/art/collection/search/768838 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 1922.454ms · Data license: CC0 · Data source: metmuseum/openaccess