Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: 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, Dimensions, 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 | Metadata Date | Repository |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 206446 | 206446 | 17.3.2983 | 0 | 0 | 333790 | Drawings and Prints 11 | Book 97 | Cecil Lawson: A Memoir | Subject of book|Designer|Illustrator|Author|Illustrator|Publisher|Printer 973 | About|After | Cecil Gordon Lawson|Cecil Gordon Lawson|James McNeill Whistler|Sir Edmund William Gosse|Sir Hubert von Herkomer|The Fine Art Society, London|J. S. Virtue | British, Wellington, Shropshire 1849–1882 London|British, Wellington, Shropshire 1849–1882 London|American, Lowell, Massachusetts 1834–1903 London|British, Hackney, Middlesex 1849–1928 London|British, Waal, Bavaria 1849–1914 Budleigh Salterton, Devon|London | Lawson, Cecil Gordon|Lawson, Cecil Gordon|Whistler, James McNeill|Gosse, Edmund William, Sir|Herkomer, Hubert von Sir|Fine Art Society, London|Virtue, J. S. 17303 | British|British|American|British|British, born Germany|British|British 740 | 1849 |1849 |1834 |1849 |1849 |1850 |1855 | 1882 |1882 |1903 |1928 |1914 |2099 |1892 | 1883 | 1883 | 1883 | Illustrations: etching, woodcut 28941 | 19 3/16 x 15 3/16 x 13/16 in. (48.7 x 38.5 x 2cm) | Harris Brisbane Dick Fund, 1917 | Books 442 | http://www.metmuseum.org/art/collection/search/333790 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 220634 | 220634 | 1973.598.3 | 0 | 0 | 348170 | Drawings and Prints 11 | Book 97 | Cinderella and the Glass Slipper | Illustrator|Publisher|Binder 2184 | George Cruikshank|David Bogue|Riviere & Son(s) | British, London 1792–1878 London|British, active London, 1807/8–1856|London | Cruikshank, George|Bogue, David|Riviere & Son(s) 23404 | British|British|British 178 | 1792 |1807 |1840 | 1878 |1856 |1939 | 1854 | 1854 | 1854 | Illustrations: etching, woodcut 28941 | 7 1/16 x 5 5/16 in. (18 x 13.5 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1973 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/348170 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 220635 | 220635 | 1973.598.2 | 0 | 0 | 348171 | Drawings and Prints 11 | Book 97 | The History of Jack & The Bean-Stalk | Illustrator|Publisher|Binder 2184 | George Cruikshank|David Bogue|Riviere & Son(s) | British, London 1792–1878 London|British, active London, 1807/8–1856|London | Cruikshank, George|Bogue, David|Riviere & Son(s) 23404 | British|British|British 178 | 1792 |1807 |1840 | 1878 |1856 |1939 | 1854 | 1854 | 1854 | Illustrations: etching, woodcut 28941 | 7 1/16 x 5 5/16 in. (18 x 13.5 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1973 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/348171 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 220636 | 220636 | 1973.598.1 | 0 | 0 | 348172 | Drawings and Prints 11 | Book 97 | Hop O'My Thumb and the Seven League Boots | Illustrator|Publisher|Binder 2184 | George Cruikshank|David Bogue|Riviere & Son(s) | British, London 1792–1878 London|British, active London, 1807/8–1856|London | Cruikshank, George|Bogue, David|Riviere & Son(s) 23404 | British|British|British 178 | 1792 |1807 |1840 | 1878 |1856 |1939 | 1853 | 1853 | 1853 | Illustrations: etching, woodcut 28941 | 7 1/16 x 5 1/2 in. (18 x 14 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1973 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/348172 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 220638 | 220638 | 1973.598.4 | 0 | 0 | 348174 | Drawings and Prints 11 | Book 97 | Puss in Boots | Illustrator|Publisher|Publisher|Binder 2185 | George Cruikshank|Routledge, Warne & Routledge|Frederick Arnold|Riviere & Son(s) | British, London 1792–1878 London|London|London|London | Cruikshank, George|Routledge, Warne & Routledge|Arnold, Frederick|Riviere & Son(s) 23405 | British|British|British|British 177 | 1792 |1800 |1850 |1840 | 1878 |1899 |1899 |1939 | 1864 | 1864 | 1864 | Illustrations: etching, woodcut 28941 | 7 1/2 x 5 1/2 in. (19 x 14 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1973 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/348174 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 224552 | 224552 | 41.100.97 | 0 | 0 | 352145 | Drawings and Prints 11 | Book 97 | The Theory and Practise of Gardening...Done from the French Original Printed at Paris anno 1709.. | Translator|Printer|Etcher 2805 | John James|George James|Vandergucht | British, active early 18th century|London|British, active 17th–18th century | James, John|James, George|Vandergucht 26338 | British|British|British 178 | 1700 |1700 |1650 | 1750 |1800 |1750 | 1712 | 1712 | 1712 | Illustrations: etching, woodcut 28941 | 10 7/16 x 8 1/16 x 1 9/16 in. (26.5 x 20.5 x 4 cm) | Bequest of W. Gedney Beatty, 1941 | Books 442 | http://www.metmuseum.org/art/collection/search/352145 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
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");