MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Classification = 307 and Object Name = 116

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Culture, Artist Role, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

Classification ✖

  • Ceramics-Porcelain · 8 ✖
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
110492 110492 40.169.2 0 1 198672 European Sculpture and Decorative Arts 3 Jar 116 Condiment jar (one of a pair), with figure symbolizing Winter German, Höchst 2285         Maker|Manufacturer 23 After an original by Johann Joachim Kändler|Höchst Manufactory German, Fischbach 1706–1775 Meissen|German, 1746–1796   Kändler, Johann Joachim|Höchst Manufactory 10126 German 10 1706 |1746 1775 |1796 ca. 1750–55 1745 1760 Hard-paste porcelain 572 H. 6-1/4 in. (15.9 cm.) Purchase, Anita M. Linzee Bequest, 1940                       Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/198672 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
110493 110493 40.169.3 0 1 198673 European Sculpture and Decorative Arts 3 Jar 116 Condiment jar (one of a pair), with figure symbolizing Summer German, Höchst 2285         Factory 328   Höchst Manufactory German, 1746–1796   Höchst Manufactory 8185   1746 1796 ca. 1750–55 1745 1760 Hard-paste porcelain 572 Height: 5 3/4 in. (14.6 cm) Rogers Fund, 1940                       Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/198673 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
111422 111422 45.128.1 0 1 199670 European Sculpture and Decorative Arts 3 Jar 116 Jar Italian, Naples 427         Maker 1   Gaetano Lottini Italian, ca. 1755   Lottini, Gaetano 10272   1725 1785 mid-18th century 1730 1765 Earthenware 21 Height: 39 in. (99.1 cm) Bequest of Helen Hay Whitney, 1944                       Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/199670 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
112545 112545 50.211.121 0 1 200827 European Sculpture and Decorative Arts 3 Jar 116 Jar with figures French, Chantilly 2381         Artist|Manufactory 382 After a print by Jean Antoine Fraisse|Chantilly French, active ca. 1680–1739|French   Fraisse, Jean Antoine|Chantilly 10647 French 2 1680 1739 ca. 1735–40 1730 1745 Soft-paste porcelain painted with colored enamels over tin glaze 22551 Height: 11 in. (27.9 cm) Gift of R. Thornton Wilson, in memory of Florence Ellsworth Wilson, 1950                       Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/200827 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
112672 112672 50.211.266 0 1 200954 European Sculpture and Decorative Arts 3 Jar 116 Jar Italian, Naples 427         Factory|Decorator 330 decoration possibly by Capodimonte Porcelain Factory|Giovanni Caselli Italian, 1740/43–1759|1698–1752   Capodimonte Porcelain Factory|Caselli Giovanni 10694   1740 |1698 1759 |1752 ca. 1745–50 1740 1755 Soft-paste porcelain 2061 Overall, irregular diameter (confirmed): H. 6 3/8 x W. 6 x D. 5 5/8 in. (16.2 x 15.2 x 14.3 cm) Gift of R. Thornton Wilson, in memory of Florence Ellsworth Wilson, 1950                       Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/200954 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
114848 114848 64.101.412 0 1 203299 European Sculpture and Decorative Arts 3 Jar 116 Jar (bulb pot) British, Chelsea 2371         Factory 328   Chelsea Porcelain Manufactory British, 1745–1784   Chelsea Porcelain Manufactory 8309   1745 1784 ca. 1748 1743 1753 Soft-paste porcelain 2061 4 3/4 × 3 1/4 in. (12.1 × 8.3 cm) Gift of Irwin Untermyer, 1964                       Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/203299 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
118160 118160 1982.60.270a, b 0 1 207152 European Sculpture and Decorative Arts 3 Jar 116 Oriental with Jar French, Chantilly 2381                           ca. 1735 1730 1740 Tin-glazed soft-paste porcelain 20798 Height: 6 5/8 in. (16.8 cm) The Jack and Belle Linsky Collection, 1982                       Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/207152 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
118819 118819 1990.166.1a, b 0 1 207843 European Sculpture and Decorative Arts 3 Jar 116 Cylindrical jar Austrian 184                           1842 1842 1842 Hard-paste porcelain 572 Height: 6 3/8 in. (16.2 cm) Gift of Zita Spiss, in memory of her father, Julius Triger, 1990                       Ceramics-Porcelain 307   http://www.metmuseum.org/art/collection/search/207843 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 1002.708ms · Data license: CC0 · Data source: metmuseum/openaccess