MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Nationality = 7 and Object Name = 75

View and edit SQL

Suggested facets: Is Public Domain, Title, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, Classification

Artist Nationality

  • British · 9
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
103149 08.78.5 0 0 190694 European Sculpture and Decorative Arts 3 Plaque 75 Plaque British, Birmingham, after German original 2181         Manufacturer 20   Elkington & Co. British, Birmingham, 1829–1963   Elkington & Co. 2972 British 7 1829 1963 19th century, after 17th century original 1800 1899 Pewter 104 Diameter: 11 1/2 in. (29.2 cm) Rogers Fund, 1908                       Metalwork-Electrotype 136   Metropolitan Museum of Art, New York, NY 1
104177 11.133.5 0 1 191784 European Sculpture and Decorative Arts 3 Plaque 75 Plaque British 6         Maker 1   Enoch Wood British, 1759–1846   Wood, Enoch 563 British 7 1759 1846 18th century 1700 1799 Lead-glazed earthenware 20492 Height: 8 5/8 in. (21.9 cm) Frederick C. Hewitt Fund, 1911                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
105291 14.102.401 0 1 193096 European Sculpture and Decorative Arts 3 Plaque 75 Plaque British, Staffordshire 2229         Manufacturer 20   Josiah Wedgwood British, Burslem, Stoke-on-Trent 1730–1795 Burslem, Stoke-on-Trent   Wedgwood, Josiah 8583 British 7 1730 1795 late 18th century 1785 1799 Jasperware 304 3/4 × 1 1/8 in. (1.9 × 2.9 cm) Bequest of Mary Mandeville Johnston, from the collection of Mr. and Mrs. Edward W. S. Johnston, 1914                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
107142 24.80.40 0 1 195077 European Sculpture and Decorative Arts 3 Plaque 75 Plaque British, Etruria, Staffordshire 2456         Modeler|Factory 420   Lady Templetown|Josiah Wedgwood before 1759–1823, active 1777–83|British, Burslem, Stoke-on-Trent 1730–1795 Burslem, Stoke-on-Trent   Templetown Lady|Wedgwood, Josiah 8582 British 7 1759 |1730 1823 |1795 probably ca. 1790 1785 1795 Jasperware, back green 21720 3 × 4 1/2 in. (7.6 × 11.4 cm) Bequest of Mary Clark Thompson, 1923                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
107143 24.80.41 0 1 195078 European Sculpture and Decorative Arts 3 Plaque 75 Plaque British, Etruria, Staffordshire 2456         Factory 328   Josiah Wedgwood British, Burslem, Stoke-on-Trent 1730–1795 Burslem, Stoke-on-Trent   Wedgwood, Josiah 8583 British 7 1730 1795 1776–96 1776 1796 Jasperware, black back 21721 2 7/8 × 4 in. (7.3 × 10.2 cm) Bequest of Mary Clark Thompson, 1923                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
108802 31.84.1 0 1 196842 European Sculpture and Decorative Arts 3 Plaque 75 Rape of Helen British, Etruria, Staffordshire 2456         Factory 328   Josiah Wedgwood British, Burslem, Stoke-on-Trent 1730–1795 Burslem, Stoke-on-Trent   Wedgwood, Josiah 8583 British 7 1730 1795 1780–90 1780 1790 Black basalt ware with "encaustic" decoration 21964 Diam. 13 5/8 in. (34.6 cm) Rogers Fund, 1931                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
108803 31.84.2 0 1 196843 European Sculpture and Decorative Arts 3 Plaque 75 Hercules and Antaeus British, Etruria, Staffordshire 2456         Factory 328   Josiah Wedgwood British, Burslem, Stoke-on-Trent 1730–1795 Burslem, Stoke-on-Trent   Wedgwood, Josiah 8583 British 7 1730 1795 1780–90 1780 1790 Black basalt ware with "encaustic" decoration 21964 Diam. 13 5/8 in. (34.6 cm) Rogers Fund, 1931                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
115115 64.101.777 0 1 203598 European Sculpture and Decorative Arts 3 Plaque 75 Floral plaque British, Bristol 2276         Factory director|Maker|Factory 555 Probably Richard Champion|Thomas Briand|Bristol British, active 1742–1780|British   Champion, Richard|Briand, Thomas|Bristol 11064 British 7 1742 1780 ca. 1774–77 1769 1782 Hard-paste porcelain 572 5 1/2 × 4 1/2 in. (14 × 11.4 cm) Gift of Irwin Untermyer, 1964                       Ceramics-Porcelain 307   Metropolitan Museum of Art, New York, NY 1
140548 2013.239.3 0 1 239505 European Sculpture and Decorative Arts 3 Plaque 75 Plaque depicting a pottery workshop British, Southall, London 3984         Maker 1   R. W. Martin and Brothers British, 1873–1915   R. W. Martin and Brothers 12896 British 7 1873 1915 ca. 1882 1877 1887 Terracotta 160 Overall (confirmed): 7 1/4 × 17 × 2 1/8 in. (18.4 × 43.2 × 5.4 cm); Framed (confirmed): 16 1/4 × 19 3/4 × 2 5/8 in. (41.3 × 50.2 × 6.7 cm) Robert A. Ellison Jr. Collection, Gift of Robert A. Ellison Jr., 2013                       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 4280.94ms · Data license: CC0 · Data source: metmuseum/openaccess