Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Artist End Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
109635 | 109635 | 35.100 | 0 | 1 | 197727 | European Sculpture and Decorative Arts 3 | Panel 399 | "Verdures du Vatican" | French, Lyons 2685 | Designer|Manufacturer 3 | Designer: | Jean Démosthène Dugourc|Maison Pernon | French, Versailles 1749–1825 Paris | Dugourc, Jean Démosthène|Pernon Maison 9931 | French 2 | 1749 | 1825 | ca. 1790 | 1785 | 1795 | Silk 165 | Overall: 94 x 17 3/4 in. (238.8 x 45.1 cm) Framed: 93 1/2 x 19 x 2 1/8 in. (237.5 x 48.3 x 5.4 cm) | Rogers Fund, 1935 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/197727 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
110488 | 110488 | 40.134.21 | 0 | 1 | 198667 | European Sculpture and Decorative Arts 3 | Length 992 | Length | French, Lyons 2685 | Manufactory|Patron 458 | Woven by|Comissioned by | Séguin et Cie|Napoléon Bonaparte | French, Ajaccio 1769–1821 St. Helena | Séguin et Cie|Bonaparte, Napoléon 10123 | French 2 | 1769 | 1821 | ca. 1805–15 | 1800 | 1820 | Silk and two types of metal thread 22230 | L. 70 x W. 24 inches (177.8 x 61.0 cm) | Rogers Fund, 1940 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/198667 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
110528 | 110528 | 41.78 | 0 | 1 | 198713 | European Sculpture and Decorative Arts 3 | Portrait 2537 | Catherine II of Russia | French, Lyons 2685 | Designer 5 | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | ca. 1771 | 1766 | 1776 | Woven and embroidered silk 22233 | Overall, loom width: H. 40 x W. 29 1/2in. (101.6 x 74.9cm); Framed: H. 45 x W. 33 1/2 in. (114.3 x 85.1 cm) | Rogers Fund, 1941 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/198713 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
111164 | 111164 | 43.134 | 0 | 1 | 199388 | European Sculpture and Decorative Arts 3 | Banner 1326 | Saint Peter as Pope | French, Paris 114 | Manufactory|Maker 432 | Probably woven under the direction of | Savonnerie Manufactory|Bertrand François Dupont | Manufactory, established 1626; Manufacture Royale, established 1663|French, active 1687–1720 | Savonnerie Manufactory|Dupont, Bertrand François 10244 | French 2 | 1626 |1687 | 2050 |1720 | 1689 | 1689 | 1689 | Wool (169-95 knots per sq. inch, 25-30 per sq. cm.) 22315 | H. 58 x W. 56 inches (147.3 x 142.2 cm); With frame: H. 65 x W. 61 inches (215.9 x 154.9 cm) | Rogers Fund, 1943 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/199388 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
123338 | 123338 | 07.225.284 | 0 | 1 | 213248 | European Sculpture and Decorative Arts 3 | Screen panel 4670 | Hawk and three pheasants | French, Paris 114 | Manufactory|Designer 484 | Probably after a design by | Savonnerie Manufactory|Alexandre François Desportes | Manufactory, established 1626; Manufacture Royale, established 1663|French, Champigneulle 1661–1743 Paris | Savonnerie Manufactory|Desportes, Alexandre François 12308 | French 2 | 1626 |1661 | 2050 |1743 | 1719–72 | 1719 | 1772 | Wool (108 knots per sq. inch, 17 per sq. cm.) 24411 | H. 73 x W. 27 inches (185.4 x 68.6 cm) | Gift of J. Pierpont Morgan, 1906 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/213248 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
130495 | 130495 | 26.127 | 0 | 1 | 221795 | European Sculpture and Decorative Arts 3 | Border 1032 | Border | French, Lyons 2685 | Designer|Manufacturer 3 | Philippe de Lasalle|Maison Pernon | French, 1723–1804 | Lasalle, Philippe de|Pernon Maison 12375 | French 2 | 1723 | 1804 | late 18th century | 1785 | 1799 | Silk 165 | L. 31 x W. 8 3/4 inches 78.7 x 22.2 cm | Gift of Herman A. Elsberg, 1926 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/221795 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
131514 | 131514 | 33.119 | 0 | 1 | 222971 | European Sculpture and Decorative Arts 3 | Upholstery fragments 8930 | Woven silk upholstery for a chair | French, Lyons 2685 | Designer|Manufacturer 3 | Philippe de Lasalle|Maison Pernon | French, 1723–1804 | Lasalle, Philippe de|Pernon Maison 12375 | French 2 | 1723 | 1804 | ca. 1770 | 1765 | 1775 | Silk 165 | L. 50 x W. 30 1/2 inches (127.0 x 77.5 cm) (loom width) | Rogers Fund, 1933 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/222971 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
131518 | 131518 | 33.140 | 0 | 1 | 222975 | European Sculpture and Decorative Arts 3 | Panel 399 | L'Autel | French, Lyons 2685 | Designer|Manufacturer 3 | Jean Démosthène Dugourc|Maison Pernon | French, Versailles 1749–1825 Paris | Dugourc, Jean Démosthène|Pernon Maison 9931 | French 2 | 1749 | 1825 | late 18th century | 1785 | 1799 | Silk 165 | L. 96 x W. 22 inches (loom width) 243.8 x 55.9 cm | Purchase, Joseph Pulitzer Bequest, 1933 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/222975 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
131521 | 131521 | 33.148.1 | 0 | 1 | 222978 | European Sculpture and Decorative Arts 3 | Piece 1049 | Piece | French 7 | Maker 1 | Style of | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | 1780–90 | 1780 | 1790 | Silk 165 | H. 21 3/4 x W. 23 3/8 inches 55.2 x 59.4 cm | Gift of H.A. Elsberg, 1933 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/222978 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
131606 | 131606 | 35.99.4 | 0 | 1 | 223066 | European Sculpture and Decorative Arts 3 | Piece 1049 | Piece | French 7 | Designer 5 | Possibly after a painting by | Jean Pillement | French, Lyons 1728–1808 Lyons | Pillement, Jean 1682 | French 2 | 1728 | 1808 | second half 18th century | 1750 | 1799 | Silk and metal thread 11395 | H. 8 3/4 x W. 11 inches (22.2 x 27.9 cm) | Rogers Fund, 1935 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/223066 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
134860 | 134860 | 38.169a | 0 | 1 | 226341 | European Sculpture and Decorative Arts 3 | Upholstery panel 7212 | Part of a chair cover | French, Lyons 2685 | Designer 5 | Jean Démosthène Dugourc | French, Versailles 1749–1825 Paris | Dugourc, Jean Démosthène 12439 | French 2 | 1749 | 1825 | ca. 1797 | 1792 | 1802 | Silk 165 | L. 19 1/2 x W. 18 inches 49.5 x 45.7 cm | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226341 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
134861 | 134861 | 38.169b | 0 | 1 | 226342 | European Sculpture and Decorative Arts 3 | Upholstery panel 7212 | Part of a chair cover | French, Lyons 2685 | Designer 5 | Jean Démosthène Dugourc | French, Versailles 1749–1825 Paris | Dugourc, Jean Démosthène 12439 | French 2 | 1749 | 1825 | ca. 1797 | 1792 | 1802 | Silk, brocaded 24847 | L. 19 1/4 x 22 inches 48.9 x 55.9 cm | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226342 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
134862 | 134862 | 38.169c–f | 0 | 1 | 226343 | European Sculpture and Decorative Arts 3 | Upholstery panel 7212 | Part of a chair cover | French, Lyons 2685 | Designer 5 | Jean Démosthène Dugourc | French, Versailles 1749–1825 Paris | Dugourc, Jean Démosthène 12439 | French 2 | 1749 | 1825 | ca. 1797 | 1792 | 1802 | Silk 165 | c) L. 16 1/4 x W. 14 1/2 inches 41.3 x 36.8 cm d) L. 35 1/4 inches 89.5 cm e) L. 19 3/4 inches 50.2 cm f) L. 17 inches 43.2 inches | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226343 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
134863 | 134863 | 38.170 | 0 | 1 | 226344 | European Sculpture and Decorative Arts 3 | Picture 8273 | Picture | French, Lyons 2685 | Manufactory|Designer|Maker 640 | Woven by | Didier, Petit et Cie|Claude Bonnefond|Michel-Marie Carquillat | French, Lyons 1796–1860 Lyons|French, 1803–1884 | , probably | Didier, Petit et Cie|Bonnefond, Claude|Carquillat, Michel-Marie 12440 | French 2 | 1796 |1803 | 1860 |1884 | 1844 | 1844 | 1844 | Silk 165 | Framed dimensions H. 41 1/4 x W. 35 inches (104.8 x 88.9 cm) H. 39 x W. 32 1/2 inches (99.1 x 82.6 cm) | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226344 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
134868 | 134868 | 38.182.5 | 0 | 1 | 226349 | European Sculpture and Decorative Arts 3 | Upholstery panel 7212 | Chair back | French, Lyons 2685 | Designer|Manufacturer 3 | Philippe de Lasalle|Maison Pernon | French, 1723–1804 | Lasalle, Philippe de|Pernon Maison 12375 | French 2 | 1723 | 1804 | ca. 1770 | 1765 | 1775 | Silk 165 | L. 28 1/2 x W. 22 inches 72.4 x 55.9 cm Framed dim.: 36 x 36 inches 91.4 x 91.4 cm | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226349 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
134869 | 134869 | 38.182.6 | 0 | 1 | 226350 | European Sculpture and Decorative Arts 3 | Upholstery panel 7212 | Length of upholstery silk | French, Lyons 2685 | Designer 5 | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | 1771–72 | 1771 | 1772 | Silk 165 | L. 32 x W. 22 inches (loom width) 81.3 x 55.9 cm | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226350 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
134870 | 134870 | 38.182.7 | 0 | 1 | 226351 | European Sculpture and Decorative Arts 3 | Upholstery panel 7212 | Length of upholstery silk | French, Lyons 2685 | Designer|Manufacturer 3 | Philippe de Lasalle|Maison Pernon | French, 1723–1804 | Lasalle, Philippe de|Pernon Maison 12375 | French 2 | 1723 | 1804 | ca. 1770 | 1765 | 1775 | Silk 165 | L. 34 1/4 x W. 22 inches 87.0 x 55.9 cm | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226351 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
134878 | 134878 | 38.182.16 | 0 | 1 | 226359 | European Sculpture and Decorative Arts 3 | Piece 1049 | Panel of upholstery silk | French, Lyons 2685 | Designer 5 | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | ca. 1770 | 1765 | 1775 | Silk 165 | L. 21 1/2 x W. 16 inches (54.6 x 40.6 cm) | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226359 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
134892 | 134892 | 38.182.31 | 0 | 1 | 226373 | European Sculpture and Decorative Arts 3 | Fragment 486 | Fragment of woven silk | French, Lyons 2685 | Designer 5 | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | 1760–65 | 1760 | 1765 | Silk 165 | L. 24 x W. 15 inches (61.0 x 38.1 cm) | Rogers Fund, 1938 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/226373 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
135677 | 135677 | 50.8a | 0 | 1 | 227482 | European Sculpture and Decorative Arts 3 | Upholstery textile 8960 | "Les Perdrix" (The Partridges) | French, Lyons 2685 | Designer 5 | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | 1771–72 | 1771 | 1772 | Silk 165 | L. 82 x W. 31 inches (208.3 x 78.7 cm) | Rogers Fund, 1950 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/227482 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
135678 | 135678 | 50.8b | 0 | 1 | 227483 | European Sculpture and Decorative Arts 3 | Piece 1049 | Border of woven silk | French, Lyons 2685 | Designer 5 | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | 1770–80 | 1770 | 1780 | Silk 165 | L. 126 x W. 16 1/2 inches (320 x 41.9 cm) | Rogers Fund, 1950 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/227483 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
136837 | 136837 | 58.75.128 | 0 | 1 | 228723 | European Sculpture and Decorative Arts 3 | Screen panels 8980 | Trophies and birds | French, Paris 114 | Manufactory|Designer|Designer 542 | Probably after a design by|Possibly after a design by | Savonnerie Manufactory|Jean Baptiste Blain (or Blin) de Fontenay|Alexandre François Desportes | Manufactory, established 1626; Manufacture Royale, established 1663|1653–1715|French, Champigneulle 1661–1743 Paris | Savonnerie Manufactory|Blain de Fontenay Jean Baptiste|Desportes, Alexandre François 12529 | French 2 | 1626 |1653 |1661 | 2050 |1715 |1743 | 1715–50 | 1715 | 1750 | Wool (120 knots per sq. inch, 19 per sq. cm.) 25078 | Each panel: H. 108 x W. 26 inches (274.3 x 66 cm) | Gift of Samuel H. Kress Foundation, 1958 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/228723 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
137675 | 137675 | 1978.82 | 0 | 1 | 229571 | European Sculpture and Decorative Arts 3 | Length 992 | Length of upholstery silk | French, Lyons 2685 | Designer 5 | After a design by | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | 1760–1765 | 1760 | 1765 | Silk 165 | L. 55 3/4 x W. 27 5/8 inches (141.6 x 70.2 cm) | Rogers and Director's Discretionary Funds, 1978 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/229571 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
140331 | 140331 | 2012.544 | 0 | 0 | 239012 | European Sculpture and Decorative Arts 3 | Length 992 | Length | French 7 | Designer 5 | Philippe de Lasalle | French, 1723–1804 | Lasalle, Philippe de 10137 | French 2 | 1723 | 1804 | 1760–65 | 1760 | 1765 | Silk, brocaded lampas with twill foundation weave 25532 | Overall: 55 x 27 in. (139.7 x 68.6 cm) | Gift of C. and H. Boehringer, 2012 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/239012 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
339618 | 339618 | 23.175.10 | 0 | 1 | 487301 | Modern and Contemporary Art 4 | Textile sample 15073 | MAI | Designer 5 | André Mare | French, Argentan 1887–1932 Paris | Mare, André 46451 | French 2 | 1887 | 1932 | ca. 1920 | 1920 | 1920 | Silk and cotton 2238 | L. 49-1/2, W. 50-1/2 in. (125.7 x 128.3 cm) | Purchase, Edward C. Moore Jr. Gift, 1923 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/487301 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
339619 | 339619 | 23.175.11 | 0 | 1 | 487302 | Modern and Contemporary Art 4 | Upholstery sample 15266 | Rose Mousse | Designer 5 | André Mare | French, Argentan 1887–1932 Paris | Mare, André 46451 | French 2 | 1887 | 1932 | 1900 | 1923 | Silk and cotton 2238 | H. 50-1/2, W. 51 in. (128.3 x 129.5 cm) | Purchase, Edward C. Moore Jr. Gift, 1923 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/487302 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||
339624 | 339624 | 23.175.7 | 0 | 0 | 487307 | Modern and Contemporary Art 4 | Sample 1077 | "Bouquets" Textile | Designer 5 | Louis Süe | French, Bordeaux 1875–1968 Paris | Süe, Louis 46456 | French 2 | 1875 | 1968 | ca. 1919 | 1914 | 1924 | Silk 165 | 21 × 26 in. (53.3 × 66 cm) | Purchase, Edward C. Moore Jr. Gift, 1923 | Textiles-Woven 191 | © 2018 Artists Rights Society (ARS), New York | http://www.metmuseum.org/art/collection/search/487307 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
339625 | 339625 | 23.175.8 | 0 | 0 | 487308 | Modern and Contemporary Art 4 | Sample 1077 | "Paris" Textile | Designer 5 | Louis Süe | French, Bordeaux 1875–1968 Paris | Süe, Louis 46456 | French 2 | 1875 | 1968 | ca. 1919 | 1914 | 1924 | Silk 165 | H. 91-1/4, W. 51-1/2 inches (231.8 x 130.8 cm.) | Purchase, Edward C. Moore Jr. Gift, 1923 | Textiles-Woven 191 | © 2018 Artists Rights Society (ARS), New York | http://www.metmuseum.org/art/collection/search/487308 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
339626 | 339626 | 23.175.9 | 0 | 1 | 487309 | Modern and Contemporary Art 4 | Sample 1077 | "Abundance" Textile | Designer 5 | André Mare | French, Argentan 1887–1932 Paris | Mare, André 46451 | French 2 | 1887 | 1932 | Designed ca. 1911; manufactured after 1918 | 1911 | 1911 | Silk 165 | Length 100 1/2 in. (255.3 cm), width 49 3/4 in. (126.4 cm) | Purchase, Edward C. Moore Jr. Gift, 1923 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/487309 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
341642 | 341642 | 68.145.5 | 0 | 0 | 489699 | Modern and Contemporary Art 4 | Textile 1143 | Pomone | Manufacturer|Designer 18 | Atelier d'Art du Bon Marché|Renée Schils | ATELIER D'ART|Schils, Renée 47018 | French 2 | 1925 | 1925 | 1925 | Rayon and cotton 52760 | 50 × 20 1/2 in. (127 × 52.1 cm) | Rogers Fund, 1968 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/489699 | 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");