MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

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

View and edit SQL

Suggested facets: Department, Object Name, Title, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Object Begin Date, Object End Date, Medium, Dimensions, 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
68338 C.I.51.83 1 0 81142 Costume Institute 8 Cape 5042 "Apollo of Versailles" French 7         Designer 5   Elsa Schiaparelli Italian, 1890–1973   Schiaparelli Elsa 5266 Italian 6 1890 1973 winter 1938–39 1938 1939 silk, metallic 15565   Gift of Estate of Lady Mendl, 1951                           Metropolitan Museum of Art, New York, NY 1
164652 1992.5149 1 0 266850 Photographs 13 Photograph 997 [Brancusi's Studio]           Artist 2   Edward J. Steichen American (born Luxembourg), Bivange 1879–1973 West Redding, Connecticut   Steichen, Edward J. 13761 American, born Luxembourg 434 1879 1973 ca. 1920 1918 1922 Gelatin silver print 14941 24.4 x 19.4 cm (9 5/8 x 7 5/8 in.) Gift of Grace M. Mayer, 1992                       Photographs 21 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
165561 33.43.36 1 0 267775 Photographs 13 Photograph 997 Balzac, The Silhouette—4 A.M.           Artist 2   Edward J. Steichen American (born Luxembourg), Bivange 1879–1973 West Redding, Connecticut   Steichen, Edward J. 13761 American, born Luxembourg 434 1879 1973 1908 1908 1908 Gum bichromate print 26070 37.9 x 46 cm (14 15/16 x 18 1/8 in.) Alfred Stieglitz Collection, 1933                       Photographs 21 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
165589 33.43.39 1 0 267803 Photographs 13 Photograph 997 The Flatiron           Artist 2   Edward J. Steichen American (born Luxembourg), Bivange 1879–1973 West Redding, Connecticut   Steichen, Edward J. 13761 American, born Luxembourg 434 1879 1973 1904, printed 1909 1900 1909 Gum bichromate over platinum print 26212 47.8 x 38.4 cm (18 13/16 x 15 1/8 in.) Alfred Stieglitz Collection, 1933                       Photographs 21 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
165624 33.43.43 1 0 267838 Photographs 13 Photograph 997 The Flatiron           Artist 2   Edward J. Steichen American (born Luxembourg), Bivange 1879–1973 West Redding, Connecticut   Steichen, Edward J. 13761 American, born Luxembourg 434 1879 1973 1904 1904 1904 Gum bichromate over platinum print 26212 47.8 x 38.4 cm (18 13/16 x 15 1/8 in.) Alfred Stieglitz Collection, 1933                       Photographs 21 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
165625 33.43.44 1 0 267839 Photographs 13 Photograph 997 The Flatiron           Artist 2   Edward J. Steichen American (born Luxembourg), Bivange 1879–1973 West Redding, Connecticut   Steichen, Edward J. 13761 American, born Luxembourg 434 1879 1973 1904, printed 1905 1904 1904 Gum bichromate over platinum print 26212 49.9 x 38.9 cm (19 5/8 x 15 5/16 in.) Alfred Stieglitz Collection, 1933                       Photographs 21 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
165628 33.43.47 1 0 267842 Photographs 13 Photograph 997 The Big White Cloud, Lake George           Artist 2   Edward J. Steichen American (born Luxembourg), Bivange 1879–1973 West Redding, Connecticut   Steichen, Edward J. 13761 American, born Luxembourg 434 1879 1973 1903, printed 1904 1903 1903 Direct carbon print 26155 39.3 x 48.3 cm (15 1/2 x 19 in.) Alfred Stieglitz Collection, 1933                       Photographs 21 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
180961 2001.293 1 0 284572 Photographs 13 Photograph; Drawing 13070 Bingham Copper Mining Pit—Utah / Reclamation Project           Artist 2   Robert Smithson American, Passaic, New Jersey 1938–1973 Amarillo, Texas   Smithson, Robert 14732 American 1 1938 1973 1973 1973 1973 Photostat and plastic overlay with wax pencil 26364 47 x 34.3 cm (18 1/2 x 13 1/2 in.) Purchase, Pat and John Rosenwald Gift, 2001                       Photographs|Drawings 22   Metropolitan Museum of Art, New York, NY 1
338539 1992.391 1 0 486162 Modern and Contemporary Art 4 Painting 69 At the Lapin Agile           Artist 2   Pablo Picasso Spanish, Malaga 1881–1973 Mougins, France   Picasso, Pablo 6385 Spanish 76 1881 1973 1905 1905 1905 Oil on canvas 953 39 x 39 1/2 in. (99.1 x 100.3 cm) The Walter H. and Leonore Annenberg Collection, Gift of Walter H. and Leonore Annenberg, 1992, Bequest of Walter H. Annenberg, 2002                       Paintings 11 © 2018 Estate of Pablo Picasso / Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
339092 1996.403.1 1 0 486739 Modern and Contemporary Art 4 Painting 69 Reading at a Table           Artist 2   Pablo Picasso Spanish, Malaga 1881–1973 Mougins, France   Picasso, Pablo 6385 Spanish 76 1881 1973 1934 1934 1934 Oil on canvas 953 63 7/8 x 51 3/8 in. (162.2 x 130.5 cm) Bequest of Florene M. Schoenborn, in honor of William S. Lieberman, 1995                       Paintings 11 © 2018 Estate of Pablo Picasso / Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
340369 47.106 1 0 488221 Modern and Contemporary Art 4 Painting 69 Gertrude Stein           Artist 2   Pablo Picasso Spanish, Malaga 1881–1973 Mougins, France   Picasso, Pablo 6385 Spanish 76 1881 1973 1905–6 1905 1906 Oil on canvas 953 39-3/8 x 32 in. (100 x 81.3cm) Bequest of Gertrude Stein, 1946                       Paintings 11 © 2018 Estate of Pablo Picasso / Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
341156 60.87 1 0 489124 Modern and Contemporary Art 4 Painting 69 Seated Harlequin           Artist 2   Pablo Picasso Spanish, Malaga 1881–1973 Mougins, France   Picasso, Pablo 6385 Spanish 76 1881 1973 1901 1901 1901 Oil on canvas, lined and mounted to a sheet of pressed cork 52688 32 3/4 x 24 1/8 in. (83.2 x 61.3 cm) Purchase, Mr. and Mrs. John L. Loeb Gift, 1960                       Paintings 11 © 2018 Estate of Pablo Picasso / 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 1200.028ms · Data license: CC0 · Data source: metmuseum/openaccess