MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

6 rows where Artist Nationality = 2529

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Artist Role, Artist Prefix, Object 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 Repository
237294 51.501.7722 0 0 365276 Drawings and Prints 11 Print 731 Forest at Dawn with a Deer Hunt           Artist|Artist|Publisher 895 After|Etched by|Published by Peter Paul Rubens|Schelte Adams à Bolswert|Gillis Hendricx Flemish, Siegen 1577–1640 Antwerp|Dutch, Bolsward 1581–1659 Antwerp|Flemish, active 1640–1677   Rubens, Peter Paul|Bolswert, Schelte Adams à|Hendricx, Gillis 32452 Flemish|Dutch|Flemish 2529 1577 |1581 |1640 1640 |1659 |1677 ca. 1635–40 1630 1645 Etching and engraving 6712 image: 12 x 17 5/16 in. (30.5 x 44 cm) sheet: 12 9/16 x 17 11/16 in. (31.9 x 44.9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
249543 1994.610(26) 0 0 377986 Drawings and Prints 11 Print 731 Ernestina de Ligne           Artist|Artist|Publisher 895 after Anthony van Dyck|Michael Noël Natalis|Johannes Meyssens Flemish, Antwerp 1599–1641 London|Dutch, Liège 1611–1668 Liège|Flemish, Brussels 1612–1670 Antwerp   Dyck, Anthony van|Natalis, Michael Noël|Meyssens, Johannes 35517 Flemish|Dutch|Flemish 2529 1599 |1611 |1612 1641 |1668 |1670 17th century 1612 1668 Engraving; first state 30349 Sheet: 15 3/8 x 10 9/16 in. (39.1 x 26.9 cm) Plate: 10 3/8 x 7 9/16 in. (26.4 x 19.2 cm) Purchase, Lila Acheson Wallace Gift, Gifts in Memory of Jacob Bean, and various donors, 1994                       Prints|Albums 684   Metropolitan Museum of Art, New York, NY 1
270096 2011.461 0 1 399222 Drawings and Prints 11 Drawing 23 Christ Healing the Paralytic           Artist|Former Attribution|Former Attribution 1248   Jacob Jordaens|Jan (Gerritsz.) van Bronchorst|Anonymous, Flemish, 17th century Flemish, Antwerp 1593–1678 Antwerp|Dutch, Utrecht ca. 1603–ca. 1661 Amsterdam   Jordaens, Jacob|Bronchorst, Jan (Gerritsz.) van|Anonymous, Flemish, 17th century 40102 Flemish|Dutch|Flemish 2529 1593 |1600 |1600 1678 |1665 |1700 ca. 1616–20 1616 1620 Pen and brown ink, brown wash 25571 sheet: 5 1/4 x 7 15/16 in. (13.3 x 20.2 cm) Frits and Rita Markus Fund, 2011                       Drawings 9   Metropolitan Museum of Art, New York, NY 1
393612 17.3.756–389 0 0 646239 Drawings and Prints 11 print 5846 Paulus Pontius           Artist|Artist|Publisher 895 After Pieter de Jode II|Jan Lievens|Johannes Meyssens Flemish, 1606–ca. 1674|Dutch, Leiden 1607–1674 Amsterdam|Flemish, Brussels 1612–1670 Antwerp   Jode, Pieter de II|Lievens, Jan|Meyssens, Johannes 50135 Flemish|Dutch|Flemish 2529 1606 |1607 |1612 1674 |1674 |1670 17th century 1600 1699 Engraving 7208   Harris Brisbane Dick Fund, 1917                       Prints 13   Metropolitan Museum of Art, New York, NY 1
393614 51.501.5689 0 0 646241 Drawings and Prints 11 print 5846 Cornelis Danckerts de Ry, Architect in Amsterdam           Artist|Artist|Artist 53 After Pieter de Jode II|Cornelis Danckertsz. I|Johannes Meyssens Flemish, 1606–ca. 1674|Dutch, ca. 1603–1656|Flemish, Brussels 1612–1670 Antwerp   Jode, Pieter de II|Danckertsz., Cornelis I|Meyssens, Johannes 50137 Flemish|Dutch|Flemish 2529 1606 |1603 |1612 1674 |1656 |1670 1620–74 1620 1674 Engraving 7208   The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
393658 49.95.2496 0 0 646290 Drawings and Prints 11 Print 731 William II of Orange-Nassau from Theatrum pontificum, imperatorum, regum, ducum, principum           Publisher|Artist|Artist 878 After Pieter de Jode II|Gerrit van Honthorst|Anonymous, Flemish, 17th century Flemish, 1606–ca. 1674|Dutch, Utrecht 1592–1656 Utrecht   Jode, Pieter de II|Honthorst, Gerrit van|Anonymous, Flemish, 17th century 50152 Flemish|Dutch|Flemish 2529 1606 |1592 |1600 1674 |1656 |1700 1641 1641 1641 Engraving 7208   The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949                       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 139.321ms · Data license: CC0 · Data source: metmuseum/openaccess