MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where "Artist Begin Date" is on date -4707-02-08 and Is Highlight = 1

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, 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
68318 1973.104.2a, b 1 0 81122 Costume Institute 8 Evening dress 5874 Evening dress French 7         Designer 5   Madame Grès (Alix Barton) French, Paris 1903–1993 Var region   Grès, Madame 5274 French 2 1903 1993 1958 1958 1958 silk 15101   Gift of Mrs. Leon L. Roos, 1973                           Metropolitan Museum of Art, New York, NY 1
68832 C.I.58.25a–c 1 0 81692 Costume Institute 8 Evening ensemble 5879 Evening ensemble American 1         Designer 5   Gilbert Adrian American, Naugatuck, Connecticut 1903–1959 Hollywood, California   Adrian, Gilbert 5267 American 1 1903 1959 1945 1945 1945 silk 15101   Gift of Eleanor Lambert, 1958                           Metropolitan Museum of Art, New York, NY 1
163375 1987.1100.482 1 1 265556 Photographs 13 Photograph 997 Penny Picture Display, Savannah           Artist 2   Walker Evans American, St. Louis, Missouri 1903–1975 New Haven, Connecticut   Evans, Walker 13548 American 1 1903 1975 1936 1936 1936 Gelatin silver print 14941 24.7 x 19.3 cm (9 3/4 x 7 5/8 in.) Ford Motor Company Collection, Gift of Ford Motor Company and John C. Waddell, 1987                       Photographs 21   Metropolitan Museum of Art, New York, NY 1
163718 1988.1030 1 0 265903 Photographs 13 Photograph 997 Kitchen Corner, Tenant Farmhouse, Hale County, Alabama           Artist 2   Walker Evans American, St. Louis, Missouri 1903–1975 New Haven, Connecticut   Evans, Walker 13548 American 1 1903 1975 1936 1936 1936 Gelatin silver print 14941 Image: 7 11/16 × 6 5/16 in. (19.5 × 16.1 cm) Mount: 7 11/16 × 6 5/16 in. (19.5 × 16.1 cm) Purchase, The Horace W. Goldsmith Foundation Gift, through Joyce and Robert Menschel, 1988                       Photographs 21 © Walker Evans Archive, The Metropolitan Museum of Art Metropolitan Museum of Art, New York, NY 1
169743 1994.245.135 1 0 272071 Photographs 13 Polaroid 13013 [Abandoned House]           Artist 2   Walker Evans American, St. Louis, Missouri 1903–1975 New Haven, Connecticut   Evans, Walker 13548 American 1 1903 1975 1973–74 1973 1974 Instant color print 26120 7.9 x 7.9 cm (3 1/8 x 3 1/8 in.) Purchase, Samuel J. Wagstaff Jr. Bequest and Lila Acheson Wallace Gift, 1994                       Photographs 21 © Walker Evans Archive, The Metropolitan Museum of Art Metropolitan Museum of Art, New York, NY 1
179199 1999.237.4 1 0 282778 Photographs 13 Photograph 997 [Floyd and Lucille Burroughs on Porch, Hale County, Alabama]           Artist 2   Walker Evans American, St. Louis, Missouri 1903–1975 New Haven, Connecticut   Evans, Walker 13548 American 1 1903 1975 1936 1936 1936 Gelatin silver print 14941 18.9 x 23.7 cm (7 7/16 x 9 5/16 in.) Purchase, Marlene Nathan Meyerson Family Foundation Gift, in memory of David Nathan Meyerson; and Pat and John Rosenwald and Lila Acheson Wallace Gifts, 1999                       Photographs 21 © Walker Evans Archive, The Metropolitan Museum of Art Metropolitan Museum of Art, New York, NY 1
336823 1985.63.5 1 0 484362 Modern and Contemporary Art 4 Painting 69 No. 13 (White, Red on Yellow)           Artist 2   Mark Rothko American (born Russia), Dvinsk 1903–1970 New York   Rothko, Mark 44829 American, born Russia 18 1903 1970 1958 1958 1958 Oil and acrylic with powdered pigments on canvas 51609 95 1/4 × 81 3/8 in. (241.9 × 206.7 cm) Gift of The Mark Rothko Foundation Inc., 1985                       Paintings 11 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
344202 2007.95 1 0 494589 Modern and Contemporary Art 4 Sculpture 100 Oval Form with Strings and Color           Artist 2   Barbara Hepworth British, 1903–1975   Hepworth, Barbara 47415 British 7 1903 1975 1966 1966 1966 Elmwood and painted Elmwood with cotton strings 53601 33 7/16 x 22 7/16 x 21 5/8 in. (85 x 57 x 55 cm) Purchase, Gift of Hon. and Mrs. Peter I. B. Lavan, by exchange, 2007                       Sculpture 12 © Bowness, Hepworth Estate 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 1280.009ms · Data license: CC0 · Data source: metmuseum/openaccess