MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Medium = 33314

View and edit SQL

Suggested facets: Is Public Domain, Title, 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
215008 2000.361.3 0 1 342431 Drawings and Prints 11 Print 731 Herdsman and Bull, after Ruisdael           Artist|Artist 13 After Jean Jacques de Boissieu|Jacob van Ruisdael French, Lyons 1736–1810 Lyons|Dutch, Haarlem 1628/29–1682 Amsterdam   Boissieu, Jean Jacques de|Ruisdael, Jacob van 19312 French|Dutch 310 1736 |1628 1810 |1682 1772 1772 1772 Etching with drypoint; fourth state of four 33314 Sheet: 7 5/16 × 7 7/8 in. (18.5 × 20 cm) Gift of James David Draper, 2001                       Prints 13   Metropolitan Museum of Art, New York, NY 1
215015 2000.361.10 0 1 342438 Drawings and Prints 11 Print 731 View of Saint-Andéol           Artist 2   Jean Jacques de Boissieu French, Lyons 1736–1810 Lyons   Boissieu, Jean Jacques de 18397 French 2 1736 1810 1774 1774 1774 Etching with drypoint; fourth state of four 33314 Sheet: 12 5/16 × 15 9/16 in. (31.2 × 39.5 cm) Plate: 11 1/2 × 14 3/4 in. (29.2 × 37.4 cm) Gift of James David Draper, 2000                       Prints 13   Metropolitan Museum of Art, New York, NY 1
215016 2000.361.11 0 1 342439 Drawings and Prints 11 Print 731 The School Master           Artist 2   Jean Jacques de Boissieu French, Lyons 1736–1810 Lyons   Boissieu, Jean Jacques de 18397 French 2 1736 1810 1780 1780 1780 Etching with drypoint; fourth state of four 33314 Sheet: 9 13/16 × 13 7/8 in. (25 × 35.3 cm) Gift of James David Draper, 2000                       Prints 13   Metropolitan Museum of Art, New York, NY 1
215017 2000.361.12 0 0 342440 Drawings and Prints 11 Print 731 The School Master (Le grand Maître d'École)           Artist 2   Jean Jacques de Boissieu French, Lyons 1736–1810 Lyons   Boissieu, Jean Jacques de 18397 French 2 1736 1810 1780 1780 1780 Etching with drypoint; fourth state of four 33314 sheet: 19 11/16 x 14 1/4 in. (50 x 36.2 cm) plate: 10 1/4 x 13 9/16 in. (26 x 34.5 cm) Gift of James David Draper, 2000                       Prints 13   Metropolitan Museum of Art, New York, NY 1
256501 61.622.27 0 1 385178 Drawings and Prints 11 Print 731 The School Master           Artist 2   Jean Jacques de Boissieu French, Lyons 1736–1810 Lyons   Boissieu, Jean Jacques de 18397 French 2 1736 1810 1780 1780 1780 Etching with drypoint; fourth state of four 33314 Sheet: 9 5/8 x 13 13/16 in. (24.4 x 35.1 cm) Purchase, The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1961                       Prints 13   Metropolitan Museum of Art, New York, NY 1
266426 19.56.55 0 1 395406 Drawings and Prints 11 Print 731 Interior of a Farm at Saint-Jean-de-Touslas           Artist 2   Jean Jacques de Boissieu French, Lyons 1736–1810 Lyons   Boissieu, Jean Jacques de 18397 French 2 1736 1810 1793 1793 1793 Etching with drypoint; fourth state of four 33314 Sheet: 10 1/16 × 13 3/4 in. (25.6 × 35 cm) Plate: 8 11/16 × 13 1/16 in. (22 × 33.2 cm) Gift of Mrs. Algernon S. Sullivan, 1919                       Prints 13   Metropolitan Museum of Art, New York, NY 1
266429 33.3.6 0 1 395409 Drawings and Prints 11 Print 731 Harvesters Resting           Artist|Artist 13 After Jean Jacques de Boissieu|Adriaen van de Velde French, Lyons 1736–1810 Lyons|Dutch, Amsterdam 1636–1672 Amsterdam   Boissieu, Jean Jacques de|Velde, Adriaen van de 39253 French|Dutch 310 1736 |1636 1810 |1672 1795 1795 1795 Etching with drypoint; fourth state of four 33314 Sheet: 11 3/16 x 14 5/8 in. (28.4 x 37.2 cm) Gift of Fräulein Sofie Krick, 1933                       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 162.145ms · Data license: CC0 · Data source: metmuseum/openaccess