Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Object Name, Title, Object Date, Object End Date, Medium, Dimensions
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
322501 | 322501 | 1975.1.1746 | 0 | 1 | 460665 | Robert Lehman Collection 16 | Ewer 227 | Small ewer | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height: 4 7/16 in. (11.2 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460665 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322503 | 322503 | 1975.1.1710 | 0 | 1 | 460667 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height with lid: 3 7/16 in. (8.7 cm.) to 3 1/2 in. (8.8 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460667 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322504 | 322504 | 1975.1.1709 | 0 | 1 | 460668 | Robert Lehman Collection 16 | Winepot and teapot with lid 14563 | Small wine pot or teapot with a lid | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height without lid: 2 1/4 in. (5.7 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460668 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322505 | 322505 | 1975.1.1713 | 0 | 1 | 460669 | Robert Lehman Collection 16 | Winepot or teapot 14532 | Small wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height: 2 1/8 in. (5.4 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460669 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322506 | 322506 | 1975.1.1733 | 0 | 1 | 460670 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | "Soft-paste" type porcelain painted in underglaze blue. 48454 | Height with lid: 2 9/16 in. (6.5 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460670 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322507 | 322507 | 1975.1.1698 | 0 | 1 | 460671 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height to top of handle: 4 5/16 in. (11 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460671 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322508 | 322508 | 1975.1.1718 | 0 | 1 | 460672 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | H. with lid: 7 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460672 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322518 | 322518 | 1975.1.1735 | 0 | 1 | 460682 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue and overglaze famille verte enamels. 48458 | Height with lid: 2 1/2 in. (6.3 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460682 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322519 | 322519 | 1975.1.1708 | 0 | 1 | 460683 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in overglaze famille verte enamels and gilt. 48459 | Height: 6 3/4 in. (17.2 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460683 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322520 | 322520 | 1975.1.1734 | 0 | 1 | 460684 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in overglaze famille verte enamels and gilt. 48459 | Height: 17.5 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460684 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322551 | 322551 | 1975.1.1694 | 0 | 1 | 460715 | Robert Lehman Collection 16 | Ewer 227 | Ewer | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with "powder-blue" glaze, painted in overglaze gilt. 48474 | Height: 6 3/4 in. (17.3 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460715 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322552 | 322552 | 1975.1.1695 | 0 | 1 | 460716 | Robert Lehman Collection 16 | Ewer 227 | Ewer | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with mirror-black glaze, painted in overglaze gilt. 48475 | Height: 6 1/2 in. (16.5 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460716 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322708 | 322708 | 1975.1.1705 | 0 | 1 | 460875 | Robert Lehman Collection 16 | Covered teapot or wine pot 14578 | Covered teapot or wine pot (pair with 1975.1.1704) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with "powder-blue" glaze, painted in overglaze gilt. 48474 | Height: 5 7/8 in. (15cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460875 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322733 | 322733 | 1975.1.1683 | 0 | 1 | 460900 | Robert Lehman Collection 16 | Vase 7 | Amphora vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with peach-bloom glaze. 48603 | Height: 6 1/8 in. (15.6 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460900 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322762 | 322762 | 1975.1.1711 | 0 | 1 | 460930 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered winepot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height with lid: 3 7/16 in. (8.7 cm.) to 3 1/2 in. (8.8 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460930 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322763 | 322763 | 1975.1.1712 | 0 | 1 | 460931 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered winepot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height with lid: 3 7/16 in. (8.7 cm.) to 3 1/2 in. (8.8 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460931 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322764 | 322764 | 1975.1.1716 | 0 | 1 | 460932 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered winepot or teapot (similar to 1975.1.1714-15 and 1975.1.1717) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1772 | 1662 | 1772 | "Soft-paste" porcelain painted in underglaze blue 48456 | Height with lid: 2 3/4 in ( 7cm.) to 3 1/2 in (8.8 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460932 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323040 | 323040 | 1975.1.1701 | 0 | 1 | 461213 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | H. with lid: 10.2 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461213 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323041 | 323041 | 1975.1.1730 | 0 | 1 | 461214 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height with lid: 3 5/8 in. (9.2 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461214 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323042 | 323042 | 1975.1.1731 | 0 | 1 | 461215 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height with lid: 3 3/4 in. (8.5 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461215 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323043 | 323043 | 1975.1.1732 | 0 | 1 | 461216 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | "Soft-paste" type porcelain painted in underglaze blue. 48454 | Height with lid: 6.5 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461216 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323044 | 323044 | 1975.1.1714 | 0 | 1 | 461217 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | "Soft-paste" porcelain painted in underglaze blue 48456 | Height with lid: 2 3/4 in ( 7cm.) to 3 1/2 in (8.8 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461217 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323048 | 323048 | 1975.1.1720 | 0 | 1 | 461221 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in overglaze famille verte enamels and gilt 10277 | Height: 7 1/4 in. (18.3 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461221 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323050 | 323050 | 1975.1.1696 | 0 | 1 | 461223 | Robert Lehman Collection 16 | Pot 726 | Water pot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with incised decoration under peach-bloom glaze. 48461 | Height: 3 in. (7.6 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461223 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323052 | 323052 | 1975.1.1704 | 0 | 1 | 461225 | Robert Lehman Collection 16 | Covered teapot or winepot 14592 | Covered teapot or wine pot (pair with 1975.1.1705) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with "powder-blue" glaze, painted in overglaze gilt. 48474 | Height: 5 7/8 in. (15 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461225 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323090 | 323090 | 1975.1.1703 | 0 | 1 | 461263 | Robert Lehman Collection 16 | Covered teapot or winepot 14592 | Covered teapot or winepot (pair with 1975.1.1702) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with mirror black-glazes, painted in overglaze gilt. 48756 | Height with lid: 4 in. (10.2 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461263 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323099 | 323099 | 1975.1.1702 | 0 | 1 | 461272 | Robert Lehman Collection 16 | Covered teapot or winepot 14592 | covered teapot or wine pot (pair with 1975.1.1703) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with mirror-black glazes, painted in overglaze gilt. 48763 | Height with lid: 4 in. (10.2 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461272 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323102 | 323102 | 1975.1.1715 | 0 | 1 | 461277 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered winepot or teapot (similar to 1975.1.1714, and 1975.1.16-17) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1772 | 1662 | 1772 | "Soft-paste" porcelain painted in underglaze blue 48456 | Height with lid: 2 3/4 in ( 7cm.) to 3 1/2 in (8.8 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461277 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323103 | 323103 | 1975.1.1717 | 0 | 1 | 461278 | Robert Lehman Collection 16 | Covered winepot or teapot 14562 | Small covered winepot or teapot (similar to 1975.1.1714-16) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1772 | 1662 | 1772 | "Soft-paste" porcelain painted in underglaze blue 48456 | Height with lid: 2 3/4 in ( 7cm.) to 3 1/2 in (8.8 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461278 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323315 | 323315 | 1975.1.1743 | 0 | 1 | 461495 | Robert Lehman Collection 16 | Cup 107 | Bird-cage cup | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height: 2 in. (5 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461495 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323316 | 323316 | 1975.1.1685 | 0 | 1 | 461496 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty, Kangxi period | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in underglaze blue. 48452 | Height: 13 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461496 | 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");