Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, 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, Medium, Dimensions, 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 | Metadata Date | Repository |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9310 | 9310 | 66.73 | 0 | 1 | 10028 | American Paintings and Sculpture 2 | Painting 69 | Orange Branch | Former Attribution 27 | Formerly attributed to | John La Farge | American, New York 1835–1910 Providence, Rhode Island | La Farge, John 520 | American 1 | 1835 | 1910 | ca. 1883 | 1880 | 1883 | Oil on canvas 953 | 54 5/8 x 11 5/8 in. (138.4 x 29.5 cm) | Gift of J. William Middendorf II, 1966 | Paintings 11 | http://www.metmuseum.org/art/collection/search/10028 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
9317 | 9317 | 67.187.138 | 0 | 1 | 10035 | American Paintings and Sculpture 2 | Painting 69 | Pasture at Evening | Former Attribution 27 | Formerly attributed to | Albert Pinkham Ryder | American, New Bedford, Massachusetts 1847–1917 Elmhurst, New York | Ryder, Albert Pinkham 1231 | American 1 | 1847 | 1917 | 1912–32 | 1913 | 1931 | Oil on canvas 953 | 12 x 16 in. (30.5 x 40.6 cm) | Bequest of Miss Adelaide Milton de Groot (1876–1967), 1967 | Paintings 11 | http://www.metmuseum.org/art/collection/search/10035 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
9981 | 9981 | 1977.258.3 | 0 | 1 | 10799 | American Paintings and Sculpture 2 | Painting 69 | View of New York from New Jersey | Former Attribution 27 | Formerly attributed to | Asher Brown Durand | American, Jefferson, New Jersey 1796–1886 Maplewood, New Jersey | Durand, Asher Brown 1402 | American 1 | 1796 | 1886 | ca. 1850 | 1847 | 1850 | Oil on canvas 953 | 15 x 27 1/4 in. (38.1 x 68.8 cm) | Gift of Mary Knight Arnold, 1977 | Paintings 11 | http://www.metmuseum.org/art/collection/search/10799 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
10318 | 10318 | 64.95 | 0 | 1 | 11191 | American Paintings and Sculpture 2 | Painting 69 | Mary Inman | Artist|Former Attribution 54 | Formerly attributed to | Daniel Huntington|Henry Inman | American, New York 1816–1906 New York|American, Utica, New York 1801–1846 New York | Huntington, Daniel|Inman, Henry 1528 | American|American 5 | 1816 |1801 | 1906 |1846 | 1844 | 1844 | 1844 | Oil on canvas 953 | 30 x 25 in. (76.2 x 63.5 cm) | Gift of Mrs. Dave Hennen Coddington, in memory of her husband, 1964 | Paintings 11 | http://www.metmuseum.org/art/collection/search/11191 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
10336 | 10336 | 1977.342.2 | 0 | 1 | 11209 | American Paintings and Sculpture 2 | Painting 69 | Mrs. Luman Reed | Artist|Former Attribution 54 | Formerly attributed to | Charles Cromwell Ingham|Asher Brown Durand | American (born Ireland), Dublin 1786–1863 New York|American, Jefferson, New Jersey 1796–1886 Maplewood, New Jersey | Ingham, Charles Cromwell|Durand, Asher Brown 1532 | American, born Ireland|American 40 | 1786 |1796 | 1863 |1886 | ca. 1835 | 1832 | 1835 | Oil on canvas, laid down on composition board 1656 | 30 1/8 x 25 in. (76.5 x 63.5 cm) | Bequest of Frederick Sturges Jr., 1977 | Paintings 11 | http://www.metmuseum.org/art/collection/search/11209 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
10397 | 10397 | 64.114.1 | 0 | 1 | 11273 | American Paintings and Sculpture 2 | Painting 69 | Jacob Hurd | Artist|Former Attribution 54 | Formerly attributed to | William Johnston|John Singleton Copley | 1732–1772|American, Boston, Massachusetts 1738–1815 London | Johnston, William|Copley, John Singleton 1544 | American 1 | 1732 |1738 | 1772 |1815 | ca. 1762 | 1759 | 1762 | Oil on canvas 953 | 30 x 25 in. (76.2 x 63.5 cm) | Anonymous Gift, 1964 | Paintings 11 | http://www.metmuseum.org/art/collection/search/11273 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
10398 | 10398 | 64.114.2 | 0 | 1 | 11274 | American Paintings and Sculpture 2 | Painting 69 | Mrs. Jacob Hurd and Child | Artist|Former Attribution 54 | Formerly attributed to | William Johnston|John Singleton Copley | 1732–1772|American, Boston, Massachusetts 1738–1815 London | Johnston, William|Copley, John Singleton 1544 | American 1 | 1732 |1738 | 1772 |1815 | ca. 1762 | 1759 | 1762 | Oil on canvas 953 | 30 x 25 in. (76.2 x 63.5 cm) | Anonymous Gift, 1964 | Paintings 11 | http://www.metmuseum.org/art/collection/search/11274 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
10981 | 10981 | 40.167.2 | 0 | 1 | 11989 | American Paintings and Sculpture 2 | Drawing 23 | Mrs. George Clinton (Cornelia Tappen) | Artist|Former Attribution 54 | Formerly attributed to | Thomas Bluget De Valdenuit|Charles Balthazar Julien Févret de Saint-Mémin | 1763–1846|1770–1852 | Valdenuit, Thomas Bluget De|de Saint-Mémin, Charles Balthazar Julien Févret 1738 | French|French 21 | 1763 |1770 | 1846 |1852 | ca. 1797 | 1794 | 1797 | Conté crayone, charcoal (?), and white-chalk heightening on off-white laid paper coated with gouache 1792 | 21 3/8 x 13 3/4 in. (54.3 x 34.9 cm) | Purchase, Anonymous Gift, 1940 | Made in 1 | France 9 | Drawings 9 | http://www.metmuseum.org/art/collection/search/11989 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
11457 | 11457 | 50.130.83h | 0 | 1 | 12466 | American Paintings and Sculpture 2 | Watercolor 198 | Tomb of Francis Dineley and His Wife, St. Michael's Church, Cropthorne, England | Former Attribution 27 | Formerly attributed to | John Singer Sargent | American, Florence 1856–1925 London | Sargent, John Singer 23 | American 1 | 1856 | 1925 | 1865 (?) | 1865 | 1865 | Watercolor and graphite on white wove paper 1608 | 14 3/4 x 22 in. (37.5 x 55.9 cm) | Gift of Mrs. Francis Ormond, 1950 | Drawings 9 | http://www.metmuseum.org/art/collection/search/12466 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11605 | 11605 | 22.28.1 | 0 | 1 | 12617 | American Paintings and Sculpture 2 | Watercolor 198 | The Shop and Warehouse of Duncan Phyfe, 168–172 Fulton Street, New York City | Former Attribution 27 | Formerly attributed to | John Rubens Smith | American, London 1775–1849 New York | Smith, John Rubens 1795 | American 1 | 1775 | 1849 | ca. 1816 | 1813 | 1819 | Watercolor, black ink, and gouache on white laid paper 1900 | 15 7/8 x 19 5/8 in. (40.3 x 49.8 cm) | Rogers Fund, 1922 | Drawings 9 | http://www.metmuseum.org/art/collection/search/12617 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11647 | 11647 | 24.109.84 | 0 | 1 | 12661 | American Paintings and Sculpture 2 | Painting 69 | Commodore Isaac Hull | Former Attribution 27 | Formerly attributed to | Gilbert Stuart | American, North Kingston, Rhode Island 1755–1828 Boston, Massachusetts | Stuart, Gilbert 576 | American 1 | 1755 | 1828 | 1813–14 | 1813 | 1814 | Oil on canvas 953 | 30 x 25 in. (76.2 x 63.5 cm) | Bequest of Charles Allen Munn, 1924 | Paintings 11 | http://www.metmuseum.org/art/collection/search/12661 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11710 | 11710 | 42.95.21 | 0 | 1 | 12727 | American Paintings and Sculpture 2 | Watercolor 198 | Members of the City Troop and Other Philadelphia Soldiery | Artist|Former Attribution 54 | Formerly attributed to | John Lewis Krimmel|Pavel Petrovich Svinin | 1786–1821|1787/88–1839 | Krimmel, John Lewis|Svinin, Pavel Petrovtch 1823 | American|Russian 60 | 1786 |1787 | 1821 |1839 | 1811–ca. 1813 | 1811 | 1816 | Watercolor, gouache, and graphite on white laid paper 1916 | 9 x 7 1/4 in. (22.9 x 18.4 cm) | Rogers Fund, 1942 | Drawings 9 | http://www.metmuseum.org/art/collection/search/12727 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11827 | 11827 | 66.214 | 0 | 1 | 12849 | American Paintings and Sculpture 2 | Painting 69 | After the Storm | Former Attribution 27 | Formerly attributed to | Albert Bierstadt | American, Solingen 1830–1902 New York | Bierstadt, Albert 1269 | American 1 | 1830 | 1902 | ca. 1870–80 (?) | 1867 | 1880 | Oil on canvas 953 | 26 3/4 x 38 3/4 in. (67.9 x 98.4 cm) | Gift of Mr. and Mrs. Alfred Fischer, 1966 | Paintings 11 | http://www.metmuseum.org/art/collection/search/12849 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11833 | 11833 | 32.67.1 | 0 | 1 | 12856 | American Paintings and Sculpture 2 | Painting 69 | Autumn Meadows | Former Attribution 27 | Formerly attributed to | Albert Pinkham Ryder | American, New Bedford, Massachusetts 1847–1917 Elmhurst, New York | Ryder, Albert Pinkham 1231 | American 1 | 1847 | 1917 | 1912–17 | 1913 | 1916 | Oil on canvas mounted on wood 1627 | 21 x 17 1/4 in. (53.3 x 43.8 cm) | Morris K. Jesup Fund, 1932 | Paintings 11 | http://www.metmuseum.org/art/collection/search/12856 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11888 | 11888 | 53.45.6 | 0 | 1 | 12925 | American Paintings and Sculpture 2 | Painting 69 | Landscape and Figures | Former Attribution 27 | Formerly attributed to | Ralph Albert Blakelock | 1847–1919 | Blakelock, Ralph Albert 1276 | 1847 | 1919 | by 1913 | 1912 | 1913 | Oil on canvas 953 | 4 5/8 x 7 in. (11.8 x 17.8 cm) | Bequest of Katherine S. Dreier, 1952 | Paintings 11 | http://www.metmuseum.org/art/collection/search/12925 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
11916 | 11916 | 32.67.2 | 0 | 1 | 12956 | American Paintings and Sculpture 2 | Painting 69 | Nourmahal | Former Attribution 27 | Formerly attributed to | Albert Pinkham Ryder | American, New Bedford, Massachusetts 1847–1917 Elmhurst, New York | Ryder, Albert Pinkham 1231 | American 1 | 1847 | 1917 | by 1924 | 1923 | 1924 | Oil on wood 156 | 19 1/2 x 28 1/2 in. (49.5 x 72.3 cm) | Morris K. Jesup Fund, 1932 | Paintings 11 | http://www.metmuseum.org/art/collection/search/12956 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11931 | 11931 | 1972.263.4 | 0 | 1 | 12975 | American Paintings and Sculpture 2 | Painting 69 | Portrait of a Lady (Possibly Hannah Stillman) | Former Attribution 27 | Formerly attributed to | Pieter Vanderlyn | ca. 1687–1778 | Vanderlyn, Pieter 1869 | 1687 | 1778 | 1720–30 | 1720 | 1730 | Oil on canvas 953 | 29 1/2 x 24 1/2 in. (74.9 x 62.2 cm) | Gift of Edgar William and Bernice Chrysler Garbisch, 1972 | Paintings 11 | http://www.metmuseum.org/art/collection/search/12975 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
11934 | 11934 | 55.73.3 | 0 | 1 | 12978 | American Paintings and Sculpture 2 | Painting 69 | Portrait of a Man | Former Attribution 27 | Formerly attributed to | Thomas Hicks | American, Newton, Pennsylvania 1823–1890 Trenton Falls, New York | Hicks, Thomas 1501 | American 1 | 1823 | 1890 | ca. 1850 | 1847 | 1850 | Oil on canvas 953 | 26 1/2 x 19 3/4 in. (66.5 x 49 cm) | Gift of The Chester Dale Collection, 1955 | Paintings 11 | http://www.metmuseum.org/art/collection/search/12978 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11959 | 11959 | 55.49 | 0 | 1 | 13008 | American Paintings and Sculpture 2 | Painting 69 | Henry Irving as Philip II of Spain | Former Attribution 27 | Formerly attributed to | James McNeill Whistler | American, Lowell, Massachusetts 1834–1903 London | Whistler, James McNeill 1875 | American 1 | 1834 | 1903 | after 1872 | 1873 | 1882 | Oil on canvas 953 | 19 1/8 x 14 3/8 in. (48.6 x 36 cm) | Gift of George S. Hellman, 1955 | Paintings 11 | http://www.metmuseum.org/art/collection/search/13008 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
11980 | 11980 | 49.116 | 0 | 1 | 13033 | American Paintings and Sculpture 2 | Painting 69 | Woodland Vista | Former Attribution 27 | Formerly attributed to | Ralph Albert Blakelock | 1847–1919 | Blakelock, Ralph Albert 1276 | 1847 | 1919 | 1910–20 (?) | 1907 | 1920 | Oil on canvas 953 | 18 x 24 in. (45.7 x 61 cm) | Gift of Francis M. Weld, 1949 | Paintings 11 | http://www.metmuseum.org/art/collection/search/13033 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
12058 | 12058 | 54.90.107 | 0 | 1 | 13117 | American Paintings and Sculpture 2 | Watercolor 198 | Weehawken from Turtle Grove | Former Attribution|Artist 55 | Formerly attributed to | William Guy Wall|William James Bennett | Irish, Dublin 1792–after 1864 Ireland (active America)|American, London 1787–1844 New York | Wall, William Guy|Bennett, William James 1898 | Irish|American 62 | 1792 |1787 | 1864 |1844 | ca. 1830 | 1827 | 1833 | Watercolor and graphite on off-white wove paper 1416 | 15 3/16 x 20 1/16 in. (38.6 x 51 cm) | The Edward W. C. Arnold Collection of New York Prints, Maps, and Pictures, Bequest of Edward W. C. Arnold, 1954 | Drawings 9 | http://www.metmuseum.org/art/collection/search/13117 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
12233 | 12233 | 26.216.77 | 0 | 0 | 13333 | American Paintings and Sculpture 2 | Drawing 23 | Felbrigg Hall, Southwest View (Gloria Deo in Excelsis), Seat of the Honorable William Windham (from McGuire Scrapbook) | Former Attribution 27 | Formerly attributed to | William Windham | Windham, William 1928 | 1800 | 1900 | Graphite on off-white wove paper 37 | 3 15/16 x 6 7/8 in. (10 x 17.5 cm) | Gift of James C. McGuire, 1926 | Drawings 9 | http://www.metmuseum.org/art/collection/search/13333 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||||
13059 | 13059 | 40.167.1 | 0 | 1 | 14206 | American Paintings and Sculpture 2 | Drawing 23 | Governor George Clinton | Artist|Former Attribution 54 | Formerly attributed to | Thomas Bluget De Valdenuit|Charles Balthazar Julien Févret de Saint-Mémin | 1763–1846|1770–1852 | Valdenuit, Thomas Bluget De|de Saint-Mémin, Charles Balthazar Julien Févret 1738 | French|French 21 | 1763 |1770 | 1846 |1852 | ca. 1797 | 1794 | 1797 | Conté crayon, charcoal (?), and white-chalk heightening on off-white laid paper coated with gouache 1790 | 21 1/2 x 14 3/8 in. (54.6 x 36.5 cm) | Purchase, Anonymous Gift, 1940 | Made in 1 | France 9 | Drawings 9 | http://www.metmuseum.org/art/collection/search/14206 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
13350 | 13350 | 95.22.6b | 0 | 1 | 14512 | American Paintings and Sculpture 2 | Painting 69 | Benjamin West (fragment from a portrait) | Artist|Former Attribution 54 | Formerly attributed to | James Green|Benjamin West | British, Leytonstone 1771–1834 Bath|American, Swarthmore, Pennsylvania 1738–1820 London | Green, James|West, Benjamin 2203 | British|American 33 | 1771 |1738 | 1834 |1820 | 1818 | 1818 | 1818 | Oil on canvas 953 | 44 1/4 x 18 5/8 in. (112.4 x 47 cm) | Maria DeWitt Jesup Fund, 1895 | Paintings 11 | http://www.metmuseum.org/art/collection/search/14512 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
13351 | 13351 | 95.22.6a | 0 | 1 | 14513 | American Paintings and Sculpture 2 | Painting 69 | Benjamin West | Artist|Former Attribution 54 | Formerly attributed to | James Green|Benjamin West | British, Leytonstone 1771–1834 Bath|American, Swarthmore, Pennsylvania 1738–1820 London | Green, James|West, Benjamin 2203 | British|American 33 | 1771 |1738 | 1834 |1820 | 1818 | 1818 | 1818 | Oil on canvas 953 | 44 1/4 x 18 5/8 in. (112.4 x 47 cm) | Maria DeWitt Jesup Fund, 1895 | Paintings 11 | http://www.metmuseum.org/art/collection/search/14513 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
13842 | 13842 | 2006.235.308 | 0 | 1 | 15009 | American Paintings and Sculpture 2 | Painting, miniature 73 | Portrait of a Lady | Former Attribution 27 | Formerly attributed to | David Boudon | 1748–ca. 1816 | Boudon, David 2267 | Swiss 61 | 1748 | 1816 | 1748 | 1816 | Watercolor on ivory 620 | 2 1/2 x 2 1/2 in. (6.3 x 6.3 cm) | Gift of Gloria Manney, 2006 | Paintings 11 | http://www.metmuseum.org/art/collection/search/15009 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
13947 | 13947 | 2006.235.66 | 0 | 1 | 15114 | American Paintings and Sculpture 2 | Painting, miniature 73 | L. B. Walker | Former Attribution 27 | Formerly attributed to | Edward Miles | British, Yarmouth 1752–1828 Philadelphia, Pennsylvania | Miles, Edward 2288 | British 7 | 1752 | 1828 | 1752 | 1828 | Watercolor on ivory 620 | 2 7/8 x 2 3/16 in. (7.2 x 5.5 cm) | Gift of Gloria Manney, 2006 | Paintings 11 | http://www.metmuseum.org/art/collection/search/15114 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
13948 | 13948 | 2006.235.304a | 0 | 1 | 15115 | American Paintings and Sculpture 2 | Painting, miniature 73 | Portrait of a Gentleman | Former Attribution 27 | Formerly attributed to | Edward Miles | British, Yarmouth 1752–1828 Philadelphia, Pennsylvania | Miles, Edward 2288 | British 7 | 1752 | 1828 | 1752 | 1828 | Watercolor on ivory 620 | 2 7/16 x 2 in. (6.2 x 5.2 cm) | Gift of Gloria Manney, 2006 | Paintings 11 | http://www.metmuseum.org/art/collection/search/15115 | 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");