MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

21 rows where Artist Alpha Sort = 18743

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Is Public Domain, Department, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

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
210111 210111 1995.196 1 1 337493 Drawings and Prints 11 Drawing 23 Dune Landscape with Oak Tree           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 1650–55 1650 1655 Black chalk; brush and gray wash; gouache; framing lines in pen and brown ink. 30998 8 1/4 x 7 1/2 in. (21.0 x 19.1 cm) Fletcher Fund, 1995                       Drawings 9   http://www.metmuseum.org/art/collection/search/337493 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
220557 220557 1975.131.162 0 1 348092 Drawings and Prints 11 Drawing 23 Canal Landscape with a Fisherman           Artist 2 Attributed to Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1640 1682 Black chalk, brush and gray wash. Framing line in pen & brown ink 34719 sheet: 5 1/16 x 7 15/16 in. (12.9 x 20.2 cm) Bequest of Harry G. Sperling, 1971                       Drawings 9   http://www.metmuseum.org/art/collection/search/348092 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
220584 220584 1975.131.163 0 1 348119 Drawings and Prints 11 Drawing 23 House among Trees, at Right Man and Dog on a Footbridge           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1640 1682 Black chalk 29155 sheet: 5 3/8 x 7 3/16 in. (13.6 x 18.2 cm) Bequest of Harry G. Sperling, 1971                       Drawings 9   http://www.metmuseum.org/art/collection/search/348119 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
220585 220585 1994.88 0 1 348120 Drawings and Prints 11 Drawing 23 Dredging a Canal           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1640 1682 Pen and black ink over black chalk, brush and gray wash. Framing line in pen & brown ink. 34725 sheet: 3 9/16 x 5 15/16 in. (9.1 x 15.1 cm) Purchase, Mrs. Carl L. Selden Gift, in memory of Carl L. Selden, and Werner H. Kramarsky and Mr. and Mrs. Howard G. Lepow Gifts, 1994                       Drawings 9   http://www.metmuseum.org/art/collection/search/348120 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
232010 232010 26.72.10 0 1 359755 Drawings and Prints 11 Print 731 The Great Beech (Two Farmers with their Dog)           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 ca. 1652 1647 1657 Etching; first state of three 30755 image: 7 7/16 x 10 13/16 in. (18.9 x 27.5 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   http://www.metmuseum.org/art/collection/search/359755 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
232113 232113 26.72.9 0 1 359859 Drawings and Prints 11 Print 731 A Forest Marsh with Travelers on a Bank (The Travelers)           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1628 1682 Etching, first state of four 36715 image: 7 1/4 x 10 11/16 in. (18.4 x 27.1 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   http://www.metmuseum.org/art/collection/search/359859 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
237359 237359 25.2.62 0 0 365341 Drawings and Prints 11 Print 731 The Wheat-field (Cornfield)           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1640 1682 Etching; second state 29005 plate: 4 x 6 in. (10.2 x 15.2 cm) sheet: 4 3/16 x 6 1/8 in. (10.6 x 15.6 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   http://www.metmuseum.org/art/collection/search/365341 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
237360 237360 22.31 0 1 365342 Drawings and Prints 11 Print 731 The Little Bridge (Le Petit Pont)           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1600 1699 Etching; first state of two 29408 plate: 7 11/16 x 11 in. (19.5 x 27.9 cm) sheet: 8 1/8 x 11 5/8 in. (20.6 x 29.5 cm) Rogers Fund, 1922                       Prints 13   http://www.metmuseum.org/art/collection/search/365342 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
239081 239081 47.100.117 0 0 367146 Drawings and Prints 11 Print 731 The Little Bridge           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1640 1682 Etching; second state 29005   Harris Brisbane Dick Fund, 1947                       Prints 13   http://www.metmuseum.org/art/collection/search/367146 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
239082 239082 23.65.25 0 0 367147 Drawings and Prints 11 Print 731 The Little Bridge           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1628 1682 Etching; second state 29005   Gift of Theodore De Witt, 1923                       Prints 13   http://www.metmuseum.org/art/collection/search/367147 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
239083 239083 23.54.3 0 0 367148 Drawings and Prints 11 Print 731 The Little Bridge           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1628 1682 Etching; second state 29005   Gift of M. Knoedler & Co., 1923                       Prints 13   http://www.metmuseum.org/art/collection/search/367148 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
239084 239084 19.74.20 0 1 367149 Drawings and Prints 11 Print 731 The Great Beech           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1640 1682 Etching; second state 29005 image: 7 1/4 x 10 9/16 in. (18.3 x 26.8 cm) sheet: 7 5/8 x 11 in. (19.4 x 27.9 cm) Rogers Fund, 1919                       Prints 13   http://www.metmuseum.org/art/collection/search/367149 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
239085 239085 19.74.19 0 0 367150 Drawings and Prints 11 Print 731 Cottage on the Hill           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1640 1682 Etching; third state 30316   Rogers Fund, 1919                       Prints 13   http://www.metmuseum.org/art/collection/search/367150 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
239086 239086 19.74.18 0 0 367151 Drawings and Prints 11 Print 731 A Forest Marsh with Travelers on a Bank           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 17th century 1640 1682 Etching; third state 30316   Rogers Fund, 1919                       Prints 13   http://www.metmuseum.org/art/collection/search/367151 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
239087 239087 17.50.15-346 0 0 367152 Drawings and Prints 11 Print 731 The Wheat Field           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 mid-17th century 1640 1682 Etching; fourth state 36117   Purchase, Joseph Pulitzer Bequest, 1917                       Prints 13   http://www.metmuseum.org/art/collection/search/367152 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
239088 239088 17.50.15-329 0 1 367153 Drawings and Prints 11 Print 731 The Three Oaks           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 mid-17th century 1640 1682 Etching; second state 29005 Sheet: 4 5/8 × 5 3/4 in. (11.7 × 14.6 cm) Purchase, Joseph Pulitzer Bequest, 1917                       Prints 13   http://www.metmuseum.org/art/collection/search/367153 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307424 307424 65.181.10 0 1 437545 European Paintings 15 Painting 69 Landscape with a Village in the Distance           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 1646 1646 1646 Oil on wood 156 30 x 43 in. (76.2 x 109.2 cm) Bequest of Adele L. Lehman, in memory of Arthur Lehman, 1965                       Paintings 11   http://www.metmuseum.org/art/collection/search/437545 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307425 307425 89.15.4 0 1 437546 European Paintings 15 Painting 69 The Forest Stream           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 ca. 1660 1655 1665 Oil on canvas 953 39 1/4 x 50 7/8 in. (99.7 x 129.2 cm) Marquand Collection, Gift of Henry G. Marquand, 1889                       Paintings 11   http://www.metmuseum.org/art/collection/search/437546 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307426 307426 32.100.14 0 1 437547 European Paintings 15 Painting 69 Grainfields           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 mid- or late 1660s 1664 1669 Oil on canvas 953 18 1/2 x 22 1/2 in. (47 x 57.2 cm) The Friedsam Collection, Bequest of Michael Friedsam, 1931                       Paintings 11   http://www.metmuseum.org/art/collection/search/437547 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307427 307427 25.110.18 0 1 437548 European Paintings 15 Painting 69 Mountain Torrent           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 1670s 1670 1679 Oil on canvas 953 21 1/4 x 16 1/2 in. (54 x 41.9 cm) Bequest of Collis P. Huntington, 1900                       Paintings 11   http://www.metmuseum.org/art/collection/search/437548 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307428 307428 14.40.623 1 1 437549 European Paintings 15 Painting 69 Wheat Fields           Artist 2   Jacob van Ruisdael Dutch, Haarlem 1628/29–1682 Amsterdam   Ruisdael, Jacob van 18743 Dutch 11 1628 1682 ca. 1670 1665 1675 Oil on canvas 953 39 3/8 x 51 1/4 in. (100 x 130.2 cm) Bequest of Benjamin Altman, 1913                       Paintings 11   http://www.metmuseum.org/art/collection/search/437549 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 142.837ms · Data license: CC0 · Data source: metmuseum/openaccess