MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where Artist Alpha Sort = 23263

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, 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 Repository
220426 61.17 0 1 347960 Drawings and Prints 11 Drawing 23 Landscape           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263 Dutch 11 1627 1692 17th century 1640 1692 Pen, brown ink, brush and gray wash on beige paper. Framing line in pen & black ink. 34690 sheet: 7 x 9 5/8 in. (17.8 x 24.4 cm) Rogers Fund, 1961                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
222073 2001.636 0 1 349633 Drawings and Prints 11 Drawing 23 The Castle Meerdevoort, near Dordrecht           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263 Dutch 11 1627 1692 1647 1647 1647 Black chalk, gray wash 29958 sheet: 13 9/16 x 19 7/8 in. (34.5 x 50.5 cm) Frits and Rita Markus Fund, 2001                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321363 1975.1.808 0 1 459332 Robert Lehman Collection 16 Drawing 23 River Landscape with Rocky Cliffs           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263 Dutch 11 1627 1692 after 1647 1647 1670 Pen and brush and washes in tints of brown and gray ink over black chalk; framing line in pen and brown ink probably by the artist. 47891 6 x 9 1/8 in. (15.2 x 23.1 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
321364 1975.1.807 0 1 459333 Robert Lehman Collection 16 Drawing 23 Mountainous River Landscape with Figures           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263 Dutch 11 1627 1692 after 1647 1647 1670 Pen and dark brown ink, brush and light brown ink and grayish brown wash over black chalk; framing line in pen and brown ink probably by the artist. 47892 6 x 9 3/16 in. (15.3 x 23.4 cm) Robert Lehman Collection, 1975                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
432861 63.621.9 0 0 719124 Drawings and Prints 11 Print 731 Buyten Haerlem, Plate 2 from Eight Landscapes with Views in Various Provinces           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 ca. 1645–77 1640 1677 Etching 26137 Sheet: 5 3/16 × 8 5/16 in. (13.2 × 21.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Prints 13   Metropolitan Museum of Art, New York, NY 1
432863 63.621.10 0 0 719126 Drawings and Prints 11 Print 731 Buyten Utrecht, Plate 3 from Eight Landscapes with Views in Various Provinces           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 ca. 1645–77 1640 1677 Etching 26137 Sheet: 5 3/16 × 8 1/8 in. (13.2 × 20.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1963                       Prints 13   Metropolitan Museum of Art, New York, NY 1
432865 62.557.66 0 0 719128 Drawings and Prints 11 Print 731 Rocky Landscape with Cross, Plate 5 from Eight Tyrolean Landscapes           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 1650–83 1650 1683 Etching 26137 Sheet (trimmed): 5 in. × 6 9/16 in. (12.7 × 16.7 cm) Gift of Mrs. Olga Sichel and Max Philippson, 1962                       Prints 13   Metropolitan Museum of Art, New York, NY 1
432867 62.557.67 0 0 719130 Drawings and Prints 11 Print 731 The Waterfall, Plate 6 from Eight Tyrolean Landscapes           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 1650–83 1650 1683 Etching 26137 Sheet (trimmed): 4 5/8 × 5 7/8 in. (11.7 × 14.9 cm) Gift of Mrs. Olga Sichel and Max Philippson, 1962                       Prints 13   Metropolitan Museum of Art, New York, NY 1
432868 17.50.15-215 0 0 719131 Drawings and Prints 11 Print 731 Buyten Naerden, Plate 1 from Eight Landscapes with Views in Various Provinces           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 ca. 1640–77 1635 1677 Etching 26137 Sheet: 4 5/8 × 6 1/8 in. (11.8 × 15.5 cm) Purchase, Joseph Pulitzer Bequest, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
433481 51.501.5216 0 0 719935 Drawings and Prints 11 Print 731 Plate 6 from Six Views in the Wood of the Hague           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 ca. 1645–60 1640 1660 Etching 26137 Sheet (trimmed): 8 3/16 × 10 5/16 in. (20.8 × 26.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434579 51.501.5235 0 0 722470 Drawings and Prints 11 Print 731 'T Veer by Schoonhoven, Plate 4 from Eight Landscapes with Views in the Provinces of Holland and Utrecht           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 ca. 1645–92 1640 1692 Etching 26137 Sheet (trimmed): 5 1/8 × 6 3/8 in. (13 × 16.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434584 51.501.5236 0 0 722475 Drawings and Prints 11 Print 731 Hedickhuysen, Plate 2 from Eight Landscapes with Views in the Provinces of Holland and Utrecht           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 ca. 1645–92 1640 1692 Etching 26137 Sheet (trimmed): 5 1/16 × 6 5/16 in. (12.8 × 16.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434585 51.501.5237 0 0 722476 Drawings and Prints 11 Print 731 The Bridge, Plate 7 from Eight Tirolian Landscapes           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 ca. 1645–92 1640 1692 Etching 26137 Sheet (trimmed): 5 1/16 × 6 5/16 in. (12.8 × 16.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
434587 51.501.5238 0 0 722479 Drawings and Prints 11 Print 731 Slooten, Plate 8 from Eight Landscapes with Views in the Provinces of Holland and Utrecht           Artist 2   Roelant Roghman Dutch, Amsterdam 1627–1692 Amsterdam   Roghman, Roelant 23263   1627 1692 ca. 1645–92 1640 1692 Etching 26137 Sheet (trimmed): 5 3/8 × 6 9/16 in. (13.6 × 16.6 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   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 123.763ms · Data license: CC0 · Data source: metmuseum/openaccess