MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Role = 4017

View and edit SQL

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

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
241657 41.100.407 0 0 369802 Drawings and Prints 11 Book 97 Dell'architettura libri dieci di M. Vitruvio Pollione tradotti e comentati dal marchese Berardo Galiani Napolitano           Author|Translator|Engraver|Publisher 4017 Written by|Translated and Commentary by|Engraved by|Published by Marcus Pollio Vitruvius|Berardo Galiani|C. Gianni|Alessandro Dozio Roman, active late 1st century B.C.|Italian, died 1771|Italian, active 19th century|Italian, active 19th c   Vitruvius, Marcus|Galiani, Berardo|Gianni, C.|Dozio, Alessandro 33686 Italian|Italian|Italian|Italian 315 -0100 |1700 |0019 |1800 0001 |1771 |0019 |1899 1832 1832 1832 Printed book with engraved illustrations and lithograph frontis 38477 Overall: 11 7/8 x 9 x 1 1/8 in. (30.1 x 22.8 x 2.9 cm) Bequest of W. Gedney Beatty, 1941   Milan 420                   Books 442   Metropolitan Museum of Art, New York, NY 1
243251 41.100.512 0 0 371430 Drawings and Prints 11 Book 97 Abregé des dix livres d'architecture de Vitruve           Author|Translator|Engraver|Publisher 4017 Written by|Translated and commentary by|Plates after engravings by|Published by Marcus Pollio Vitruvius|Claude Perrault|Sébastien Leclerc I|Jean Baptiste Coignard Roman, active late 1st century B.C.|French, 1613–1688|French, Metz 1637–1714 Paris|French, active 17th century   Vitruvius, Marcus|Perrault, Claude|Leclerc, Sébastien, I|Coignard, Jean Baptiste 34120 Italian|French|French|French 1207 -0100 |1613 |1637 |1600 0001 |1688 |1714 |1700 1674 [after 1682] 1674 1682 Printed book with woodcut head and tail pieces and engraved plates 38743 Overall: 6 3/4 x 4 1/8 x 15/16 in. (17.1 x 10.4 x 2.4 cm) Bequest of W. Gedney Beatty, 1941   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
243973 41.100.232 0 0 372180 Drawings and Prints 11 Book 97 Abregé des dix livres d'architecture de Vitruve           Author|Translator|Engraver|Publisher 4017 Written by|Translated and commentary by|Plates after engravings by|Published by Marcus Pollio Vitruvius|Claude Perrault|Sébastien Leclerc I|Jean Baptiste Coignard Roman, active late 1st century B.C.|French, 1613–1688|French, Metz 1637–1714 Paris|French, active 17th century   Vitruvius, Marcus|Perrault, Claude|Leclerc, Sébastien, I|Coignard, Jean Baptiste 34120 Italian|French|French|French 1207 -0100 |1613 |1637 |1600 0001 |1688 |1714 |1700 1674 [after 1682] 1674 1682 Printed book with woodcut head and tail pieces and engraved plates 38743 Overall: 6 5/8 x 4 x 15/16 in. (16.8 x 10.2 x 2.4 cm) Bequest of W. Gedney Beatty, 1941   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
441755 38.501(3) 0 0 738362 Drawings and Prints 11 Book 97 Essays on Physiognomy for the Promotion of the Knowledge and the Love of Mankind           Author|Translator|Engraver|Publisher 4017   Johann Caspar Lavater|Thomas Holcroft|James Heath|G. G. J. & J. Robinson Swiss, Zurich 1741–1801 Zurich|British, 1745–1809|British, London 1757–1834 London|London   Lavater, Johann Caspar|Holcroft, Thomas|Heath, James|Robinson, G. G. J & J. 56314   1741 |1745 |1757 |1780 1801 |1809 |1834 |1811 1789 1789 1789 Illustrations: engraving 28942 9 1/4 × 5 7/8 × 1 15/16 in. (23.5 × 15 × 5 cm) Bequest of Mary Martin, 1938                       Books 442   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 128.281ms · Data license: CC0 · Data source: metmuseum/openaccess