Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Artist Role, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
112318 | 112318 | 49.7.116 | 0 | 1 | 200594 | European Sculpture and Decorative Arts 3 | Table 477 | Table | French, Paris and Sèvres 3089 | Maker|Factory|Decorator|Decorator|Decorator|Decorator 488 | Porcelain plaques by|Decorated by|Decorated by|Decorated by|Decorated by | Jean-François Leleu|Sèvres Manufactory|Jean-Jacques Pierre the Younger|Guillaume Noël|Drand|Jacques Fontaine | 1729–1807, master 1764|French, 1740–present|French, active 1763–1800|French, active 1755–1807|French, born 1735 | LELEU JEAN-FRANÇOIS|Sèvres Manufactory|Pierre, Jean-Jacques jeune|Noël, Guillaume|DRAND|Fontaine Jacques 10597 | French|French 21 | 1729 |1740 |1763 |1755 |1700 |1735 | 1807 |9999 |1800 |1807 |1850 |1835 | ca. 1780–90 | 1775 | 1795 | Tulipwood, Sèvres porcelain, gilt bronze, leather, silk moiré 22507 | Overall: 30 3/4 × 70 1/2 × 34 3/4 in. (78.1 × 179.1 × 88.3 cm) | The Jules Bache Collection, 1949 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/200594 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113824 | 113824 | 58.75.40 | 0 | 1 | 202148 | European Sculpture and Decorative Arts 3 | Cabinet 149 | Cabinet | French, Paris and Sèvres 3089 | Factory|Decorator|Decorator|Decorator|Decorator 526 | Porcelain plaques by|Plaques decorated by|Plaques probably decorated by|Plaques possibly decorated by | Sèvres Manufactory|Guillaume Noël|Louis-Jean Thévenet (père)|Dominique Joffroy|Unidentified | French, 1740–present|French, active 1755–1807|French, 1707–after 1778, active 1741–78|French, active 1753–70 | Sèvres Manufactory|Noël, Guillaume|Thévenet, Louis-Jean|Joffroy, Dominique|Unidentified 10845 | French|French 21 | 1740 |1755 |1707 |1753 | 9999 |1807 |1783 |1770 | plaques 1761–65, cabinet ca. 1822 | 1761 | 1827 | Oak, tulipwood, gilt bronze, soft-paste porcelain, marble, mirror glass 22681 | Overall: 39 1/4 × 73 1/8 × 14 5/8 in. (99.7 × 185.7 × 37.1 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202148 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113825 | 113825 | 58.75.41 | 0 | 1 | 202149 | European Sculpture and Decorative Arts 3 | Jewel coffer on stand 8134 | Jewel coffer on stand (petit coffre à bijoux) | French, Paris and Sèvres 3089 | Decorator|Maker|Factory|Decorator 527 | One plaque decorated by|Coffer attributed to|Porcelain plaques by|Eight plaques decorated by | Michel-Gabriel Commelin|Martin Carlin|Sèvres Manufactory|Jean-Jacques Pierre the Younger | French, 1746–1802|French, near Freiburg im Breisgau ca. 1730–1785 Paris|French, 1740–present|French, active 1763–1800 | Commelin, Michel-Gabriel|Carlin, Martin|Sèvres Manufactory|Pierre, Jean-Jacques jeune 10846 | French|French 21 | 1746 |1725 |1740 |1763 | 1802 |1785 |9999 |1800 | ca. 1770 | 1765 | 1775 | Oak veneered with tulipwood, amaranth, stained sycamore, holly, and ebonized holly; thirteen soft-paste porcelain plaques; gilt-bronze mounts; velvet (not original) 22682 | 37 1/2 x 21 3/4 x 14 1/2 in. (95.3 x 55.2 x 36.8cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202149 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113826 | 113826 | 58.75.42 | 0 | 1 | 202150 | European Sculpture and Decorative Arts 3 | Jewel coffer on stand 8134 | Jewel coffer on stand (petit coffre à bijoux) | French, Paris and Sèvres 3089 | Maker|Factory|Decorator 424 | Coffer attributed to|Porcelain plaques by|Plaque decoration attributed to | Martin Carlin|Sèvres Manufactory|Michel-Gabriel Commelin | French, near Freiburg im Breisgau ca. 1730–1785 Paris|French, 1740–present|French, 1746–1802 | Carlin, Martin|Sèvres Manufactory|Commelin, Michel-Gabriel 10847 | French|French 21 | 1725 |1740 |1746 | 1785 |9999 |1802 | ca. 1775 | 1770 | 1800 | Oak veneered with tulipwood, sycamore, holly, and ebonized holly; thirteen soft-paste porcelain plaques; gilt-bronze mounts; velvet (not original) 22683 | 37 1/2 × 21 3/4 × 14 1/2 in. (95.3 × 55.2 × 36.8 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202150 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113828 | 113828 | 58.75.44 | 0 | 1 | 202152 | European Sculpture and Decorative Arts 3 | Desk 89 | Drop-front desk (secrétaire à abattant or secrétaire en cabinet) | French, Paris and Sèvres 3089 | Maker|Factory|Decorator|Decorator|Decorator|Decorator 488 | Porcelain plaques by|Oval front plaques decorated by|Six plaques decorated by|Oval side plaques decorated by|Two plaques decorated by | Martin Carlin|Sèvres Manufactory|Nicolas Bulidon|Guillaume Noël|Marie-Claude Sophie Xhrouuet|Jacques-François Micaud | French, near Freiburg im Breisgau ca. 1730–1785 Paris|French, 1740–present|French, active 1763–92|French, active 1755–1807|active 1775–88|French, active 1757–1810 | Carlin, Martin|Sèvres Manufactory|Bulidon, Nicolas|Noël, Guillaume|Xhrouuet Marie-Claude Sophie|Micaud, Jacques-François 10848 | French|French 21 | 1725 |1740 |1763 |1755 |1775 |1757 | 1785 |9999 |1792 |1807 |1788 |1810 | ca. 1773 | 1768 | 1778 | Oak veneered with tulipwood, amaranth, holly, and ebonized holly; ten soft-paste porcelain plaques; gilt-bronze mounts; marble; velvet (not original) 22685 | Overall: 47 × 31 3/4 × 16 3/8 in. (119.4 × 80.6 × 41.6 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202152 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113829 | 113829 | 58.75.45 | 0 | 1 | 202153 | European Sculpture and Decorative Arts 3 | Table 477 | Eating and work table (one of a pair) | French, Paris and Sèvres 3089 | Maker|Factory|Maker 528 | Table attributed to|Plaques by|or possibly | Bernard II van Risenburgh|Sèvres Manufactory|Bernard III van Risamburgh | ca. 1696–ca. 1767|French, 1740–present|ca. 1731–1800 | Risenburgh, Bernard II van|Sèvres Manufactory|Risamburgh Bernard III van 10849 | French 2 | 1696 |1740 |1731 | 1767 |9999 |1800 | ca. 1758–65 | 1753 | 1770 | Oak, vernis Martin, soft-paste porcelain, gilt bronze 22686 | Overall: 27 × 14 1/2 × 12 in. (68.6 × 36.8 × 30.5 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202153 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113831 | 113831 | 58.75.47 | 0 | 1 | 202155 | European Sculpture and Decorative Arts 3 | Desk 89 | Desk | French, Paris and Sèvres 3089 | Maker|Factory|Decorator 424 | Porcelain plaques by|Decoration of plaques attributed to | Joseph Baumhauer|Sèvres Manufactory|Jean-Jacques Pierre the Younger | French, active ca. 1749–72|French, 1740–present|French, active 1763–1800 | Baumhauer, Joseph|Sèvres Manufactory|Pierre, Jean-Jacques jeune 10851 | French|French 21 | 1749 |1740 |1763 | 1772 |9999 |1800 | ca. 1770 | 1765 | 1775 | Oak, tulipwood, gilt bronze, soft-paste porcelain, leather, silk 22688 | 29 3/4 × 34 1/2 × 20 1/2 in. (75.6 × 87.6 × 52.1 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202155 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113833 | 113833 | 58.75.51 | 0 | 1 | 202157 | European Sculpture and Decorative Arts 3 | Cabinet 149 | Cabinet | French, Paris and Sèvres 3089 | Maker|Factory|Decorator|Maker|Maker 530 | Porcelain plaques by|Plaques painted by|Plaques gilded by|and | Martin Carlin|Sèvres Manufactory|Jean-Baptiste Tandart|Jean-Pierre Boulanger|Cyprien-Julien Hirel de Choisy | French, near Freiburg im Breisgau ca. 1730–1785 Paris|French, 1740–present|French, active 1754–1800|1722–1785, active 1754–85|French, active 1770–1812 | Carlin, Martin|Sèvres Manufactory|Tandart, Jean-Baptiste|Boulanger (Boulanger père) Jean-Pierre|Choisy, Cyprien-Julien Hirel de 10853 | French|French 21 | 1725 |1740 |1754 |1722 |1770 | 1785 |9999 |1800 |1785 |1812 | ca. 1775–80 | 1770 | 1785 | Oak veneered with tulipwood and amaranth, holly, and ebonized holly; gilt bronze, soft-paste porcelain, marble, mirror glass, silk 22690 | Overall" 36 1/2 × 13 1/8 × 13 3/4 in. (92.7 × 33.3 × 34.9 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202157 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113834 | 113834 | 58.75.52 | 0 | 1 | 202158 | European Sculpture and Decorative Arts 3 | Desk 89 | Drop-front desk (secrétaire à abattant or secrétaire en cabinet) | French, Paris and Sèvres 3089 | Factory|Maker 400 | Porcelain plaques by|Attributed to | Sèvres Manufactory|Roger Vandercruse, called Lacroix | French, 1740–present|French, 1727–1799 | Sèvres Manufactory|Vandercruse Roger called Lacroix 10854 | French|French 21 | 1740 |1727 | 9999 |1799 | porcelain ca. 1764, secretary ca. 1775 | 1759 | 1780 | Oak veneered with satin-wood, green and black-stained wood; gilt bronze, marble, soft-paste porcelain, silk 22691 | Overall: 50 1/2 × 33 5/8 × 14 in. (128.3 × 85.4 × 35.6 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202158 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113838 | 113838 | 58.75.56 | 0 | 1 | 202162 | European Sculpture and Decorative Arts 3 | Writing and eating table 8135 | Writing and eating table | French, Paris and Sèvres 3089 | Maker|Factory|Decorator 424 | Porcelain plaques by|Plaque possibly decorated by | Martin Carlin|Sèvres Manufactory|François Bouilliat | French, near Freiburg im Breisgau ca. 1730–1785 Paris|French, 1740–present|active 1785–93 | Carlin, Martin|Sèvres Manufactory|Bouilliat François 10857 | French|French 21 | 1725 |1740 |1785 | 1785 |9999 |1793 | ca. 1780 | 1775 | 1785 | Oak veneered with tulipwood, gilt bronze, soft-paste porcelain, marble 22695 | Overall: 29 1/4 × 13 1/2 × 10 1/4 in. (74.3 × 34.3 × 26 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202162 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
113839 | 113839 | 58.75.57 | 0 | 0 | 202163 | European Sculpture and Decorative Arts 3 | Desk 89 | Drop-front desk (secrétaire à abattant or secrétaire en cabinet) | French, Paris and Sèvres 3089 | Maker|Manufactory|Decorator|Maker|Factory|Decorator 531 | Attributed to|Porcelain plaques made by|Porcelain plaques decorated by|Some mounts by|Jasperware medallions by|Porcelain plaques decorated by | Adam Weisweiler|Sèvres Manufactory|Edme François Bouillat père|Pierre Rémond|Josiah Wedgwood and Sons|Geneviève Taillandier | French, 1744–1820|French, 1740–present|French,1739/40–1810, active 1758–1800|French, Paris 1747–1812 Paris|1759–present|active 1774–98 | Weisweiler, Adam|Sèvres Manufactory|Bouillat père, Edme François|Rémond, Pierre|Wedgwood and Sons, Josiah|Taillandier Geneviève 10858 | French|French|French 103 | 1744 |1740 |1739 |1747 |1759 |1774 | 1820 |9999 |1810 |1812 |9999 |1798 | ca. 1787 | 1782 | 1792 | Oak veneered with burl thuya, amaranth, mahogany, satinwood, holly, and ebonized holly; painted metal; one soft-paste porcelain plaque; fifteen jasper medallions; gilt-bronze mounts; marble; leather (not original) 22696 | Overall: 51 × 27 × 16 in. (129.5 × 68.6 × 40.6 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/202163 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117582 | 117582 | 1976.155.104 | 0 | 1 | 206494 | European Sculpture and Decorative Arts 3 | Worktable 985 | Circular worktable | French, Paris and Sèvres 3089 | Maker|Factory 359 | Plaques by | Martin Carlin|Sèvres Manufactory | French, near Freiburg im Breisgau ca. 1730–1785 Paris|French, 1740–present | Carlin, Martin|Sèvres Manufactory 11525 | French|French 21 | 1725 |1740 | 1785 |9999 | ca. 1772 | 1767 | 1777 | Oak veneered with tulipwood, ebony, and holly; soft-paste porcelain; gilt bronze 23360 | H. 27-1/4 in. (69.2 cm); Diam. of top 14-1/2 in. (36.8 cm) | Gift of Mr. and Mrs. Charles Wrightsman, 1976 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/206494 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117586 | 117586 | 1976.155.110 | 1 | 1 | 206499 | European Sculpture and Decorative Arts 3 | Desk 89 | Drop-front desk (secrétaire à abattant or secrétaire en cabinet) | French, Paris and Sèvres 3089 | Maker|Decorator|Factory 578 | Attributed to|Central plaque decorated by | Martin Carlin|Edme François Bouillat père|Sèvres Manufactory | French, near Freiburg im Breisgau ca. 1730–1785 Paris|French,1739/40–1810, active 1758–1800|French, 1740–present | Carlin, Martin|Bouillat père, Edme François|Sèvres Manufactory 11527 | French|French|French 103 | 1725 |1739 |1740 | 1785 |1810 |9999 | ca. 1776 | 1771 | 1781 | Oak veneered with tulipwood, amaranth, holly, and sycamore; six Sèvres soft-paste porcelain plaques and two painted tin plaques; gilt-bronze mounts; marble shelves; moiré silk 23364 | 43 3/8 x 40 1/2 x 12 7/8 in. (110.1 x 102.9 x 32.7cm) | Gift of Mr. and Mrs. Charles Wrightsman, 1976 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/206499 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
117978 | 117978 | 1982.60.55 | 0 | 1 | 206970 | European Sculpture and Decorative Arts 3 | Desk 89 | Desk (bonheur du jour) | French, Paris and Sèvres 3089 | Maker|Factory|Decorator|Decorator 592 | Porcelain plaques by|Plaques decorated by|and | Martin Carlin|Sèvres Manufactory|Antoine-Toussaint Cornailles|Nicquet | French, near Freiburg im Breisgau ca. 1730–1785 Paris|French, 1740–present|French, active 1755–1800|French, active 1764–92 | Carlin, Martin|Sèvres Manufactory|Cornailles, Antoine-Toussaint|Nicquet 11600 | French|French|French 103 | 1725 |1740 |1755 |1764 | 1785 |9999 |1800 |1792 | ca. 1770 | 1765 | 1775 | Oak, mahogany, tulipwood, sycamore, ebony, box and harewood, gilt-bronze mounts, soft-paste porcelain 23473 | Overall: 32 1/4 × 26 1/4 × 15 3/4 in. (81.9 × 66.7 × 40 cm) | The Jack and Belle Linsky Collection, 1982 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/206970 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
139276 | 139276 | 58.75.48 | 0 | 1 | 231856 | European Sculpture and Decorative Arts 3 | Desk 89 | Small writing desk (bonheur-du-jour) | French, Paris and Sèvres 3089 | Factory|Decorator|Maker 449 | Porcelain plaques by|Decorated by | Sèvres Manufactory|Denis Levé|Martin Carlin | French, 1740–present|French, active 1754–93, 1795–1805|French, near Freiburg im Breisgau ca. 1730–1785 Paris | Sèvres Manufactory|Levé, Denis|Carlin, Martin 12667 | French|French 21 | 1740 |1754 |1725 | 9999 |1805 |1785 | ca. 1768 | 1763 | 1773 | Oak veneered with tulipwood, amaranth, and stained sycamore; mahogany; seventeen soft-paste porcelain plaques; gilt-bronze mounts; velvet (not original) 25321 | Overall: 32 1/2 × 25 7/8 × 16 in. (82.6 × 65.7 × 40.6 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/231856 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
139277 | 139277 | 58.75.49 | 0 | 1 | 231857 | European Sculpture and Decorative Arts 3 | Desk 89 | Small writing desk (bonheur-du-jour) | French, Paris and Sèvres 3089 | Factory|Maker|Decorator 532 | Porcelain plaques by | Sèvres Manufactory|Martin Carlin|Jean-Jacques Pierre the Younger | French, 1740–present|French, near Freiburg im Breisgau ca. 1730–1785 Paris|French, active 1763–1800 | Sèvres Manufactory|Carlin, Martin|Pierre, Jean-Jacques jeune 12668 | French|French 21 | 1740 |1725 |1763 | 9999 |1785 |1800 | ca. 1774 | 1769 | 1779 | Oak veneered with tulipwood, amaranth, and stained sycamore; mahogany; seventeen soft-paste porcelain plaques; gilt-bronze mounts; velvet (not original) 25321 | Overall: 32 1/2 × 25 7/8 × 16 in. (82.6 × 65.7 × 40.6 cm) | Gift of Samuel H. Kress Foundation, 1958 | Woodwork-Furniture 321 | http://www.metmuseum.org/art/collection/search/231857 | 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");