MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

17 rows where Artist Nationality = 34 and Classification = 12

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Rights and Reproduction

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
9799 9799 94.9.4 0 1 10573 American Paintings and Sculpture 2 Sculpture 100 The Babes in the Wood           Artist 2   Thomas Crawford American, New York 1813?–1857 London   Crawford, Thomas 1367 American  34 1813 1857 ca. 1850, carved 1851 1847 1851 Marble 750 17 x 49 x 33 1/2 in. (43.2 x 124.5 x 85.1 cm) Bequest of Hamilton Fish, 1894                       Sculpture 12   http://www.metmuseum.org/art/collection/search/10573 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
9800 9800 97.13.1 1 1 10574 American Paintings and Sculpture 2 Sculpture 100 Genius of Mirth           Artist 2   Thomas Crawford American, New York 1813?–1857 London   Crawford, Thomas 1367 American  34 1813 1857 1842; carved 1843 1842 1843 Marble 750 47 x 20 x 24 in. (119.4 x 50.8 x 61 cm) Bequest of Annette W. W. Hicks-Lord, 1896                       Sculpture 12   http://www.metmuseum.org/art/collection/search/10574 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
9801 9801 97.13.2a–e 0 1 10575 American Paintings and Sculpture 2 Sculpture 100 Mexican Girl Dying           Artist 2   Thomas Crawford American, New York 1813?–1857 London   Crawford, Thomas 1367 American  34 1813 1857 By 1846; carved 1848 1846 1848 Marble 750 20 1/4 x 54 1/2 x 19 1/2 in. (51.4 x 138.4 x 49.5 cm) Bequest of Annette W. W. Hicks-Lord, 1896                       Sculpture 12   http://www.metmuseum.org/art/collection/search/10575 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
12064 12064 1979.394 1 1 13134 American Paintings and Sculpture 2 Sculpture 100 The Freedman           Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1863, cast 1891 1863 1891 Bronze 23 19 1/2 x 14 3/4 x 9 3/4 in. (49.5 x 37.5 x 24.8 cm) Gift of Charles Anthony Lamb and Barea Lamb Seeley, in memory of their grandfather, Charles Rollinson Lamb, 1979                       Sculpture 12   http://www.metmuseum.org/art/collection/search/13134 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
12065 12065 1972.33 0 1 13135 American Paintings and Sculpture 2 Statuette 14 Henry B. Hyde           Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1901 1901 1901 Bronze 23 21 x 7 1/2 x 6 1/4 in. (53.3 x 19.1 x 15.9 cm) Gift of The Equitable Life Assurance Society of the United States, 1972                       Sculpture 12   http://www.metmuseum.org/art/collection/search/13135 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
12066 12066 17.90.4 0 1 13136 American Paintings and Sculpture 2 Sculpture 100 Henry Ward Beecher           Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1891; cast after 1910 1891 1911 Bronze 23 14 1/2 x 9 x 5 1/2 in. (36.8 x 22.9 x 14 cm) Rogers Fund, 1917                       Sculpture 12   http://www.metmuseum.org/art/collection/search/13136 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
12067 12067 1973.257 1 1 13137 American Paintings and Sculpture 2 Sculpture 100 The Indian Hunter           Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1860, cast before 1910 1860 1909 Bronze 23 16 1/8 x 10 1/2 x 15 1/4 in. (41 x 26.7 x 38.7 cm) Morris K. Jesup Fund, 1973                       Sculpture 12   http://www.metmuseum.org/art/collection/search/13137 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
12068 12068 1972.1a, b 0 1 13138 American Paintings and Sculpture 2 Statuette 14 George Washington           Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1882; cast ca. 1911 1882 1914 Bronze 23 23 3/4 x 12 3/8 x 10 in. (60.3 x 31.4 x 25.4 cm) Rogers Fund, 1972                       Sculpture 12   http://www.metmuseum.org/art/collection/search/13138 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
12069 12069 17.90.3 0 1 13139 American Paintings and Sculpture 2 Sculpture 100 Study of the Horse for the Statue of Major General George Henry Thomas           Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1879, cast after 1910 1879 1911 Bronze 23 20 x 18 x 5 in. (50.8 x 45.7 x 12.7 cm) Rogers Fund, 1917                       Sculpture 12   http://www.metmuseum.org/art/collection/search/13139 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
12070 12070 17.90.2 0 1 13140 American Paintings and Sculpture 2 Sculpture 100 William Shakespeare           Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1870, cast after 1910 1870 1911 Bronze 23 28 x 11 x 11 in. (71.1 x 27.9 x 27.9 cm) Rogers Fund, 1917                       Sculpture 12   http://www.metmuseum.org/art/collection/search/13140 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
12071 12071 10.200 0 1 13141 American Paintings and Sculpture 2 Bust 5 William Tilden Blodgett           Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1865 1865 1865 Marble 750 26 x 15 1/2 x 10 1/2 in. (66 x 39.4 x 26.7 cm) Gift of Mrs. John Quincy Adams Ward, 1910                       Sculpture 12   http://www.metmuseum.org/art/collection/search/13141 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17019 17019 SL.1.2013.34.3 0 0 21191 American Decorative Arts 1 Sculpture 100 The Indian Hunter American 1         Artist 2   John Quincy Adams Ward American, Urbana, Ohio 1830–1910 New York   Ward, John Quincy Adams 1903 American  34 1830 1910 1860 1860 1860 Bronze 23 16 1/4 × 9 1/4 × 14 1/4 in. (41.3 × 23.5 × 36.2 cm) Daniel and Mathew Wolf in memory of Diane R. Wolf                       Sculpture 12   http://www.metmuseum.org/art/collection/search/21191 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
337083 337083 1986.419.2 0 0 484637 Modern and Contemporary Art 4 Sculpture 100 Curve XXXII           Artist 2   Ellsworth Kelly American, Newburgh, New York 1923–2015 Spencertown, New York   Kelly, Ellsworth 26480 American  34 1923 2015 1982 1982 1982 (Corten) "Weathering" steel 51709 108 x 104 1/4 x 18 1/4 in. (274.3 x 264.8 x 46.4 cm) Anonymous Gift, 1986                       Sculpture 12   http://www.metmuseum.org/art/collection/search/484637 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
337186 337186 1987.225 0 0 484751 Modern and Contemporary Art 4 Sculpture 100 Walla Walla Robe           Artist 2   Jim Dine American, born Cincinnati, Ohio, 1935   Dine, Jim 26391 American  34 1935 2035 1984 1984 1984 Painted bronze 51479 48 x 37 1/2in. (121.9 x 95.3cm) Purchase, Mr. and Mrs. Milton Petrie Gift, 1987                       Sculpture 12 © 2010 Jim Dine / Artists Rights Society (ARS), New York http://www.metmuseum.org/art/collection/search/484751 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
337230 337230 1987.363 0 0 484797 Modern and Contemporary Art 4 Sculpture 100 History of Black Bronze I           Artist 2   Jim Dine American, born Cincinnati, Ohio, 1935   Dine, Jim 26391 American  34 1935 2035 1983 1983 1983 Bronze 23 53 1/4 × 48 × 20 in. (135.3 × 121.9 × 50.8 cm) Weight: 195 lb. (88.5 kg) Gift of Industrial Petro-Chemicals, Inc., 1987                       Sculpture 12 © 2010 Jim Dine / Artists Rights Society (ARS), New York http://www.metmuseum.org/art/collection/search/484797 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
337382 337382 1987.91ab 0 0 484953 Modern and Contemporary Art 4 Sculpture 100 The Crommelynck Gate with Tools           Artist 2   Jim Dine American, born Cincinnati, Ohio, 1935   Dine, Jim 26391 American  34 1935 2035 1983 1983 1983 Painted bronze 51479 107 3/4 x 69 x 38in. (273.7 x 175.3 x 96.5cm) Purchase, Linda and Morton L. Janklow Gift, 1987                       Sculpture 12 © 2010 Jim Dine / Artists Rights Society (ARS), New York http://www.metmuseum.org/art/collection/search/484953 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
344429 344429 2007.534 0 0 495449 Modern and Contemporary Art 4 Sculpture 100 Untitled (Head)           Artist 2   Jim Dine American, born Cincinnati, Ohio, 1935   Dine, Jim 26391 American  34 1935 2035 1959 1959 1959 Oil on plaster over wire armature of electric fan 53703 Diam.: 14 in. (35.6 cm) H: 10 in. (25.4 cm) Gift of Stanley Posthorn, 2007                       Sculpture 12 © 2018 Artists Rights Society (ARS), New York http://www.metmuseum.org/art/collection/search/495449 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 1172.882ms · Data license: CC0 · Data source: metmuseum/openaccess