MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where "Artist End Date" is on date -4707-04-26 and Artist Role = 3

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Credit Line

Artist End Date (date) ✖

  • -4707-04-26 · 10 ✖
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
70169 70169 C.I.59.16.6a, b 0 0 84021 Costume Institute 8 Cocktail Ensemble 5952 Cocktail ensemble American 1         Designer|Manufacturer 3   Anne Fogarty|Margot, Inc. American, Pittsburgh, Pennsylvania 1919–1980 New York|American   Fogarty, Anne|Margot, Inc. 5897 American|American 5 1919 1980 fall/winter 1955–56 1955 1956 wool, silk 15161   Gift of Miss Anne Fogarty, 1959                           http://www.metmuseum.org/art/collection/search/84021 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
74295 74295 C.I.59.16.4 0 0 94631 Costume Institute 8 Evening dress 5874 Evening dress American 1         Designer|Manufacturer 3   Anne Fogarty|Margot, Inc. American, Pittsburgh, Pennsylvania 1919–1980 New York|American   Fogarty, Anne|Margot, Inc. 5897 American|American 5 1919 1980 fall/winter 1952–53 1952 1953 metallic cloth, cotton 16964   Gift of Miss Anne Fogarty, 1959                           http://www.metmuseum.org/art/collection/search/94631 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334013 334013 1974.373.1ab 0 0 481227 Modern and Contemporary Art 4 Vase with tray 15088 "Girls Playing Ball", Vase with Tray           Designer|Manufacturer 3   Edward Hald|Orrefors Glasbruk Swedish, Stockholm 1883–1980   Hald, Edward|ORREFORS 44895 Swedish|Swedish 819 1883 1980 designed 1920, manufactured 1927 1920 1927 Engraved glass 23831 a) H. 9-3/16, Diam. 10-15/16 in. (23.3 x 27.8 cm.); b) Diam. 11-9/16 in. (29.4 cm.) Gift of Peter M. Brant, 1974                       Glass 3   http://www.metmuseum.org/art/collection/search/481227 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334014 334014 1974.373.2 0 0 481228 Modern and Contemporary Art 4 Bowl 106 Bowl           Designer|Manufacturer 3   Edward Hald|Orrefors Glasbruk Swedish, Stockholm 1883–1980   Hald, Edward|ORREFORS 44895 Swedish|Swedish 819 1883 1980 ca. 1925 1925 1925 Glass 31 H. 4-3/16, Diam. 8 in. (10.6 x 20.3 cm.) Gift of Peter M. Brant, 1974                       Glass 3   http://www.metmuseum.org/art/collection/search/481228 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334015 334015 1974.373.3ab 0 0 481229 Modern and Contemporary Art 4 Cup with cover 4351 Masquerade Ball           Designer|Manufacturer 3   Edward Hald|Orrefors Glasbruk Swedish, Stockholm 1883–1980   Hald, Edward|ORREFORS 44895 Swedish|Swedish 819 1883 1980 ca. 1925 1925 1925 Engraved glass 23831 H. (with cover) 13-3/4 Diam. 4-1/2 in. (34.9 x 11.4 cm.) Gift of Peter M. Brant, 1974                       Glass 3   http://www.metmuseum.org/art/collection/search/481229 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339692 339692 24.176.3ab 0 0 487387 Modern and Contemporary Art 4 Cup with cover 4351 Music           Designer|Manufacturer 3   Edward Hald|Orrefors Glasbruk Swedish, Stockholm 1883–1980   Hald, Edward|ORREFORS 44895 Swedish|Swedish 819 1883 1980 1918 1918 1918 Glass 31 H. 14 7/8 in. (37.8 cm.) Purchase, Edward C. Moore Jr. Gift, 1924                       Glass 3 © 2018 Artists Rights Society (ARS), New York http://www.metmuseum.org/art/collection/search/487387 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339853 339853 27.96.2ab 0 0 487595 Modern and Contemporary Art 4 Cup with cover 4351 "Music" Covered Cup           Designer|Manufacturer 3   Edward Hald|Orrefors Glasbruk Swedish, Stockholm 1883–1980   Hald, Edward|ORREFORS 44895 Swedish|Swedish 819 1883 1980 1926 1926 1926 Glass 31 H. 13 3/4, Diam. 4 1/2 in. (34.9 x 11.4 cm.) Purchase, Edward C. Moore Jr. Gift, 1927                       Glass 3   http://www.metmuseum.org/art/collection/search/487595 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339854 339854 27.96.3ab 0 0 487596 Modern and Contemporary Art 4 Vase with tray 15088 Cactus Exhibition (Kaktusutstallningen)           Designer|Manufacturer 3   Edward Hald|Orrefors Glasbruk Swedish, Stockholm 1883–1980   Hald, Edward|ORREFORS 44895 Swedish|Swedish 819 1883 1980 1926 1926 1926 Glass 31 Vase: H. 7-1/4, Diam. 7-5/8 in. (18.4 x 19.4 cm.); Tray: Diam. 8-3/4 in. (22.2 cm.) Purchase, Edward C. Moore Jr. Gift, 1927                       Glass 3   http://www.metmuseum.org/art/collection/search/487596 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339858 339858 27.96.8 0 0 487601 Modern and Contemporary Art 4 Vase 7 Graal Glass           Designer|Manufacturer 3   Edward Hald|Orrefors Glasbruk Swedish, Stockholm 1883–1980   Hald, Edward|ORREFORS 44895 Swedish|Swedish 819 1883 1980 1926 1926 1926 Glass, Graal technique 52470 H. 7-1/2 in. (19.1 cm.) Purchase, Edward C. Moore Jr. Gift, 1927                       Glass 3   http://www.metmuseum.org/art/collection/search/487601 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
341001 341001 57.107 0 0 488953 Modern and Contemporary Art 4 Plate 356 "The Wind Rose"           Designer|Manufacturer 3   Edward Hald|Orrefors Glasbruk Swedish, Stockholm 1883–1980   Hald, Edward|ORREFORS 44895 Swedish|Swedish 819 1883 1980 1957, designed 1925 1957 1957 Engraved glass 23831 H. 2-7/16, Diam. 15-3/8 in. (6.2 x 39.1 cm.) Gift of A.B. Orrefors Glasbruk and Johann Beyer, 1957                       Glass 3   http://www.metmuseum.org/art/collection/search/488953 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 1951.339ms · Data license: CC0 · Data source: metmuseum/openaccess