MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Role = 370 and Classification = 12

View and edit SQL

Suggested facets: Is Highlight, Object Name, Culture, Artist Prefix, Artist Nationality, Medium

Artist Role

  • Artist|Patron · 6
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
101318 03.11a–d 0 1 188827 European Sculpture and Decorative Arts 3 Group 3937 The Demidoff Table Italian, Florence 1136         Artist|Patron 370 Commissioned by Lorenzo Bartolini|Prince Anatole Demidov Italian, 1777–1850|1845–1870   Bartolini, Lorenzo|Demidov, Anatole Prince 8350 Italian 6 1777 |1845 1850 |1870 1845 1845 1845 Marble 750 Overall (confirmed): H. 64 3/8 x W. 51 1/4 x Diam. 49 3/4 x in. (163.5 x 130.2 x 126.4 cm) Gift of le Duc de Loubat, 1903                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
110577 41.100.244 0 1 198766 European Sculpture and Decorative Arts 3 Bust 5 Louis XV (1710–1774), King of France French, Paris 114         Artist|Patron 370 Probably commissioned by Jean-Baptiste Lemoyne the Younger|Mme de Pompadour French, Paris 1704–1778 Paris|French, 1721–1764   Lemoyne, Jean-Baptiste, the Younger|Pompadour, Mme de 10149 French|French 21 1704 |1721 1778 |1764 1757 1757 1757 White marble 7593 Overall (confirmed): 30 1/2 × 25 1/4 × 16 3/8 in., 219lb. (77.5 × 64.1 × 41.6 cm, 99.3377kg) Gift of George Blumenthal, 1941                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
116044 67.34 0 1 204720 European Sculpture and Decorative Arts 3 Group 3937 Andromeda and the Sea Monster Italian, Rome 549         Artist|Patron 370 Commissioned by Domenico Guidi|Francesco II, Duke of Mantua and Reggio Italian, 1625–1701|Italian, 1660–1694 , who died before the sculpture's completion Guidi Domenico|Francesco II, Duke of Mantua and Reggio 11188 Italian|Italian 93 1625 |1660 1701 |1694 1694 1694 1694 Marble 750 Overall (confirmed): 64 3/8 x 46 3/8 x 34 5/8 in. (163.5 x 117.8 x 87.9 cm) Purchase, Josephine Bay Paul and C. Michael Paul Foundation Inc. Gift and Charles Ulrick and Josephine Bay Foundation Inc. Gift, 1967                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
116079 67.110.1 1 1 204758 European Sculpture and Decorative Arts 3 Statue 3890 Perseus with the Head of Medusa Italian, Rome 549         Artist|Patron 370 Commissioned by Antonio Canova|Count Jan and Countess Valeria Tarnowski Italian, Possagno 1757–1822 Venice|Dzików, Poland   Canova, Antonio|Tarnowski Jan and Valeria Count and Countess 11193 Italian 6 1757 1822 1804–6 1804 1806 Marble 750 Overall (confirmed): H. 95 1/2 x W. 75 1/2 x D. 40 1/2 in. (242.6 x 191.8 x 102.9 cm) Fletcher Fund, 1967                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
116467 1970.1 0 1 205177 European Sculpture and Decorative Arts 3 Statue 3890 Reclining Naiad Italian, Rome 549         Artist|Patron 370 Commissioned by Antonio Canova|John Bligh, 4th Earl of Darnley Italian, Possagno 1757–1822 Venice , and his studio Canova, Antonio|Darnley, John 11322 Italian 6 1757 |1815 1822 |1831 1819–24 1819 1824 White marble on grey marble 23151 Overall (wt. confirmed): 35 × 75 × 32 1/2 in., 2558 lb. (88.9 × 190.5 × 82.6 cm, 1160.3 kg) Purchase, Mrs. Joseph A. Neff Gift, in memory of Joseph A. Neff, 1970                       Sculpture 12   Metropolitan Museum of Art, New York, NY 1
139010 2004.174 0 1 231004 European Sculpture and Decorative Arts 3 Relief 3917 Nessus Abducting Dejanira Danish, sculpted Rome 3923         Artist|Patron 370 Commissioned by Bertel Thorvaldsen|Count Paolo Marulli Danish, Copenhagen 1770–1844 Copenhagen   Thorvaldsen, Bertel|Marulli, Paolo Count 12617 Danish 144 1770 1844 modeled 1814–15, carved 1821–23 or 1826 1814 1826 Marble 750 Overall (confirmed): H. 39 1/2 x W. 49 1/2 x D. 5 3/4 in. (100.3 x 125.7 x 14.6 cm) European Sculpture and Decorative Arts Fund, 2004                       Sculpture 12   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 2686.488ms · Data license: CC0 · Data source: metmuseum/openaccess