MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Artist Alpha Sort = 24594

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Artist Prefix, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, 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 Metadata Date Repository
222359 222359 56.527(1–77) 0 0 349919 Drawings and Prints 11 Album ; Drawing ; Ornament & Architecture 13918 Original Designs for Porcelain and Pottery for Samuel Alcock & Company, Staffordshire           Artist|Patron 370 Commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Pen and Ink, wash, graphite, watercolor, and gouache 35071 17 1/4 x 12 in. (43.8 x 30.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Albums|Ornament & Architecture|Drawings 690   http://www.metmuseum.org/art/collection/search/349919 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265825 265825 56.527(1) 0 1 394792 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Drawn title page inscribed "Alfred Crowquill [Alfred Henry Forrester, 1804–1872], Original Designs for Pottery and Porcelain, ca. 1845–1855," with Drawing of Lily Cup           Artist|Patron 370 Commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Pen and ink, watercolor and gouache 40247 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) drawing mount: 6 3/8 x 7 3/8 in. (16.2 x 18.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Albums 745   http://www.metmuseum.org/art/collection/search/394792 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265826 265826 56.527(2) 0 1 394793 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Four Designs for Decorated Plates and a Quatrefoil Rondel           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1852 1852 1852 Pen and ink, watercolor and gouache 40247 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394793 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265827 265827 56.527(3) 0 1 394794 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Eight Designs for Decorated Cups and Two Designs for Plate Rims           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Pen and ink, and watercolor 42694 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394794 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265828 265828 56.527(4) 0 1 394795 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Eight Designs for Decorated Cups, including Boabdil Pattern           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Pen and ink, and watercolor 42694 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394795 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265829 265829 56.527(5) 0 1 394796 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Five Designs for Decorated Cups and Three Designs for Saucers           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Pen and ink, watercolor and gouache 40247 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394796 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265830 265830 56.527(6) 0 1 394797 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Seven Designs for Decorated Cups, including Venice, Osborne Tapetry and Osborne Patterns           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Pen and ink, and watercolor 42694 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394797 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265831 265831 56.527(7) 0 1 394798 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Eleven Designs for Decorated Cups, including Venice and Celestial Patterns           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 ca. 1852 1847 1857 Pen and ink, watercolor and gouache 40247 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394798 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265832 265832 56.527(8) 0 1 394799 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Designs for an Pierced Border Ornament, Three Pitchers and an Open Basin (recto); Design for a Candle Stick (verso)           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Pen and ink, watercolor and gouache 40247 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394799 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265875 265875 56.527(42) 0 1 394843 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Designs for a Ewer and a Candlestick           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Graphite, ink and wash 37360 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394843 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265898 265898 56.527(67a) 0 1 394866 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Lettered title: Christy           Artist|Patron 370 Possibly commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Gouache 29287 sheet: 13 x 9 5/8 in. (33 x 24.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394866 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
265899 265899 56.527(67c) 0 1 394867 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Sketch of a Chalice           Artist|Patron 370 Possibly commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Graphite 28967 sheet: 12 11/16 x 10 1/16 in. (32.3 x 25.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/394867 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
292248 292248 56.527(67d) 0 1 421580 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Sketch of a Fairy or Spirit Emerging from a Shell           Artist|Patron 370 Possibly commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Graphite 28967 sheet: 12 11/16 x 10 1/16 in. (32.3 x 25.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/421580 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
292254 292254 56.527(67b) 0 1 421586 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Sketches of Butterfly Pen-holder, a Shell Pen-holder and Snail Ring-holder, and a Vase           Artist|Patron 370 Possibly commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Graphite 28967 sheet: 13 x 9 5/8 in. (33 x 24.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/421586 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
294202 294202 56.527(41b) 0 1 423544 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Designs for Two Tureens and a Plate           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Graphite, ink and wash, and watercolor 43988 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/423544 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
294203 294203 56.527(41a) 0 1 423545 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Designs for Tureens and a Platter           Artist|Patron 370 Probably commissioned by Alfred Henry Forrester [Alfred Crowquill]|Samuel Alcock & Company British, London 1804–1872 London|British, active ca. 1828–1859   Forrester, Alfred Henry [Alfred Crowquill]|Alcock, Samuel & Company 24594 British|British 9 1804 |1828 1872 |1860 1845–55 1845 1855 Graphite, pen and ink, and wash 43989 sheet: 16 3/4 x 11 7/16 in. (42.5 x 29 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1956                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/423545 4/23/2018 8:00:01 AM 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 181.101ms · Data license: CC0 · Data source: metmuseum/openaccess