MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

22 rows where Artist Role = 1035

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Artist Prefix, 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, 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
206818 206818 53.600.526 0 0 334162 Drawings and Prints 11 Print 731 Saying Grace           Artist|Engraver|Publisher|Publisher 1035 After Jean Siméon Chardin|Bernard Lepicié|Louis Surugue|Bernard Lepicié French, Paris 1699–1779 Paris|French, Paris 1698–1755 Paris|French, Paris ca. 1686–1762 Grand Vaux|French, Paris 1698–1755 Paris   Chardin, Jean Siméon|Lepicié, Bernard|Surugue, Louis|Lepicié, Bernard 17432 French|French 21 1699 |1698 |1686 |1698 1779 |1755 |1762 |1755 1744 1744 1744 Engraving with stipplework; second state 29132 Image: 12 11/16 x 9 15/16 in. (32.3 x 25.2 cm) Sheet: 14 1/2 x 10 1/16 in. (36.8 x 25.5 cm) Harris Brisbane Dick Fund, 1953                       Prints 13   http://www.metmuseum.org/art/collection/search/334162 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
209272 209272 1974.672.20 0 0 336653 Drawings and Prints 11 Print 731 Death of the Wild Bull (Scene in Chillingham Park)           Artist|Engraver|Publisher|Publisher 1035 After|Published Washington DC Sir Edwin Henry Landseer|Thomas Landseer|Henry Graves & Company|William Schaus British, London 1802–1873 London|British, London 1795–1880 London|London|American, 1821–1892   Landseer, Edwin Henry, Sir|Landseer, Thomas|Graves, Henry & Company|Schaus, William 18497 British|British|British|American 881 1802 |1795 |1820 |1821 1873 |1880 |1899 |1892 February 2, 1874 1870 1875 Etching and mezzotint 30617 Sheet: 26 7/16 x 25 3/4 in. (67.1 x 65.4 cm) Image: 24 5/16 x 23 7/8 in. (61.8 x 60.7 cm) Bequest of Anna Hyatt Huntington, 1974   Washington D.C. 1058                   Prints 13   http://www.metmuseum.org/art/collection/search/336653 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
223167 223167 1970.565.254 0 0 350741 Drawings and Prints 11 Book 97 Animal Stories, Old and New, told in Pictures and Prose.           Artist|Engraver|Publisher|Publisher 1035 Written and illustrated by|Engraved and printed by Harrison William Weir|Edmund Evans|Sampson Low, Marston, Searle & Rivington|E. P. Dutton and Company British, Lewes, Sussex 1824–1906 Appledore, Kent|British, Southwark, London 1826–1905 Ventnor, Isle of Wight|London|New York, NY   Weir, Harrison William|Evans, Edmund|Sampson, Low, Marston, Searle & Rivington|Dutton, E. P. and Company 25243 British|British|British|American 881 1824 |1826 |1800 |1850 1906 |1905 |1900 |1999 [1885] 1885 1885 Illustrations: woodcuts, some printed in color 35198 10 1/16 x 8 11/16 x 3/8 in. (25.6 x 22.1 x 1 cm) Gift of Lincoln Kirstein, 1970                       Books 442   http://www.metmuseum.org/art/collection/search/350741 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
236591 236591 47.30.64 0 0 364496 Drawings and Prints 11 Print 731 High Life           Artist|Engraver|Publisher|Publisher 1035 After|Published Washington DC by Sir Edwin Henry Landseer|Christopher C. Hollyer|Henry Graves & Company|William Schaus British, London 1802–1873 London|British, active ca. 1863–ca. 1873|London|American, 1821–1892   Landseer, Edwin Henry, Sir|Hollyer, Christopher C.|Graves, Henry & Company|Schaus, William 32340 British|British|British|American 881 1802 |1840 |1820 |1821 1873 |1900 |1899 |1892 October 17, 1873 1873 1873 Mixed method engraving on chine collé 37632 Plate: 23 1/4 × 17 11/16 in. (59 × 45 cm) Sheet: 26 9/16 × 22 5/8 in. (67.5 × 57.4 cm) Harris Brisbane Dick Fund, 1947                       Prints 13   http://www.metmuseum.org/art/collection/search/364496 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
259504 259504 24.90.1240 0 0 388203 Drawings and Prints 11 Print 731 Masonic Hall, Broadway, New York           Artist|Engraver|Publisher|Publisher 1035 After Alexander Jackson Davis|Fenner, Sears & Co.|Jennings & Chaplin, London|Isaac Taylor Hinton American, New York 1803–1892 West Orange, New Jersey|London|London   Davis, Alexander Jackson|Fenner, Sears & Co.|Jennings & Chaplin|Hinton, Isaac Taylor 37505 American|British|British|British 1458 1803 |1800 |1820 |1800 1892 |1900 |1860 |1900 1830 1830 1830 Engraving 7208 sheet: 10 9/16 x 8 1/16 in. (26.8 x 20.4 cm) image: 6 5/16 x 4 3/16 in. (16 x 10.6 cm) Bequest of Charles Allen Munn, 1924                       Prints 13   http://www.metmuseum.org/art/collection/search/388203 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
259506 259506 44.10.1 0 0 388205 Drawings and Prints 11 Print 731 Columbia College, New York           Artist|Engraver|Publisher|Publisher 1035 After Alexander Jackson Davis|Fenner, Sears & Co.|Isaac Taylor Hinton|Simpkin & Marshall American, New York 1803–1892 West Orange, New Jersey|London|British, Oxford 1799–1847 New Orleans|London   Davis, Alexander Jackson|Fenner, Sears & Co.|Hinton, Isaac Taylor|Simpkin & Marshall 37507 American|British|British 254 1803 |1800 |1799 |1800 1892 |1900 |1847 |1920 1831 1831 1831 Hand-colored engraving 40197 sheet: 7 15/16 x 10 1/2 in. (20.2 x 26.7 cm) Gift of Edith Agnew, 1944                       Prints 13   http://www.metmuseum.org/art/collection/search/388205 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
283345 283345 60.537.1 0 0 412654 Drawings and Prints 11 Print 731 The Vintage Festival           Artist|Engraver|Publisher|Publisher 1035 After Sir Lawrence Alma-Tadema|Auguste-Thomas-Marie Blanchard|Pilgeram & Lefèvre|Knoedler and Co., New York British (born The Netherlands), Dronrijp 1836–1912 Wiesbaden|French, Paris 1819–1898 Paris|London   Alma-Tadema, Lawrence, Sir|Blanchard, Auguste-Thomas-Marie|Pilgeram & Lefevre|Knoedler and Co. 41161 British, born The Netherlands|French|British 2933 1836 |1819 |1800 1912 |1898 |1900 1873 1873 1873 Engraving on chine collé 36675 Image: 14 3/8 x 33 15/16 in. (36.5 x 86.2 cm) Plate: 19 11/16 × 37 3/8 in. (50 × 95 cm) Sheet: 22 1/8 × 38 1/2 in. (56.2 × 97.8 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1960                       Prints 13   http://www.metmuseum.org/art/collection/search/412654 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
287628 287628 21.36.229 0 0 416942 Drawings and Prints 11 Print 731 Colman's Literary Rooms, Broadway, New York           Artist|Engraver|Publisher|Publisher 1035 After Alexander Jackson Davis|Fenner, Sears & Co.|Isaac Taylor Hinton|Simpkin & Marshall American, New York 1803–1892 West Orange, New Jersey|London|British, Oxford 1799–1847 New Orleans|London   Davis, Alexander Jackson|Fenner, Sears & Co.|Hinton, Isaac Taylor|Simpkin & Marshall 37507 American|British|British 254 1803 |1800 |1799 |1800 1892 |1900 |1847 |1920 1831 1831 1831 Etching and engraving 6712 Image: 4 3/16 x 6 7/16 in. (10.6 x 16.4 cm) Sheet: 8 3/16 x 10 1/2 in. (20.8 x 26.7 cm) Museum Accession, transferred from the Library, 1921                       Prints 13   http://www.metmuseum.org/art/collection/search/416942 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
288709 288709 24.90.1239 0 0 418028 Drawings and Prints 11 Print 731 Colman's Literary Rooms, New York           Artist|Engraver|Publisher|Publisher 1035 After Alexander Jackson Davis|Fenner, Sears & Co.|Isaac Taylor Hinton|Simpkin & Marshall American, New York 1803–1892 West Orange, New Jersey|London|British, Oxford 1799–1847 New Orleans|London   Davis, Alexander Jackson|Fenner, Sears & Co.|Hinton, Isaac Taylor|Simpkin & Marshall 37507 American|British|British 254 1803 |1800 |1799 |1800 1892 |1900 |1847 |1920 1831 1831 1831 Etching and engraving 6712 Image: 4 5/16 x 6 7/8 in. (11 x 17.5 cm) Sheet: 8 x 10 9/16 in. (20.3 x 26.8 cm) Bequest of Charles Allen Munn, 1924                       Prints 13   http://www.metmuseum.org/art/collection/search/418028 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
291255 291255 24.90.1229 0 0 420587 Drawings and Prints 11 Print 731 Columbia College, New York           Artist|Engraver|Publisher|Publisher 1035 After Alexander Jackson Davis|Fenner, Sears & Co.|Isaac Taylor Hinton|Simpkin & Marshall American, New York 1803–1892 West Orange, New Jersey|London|British, Oxford 1799–1847 New Orleans|London   Davis, Alexander Jackson|Fenner, Sears & Co.|Hinton, Isaac Taylor|Simpkin & Marshall 37507 American|British|British 254 1803 |1800 |1799 |1800 1892 |1900 |1847 |1920 1831 1831 1831 Engraving 7208 Image: 4 x 6 1/4 in. (10.2 x 15.9 cm) Plate: 8 1/8 x 10 1/4 in. (20.6 x 26 cm) Bequest of Charles Allen Munn, 1924                       Prints 13   http://www.metmuseum.org/art/collection/search/420587 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
390159 390159 49.40.209 0 1 641120 Drawings and Prints 11 Print 731 The Proscribed Royalist           Artist|Engraver|Publisher|Publisher 1035 After Sir John Everett Millais|William Henry Simmons|E. Gambart & Co.|Henry Graves & Company British, Southampton 1829–1896 London|British, London 1811–1882 London|London|London , and Paris Millais, John Everett, Sir|Simmons, William Henry|Gambart, E. & Co.|Graves, Henry & Company 49767 British|British|British|British 177 1829 |1811 |1800 |1820 1896 |1882 |1899 |1899 January 15, 1858 1858 1858 Mixed method engraving on chine collé 37632 Plate: 29 7/8 × 21 1/8 in. (75.9 × 53.7 cm) Sheet: 31 1/2 × 22 3/4 in. (80 × 57.8 cm) Chine collé: 28 3/4 × 20 1/8 in. (73.1 × 51.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949                       Prints 13   http://www.metmuseum.org/art/collection/search/641120 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
390440 390440 29.102.175 0 0 641457 Drawings and Prints 11 Print 731 Procession of the Flitch of Bacon           Artist|Engraver|Publisher|Publisher 1035 After Thomas Stothard|James Henry Watt|Alaric Alexander Watts|James Henry Watt British, London 1755–1834 London|British, London 1799–1867 London|British, London 1797–1864 London|British, London 1799–1867 London   Stothard, Thomas|Watt, James Henry|Watts, Alaric Alexander|Watt, James Henry 49789 British|British|British|British 177 1755 |1799 |1797 |1799 1834 |1867 |1864 |1867 December 1832 1832 1832 Etching and engraving on chine collé 42750 Plate: 17 1/8 × 34 1/8 in. (43.5 × 86.7 cm) Sheet: 26 5/8 × 39 3/4 in. (67.6 × 101 cm) Gift of Junius S. Morgan, 1929                       Prints 13   http://www.metmuseum.org/art/collection/search/641457 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399221 399221 47.30.24 0 0 653628 Drawings and Prints 11 Print 731 Night           Artist|Engraver|Publisher|Publisher 1035 After Sir Edwin Henry Landseer|Thomas Landseer|Henry Graves & Company|Williams, Stevens, Williams, and Co. British, London 1802–1873 London|British, London 1795–1880 London|London|New York   Landseer, Edwin Henry, Sir|Landseer, Thomas|Graves, Henry & Company|Williams, Stevens, Williams, and Co. 50747 British|British|British|American 881 1802 |1795 |1820 1873 |1880 |1899 August 1, 1855 1855 1855 Etching and engraving on chine collé; proof before letters 58847 Plate: 26 15/16 × 38 3/8 in. (68.5 × 97.4 cm) Harris Brisbane Dick Fund, 1947                       Prints 13   http://www.metmuseum.org/art/collection/search/653628 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399223 399223 47.30.35 0 0 653630 Drawings and Prints 11 Print 731 Deer Family           Artist|Engraver|Publisher|Publisher 1035 After Sir Edwin Henry Landseer|Thomas Landseer|Thomas Agnew & Sons, Ltd.|William Schaus British, London 1802–1873 London|British, London 1795–1880 London|London|American, 1821–1892   Landseer, Edwin Henry, Sir|Landseer, Thomas|Agnew, Thomas & Sons, Ltd.|Schaus, William 50749 British|British|American 756 1802 |1795 |1821 1873 |1880 |1892 January 1, 1873 1873 1873 Etching, engraving and stipple on chine collé 58849 Plate: 32 × 22 7/8 in. (81.3 × 58.1 cm) Harris Brisbane Dick Fund, 1947                       Prints 13   http://www.metmuseum.org/art/collection/search/653630 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399359 399359 47.30.25 0 0 653799 Drawings and Prints 11 Print 731 Morning (The Fatal Struggle)           Artist|Engraver|Publisher|Publisher 1035 After Sir Edwin Henry Landseer|Thomas Landseer|Henry Graves & Company|Williams, Stevens, Williams, and Co. British, London 1802–1873 London|British, London 1795–1880 London|London|New York   Landseer, Edwin Henry, Sir|Landseer, Thomas|Graves, Henry & Company|Williams, Stevens, Williams, and Co. 50747 British|British|British|American 881 1802 |1795 |1820 1873 |1880 |1899 August 1, 1855 1855 1855 Etching, engraving and stipple 42293 Plate: 27 1/8 × 38 3/4 in. (68.9 × 98.5 cm) Harris Brisbane Dick Fund, 1925                       Prints 13   http://www.metmuseum.org/art/collection/search/653799 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399608 399608 47.30.62 0 0 654069 Drawings and Prints 11 Print 731 Low Life           Artist|Engraver|Publisher|Publisher 1035 After Sir Edwin Henry Landseer|Christopher C. Hollyer|Henry Graves & Company|William Schaus British, London 1802–1873 London|British, active ca. 1863–ca. 1873|London|American, 1821–1892   Landseer, Edwin Henry, Sir|Hollyer, Christopher C.|Graves, Henry & Company|Schaus, William 32340 British|British|British|American 881 1802 |1840 |1820 |1821 1873 |1900 |1899 |1892 1870 1870 1870 Mixed method engraving on chine collé 37632 Plate: 22 7/8 × 17 15/16 in. (58.1 × 45.5 cm) Sheet: 27 11/16 × 21 3/4 in. (70.3 × 55.3 cm) Harris Brisbane Dick Fund, 1947                       Portraits 146   http://www.metmuseum.org/art/collection/search/654069 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
399901 399901 47.30.12 0 0 654456 Drawings and Prints 11 Print 731 A Fireside Party           Artist|Engraver|Publisher|Publisher 1035 Published London by Sir Edwin Henry Landseer|Benjamin Phelps Gibbon|Dominic Colnaghi|Henry Leggatt & Co. British, London 1802–1873 London|British, Penally, Wales 1802–1851 London|London   Landseer, Edwin Henry, Sir|Gibbon, Benjamin Phelps|Colnaghi Dominic|Leggatt, Henry & Co. 18492 British|British, Welsh|British 880 1802 |1802 |1775 1873 |1851 |1864 April 16, 1832 1832 1832 Etching and engraving 6712 Plate: 14 7/8 × 16 5/8 in. (37.8 × 42.2 cm) Sheet: 16 1/8 × 18 1/16 in. (41 × 45.8 cm) Harris Brisbane Dick Fund, 1947                       Prints 13   http://www.metmuseum.org/art/collection/search/654456 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
400965 400965 47.30.59 0 0 655808 Drawings and Prints 11 Print 731 The Twins           Artist|Engraver|Publisher|Publisher 1035 After Sir Edwin Henry Landseer|Thomas Landseer|Henry Graves & Company|Williams, Stevens & Williams British, London 1802–1873 London|British, London 1795–1880 London|London|New York   Landseer, Edwin Henry, Sir|Landseer, Thomas|Graves, Henry & Company|Williams, Stevens & Williams 50954 British|British|British|American 881 1802 |1795 |1820 1873 |1880 |1899 September 25, 1855 1855 1855 Mixed method engraving 38289 Sheet: 31 in. × 25 1/2 in. (78.7 × 64.8 cm) Harris Brisbane Dick Fund, 1947                       Prints 13   http://www.metmuseum.org/art/collection/search/655808 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
401030 401030 47.30.22 0 0 655898 Drawings and Prints 11 Print 731 The Mountain Torrent           Artist|Engraver|Publisher|Publisher 1035 After Sir Edwin Henry Landseer|Thomas Landseer|Henry Graves & Company|Williams, Stevens, Williams, and Co. British, London 1802–1873 London|British, London 1795–1880 London|London|New York   Landseer, Edwin Henry, Sir|Landseer, Thomas|Graves, Henry & Company|Williams, Stevens, Williams, and Co. 50747 British|British|British|American 881 1802 |1795 |1820 1873 |1880 |1899 1836 1836 1836 Mixed media engraving on chine collé 58982 Plate: 23 13/16 × 29 5/16 in. (60.5 × 74.5 cm) Sheet: 27 15/16 × 35 1/16 in. (71 × 89 cm) Harris Brisbane Dick Fund, 1947                       Prints 13   http://www.metmuseum.org/art/collection/search/655898 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
408433 408433 49.40.123 0 0 668350 Drawings and Prints 11 Print 731 Invited Out           Artist|Engraver|Publisher|Publisher 1035 After Joseph H. Barnes|Joseph Bishop Pratt|Leggatt Brothers|Fishl, Adler & Co. British, active 1867–87|British, 1854–1910|London|New York, NY , and Washington DC Barnes, Joseph H.|Pratt, Joseph Bishop|Leggatt Brothers|Fishl, Adler & Co. 51528 British|British|British|American 881 1867 |1854 |1800 1887 |1910 |1900 1881 1881 1881 Mixed-media engraving and mezzotint on chine collé 59378 Image: 16 1/16 × 10 5/8 in. (40.8 × 27 cm) Plate: 20 5/16 × 13 15/16 in. (51.6 × 35.4 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1949                       Prints 13   http://www.metmuseum.org/art/collection/search/668350 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
408550 408550 48.163.3 0 0 668715 Drawings and Prints 11 Print 731 Miss Bulkley           Artist|Engraver|Publisher|Publisher 1035 After|Probably published by Richard Cosway|Abel Jamas|Moglia & Cie.|Henry Graves & Company British, Oakford, Devon 1742–1821 London|French, born 1862–active to 1941|Paris|London   Cosway, Richard|Jamas, Abel|Moglia & Cie.|Graves, Henry & Company 51555 British|French|French Italian|British 3751 1742 |1862 |1900 |1820 1821 |1941 |1920 |1899 1911 1911 1911 Etching on vellum 59387 Sheet: 13 7/8 × 11 5/8 in. (35.2 × 29.6 cm) Bequest of George D. Pratt, 1935                       Prints 13   http://www.metmuseum.org/art/collection/search/668715 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
411240 411240 14.1.30 0 0 677805 Drawings and Prints 11 Print 731 The First of September, Evening           Artist|Engraver|Publisher|Publisher 1035 After George Morland|William Ward|Thomas Simpson|Darling & Thompson British, London 1763–1804 London|British, London 1766–1826 London|British, active London, ca. 1765–1801|London   Morland, George|Ward, William|Simpson, Thomas|Darling & Thompson 51889 British|British|British|British 177 1763 |1766 |1700 |1750 1804 |1826 |1850 |1800 September 1, 1796 1796 1796 Mezzotint, hand-colored 35216 Sheet (clipped to plate): 18 3/16 in. × 23 in. (46.2 × 58.3 cm) Bequest of Frederick Townsend Martin, 1914                       Prints 13   http://www.metmuseum.org/art/collection/search/677805 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 138.004ms · Data license: CC0 · Data source: metmuseum/openaccess