MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Is Highlight = 1 and Object Name = 356

View and edit SQL

Suggested facets: Department, Title, Credit Line

Is Highlight

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
5798 34.100.124 1 1 6186 American Decorative Arts 1 Plate 356 Plate American 1         Maker 1 Possibly Heinrich Roth active ca. 1790–1810   Roth, Heinrich 883   1790 1810 1793 1793 1793 Earthenware; Redware with sgraffito decoration 585 Diam. 12 1/4 in. (31.1 cm) Gift of Mrs. Robert W. de Forest, 1933 Possibly made in 5   Northampton County 48 Northampton County 48 United States 3             Ceramics 5   Metropolitan Museum of Art, New York, NY 1
115888 65.47 1 1 204533 European Sculpture and Decorative Arts 3 Plate 356 Plate Russian, St. Petersburg 2372         Manufactory 331   Imperial Porcelain Manufactory, St. Petersburg Russian, 1744–present   Imperial Porcelain Manufactory, St. Petersburg 8311 Russian 57 1744 9999 1755–60 1755 1760 Hard-paste porcelain 572 Diameter: 10 1/8 in. (25.7 cm) The Charles E. Sampson Memorial Fund, 1965                       Ceramics-Porcelain 307   Metropolitan Museum of Art, New York, NY 1
205893 1994.402 1 1 327497 Ancient Near Eastern Art 14 Plate 356 Plate with a hunting scene from the tale of Bahram Gur and Azadeh Sasanian 5655 Sasanian                         ca. 5th century A.D. 400 500 Silver, mercury gilding 28643 Height 1.62 in. (4.11 cm), Diameter 7.9 in. (20.1 cm) Purchase, Lila Acheson Wallace Gift, 1994           Iran 347           Metalwork-Vessels-Inscribed 636   Metropolitan Museum of Art, New York, NY 1
321229 1975.1.1019 1 1 459198 Robert Lehman Collection 16 Plate 356 Armorial Plate (tondino): The story of King Midas           Artist 2   Nicola da Urbino Italian, active by 1520–died ?1537/38 Urbino   Nicola da Urbino 11147 Italian 6 1520 1538 ca. 1520–25 1517 1528 Maiolica (tin-glazed earthenware) 20530 Diam. 10 13/16 in. (27.5 cm) Robert Lehman Collection, 1975                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
321277 1975.1.1232 1 1 459246 Robert Lehman Collection 16 Plate 356 Dish: The Destruction of the Hosts of Pharaoh           Artist|Artist 13   Master IC (probably Jean Court)|Jean Cour (or Court) French, Limoges, active 1614–1627|French, Limoges, active 1598–1631 or Master IC|Cour, Jean 44403 French, Limoges|French, Limoges 3382 1614 |1598 1627 |1631 probably early 17th century 1600 1635 Painted enamel on copper, partly gilt. 47827 20 11/16 x 15 3/4 in. (52.5 x 40 cm) Robert Lehman Collection, 1975                       Enamels 193   Metropolitan Museum of Art, New York, NY 1
324663 17.190.396 1 1 464377 Medieval Art 6 Plate 356 Plate with the Battle of David and Goliath Byzantine 1134                           629–30 629 630 Silver 2 Overall: 19 7/16 x 2 5/8 in., 203.9oz. (49.4 x 6.6 cm, 5780g) foot: 8 1/8 x 3/4 in. (20.6 x 1.9 cm) Gift of J. Pierpont Morgan, 1917 Made in 1 Constantinople 1847                   Metalwork-Silver 313   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 1953.621ms · Data license: CC0 · Data source: metmuseum/openaccess