MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

23 rows where City = 1063

View and edit SQL

Suggested facets: Is Public Domain, Object Name, 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, 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 Repository
210887 1973.527.2 0 1 338275 Drawings and Prints 11 Book 97 The Children's Tableaux. A Novel Colour Book with Pictures Arranged as Tableaux           Designer|Publisher|Publisher 1262   Ernest Nister|E. P. Dutton and Company|Ernest Nister German, 1842–1909|New York, NY|London   Nister, Ernest|Dutton, E. P. and Company|Nister, Ernest 19025 German|American 51 1842 |1850 |1842 1909 |1999 |1909 ca. 1895 1890 1900 Illustrations: color lithography and commercial process 31463 10 x 12 6/8 x 11/12 in. (25.4 x 32.4 x 2.3 cm) Gift of Lincoln Kirstein, 1973   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
217037 21.36.157 0 0 344527 Drawings and Prints 11 Book 97 The Baby's Opera, A Book of Old Rhymes with New Dresses...the Music by the Earliest Masters           Artist|Engraver|Publisher 1036 Engraved and printed by Walter Crane|Edmund Evans|Frederick Warne & Co. British, Liverpool 1845–1915 Horsham|British, Southwark, London 1826–1905 Ventnor, Isle of Wight London and New York Crane, Walter|Evans, Edmund|Warne, Frederick & Co. 20834 British|British|British 178 1845 |1826 |1850 1915 |1905 |1950 1877 1877 1877 Illustrations: wood engraving, printed in colors 31191 7 5/16 x 7 9/16 x 1/2in. (18.5 x 19.2 x 1.3cm) Museum Accession, transferred from the Library, 1921   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
217053 1970.641.1 0 0 344543 Drawings and Prints 11 Book 97 The Fables of Aesop: Selected, Told Anew and Their History Traced           Author|Illustrator|Editor|Publisher|Dedicatee|Printer 1517   Aesop|Richard Heighway|Joseph Jacobs|Macmillan & Co.|Francis James Child|R. & R. Clark Greek, ca. 620–560 B.C.|British, active 1787–93|Sydney, New South Wales, Australia 1854–1916 New Rochelle, New York|American, Boston, Massachusetts 1825–1896 Boston, Massachusetts|Edinburgh London & New York Aesop|Heighway, Richard|Jacobs, Joseph|Macmillan & Co.|Child, Francis James|Clark, R. & R. 20910 Greek|British|British|American|British, Scottish 1087 -0620 |1787 |1854 |1843 |1825 |1846 -0560 |1793 |1916 |2012 |1896 |1979 1894 1894 1894 Illustrations: wood engraving 28946 10 1/2 x 7 5/16 x 7/8 in. (26.7 x 18.6 x 2.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1970   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
219408 62.635.18 0 0 346928 Drawings and Prints 11 Book 97 The Delineator, a journal of fashion, culture & fine arts, vol. xxxiii, no. 6           Publisher 16   The Butterwick Publishing Co. New York, NY , and London Butterwick Publishing Co. 21360 American 1 1850 1950 1889 1889 1889     Gift of Harry G. Friedman, 1962   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
219643 1974.617.4 0 0 347163 Drawings and Prints 11 Book 97 Sylvie and Bruno           Author|Publisher|Illustrator|Printer 1151   Lewis Carroll|Macmillan & Co.|Harry Furniss|Richard Clay & Sons, Limited British, Daresbury, Cheshire 1832–1898 Guildford|Irish, Wexford 1854–1925 Hastings|London London and New York|and Bungay Carroll, Lewis|Macmillan & Co.|Furniss, Harry|Clay, Richard & Sons, Limited 22705 British|Irish|British 1381 1832 |1843 |1854 |1850 1898 |2012 |1925 |1980 1889 1889 1889 Illustrations: etching 28943 7 1/2 x 5 1/2 in. (19.1 x 14 cm) Rogers Fund, 1974   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
220570 1972.655.4 0 0 348105 Drawings and Prints 11 Book 97 Aladdin, and the Wonderful Lamp           Illustrator|Engraver|Publisher 1140 Engraved and printed by Walter Crane|Edmund Evans|John Lane British, Liverpool 1845–1915 Horsham|British, Southwark, London 1826–1905 Ventnor, Isle of Wight , London and New York Crane, Walter|Evans, Edmund|Lane, John 23353 British|British|British 178 1845 |1826 |1854 1915 |1905 |1925 [ca. 1901] 1896 1906 Illustrations: wood engraving, printed in color 34721 10 11/16 x 9 3/16 x 1/8 in. (27.1 x 23.3 x 0.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
220730 1972.632.9 0 0 348266 Drawings and Prints 11 Book 97 The Shepheard's Calender: Twelve Aeglogues Proportionable to the Twelve Months           Illustrator|Author|Publisher 1083   Walter Crane|Edmund Spenser|Harper & Brothers British, Liverpool 1845–1915 Horsham|British, London 1552?–1599 London|American, New York   Crane, Walter|Spenser, Edmund|Harper & Brothers 23460 British|British|American 756 1845 |1552 |1833 1915 |1599 |1962 1898 1898 1898 Illustrations: woodcut 33876 8 1/4 × 6 9/16 × 1 in. (20.9 × 16.7 × 2.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
220748 1973.572.1 0 0 348284 Drawings and Prints 11 Book 97 The Shepheard's Calender: Twelve Aeglogues Proportionable to the Twelve Months           Illustrator|Author|Publisher 1083   Walter Crane|Edmund Spenser|Harper & Brothers British, Liverpool 1845–1915 Horsham|British, London 1552?–1599 London|American, New York   Crane, Walter|Spenser, Edmund|Harper & Brothers 23460 British|British|American 756 1845 |1552 |1833 1915 |1599 |1962 1898 1898 1898 Illustrations: woodcut 33876 8 1/4 × 6 9/16 × 1 in. (20.9 × 16.7 × 2.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1973   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
220758 1986.1145.31 0 0 348295 Drawings and Prints 11 Book 97 Kate Greenaway's Birthday Book for Children           Artist|Printer|Author|Publisher 1325 Verses by Kate Greenaway|Edmund Evans|Lucy Elizabeth Drummond Sale-Barker|Frederick Warne & Co. British, London 1846–1901 London|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|British, 1841–1892   Greenaway, Kate|Evans, Edmund|Sale-Barker, Lucy Elizabeth Drummond|Warne, Frederick & Co. 23483 British|British|British|British 177 1846 |1826 |1841 |1850 1901 |1905 |1892 |1950 [ca. 1918] 1913 1923 Illustrations: colored wood engravings 34761 4 x 4 1/4 in. (10.2 x 10.8 cm) Gift of Estate of Jane Erdmann Whitney, 1986   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
220965 65.518.23 0 0 348504 Drawings and Prints 11 Book 97 Undine           Illustrator|Printer|Publisher|Author|Translator 2229 Adapted from the German by Arthur Rackham|Ballantyne & Co.|William Heinemann Ltd.|Friedrich Heinrich Karl, Freiherr de La Motte-Fouqué|William Leonard Courtney British, London 1867–1939 Limpsfield, Surrey|Edinburgh and London|London|German, Brandenburg 1777–1843 Berlin|British, Poona, India 1850–1928 London   Rackham, Arthur|Ballantyne & Co.|Heinemann,William Ltd.|La Motte-Fouqué, Friedrich Heinrich Karl Freiherr de|Courtney, William Leonard 23633 British|German|British 1432 1867 |1800 |1850 |1777 |1850 1939 |2000 |1950 |1843 |1928 1909 1909 1909 Illustrations: Hentschel Colourtype (photomechanical process) 34812 10 x 7 1/2 x 15/16 in. (25.4 x 19.1 x 2.4 cm) Gift of Fairchild Bowler, 1965   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
221183 1976.612.1 0 0 348725 Drawings and Prints 11 Book 97 San Francisco: A Pageant           Author|Illustrator|Publisher 1154   Charles Caldwell Dobie|Edward Howard Suydam|D. Appleton & Co. American, 1881–1943|American, Vineland, New Jersey 1885–1940 Charlottesville, Virginia|New York, NY and London Dobie, Charles Caldwell|Suydam, Edward Howard|Appleton, D. & Co. 23780 American|American|American 101 1881 |1885 |1800 1943 |1940 |1900 1933 1933 1933 Illustrations: lithography and photomechanical reproduction 34226 9 3/16 x 6 5/16 x 1 9/16 in. (23.4 x 16 x 4 cm) Gift of Lillian and Elmer Sheets, 1976   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
221286 24.66.108 0 0 348834 Drawings and Prints 11 Book ; Ornament and architecture 13811 A Treatise on the Theory and Practice of Landscape Gardening Adapted to North America; with a view to the Improvement of Country Residences...[and] Remarks on Rural Architecture, 4th editiion           Illustrator|Publisher|Etcher|Author|Publisher 2291   Alexander Jackson Davis|Longman and Co.|H. Jordan|Andrew Jackson Downing|G. P. Putnam American, New York 1803–1892 West Orange, New Jersey|British, London|American, 19th century|American, Newburgh, New York 1815–1852 Yonkers, New York|New York, NY   Davis, Alexander Jackson|Longman and Co.|Jordan, H.|Downing, Andrew Jackson|Putnam, G. P. 23862 American|British|American|American|American 1526 1803 |1800 |1820 |1815 |1800 1892 |1900 |1850 |1852 |1900 1849 1849 1849 Illustrations: etching and wood engraving 34879 9 3/8 × 5 7/8 × 1 7/16 in. (23.8 × 15 × 3.7 cm) Harris Brisbane Dick Fund, 1924   New York|London 1063                   Books|Ornament & Architecture 665   Metropolitan Museum of Art, New York, NY 1
221549 66.540.29 0 0 349101 Drawings and Prints 11 Book 97 Ecclesiasticus or the Wisdom of Jesus the Son of Sirach           Author|Illustrator|Publisher|Printer|Publisher 2300 Introduction by|Printed by John Johnson at the Charles Lewis Hind|Violet E. Brunton|Dodd, Mead & Co.|Oxford University Press|John Lane, The Bodley Head British, 1862–1927|British, Brighouse 1878–1951 , Limited, London Hind, Charles Lewis|Brunton, Violet E.|Dodd, Mead & Co.|Oxford University Press|Lane, John, The Bodley Head 24007 British|British|American|British|British 1544 1862 |1878 |1850 |1800 |1854 1927 |1951 |1950 |2050 |1925 1927 1927 1927 Illustrations: wood engraving and photomechanical reproduction 34548 10 3/16 x 6 11/16 x 1 1/8 in. (25.9 x 17 x 2.9 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
221788 1975.635.4 0 0 349346 Drawings and Prints 11 Book 97 Woman Alive           Author|Illustrator|Publisher 1154   Susan Ertz|Bip Pares|D. Appleton & Co. British, 1894–1985|British, 1904–1975|New York, NY and London Ertz, Susan|Pares, Bip|Appleton, D. & Co. 24174 British|British|American 756 1894 |1904 |1800 1985 |1975 |1900 1936 1936 1936 Illustrations: lithography, halftone 34967 7 11/16 x 5 5/16 in. (19.5 x 13.5 cm) Gift of David W. Kiehl in Memory of John J. McKendry, 1975   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
222923 44.67 0 0 350492 Drawings and Prints 11 Book 97 Eighty Drawings including the Weaker Sex: The Story of a Susceptible Bachelor           Artist|Publisher|Publisher 876   Charles Dana Gibson|Charles Scribner's Sons|John Lane American, Roxbury, Massachusetts 1867–1944 New York|New York, NY , London Gibson, Charles Dana|Scribner's, Charles, Sons|Lane, John 25063 American|American|British 884 1867 |1800 |1854 1944 |1999 |1925 1903 1903 1903 Illustrations: photomechanical reproduction 34086 11 3/4 × 17 3/8 × 13/16 in. (29.8 × 44.2 × 2 cm) Anonymous Gift, 1944   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
226511 1972.655.13 0 0 354124 Drawings and Prints 11 Book 97 The Cuckoo Clock           Author|Publisher|Illustrator|Engraver 2334   Mary Louisa Molesworth|Macmillan & Co.|Walter Crane|Joseph Swain British (born Scotland), 1839–1921|British, Liverpool 1845–1915 Horsham|British, Oxford 1820–1909 London   Molesworth, Mary Louisa|Macmillan & Co.|Crane, Walter|Swain, Joseph 27732 British, Scottish|British|British 1188 1839 |1843 |1845 |1820 1921 |2012 |1915 |1909 1898 1898 1898 Illustrations: commercial color process and line block reproductions of wood-engraved ilustrations 35661 7 1/2 x 5 5/16 x 1 1/8 in. (19 x 13.5 x 2.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
226512 1972.655.11 0 0 354125 Drawings and Prints 11 Book 97 The Tapestry Room, A Child's Romance           Author|Publisher|Illustrator|Engraver 2334   Mary Louisa Molesworth|Macmillan & Co.|Walter Crane|Joseph Swain British (born Scotland), 1839–1921|British, Liverpool 1845–1915 Horsham|British, Oxford 1820–1909 London   Molesworth, Mary Louisa|Macmillan & Co.|Crane, Walter|Swain, Joseph 27732 British, Scottish|British|British 1188 1839 |1843 |1845 |1820 1921 |2012 |1915 |1909 1904 1904 1904 Illustrations: wood engraving 28946 7 1/2 x 5 1/16 x 1 7/16 in. (19 x 12.8 x 3.6 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
226514 1972.655.17 0 0 354127 Drawings and Prints 11 Book 97 Two Little Waifs           Author|Illustrator|Publisher|Engraver 1725   Mary Louisa Molesworth|Walter Crane|Macmillan & Co.|Joseph Swain British (born Scotland), 1839–1921|British, Liverpool 1845–1915 Horsham|British, Oxford 1820–1909 London   Molesworth, Mary Louisa|Crane, Walter|Macmillan & Co.|Swain, Joseph 27734 British, Scottish|British|British 1188 1839 |1845 |1843 |1820 1921 |1915 |2012 |1909 1890 1890 1890 Illustrations: wood engraving 28946 6 11/16 x 4 3/4 x 11/16 in. (17 x 12 x 1.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
226515 1972.655.16 0 0 354128 Drawings and Prints 11 Book 97 "US" an Old-Fashioned Story           Author|Illustrator|Publisher|Engraver 1725   Mary Louisa Molesworth|Walter Crane|Macmillan & Co.|Joseph Swain British (born Scotland), 1839–1921|British, Liverpool 1845–1915 Horsham|British, Oxford 1820–1909 London   Molesworth, Mary Louisa|Crane, Walter|Macmillan & Co.|Swain, Joseph 27734 British, Scottish|British|British 1188 1839 |1845 |1843 |1820 1921 |1915 |2012 |1909 1903 1903 1903 Illustrations: wood engraving 28946 7 1/2 x 5 3/16 x 1 5/16 in. (19 x 13.1 x 3.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1972   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
255763 24.66.363(2) 0 1 384431 Drawings and Prints 11 Drawing ; Ornament and architecture 13833 Design for a Cottage-Villa in the Bracketted Mode, Constructed in Wood (perspective and plan)           Artist 2   Alexander Jackson Davis American, New York 1803–1892 West Orange, New Jersey   Davis, Alexander Jackson 2502 American 1 1803 1892 ca. 1842 1837 1847 Watercolor and ink, over graphite 41106 sheet: 9 3/16 x 5 11/16 in. (23.4 x 14.5 cm) Harris Brisbane Dick Fund, 1924   New York|London 1063                   Drawings|Ornament & Architecture 671   Metropolitan Museum of Art, New York, NY 1
256184 83.2.2059 0 0 384855 Drawings and Prints 11 Print 731 Mount Vernon in Virginia           Artist|Artist|Publisher 895 Etched and published by|After Francis Jukes|Alexander Robertson|Alexander Robertson British, Hertfordshire 1747–1812 London|American, active early 19th century|American, active early 19th century   Jukes, Francis|Robertson, Alexander|Robertson, Alexander 36862 British|American|American 691 1747 |1750 |1750 1812 |1850 |1850 March 31, 1800 1800 1800 Hand-colored aquatint 40382 plate: 21 9/16 x 26 5/8 in. (54.8 x 67.6 cm) sheet: 14 1/2 x 18 9/16 in. (36.8 x 47.1 cm) Gift of William H. Huntington, 1883   New York|London 1063                   Prints 13   Metropolitan Museum of Art, New York, NY 1
264446 2010.299.6 0 0 393406 Drawings and Prints 11 Book 97 Poems of Wordsworth           Author|Publisher|Editor|Artist|Artist|Artist|Binder 4536 After|After William Wordsworth|Macmillan & Co.|Matthew Arnold|Charles Henry Jeens|Thomas Goff Lupton|Benjamin Robert Haydon|W. T. Morrell and Co. British, Cockermouth, Cumberland 1770–1850 Grasmere|British, 1822–1888|British, Uley, Gloucestershire 1827–1879 London|British, London 1791–1873 London|British, Plymouth 1786–1846 London|British, late 19th–20th century   Wordsworth, William|Macmillan & Co.|Arnold, Matthew|Jeens, Charles Henry|Lupton, Thomas Goff|Haydon, Benjamin Robert|Morrell, W. T. and Co. 38630 British|British|British|British|British|British 670 1770 |1843 |1822 |1827 |1791 |1786 |0019 1850 |2012 |1888 |1879 |1873 |1846 |0019 1890 1890 1890 Illustrations: engraving 28942 6 1/16 x 4 1/8 x 13/16 in. (15.4 x 10.5 x 2 cm) Gift of David and Katherine Moore, 2010   New York|London 1063                   Books 442   Metropolitan Museum of Art, New York, NY 1
269236 66.542.10 0 0 398336 Drawings and Prints 11 Book 97 The Pilgrim's Progress: From This World to That Which is to Come: Delivered Under the Similitude of a Dream; Wherein is Discovered the Manner of His Setting Out; His Dangerous Journey; and Safe Arrival at the Desired Country           Author|Sitter|Publisher 4596   John Bunyan|John Bunyan|Ballantyne, Hanson & Co. British, baptised Elstow, Bedfordshire 1628–1688 London|British, baptised Elstow, Bedfordshire 1628–1688 London|Edinburgh and London   Bunyan, John|Bunyan, John|Ballantyne, Hanson & Co. 39869 British|British|British, active Scotland and England 1284 1628 |1628 |1850 1688 |1688 |1920 [1916]? 1916 1916 Illustrations: etching 28943 9 1/8 x 6 3/4 x 1 5/8 in. (23.2 x 17.1 x 4.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1966   New York|London 1063                   Books 442   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 127.115ms · Data license: CC0 · Data source: metmuseum/openaccess