MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

42 rows where Artist Nationality = 7 and Medium = 148

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Object Name, Title, Artist Prefix, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Credit Line, Classification

Artist Nationality ✖

  • British · 42 ✖
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
305722 305722 30.111.1 0 1 435609 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   John Barry British, active ca. 1784–1827   Barry, John 43391 British 7 1784 1827 ca. 1790 1785 1795 Ivory 148 Oval, 2 1/2 x 2 1/8 in. (64 x 54 mm) Gift of Mrs. Sherwood Eddy, 1930                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435609 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305723 305723 30.111.2 0 1 435610 European Paintings 15 Painting, miniature 73 Portrait of a Woman           Artist 2   John Barry British, active ca. 1784–1827   Barry, John 43391 British 7 1784 1827 ca. 1790 1785 1795 Ivory 148 Oval, 2 1/2 x 2 1/8 in. (64 x 54 mm) Gift of Mrs. Sherwood Eddy, 1930                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435610 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305724 305724 62.122.40 0 1 435611 European Paintings 15 Painting, miniature 73 Portrait of a Man, Said to Be John Durham           Artist 2   John Barry British, active ca. 1784–1827   Barry, John 43391 British 7 1784 1827 ca. 1790 1785 1795 Ivory 148 Oval, 2 5/8 x 2 1/4 in. (67 x 56 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435611 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305744 305744 50.187.44 0 1 435634 European Paintings 15 Painting, miniature 73 Miss Chambers           Artist 2   Isabella Beetham British, 1750–after 1809   Beetham, Isabella 43401 British 7 1750 1809 after 1782 1782 1809 Ivory 148 Oval, 2 1/4 x 1 7/8 in. (59 x 48 mm) The Glenn Tilley Morse Collection, Bequest of Glenn Tilley Morse, 1950                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435634 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305883 305883 32.75.28 0 1 435787 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   British Painter ca. 1770   British Painter 3094 British 7       1765 1775 Ivory 148 Oval, 1 3/8 x 1 1/4 in. (36 x 30 mm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435787 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305885 305885 62.122.34 0 1 435791 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   British Painter ca. 1800   British Painter 3094 British 7       1795 1805 Ivory 148 Oval, 3 x 2 3/8 in. (77 x 60 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435791 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305886 305886 62.122.46 0 1 435792 European Paintings 15 Painting, miniature 73 Portrait of an Officer           Artist 2   British Painter ca. 1820   British Painter 3094 British 7       1815 1825 Ivory 148 Oval, 3 1/4 x 2 1/2 in. (78 x 62 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435792 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305887 305887 54.128.1 0 1 435797 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Irregular, 1/2 x 7/8 in. (13 x 22 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435797 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305888 305888 54.128.2 0 1 435798 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Oval, 1/4 x 1/2 in. (6 x 14 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435798 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305889 305889 54.128.3 0 1 435799 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Oval, 1/2 x 1 in. (14 x 27 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435799 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305890 305890 54.128.5 0 1 435800 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Diameter 1/4 in. (6 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435800 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305891 305891 54.128.7 0 1 435801 European Paintings 15 Painting, miniature 73 Eye Miniature           Artist 2   British Painter early 19th century   British Painter 3094 British 7       1800 1829 Ivory 148 Oval, 3/4 x 1/2 in. (19 x 13 mm) Gift of Mr. and Mrs. John W. Starr, 1954                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435801 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305997 305997 62.122.36 0 1 435919 European Paintings 15 Painting, miniature 73 George Howard (1773–1848), Lord Morpeth           Artist 2   Richard Collins British, 1755–1831   Collins, Richard 43481 British 7 1755 1831   1775 1831 Ivory 148 Oval, 2 x 1 5/8 in. (52 x 41 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435919 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
305998 305998 95.14.69 0 1 435920 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   Samuel Collins British, 1735?–1768   Collins, Samuel 23153 British 7 1735 1768   1755 1768 Ivory 148 Oval, 1 5/8 x 1 1/4 in. (40 x 32 mm) The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435920 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306067 306067 62.49 0 1 435994 European Paintings 15 Painting, miniature 73 Self-Portrait           Artist 2   Richard Cosway British, Oakford, Devon 1742–1821 London   Cosway, Richard 19855 British 7 1742 1821 ca. 1770–75 1770 1775 Ivory 148 Oval, 2 x 1 5/8 in. (50 x 42 mm) Gift of Charlotte Guilford Muhlhofer, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435994 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306068 306068 24.80.499 0 1 435996 European Paintings 15 Painting, miniature 73 Ensign Lionel Robert Tollemache (1774–1793)           Artist 2   Richard Cosway British, Oakford, Devon 1742–1821 London   Cosway, Richard 19855 British 7 1742 1821   1762 1821 Ivory 148 Oval, 3 1/8 x 2 1/2 in. (81 x 65 mm) Bequest of Mary Clark Thompson, 1923                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435996 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306071 306071 62.122.33 0 1 435999 European Paintings 15 Painting, miniature 73 Portrait of a Woman           Artist 2   Samuel Cotes British, 1734–1818   Cotes, Samuel 43488 British 7 1734 1818 1767 1767 1767 Ivory 148 Oval, 1 1/2 x 1 1/8 in. (38 x 30 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/435999 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306128 306128 33.136.14 0 1 436058 European Paintings 15 Painting, miniature 73 Portrait of a Woman           Artist 2   Richard Crosse British, 1742–1810   Crosse, Richard 43496 British 7 1742 1810 possibly ca. 1780 1775 1785 Ivory 148 Oval, 2 1/4 x 1 7/8 in. (58 x 48 mm) Bequest of Margaret Crane Hurlbut, 1933                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436058 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306315 306315 95.14.55 0 1 436273 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   George Engleheart British, Kew 1750–1829 Blackheath   Engleheart, George 43529 British 7 1750 1829 ca. 1780 1775 1785 Ivory 148 Oval, 1 1/4 x 1 1/8 in. (32 x 29 mm) The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436273 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306316 306316 38.146.16 0 1 436274 European Paintings 15 Painting, miniature 73 Mrs. Peter De Lancey (Elizabeth Colden, 1720–1784)           Artist 2   George Engleheart British, Kew 1750–1829 Blackheath   Engleheart, George 43529 British 7 1750 1829 1783 1778 1788 Ivory 148 Oval, 1 3/8 x 1 1/8 in. (34 x 28 mm) Fletcher Fund, 1938                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436274 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306317 306317 26.168.14 0 1 436275 European Paintings 15 Painting, miniature 73 Colonel Woodford           Artist 2   George Engleheart British, Kew 1750–1829 Blackheath   Engleheart, George 43529 British 7 1750 1829 probably 1788 1788 1788 Ivory 148 Oval, 2 1/8 x 1 3/4 in. (55 x 44 mm) Bequest of Collis P. Huntington, 1900                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436275 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306318 306318 11.218 0 1 436277 European Paintings 15 Painting, miniature 73 Portrait of a Man, Said to Be Mr. De Wolf           Artist 2   George Engleheart British, Kew 1750–1829 Blackheath   Engleheart, George 43529 British 7 1750 1829 ca. 1805 1800 1810 Ivory 148 Oval, 3 1/4 x 2 1/2 in. (81 x 62 mm) Gift of Alfred Ram, 1911                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436277 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306338 306338 33.136.15 0 1 436298 European Paintings 15 Painting, miniature 73 Portrait of a Woman           Artist 2   Joshua Wilson Faulkner British, active ca. 1809–20   Faulkner, Joshua Wilson 43538 British 7 1809 1820   1809 1820 Ivory 148 4 x 3 1/8 in. (100 x 80 mm) Bequest of Margaret Crane Hurlbut, 1933                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436298 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306573 306573 62.122.60 0 1 436589 European Paintings 15 Painting, miniature 73 Sir Joshua Reynolds (1723–1792)           Artist 2 Style of William Grimaldi 1773 or later   Grimaldi, William 43592 British 7 1751 1830   1773 1773 Ivory 148 Oval, 1 7/8 x 1 1/2 in. (47 x 37 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436589 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306616 306616 45.95 0 1 436635 European Paintings 15 Painting, miniature 73 Agnes Sewell           Artist 2   Thomas Hazlehurst British, ca. 1740–ca. 1821   Hazlehurst, Thomas 43604 British 7 1740 1821 possibly ca. 1800 1795 1805 Ivory 148 Oval, 3 x 2 3/8 in. (75 x 60 mm) Gift of Elise Shackelford Black, 1945                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436635 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306652 306652 62.122.28 0 1 436673 European Paintings 15 Painting, miniature 73 Portrait of a Woman, Said to Be Lady Agnes Anne Wrothesley           Artist 2   Horace Hone British, London ca. 1754/56–1825 London   Hone, Horace 2306 British 7 1749 1825 1791 1791 1791 Ivory 148 Oval, 2 x 1 5/8 in. (52 x 41 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436673 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306728 306728 24.80.524 0 1 436777 European Paintings 15 Painting, miniature 73 Admiral Adam Duncan (1731–1804)           Artist 2 Attributed to Philip Jean British, 1755–1802   Jean, Philip 43644 British 7 1755 1802   1775 1802 Ivory 148 Oval, 2 x 1 1/2 in. (50 x 40 mm) Bequest of Mary Clark Thompson, 1923                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436777 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306729 306729 25.106.29 0 1 436778 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2 Attributed to Philip Jean British, 1755–1802   Jean, Philip 43644 British 7 1755 1802   1775 1802 Ivory 148 Oval, 1 3/4 x 1 1/2 in. (46 x 37 mm) Gift of Mrs. Louis V. Bell, in memory of her husband, 1925                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436778 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306730 306730 62.122.35 0 1 436779 European Paintings 15 Painting, miniature 73 Portrait of a Woman           Artist 2   James Jennings British, active ca. 1763–93   Jennings, James 43645 British 7 1763 1793 probably early 1770s 1770 1773 Ivory 148 Oval, 1 5/8 x 1 1/4 in. (40 x 34 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/436779 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306966 306966 17.190.1150 0 1 437047 European Paintings 15 Painting, miniature, snuffbox 14112 Portrait of a Woman, Possibly Barbara (1768–1829), Marchioness of Donegall           Artist 2   Anne Foldsone Mee British, ca. 1770–1851   Mee, Anne Foldsone 43740 British 7 1765 1851 ca. 1790 1785 1795 Ivory 148 Oval, 2 7/8 x 2 1/8 in. (73 x 53 mm) Gift of J. Pierpont Morgan, 1917                       Miniatures|Metalwork-Gold and Platinum 775   http://www.metmuseum.org/art/collection/search/437047 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
306967 306967 95.14.60 0 1 437048 European Paintings 15 Painting, miniature 73 Portrait of a Woman, Said to Be Lady Sophia Boyle           Artist 2   Anne Foldsone Mee British, ca. 1770–1851   Mee, Anne Foldsone 43740 British 7 1765 1851 ca. 1790 1785 1795 Ivory 148 Oval, 2 5/8 x 2 1/8 in. (67 x 53 mm) The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437048 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307128 307128 39.122 0 1 437225 European Paintings 15 Painting, miniature 73 Portrait of a Young Woman           Artist 2   James Nixon British, ca. 1741–1812   Nixon, James 43794 British 7 1736 1812 ca. 1780–85 1780 1785 Ivory 148 Oval, 3 3/4 x 3 in. (97 x 75 mm) Fletcher Fund, 1939                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437225 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307129 307129 62.122.42 0 1 437226 European Paintings 15 Painting, miniature 73 Portrait of a Woman           Artist 2   James Nixon British, ca. 1741–1812   Nixon, James 43794 British 7 1736 1812 ca. 1790 1785 1795 Ivory 148 Oval, 2 1/4 x 1 7/8 in. (56 x 47 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437226 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307176 307176 68.213 0 1 437277 European Paintings 15 Painting, miniature 73 A Man with the Initials FM           Artist 2 Attributed to William Pether British, Carlisle ca. 1738–1821 Bristol   Pether, William 43816 British 7 1733 1821   1751 1821 Ivory 148 Oval, 3 x 2 1/4 in. (75 x 56 mm) Gift of Lilliana Teruzzi, 1968                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437277 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307213 307213 26.168.59 0 1 437320 European Paintings 15 Painting, miniature 73 Elizabeth Bushby           Artist 2   Andrew Plimer British, 1763–1837   Plimer, Andrew 43826 British 7 1763 1837 1804 1804 1804 Ivory 148 Oval, 3 x 2 1/4 in. (75 x 57 mm) Bequest of Collis P. Huntington, 1900                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437320 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307512 307512 26.168.71 0 1 437663 European Paintings 15 Painting, miniature 73 The Hours           Artist 2   Samuel Shelley British, London 1756–1808 London   Shelley, Samuel 30813 British 7 1756 1808 1801 1801 1801 Ivory 148 5 1/2 x 4 1/4 in. (140 x 109 mm) Bequest of Collis P. Huntington, 1900                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437663 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307513 307513 62.122.39 0 1 437664 European Paintings 15 Painting, miniature 73 Portrait of a Man           Artist 2   Samuel Shelley British, London 1756–1808 London   Shelley, Samuel 30813 British 7 1756 1808 probably ca. 1800 1795 1805 Ivory 148 Oval, 3 x 2 3/8 in. (75 x 60 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437664 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307514 307514 62.122.32 0 1 437665 European Paintings 15 Painting, miniature 73 Portrait of a Boy           Artist 2 Style of Samuel Shelley late 18th century   Shelley, Samuel 30813 British 7 1756 1808   1770 1799 Ivory 148 Oval, 1 1/4 x 1 in. (33 x 27 mm) Bequest of Millie Bruhl Fredrick, 1962                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437665 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307535 307535 24.80.493 0 1 437689 European Paintings 15 Painting, miniature 73 Sir William Hood           Artist 2   John Smart British, Norfolk 1741–1811 London   Smart, John 30850 British 7 1741 1811 ca. 1766 1761 1771 Ivory 148 Oval, 1 1/2 x 1 1/4 in. (37 x 32 mm) Bequest of Mary Clark Thompson, 1923                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437689 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307542 307542 41.191.2 0 1 437696 European Paintings 15 Painting, miniature 73 Portrait of an Officer           Artist 2 Imitator of John Smart 1784 or later?   Smart, John 30850 British 7 1741 1811   1784 1789 Ivory 148 Oval, 1 3/4 x 1 1/4 in. (45 x 32 mm) Gift of Mrs. Thomas Hunt, 1941                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437696 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307752 307752 95.14.95 0 1 437950 European Paintings 15 Painting, miniature 73 An Interesting Story (Miss Ray)           Artist 2   William Wood British, 1769–1810   Wood, William 43947 British 7 1769 1810 1806 1806 1806 Ivory 148 4 3/4 x 3 7/8 in. (119 x 97 mm) The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437950 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
307753 307753 95.14.97 0 1 437951 European Paintings 15 Painting, miniature 73 Portrait of a Man, Said to Be Mr. Fitzgerald           Artist 2   William Wood British, 1769–1810   Wood, William 43947 British 7 1769 1810   1789 1810 Ivory 148 Oval, 3 1/4 x 2 5/8 in. (81 x 66 mm) The Moses Lazarus Collection, Gift of Josephine and Sarah Lazarus, in memory of their father, 1888–95                       Miniatures 771   http://www.metmuseum.org/art/collection/search/437951 4/23/2018 8:00:01 AM 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 1272.393ms · Data license: CC0 · Data source: metmuseum/openaccess