MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

12 rows where Artist Prefix = "Manufactured by" and Medium = 21

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Nationality, City, State, County, Country

Artist Prefix

  • Manufactured by · 12
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
746 69.37.3 0 0 817 American Decorative Arts 1 Bowl 106 Bowl American 1         Decorator|Manufacturer 21 Manufactured by Kataro Shirayamadani|Rookwood Pottery 1865–1948|American, Cincinnati, Ohio, 1880–1967   Shirayamadani, Kataro|Rookwood Pottery 172 American 1 1865 |1880 1865 |1967 1890 1890 1890 Earthenware 21 H. 5 9/16 in. (14.1 cm); Diam. 11 in. (27.9 cm) Purchase, The Edgar J. Kaufmann Foundation Gift, 1969 Made in 1 Cincinnati 41     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
762 1980.452 0 1 834 American Decorative Arts 1 Bowl 106 Bowl American 1         Maker|Manufacturer 23 Manufactured by Albert R. Valentien|Rookwood Pottery American, Cincinnati, Ohio 1862–1925 San Diego, California|American, Cincinnati, Ohio, 1880–1967   Valentien, Albert R.|Rookwood Pottery 180 American|American 5 1862 |1880 1925 |1967 1882 1882 1882 Earthenware 21 H. 3 15/16 in. (10 cm); Diam. 10 in. (25.4 cm) Purchase, Sansbury-Mills Fund and Bequest of Herbert L. Pratt, by exchange, 1980 Made in 1 Cincinnati 41     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
1028 83.2.282 0 0 1112 American Decorative Arts 1 Cameo medallion 157 Cameo Medallion British 6         Artist|Manufacturer 26 Manufactured by Jean-Baptiste Nini|Josiah Wedgwood and Sons Italian, Urbino 1717–1786 Chaumont-sur-Loire|1759–present   Nini, Jean-Baptiste|Wedgwood and Sons, Josiah 220 Italian 6 1717 |1759 1786 |9999 1777 (?) 1777 1777 Earthenware 21 4 x 3 1/16 in. (10.2 x 7.8 cm) Gift of William H. Huntington, 1883 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
3508 1984.395.6 0 1 3746 American Decorative Arts 1 Flask 96 Flask American 1         Manufacturer 20 Manufactured by United States Pottery Company 1852–58   United States Pottery Company  75   1852 1852 1852–58 1852 1852 Earthenware 21 H. 6 in. (15.2 cm) Gift of Mrs. Stanley Herzman, 1984 Made in 1 Bennington 25     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
5523 1980.453 0 0 5901 American Decorative Arts 1 Plaque 75 Plaque American 1         Manufacturer 20 Manufactured by Rookwood Pottery American, Cincinnati, Ohio, 1880–1967   Rookwood Pottery 620 American 1 1880 1967 1919 1919 1919 Earthenware 21 9 x 12 in. (22.9 x 30.5 cm) Purchase, Mr. and Mrs. David Lubart Gift, in memory of Katherine J. Lubart, 1944–1975, 1980 Made in 1 Cincinnati 41     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
8526 69.53 0 1 9167 American Decorative Arts 1 Umbrella stand 923 Umbrella Stand American 1         Decorator|Manufacturer 21 Manufactured by Albert Haubrich|J. B. Owens Pottery Company 1875–1931|1891–1907   Haubrich, Albert|Owens Pottery Company J. B. 1173 German 10 1875 |1891 1931 |1907 ca. 1896 1893 1896 Earthenware 21 H. 22 5/16 in. (56.7 cm); Diam. 11 1/4 in. (28.6 cm) Gift of Ronald S. Kane, 1969 Made in 1 Zanesville 57     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
8665 1978.507 0 1 9312 American Decorative Arts 1 Vase 7 Vase American 1         Manufacturer 20 Manufactured by Gates Potteries (Teco Pottery) ca.1890–ca.1927   Gates Potteries  1178   1887 1927 ca. 1901–22 1898 1922 Earthenware 21 H. 5 5/8 in. (14.3 cm); Diam. 5 in. (12.7 cm) Gift of Stephen Spector, 1978 Made in 1   McHenry 55 McHenry 55 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
8715 1981.443 0 1 9366 American Decorative Arts 1 Vase 7 Aladdin Vase American 1         Decorator|Manufacturer 21 Manufactured by Maria Longworth Nichols|Rookwood Pottery American, 1849–1932|American, Cincinnati, Ohio, 1880–1967   Nichols, Maria Longworth|Rookwood Pottery 1196 American|American 5 1849 |1880 1932 |1967 1880–83 1880 1883 Earthenware 21 H. 30 in. (76.2 cm); Diam. 18 1/4 in. (46.4 cm) Gift of Marcia and William Goodman, 1981 Made in 1 Cincinnati 41     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
12365 1991.25 0 0 13498 American Decorative Arts 1 Plaque 75 M. B. Brown British (American market) 2         Decorator|Manufacturer 21 Manufactured by Rosina Emmet|Josiah Wedgwood and Sons American, New York 1854–1948 New York|1759–present   Emmet, Rosina|Wedgwood and Sons, Josiah 1958 American 1 1854 |1759 1948 |9999 ca. 1878–85 1875 1885 Earthenware 21 Diam. 15 1/8 in. (38.4 cm) Sansbury-Mills Fund, 1991 Made in 1   Staffordshire 1 Staffordshire 1 England 4             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
13187 1991.335 0 0 14342 American Decorative Arts 1 Plaque 75 Plaque American 1         Manufacturer|Decorator 61 Manufactured by Rookwood Pottery|Frederick D. H. Rothenbusch American, Cincinnati, Ohio, 1880–1967|active 1896–1931   Rookwood Pottery|Rothenbusch, Frederick D. H. 2170 American 1 1880 |1896 1967 |1931 1916 1916 1916 Earthenware 21 8 7/16 x 10 15/16 in. (21.4 x 27.8 cm) Gift of Mr. and Mrs. Jason Carl Berger, 1991 Made in 1 Cincinnati 41     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
14625 24.207 0 1 15861 American Decorative Arts 1 Bowl 106 Bowl American 1         Designer|Manufacturer 3 Manufactured by Arthur E. Baggs|Marblehead Pottery 1886–1947|1904–36   Baggs, Arthur E.|Marblehead Pottery  2326   1886 |1904 1947 |1936 ca. 1920–24 1915 1925 Earthenware 21   Purchase, 1924, Soc. of Arts and Crafts. Edward C. Moore, Jr. Gift Fund Made in 1 Marblehead 91     United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
14626 69.85 0 1 15862 American Decorative Arts 1 Vase 7 Vase American 1         Manufacturer 20 Manufactured by Van Briggle Pottery Company 1901–present   Van Briggle Pottery Company  2327   1901 9999 1906 1906 1906 Earthenware 21 H. 13 1/2 in. (34.3 cm); Diam. 5 3/8 in. (13.7 cm) The Edward C. Moore, Jr. Gift Fund Made in 1 Colorado Springs 377     United States 3             Ceramics 5   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 617.457ms · Data license: CC0 · Data source: metmuseum/openaccess