MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Medium = 40247

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Role, Artist Prefix, 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, Dimensions, Credit Line, 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 Repository
251762 23.112.3088 0 1 380221 Drawings and Prints 11 Drawing 23 Design for Driving or Road Phaeton (unnumbered)           Manufacturer 20   Brewster & Co. American, New York   Brewster & Co. 32247 American 1     ca. 1870 1865 1875 Pen and ink, watercolor and gouache 40247 sheet: 6 x 8 13/16 in. (15.2 x 22.4 cm) Gift of William Brewster, 1923                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
265839 56.527(9) 0 1 394806 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Nine Designs for Decorated Cups           Patron|Artist 3947 Probably commissioned by Samuel Alcock & Company|Alfred Henry Forrester [Alfred Crowquill] British, active ca. 1828–1859|British, London 1804–1872 London   Alcock, Samuel & Company|Forrester, Alfred Henry [Alfred Crowquill] 39059 British|British 9 1828 |1804 1860 |1872 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   Metropolitan Museum of Art, New York, NY 1
265865 56.527(32) 0 1 394832 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Designs for a Decorated Dish, or Platter, and a Biscuit Barrel           Patron|Artist 3947 Probably commissioned by Samuel Alcock & Company|Alfred Henry Forrester [Alfred Crowquill] British, active ca. 1828–1859|British, London 1804–1872 London   Alcock, Samuel & Company|Forrester, Alfred Henry [Alfred Crowquill] 39059 British|British 9 1828 |1804 1860 |1872 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   Metropolitan Museum of Art, New York, NY 1
265867 56.527(34) 0 1 394835 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Designs for Two Decorated Plates and a Candleholder with Cut Glass Drops           Patron|Artist 3947 Probably commissioned by Samuel Alcock & Company|Alfred Henry Forrester [Alfred Crowquill] British, active ca. 1828–1859|British, London 1804–1872 London   Alcock, Samuel & Company|Forrester, Alfred Henry [Alfred Crowquill] 39059 British|British 9 1828 |1804 1860 |1872 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   Metropolitan Museum of Art, New York, NY 1
265871 56.527(38) 0 1 394839 Drawings and Prints 11 Drawing ; Ornament and Architecture 13851 Designs for Four Mirrors and a Two Handled Vase           Patron|Artist 3947 Probably commissioned by Samuel Alcock & Company|Alfred Henry Forrester [Alfred Crowquill] British, active ca. 1828–1859|British, London 1804–1872 London   Alcock, Samuel & Company|Forrester, Alfred Henry [Alfred Crowquill] 39059 British|British 9 1828 |1804 1860 |1872 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   Metropolitan Museum of Art, New York, NY 1
420145 52.625.128 0 0 695595 Drawings and Prints 11 Drawing 23 The Knight Errant: Cover Design for Collier's, December 21, 1907           Artist 2   William Henry Bradley American, Boston, Massachusetts 1868–1962 La Mesa, California   Bradley, William Henry 19336   1868 1962 1907 1907 1907 Pen and ink, watercolor and gouache 40247 Sheet: 19 1/2 × 13 15/16 in. (49.5 × 35.4 cm) The Will Bradley Collection, Gift of Fern Bradley Dufner, 1952                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
420146 52.625.129 0 0 695598 Drawings and Prints 11 Drawing 23 Cover Design for Collier's, Dramatic Number, November 2, 1901           Artist 2   William Henry Bradley American, Boston, Massachusetts 1868–1962 La Mesa, California   Bradley, William Henry 19336   1868 1962 1901 1901 1901 Pen and ink, watercolor and gouache 40247 Figures: 16 9/16 × 12 13/16 in. (42 × 32.5 cm) Sheet: 24 in. × 18 7/8 in. (61 × 48 cm) The Will Bradley Collection, Gift of Fern Bradley Dufner, 1952                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
420149 52.625.125 0 0 695606 Drawings and Prints 11 Drawing 23 King Flipper and a Boat: Design for "Castle Perilous," in Collier's, Mary 27, 1905           Artist 2   William Henry Bradley American, Boston, Massachusetts 1868–1962 La Mesa, California   Bradley, William Henry 19336   1868 1962 1905 1905 1905 Pen and ink, watercolor and gouache 40247 Sheet: 14 3/8 × 21 1/4 in. (36.5 × 54 cm) The Will Bradley Collection, Gift of Fern Bradley Dufner, 1952                       Drawings 9   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 136.501ms · Data license: CC0 · Data source: metmuseum/openaccess