MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 30617

View and edit SQL

Suggested facets: Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Credit Line, City

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
209268 1974.672.18 0 0 336649 Drawings and Prints 11 Print 731 High Life           Artist|Engraver|Publisher 1036 After Sir Edwin Henry Landseer|Christopher C. Hollyer|Henry Graves & Company British, London 1802–1873 London|British, active ca. 1863–ca. 1873|London   Landseer, Edwin Henry, Sir|Hollyer, Christopher C.|Graves, Henry & Company 18493 British|British|British 178 1802 |1840 |1820 1873 |1900 |1899 October 17, 1873 1870 1875 Etching and mezzotint 30617 Image: 18 7/8 × 14 15/16 in. (47.9 × 38 cm) Sheet: 23 1/4 × 17 11/16 in. (59 × 45 cm) Bequest of Anna Hyatt Huntington, 1974   London|Washington D.C. 1056                   Prints 13   Metropolitan Museum of Art, New York, NY 1
209270 1974.672.19 0 0 336651 Drawings and Prints 11 Print 731 Hafed           Artist|Artist|Publisher|Printer 1205 After Sir Edwin Henry Landseer|John Cother Webb|Henry Graves & Company|Alfred Holdgate British, London 1802–1873 London|British, Torquay, Devon, 1855–1927|London|London   Landseer, Edwin Henry, Sir|Webb, John Cother|Graves, Henry & Company|Holdgate, Alfred 18495 British|British|British|British 177 1802 |1855 |1820 |1855 1873 |1927 |1899 |1930 September 1, 1886 1880 1890 Etching and mezzotint 30617 Sheet: 24 x 29 3/8 in. (61 x 74.6 cm) Image: 17 11/16 x 23 3/8 in. (45 x 59.4 cm) Plate: 20 7/16 x 26 1/8 in. (51.9 x 66.4 cm) Bequest of Anna Hyatt Huntington, 1974   London 14                   Prints 13   Metropolitan Museum of Art, New York, NY 1
209272 1974.672.20 0 0 336653 Drawings and Prints 11 Print 731 Death of the Wild Bull (Scene in Chillingham Park)           Artist|Engraver|Publisher|Publisher 1035 After|Published Washington DC Sir Edwin Henry Landseer|Thomas Landseer|Henry Graves & Company|William Schaus British, London 1802–1873 London|British, London 1795–1880 London|London|American, 1821–1892   Landseer, Edwin Henry, Sir|Landseer, Thomas|Graves, Henry & Company|Schaus, William 18497 British|British|British|American 881 1802 |1795 |1820 |1821 1873 |1880 |1899 |1892 February 2, 1874 1870 1875 Etching and mezzotint 30617 Sheet: 26 7/16 x 25 3/4 in. (67.1 x 65.4 cm) Image: 24 5/16 x 23 7/8 in. (61.8 x 60.7 cm) Bequest of Anna Hyatt Huntington, 1974   Washington D.C. 1058                   Prints 13   Metropolitan Museum of Art, New York, NY 1
267073 1995.411.154 0 0 396110 Drawings and Prints 11 Print 731 Their Appointed Rounds           Artist 2   John Sloan American, Lock Haven, Pennsylvania 1871–1951 Hanover, New Hampshire   Sloan, John 2529 American 1 1871 1951 1938 1938 1938 Etching and mezzotint 30617 Plate: 5 1/2 × 6 15/16 in. (13.9 × 17.7 cm) Sheet: 8 × 10 in. (20.3 × 25.4 cm) Gift of Ernest Shapiro and Family, 1995                       Prints 13 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
267074 1995.411.155 0 0 396111 Drawings and Prints 11 Print 731 The Shell of Hell!           Artist 2   John Sloan American, Lock Haven, Pennsylvania 1871–1951 Hanover, New Hampshire   Sloan, John 2529 American 1 1871 1951 1939 1939 1939 Etching and mezzotint 30617 Plate: 5 in. × 3 15/16 in. (12.7 × 10 cm) Sheet: 11 3/4 × 8 7/8 in. (29.8 × 22.5 cm) Gift of Ernest Shapiro and Family, 1995                       Prints 13 © 2018 Artists Rights Society (ARS), New York Metropolitan Museum of Art, New York, NY 1
392844 58.549.160 0 0 645102 Drawings and Prints 11 Print 731 Mary, Queen of Scots on the scaffold           Sitter|Artist|Artist 4432 After Mary, Queen of Scots|Narcisse-Edmond-Joseph Desmadryl|Louis Boulanger Linlithgow 1542–1587 Fotheringhay, England|French, Lille 1801–ca. 1890 Valparaíso, Chile|French, 1807–1867 Dijon   Mary Queen of Scots|Desmadryl, Narcisse-Edmond-Joseph|Boulanger, Louis 50018 Scottish|French|French 3558 1542 |1801 |1807 1587 |1890 |1867 19th century 1800 1899 Etching and mezzotint 30617 Plate: 8 1/8 × 5 15/16 in. (20.7 × 15.1 cm) Sheet: 10 3/8 × 6 7/8 in. (26.3 × 17.4 cm) Gift of Susan Dwight Bliss, 1958                       Prints 13   Metropolitan Museum of Art, New York, NY 1
399644 24.63.1864 0 0 654105 Drawings and Prints 11 Print 731 Bolton Abbey in Olden TIme           Artist|Engraver|Dedicatee|Publisher 1206 After Sir Edwin Henry Landseer|Samuel Cousins|William Spencer Cavendish, 6th Duke of Devonshire|Thomas Boys British, London 1802–1873 London|British, Exeter 1801–1887 London|British, 1790–1858|London   Landseer, Edwin Henry, Sir|Cousins, Samuel|Cavendish, William Spencer, 6th Duke of Devonshire|Boys, Thomas 18499 British|British|British 178 1802 |1801 |1790 |1800 1873 |1887 |1858 |1880 May 8, 1837 1830 1840 Etching and mezzotint 30617 Plate: 19 3/4 × 23 5/8 in. (50.2 × 60 cm) Sheet: 21 1/16 × 25 3/16 in. (53.5 × 64 cm) Gift of Georgiana W. Sargent, in memory of John Osborne Sargent, 1924   London 14                   Prints 13   Metropolitan Museum of Art, New York, NY 1
434628 1986.1180.1145 0 0 722549 Drawings and Prints 11 Print 731 A Journey by Night           Artist 2   Sir George Clausen British, London 1852–1944 Newbury, Berkshire   Clausen, George Sir 55313   1852 1944 before 1905 1900 1905 Etching and mezzotint 30617 Plate: 4 3/4 × 6 1/4 in. (12 × 15.8 cm) Sheet: 7 3/4 × 11 3/16 in. (19.7 × 28.4 cm) Bequest of Grace M. Pugh, 1985                       Prints 13   Metropolitan Museum of Art, New York, NY 1
457586 51.648.79 0 0 772981 Drawings and Prints 11 Print 731 Moonlight on a River, Lucerne           Artist|Etcher 1324 After Joseph Mallord William Turner|Sir Frank Short British, London 1775–1851 London|British, Stourbridge, West Midlands 1857–1945 Ditchling, East Sussex   Turner, Joseph Mallord William|Short, Frank Sir 58689   1775 |1857 1851 |1945 1896 1896 1896 Etching and mezzotint 30617 Plate: 8 7/16 × 11 1/4 in. (21.4 × 28.5 cm) Sheet: 11 13/16 × 16 7/8 in. (30 × 42.8 cm) Gift of Edwin De T. Bechtel, 1951                       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 102.87ms · Data license: CC0 · Data source: metmuseum/openaccess