MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Nationality = 1569

View and edit SQL

Suggested facets: 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
221828 28.94.17 0 0 349387 Drawings and Prints 11 Book 97 Kronica von der loblichen Eydtgnoschaft Ir Harkomen und sust selstsam strittenn und Geschichten           Author|Printer|Artist 750 Written by|Printed by Peterman Etterlyn|Michael Furter|Master DS Swiss, active Lucerne, died 1509 (?)|German, 1494–1517|Swiss, active 1503–1515   Etterlyn, Peterman|Furter, Michael|Master DS 24202 Swiss|German|Swiss 1569 1400 |1494 |1503 1500 |1517 |1515 December 24, 1507 1507 1507 Woodcuts 30622 Overall: 10 15/16 x 7 7/8 x 1 in. (27.8 x 20 x 2.6 cm) Harris Brisbane Dick Fund, 1928   Basel 550                   Books 442   Metropolitan Museum of Art, New York, NY 1
221931 30.110.1-2 0 0 349491 Drawings and Prints 11 Book 97 Zwölf Bilderbogen für die Jugend. Erstes-Zweites Heft           Publisher|Artist|Printer 1318 Published by|Printed by Ferdinand Riehm|Adrian Ludwig Richter|Ferdinand Riehm Swiss|German, Dresden 1803–1884 Dresden|Swiss   Riehm, Ferdinand|Richter, Adrian Ludwig|Riehm, Ferdinand 24271 Swiss|German|Swiss 1569 1803 1884 ca. 1890 1885 1895   Overall: 15 1/16 x 11 15/16 x 3/16 in. (38.2 x 30.4 x 0.4 cm) Harris Brisbane Dick Fund, 1930                       Books 442   Metropolitan Museum of Art, New York, NY 1
221933 45.42.1 0 0 349493 Drawings and Prints 11 Book 97 II) Icones Clarorum Virorum Germaniae, Angliae, Galliae, Ungariae           Printer|Author|Author|Illustrator 2375 Printed by|Written by|Written by|Illustrated by Conrad von Waldkirch|Theodor Zwinger|Nicolaus Reusner|Tobias Stimmer Swiss, 1583–1616|German, 1533–1588|Swiss, Schaffhausen 1539–1584 Strasbourg I) Waldkirch, Conrad von|Zwinger, Theodor|Reusner, Nicolaus|Stimmer, Tobias 24273 Swiss|German|Swiss 1569 1583 |1533 |1539 1616 |1588 |1584 February 1589 1589 1589 Printed book with woodcut illustrations 33727 Overall: 6 3/4 x 4 7/16 x 1 15/16 in. (17.2 x 11.2 x 5 cm) Harris Brisbane Dick Fund, 1945                       Books 442   Metropolitan Museum of Art, New York, NY 1
268909 2011.465 0 0 397981 Drawings and Prints 11 Print 731 Portrait of Johann Wolfgang von Goethe in Profile           Artist|Sitter|Author 4594   Johann Heinrich Lips|Johann Wolfgang von Goethe|Johann Caspar Lavater Swiss, Kloten 1758–1817 Zurich|German, Frankfurt am Main 1749–1832 Weimar, Saxe-Weimar|Swiss, Zurich 1741–1801 Zurich   Lips, Johann Heinrich|Goethe, Johann Wolfgang von|Lavater, Johann Caspar 39790 Swiss|German|Swiss 1569 1758 |1749 |1741 1817 |1832 |1801 1774 1774 1774 Etching 26137 sheet: 10 5/16 x 12 1/16 in. (26.2 x 30.7 cm) plate: 7 7/8 x 9 1/8 in. (20 x 23.2 cm) Purchase, Thomas and Lore Firman Gift, 2011                       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 139.218ms · Data license: CC0 · Data source: metmuseum/openaccess