Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Object Name, Title, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
322301 | 322301 | 1975.1.1426 | 0 | 1 | 460459 | Robert Lehman Collection 16 | Censer 3914 | Censer with elephant-shaped handles | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 1644–1911 | 1644 | 1911 | Bronze with treated surface. 48330 | Diameter: 11.4 cm. | Robert Lehman Collection, 1975 | Metalwork-Bronze 325 | http://www.metmuseum.org/art/collection/search/460459 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322302 | 322302 | 1975.1.1427 | 0 | 1 | 460460 | Robert Lehman Collection 16 | Censer 3914 | Censer | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | ca. 18th century | 1697 | 1803 | Bronze with treated surface. 48330 | Diameter: 13 cm. | Robert Lehman Collection, 1975 | Metalwork-Bronze 325 | http://www.metmuseum.org/art/collection/search/460460 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322398 | 322398 | 1975.1.1428 | 0 | 1 | 460557 | Robert Lehman Collection 16 | Censer 3914 | Censer | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 19th to early 20th century | 1800 | 1935 | Bronze. 48387 | Height (with handle): 35 cm. | Robert Lehman Collection, 1975 | Metalwork-Bronze 325 | http://www.metmuseum.org/art/collection/search/460557 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322416 | 322416 | 1975.1.1689 | 0 | 1 | 460575 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 19th century | 1798 | 1902 | Porcelain with dark red glaze. 48402 | Height: 3 1/2 in. (8.9 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460575 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322510 | 322510 | 1975.1.1744 | 0 | 1 | 460674 | Robert Lehman Collection 16 | Water coupe 4453 | Water coupe | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 18th century | 1700 | 1799 | Porcelain painted in underglaze blue. 48452 | Height: 2 7/16 in. (6.2 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460674 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322511 | 322511 | 1975.1.1742 | 0 | 1 | 460675 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 18th century | 1700 | 1799 | Porcelain painted in underglaze blue. 48452 | Height: 4 3/4 in. (12 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460675 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322512 | 322512 | 1975.1.1725 | 0 | 1 | 460676 | Robert Lehman Collection 16 | Vase 7 | Small bottle-shaped vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 18th century | 1698 | 1802 | Porcelain painted in underglaze blue. 48452 | Height: 4 7/8 in. (12.3 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460676 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322513 | 322513 | 1975.1.1736 | 0 | 1 | 460677 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | ca. late 18th century | 1766 | 1803 | Porcelain painted in underglaze blue. 48452 | Height: 5 1/2 in. (14 cm. ) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460677 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322514 | 322514 | 1975.1.1726 | 0 | 1 | 460678 | Robert Lehman Collection 16 | Covered vase 4305 | Small covered vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | ca. late 18th century | 1766 | 1803 | "Soft-paste" porcelain painted in underglaze blue. 48455 | Height with lid: 6 3/4 in. (17.1 cm. ) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460678 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322515 | 322515 | 1975.1.1738 | 0 | 1 | 460679 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 19th century | 1800 | 1900 | "Soft-paste" porcelain painted in underglaze blue 48456 | Height: 5 5/16 in. (13.5 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460679 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322523 | 322523 | 1975.1.1724 a,b | 0 | 1 | 460687 | Robert Lehman Collection 16 | Teapot and saucer 14564 | Teapot (a) and saucer (b) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | ca. 1740 (teapot); late 18th century (saucer) | 1737 | 1800 | Porcelain with full relief decoration, painted in overglaze enamels. 48460 | Height of pot: 8.2 cm. Diameter of saucer: 15 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460687 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322525 | 322525 | 1975.1.1690 | 0 | 1 | 460689 | Robert Lehman Collection 16 | Pot 726 | Water pot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain with incised decoration under peach-bloom glaze. 48461 | Height: 3 9/16 in. (9 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460689 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322526 | 322526 | 1975.1.1662 | 0 | 1 | 460690 | Robert Lehman Collection 16 | Dish 110 | Large dish | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 19th century | 1800 | 1900 | Porcelain with dark red glaze. 48402 | Diameter: 15 3/4 in (40 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460690 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322527 | 322527 | 1975.1.1680 | 0 | 1 | 460691 | Robert Lehman Collection 16 | Bowl 106 | Bowl | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 18th century | 1700 | 1800 | Porcelain with Sang de Boeuf glaze. 48462 | Diameter: 6 3/8 in. (16.2 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460691 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322528 | 322528 | 1975.1.1681 | 0 | 1 | 460692 | Robert Lehman Collection 16 | Bowl 106 | Bowl | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 18th century | 1700 | 1800 | Porcelain with Sang de Boeuf glaze. 48462 | Diameter: 8 1/4 in. (21 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460692 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322622 | 322622 | 1975.1.1932 | 0 | 1 | 460786 | Robert Lehman Collection 16 | Fabric 14572 | Panel (see also 1975.1.1933) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | late 19th to early 20th century | 1871 | 1935 | Red silk. 48527 | Height: 264.4 cm. Width: 160.4 cm. repeat: 14.3 cm. x 19.7 cm.; loomed width: 80.7 cm. | Robert Lehman Collection, 1975 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/460786 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322648 | 322648 | 1975.1.1425 | 0 | 1 | 460812 | Robert Lehman Collection 16 | Censer 3914 | Censer | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 19th century | 1800 | 1900 | Brass. 48542 | H. 19 cm. Diameter: 32.7 cm. | Robert Lehman Collection, 1975 1975.1.1425 | Metalwork-Bronze 325 | http://www.metmuseum.org/art/collection/search/460812 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322669 | 322669 | 1975.1.1933 | 0 | 1 | 460834 | Robert Lehman Collection 16 | Fabric 14572 | Panel (see also 1975.1.1932) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | late 19th–early 20th century | 1871 | 1935 | Red silk. 48527 | Height: 287.7 cm. Width: 161 cm. repeat: 14.3 cm. x 19.7 cm.; loomed width: 80.7 cm. | Robert Lehman Collection, 1975 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/460834 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322707 | 322707 | 1975.1.1722 | 0 | 1 | 460874 | Robert Lehman Collection 16 | Winepot or teapot 14532 | Peach-shaped wine pot or tea pot (pair with 1975.1.1721) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 18th century | 1698 | 1802 | Porcelain with relief decoration under polychrome glazes. 48119 | Height: 14 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460874 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
322760 | 322760 | 1975.1.1729 | 0 | 1 | 460927 | Robert Lehman Collection 16 | Lion 4077 | Figure of lion mounted as lamp | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 19th century | 1798 | 1902 | Porcelain with colored glazes. 48614 | Height: 10 3/4 in. (27.3 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/460927 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323037 | 323037 | 1975.1.1668 | 0 | 1 | 461210 | Robert Lehman Collection 16 | Vase 7 | Quatrefoil vase, Jun ware | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | possibly 18th century | 1695 | 1795 | Stoneware with slightly flushed blue glaze 48727 | Height: 9 7/8 in (25cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461210 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323046 | 323046 | 1975.1.1679 | 0 | 1 | 461219 | Robert Lehman Collection 16 | Tazza 891 | Tazza | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 1662–1722 | 1662 | 1722 | Porcelain painted in overglaze famille verte enamels. 48730 | Diam.: 18.4 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461219 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323047 | 323047 | 1975.1.1700 | 0 | 1 | 461220 | Robert Lehman Collection 16 | Winepot or teapot 14532 | Peach-shaped wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 18th century | 1698 | 1802 | Porcelain with relief decoration under polychrome glazes. 48119 | Height: 5 1/2 in. (14cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461220 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323049 | 323049 | 1975.1.1692 | 0 | 1 | 461222 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 18th century | 1700 | 1800 | Porcelain with Sang de Boeuf glaze. 48462 | Height: 4 1/4 in. (10.8 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461222 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323051 | 323051 | 1975.1.1684 | 0 | 1 | 461224 | Robert Lehman Collection 16 | Vase 7 | Vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 19th century | 1798 | 1902 | Porcelaneous stoneware with apple-green glaze. 48731 | Height: 4 3/4 in. (12 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461224 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323077 | 323077 | 1975.1.1935 | 0 | 1 | 461250 | Robert Lehman Collection 16 | Fabric 14572 | Fabric | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 18th–19th century | 1700 | 1900 | Silk 165 | Height: 114.2 cm. Width: 248 cm. repeat height: 37.5 cm. repeat width: 24.1 cm. loomed width: 73.3 cm. | Robert Lehman Collection, 1975 | Textiles-Woven 191 | http://www.metmuseum.org/art/collection/search/461250 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323091 | 323091 | 1975.1.1707 | 0 | 1 | 461264 | Robert Lehman Collection 16 | Teapot or winepot 14596 | Hexagonal teapot or winepot (pair with 1975.1.1706) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | late 18th century | 1771 | 1800 | Porcelain with reticulated ornamentation, painted in overglaze famille rose enamels. 48757 | Height with lid 4 15/16 in. (12.7 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461264 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323158 | 323158 | 1975.1.1697 | 0 | 1 | 461336 | Robert Lehman Collection 16 | Cup 107 | Small stemcup | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | ca. second half of the 17th century | 1647 | 1703 | "Soft-paste" porcelain painted in underglaze blue. 48455 | Height: 3 3/4 in. (9.5 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461336 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323160 | 323160 | 1975.1.1677 | 0 | 1 | 461338 | Robert Lehman Collection 16 | Covered ewer 4788 | Covered ewer | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 19th century | 1798 | 1902 | Porcelain painted in overglaze polychrome enamels. 48790 | Height with lid: 6 1/16 in (15.4 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461338 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323161 | 323161 | 1975.1.1688 | 0 | 1 | 461339 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 19th century | 1798 | 1902 | Porcelain with dark red glaze. 48402 | Height 3 1/2 in. (8.9 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461339 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323317 | 323317 | 1975.1.1691 | 0 | 1 | 461497 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably late 18th century | 1769 | 1805 | Porcelain painted in underglaze blue. 48452 | Height: 13.5 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461497 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323319 | 323319 | 1975.1.1706 | 0 | 1 | 461499 | Robert Lehman Collection 16 | Teapot or winepot 14596 | Hexagonal wine pot or teapot | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | late 18th century | 1771 | 1800 | Porcelain with reticulated ornamentation, painted in overglaze famille rose enamels. 48757 | Height with lid 4 15/16 in. (12.7 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461499 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323320 | 323320 | 1975.1.1687 | 0 | 1 | 461500 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | 18th century | 1700 | 1800 | Porcelain with peach-bloom-type glaze. 48843 | Height: 4 5/16 in. (11 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461500 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323321 | 323321 | 1975.1.1723 | 0 | 1 | 461501 | Robert Lehman Collection 16 | Vase 7 | Small vase | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 19th century | 1798 | 1902 | Porcelain with dark red glaze. 48402 | Height: 3 5/8 in. (9.2 cm.) | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461501 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
323347 | 323347 | 1975.1.1721 | 0 | 1 | 461528 | Robert Lehman Collection 16 | Winepot or teapot 14532 | Peach-shaped wine pot or teapot (pair with 1975.1.1722) | Chinese 10 | Artist 2 | Chinese | , Qing Dynasty | Chinese 44503 | probably 18th century | 1698 | 1802 | Porcelain with relief decoration under aubergine glazes. 48856 | Height: 14 cm. | Robert Lehman Collection, 1975 | Ceramics 5 | http://www.metmuseum.org/art/collection/search/461528 | 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");