MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

10 rows where Artist Role = 5, Is Public Domain = 1 and Object Name = 106

✎ View and edit SQL

This data as json, CSV (advanced)

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
105775 105775 17.190.643 0 1 193611 European Sculpture and Decorative Arts 3 Bowl 106 Bowl possibly Southern German, Nuremberg 2640         Designer 5 Said to be based on a design by Sebald Beham German, Nuremberg 1500–1550 Frankfurt   Beham, Sebald 8732   1500 1550 ca. 1540–50 1535 1555 Boxwood and fruitwood 21323 Overall: 6 3/4 × 7 7/8 in. (17.1 × 20 cm) Gift of J. Pierpont Morgan, 1917                       Sculpture-Miniature 311   http://www.metmuseum.org/art/collection/search/193611 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
334274 334274 1977.438.2 0 1 481682 Modern and Contemporary Art 4 Bowl 106 Bowl           Designer 5   René-Jules Lalique French, Aÿ 1860–1945 Paris   Lalique, René-Jules 6695 French 2 1860 1945 1933 1933 1933 Glass 31 Diam. 12-7/8 in. (32.7 cm.) Gift of Ethel Lyman Mackey, in memory of Mary Hopkins Emerson, 1977                       Glass 3   http://www.metmuseum.org/art/collection/search/481682 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339537 339537 22.183.2 0 1 487207 Modern and Contemporary Art 4 Bowl 106 Bowl French 7         Designer 5   André Metthey French, Laignes 1871–1920 Asnieres-sur-Seine   Metthey, Andre 46420 French 2 1871 1920 ca. 1910 1910 1910 Earthenware 21 H. 1-1/2, W. 4-1/4 in. (3.8 x 10.8 cm) Purchase, Edward C. Moore Jr. Gift, 1922                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/487207 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339627 339627 23.176.1 0 1 487310 Modern and Contemporary Art 4 Bowl 106 Bowl French 7         Designer 5   Paul Jeanneney French, 1861–1920 Strasbourg   Jeanneney, Paul 46457 French 2 1861 1920 ca. 1900–1910 1895 1905 Stoneware 209 H. 6-3/4, W. 7-7/8 in. (17.1 x 20 cm) Purchase, Edward C. Moore Jr. Gift, 1923                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/487310 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339630 339630 23.176.4 0 1 487313 Modern and Contemporary Art 4 Bowl 106 Bowl           Designer 5   Auguste Delaherche French, Beauvais 1857–1940 Paris   Delaherche, Auguste 12873 French 2 1857 1940 ca. 1900 1895 1905 Stoneware 209 H. 6, W. 10-3/4 inches (15.2 x 27.3 cm.) Purchase, Edward C. Moore Jr. Gift, 1923                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/487313 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339744 339744 26.228.17 0 1 487475 Modern and Contemporary Art 4 Bowl 106 Bowl with Streaked Design           Designer 5   Alexandre Bigot French, Mer, Loire-et-Cher 1862–1927 Paris   Bigot, Alexandre 11830 French 2 1862 1927 1895 1895 1895 Stoneware with glazes 52461 H. 3-3/4, Diam. 9-3/8 inches (9.5 x 23.8 cm.) Purchase, Edward C. Moore Jr. Gift, 1926                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/487475 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339763 339763 26.37 0 1 487495 Modern and Contemporary Art 4 Bowl 106 Bowl           Designer 5   Adelaide Alsop Robineau American, Middletown, Connecticut, 1865–1929 Syracuse, New York   Robineau, Adelaide Alsop 2497 American 1 1865 1929 1924 1924 1924 Porcelain 109 H. 2-3/4, Diam. 5-5/8 inches (7 x 14.3 cm.) Purchase, Edward C. Moore Jr. Gift, 1926 Made in 1 Syracuse 116   New York 126 United States 3 Mid-Atlantic United States 560           Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/487495 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339952 339952 34.105.1 0 1 487747 Modern and Contemporary Art 4 Bowl 106 Bowl French 7         Designer 5   Jean E. Puiforcat French, Paris 1897–1945 Paris   Puiforcat, Jean 44864 French 2 1897 1945 1934 1934 1934 Silver and glass 2088 5-3/4 x 8-5/8 inches (14.6 x 21.9 cm) Purchase, Edward C. Moore Jr. Gift, 1934                       Metalwork-Silver 313   http://www.metmuseum.org/art/collection/search/487747 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
339982 339982 35.91 0 1 487783 Modern and Contemporary Art 4 Bowl 106 Bowl with "Hare's-Fur" Glaze           Designer 5   Charles Fergus Binns American (born England), Worcester 1857–1934 Alfred, New York   Binns, Charles Fergus 46571 American, born England 16 1857 1934 1929 1929 1929 Stoneware with iron glaze 52490 H. 2-1/2, Diam. 7-1/2 inches (6.4 x 19.1 cm.) Gift of Miss Henrietta M. Crawford, 1934                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/487783 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
340346 340346 46.141 0 1 488197 Modern and Contemporary Art 4 Bowl 106 Bowl           Designer 5   Sylvie Weinstein American, 1906–1945   Weinstein, Sylvie 46745 American 1 1906 1945 1941 1941 1941 Stoneware 209 H. 3-1/2, Diam. 3-3/4 in. (8.9 x 9.5 cm) Gift of Florence Weinstein and Eleanore Lockspeiser, 1946, in memory of their sister, Sylvie L. Weinstein                       Ceramics-Pottery 314   http://www.metmuseum.org/art/collection/search/488197 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 7245.933ms · Data license: CC0 · Data source: metmuseum/openaccess