MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Medium = 30603

View and edit SQL

Suggested facets: Is Public Domain, 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

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
209238 31.77.26 0 1 336619 Drawings and Prints 11 Print 731 Studies of Six Greek Coins           Artist 2   Eugène Delacroix French, Charenton-Saint-Maurice 1798–1863 Paris   Delacroix, Eugène 17498 French 2 1798 1863 1825 1825 1825 Lithograph; third state of four 30603 Image: 10 3/8 x 7 7/8 in. (26.4 x 20 cm) Sheet: 13 1/8 x 10 1/4 in. (33.3 x 26 cm) Harris Brisbane Dick Fund, 1931                       Prints 13   Metropolitan Museum of Art, New York, NY 1
209727 22.56.13 0 1 337108 Drawings and Prints 11 Print 731 Hamlet and the Queen         Hamlet, Treize Sujets Dessinés par Eug. Delacroix [Hamlet, Thirteen Subjects Drawn by Eug. Delacroix], Gihaut Frères, Paris, 1843 154 Artist|Lithographer|Subject 1224   Eugène Delacroix|Villain|William Shakespeare French, Charenton-Saint-Maurice 1798–1863 Paris|French, active 1822–53|British, Stratford-upon-Avon 1564–1616 Stratford-upon-Avon   Delacroix, Eugène|Villain|Shakespeare, William 18636 French 2 1798 |1822 |1564 1863 |1853 |1616 1834 1834 1834 Lithograph; third state of four 30603 Image: 10 1/8 x 7 in. (25.7 x 17.8 cm) Sheet: 11 7/8 x 7 15/16 in. (30.1 x 20.2 cm) Rogers Fund, 1922                       Prints 13   Metropolitan Museum of Art, New York, NY 1
209976 29.107.129 0 1 337358 Drawings and Prints 11 Print 731 Lion of the Atlas Mountains           Artist 2   Eugène Delacroix French, Charenton-Saint-Maurice 1798–1863 Paris   Delacroix, Eugène 17498 French 2 1798 1863 1829–30 1829 1830 Lithograph; third state of four 30603 Image: 18 1/8 x 12 15/16 in. (46 x 32.8 cm) Sheet: 25 1/8 x 19 in. (63.8 x 48.2 cm) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Prints 13   Metropolitan Museum of Art, New York, NY 1
265296 26.87.7 0 0 394263 Drawings and Prints 11 Print 731 Reading           Artist|Artist 13 After Pierre Paul Prud'hon|Charles Motte French, Cluny 1758–1823 Paris|French, 1785–1836   Prud'hon, Pierre Paul|Motte, Charles 38830 French|French 21 1758 |1785 1823 |1836 n.d. 1795 1836 Lithograph; third state of four 30603 image: 7 5/16 x 5 13/16 in. (18.5 x 14.8 cm) sheet: 10 3/16 x 8 1/16 in. (25.9 x 20.5 cm) Harris Brisbane Dick Fund, 1926                       Prints 13   Metropolitan Museum of Art, New York, NY 1
268892 29.107.68 0 0 397964 Drawings and Prints 11 Print 731 Alfred (Portrait of Alfred Feydeau), plate II from the series Études d'Enfants           Artist|Printer 715   Paul Gavarni [Chevalier]|Coulon French, Paris 1804–1866 Paris   Gavarni, Paul|Coulon 39783 French 2 1804 1866 19th century 1815 1866 Lithograph; third state of four 30603 sheet: 12 1/4 x 8 7/8 in. (31.1 x 22.5 cm) The H.O. Havemeyer Collection, Bequest of Mrs. H.O. Havemeyer, 1929                       Prints 13   Metropolitan Museum of Art, New York, NY 1
270162 2012.136.617 0 1 399288 Drawings and Prints 11 Print 731 Vallée de Glenfinlas (Glenfinlas Valley)         Vues Pittoresques de l'Écosse 1717 Artist|Artist|Printer 958 After Richard Parkes Bonington|François-Alexandre Pernot|Villain British, Arnold, Nottinghamshire 1802–1828 London|French, Wassy 1793–1865|French, active 1822–53   Bonington, Richard Parkes|Pernot, François-Alexandre|Villain 40125 British|French|French 206 1802 |1793 |1822 1828 |1793 |1853 1826 1826 1826 Lithograph; third state of four 30603 Image: 8 in. × 13 9/16 in. (20.3 × 34.4 cm) Sheet: 10 3/16 × 13 9/16 in. (25.8 × 34.4 cm) Bequest of Phyllis Massar, 2011                       Prints 13   Metropolitan Museum of Art, New York, NY 1
271662 49.74.134 0 0 400823 Drawings and Prints 11 Print 731 Mosieu le Maire..., plate VIII from the series Histoire de Politiquer, published in Paris (Journal), November 3, 1852         Masques et Visages 1640 Artist 2   Paul Gavarni [Chevalier] French, Paris 1804–1866 Paris   Gavarni, Paul 17681 French 2 1804 1866 November 3, 1852 1852 1852 Lithograph; third state of four 30603 sheet: 10 1/16 x 7 15/16 in. (25.5 x 20.1 cm) image: 7 1/2 x 6 5/16 in. (19 x 16.1 cm) Bequest of Howard Carter, 1949                       Prints 13   Metropolitan Museum of Art, New York, NY 1
393832 23.21.6 0 0 646481 Drawings and Prints 11 Print 731 Edimbourg vu de Calton-Hill (Edinburgh, from Carlton Hill)         Vues Pittoresques de l'Écosse 1717 Artist|Artist|Printer 958 After Richard Parkes Bonington|François-Alexandre Pernot|Villain British, Arnold, Nottinghamshire 1802–1828 London|French, Wassy 1793–1865|French, active 1822–53   Bonington, Richard Parkes|Pernot, François-Alexandre|Villain 40125 British|French|French 206 1802 |1793 |1822 1828 |1793 |1853 1826 1826 1826 Lithograph; third state of four 30603 Image: 6 13/16 × 8 15/16 in. (17.3 × 22.7 cm) Sheet: 9 9/16 in. × 12 in. (24.3 × 30.5 cm) Harris Brisbane Dick Fund, 1923                       Prints 13   Metropolitan Museum of Art, New York, NY 1
399781 58.549.135 0 0 654287 Drawings and Prints 11 Print 731 Mary, Queen of Scots           Sitter|Artist|Publisher 3695   Mary, Queen of Scots|Charles Achile d'Hardivillier|Imprimerie Lesauvage Linlithgow 1542–1587 Fotheringhay, England|French, Beauvais 1795–after 1850|French, active Paris, second half 19th century   Mary Queen of Scots|d'Hardiviller, Charles Achille|Imprimerie Lesauvage 50843 Scottish|French|French 3558 1542 |1795 |1800 1587 |1899 |1899 after 1833 1833 1899 Lithograph; third state of four 30603 Sheet: 9 1/2 × 5 15/16 in. (24.1 × 15.1 cm) Gift of Susan Dwight Bliss, 1958   Paris 27                   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 91.966ms · Data license: CC0 · Data source: metmuseum/openaccess