MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 59580

View and edit SQL

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

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
411220 14.1.8 0 0 677666 Drawings and Prints 11 Print 731 The Woodcutter           Artist|Engraver|Publisher|Publisher|Publisher 2228 After George Morland|William Ward|Daniel Orme|T. F. Tomkins|Elizabeth Walker British, London 1763–1804 London|British, London 1766–1826 London|British, Manchester 1766–1837 Buxton, Derbyshire|London|British, active 1789–1813   Morland, George|Ward, William|Orme, Daniel|Tomkins, T. F.|Walker, Elizabeth 51879 British|British|British|British|British 394 1763 |1766 |1766 |1792 |1789 1804 |1826 |1837 |1792 |1813 February 1, 1792 1792 1792 Mezzotint, printed in color and hand-colored 59580 Plate: 17 13/16 × 21 3/4 in. (45.3 × 55.3 cm) Sheet: 18 7/16 × 23 1/4 in. (46.8 × 59 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411226 14.1.12 0 0 677694 Drawings and Prints 11 Print 731 Rubbing Down the Post Horse           Artist|Publisher|Engraver 1303 After George Morland|John Raphael Smith|John Raphael Smith British, London 1763–1804 London|British, baptized Derby 1751–1812 Doncaster|British, baptized Derby 1751–1812 Doncaster   Morland, George|Smith, John Raphael|Smith, John Raphael 51876 British|British|British 178 1763 |1751 |1751 1804 |1812 |1812 1794 1794 1794 Mezzotint, printed in color and hand-colored 59580 Plate: 12 11/16 × 14 13/16 in. (32.3 × 37.6 cm) Sheet: 13 7/8 × 16 5/8 in. (35.3 × 42.3 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411227 14.1.13 0 0 677695 Drawings and Prints 11 Print 731 Watering the Cart Horse           Artist|Publisher|Engraver 1303 After George Morland|John Raphael Smith|John Raphael Smith British, London 1763–1804 London|British, baptized Derby 1751–1812 Doncaster|British, baptized Derby 1751–1812 Doncaster   Morland, George|Smith, John Raphael|Smith, John Raphael 51876 British|British|British 178 1763 |1751 |1751 1804 |1812 |1812 1794 1794 1794 Mezzotint, printed in color and hand-colored 59580 Plate: 12 13/16 × 14 7/8 in. (32.5 × 37.9 cm) Sheet: 14 1/16 × 16 5/8 in. (35.7 × 42.1 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411233 14.1.18 0 0 677723 Drawings and Prints 11 Print 731 Cottage Family           Artist|Engraver|Publisher 1036 After George Morland|John Raphael Smith|John Raphael Smith British, London 1763–1804 London|British, baptized Derby 1751–1812 Doncaster|British, baptized Derby 1751–1812 Doncaster   Morland, George|Smith, John Raphael|Smith, John Raphael 51876 British|British|British 178 1763 |1751 |1751 1804 |1812 |1812 February 1, 1803 1803 1803 Mezzotint, printed in color and hand-colored 59580 Sheet (trimmed to plate): 21 3/16 × 16 1/16 in. (53.8 × 40.8 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411236 14.1.23 0 0 677801 Drawings and Prints 11 Print 731 The Turnpike Gate           Artist|Engraver|Publisher 1036 After George Morland|William Ward|James Linnell British, London 1763–1804 London|British, London 1766–1826 London|British, 1759–1836   Morland, George|Ward, William|Linnell, James 51886 British|British|British 178 1763 |1766 |1759 1804 |1826 |1836 June 4, 1806 1806 1806 Mezzotint, printed in color and hand-colored 59580 Plate: 18 15/16 × 24 1/16 in. (48.1 × 61.1 cm) Sheet: 19 7/16 × 26 3/16 in. (49.4 × 66.5 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411238 14.1.27 0 0 677803 Drawings and Prints 11 Print 731 The Country Stable           Artist|Engraver|Publisher|Publisher|Publisher 2228 After George Morland|William Ward|Daniel Orme|J. F. Tomkins|Elizabeth Walker British, London 1763–1804 London|British, London 1766–1826 London|British, Manchester 1766–1837 Buxton, Derbyshire|active London 1789–1800|British, active 1789–1813   Morland, George|Ward, William|Orme, Daniel|Tomkins, J. F.|Walker, Elizabeth 51888 British|British|British|British|British 394 1763 |1766 |1766 |1789 |1789 1804 |1826 |1837 |1800 |1813 March 1, 1792 1792 1792 Mezzotint, printed in color and hand-colored 59580 Plate (covered at bottom): 18 7/8 × 23 13/16 in. (48 × 60.5 cm) Sheet: 19 7/8 × 24 3/4 in. (50.5 × 62.8 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411256 14.1.29 0 0 677827 Drawings and Prints 11 Print 731 The Country Butcher           Engraver|Publisher|Artist 2136 After Thomas Gosse|John Raphael Smith|George Morland British, 1765–1844|British, baptized Derby 1751–1812 Doncaster|British, London 1763–1804 London   Gosse, Thomas|Smith, John Raphael|Morland, George 51898 British|British|British 178 1765 |1751 |1763 1844 |1812 |1804 October 25, 1802 1802 1802 Mezzotint, printed in color and hand-colored 59580 Plate: 17 13/16 × 21 3/4 in. (45.3 × 55.3 cm) Sheet: 20 3/16 × 24 13/16 in. (51.3 × 63 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411257 14.1.37 0 0 677828 Drawings and Prints 11 Print 731 The Enamour'd Sportsman           Artist|Engraver|Publisher 1036 After George Morland|John Raphael Smith|John Raphael Smith British, London 1763–1804 London|British, baptized Derby 1751–1812 Doncaster|British, baptized Derby 1751–1812 Doncaster   Morland, George|Smith, John Raphael|Smith, John Raphael 51876 British|British|British 178 1763 |1751 |1751 1804 |1812 |1812 1801 1801 1801 Mezzotint, printed in color and hand-colored 59580 Sheet (trimmed to image): 17 5/16 in. × 22 in. (44 × 55.9 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   Metropolitan Museum of Art, New York, NY 1
411285 42.119.21 0 0 677873 Drawings and Prints 11 Print 731 The Contented Waterman           Artist|Engraver|Publisher 1036 After George Morland|William Ward|Philip Cornman British, London 1763–1804 London|British, London 1766–1826 London|British, 1754–after 1800   Morland, George|Ward, William|Cornman, Philip 51911 British|British|British 178 1763 |1766 |1754 1804 |1826 |1850 September 10, 1790 1790 1790 Mezzotint, printed in color and hand-colored 59580 Sheet (trimmed to plate and inlaid): 15 5/8 × 17 11/16 in. (39.7 × 44.9 cm) Gertrude and Thomas Jefferson Mumford Collection, Gift of Dorothy Quick Mayer, 1942                       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 135.794ms · Data license: CC0 · Data source: metmuseum/openaccess