MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

3 rows where Artist Nationality = 913

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Suffix, 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
210556 21.36.8 0 1 337940 Drawings and Prints 11 Book 97 De Florum Cultura. Rome, 1633           Artist|Publisher|Designer|Engraver|Designer|Designer|Designer 1252 Published by|Designed by|Engraved by|Designed by|Designed by|Designed by Giovanni Battista Ferrari|Stephanus Paulinus|Anna Maria Vaiani|Johann Friedrich Greuter|Andrea Sacchi|Guido Reni|Pietro da Cortona (Pietro Berrettini) Italian, Siena 1584–1655 Siena|Italian, active 1620–30|German, active Rome, ca. 1590/93–1662|Italian, Rome (?) ca. 1599–1661 Rome|Italian, Bologna 1575–1642 Bologna|Italian, Cortona 1596–1669 Rome , Rome Ferrari, Giovanni Battista|Paulinus, Stephanus|Vaiani, Anna Maria|Greuter, Johann Friedrich|Sacchi, Andrea|Reni, Guido|Cortona, Pietro da (Pietro Berrettini) 18885 Italian|Italian|Italian|German|Italian|Italian|Italian 913 1584 |1620 |1590 |1599 |1575 |1596 1655 |1630 |1662 |1661 |1642 |1669 1633 1633 1633 Engraving, woodcut 31291 Overall: 9 13/16 x 6 11/16 x 1 13/16 in. (25 x 17 x 4.6 cm) Museum Accession, transferred from the Library, 1921   Rome 571                   Books 442   Metropolitan Museum of Art, New York, NY 1
223662 64.511 0 0 351243 Drawings and Prints 11 Book 97 Breve Racconto Della Trasportatione Del Corpo Di Papa Paolo V Dalla Basilica di S. Pietro a quella di S. Maria Maggiore           Author|Publisher|Designer|Engraver|Artist|Designer|Draftsman 2678 Written by|Published by heirs of|Designed by|Engraved by|Figures on catafalque sculpted by|Designed by|Drawn by Lelio Guidiccioni|Bartolomeo Zanetti|Sergius Venturi|Theodorus Crueger|Gian Lorenzo Bernini|Domenico Garzoli|Giovanni Lanfranco Italian, active 1609–23|Italian, active 17th century|born Hamburg, died Rome, 1625|Italian, Naples 1598–1680 Rome|Italian, active 17th century|Italian, Parma 1582–1647 Rome , Rome Guidiccioni, Lelio|Zanetti, Bartolomeo|Venturi, Sergius|Crueger, Theodorus|Bernini, Gian Lorenzo|Garzoli, Domenico|Lanfranco, Giovanni 25633 Italian|Italian|Italian|German|Italian|Italian|Italian 913 1600 |1600 |1598 |1600 |1582 1623 |1700 |1625 |1680 |1700 |1647 1623 1623 1623 Printed book with engraved illustrations 29332 12 13/16 x 9 5/8 x 1 1/4 in. (32.5 x 24.5 x 3.2 cm) Purchase, Anne and Carl Stern Gift   Rome 571                   Books 442   Metropolitan Museum of Art, New York, NY 1
228915 52.519.32 0 0 356554 Drawings and Prints 11 Book ; Ornament and architecture 13811 I Dieci libri d'architettura di Gio: Antonio Rusconi. Secondo i precetti di Vitruvio, novamenti ristampati, & accresciuti della Prattica degl'Horologi Solari           Author|Illustrator|Publisher|Dedicatee|Author|Editor|Author 3397 Text summarizes precepts of Giovanni Antonio Rusconi|Giovanni Antonio Rusconi|Francesco Nicolini|Duchess Sophia Dorothea Herzogin von Braunsweig-Lüneburg|Bernardino Stramegioli|Salustio Piobbici|Marcus Pollio Vitruvius ca. 1520–1587|ca. 1520–1587|German, 1666–1726|Italian|Italian|Roman, active late 1st century B.C. , Venice Rusconi, Giovanni Antonio|Rusconi, Giovanni Antonio|Nicolini, Francesco|Sophia Dorothea, Duchess|Stramegioli, Bernardino|Piobbici, Salustio|Vitruvius, Marcus 29348 Italian|Italian|Italian|German|Italian|Italian|Italian 913 1500 |1500 |1666 |-0100 1600 |1600 |1726 |0001 1669 (1660) 1660 1669 Printed book with woodcut illustrations 33727 11 1/2 x 8 1/16 x 1 1/8 in. (29.2 x 20.5 x 2.8 cm) Box: 12 5/8 x 9 1/16 x 1 7/8 in. (32 x 23 x 4.7 cm) Rogers Fund, 1952                       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 118.083ms · Data license: CC0 · Data source: metmuseum/openaccess