MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Nationality = 217

View and edit SQL

Suggested facets: Department, Object Name, Classification

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
74186 2003.410a–d 0 0 94335 Costume Institute 8 Ensemble 5875 Ensemble Swiss 54         Design House|Designer|Designer 211   Amok|Sandra Kuratle|Bally of Switzerland Swiss, founded 1996|Swiss, born 1966|Swiss, founded 1810 for|(Shoes) Amok|Kuratle Sandra|Bally of Switzerland 6183 Swiss|Swiss|Swiss 217 1996 |1966 |1810 9999 |2066 |9999 fall/winter 2003–4 2003 2004 a,b) cotton; c,d) leather, rubber, cotton 16944   Gift of Amok by Sandra Kuratle, 2003                           Metropolitan Museum of Art, New York, NY 1
222576 36.87.2 0 0 350137 Drawings and Prints 11 Book 97 Leben Georg Philipp Rugendas, und Johannes Kupezki           Artist|Author|Publisher 1001 Written by|Published by Johann Caspar Füssli the Elder|Johann Caspar Füssli the Elder|Johann Caspar Füssli the Elder Swiss, 1706–1782|Swiss, 1706–1782|Swiss, 1706–1782 , Zürich Füssli, Johann Caspar the Elder|Füssli, Johann Caspar the Elder|Füssli, Johann Caspar the Elder 24761 Swiss|Swiss|Swiss 217 1706 |1706 |1706 1782 |1782 |1782 1758 1758 1758 Etchings 28944 Overall: 8 1/4 x 6 5/16 x 3/8 in. (21 x 16 x 1 cm) Harris Brisbane Dick Fund, 1936   Zürich 437                   Books 442   Metropolitan Museum of Art, New York, NY 1
223462 1970.565.153 0 0 351040 Drawings and Prints 11 Book 97 Architecture Suisse, ou choix des maisons rustiques des Alpes du Canton de Berne           Designer|Designer|Publisher 1912 Designed by|Designed by|Published by Adolf von Graffenried|Gabriel Ludwig Rudolf von Stürler|J. J. Burgdorfer Swiss|Swiss   Graffenried, Adolf von|Stürler, Gabriel Ludwig Rudolf von|Burgdorfer, J. J. 25481 Swiss|Swiss|Swiss 217     1844 1844 1844     Gift of Lincoln Kirstein                       Books 442   Metropolitan Museum of Art, New York, NY 1
226475 32.87.4 0 0 354087 Drawings and Prints 11 Book 97 Missale Speciale noviter impressum           Artist|Artist|Printer 958 Printed by Master DS|Urs Graf|Jacob Wolff de Pforzheim Swiss, active 1503–1515|Swiss, Solothurn ca. 1485–1529/30 Basel|Swiss   Master DS|Graf, Urs|Pforzheim, Jacob Wolff de 27708 Swiss|Swiss|Swiss 217 1503 |1485 1515 |1529 February 10, 1519 1519 1519   Overall: 13 15/16 x 9 3/16 x 1 3/4 in. (35.4 x 23.3 x 4.5 cm) Harris Brisbane Dick Fund, 1932                       Books 442   Metropolitan Museum of Art, New York, NY 1
248477 2007.105 0 0 376781 Drawings and Prints 11 Print 731 The Artist's Wife, Elisabetha Graff, born Sulzer           Artist|Artist|Sitter 1046 After|Engraved by|Portrait of Anton Graff|Johann Rudolph Schellenburg|Elisabetha Graff, born Sulzer Swiss, Winterthur 1736–1813 Dresden|Swiss, 1740–1806|Swiss, 1753–1812   Graff, Anton|Schellenburg, Johann Rudolph|Graff, born Sulzer Elisabetha 35241 Swiss|Swiss|Swiss 217 1736 |1740 |1753 1813 |1806 |1812 after 1772 1772 1790 Etching 26137 plate: 9 1/8 x 6 3/4 in. (23.2 x 17.2 cm) sheet: 13 1/8 x 10 7/16 in. (33.3 x 26.5 cm) A. Hyatt Mayor Purchase Fund, Marjorie Phelps Starr Bequest, 2007                       Prints 13   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 166.864ms · Data license: CC0 · Data source: metmuseum/openaccess