MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Portfolio = 1461

View and edit SQL

Suggested facets: Is Public Domain, Title, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions

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
263787 59.533.1019 0 1 392733 Drawings and Prints 11 Print 731 Miseries of Human Life: While Deep in Study and Lost in Thought in the Complicated Profession of a Taylor and All on a Sudden Disturbed by the Shrieks of a Woman Crying Cucumbers         Miseries of Human Life 1461 Artist|Publisher|Artist 867 After Thomas Rowlandson|Rudolph Ackermann, London|Nicolaus Heideloff British, London 1757–1827 London|active 1794–1829|British, 1761–1837   Rowlandson, Thomas|Ackermann, Rudolph|Heideloff, Nicolaus 38455 British|British|British 178 1757 |1764 |1761 1827 |1834 |1837 October 1807 1807 1807 Hand-colored etching 34862 Sheet: 12 5/8 × 9 1/8 in. (32 × 23.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
444740 59.533.1018 0 1 742747 Drawings and Prints 11 Print 731 Miseries of Human Life: While Deep in Study and Lost in Thought in the Complicated Profession of a Taylor and All on a Sudden Disturbed by the Shrieks of a Woman Crying Cucumbers         Miseries of Human Life 1461 Artist|Artist|Publisher 895 After Nicolaus Heideloff|Thomas Rowlandson|Rudolph Ackermann, London British, 1761–1837|British, London 1757–1827 London|active 1794–1829   Heideloff, Nicolaus|Rowlandson, Thomas|Ackermann, Rudolph 56627   1761 |1757 |1764 1837 |1827 |1834 October 1807 1807 1807 Etching 26137 Sheet: 12 5/8 × 9 1/8 in. (32 × 23.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
444809 59.533.1011 0 0 742841 Drawings and Prints 11 Print 731 Miseries of Human Life: I Smell a Rat, or a Rogue in Grain         Miseries of Human Life 1461 Artist|Publisher|Artist 867 After Henry William Bunbury|Rudolph Ackermann, London|Thomas Rowlandson British, Mildenhall, Suffolk 1750–1811 Keswick, Cumberland|active 1794–1829|British, London 1757–1827 London   Bunbury, Henry William|Ackermann, Rudolph|Rowlandson, Thomas 56641   1750 |1764 |1757 1811 |1834 |1827 1807 1807 1807 Hand-colored etching 34862 Sheet: 5 7/8 × 7 5/8 in. (15 × 19.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
444815 59.533.1013 0 1 742847 Drawings and Prints 11 Print 731 The Miseries of Human Life: Getting Up Early in a Cold Gloomy Morning...Before an Empty Grate         Miseries of Human Life 1461 Artist|Artist 13 After George Moutard Woodward|Thomas Rowlandson British, ca. 1760–1809 London|British, London 1757–1827 London   Woodward, George Moutard|Rowlandson, Thomas 56393   1760 |1757 1809 |1827 October 9, 1807 1807 1807 Hand-colored etching 34862 Sheet: 10 11/16 × 14 7/16 in. (27.2 × 36.6 cm) Plate: 9 5/8 × 13 9/16 in. (24.4 × 34.4 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
458698 59.533.1717 0 1 775333 Drawings and Prints 11 Print 731 The Production of a Post House         Miseries of Human Life 1461 Artist|Author 709 Related outhor Thomas Rowlandson|Rev. James Beresford British, London 1757–1827 London|British, 1764–1840   Rowlandson, Thomas|Beresford, James Rev. 58892   1757 |1764 1827 |1840 1808 1808 1808 Etching 26137 Plate: 6 11/16 × 9 13/16 in. (17 × 25 cm) Sheet: 8 3/8 × 10 3/4 in. (21.3 × 27.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
458700 59.533.1718 0 1 775335 Drawings and Prints 11 Print 731 The Production of a Post House         Miseries of Human Life 1461 Artist|Author 709 Related outhor Thomas Rowlandson|Rev. James Beresford British, London 1757–1827 London|British, 1764–1840   Rowlandson, Thomas|Beresford, James Rev. 58892   1757 |1764 1827 |1840 1808 1808 1808 Hand-colored etching 34862 Plate: 6 11/16 × 9 15/16 in. (17 × 25.2 cm) Sheet: 7 5/16 × 10 13/16 in. (18.5 × 27.4 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
458872 59.533.1742 0 1 775522 Drawings and Prints 11 Print 731 The Inflexible Porter         Miseries of Human Life 1461 Etcher|Artist 1330 After Thomas Rowlandson|Henry William Bunbury British, London 1757–1827 London|British, Mildenhall, Suffolk 1750–1811 Keswick, Cumberland   Rowlandson, Thomas|Bunbury, Henry William 56509   1757 |1750 1827 |1811 1808–14 1808 1814 Hand-colored etching 34862 Plate: 4 3/16 × 5 3/16 in. (10.7 × 13.2 cm) Sheet: 5 3/16 × 6 5/8 in. (13.2 × 16.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
458918 59.533.962 0 1 775593 Drawings and Prints 11 Print 731 Symptoms of Choaking         Miseries of Human Life 1461 Publisher|Artist 740   Rudolph Ackermann, London|Thomas Rowlandson active 1794–1829|British, London 1757–1827 London   Ackermann, Rudolph|Rowlandson, Thomas 38462   1764 |1757 1834 |1827 1806 (pub. August 25, 1808) 1806 1808 Hand-colored etching 34862 Plate: 5 1/4 × 7 3/16 in. (13.4 × 18.2 cm) Sheet: 6 in. × 7 7/8 in. (15.3 × 20 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
459683 59.533.1023 0 0 776733 Drawings and Prints 11 Print 731 Title Page: Miseries of Human Life         Miseries of Human Life 1461 Artist|Publisher 710   Thomas Rowlandson|Rudolph Ackermann, London British, London 1757–1827 London|active 1794–1829   Rowlandson, Thomas|Ackermann, Rudolph 32059   1757 |1764 1827 |1834 1808 1808 1808 Hand-colored etching 34862 Plate: 6 11/16 × 9 1/4 in. (17 × 23.5 cm) Sheet: 7 5/16 × 10 1/16 in. (18.5 × 25.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       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 225.074ms · Data license: CC0 · Data source: metmuseum/openaccess