MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

3 rows where Artist Role = 3028

View and edit SQL

Suggested facets: Object Name, 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, City, 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
226088 41.100.495 0 0 353693 Drawings and Prints 11 Book 97 Architecture ou Art de bien bastir de Marc Vitruve Pollion autheur romain antique: mis Latin en Francois, par Ian Martin Secretaire de Monseigneur le Cardinal de Lenoncourt           Author|Printer|Translator|Author 3028 Written by|Printed and published by|Translated by|Commentary written by Marcus Pollio Vitruvius|Hiérosme de Marnef and Guillaume Cavellat|Jean Martin|Jean Goujon Roman, active late 1st century B.C.|French, died 1553|French, ca. 1510–ca. 1565 Bologna (?) , Paris Vitruvius, Marcus|Marnef, Hiérosme de and Guillaume Cavellat|Martin, Jean|Goujon, Jean 27418 Italian|French|French|French 1207 -0100 |1505 0001 |1553 |1565 1572 1572 1572 Printed book with woodcut illustrations 33727 Overall: 13 7/8 x 9 3/16 x 1 1/4 in. (35.2 x 23.4 x 3.1 cm) Bequest of W. Gedney Beatty, 1941   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
226089 41.100.496 0 0 353694 Drawings and Prints 11 Book 97 Architecture ou Art de bien bastir de Marc Vitruve Pollion autheur romain antique: mis Latin en Francois, par Ian Martin Secretaire de Monseigneur le Cardinal de Lenoncourt           Author|Printer|Translator|Author 3028 Written by|Printed and published by|Translated by|Commentary written by Marcus Pollio Vitruvius|Hiérosme de Marnef and Guillaume Cavellat|Jean Martin|Jean Goujon Roman, active late 1st century B.C.|French, died 1553|French, ca. 1510–ca. 1565 Bologna (?) , Paris Vitruvius, Marcus|Marnef, Hiérosme de and Guillaume Cavellat|Martin, Jean|Goujon, Jean 27418 Italian|French|French|French 1207 -0100 |1505 0001 |1553 |1565 1572 1572 1572 Printed book with woodcut illustrations 33727 Overall: 14 1/8 x 9 13/16 x 1 in. (35.8 x 24.9 x 2.6 cm) Bequest of W. Gedney Beatty, 1941   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
245484 41.100.289 0 0 373699 Drawings and Prints 11 Book ; Ornament and Architecture 13814 A New Treatise of Architecture, according to Vitruvius. Wherein is discoursed of the five orders of columns, viz. The Tuscan, Dorick, Ionick, Corinthian, and Composite.           Author|Printer|Translator|Author 3028 Written and Edited by|Printed by|Translated and published by|After treatise written by Julien Mauclerc|J. Darby|Robert Pricke|Jacopo [Giacomo] Barozzi da Vignola French, 1543–ca. 1598|London|British, ca. 1642–1708|Italian, Vignola 1507–1573 Rome   Mauclerc, Julien|Darby, J.|Pricke Robert|Vignola, Jacopo [Giacomo] Barozzi da 34522 French|British|British|Italian 2758 1543 |1650 |1642 |1507 1598 |1750 |1708 |1573 1669 1669 1669 Illustrations: engraving 28942 16 1/8 x 11 5/8 x 1 in. (41 x 29.5 x 2.5 cm) Bequest of W. Gedney Beatty, 1941   London 14                   Books|Ornament & Architecture 665   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 130.79ms · Data license: CC0 · Data source: metmuseum/openaccess