MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Alpha Sort = 31427

View and edit SQL

Suggested facets: Department, Object Name, Object Date, Object Begin Date, Object End Date, Credit Line, 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
232716 49.92.17 0 1 360467 Drawings and Prints 11 Drawing 23 St. Peter's, drum, interior, elevation (recto) St. Peter's, drum, pedestal, section (verso)           Artist 2 Attributed to Etienne DuPérac French, ca. 1535–1604   DuPérac, Etienne 31427 French 2 1535 1604 early to mid-16th century 1500 1560 Dark brown ink, black chalk, and incised lines 34909 sheet: 22 5/8 x 17 3/16 in. (57.4 x 43.7 cm) Gift of Janos Scholz and Anne Bigelow Scholz, in memory of Flying Officer Walter Bigelow Rosen, RCAF, 1949                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
232791 49.92.92 0 1 360542 Drawings and Prints 11 Drawing 23 St. Peter's, dome and drum, interior section and elevation, and labeled details (recto); St. Peter's, moulding profiles, details (verso)           Artist 2 Attributed to Etienne DuPérac French, ca. 1535–1604   DuPérac, Etienne 31427 French 2 1535 1604 early to mid-16th century 1500 1560 Pen and brown ink, black chalk, and incised lines 36865 sheet: 11 13/16 x 17 5/16 in. (30 x 44 cm) Gift of Janos Scholz and Anne Bigelow Scholz, in memory of Flying Officer Walter Bigelow Rosen, RCAF, 1949 49.92.92                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
236600 49.92.92 (Mich pal) 0 1 364509 Greek and Roman Art 12 Drawing 23 Half-Section of the Model of the Attic and Dome of Saint Peter's Basilica as Conceived by Michelangelo (recto); Detail Studies Relating to the Plan, Section, and Elevation of the Dome of Saint Peter's Basilica (verso).               Etienne DuPérac     DuPérac, Etienne 31427   1535 1604 1551, 1558–69 1551 1569 Pen and brown ink, over leadpoint or black chalk. 37457 sheet: 11 3/4 x 17 5/16 in. (29.8 x 44 cm) Gift of Janos Scholz and Anne Bigelow Scholz, in memory of Flying Officer Walter Bigelow Rosen, RCAF, 1949                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
236602 41.72(3.26) 0 1 364511 Drawings and Prints 11 Print 731 Speculum Romanae Magnificentiae: Longitudinal Section Showing the Interior of Saint Peter's Basilica as Conceived by Michelangelo (Published in 1569)           Artist 2   Etienne DuPérac French, ca. 1535–1604   DuPérac, Etienne 31427 French 2 1535 1604 1551, 1558–61 1551 1561 Etching with engraving 30388 sheet: 13 1/4 x 18 3/4 in. (33.7 x 47.6 cm) Rogers Fund, Transferred from the Library, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
236604 41.72(3.24) 0 1 364513 Drawings and Prints 11 Print 731 Speculum Romanae Magnificentiae: Elevation Showing the Exterior of Saint Peter's Basilica from the South as Conceived by Michelagelo (Published in 1569)           Artist 2   Etienne DuPérac French, ca. 1535–1604   DuPérac, Etienne 31427 French 2 1535 1604 1558–61 1558 1561 Engraving with etching 37638 sheet: 13 5/16 x 18 1/8 in. (33.8 x 46.1 cm) Rogers Fund, Transferred from the Library, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
266131 41.72(1.14) 0 1 395099 Drawings and Prints 11 Print 731 View of the Campidoglio as re-designed by Michelangelo from the 'Speculum Romanae Magnificentiae'         Speculum Romanae Magnificentiae 159 Artist 2   Etienne DuPérac French, ca. 1535–1604   DuPérac, Etienne 31427 French 2 1535 1604 1569 1569 1569 Etching and engraving 6712 Mount: 18 1/8 × 22 1/4 in. (46 × 56.5 cm) Sheet: 15 15/16 × 21 3/4 in. (40.5 × 55.2 cm) Plate: 14 13/16 × 21 5/8 in. (37.6 × 55 cm) Rogers Fund, Transferred from the Library, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
274066 41.72(1.15) 0 1 403238 Drawings and Prints 11 Print 731 Speculum Romanae Magnificentiae: View of the Roman Capitol           Artist 2   Etienne DuPérac French, ca. 1535–1604   DuPérac, Etienne 31427 French 2 1535 1604 1569 1569 1569 Etching; second state of two 29783 sheet: 14 13/16 x 21 1/16 in. (37.6 x 53.5 cm) Rogers Fund, Transferred from the Library, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
274133 41.72(1.23) 0 1 403305 Drawings and Prints 11 Print 731 Speculum Romanae Magnificentiae: Temples on the Isle of Tiber         Speculum Romae Magnificentiae 1506 Artist 2   Etienne DuPérac French, ca. 1535–1604   DuPérac, Etienne 31427 French 2 1535 1604 1582 1582 1582 Engraving and etching 29129 sheet: 18 1/8 x 21 15/16 in. (46.1 x 55.8 cm) plate: 15 3/8 x 19 1/2 in. (39.1 x 49.5 cm) Rogers Fund, Transferred from the Library, 1941                       Prints 13   Metropolitan Museum of Art, New York, NY 1
274515 41.72(3.29) 0 1 403687 Drawings and Prints 11 Print 731 Speculum Romanae Magnificentiae: Plan of St. Peter's           Artist 2   Etienne DuPérac French, ca. 1535–1604   DuPérac, Etienne 31427 French 2 1535 1604 1569 1569 1569 Engraving 7208 sheet: 18 9/16 x 16 5/16 in. (47.2 x 41.5 cm) Rogers Fund, Transferred from the Library, 1941                       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 150.687ms · Data license: CC0 · Data source: metmuseum/openaccess