Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Object Name, Artist Role, Artist Nationality, Object Date, Object Begin Date, Object End Date, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
217077 | 217077 | 17.3.2641(59) | 0 | 1 | 344567 | Drawings and Prints 11 | Book 97 | Household Stories from the Collection of the Brothers Grimm | Illustrator|Translator|Publisher|Author|Author 1531 | Walter Crane|Lucy Crane|Macmillan & Co.|Jacob Ludwig Carl Grimm|Wilhelm Carl Grimm | British, Liverpool 1845–1915 Horsham|British, 1842–1882|German, Hanau, Hesse-Kassel 1785–1863 Berlin|German, Hanau 1786–1859 Berlin | Crane, Walter|Crane, Lucy|Macmillan & Co.|Grimm, Jacob Ludwig Carl|Grimm, Wilhelm Carl 20931 | British|British|German|German 1089 | 1845 |1842 |1843 |1785 |1786 | 1915 |1882 |2012 |1863 |1859 | 1882 | 1882 | 1882 | Illustrations: wood engraving 28946 | 7 11/16 x 5 3/8 x 7/8in. (19.6 x 13.7 x 2.3cm) | Harris Brisbane Dick Fund, 1917 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/344567 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
217283 | 217283 | 22.14 | 0 | 1 | 344774 | Drawings and Prints 11 | Book 97 | The Music Master | Author|Publisher|Illustrator|Illustrator|Engraver 1581 | William Allingham|Routledge & Co.|Dante Gabriel Rossetti|Sir John Everett Millais|Dalziel Brothers | Irish, Ballyshannon, Donegal 1824–1889 Hampstead, London|London|British, London 1828–1882 Birchington-on-Sea|British, Southampton 1829–1896 London|British, active 1839–1893 | Allingham, William|Routledge & Co.|Rossetti, Dante Gabriel|Millais, John Everett, Sir|Dalziel Brothers 21069 | Irish|British|British|British|British 1127 | 1824 |1850 |1828 |1829 |1839 | 1889 |1950 |1882 |1896 |1893 | 1855 | 1855 | 1855 | Illustrations: wood engraving 28946 | 6 7/8 x 4 1/2 in. (17.5 x 11.5 cm) | Rogers Fund, 1922 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/344774 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
218131 | 218131 | 62.675 | 0 | 1 | 345632 | Drawings and Prints 11 | Book 97 | Celtic Fairy Tales | Illustrator|Editor|Publisher 1756 | Selected and edited by | John Dickson Batten|Joseph Jacobs|David Nutt | British, 1860–1932|Sydney, New South Wales, Australia 1854–1916 New Rochelle, New York|London | Batten, John Dickson|Jacobs, Joseph|Nutt, David 21655 | British|British|British 178 | 1860 |1854 |1850 | 1932 |1916 |1950 | 1895 | 1895 | 1895 | Illustrations: wood engraving 28946 | 7 11/16 x 5 11/16 in. (19.5 x 14.5 cm) | Gift of Marion P. Bolles, 1962 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/345632 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
218490 | 218490 | 31.69.2(1) | 0 | 1 | 345995 | Drawings and Prints 11 | Book 97 | Quadrupeds | Artist|Printer|Engraver 1824 | Designed and engraved by | Thomas Bewick|Edward Walker|William W. Temple | British, Eltringham, Northumberland 1753–1828 Gateshead|Newcastle-upon-Tyne|British, baptized Newcastle upon Tyne 1798–1837 | Bewick, Thomas|Edward Walker|Temple, William W. 21886 | British|British|British 178 | 1753 |1800 |1798 | 1828 |1850 |1837 | [1820] | 1820 | 1820 | Illustrations: wood engraving 28946 | 11 1/8 × 7 1/2 × 1 7/8 in. (28.3 × 19.1 × 4.7 cm) | Harris Brisbane Dick Fund, 1931 | Books 442 | http://www.metmuseum.org/art/collection/search/345995 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
221294 | 221294 | 63.698.1(1–8) | 0 | 1 | 348842 | Drawings and Prints 11 | Book 97 | Pictures of Extra Articles and Visitors to the Exhibition | Publisher|Artist|Printer 1318 | Chapman and Hall|Richard Doyle|Dalziel Brothers | London|British, London 1824–1883 London|British, active 1839–1893 | Chapman and Hall|Doyle, Richard|Dalziel Brothers 23868 | British|British|British 178 | 1800 |1824 |1839 | 1999 |1883 |1893 | ca. 1851 | 1846 | 1856 | Illustrations: wood engraving 28946 | 4 15/16 x 7 1/16 x 1/4 in. (12.5 x 17.9 x 0.6 cm) | Gift of Lincoln Kirstein, 1963 | Books 442 | http://www.metmuseum.org/art/collection/search/348842 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
222269 | 222269 | 36.500.1 | 0 | 1 | 349829 | Drawings and Prints 11 | Book 97 | Catalogue of the F. M. Co., Art Pottery, Barbotine Vases, Baskets, Jardineres, &c. | Author 41 | Faience Manufacturing Company | American, New York, 1881–1892 | Faience Manufacturing Company 404 | American 1 | 1881 | 1892 | 1881–82 | 1881 | 1882 | Illustrations: wood engraving 28946 | 7 13/16 x 5 3/8 in. (19.9 x 13.7 cm) | Gift of V. Ottilie von Wallmenich, 1936 | Books 442 | http://www.metmuseum.org/art/collection/search/349829 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
223414 | 223414 | 65.629.3(1) | 0 | 1 | 350990 | Drawings and Prints 11 | Book ; periodical 13880 | Good Words for 1862 | Editor|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Publisher|Engraver|Illustrator|Illustrator|Printer|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator 2639 | Norman Macleod|Sir John Everett Millais|William Holman Hunt|Sir John Tenniel|Charles Samuel Keene|Frederick Walker|John Dawson Watson|Alexander Strahan & Co.|Dalziel Brothers|Thomas Morten|Frederick Augustus Sandys|Bradbury & Evans|Henry Stormonth Leifchild|John MacWhirter|Thomas Alexander Ferguson Graham|William Paton Burton|Arthur Boyd Houghton|Henry Hugh Armstead|James McNeill Whistler|Simeon Solomon|Matthew James Lawless|George Henry Andrews|Frank Stone|John Pettie|Sir Edward Burne-Jones|Charles Piazzi Smyth | British, Campbeltown, Argyll, Scotland 1812–1872 Glasgow|British, Southampton 1829–1896 London|British, London 1827–1910 London|British, London 1820–1914 London|British, Hornsey, Middlesex 1823–1891 London|British, London 1840–1875 Perthshire, Scotland|British, Sedbergh, Yorkshire 1832–1892 Conwy, Wales|British, active 1839–1893|British, Uxbridge 1836–1866 London|British, Norwich 1829–1904 London|British, London 1823–1884 London|British, Edinburgh, Scotland 1837–1911 London|British, Kirkwall, Orkney, Scotland 1840–1906 Edinburgh|British, Madras, India 1828–1883 Kincardineshire, Scotland|British, Madras, India 1836–1875 London|British, London 1828–1905 London|American, Lowell, Massachusetts 1834–1903 London|British, London 1840–1905 London|Irish, Dublin 1837–1864 London|British, Lambeth 1816–1898 Hammersmith|British, Manchester 1800–1859 London|British, Edinburgh, Scotland 1839–1893 Hastings|British, Birmingham 1833–1898 Fulham|British (born Italy), Naples 1819–1900 Ripon, Yorkshire | , London | Macleod, Norman|Millais, John Everett, Sir|Hunt, William Holman|Tenniel, John Sir|Keene, Charles Samuel|Walker, Frederick|Watson, John Dawson|Strahan, Alexander & Co.|Dalziel Brothers|Morten, Thomas|Sandys, Frederick Augustus|Bradbury & Evans|Leifchild, Henry Stormonth|MacWhirter, John|Graham, Thomas Alexander Ferguson|Burton, William Paton|Houghton, Arthur Boyd|Armstead, Henry Hugh|Whistler, James McNeill|Solomon, Simeon|Lawless, Matthew James|Andrews, George Henry|Stone, Frank|Pettie, John|Burne-Jones, Edward, Sir|Smyth, Charles Piazzi 25443 | British, Scottish|British|British|British|British|British|British|British|British|British|British|British|British|British, Scottish|British, Scottish|British|British, born India|British|American|British|Irish|British|British|British, born Scotland|British|British, born Italy 1743 | 1812 |1829 |1827 |1820 |1823 |1840 |1832 |1840 |1839 |1836 |1829 |1830 |1823 |1837 |1840 |1828 |1836 |1828 |1834 |1840 |1837 |1816 |1800 |1839 |1833 |1819 | 1812 |1896 |1910 |1914 |1891 |1875 |1892 |1940 |1893 |1866 |1904 |1930 |1884 |1911 |1906 |1883 |1875 |1905 |1903 |1905 |1864 |1898 |1859 |1893 |1898 |1900 | 1862 | 1862 | 1862 | Illustrations: wood engraving 28946 | 9 3/4 x 7 1/4 x 2 1/8 in. (24.8 x 18.4 x 5.4 cm) | Gift of Sinclair Hamilton, 1965 | Books|Periodicals 698 | http://www.metmuseum.org/art/collection/search/350990 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
225813 | 225813 | 24.66.110 | 0 | 1 | 353415 | Drawings and Prints 11 | Book ; Ornament and Architecture 13814 | An Encyclopedia of Cottage, Farm and Villa Architecture and Furniture | Publisher|Author 45 | Longman, Rees, Orme, Brown, Green and Longman|John Claudius Loudon | London|British (born Scotland), 1783–1843 | Longman, Rees, Orme, Brown, Green and Longman|Loudon, John Claudius 21284 | British|British 9 | 1800 |1783 | 1900 |1843 | 1835 | 1835 | 1835 | Illustrations: wood engraving 28946 | 8 13/16 × 5 1/2 × 2 3/8 in. (22.4 × 14 × 6 cm) | Harris Brisbane Dick Fund, 1924 | Books|Ornament & Architecture 665 | http://www.metmuseum.org/art/collection/search/353415 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
227314 | 227314 | 33.21.10 | 0 | 1 | 354931 | Drawings and Prints 11 | Book ; periodical 13880 | Our Young Folks, Vol. III, Nos. I-XII | Publisher|Illustrator|Sitter|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Illustrator|Engraver 3181 | Frontispiece portrait of | Ticknor and Fields|Winslow Homer|Captain Mayne Reid|Solomon Eytinge Jr.|Harry Fenn|Henry Louis Stephens|Augustus Hoppin|Gaston Fay|Sir John Tenniel|William James Linton | American, Boston, Massachusetts|American, Boston, Massachusetts 1836–1910 Prouts Neck, Maine|Irish, Ballyroney, County Down 1818–1883 London|American, 1833–1905 Bayonne, New Jersey|American (born England), Surrey 1845–1911 Montclair, New Jersey|American, Philadelphia, Pennsylvania 1824–1882 Bayonne, New Jersey|American, Providence, Rhode Island 1828–1896 Queens, New York|American (?), active 19th century|British, London 1820–1914 London|British, London 1812–1897 New Haven, Connecticut | Ticknor and Fields|Homer, Winslow|Reid, Mayne Captain|Eytinge, Solomon Jr.|Fenn, Harry|Stephens, Henry Louis|Hoppin, Augustus|Fay, Gaston|Tenniel, John Sir|Linton, William James 28252 | American|American|Irish|American|American, born England|American|American|American?|British 2083 | 1836 |1818 |1833 |1845 |1824 |1828 |1800 |1820 |1812 | 1910 |1883 |1905 |1911 |1882 |1896 |1900 |1914 |1897 | 1867 | 1867 | 1867 | Illustrations: wood engraving 28946 | 8 7/16 x 5 11/16 in. (21.5 x 14.5 cm) | Harris Brisbane Dick Fund, 1933 | Books|Periodicals 698 | http://www.metmuseum.org/art/collection/search/354931 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
228787 | 228787 | 21.14.1 | 0 | 1 | 356425 | Drawings and Prints 11 | Book 97 | The Prince's Progress, and Other Poems | Author|Artist|Publisher|Printer|Engraver|Binder 3376 | Binding and illustrations by | Christina Georgina Rossetti|Dante Gabriel Rossetti|Macmillan & Co.|R. Clay, Son(s), and Taylor|William James Linton|Burn | British, London 1830–1894 London|British, London 1828–1882 Birchington-on-Sea|London|British, London 1812–1897 New Haven, Connecticut|London | London | Rossetti, Christina Georgina|Rossetti, Dante Gabriel|Macmillan & Co.|Clay R., Son(s), and Taylor|Linton, William James|Burn 29257 | British|British|British|British|British 394 | 1830 |1828 |1843 |1800 |1812 |1800 | 1894 |1882 |2012 |1900 |1897 |1900 | 1866 | 1866 | 1866 | Illustrations: wood engraving 28946 | 7 x 4 1/2 in. (17.8 x 11.4 cm) | Rogers Fund, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/356425 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
229028 | 229028 | 54.629.3 | 0 | 1 | 356673 | Drawings and Prints 11 | Book 97 | Illustrated Catalogue Spring of 1888 | Author 41 | Sargent Manufacturing Co. | New York, NY | Sargent Manufacturing Co. 29451 | American 1 | 1800 | 1900 | 1888 | 1888 | 1888 | Illustrations: wood engraving 28946 | 5 7/8 x 8 9/16 in. (15 x 21.8 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1954 | Books 442 | http://www.metmuseum.org/art/collection/search/356673 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
230255 | 230255 | 21.36.76 | 0 | 1 | 357941 | Drawings and Prints 11 | Book 97 | The Pastorals of Virgil, with a Course of English Reading, Adapted for Schools, Vol. I | Editor|Illustrator|Publisher|Author 3439 | Robert John Thornton|William Blake|F. C. & J. Rivington|Virgil | British, 1768–1837|British, London 1757–1827 London|London|Roman, Andes 70 B.C.–19 B.C. Brundisium | Thornton, Robert John|Blake, William|Rivington, F. C. & J.|Virgil 30296 | British|British|British|Italian 1669 | 1768 |1757 |1750 |-0070 | 1837 |1827 |1850 |-0019 | 1821 | 1821 | 1821 | Illustrations: wood engraving 28946 | 7 1/16 x 4 5/16 in. (18 x 11 cm) | Museum Accession, transferred from the Library, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/357941 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
238112 | 238112 | 52.519.105 | 0 | 1 | 366143 | Drawings and Prints 11 | Book 97 | How to Lay Out a Garden | Author|Publisher 44 | Edward Kemp|Bradbury & Evans | British, active 19th century | Kemp, Edward|Bradbury & Evans 32732 | British|British 9 | 1800 |1830 | 1900 |1930 | 1864 | 1864 | 1864 | Illustrations: wood engraving 28946 | 9 x 5 7/8 x 1 9/16 in. (22.8 x 15 x 4 cm) | Rogers Fund, 1952 | Books 442 | http://www.metmuseum.org/art/collection/search/366143 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
238776 | 238776 | 2004.482 | 0 | 1 | 366831 | Drawings and Prints 11 | Book 97 | Pictures from Italy | Author|Illustrator|Publisher 1154 | Charles Dickens|Samuel Palmer|Bradbury & Evans | British, Portsmouth 1812–1870 Rochester|British, London 1805–1881 Redhill, Surrey | Dickens, Charles|Palmer, Samuel|Bradbury & Evans 32980 | British|British|British 178 | 1812 |1805 |1830 | 1870 |1881 |1930 | 1846 | 1846 | 1846 | Illustrations: wood engraving 28946 | sheet: 6 7/8 x 4 3/8 in. (17.5 x 11.1 cm) book: 7 1/16 x 4 3/4 x 13/16 in. (18 x 12 x 2 cm) | A. Hyatt Mayor Purchase Fund, Marjorie Phelps Starr Bequest, 2004 | Books 442 | http://www.metmuseum.org/art/collection/search/366831 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
241238 | 241238 | 30.75.2 | 0 | 1 | 369370 | Drawings and Prints 11 | Book 97 | Every Saturday: An Illustrated Journal of Choice Reading, Vol. II, New Series | Publisher|Illustrator 1742 | Fields, Osgood & Co.|Winslow Homer | Boston, Massachusetts|American, Boston, Massachusetts 1836–1910 Prouts Neck, Maine | Fields, Osgood & Co.|Homer, Winslow 33571 | American|American 5 | 1830 |1836 | 1930 |1910 | January–June 1871 | 1871 | 1871 | Illustrations: wood engraving 28946 | 14 3/4 x 11 7/16 in. (37.5 x 29 cm) | Harris Brisbane Dick Fund, 1930 | Books 442 | http://www.metmuseum.org/art/collection/search/369370 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
241664 | 241664 | 33.35.299 | 0 | 1 | 369809 | Drawings and Prints 11 | Book 97 | Nast's Illustrated Almanac | Illustrator|Publisher 1092 | Thomas Nast|Harper & Brothers | American (born Germany), Landau 1840–1902 Guayaquil|American, New York | Nast, Thomas|Harper & Brothers 33689 | American, born Germany|American 172 | 1840 |1833 | 1902 |1962 | 1874 | 1874 | 1874 | Illustrations: wood engraving 28946 | 8 1/16 x 5 11/16 in. (20.5 x 14.5 cm) | Gift of Thomas Nast, Jr., Mabel Nast Crawford and Cyril Nast, 1933 | Books 442 | http://www.metmuseum.org/art/collection/search/369809 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
261430 | 261430 | 58.521(3) | 0 | 1 | 390157 | Drawings and Prints 11 | Book 97 | The Illustrated American Biography; containing correct Portraits and Brief Notices of the Principal Actors in American History, embracing distinguished women, naval and military heroes, statesmen, civilians, jurists, divines authors and artists... | Author|Publisher|Artist|Artist 1268 | After | Abner Dumont Jones|J. Milton Emerson and Co.|John William Orr|Samuel Wallin | American, 1807–1872|New York, NY|American (born, Ireland) 1815–1887 Jersey City, New Jersey|Swedish, active 1838–51 | Jones, Abner Dumont|Emerson, J. Milton and Co.|Orr, John William|Wallin, Samuel 38033 | American|American|American|Swedish 3015 | 1807 |1800 |1815 |1838 | 1872 |1900 |1887 |1851 | 1855 | 1855 | 1855 | Illustrations: wood engraving 28946 | 11 x 8 in. (27.9 x 20.3 cm) | The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1958 | Books 442 | http://www.metmuseum.org/art/collection/search/390157 | 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");