MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 825

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Medium, 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
179497 2005.100.382 (1-85) 0 1 283076 Photographs 13 Album 1119 [Emma Charlotte Dillwyn Llewelyn's Album]           Artist|Artist|Artist|Artist|Artist|Artist|Artist 825   John Dillwyn Llewelyn|Thereza Dillwyn Llewelyn|Jane Martha St. John|James Knight|Miss Bush|Peter Wickens Fry|M.D. British, Swansea, Wales 1810–1882 Swansea, Wales|British, 1803–1882|British|British, active 19th century|British, Compton Bishop, Somerset 1795–1860 London , et al Llewelyn, John Dillwyn|Llewelyn, Thereza Dillwyn|St., John Jane Martha|Knight, James|Bush Miss|Fry, Peter Wickens|M.D. 15723 British, Welsh|British|British|British|British 599 1810 |1803 |1795 1882 |1882 |1860-08-29 1853–56 1853 1856 128 salted paper prints and albumen silver prints from paper and glass negatives 26330 28.8 × 22.3 cm (11 5/16 × 8 3/4 in.) Gilman Collection, Gift of The Howard Gilman Foundation, 2005                       Albums 441   Metropolitan Museum of Art, New York, NY 1
182362 2005.100.583 (1–127) 0 0 286102 Photographs 13 Album 1119 [Franklin Blake Album]           Artist|Artist|Artist|Artist|Artist|Artist|Artist 825   John Thomson|Felice Beato|Milton M. Miller|Carleton E. Watkins|Sylvester Dutton|William Pryor Floyd|Lai Fong British, Edinburgh, Scotland 1837–1921 London|British (born Italy), Venice 1832–1909 Luxor, Egypt|American, active China, 1830–1899|American, 1829–1916|American, active China, 1824–1866|British, 1830–ca. 1900|Chinese, 1839–1890   Thomson, John|Beato, Felice|Miller, Milton|Watkins, Carleton E.|Dutton, Sylvester|Floyd, William Pryor|Lai, Fong 16085 British, Scottish|British, born Italy|American|American|American 637 1837 |1832 |1830 |1829 |1824 |1830 |1839 1921 |1909 |1899 |1916 |1866 |1905 |1890 ca. 1865–70 1863 1872 Albumen silver prints from glass negatives; salted paper prints from glass negatives 26414 Various: cdv to approx. 11 x 15 inches, some panoramas Gilman Collection, Purchase, Cynthia Hazen Polsky Gift, 2005                       Albums 441   Metropolitan Museum of Art, New York, NY 1
221570 69.671.3(1) 0 0 349125 Drawings and Prints 11 Book 97 Société des Eclectiques (Album for the first year, 1872–1873)           Artist|Artist|Artist|Artist|Artist|Artist|Artist 825   Aglaüs Bouvenne|Michel Charles Fichot|Karl Fichot|Emil Guillemin|Edmond Morin|E. (Paul) Rajon|Fréderic Réjamey French, Paris 1829–1903 Levallois-Perret|French, Troyes 1817–1903 Paris|French, 19th century|French, 19th century|French, Le Havre 1824–1882 Sceaux   Bouvenne, Aglaüs|Fichot, Michel Charles|Fichot, Karl|Guillemin, Emil|Morin, Edmond|Rajon, E. (Paul)|Réjamey, Fréderic 24023 French|French|French|French|French|French|French 321 1829 |1817 |1800 |1800 |1824 1903 |1903 |1900 |1900 |1882 1873 1873 1873 Etching, drypoint, facsimilie reproduction of handwriting 34935 8 7/8 x 11 1/4 x 1/2 in. (22.5 x 28.5 x 1.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1969, and Rogers Fund, 1969   Paris 27                   Books 442   Metropolitan Museum of Art, New York, NY 1
222002 1971.559.5 0 0 349562 Drawings and Prints 11 Book 97 Varie pitture a fresco de'principali maestri veneziani ora per la prima volta con le stampe pubblicate (Frescoes by the Most Important Venetian Masters Published in Print for the First Time)           Artist|Artist|Artist|Artist|Artist|Artist|Artist 825 After|After|After|After|After Giorgione|Titian (Tiziano Vecellio)|Jacopo Tintoretto (Jacopo Robusti)|Giambattista Zelotti|Paolo Veronese (Paolo Caliari)|Joannes de Plano|Antonio Maria Zanetti II Italian, Castelfranco Veneto 1477/78–1510 Venice|Italian, Pieve di Cadore ca. 1485/90?–1576 Venice|Italian, Venice 1518/19–1594 Venice|Italian, Verona 1526–1578 Mantua|Italian, Verona 1528–1588 Venice|Spanish, active ca. 1778|Italian, 1706–1778   Giorgione|Titian (Tiziano Vecellio)|Tintoretto, Jacopo (Jacopo Robusti)|Zelotti, Giambattista|Veronese, Paolo (Paolo Caliari)|de Plano, Joannes|Maria Zanetti, Antonio II 24323 Italian|Italian|Italian|Italian|Italian|Spanish|Italian 1590 1477 |1485 |1518 |1526 |1528 |1773 |1706 1510 |1576 |1594 |1578 |1588 |1783 |1778 1760 1760 1760 Etching 26137 19 7/8 × 14 3/16 × 13/16 in. (50.5 × 36 × 2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1971                       Books 442   Metropolitan Museum of Art, New York, NY 1
267906 51.501.4892 0 1 396950 Drawings and Prints 11 Print 731 Five numbered scenes, each after a painter in the Accademia Degl'Incamminati, from IL FUNERALE D'AGOSTINO CARRACCIO FATTO IN BOLOGNA SUA PATRIA DAGL'INCAMINATI Academici del Disegno: 1. Ceres lamenting the death of Carracci before Jupiter, painted by Ippolito Ferrantini; 2. Personification of Painting entrusting Carracci's body to Fame, painted by Giovanni Battista Bertusi; 3. The Fates leading the blindfolded Carracci to the foot of Jupiter's throne, painted by Lucio Massari; 4. Three rivers representing the cities of Bologna, Rome and Parma (Reno, Tiber and Parma) with Fame at left, designed by Sebastiano Razzali and painted by Baldessare Aloisi Galanini; 5. Agostino Carracci abducted by Mars who is jealous of the artist's portrait of Adonis made for a Farnese gallery panel, painted by Giovanni Battista Busi.         IL FUNERALE D'AGOSTIN CARRACCIO FATTO IN BOLOGNA SUA PATRIA DAGL'INCAMINATI Academici del Disegno 1565 Artist|Artist|Artist|Artist|Artist|Artist|Artist 825 After|After|After|After|After|After Guido Reni|Giovanni Battista Bertusi|Ippolito Ferrantini|Lucio Massari|Baldassare Aloisi Galanini|Sebastiano Razzali|Giovanni Battista Busi Italian, Bologna 1575–1642 Bologna|Italian, Bologna 1577–1644 Bologna|Italian, active Bologna ca. 1594–1603|Italian, Bologna 1569–1633 Bologna|Italian, Bologna 1577–1638 Rome|Italian, active Bologna ca. 1571–1602|Italian, active ca. 1603–1688   Reni, Guido|Bertusi, Giovanni Battista|Ferrantini, Ippolito|Massari, Lucio|Aloisi Galanini, Baldassare|Razzali, Sebastiano|Busi, Giovanni Battista 39581 Italian|Italian|Italian|Italian|Italian|Italian|Italian 1232 1575 |1577 |1589 |1569 |1577 |1566 |1598 1642 |1644 |1608 |1633 |1638 |1607 |1693 1603 1603 1603 Etching 26137 Sheet (Trimmed): 4 3/4 × 4 5/8 in. (12 × 11.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
379130 45.78.126 0 0 625284 Drawings and Prints 11 Print 731 Saints among clouds, surrounded by putti, from 'Di Tutti gli Affresco del Correggio in Parma'           Artist|Artist|Artist|Artist|Artist|Artist|Artist 825 After|Intermediary draughtsman|Intermediary draughtsman|Intermediary draughtsman Correggio (Antonio Allegri)|Paolo Toschi|Carlo Raimondi|Luigi Margotti|Antonio Costa|Carlo Raimondi|Giovanni Battista Callegari Italian, Correggio, active by 1514–died 1534 Correggio|Italian, Parma 1788–1854 Parma|Italian, Bocche di Cattoro 1809–1883 Parma|Italian, Faenza 1813–1872|Italian, Parma 1804–1875 Venice|Italian, Bocche di Cattoro 1809–1883 Parma|Italian, 1785–1855   Correggio (Antonio Allegri)|Toschi, Paolo|Raimondi, Carlo|Margotti, Luigi|Costa, Antonio|Raimondi, Carlo|Callegari, Giovanni Battista 48717 Italian|Italian|Italian|Italian|Italian 836 1514 |1788 |1809 |1813 |1804 |1809 |1785 1534 |1854 |1883 |1872 |1875 |1883 |1855 ca. 1846 1841 1851 Etching and engraving 6712 Sheet: 27 15/16 in. × 34 in. (71 × 86.3 cm) Plate: 20 11/16 × 21 3/4 in. (52.5 × 55.2 cm) Gift of Alice C. Taft, Hope Smith, Marianna F. Taft, Helen Head, and Brockholst M. Smith, 1945                       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 144.118ms · Data license: CC0 · Data source: metmuseum/openaccess