MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Role = 2146

View and edit SQL

Suggested facets: Medium

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
220252 52.561.2 0 0 347785 Drawings and Prints 11 Book 97 The Comic English Grammar; A New and Facetious Introduction to the English Tongue           Illustrator|Publisher|Printer|Author 2146   John Leech|Richard Bentley|Samuel Bentley|Percival Leigh British, London 1817–1864 London|British, London 1794–1871 Ramsgate|London|British, Haddington, Scotland 1813–1889 London   Leech, John|Bentley, Richard|Bentley, Samuel|Leigh, Percival 23180 British|British|British|British, Scottish 1187 1817 |1794 |1785 |1813 1864 |1871 |1868 |1889 1840 1840 1840 Illustrations: lithography 28996 7 3/4 x 5 in. (19.7 x 12.7 cm) Gift of Sinclair Hamilton, 1952   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
224040 54.524.46 0 0 351630 Drawings and Prints 11 Book 97 The Theory of Effect: Embracing the Contrast of Light and Shade of Color and Harmony           Illustrator|Publisher|Printer|Author 2146   Cornelius T. Hinkley|J. W. Moore|Isaac Ashmead|John Bengo American, born ca. 1820|Philadelphia, Pennsylvania|American, 19th century|American, 19th century   Hinkley, Cornelius T.|Moore, J. W.|Ashmead, Isaac|Bengo, John 25922 American|American|American|American 97 1820 |1800 |1800 |1800 1920 |1900 |1900 |1900 1851 1851 1851 Illustrations: wood engraving 28946 7 1/4 x 4 3/4 in. (18.4 x 12.1 cm) Harris Brisbane Dick Fund, 1954                       Books 442   Metropolitan Museum of Art, New York, NY 1
224248 66.540.48 0 0 351840 Drawings and Prints 11 Book 97 Princess Badoura: A Tale from the Arabian Nights           Illustrator|Publisher|Printer|Author 2146 Retold by Edmund Dulac|Hodder & Stoughton, Ltd.|T. and A. Constable|Laurence Housman British (born France), Toulouse 1882–1953 London|Edinburgh|British, Bromsgrove, Worcestershire 1865–1959 Glastonbury, Somerset London (?)|at the University Press Dulac, Edmund|Hodder & Stoughton, Ltd.|Constable, T. and A.|Housman, Laurence 26097 British, born France|British, Scottish|British 1815 1882 |1800 |1865 1953 |1999 |1959 [1913] 1913 1913 Illustrations: photomechanical reproduction 34086 11 7/16 x 9 3/16 x 1 1/4 in. (29.1 x 23.3 x 3.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966                       Books 442   Metropolitan Museum of Art, New York, NY 1
226427 67.804.2 0 0 354039 Drawings and Prints 11 Book 97 The Wreath           Illustrator|Publisher|Printer|Author 2146   James J. Guthrie|D. J. Rider|Pear Tree Press|Peter James Miller British, active early 20th century|London|British|British, active early 20th century   Guthrie, James J.|Rider, D. J.|Pear Tree Press|Miller, Peter James 27664 British|British|British|British 177 1850 |1880 |1850 |1850 1950 |1940 |1900 |1950 1911 1911 1911 Illustrations: wood engraving 28946 7 x 5 1/4 in. (17.8 x 13.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1967                       Books 442   Metropolitan Museum of Art, New York, NY 1
227904 1972.526.1 0 0 355528 Drawings and Prints 11 Book 97 The Poems of Edgar Allen Poe           Illustrator|Publisher|Printer|Author 2146   William Heath Robinson|George Bell & Sons|Stephen Austin & Sons Ltd.|Edgar Allan Poe British, London 1872–1944 Highgate, London|London|Hertford|American, Boston, Massachusetts 1809–1849 Baltimore, Maryland   Robinson, William Heath|Bell, George & Sons|Austin, Stephen & Sons Ltd.|Poe, Edgar Allan 28694 British|British|British|American 881 1872 |1800 |1950 |1809 1944 |2100 |2100 |1849 1970 1970 1970 Illustrations: photomechanical process 33879 8 3/4 x 5 13/16 x 7/8 in. (22.2 x 14.8 x 2.2 cm) Adminstrative Purchase Fund, 1972                       Books 442   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 358.165ms · Data license: CC0 · Data source: metmuseum/openaccess