MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Medium = 31673

View and edit SQL

Suggested facets: Title, Portfolio, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Credit Line

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
211305 26.72.14 0 1 338695 Drawings and Prints 11 Print 731 The Penitent Magdalene (Magdalena Poenitens) from the series The Large Landscapes           Artist|Artist|Artist|Publisher 853 After Pieter Bruegel the Elder|Johannes van Doetecum the elder|Lucas van Doetecum|Hieronymus Cock Netherlandish, Breda (?) ca. 1525–1569 Brussels|Netherlandish, active 1554–ca. 1600, died 1605|Netherlandish, active 1554–72, died before 1589|Netherlandish, Antwerp ca. 1510–1570 Antwerp   Bruegel, Pieter, the Elder|Doetecum, Johannes van the elder|Doetecum, Lucas van|Cock, Hieronymus 18710 Netherlandish|Netherlandish|Netherlandish|Netherlandish 829 1525 |1554 |1554 |1510 1569 |1605 |1589 |1570 ca. 1555–56 1555 1556 Etching with engraving; first state of two 31673 sheet: 12 11/16 x 16 7/8 in. (32.3 x 42.8 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
231070 26.49.42 0 1 358771 Drawings and Prints 11 Print 731 Visit to the New Mother         Marriage in the City (Le mariage à la ville) 414 Artist|Publisher 710   Abraham Bosse|Melchior Tavernier French, Tours 1602/1604–1676 Paris|French (born Flanders), Antwerp 1564–1641 Paris   Bosse, Abraham|Tavernier, Melchior 25292 French|French 21 1602 |1564 1676 |1641 1633 1633 1633 Etching with engraving; first state of two 31673 Sheet: 11 5/8 × 14 15/16 in. (29.6 × 38 cm) Plate: 10 1/2 x 13 3/4 in. (26.7 x 35 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
234475 26.72.47 0 1 362231 Drawings and Prints 11 Print 731 Wooded Region (Pagus Nemorosus) from The Large Landscapes           Artist|Artist|Artist|Publisher 853 After Pieter Bruegel the Elder|Johannes van Doetecum the elder|Lucas van Doetecum|Hieronymus Cock Netherlandish, Breda (?) ca. 1525–1569 Brussels|Netherlandish, active 1554–ca. 1600, died 1605|Netherlandish, active 1554–72, died before 1589|Netherlandish, Antwerp ca. 1510–1570 Antwerp   Bruegel, Pieter, the Elder|Doetecum, Johannes van the elder|Doetecum, Lucas van|Cock, Hieronymus 18710 Netherlandish|Netherlandish|Netherlandish|Netherlandish 829 1525 |1554 |1554 |1510 1569 |1605 |1589 |1570 ca. 1555–56 1550 1561 Etching with engraving; first state of two 31673 sheet: 13 5/8 x 17 7/8 in. (34.6 x 45.4 cm) image: 12 3/4 x 15 7/8 in. (32.4 x 40.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
257468 26.49.17 0 1 386153 Drawings and Prints 11 Print 731 Lodge the Pilgrims         Acts of Mercy (Les Oeuvres de Miséricorde) 1353 Artist|Publisher 710   Abraham Bosse|Jean I Leblond French, Tours 1602/1604–1676 Paris|French, ca. 1590–1666 Paris   Bosse, Abraham|Leblond, Jean I 25296 French|French 21 1602 |1585 1676 |1666 1635 1635 1635 Etching with engraving; first state of two 31673 Sheet (trimmed): 10 3/16 × 12 5/16 in. (25.9 × 31.3 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
257663 51.501.2262 0 1 386348 Drawings and Prints 11 Print 731 Feeding the Hungry         Acts of Mercy (Les Oeuvres de Miséricorde) 1353 Artist|Publisher 710   Abraham Bosse|Jean I Leblond French, Tours 1602/1604–1676 Paris|French, ca. 1590–1666 Paris   Bosse, Abraham|Leblond, Jean I 25296 French|French 21 1602 |1585 1676 |1666 1635 1635 1635 Etching with engraving; first state of two 31673 Sheet (trimmed): 10 in. × 12 11/16 in. (25.4 × 32.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
259055 26.49.46 0 1 387752 Drawings and Prints 11 Print 731 The Hotpot Carried to the Newlyweds; or The Racket         Wedding in the Countryside (Le mariage à la campagne) 1392 Artist|Publisher 710   Abraham Bosse|Jean I Leblond French, Tours 1602/1604–1676 Paris|French, ca. 1590–1666 Paris   Bosse, Abraham|Leblond, Jean I 25296 French|French 21 1602 |1585 1676 |1666 ca. 1633 1628 1638 Etching with engraving; first state of two 31673 Sheet: 11 in. × 13 11/16 in. (28 × 34.8 cm) Plate: 10 1/4 × 13 1/16 in. (26.1 × 33.1 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
259056 51.501.2239 0 1 387753 Drawings and Prints 11 Print 731 Charivari         Marriage in the Countryside (Le Mariage à la campagne) 1393 Artist|Publisher 710   Abraham Bosse|Jean I Leblond French, Tours 1602/1604–1676 Paris|French, ca. 1590–1666 Paris   Bosse, Abraham|Leblond, Jean I 25296 French|French 21 1602 |1585 1676 |1666 ca. 1633 1628 1638 Etching with engraving; first state of two 31673 Sheet (trimmed): 10 in. × 12 15/16 in. (25.4 × 32.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1951                       Prints 13   Metropolitan Museum of Art, New York, NY 1
259073 51.501.2235 0 1 387770 Drawings and Prints 11 Print 731 Visit to the New Mother         Marriage in the City (Le Mariage à la ville) 1391 Artist|Publisher 710   Abraham Bosse|Melchior Tavernier French, Tours 1602/1604–1676 Paris|French (born Flanders), Antwerp 1564–1641 Paris   Bosse, Abraham|Tavernier, Melchior 25292 French|French 21 1602 |1564 1676 |1641 1633 1633 1633 Etching with engraving; first state of two 31673 Sheet (trimmed): 10 3/8 × 13 9/16 in. (26.4 × 34.5 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 94.995ms · Data license: CC0 · Data source: metmuseum/openaccess