MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

27 rows where Medium = 17467

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Role, Artist End Date, Object Date, Object Begin Date, Object End Date

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
77361 77361 38.139.1 0 0 101678 Costume Institute 8 Parasol 5976 Parasol probably French 203                           late 19th–early 20th century 1875 1925 silk, wood, metal 17467   Gift of Ann Payne Blumenthal, 1938                           http://www.metmuseum.org/art/collection/search/101678 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
79872 79872 1980.126.16 0 0 107441 Costume Institute 8 Parasol 5976 Parasol probably French 203                           1900–1910 1900 1910 silk, wood, metal 17467   Gift of Mrs. Alan L. Corey Jr., Mrs. William T. Newbold, and Mrs. A.G. Paine, II, 1980                           http://www.metmuseum.org/art/collection/search/107441 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
83571 83571 1978.88.16 0 0 116019 Costume Institute 8 Parasol 5976 Parasol American or European 48                           ca. 1900 1895 1905 silk, wood, metal 17467   Purchase, Friends of The Costume Institute Gifts, 1978                           http://www.metmuseum.org/art/collection/search/116019 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86344 86344 1979.244.1 0 0 121831 Costume Institute 8 Parasol 5976 Parasol American or European 48                           ca. 1900 1895 1905 silk, wood, metal 17467   Gift of William L. Maloney, executor for Estate of Katherine Litz, American Dancer, 1979                           http://www.metmuseum.org/art/collection/search/121831 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86378 86378 1983.110 0 1 121902 Costume Institute 8 Parasol 5976 Parasol American 1                           ca. 1885 1880 1890 silk, wood, metal 17467   Gift of Francesco de'Rogati in memory of Irma Catani de'Rogati, 1983                           http://www.metmuseum.org/art/collection/search/121902 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86414 86414 1985.279 0 0 121943 Costume Institute 8 Parasol 5976 Parasol European 12                           fourth quarter 19th century 1875 1899 silk, wood, metal 17467   Gift of Gerda Frank in memory of her grandmother, Hulda Lesser, 1985                           http://www.metmuseum.org/art/collection/search/121943 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86755 86755 C.I.55.43.39 0 0 122513 Costume Institute 8 Parasol 5976 Parasol French 7                           early 20th century 1900 1950 silk, wood, metal 17467   Gift of Miss Agnes Miles Carpenter, 1955                           http://www.metmuseum.org/art/collection/search/122513 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86767 86767 C.I.60.13.3 0 0 122540 Costume Institute 8 Parasol 5976 Parasol American 1                           ca. 1900 1895 1905 silk, wood, metal 17467   Gift of Thomas Nichol Jr., 1960                           http://www.metmuseum.org/art/collection/search/122540 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86768 86768 C.I.60.13.4 0 0 122541 Costume Institute 8 Parasol 5976 Parasol American 1                           ca. 1900 1895 1905 silk, wood, metal 17467   Gift of Thomas Nichol, Jr., 1960                           http://www.metmuseum.org/art/collection/search/122541 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
86830 86830 1976.290.8a, b 0 0 122635 Costume Institute 8 Parasol 5976 Parasol French 7                           1920s 1920 1929 silk, wood, metal 17467   Gift of Mrs. Janet S. Kaffenburgh, in memory of my grandmother Mrs. Joseph Garson of Rochester, N.Y. (born June 5, 1864), 1976                           http://www.metmuseum.org/art/collection/search/122635 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
88579 88579 C.I.50.86.4a–c 0 0 133967 Costume Institute 8 Parasol 5976 Parasol British 6                           early 20th century 1900 1925 silk, wood, metal 17467   Gift of Mr. Elisha Dyer, 1950                           http://www.metmuseum.org/art/collection/search/133967 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91136 91136 2009.300.2337 0 1 157151 Costume Institute 8 Parasol 5976 Parasol probably British 233                           1885 1885 1885 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Evelyn Eaves and Emma Eaves Alyea in memory of their mother, Elizabeth Predmore Eaves, 1940                           http://www.metmuseum.org/art/collection/search/157151 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91149 91149 2009.300.2349 0 0 157164 Costume Institute 8 Parasol 5976 Parasol British 6                           1902 1902 1902 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Alice Pentlarge, 1944                           http://www.metmuseum.org/art/collection/search/157164 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91152 91152 2009.300.2351 0 1 157167 Costume Institute 8 Parasol 5976 Parasol American 1         Department Store 208   Stern Brothers American, founded New York, 1867   Stern Brothers 5945 American 1 1867 2001 ca. 1870 1868 1872 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Lillian E. Glenn Peirce in memory of Mrs. Luther G. Tillotson, 1944                           http://www.metmuseum.org/art/collection/search/157167 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91155 91155 2009.300.2354 0 1 157170 Costume Institute 8 Parasol 5976 Parasol American 1                           1880–90 1880 1890 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Euphemia C. van Holland in memory of Mrs. Henry van Holland, 1945                           http://www.metmuseum.org/art/collection/search/157170 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91160 91160 2009.300.2359 0 0 157175 Costume Institute 8 Parasol 5976 Parasol French 7         Designer 5   Lyon     Lyon 7124       1890–99 1890 1899 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. C. D. Waters, 1945                           http://www.metmuseum.org/art/collection/search/157175 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91209 91209 2009.300.2402a, b 0 0 157224 Costume Institute 8 Umbrella 6126 Umbrella American 1         Manufacturer|Designer 18   Paragon|Martin     Paragon|Martin 7133       1900–1915 1900 1915 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Anonymous gift, 1954                           http://www.metmuseum.org/art/collection/search/157224 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91286 91286 2009.300.2472 0 1 157301 Costume Institute 8 Parasol 5976 Parasol American 1                           ca. 1870 1868 1872 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of John Redd, 1959                           http://www.metmuseum.org/art/collection/search/157301 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91298 91298 2009.300.2483a, b 0 0 157313 Costume Institute 8 Parasol 5976 Parasol American 1                           1890–99 1890 1899 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Madeleine Tamburro, 1960                           http://www.metmuseum.org/art/collection/search/157313 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91877 91877 2009.300.3022 0 1 157914 Costume Institute 8 Parasol 5976 Parasol American 1                           1845–55 1845 1855 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. John Francis Feely, 1941                           http://www.metmuseum.org/art/collection/search/157914 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
91891 91891 2009.300.3036 0 1 157928 Costume Institute 8 Parasol 5976 Parasol European 12         Manufacturer 20   G. Fox & Company American, founded 1847   G. Fox & Company 7226 American 1 1847 9999 1885–90 1885 1890 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Marion Grant, 1943                           http://www.metmuseum.org/art/collection/search/157928 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
92006 92006 2009.300.3139 0 1 158043 Costume Institute 8 Umbrella 6126 Umbrella American 1                           1888 1888 1888 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Seitz, 1951                           http://www.metmuseum.org/art/collection/search/158043 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
92070 92070 2009.300.3197 0 1 158107 Costume Institute 8 Parasol 5976 Parasol American 1                           1850–59 1850 1859 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Alicia Braddon in memory of Miss E. S. Gilbert, 1959                           http://www.metmuseum.org/art/collection/search/158107 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
92176 92176 2009.300.3292 0 1 158213 Costume Institute 8 Parasol 5976 Parasol American 1                           1886 1886 1886 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Amelia Beard Hollenback, 1966                           http://www.metmuseum.org/art/collection/search/158213 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
92202 92202 2009.300.3316 0 0 158239 Costume Institute 8 Mourning Parasol 6631 Mourning parasol American 1                           1915–18 1915 1918 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Frederick H. Prince, Jr., 1967                           http://www.metmuseum.org/art/collection/search/158239 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
92233 92233 2009.300.3343 0 0 158270 Costume Institute 8 En tout cas 6630 En tout cas American 1         Department Store 208   B. Altman & Co. American, 1865–1990   B. Altman & Co. 5543 American 1 1865 1990 1910–20 1910 1920 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of the trustees of Mary Flagler Cary Charitable Trust, 1969                           http://www.metmuseum.org/art/collection/search/158270 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
92238 92238 2009.300.3348 0 0 158275 Costume Institute 8 Umbrella 6126 Umbrella American 1         Manufacturer|Manufacturer|Manufacturer 302   National|George W. Welsh's Son|Gorham Manufacturing Company American, 1831–present   National|Welsh's Son George W.|Gorham Manufacturing Company 7278 American 1 1831 9999 1905–20 1905 1920 silk, wood, metal 17467   Brooklyn Museum Costume Collection at The Metropolitan Museum of Art, Gift of the Brooklyn Museum, 2009; Gift of Mrs. Philip J. Roosevelt, 1969                           http://www.metmuseum.org/art/collection/search/158275 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 82.043ms · Data license: CC0 · Data source: metmuseum/openaccess