MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where "Artist End Date" is on date -4708-06-19 and Culture = 4

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Begin Date

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
321351 321351 1975.1.790 0 1 459320 Robert Lehman Collection 16 Drawing 23 Abraham and Isaac before the Sacrifice Dutch 4         Artist 2   School of Rembrandt van Rijn Dutch, 1606–1669   Rembrandt, van Rijn, School of 44420   1606 1669 ca. 1644–45 1641 1648 Pen and brush and brown ink. 47881 6 1/8 x 5 11/16 in. (15.6 x 14.4 cm) Strip of paper added later at the right: 1.5 x 7.7 cm. Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459320 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321352 321352 1975.1.802 0 1 459321 Robert Lehman Collection 16 Drawing 23 Two Studies for Blind Tobit Dutch 4         Artist 2   School of Rembrandt van Rijn Dutch, 1606–1669   Rembrandt, van Rijn, School of 44420   1606 1669 ca. 1651 1648 1654 Pen and brown inks and grayish brown wash. 47882 8 1/4 x 10 1/4 in. (21 x 26.1 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459321 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321354 321354 1975.1.793 0 1 459323 Robert Lehman Collection 16 Drawing 23 The Martyrdom of Saint Peter Dutch 4         Artist 2   School of Rembrandt van Rijn Dutch, 1606–1669   Rembrandt, van Rijn, School of 44420   1606 1669 late 1650s 1655 1659 Reed pen and brush and brown ink and brown wash. 47883 7 15/16 x 10 13/16 in. (20.1 x 27.4 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459323 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321355 321355 1975.1.791 0 1 459324 Robert Lehman Collection 16 Drawing 23 Beheading of Anabaptist Martyrs Dutch 4         Artist 2   School of Rembrandt van Rijn Dutch, 1606–1669   Rembrandt, van Rijn, School of 44420   1606 1669 ca. 1640 1637 1643 Pen and brown ink with brush and brown and gray wash. 47884 7 1/8 x 5 1/4 in. (18.1 x 13.3 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459324 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321356 321356 1975.1.798 0 1 459325 Robert Lehman Collection 16 Drawing 23 A Hawker Showing an Animal in a Cage to a Woman and Her Child Dutch 4         Artist 2   School of Rembrandt van Rijn Dutch, 1606–1669   Rembrandt, van Rijn, School of 44420   1606 1669 mid-17th century 1636 1670 Reed pen and brown ink, pen and gray washes; verso in pen and dark brown ink. 47885 5 1/4 x 5 1/8 in. (13.4 x 13 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459325 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321357 321357 1975.1.797 0 1 459326 Robert Lehman Collection 16 Drawing 23 Old Woman with a Baby in her Arms Dutch 4         Artist 2   School of Rembrandt van Rijn Dutch, 1606–1669   Rembrandt, van Rijn, School of 44420   1606 1669 ca. 1643 1640 1646 Pen and brown ink, with wash in three shades of brown and gray. 47886 6 1/4 x 4 11/16 in. (15.9 x 11.9 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459326 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
321358 321358 1975.1.795 0 1 459327 Robert Lehman Collection 16 Drawing 23 An Officer Holding a Ceremonial Sword Dutch 4         Artist 2   School of Rembrandt van Rijn Dutch, 1606–1669   Rembrandt, van Rijn, School of 44420   1606 1669 1640s 1640 1649 Pen and brush and brown inks. 47887 7 7/8 x 4 1/2 in. (20 x 11.5 cm) Robert Lehman Collection, 1975                       Drawings 9   http://www.metmuseum.org/art/collection/search/459327 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 208.509ms · Data license: CC0 · Data source: metmuseum/openaccess