MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 394

View and edit SQL

Suggested facets: Object Name, Culture, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

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
104352 12.142.16 0 1 191978 European Sculpture and Decorative Arts 3 Group 3937 St. George and the Dragon British 6         Artist|Modeler 394 Style of|After a model by Whieldon type|Ralph Wood the Elder British, Burslem 1715–1772 Burslem   Whieldon type|Wood, Ralph, the Elder 8782   1715 1772 ca. 1750 1745 1755 Glazed pottery 9688 Overall: 10 5/8 × 8 1/2 in. (27 × 21.6 cm) Rogers Fund, 1912                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
110506 41.24.1, .2 0 1 198688 European Sculpture and Decorative Arts 3 Figures 4033 Pair of water buffalos with boys British, Staffordshire 2229         Artist|Modeler 394 Style of Whieldon type|Ralph Wood the Elder British, Burslem 1715–1772 Burslem from an oriental original inspiration Whieldon type|Wood, Ralph, the Elder 8782   1715 1772 ca. 1750 1745 1755 Tortoiseshell ware 21076 Height (each): 7 3/4 in. (19.7 cm) Gift of R. Thornton Wilson, 1941                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
110514 41.40 0 1 198696 European Sculpture and Decorative Arts 3 Figure 9 Owl British, Staffordshire 2229         Artist|Modeler 394 Style of|After a model by Whieldon type|Ralph Wood the Elder British, Burslem 1715–1772 Burslem   Whieldon type|Wood, Ralph, the Elder 8782   1715 1772 ca. 1750–60 1745 1765 Lead-glazed earthenware 20492 Height: 8 in. (20.3 cm) Gift of R. Thornton Wilson, 1941                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
110809 41.194.3 0 1 199019 European Sculpture and Decorative Arts 3 Group 3937 Milkmaid and cow with dog British, Staffordshire 2229         Artist|Modeler 394 Style of|After a model by Whieldon type|Ralph Wood the Elder British, Burslem 1715–1772 Burslem   Whieldon type|Wood, Ralph, the Elder 8782   1715 1772 ca. 1750–60 1745 1765 Lead-glazed earthenware 20492 Overall: 7 1/2 × 8 in. (19.1 × 20.3 cm) Gift of Mrs. Francis P. Garvan, 1941                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
110870 42.76.20 0 1 199087 European Sculpture and Decorative Arts 3 Medallion 72 William Pitt, Earl of Chatham British, Etruria, Staffordshire 2456         Artist|Modeler 394 Probably modeled by Josiah Wedgwood|John Flaxman British, Burslem, Stoke-on-Trent 1730–1795 Burslem, Stoke-on-Trent|British, York 1755–1826 London   Wedgwood, Josiah|Flaxman, John 8702 British|British 9 1730 |1755 1795 |1826 late 18th century 1785 1799 Black basalt ware 21050 3 1/2 × 2 5/8 in. (8.9 × 6.7 cm) Purchase, Joseph Pulitzer Bequest, 1942                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
111223 44.39.48, .49 0 1 199450 European Sculpture and Decorative Arts 3 Figures 4033 Pair of Chinese dogs of Foo British, Staffordshire 2229         Artist|Modeler 394 Style of|After a model by Whieldon type|Ralph Wood the Elder British, Burslem 1715–1772 Burslem   Whieldon type|Wood, Ralph, the Elder 8782   1715 1772 ca. 1755 1750 1760 Lead-glazed earthenware 20492 Height (each): 9 in. (22.9 cm) Gift of Mrs. Russell S. Carter, 1944                       Ceramics-Pottery 314   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 118.508ms · Data license: CC0 · Data source: metmuseum/openaccess