MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Nationality = 10 and Department = 20 sorted by Artist Nationality

View and edit SQL

Suggested facets: Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Medium, Credit Line

Department

  • The Libraries · 6

Artist Nationality

  • German · 6
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
377845 125.97 D932 1 1 591824 The Libraries 20   "Alberti Dvreri pictoris et architecti praestantissimi De vrbibvs..." Paris: Officina Christiani Wecheli, 1535 6782         Author 41   Albrecht Dürer German, Nuremberg 1471–1528 Nuremberg   Dürer, Albrecht 9043 German 10 1471 1528 1535 1535 1535 Illustrated book 11174 78 pp.; H: 13 3/4 in. (35 cm) Purchased with income from the Jacob S. Rogers Fund                           Metropolitan Museum of Art, New York, NY 1
377851 254 B63 1 1 591830 The Libraries 20   Architectura Curiosa Nova: Das ist, neue ergotzliche Sinn und Kunstreiche auch nutzliche Bau- und Wasser-Kunst . . . Nuremberg : [s.n.], [1664] 6787         Author 41   Georg Andreas Böckler German, Cronheim 1644–1698 Ansbach   Böckler, Georg Andreas 48530 German 10 1644 1698 1664 1664 1664 Printed book, engraved plates 57664 4 pts. in 1 vol.; H: 13 3/8 in. (34 cm) Purchased with income from the Jacob S. Rogers Fund   Nuremberg 149                       Metropolitan Museum of Art, New York, NY 1
377855 912.1 K63 Q 1 1 591834 The Libraries 20   Athanasii Kircheri e Soc. Jesu China monumentis: qua sacris qua profanis, nec non variis naturae & artis spectaculis, aliarumque rerum memorabilium argumentis illustrata           Author 41   Athanasius Kircher German, 1602–1680   Kirchner Athanasius 48534 German 10 1602 1680 1667 1667 1667 Printed book 33728 H: 14 5/8 in. (37 cm) Jane E. Andrews Fund, in memory of her husband, William Loring Andrews   Amsterdam: Apud Joannem Janssonium a Waesberge 2413   & Elizeum Weyerstraet, 1667 1054                   Metropolitan Museum of Art, New York, NY 1
377865 221.1 K63 1 1 591844 The Libraries 20   Phonurgia nova, sive conjugium mechanico-physicum artis & natvrae paranympha phonosophia concinnatum . . . Campidonae: Rudolphum Dreherr, 1673 6797         Author 41   Athanasius Kircher German, 1602–1680   Kirchner Athanasius 48534 German 10 1602 1680 1673 1673 1673 Illustrated book 11174 H: 13 3/8 in. (34 cm) Purchased with income from the Jacob S. Rogers Fund and Bought with the income from the bequest of Nathaniel I. Bowditch, of Boston, (Class of 1812)                           Metropolitan Museum of Art, New York, NY 1
377870 532 L551 1 1 591849 The Libraries 20   Denkmaler aus Aegypten und Aethiopien: nach den Zeichnungen der von Deiner Majestat dem Konige von Preussen Friedrich Wilhelm IV Nach Diesen Landern Gesendeten und in den Jahren 1842–1845 Ausgefuhrten Wissenschaftlichen Expedition . . . Leipzig, 1897–1913 6802         Author|Author|Author 1666   Richard Lepsius|Édouard F. Naville|Ludwig Borchardt German, 1810–1884   Lepsius, Richard|Naville, Édouard F.|Borchardt, Ludwig 48544 German 10 1810 |1844 |1863 1884 |1926 |1938 1913 1913 1913 Illustrated books 57668 5 vols.; H: 25 1/4 in. (64 cm) Purchased with income from the Jacob S. Rogers Fund                           Metropolitan Museum of Art, New York, NY 1
377872 143.6 S92 1 1 591851 The Libraries 20   Collection Julien Gréau: verrerie antique, emaillerie et poterie appartenent à M. J. Pierpont Morgan Paris: [privately printed], 1903 (edition of 90) 6804         Author 41   Wilhelm Froehner German, 1834–1925   Froehner, Wilhelm 48546 German 10 1834 1925 1903 1903 1903 Hand-colored lithographs, printed texts 57669 Texts: 309 pp.; H: 12 1/4 in. (31 cm); 5 vols. of color pls.: H: 22 in. (56 cm) The Collection of Books on Classical Archaeology Bequeathed by Edward Robinson to The Metropolitan Museum of Art MCMXXXI for Use in the Classical Department.                           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 167.431ms · Data license: CC0 · Data source: metmuseum/openaccess