MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where "Artist End Date" is on date -4707-04-22 and Is Highlight = 1

View and edit SQL

Suggested facets: Department, Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification, Rights and Reproduction

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
68315 C.I.50.110a–j 1 0 81119 Costume Institute 8 Wedding ensemble 6021 Wedding ensemble French 7         Designer 5   Mainbocher American, 1890–1976   Mainbocher 5498 American 1 1890 1976 1937 1937 1937 silk, leather, straw, coq feathers 15553   Gift of the Duchess of Windsor, 1950                           Metropolitan Museum of Art, New York, NY 1
162954 1987.1100.10 1 0 265133 Photographs 13 Photograph 997 Abstraction, Twin Lakes, Connecticut           Artist 2   Paul Strand American, New York 1890–1976 Orgeval, France   Strand, Paul 13851 American 1 1890 1976 1916 1916 1916 Silver-platinum print 26151 32.8 x 24.4 cm (12 15/16 x 9 5/8 in.) Ford Motor Company Collection, Gift of Ford Motor Company and John C. Waddell, 1987                       Photographs 21 ©1997, Aperture Foundation Inc., Paul Strand Archive. Metropolitan Museum of Art, New York, NY 1
163284 1987.1100.40 1 0 265465 Photographs 13 Photograph 997 Compass           Artist 2   Man Ray American, Philadelphia, Pennsylvania 1890–1976 Paris   Man Ray 13633 American 1 1890 1976 1920 1920 1920 Gelatin silver print 14941 11.7 x 8.6 cm (4 5/8 x 3 3/8 in.) Ford Motor Company Collection, Gift of Ford Motor Company and John C. Waddell, 1987                       Photographs 21 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
163970 1989.1135 1 0 266162 Photographs 13 Photograph 997 Rebecca, New York           Artist 2   Paul Strand American, New York 1890–1976 Orgeval, France   Strand, Paul 13851 American 1 1890 1976 ca. 1923 1921 1925 Palladium print 26088 19.4 x 24.6 cm (7 5/8 x 9 11/16 in.) Gift of Marilyn Walter Grounds, 1989                       Photographs 21 © 1997 Aperture Foundation Inc., Paul Strand Archive. Metropolitan Museum of Art, New York, NY 1
165534 33.43.334 1 0 267748 Photographs 13 Photograph 997 Blind Woman, New York           Artist 2   Paul Strand American, New York 1890–1976 Orgeval, France   Strand, Paul 13851 American 1 1890 1976 1916 1916 1916 Platinum print 26063 34 x 25.7 cm (13 3/8 x 10 1/8 in.) Alfred Stieglitz Collection, 1933                       Photographs 21 ©1997, Aperture Foundation Inc., Paul Strand Archive Metropolitan Museum of Art, New York, NY 1
169621 1997.25 1 0 271948 Photographs 13 Photograph 997 Harold Greengard, Twin Lakes, Connecticut           Artist 2   Paul Strand American, New York 1890–1976 Orgeval, France   Strand, Paul 13851 American 1 1890 1976 1916 1916 1916 Silver-platinum print 26151 Image: 24.2 × 31.6 cm (9 1/2 × 12 7/16 in.) Sheet: 24.9 × 32.3 cm (9 13/16 × 12 11/16 in.) Mount: 28 × 33.9 cm (11 in. × 13 3/8 in.) Ford Motor Company Collection, Purchase, Joseph Pulitzer Bequest and The Horace W. Goldsmith Foundation Gift through Joyce and Robert Menschel, and Gift of Ford Motor Company and John C. Waddell, by exchange, 1997                       Photographs 21 © 1997 Aperture Foundation Inc., Paul Strand Archive Metropolitan Museum of Art, New York, NY 1
179696 2005.100.140 1 0 283277 Photographs 13 Rayograph; Photogram 13026 Rayograph           Artist 2   Man Ray American, Philadelphia, Pennsylvania 1890–1976 Paris   Man Ray 13633 American 1 1890 1976 1923–28 1923 1928 Gelatin silver print 14941 Image: 49 x 39.8cm (19 5/16 x 15 11/16in.) Gilman Collection, Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 2005                       Photographs 21 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
341950 2006.32.15 1 0 490182 Modern and Contemporary Art 4 Painting 69 Gala Éluard           Artist 2   Max Ernst French (born Germany), Brühl 1891–1976 Paris   Ernst, Max 47060 French, born Germany 151 1891 1976 1924 1924 1924 Oil on canvas 953 32 x 25 3/4 in. (81.3 x 65.4 cm) The Muriel Kallis Steinberg Newman Collection, Gift of Muriel Kallis Newman, 2006                       Paintings 11 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
344205 2006.32.5 1 0 494703 Modern and Contemporary Art 4 Necklace 237 Necklace           Artist 2   Alexander Calder American, Philadelphia, Pennsylvania 1898–1976 New York   Calder, Alexander 37663 American 1 1898 1976 ca. 1940 1940 1940 Brass 12 21 1/4 x 22 x 10 in. (54 x 55.9 x 25.4 cm) The Muriel Kallis Steinberg Newman Collection, Gift of Muriel Kallis Newman, 2006                       Jewelry 10   Metropolitan Museum of Art, New York, NY 1
423520 N7433.4.B76 P43 1966 1 0 702543 The Libraries 20   Phantomas. 62. Marcel Broodthaers           Artist 2   Marcel Broodthaers Belgian, Brussels 1924–1976 Cologne   Broodthaers, Marcel 54002   1924 1976 1966 1966 1966   1 volume (unpaged) : illustrations ; Height: 9 1/16 in. (23 cm)     Brussels 1150     Belgium 576               © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
441485 170.1 AL1 Quarto 1 0 737721 The Libraries 20   Interaction of color           Author|Publisher 44   Josef Albers|Yale University Press American (born Germany), Bottrop 1888–1976 New Haven, Connecticut   Albers, Josef|Yale University Press 56264   1888 1976 1963 1963 1963   1 bound volume (80 p. : ill. ; 36 cm.), 1 portfolio (80 folders of col. ill. + "Commentary," 1 paperbound v. ; 36 cm.) : chiefly col. ill. ; in cloth-covered case ; Height: 14 9/16 in. (37 cm) Gift of Josef Albers (Copy 3)   New Haven 114     United States 3               © 2018 Artists Rights Society (ARS), New York 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 1102.22ms · Data license: CC0 · Data source: metmuseum/openaccess