MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Artist Nationality = 1458

View and edit SQL

Suggested facets: Object Name, Title, Artist Prefix, Object Date, Object Begin Date, Object End 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
220573 21.36.158 0 0 348108 Drawings and Prints 11 Book 97 A Floral Fantasy in an Old English Garden           Publisher|Author|Printer|Binder 2177 Written and illustrated by Harper & Brothers|Walter Crane|Edmund Evans|Leighton Son and Hodge American, New York|British, Liverpool 1845–1915 Horsham|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|British, 19th century and London Harper & Brothers|Crane, Walter|Evans, Edmund|Leighton Son and Hodge 23355 American|British|British|British 1458 1833 |1845 |1826 |1850 1962 |1915 |1905 |1899 1899 1899 1899 Illustrations: half-tone process, printed in colors 33892 10 13/16 x 7 9/16 x 13/16 in. (27.5 x 19.2 x 2 cm) Rogers Fund, transferred from the Library, 1921   London 14                   Books 442   Metropolitan Museum of Art, New York, NY 1
222742 58.646.4 0 0 350305 Drawings and Prints 11 Book 97 Canadian Scenery, vol. I           Author|Publisher|Illustrator|Sitter 1862 Frontispiece of Nathaniel Parker Willis|George Virtue|William Henry Bartlett|William Henry Bartlett American, Portland, Maine 1806–1867 Cornwall, New York|London|British, London 1809–1854 at sea|British, London 1809–1854 at sea   Willis, Nathaniel Parker|Virtue, George|Bartlett, William Henry|Bartlett, William Henry 24904 American|British|British|British 1458 1806 |1800 |1809 |1809 1867 |1899 |1854 |1854 1840 1840 1840 Illustrations: engraving 28942 8 7/16 x 11 x 1 1/4 in. (21.5 x 28 x 3.2 cm) Gift of Mrs. Henry J. Bernheim, 1958                       Books 442   Metropolitan Museum of Art, New York, NY 1
223821 17.3.2641(44) 0 0 351408 Drawings and Prints 11 Book 97 The Queen of the Pirate Isle           Author|Publisher|Illustrator|Engraver 2334 Written by|Engraved and printed by Bret Harte|Chatto & Windus|Kate Greenaway|Edmund Evans American, Albany, New York 1836–1902 England|London|British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight   Harte, Bret|Chatto & Windus|Greenaway, Kate|Evans, Edmund 25763 American|British|British|British 1458 1836 |1850 |1846 |1826 1902 |2000 |1901 |1905 [1886] 1886 1886 Illustrations: color wood engraving 33868 8 3/4 x 6 1/2 in. (22.2 x 16.5 cm) Harris Brisbane Dick Fund, 1917                       Books 442   Metropolitan Museum of Art, New York, NY 1
228124 35.65.8 0 0 355752 Drawings and Prints 11 Book 97 Illustrations of the Rhine, Drawn from Nature and on Stone...           Engraver|Printer|Publisher|Artist 1396 Armorial bookplate by Peter Maverick|Charles Joseph Hullmandel|Rudolph Ackermann, London|Samuel Prout American, New York 1780–1831 New York|British, London 1789–1850 London|active 1794–1829|British, Plymouth 1783–1852 London   Maverick, Peter|Hullmandel, Charles Joseph|Ackermann, Rudolph|Prout, Samuel 28837 American|British|British|British 1458 1780 |1789 |1764 |1783 1831 |1850 |1834 |1852 1822–24 1822 1824 Illustrations: lithography 28996 16 5/16 x 12 11/16 x 3/4 in. (41.4 x 32.2 x 1.9 cm) Harris Brisbane Dick Fund, 1935                       Books 442   Metropolitan Museum of Art, New York, NY 1
229631 24.90.1812 0 0 357295 Drawings and Prints 11 Book 97 An Authentic Narrative of the Causes which led to the Death of Major André...           Author|Publisher|Sitter|Artist 2565 Frontispiece:|After Joshua Hett Smith Esq.|Mathews and Leigh|Major John André|James Hopwood American, active 19th century|London|British, London 1750–1780|British, Yorkshire 1795–after 1855   Smith, Joshua Hett|Mathews and Leigh|André, John Major|Hopwood, James 29880 American|British|British|British 1458 1800 |1800 |1680 |1795 1900 |1900 |1780 |1899 1808 1808 1808 Illustrations: engraving 28942 5 5/16 x 8 11/16 in. (13.5 x 22 cm) Bequest of Charles Allen Munn, 1924                       Books 442   Metropolitan Museum of Art, New York, NY 1
231640 1970.667.6 0 0 359379 Drawings and Prints 11 Book 97 Siralli and Other Tales           Author|Illustrator|Publisher|Printer 1121   Charles A. Stonehill|Harry George Theaker|Selwyn & Blount, Ltd.|M. F. Robinson and Co., Ltd. American, born 1900|British, 1873–1954|London|Lowestoft   Stonehill, Charles A.|Theaker, Harry George|Selwyn & Blount, Ltd.|Robinson, M. F. and Co. Ltd. 30958 American|British|British|British 1458 1900 |1873 |1900 |1900 2000 |1954 |1950 |2000 [1926] ? 1900 1950 Illustrations: commercial process 33874 7 1/2 x 5 1/16 x 5/8 in. (19 x 12.9 x 1.6 cm) Gift of A. Hyatt Mayor, 1970                       Books 442   Metropolitan Museum of Art, New York, NY 1
252639 54.90.1127 0 0 381143 Drawings and Prints 11 Print 731 Masonic Hall, Broadway, New York           Architect|Artist|Artist|Publisher|Publisher 4344 After|Engraved and printed by Hugh Reinagle|Alexander Jackson Davis|Fenner, Sears & Co.|Jennings & Chaplin, London|Isaac Taylor Hinton American, Philadelphia, Pennsylvania ca. 1788–1834 New Orleans, Louisiana|American, New York 1803–1892 West Orange, New Jersey|London|London   Reinagle, Hugh|Davis, Alexander Jackson|Fenner, Sears & Co.|Jennings & Chaplin|Hinton, Isaac Taylor 35958 American|British|British|British 1458 1788 |1803 |1800 |1820 |1800 1834 |1892 |1900 |1860 |1900 1830 1830 1830 Engraving 7208 image: 6 3/8 x 4 3/16 in. (16.2 x 10.6 cm) sheet: 10 5/8 x 8 1/4 in. (27 x 21 cm) The Edward W. C. Arnold Collection of New York Prints, Maps and Pictures, Bequest of Edward W. C. Arnold, 1954                       Prints 13   Metropolitan Museum of Art, New York, NY 1
259504 24.90.1240 0 0 388203 Drawings and Prints 11 Print 731 Masonic Hall, Broadway, New York           Artist|Engraver|Publisher|Publisher 1035 After Alexander Jackson Davis|Fenner, Sears & Co.|Jennings & Chaplin, London|Isaac Taylor Hinton American, New York 1803–1892 West Orange, New Jersey|London|London   Davis, Alexander Jackson|Fenner, Sears & Co.|Jennings & Chaplin|Hinton, Isaac Taylor 37505 American|British|British|British 1458 1803 |1800 |1820 |1800 1892 |1900 |1860 |1900 1830 1830 1830 Engraving 7208 sheet: 10 9/16 x 8 1/16 in. (26.8 x 20.4 cm) image: 6 5/16 x 4 3/16 in. (16 x 10.6 cm) Bequest of Charles Allen Munn, 1924                       Prints 13   Metropolitan Museum of Art, New York, NY 1
305644 49.40.260 0 0 435525 Drawings and Prints 11 Print 731 The Rocky Mountains, Lander's Peak           Artist|Publisher|Printer|Printer 1022 After Albert Bierstadt|Thomas McLean|Jacob Lutz|Kell Brothers American, Solingen 1830–1902 New York|British, active London 1788-1885|British, 19th century|Hoborn, London   Bierstadt, Albert|McLean, Thomas|Lutz, Jacob|Kell Brothers 43370 American|British|British|British 1458 1830 |1800 |1800 |1800 1902 |1899 |1900 |1920 ca. 1869 1864 1874 Color lithograph; proof with printer's color notes 44472 Sheet: 21 1/2 × 34 1/2 in. (54.6 × 87.6 cm) 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 141.397ms · Data license: CC0 · Data source: metmuseum/openaccess