MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Nationality = 1544

View and edit SQL

Suggested facets: Object Name, 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
221549 66.540.29 0 0 349101 Drawings and Prints 11 Book 97 Ecclesiasticus or the Wisdom of Jesus the Son of Sirach           Author|Illustrator|Publisher|Printer|Publisher 2300 Introduction by|Printed by John Johnson at the Charles Lewis Hind|Violet E. Brunton|Dodd, Mead & Co.|Oxford University Press|John Lane, The Bodley Head British, 1862–1927|British, Brighouse 1878–1951 , Limited, London Hind, Charles Lewis|Brunton, Violet E.|Dodd, Mead & Co.|Oxford University Press|Lane, John, The Bodley Head 24007 British|British|American|British|British 1544 1862 |1878 |1850 |1800 |1854 1927 |1951 |1950 |2050 |1925 1927 1927 1927 Illustrations: wood engraving and photomechanical reproduction 34548 10 3/16 x 6 11/16 x 1 1/8 in. (25.9 x 17 x 2.9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
226137 1973.513.17 0 0 353743 Drawings and Prints 11 Book 97 Old-World Love Stories: From the Lays of Marie de France & Other Mediæval Romances & Legends           Translator|Publisher|Publisher|Illustrator|Printer 3035 Illustrated and decorated by Eugene Mason|J. M. Dent & Co.|E. P. Dutton and Company|Reginald Lionel Knowles|Richard Clay & Sons, Limited British, active early 20th century|London|New York, NY|British, London 1879–1950 Croydon|London and Bungay Mason, Eugene|Dent, J. M. & Co.|Dutton, E. P. and Company|Knowles, Reginald Lionel|Clay, Richard & Sons, Limited 27457 British|British|American|British|British 1544 1900 |1850 |1850 |1879 |1850 1925 |1950 |1999 |1950 |1980 1913 1913 1913 Illustrations: lithography, photomechanical reproduction 34244 8 7/8 x 6 9/16 x 1 1/2 in. (22.5 x 16.7 x 3.8 cm) The Elisha Whittelsey Collection, The Elisha Whittesley Fund, 1973                       Books 442   Metropolitan Museum of Art, New York, NY 1
230166 1984.1211 0 0 357842 Drawings and Prints 11 Book 97 Vanity Fair: A Novel Without a Hero           Author|Publisher|Publisher|Printer|Dedicatee 3551 Written and illustrated by William Makepeace Thackeray|Smith, Elder, & Co.|J. B. Lippincott Company|Spottiswoode & Co.|Bryan Waller Procter British, Calcutta 1811–1863 London|London|Philadelphia|London|British, 1787–1874   Thackeray, William Makepeace|Smith, Elder, & Co.|Lippincott, J. B., Company|Spottiswoode & Co.|Procter, Bryan Waller 30243 British|British|American|British|British 1544 1811 |1800 |1800 |1800 |1787 1863 |1900 |1950 |1899 |1874 1879 1879 1879 Illustrations: etching 28943 7 7/8 x 5 1/2 in. (20 x 14 cm) Gift of Colta Ives, 1984                       Books 442   Metropolitan Museum of Art, New York, NY 1
409954 17.3.756-2307 0 0 675870 Drawings and Prints 11 Print 731 Charles Holland – Of Manly Plainness and of Honest Heart           Artist|Engraver|Artist|Publisher|Sitter 5140 After|Possibly after Hugh Baron|John Raphael Smith|Henry Benbridge|William Briand|Charles Holland British, 18th century|British, baptized Derby 1751–1812 Doncaster|American, Philadelphia 1743–1812 Philadelphia|British, active 1771|British, 1733–1769   Baron, Hugh|Smith, John Raphael|Benbridge, Henry|Briand, William|Holland, Charles 51795 British|British|American|British|British 1544 1700 |1751 |1743 |1771 |1733 1800 |1812 |1812 |1771 |1769 June 1, 1771 1771 1771 Mezzotint; first state of two with watercolor or gouache 59524 Sheet (trimmed to plate): 15 1/8 × 10 15/16 in. (38.4 × 27.8 cm) Harris Brisbane Dick Fund, 1917                       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 134.876ms · Data license: CC0 · Data source: metmuseum/openaccess