Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Begin Date, Object End Date, Medium, Credit Line, Rights and Reproduction
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 401534 | 401534 | SL.6.2016.37.1 | 0 | 0 | 656471 | Modern and Contemporary Art 4 | Emilia, Lady Cahir, Later Countess of Glengall | Artist 2 | Sir Thomas Lawrence | British, Bristol 1769–1830 London | Lawrence, Thomas, Sir 19795 | 1769 | 1830 | ca. 1803–1805 | 1798 | 1808 | Oil and graphite on canvas 50986 | 29 1/8 × 24 7/16 in. (74 × 62 cm) Framed: 38 3/16 × 33 7/16 in. (97 × 85 cm) | From a Private Collection | Country of Origin 23 | Great Britain 1036 | Paintings 11 | http://www.metmuseum.org/art/collection/search/656471 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 401536 | 401536 | SL.6.2016.48.1 | 0 | 0 | 656474 | Modern and Contemporary Art 4 | George Romney | Artist 2 | George Romney | British, Beckside, Lancashire 1734–1802 Kendal, Cumbria | Romney, George 20413 | 1734 | 1802 | 1784 | 1784 | 1784 | Oil on canvas 953 | 51 3/8 × 40 15/16 in. (130.5 × 104 cm) Framed: 59 5/8 × 49 1/2 in. (151.5 × 125.7 cm) | National Portrait Gallery, London. Purchased, 1894 (NPG 959) | Country of Origin 23 | Great Britain 1036 | Paintings 11 | © National Portrait Gallery, London / Art Resource, NY: | http://www.metmuseum.org/art/collection/search/656474 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 401850 | 401850 | SL.6.2016.99.1 | 0 | 0 | 656864 | Modern and Contemporary Art 4 | American Commissioners of the Preliminary Peace Negotiations with Great Britain | Artist 2 | Benjamin West | American, Swarthmore, Pennsylvania 1738–1820 London | West, Benjamin 1864 | 1738 | 1820 | 1783 (begun) | 1783 | 1783 | Oil on canvas 953 | 28 1/2 × 36 1/4 in. (72.4 × 92.1 cm) Frame: 35 × 43 in. (88.9 × 109.2 cm) | Winterthur Museum, Gift of Henry Francis du Pont | Country of Origin 23 | Great Britain 1036 | Paintings 11 | © Winterthur Museum, photograph, Herb Crossan | http://www.metmuseum.org/art/collection/search/656864 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 407508 | 407508 | SL.6.2016.60.2 | 0 | 0 | 665839 | Modern and Contemporary Art 4 | The Return of Mary Queen of Scots to Edinburgh | Artist 2 | James Drummond | British, Edinburgh, Scotland 1816–1877 Edinburgh | Drummond, James 51363 | 1816 | 1877 | ca. 1870 | 1865 | 1875 | Oil on panel 1499 | 32 1/16 × 47 1/2 in. (81.5 × 120.6 cm) | Mr. and Mrs. Otto Naumann, New York | Country of Origin 23 | Great Britain 1036 | Paintings 11 | http://www.metmuseum.org/art/collection/search/665839 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 408581 | 408581 | SL.6.2016.84.1 | 0 | 0 | 668785 | Modern and Contemporary Art 4 | Portrait of the Hound | Artist 2 | Lucian Freud | British (born Germany), Berlin 1922–2011 London | Freud, Lucian 34565 | 1922 | 2011 | 2011 | 2011 | 2011 | Oil on canvas 953 | 62 3/16 × 54 5/16 in. (158 × 138 cm) | Private Collection | Country of Origin 23 | Great Britain 1036 | Paintings 11 | © Lucian Freud Archive / Bridgeman Images / photograph courtesy Lenz & Staehelin, Zurich | http://www.metmuseum.org/art/collection/search/668785 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 408584 | 408584 | SL.6.2016.50.1 | 0 | 0 | 668865 | Modern and Contemporary Art 4 | The Thames above Waterloo Bridge | Artist 2 | Joseph Mallord William Turner | British, London 1775–1851 London | Turner, Joseph Mallord William 18746 | 1775 | 1851 | ca.1835–1840 | 1830 | 1840 | Oil on canvas 953 | 35 5/8 × 47 5/8 in. (90.5 × 121 cm) Framed: 44 13/16 in. × 57 3/8 in. × 3 1/4 in. (113.8 × 145.7 × 8.2 cm) | Tate: Accepted by the nation as part of the Turner Bequest 1856 | Country of Origin 23 | Great Britain 1036 | Paintings 11 | © 2016 Tate, London | http://www.metmuseum.org/art/collection/search/668865 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 408585 | 408585 | SL.6.2016.50.2 | 0 | 0 | 668867 | Modern and Contemporary Art 4 | Rough Sea | Artist 2 | Joseph Mallord William Turner | British, London 1775–1851 London | Turner, Joseph Mallord William 18746 | 1775 | 1851 | ca. 1840–1845 | 1840 | 1845 | Oil on canvas 953 | 36 × 48 in. (91.4 × 121.9 cm) Framed: 42 1/16 in. × 54 in. × 3 1/8 in. (106.8 × 137.2 × 8 cm) | Tate: Accepted by the nation as part of the Turner Bequest 1856 | Country of Origin 23 | Great Britain 1036 | Paintings 11 | © 2016 Tate, London | http://www.metmuseum.org/art/collection/search/668867 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 408586 | 408586 | SL.6.2016.50.3 | 0 | 0 | 668868 | Modern and Contemporary Art 4 | Sunset From the Top of the Rigi | Artist 2 | Joseph Mallord William Turner | British, London 1775–1851 London | Turner, Joseph Mallord William 18746 | 1775 | 1851 | ca. 1844 | 1844 | 1844 | Oil on canvas 953 | 28 × 38 in. (71.1 × 96.5 cm) Framed: 32 15/16 in. × 43 1/8 in. × 2 1/4 in. (83.6 × 109.6 × 5.7 cm) | Tate: Accepted by the nation as part of the Turner Bequest 1856 | Country of Origin 23 | Great Britain 1036 | Paintings 11 | © 2016 Tate, London | http://www.metmuseum.org/art/collection/search/668868 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 408587 | 408587 | SL.6.2016.50.4 | 0 | 0 | 668869 | Modern and Contemporary Art 4 | Sun Setting Over a Lake | Artist 2 | Joseph Mallord William Turner | British, London 1775–1851 London | Turner, Joseph Mallord William 18746 | 1775 | 1851 | ca. 1840 | 1835 | 1840 | Oil on canvas 953 | 35 7/8 × 48 1/4 in. (91.1 × 122.6 cm) Framed: 42 5/16 in. × 54 3/16 in. × 5 11/16 in. (107.4 × 137.7 × 14.5 cm) | Tate: Accepted by the nation as part of the Turner Bequest 1856 | Country of Origin 23 | Great Britain 1036 | Paintings 11 | © 2016 Tate, London | http://www.metmuseum.org/art/collection/search/668869 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 408634 | 408634 | SL.6.2016.47.1 | 0 | 0 | 668933 | Modern and Contemporary Art 4 | Margate (?), from the Sea | Artist 2 | Joseph Mallord William Turner | British, London 1775–1851 London | Turner, Joseph Mallord William 18746 | 1775 | 1851 | ca. 1835–1840 | 1835 | 1840 | Oil on canvas 953 | 35 7/8 × 48 1/8 in. (91.2 × 122.2 cm) Framed: 48 1/4 in. × 60 7/16 in. × 5 5/16 in. (122.5 × 153.5 × 13.5 cm) | The National Gallery, London. Turner Bequest, 1856 | Country of Origin 23 | Great Britain 1036 | Paintings 11 | © National Gallery, London / Art Resource, NY | http://www.metmuseum.org/art/collection/search/668933 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 413214 | 413214 | SL.6.2016.34.1 | 0 | 0 | 681466 | Modern and Contemporary Art 4 | Portrait of a Young Man | Artist 2 | Sir Joshua Reynolds | British, Plympton 1723–1792 London | Reynolds, Joshua, Sir 19829 | 1723 | 1792 | ca. 1770 | 1770 | 1770 | Oil on canvas 953 | 31 × 25 1/8 in. (78.7 × 63.8 cm) | The Menil Collection, Houston, 1983-103 DJ | Country of Origin 23 | Great Britain 1036 | Paintings 11 | photograph Hickey-Robertson, Houston | http://www.metmuseum.org/art/collection/search/681466 | 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");