MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Nationality = 1516

View and edit SQL

Suggested facets: Artist Role, Artist Prefix, Artist Display Bio, Artist Begin Date, Artist End Date

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
221171 25.30.34 0 0 348713 Drawings and Prints 11 Book 97 La Vita de Philosophi           Author|Publisher 44 Written by|Published for ("ad petitione di") Laertius Diogenes|Ser Piero Pacini da Pescia, active Florence ca. 1495-1514 Roman, active 3rd century A.D.   Diogenes, Laertius|Pacini, Piero 23772 Roman|Italian 1516 0200 0300 February 22, 1505 1505 1505 Printed book with woodcut illustration. 34117   Harris Brisbane Dick Fund, 1925   Florence 562                   Books 442   Metropolitan Museum of Art, New York, NY 1
224793 27.189.1 0 0 352387 Drawings and Prints 11 Book 97 Nelle Historie di Trogo Pompeo           Author|Publisher 44 Written by|Published by Marcus Junianus Justinus|Bernardino de Bindoni Roman, 3rd century or later A.D. , Venice Justinus, Marcus Junianus|Bindoni, Bernardino de 26495 Roman|Italian 1516 0200 0300 1542 1542 1542     Rogers Fund, 1927                       Books 442   Metropolitan Museum of Art, New York, NY 1
224800 31.54.699 0 0 352394 Drawings and Prints 11 Book 97 Opus...Satirae           Author|Publisher 44 Written by|Published by Decimus Junius Juvenal|Giovanni Taccuino Aquinum 55/60?–?127/140|Italian, active 1492–1536 , Venetiis Juvenal, Decimus Junius|Taccuino, Giovanni 26501 Roman|Italian 1516 0055 |1492 0140 |1536 August 18, 1512 1512 1512 Printed book with 16 woodcut illustrations. 35452   Bequest of James Clark McGuire, 1930                       Books 442   Metropolitan Museum of Art, New York, NY 1
227341 46.132.2 0 0 354959 Drawings and Prints 11 Book 97 Metamorphoseos vulgare           Author|Printer 1012 Written by|Printed by Ovid|Alexander Minutianus Roman, Sulmo 43 B.C.–A.D. 17 Tomis, Moesia , Milan, for the brothers de Lignani Ovid|Minutianus, Alexander 28278 Roman|Italian 1516 -0043 0017 April 8, 1519 1519 1519 Printed book with woodcut illustrations 33727 11 13/16 × 8 9/16 × 1 in. (30 × 21.8 × 2.6 cm) Harris Brisbane Dick Fund, 1946                       Books 442   Metropolitan Museum of Art, New York, NY 1
227346 41.108 0 0 354964 Drawings and Prints 11 Book 97 Metamorphoses           Author|Editor|Publisher 1533 Written by|Commentary by|Published by Ovid|Raphael Regius|Francesco de Silva Roman, Sulmo 43 B.C.–A.D. 17 Tomis, Moesia , Turin Ovid|Regius, Raphael|Silva, Francesco de 28283 Roman|Italian 1516 -0043 0017 December 15, 1504 1504 1504     Harris Brisbane Dick Fund, 1941                       Books 442   Metropolitan Museum of Art, New York, NY 1
230139 56.522.46 0 0 357815 Drawings and Prints 11 Book 97 Comoediae nunc primum italicis versibus redditae cum personarum figuris aeri accurate incisis           Author|Publisher 44 Written by|Published by Terence (Publius Terentius Afer)|Hieronymus Mainardus Roman, 190 B.C.?–159 B.C. , Urbino Terence (Publius Terentius Afer)|Mainardus, Hieronymous 30221 Roman|Italian 1516 -0190 -0159 1736 1736 1736   16 5/8 × 11 5/8 × 1 9/16 in. (42.2 × 29.5 × 4 cm) Transferred from the Library, 1956                       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 109.248ms · Data license: CC0 · Data source: metmuseum/openaccess