Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Title, 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, Dimensions, Credit Line, City
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
216836 | 216836 | 21.36.102 | 0 | 0 | 344320 | Drawings and Prints 11 | Book 97 | A Apple Pie | Publisher|Author|Engraver 1465 | Frederick Warne & Co.|Kate Greenaway|Edmund Evans | British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | London & New York | Warne, Frederick & Co.|Greenaway, Kate|Evans, Edmund 20803 | British|British|British 178 | 1850 |1846 |1826 | 1950 |1901 |1905 | [before 1921] | 1921 | 1921 | Illustrations: color wood engraving 33868 | 8 1/2 x 10 1/2 in. (21.6 x 26.7 cm) | Museum Accession, transferred from the Library, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/344320 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
216986 | 216986 | 1970.565.55bis | 0 | 0 | 344473 | Drawings and Prints 11 | Book 97 | New Toy Book (Cinderella, Ali Baba and the Forty Thieves, My Mother, The Three Bears, One Two Buckle My Shoe, The Adventures of Puffy, This Little Pig Went to Market, The Noah's Ark ABC) | Artist|Publisher|Engraver 1303 | Engraved and printed by | Walter Crane|George Routledge & Sons|Edmund Evans | British, Liverpool 1845–1915 Horsham|London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | Crane, Walter|Routledge, George & Sons|Evans, Edmund 20852 | British|British 9 | 1845 |1800 |1826 | 1915 |1920 |1905 | 1873 | 1873 | 1873 | Illustrations: color wood engraving 33868 | 10 x 7 1/2 x 11/16 in. (25.4 x 19.1 x 1.8 cm) | Gift of Lincoln Kirstein, 1970 | Books 442 | http://www.metmuseum.org/art/collection/search/344473 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
220606 | 220606 | 1983.1223.6 | 0 | 0 | 348142 | Drawings and Prints 11 | Book 97 | The Royal Progress of King Pepito | Author|Illustrator|Publisher|Engraver 1725 | Engraved and printed by | Beatrice F. Cresswell|Kate Greenaway|Society for Promoting Christian Knowledge|Edmund Evans | British, 19th–20th century|British, London 1846–1901 London|London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | Cresswell, Beatrice F.|Greenaway, Kate|Society for Promoting Christian Knowledge|Evans, Edmund 23379 | British|British|British|British 177 | 1850 |1846 |1800 |1826 | 1950 |1901 |1900 |1905 | [1889] | 1889 | 1889 | Illustrations: color wood engraving 33868 | 8 1/2 x 6 1/4 in. (21.6 x 15.9 cm) | Gift of Mrs. John Barry Ryan, transferred from the Library, 1983 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/348142 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
220607 | 220607 | 1983.1223.7 | 0 | 0 | 348143 | Drawings and Prints 11 | Book 97 | The Royal Progress of King Pepito | Author|Illustrator|Engraver|Publisher 1274 | Engraved and printed by | Beatrice F. Cresswell|Kate Greenaway|Edmund Evans|Society for Promoting Christian Knowledge | British, 19th–20th century|British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|London | Cresswell, Beatrice F.|Greenaway, Kate|Evans, Edmund|Society for Promoting Christian Knowledge 23380 | British|British|British|British 177 | 1850 |1846 |1826 |1800 | 1950 |1901 |1905 |1900 | [1889] | 1889 | 1889 | Illustrations: color wood engraving 33868 | 8 1/2 x 6 1/4 in. (21.6 x 15.9 cm) | Gift of Mrs. John Barry Ryan, transferred from the Library, 1983 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/348143 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
220880 | 220880 | 1983.1223.1 | 0 | 0 | 348419 | Drawings and Prints 11 | Book 97 | A Day in a Child's Life | Illustrator|Engraver|Publisher|Author 2220 | Engraved and printed by|Music by | Kate Greenaway|Edmund Evans|George Routledge & Sons|Myles Birket Foster | British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|London|British, Northumberland 1825–1899 Braeside | Greenaway, Kate|Evans, Edmund|Routledge, George & Sons|Foster, Myles Birket 23569 | British|British|British 178 | 1846 |1826 |1800 |1825 | 1901 |1905 |1920 |1899 | [1881] | 1881 | 1881 | Illustrations: color wood engraving 33868 | 9 3/4 x 8 1/2 in. (24.8 x 21.6 cm) | Gift of Mrs. John Barry Ryan, transferred from the Library, 1983 | London 14 | Books 442 | http://www.metmuseum.org/art/collection/search/348419 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
223581 | 223581 | 21.36.101 | 0 | 0 | 351161 | Drawings and Prints 11 | Book 97 | Birthday Book for Children | Publisher|Author|Illustrator 1602 | Frederick Warne & Co.|Lucy Elizabeth Drummond Sale-Barker|Kate Greenaway | British, 1841–1892|British, London 1846–1901 London | Warne, Frederick & Co.|Sale-Barker, Lucy Elizabeth Drummond|Greenaway, Kate 25560 | British|British|British 178 | 1850 |1841 |1846 | 1950 |1892 |1901 | [ca. 1901] | 1896 | 1906 | Illustrations: color wood engraving 33868 | 3 15/16 x 4 1/16 in. (10 x 10.3 cm) | Museum Accession, transferred from the Library, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/351161 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
223582 | 223582 | 21.36.91 | 0 | 0 | 351162 | Drawings and Prints 11 | Book 97 | A Day in a Child's Life | Illustrator|Publisher|Engraver|Author 1507 | Engraved and printed by|Music by | Kate Greenaway|Routledge & Co.|Edmund Evans|Myles Birket Foster | British, London 1846–1901 London|London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|British, Northumberland 1825–1899 Braeside | Greenaway, Kate|Routledge & Co.|Evans, Edmund|Foster, Myles Birket 25561 | British|British|British|British 177 | 1846 |1850 |1826 |1825 | 1901 |1950 |1905 |1899 | [1881] | 1881 | 1881 | Illustrations: color wood engraving 33868 | 9 3/4 x 8 1/2 in. (24.8 x 21.6 cm) | Museum Accession, transferred from the Library, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/351162 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
223583 | 223583 | 21.36.100 | 0 | 0 | 351163 | Drawings and Prints 11 | Book 97 | Language of Flowers | Illustrator|Publisher 1092 | Kate Greenaway|Routledge & Co. | British, London 1846–1901 London|London | Greenaway, Kate|Routledge & Co. 25562 | British|British 9 | 1846 |1850 | 1901 |1950 | [1884] | 1884 | 1884 | Illustrations: color wood engraving 33868 | 5 7/8 x 4 15/16 in. (15 x 12.5 cm) | Museum Accession, transferred from the Library, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/351163 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
223584 | 223584 | 21.36.98 | 0 | 0 | 351164 | Drawings and Prints 11 | Book 97 | Mother Goose, or the Old Nursery Rhymes | Illustrator|Engraver|Publisher 1140 | Engraved and printed by | Kate Greenaway|Edmund Evans|George Routledge & Sons | British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|London | Greenaway, Kate|Evans, Edmund|Routledge, George & Sons 25563 | British|British 9 | 1846 |1826 |1800 | 1901 |1905 |1920 | 1881 | 1881 | 1881 | Illustrations: color wood engraving 33868 | 6 3/4 x 5 1/16 x 1/2 in. (17.2 x 12.9 x 1.2 cm) | Rogers Fund, transferred from the Library, 1921 | London|New York 1061 | Books 442 | http://www.metmuseum.org/art/collection/search/351164 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
223585 | 223585 | 21.36.95 | 0 | 0 | 351165 | Drawings and Prints 11 | Book 97 | The Queen of the Pirate Isle | Illustrator|Publisher 1092 | Kate Greenaway|Frederick Warne & Co. | British, London 1846–1901 London | London and New York | Greenaway, Kate|Warne, Frederick & Co. 25564 | British|British 9 | 1846 |1850 | 1901 |1950 | [1900] (?) | 1900 | 1900 | Illustrations: color wood engraving 33868 | 8 3/4 x 6 1/2 in. (22.2 x 16.5 cm) | Museum Accession, transferred from the Library, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/351165 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
223821 | 223821 | 17.3.2641(44) | 0 | 0 | 351408 | Drawings and Prints 11 | Book 97 | The Queen of the Pirate Isle | Author|Publisher|Illustrator|Engraver 2334 | Written by|Engraved and printed by | Bret Harte|Chatto & Windus|Kate Greenaway|Edmund Evans | American, Albany, New York 1836–1902 England|London|British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | Harte, Bret|Chatto & Windus|Greenaway, Kate|Evans, Edmund 25763 | American|British|British|British 1458 | 1836 |1850 |1846 |1826 | 1902 |2000 |1901 |1905 | [1886] | 1886 | 1886 | Illustrations: color wood engraving 33868 | 8 3/4 x 6 1/2 in. (22.2 x 16.5 cm) | Harris Brisbane Dick Fund, 1917 | Books 442 | http://www.metmuseum.org/art/collection/search/351408 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
225004 | 225004 | 1983.1223.12 | 0 | 0 | 352598 | Drawings and Prints 11 | Book 97 | Fairy Gifts, or, A Wallet of Wonders | Author|Illustrator|Publisher|Printer|Engraver 2661 | Kathleen Knox|Kate Greenaway|Griffith & Farran|Murray and Gibb|John Greenaway | British, 19th century|British, London 1846–1901 London|London|Edinburgh|British, 1816–1890 | Knox, Kathleen|Greenaway, Kate|Griffith & Farran|Murray and Gibb|Greenaway, John 26660 | British|British|British|British|British 394 | 1800 |1846 |1800 |1850 |1816 | 1900 |1901 |1930 |1950 |1890 | 1875 | 1875 | 1875 | Illustrations: color wood engraving 33868 | 7 x 5 1/4 in. (17.8 x 13.3 cm) | Gift of Mrs. John Barry Ryan, transferred from the Library, 1983 | Books 442 | http://www.metmuseum.org/art/collection/search/352598 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
225358 | 225358 | 1983.1223.4 | 0 | 0 | 352953 | Drawings and Prints 11 | Book 97 | Language of Flowers | Illustrator|Publisher|Printer 1108 | Printed in colors by | Kate Greenaway|George Routledge & Sons|Edmund Evans | British, London 1846–1901 London|London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | Greenaway, Kate|Routledge, George & Sons|Evans, Edmund 26894 | British|British 9 | 1846 |1800 |1826 | 1901 |1920 |1905 | [1884] | 1884 | 1884 | Illustrations: color wood engraving 33868 | 6 x 5 in. (15.2 x 12.7 cm) | Gift of Mrs. John Barry Ryan, transferred from the Library, 1983 | Books 442 | http://www.metmuseum.org/art/collection/search/352953 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
225359 | 225359 | 1983.1223.5 | 0 | 0 | 352954 | Drawings and Prints 11 | Book 97 | Language of Flowers | Illustrator|Publisher|Printer 1108 | Printed in colors by | Kate Greenaway|George Routledge & Sons|Edmund Evans | British, London 1846–1901 London|London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | Greenaway, Kate|Routledge, George & Sons|Evans, Edmund 26894 | British|British 9 | 1846 |1800 |1826 | 1901 |1920 |1905 | [1884] | 1884 | 1884 | Illustrations: color wood engraving 33868 | 6 x 5 in. (15.2 x 12.7 cm) | Gift of Mrs. John Barry Ryan, transferred from the Library, 1983 | Books 442 | http://www.metmuseum.org/art/collection/search/352954 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
230087 | 230087 | 21.36.96 | 0 | 0 | 357759 | Drawings and Prints 11 | Book 97 | Little Ann and Other Poems | Author|Author|Publisher|Illustrator|Engraver 3537 | Engraved and printed by | Ann Taylor|Jane Taylor|Frederick Warne & Co.|Kate Greenaway|Edmund Evans | British, active late 19th century|British, active late 19th century|British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | London | Taylor, Ann|Taylor, Jane|Warne, Frederick & Co.|Greenaway, Kate|Evans, Edmund 30186 | British|British|British|British|British 394 | 1850 |1850 |1850 |1846 |1826 | 1920 |1900 |1950 |1901 |1905 | [ca.1909] | 1904 | 1914 | Illustrations: color wood engraving 33868 | 9 1/4 x 6 1/8 in. (23.5 x 15.5 cm) | Museum Accession, transferred from the Library, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/357759 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
230098 | 230098 | 1983.1223.3 | 0 | 0 | 357770 | Drawings and Prints 11 | Book 97 | Little Ann and Other Poems | Author|Author|Illustrator|Publisher|Printer 1152 | Ann Taylor|Jane Taylor|Kate Greenaway|Frederick Warne & Co.|Edmund Evans | British, active late 19th century|British, active late 19th century|British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | London | Taylor, Ann|Taylor, Jane|Greenaway, Kate|Warne, Frederick & Co.|Evans, Edmund 30191 | British|British|British|British|British 394 | 1850 |1850 |1846 |1850 |1826 | 1920 |1900 |1901 |1950 |1905 | [ca. 1925 or later] | 1920 | 1940 | Illustrations: color wood engraving 33868 | 8 7/8 x 5 7/8 in. (22.5 x 15 cm) | Gift of Mrs. John Barry Ryan, transferred from the Library, 1983 | Books 442 | http://www.metmuseum.org/art/collection/search/357770 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
230099 | 230099 | 1983.1223.2 | 0 | 0 | 357771 | Drawings and Prints 11 | Book 97 | Little Ann and Other Poems | Author|Author|Illustrator|Publisher|Printer 1152 | Printed in colors by | Ann Taylor|Jane Taylor|Kate Greenaway|George Routledge & Sons|Edmund Evans | British, active late 19th century|British, active late 19th century|British, London 1846–1901 London|London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | Taylor, Ann|Taylor, Jane|Greenaway, Kate|Routledge, George & Sons|Evans, Edmund 30192 | British|British|British|British 177 | 1850 |1850 |1846 |1800 |1826 | 1920 |1900 |1901 |1920 |1905 | [1882] | 1882 | 1882 | Illustrations: color wood engraving 33868 | 9 1/4 x 6 1/8 in. (23.5 x 15.5 cm) | Gift of Mrs. John Barry Ryan, transferred from the Library, 1983 | Books 442 | http://www.metmuseum.org/art/collection/search/357771 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
231943 | 231943 | 42.8.10 | 0 | 0 | 359688 | Drawings and Prints 11 | Book 97 | Animula | Author|Illustrator|Publisher|Printer 1121 | T. S. Eliot|Gertrude Hermes|Faber and Faber|The Curwen Press, Ltd. | British (born United States), St. Louis, Missouri 1888–1965 London|British, 1901–1983|British, London|Plaistow | Eliot, T. S.|Hermes, Gertrude|Faber and Faber|Curwen Press, Ltd. 31104 | British, born United States|British|British|British 2386 | 1888 |1901 |1880 | 1965 |1983 |1950 | 1929 | 1929 | 1929 | Illustrations: color wood engraving 33868 | 7 1/4 x 4 3/4 x 1/16 in. (18.4 x 12.1 x 0.2 cm) | Gift of Miss Marie L. Russell, 1942 | Books 442 | http://www.metmuseum.org/art/collection/search/359688 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
238228 | 238228 | 1970.565.590 | 0 | 0 | 366261 | Drawings and Prints 11 | Book 97 | The Baby's Bouquet, A Fresh Bunch of Rhymes and Tunes | Artist|Printer|Publisher|Author 1097 | Tunes collected and arranged by | Walter Crane|Edmund Evans|Frederick Warne & Co.|Lucy Crane | British, Liverpool 1845–1915 Horsham|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|British, 1842–1882 | London and New York | Crane, Walter|Evans, Edmund|Warne, Frederick & Co.|Crane, Lucy 32785 | British|British|British|British 177 | 1845 |1826 |1850 |1842 | 1915 |1905 |1950 |1882 | 1878 | 1878 | 1878 | Illustrations: color wood engraving 33868 | 7 1/8 x 7 5/16 x 7/16 in. (18.1 x 18.5 x 1.1 cm) | Gift of Lincoln Kirstein, 1970 | Books 442 | http://www.metmuseum.org/art/collection/search/366261 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
242617 | 242617 | 21.36.94 | 0 | 0 | 370782 | Drawings and Prints 11 | Book 97 | Under the Window: Pictures and Rhymes for Children | Designer|Engraver|Publisher 1016 | Designed and written by|Engraved and printed by | Kate Greenaway|Edmund Evans|George Routledge & Co. | British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|London and New York | Greenaway, Kate|Evans, Edmund|Routledge, George & Company 33911 | British|British|British American 2661 | 1846 |1826 |1800 | 1901 |1905 |1900 | [1878] | 1878 | 1878 | Illustrations: color wood engraving 33868 | 9 7/16 x 7 11/16 in. (24 x 19.5 cm) | Transferred from the Library, 1921 | Books 442 | http://www.metmuseum.org/art/collection/search/370782 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
242753 | 242753 | 57.681 | 0 | 0 | 370918 | Drawings and Prints 11 | Book 97 | Mother Goose or the Old Nursery Rhymes | Illustrator|Publisher|Printer 1108 | Kate Greenaway|Frederick Warne & Co.|Edmund Evans | British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | London & New York | Greenaway, Kate|Warne, Frederick & Co.|Evans, Edmund 33962 | British|British|British 178 | 1846 |1850 |1826 | 1901 |1950 |1905 | [before 1918] (?) | 1918 | 1918 | Illustrations: color wood engraving 33868 | 6 3/4 x 4 1/2 in. (17.1 x 11.4 cm) | Gift of Olivia H. Paine, 1957 | Books 442 | http://www.metmuseum.org/art/collection/search/370918 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
242758 | 242758 | 57.682 | 0 | 0 | 370923 | Drawings and Prints 11 | Book 97 | Kate Greenaway's Alphabet | Illustrator|Publisher|Engraver 1490 | (?) | Kate Greenaway|George Routledge & Sons|Edmund Evans | British, London 1846–1901 London|London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight | London & New York | Greenaway, Kate|Routledge, George & Sons|Evans, Edmund 26894 | British|British 9 | 1846 |1800 |1826 | 1901 |1920 |1905 | [ca. 1885] | 1880 | 1890 | Illustrations: color wood engraving 33868 | 2 3/4 x 2 3/8 in. (7 x 6 cm) | Gift of Olivia H. Paine, 1957 | Books 442 | http://www.metmuseum.org/art/collection/search/370923 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
242804 | 242804 | 1970.761.3 | 0 | 0 | 370973 | Drawings and Prints 11 | Book 97 | Old Christmas in Merrie England | Author|Illustrator|Publisher 1154 | Washington Irving|Paul McPharlin|Peter Pauper Press | American, New York 1783–1859 Sleepy Hollow, New York|American, 1903–1948|Mount Vernon, New York | Irving, Washington|McPharlin, Paul|Pauper, Peter, Press 33985 | American|American|American 101 | 1783 |1903 |1900 | 1859 |1948 |1999 | [1953] | 1953 | 1953 | Illustrations: color wood engraving 33868 | 7 1/2 x 4 1/2 in. (19.1 x 11.4 cm) | Gift of A. Hyatt Mayor, 1970 | Books 442 | http://www.metmuseum.org/art/collection/search/370973 | 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");