MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where Medium = 15106

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Object Date, Object Begin Date, Object End 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
66423 1996.61.6a, b 0 0 78947 Costume Institute 8 Suit 5876 Suit American 1         Design House|Designer 198   Perry Ellis Sportswear Inc.|Perry Ellis American, founded 1978|American, 1940–1986   Ellis Perry Sportswear Inc.|Ellis Perry 5257 American 1 1978 |1940 9999 |1986 1981 1981 1981 linen, wool 15106   Gift of Roz Gerten Jacobs, 1996                           Metropolitan Museum of Art, New York, NY 1
69343 C.I.39.91.7a–c 0 0 82686 Costume Institute 8 Ensemble 5875 Ensemble Greek 777                           1890–1925 1890 1925 linen, wool 15106   Gift of Miss Irene Lewisohn and Mrs. Alice Lewisohn Crowley, 1939                           Metropolitan Museum of Art, New York, NY 1
72861 42.188.1 0 1 90834 Costume Institute 8 Skirt 1152 Skirt American 1                           ca. 1750 1745 1755 linen, wool 15106   Rogers Fund, 1942                           Metropolitan Museum of Art, New York, NY 1
74198 54.124 0 1 94440 Costume Institute 8 Dress 5877 Dress American 1                           mid-18th century 1725 1775 linen, wool 15106   Rogers Fund, 1954                           Metropolitan Museum of Art, New York, NY 1
76491 09.50.2668 0 0 98425 Costume Institute 8 Apron 1163 Apron Romanian 1922                           probably 19th century 1800 1899 linen, wool 15106   Rogers Fund, 1909                           Metropolitan Museum of Art, New York, NY 1
76495 09.50.2688 0 0 98429 Costume Institute 8 Apron 1163 Apron Romanian 1922                           19th century 1800 1899 linen, wool 15106   Rogers Fund, 1909                           Metropolitan Museum of Art, New York, NY 1
76499 09.50.2692 0 0 98433 Costume Institute 8 Apron 1163 Apron Romanian 1922                           19th century 1800 1899 linen, wool 15106   Rogers Fund, 1909                           Metropolitan Museum of Art, New York, NY 1
76500 09.50.2693 0 0 98434 Costume Institute 8 Apron 1163 Apron Romanian 1922                           probably 19th century 1800 1899 linen, wool 15106   Rogers Fund, 1909                           Metropolitan Museum of Art, New York, NY 1
87760 1972.103a, b 0 0 127005 Costume Institute 8 Ensemble 5875 Ensemble Spanish 13                           1900–1972 1900 1972 linen, wool 15106   Gift of Elizabeth Rogers Horan, 1972                           Metropolitan Museum of Art, New York, NY 1
87774 C.I.39.91.1a–d 0 0 127104 Costume Institute 8 Ensemble 5875 Ensemble Romanian 1922                           1800–1939 1800 1939 linen, wool 15106   Gift of Miss Irene Lewisohn and Alice Lewisohn Crowley, 1939                           Metropolitan Museum of Art, New York, NY 1
87829 C.I.50.60a, b 0 1 127328 Costume Institute 8 Sleeves 6268 Sleeves Spanish 13                           18th century 1700 1799 linen, wool 15106   Gift of Mrs. Aline Bernstein, 1950                           Metropolitan Museum of Art, New York, NY 1
89720 2009.300.1052a, b 0 0 155725 Costume Institute 8 Suit 5876 Suit French 7         Department Store|Designer 226   Outlook|Ted Lapidus French, Paris 1929–2008 Cannes   Outlook|Lapidus Ted 6880 American|French 26 1929 2008 1972–74 1972 1974 linen, wool 15106   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Roy R. Eddey, 1989                           Metropolitan Museum of Art, New York, NY 1
90885 2009.300.2102 0 1 156892 Costume Institute 8 Pocket 6330 Pocket American 1                           1750 1750 1750 linen, wool 15106   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; H. Randolph Lever Fund, 1967                           Metropolitan Museum of Art, New York, NY 1
91508 2009.300.2671 0 0 157524 Costume Institute 8 Textile 1143 Textile Slovak 1990                           1880–1910 1880 1910 linen, wool 15106   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Museum Expedition 1920 & 1921, Robert B. Woodward Memorial Fund, 1921                           Metropolitan Museum of Art, New York, NY 1
92767 2009.300.46 0 1 158993 Costume Institute 8 Shirt 5887 Shirt Bulgarian 1999                           1840–80 1840 1880 linen, wool 15106   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Museum Expedition 1920 & 1921, Robert B. Woodward Memorial Fund, 1921                           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 127.463ms · Data license: CC0 · Data source: metmuseum/openaccess