MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Culture = 2401

View and edit SQL

Suggested facets: Object Name, Title, Artist Role, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, 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
101393 04.9.20 0 1 188904 European Sculpture and Decorative Arts 3 Basin 51 Basin French, Fontainebleau or Avon 2401         Maker|Decorator 35 Follower of|Decoration after pewter originals by Bernard Palissy|François Briot French, Agen, Lot-et-Garonne 1510–1590 Paris|French, ca. 1550–1612   Palissy, Bernard|Briot, François 8391 French|French 21 1510 |1550 1590 |1612 late 16th–early 17th century 1585 1615 Lead-glazed earthenware 20492 1/16 × 15 1/2 in. (0.2 × 39.4 cm) Rogers Fund, 1904                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
113325 53.225.41 0 1 201622 European Sculpture and Decorative Arts 3 Plate 356 Plate French, Fontainebleau or Avon 2401         Maker 1 Manner of Bernard Palissy French, Agen, Lot-et-Garonne 1510–1590 Paris   Palissy, Bernard 8005 French 2 1510 1590 late 16th–early 17th century 1585 1615 Lead-glazed earthenware 20492 Overall, irregular diameter (confirmed): 1 13/16 × 10 1/16 × 9 15/16 in. (4.6 × 25.6 × 25.2 cm) Gift of Julia A. Berwind, 1953                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
113329 53.225.45 0 1 201626 European Sculpture and Decorative Arts 3 Plate 356 Plate French, Fontainebleau or Avon 2401         Maker 1 Manner of Bernard Palissy French, Agen, Lot-et-Garonne 1510–1590 Paris   Palissy, Bernard 8005 French 2 1510 1590 first half 17th century 1600 1650 Lead-glazed earthenware 20492 Height: 1 7/8 in. (4.8 cm); Diameter: 9 11/16 in. (24.6 cm) Gift of Julia A. Berwind, 1953                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
113338 53.225.54 0 1 201635 European Sculpture and Decorative Arts 3 Gondola cup 7665 Figure personifying a spring French, Fontainebleau or Avon 2401         Modeler|Maker 88 Model probably supplied by|Probably made in the pottery at Avon of Guillaume Dupré|Claude Bertélemy French, 1579–1640|French, 1525–1626   Dupré Guillaume|Bertélemy Claude 10743 French|French 21 1579 |1525 1640 |1626 modeled ca. 1600–1610, ca. 1620–25 1595 1630 Lead-glazed earthenware 20492 3 3/16 × 4 15/16 in. (8.1 × 12.5 cm) Gift of Julia A. Berwind, 1953                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
113342 53.225.58 0 1 201639 European Sculpture and Decorative Arts 3 Dish 110 The Abduction of Hippodamia French, Fontainebleau or Avon 2401                           late 16th century 1585 1599 Lead-glazed earthenware 20492 14 5/16 x 10 13/16 x 2 5/8 in. (36.4 x 27.5 x 6.7 cm) Gift of Julia A. Berwind, 1953                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
113344 53.225.60 0 1 201641 European Sculpture and Decorative Arts 3 Dish 110 Dish with Pomona French, Fontainebleau or Avon 2401         Maker|Artist|Artist 46 Manner of|After a composition by|After an engraving by Bernard Palissy|Maerten de Vos|Philips Galle French, Agen, Lot-et-Garonne 1510–1590 Paris|Netherlandish, Antwerp 1532–1603 Antwerp|Netherlandish, Haarlem 1537–1612 Antwerp   Palissy, Bernard|Vos, Maerten de|Galle, Philips 10744 French|Netherlandish|Netherlandish 292 1510 |1532 |1537 1590 |1603 |1612 late 16th or early 17th century 1585 1615 Lead-glazed earthenware 20492 Overall (confirmed): 2 5/16 x 13 1/2 x 10 1/4 in. (5.9 x 34.3 x 26 cm) Gift of Julia A. Berwind, 1953                       Ceramics-Pottery 314   Metropolitan Museum of Art, New York, NY 1
117057 1974.356.303 0 1 205868 European Sculpture and Decorative Arts 3 Figure 9 The Nurse French, Fontainebleau or Avon 2401         Modeler 478 Possibly after a model by Guillaume Dupré French, 1579–1640   Dupré Guillaume 3088 French 2 1579 1640 model ca. 1607–8 1607 1608 Lead-glazed earthenware 20492 Height: 9 3/4 in. (24.8 cm) The Lesley and Emma Sheafer Collection, Bequest of Emma A. Sheafer, 1973                       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 142.131ms · Data license: CC0 · Data source: metmuseum/openaccess