MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

7 rows where Medium = 40997

View and edit SQL

Suggested facets: Is Public Domain, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Nationality, Artist Begin Date, Artist End Date, Object Begin 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
255366 22.1.9 0 1 384003 Drawings and Prints 11 Print 731 Portrait of Rabelais           Artist|Sitter 972   Félix Bracquemond|François Rabelais French, Paris 1833–1914 Sèvres|French, 1494?–1553   Bracquemond, Félix|Rabelais, François 36649 French|French 21 1833 |1494 1914 |1553 1868 1868 1868 Etching; early state 40997 Sheet: 9 13/16 × 6 5/8 in. (24.9 × 16.8 cm) Plate: 6 1/4 × 4 3/4 in. (15.9 × 12.1 cm) Gift of David Keppel, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
257016 26.49.13 0 1 385694 Drawings and Prints 11 Print 731 The Foolish Virgins Rejected         The Wise Virgins and The Foolish Virgins (Les Vierges sages et les Vierges folles) 1344 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. 1635 1630 1640 Etching; early state 40997 Sheet: 13 7/16 in. × 18 in. (34.2 × 45.7 cm) Plate: 10 1/16 × 12 11/16 in. (25.6 × 32.2 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
262380 33.30(9a) 0 0 391300 Drawings and Prints 11 Print 731 Lord Kames, Hugo Arnott, Esq., Advocate, and Lord Monboddo           Artist 2   John Kay British, Dalkeith, Scotland 1742–1826 Edinburgh   Kay, John 26525 British, Scottish 8 1742 1826 1784 1784 1784 Etching; early state 40997 plate: 3 3/16 x 4 15/16 in. (8.1 x 12.6 cm) sheet: 5 5/8 x 7 3/8 in. (14.3 x 18.7 cm) Harris Brisbane Dick Fund, 1933                       Prints 13   Metropolitan Museum of Art, New York, NY 1
262389 33.30(10a) 0 0 391309 Drawings and Prints 11 Print 731 Lord Gardenston, late one of the Lords of the Court of Session           Artist 2   John Kay British, Dalkeith, Scotland 1742–1826 Edinburgh   Kay, John 26525 British, Scottish 8 1742 1826 ca. 1784 1779 1789 Etching; early state 40997 sheet: 3 11/16 x 4 13/16 in. (9.4 x 12.2 cm) Harris Brisbane Dick Fund, 1933                       Prints 13   Metropolitan Museum of Art, New York, NY 1
262484 33.30(67a) 0 0 391404 Drawings and Prints 11 Print 731 Adam Ritchie           Artist|Sitter 972 Portrait of John Kay|Adam Ritchie British, Dalkeith, Scotland 1742–1826 Edinburgh|British (born Scotland), 1683–1789   Kay, John|Ritchie, Adam 38193 British, Scottish|British, Scottish 414 1742 |1683 1826 |1789 1786 1786 1786 Etching; early state 40997 plate: 6 1/16 x 3 3/4 in. (15.4 x 9.6 cm) sheet: 6 9/16 x 4 1/16 in. (16.6 x 10.3 cm) Harris Brisbane Dick Fund, 1933                       Prints 13   Metropolitan Museum of Art, New York, NY 1
399547 47.30.5 0 0 653996 Drawings and Prints 11 Print 731 Alpine Mastiff           Etcher|Artist 1330 After Thomas Landseer|Sir Edwin Henry Landseer British, London 1795–1880 London|British, London 1802–1873 London   Landseer, Thomas|Landseer, Edwin Henry, Sir 50787 British|British 9 1795 |1802 1880 |1873 1818 1818 1818 Etching; early state 40997 Sheet: 16 3/4 × 15 15/16 in. (42.5 × 40.5 cm) Harris Brisbane Dick Fund, 1947                       Prints 13   Metropolitan Museum of Art, New York, NY 1
464144 59.533.1872 0 0 786161 Drawings and Prints 11 Print 731 On Coast of Sussex           Artist 2   Thomas Rowlandson British, London 1757–1827 London   Rowlandson, Thomas 23260   1757 1827 1784–85 1784 1785 Etching; early state 40997 Sheet (trimmed within platemark): 8 7/8 × 12 13/16 in. (22.5 × 32.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       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 126.647ms · Data license: CC0 · Data source: metmuseum/openaccess