Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Credit Line, River, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
190475 | 190475 | 67.249.2 | 0 | 1 | 309525 | Arts of Africa, Oceania, and the Americas 10 | Jar 116 | Cactus Jar | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 7 15/16 x W.10 15/16 in. (20.2 x 27.8 cm) | Purchase, The J.M. Kaplan Fund, Inc., Gift, 1967 | Comala 726 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/309525 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
190792 | 190792 | 1978.412.9 | 0 | 1 | 309860 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Figure Vessel | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H x W x D: 9 1/8 x 6 1/4 x 6 5/8 in. (23.2 x 15.9 x 16.9 cm) | The Michael C. Rockefeller Memorial Collection, Gift of Nelson A. Rockefeller, 1963 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/309860 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
191383 | 191383 | 1978.412.21 | 0 | 1 | 310477 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Prisoner Vessel | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H x W x D: 21 x 10 5/8 x 16 1/8in. (53.3 x 27 x 40.9cm) | The Michael C. Rockefeller Memorial Collection, Gift of Nelson A. Rockefeller, 1963 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/310477 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
191385 | 191385 | 1978.412.23 | 0 | 1 | 310479 | Arts of Africa, Oceania, and the Americas 10 | Figure 9 | Seated Hunchback | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H x W x D: 9 5/8 x 7 x 6 5/8in. (24.4 x 17.8 x 16.9cm) | The Michael C. Rockefeller Memorial Collection, Gift of Nelson A. Rockefeller, 1963 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/310479 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
191556 | 191556 | 1978.412.213 | 0 | 1 | 310658 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Crayfish Vessel | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H x W x D: 4 3/4 x 6 1/8 x 13 1/2 in. (12.1 x 15.5 x 34.3 cm) | The Michael C. Rockefeller Memorial Collection, Purchase, Nelson A. Rockefeller Gift, 1968 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/310658 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
192990 | 192990 | 1979.205.5 | 0 | 1 | 312160 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Shell Vessel | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | Length 10-1/4 in. | Gift of Arthur M. Bullowa, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/312160 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193367 | 193367 | 1979.206.349 | 0 | 1 | 312571 | Arts of Africa, Oceania, and the Americas 10 | Jar 116 | Jar | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 6 7/16 x Diam. 13 3/8 in. (16.4 x 34 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/312571 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193368 | 193368 | 1979.206.350 | 0 | 1 | 312572 | Arts of Africa, Oceania, and the Americas 10 | Jar 116 | Tripod Jar | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 9 1/16 x Diam. 13 3/4 in. (23.1 x 34.9 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/312572 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193468 | 193468 | 1979.206.478 | 0 | 1 | 312688 | Arts of Africa, Oceania, and the Americas 10 | Male figure 13132 | Horned Figure, Shaman (?) | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 13 5/8 x W. 11 x D. 6 1/2 in. (34.6 x 27.9 x 16.5 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/312688 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193469 | 193469 | 1979.206.481 | 0 | 1 | 312691 | Arts of Africa, Oceania, and the Americas 10 | Male figure 13132 | Warrior Figure | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 11 x W. 10 1/2 x D. 7 5/16 in. (27.9 x 26.7 x 18.6 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/312691 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193899 | 193899 | 1979.206.957 | 0 | 1 | 313155 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Animal Vessel | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 5 15/16 x W. 8 1/8 x D. 11 3/8 in. (15 x 20.6 x 29 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/313155 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193900 | 193900 | 1979.206.958 | 0 | 1 | 313156 | Arts of Africa, Oceania, and the Americas 10 | Jar 116 | Jar with Cut Maguey Leaves | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 6 15/16 x Diam. 10 1/2 in. (17.7 x 26.7 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/313156 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193940 | 193940 | 1979.206.999 | 0 | 1 | 313196 | Arts of Africa, Oceania, and the Americas 10 | Female figure 11801 | Female Figure | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 4 15/16 in. (12.6 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/313196 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193942 | 193942 | 1979.206.1001 | 0 | 1 | 313198 | Arts of Africa, Oceania, and the Americas 10 | Female figure 11801 | Female Figure | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 6 7/8 in. (17.5 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/313198 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193955 | 193955 | 1979.206.1017 | 0 | 1 | 313214 | Arts of Africa, Oceania, and the Americas 10 | Female figure 11801 | Female Figure | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 2 3/4 x W. 2 x D. 1 5/8 in. (7 x 5.1 x 4.1 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/313214 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
193992 | 193992 | 1979.206.1060 | 0 | 1 | 313253 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Acrobat Vessel | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H. 9 1/4 x W. 11 x D. 10 5/8 in. (23.5 x 27.9 x 27 cm) | The Michael C. Rockefeller Memorial Collection, Bequest of Nelson A. Rockefeller, 1979 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/313253 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
195293 | 195293 | 1983.497.12 | 0 | 1 | 314629 | Arts of Africa, Oceania, and the Americas 10 | Jar 116 | Jar | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | Height 7-1/2 in. (19.1 cm) Diameter: 14 1/2 in (36.8 cm) | Gift of Arthur M. Bullowa, 1983 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/314629 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
195294 | 195294 | 1983.497.13 | 0 | 1 | 314630 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Cylinder Vessel | Colima 4453 | 2nd–3rd century | 100 | 300 | Ceramic 161 | Height 7 in. Diameter: 8 in. | Gift of Arthur M. Bullowa, 1983 | Colima 381 | Mexico 1 | Mesoamerica 34 | Rio Verde region 156 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/314630 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
195448 | 195448 | 1984.359 | 0 | 1 | 314784 | Arts of Africa, Oceania, and the Americas 10 | Figures 4033 | Ring of Figures | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | H x W: 4 1/4 x 5in. (10.8 x 12.7cm) | Gift of Carol R. Meyer, 1984 | Colima 381 | Mexico 1 | Mesoamerica 34 | Rio Verde region 156 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/314784 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
197283 | 197283 | 1991.362.1 | 0 | 1 | 316644 | Arts of Africa, Oceania, and the Americas 10 | Figure 9 | Male Figure | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | Height 4-7/8 in. | Gift of Carol R. Meyer, 1991 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/316644 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
198237 | 198237 | 1995.63.5 | 0 | 1 | 317600 | Arts of Africa, Oceania, and the Americas 10 | Temple model 5789 | Temple Model | Colima 4453 | 200 B.C.–A.D. 200 | -200 | 200 | Ceramic 161 | H. 7 1/8 in. | From the Collection of Nina and Gordon Bunshaft, Bequest of Nina Bunshaft, 1994 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/317600 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
198900 | 198900 | X.2.431 | 0 | 1 | 318295 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Hunchback Vessel | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -200 | 300 | Ceramic 161 | Height 11 in. | Museum Accession | Colima 381 | Mexico 1 | Mesoamerica 34 | Rio Verde 221 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/318295 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||||
199028 | 199028 | 2014.244.6 | 0 | 1 | 318467 | Arts of Africa, Oceania, and the Americas 10 | Figure 9 | Ring of Figures | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -199 | 300 | Ceramic 161 | H. 6 1/8 x Diam. 8 1/2 in. (15.6 x 21.6 cm) | Gift of Albert J. Grant and Monique Grant Joint Revocable Trust, 2014 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/318467 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
199337 | 199337 | 2005.91.6 | 0 | 1 | 318962 | Arts of Africa, Oceania, and the Americas 10 | Male figure 13132 | Figure with Incense Burner | Colima 4453 | 2nd century B.C.–A.D. 3rd century | -75 | 325 | Ceramic 161 | H. 19 1/4 in. (48.9 cm) | Gift of The Andrall and Joanne Pearson Collection, 2005 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/318962 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
199338 | 199338 | 2005.91.4 | 0 | 1 | 318963 | Arts of Africa, Oceania, and the Americas 10 | Duck figure 13553 | Duck | Comala 5467 | 2nd century B.C.–A.D. 3rd century | -75 | 325 | Ceramic 161 | H. 11 x L. 12 3/8 in. (27.9 x 31.4 cm) | Gift of The Andrall and Joanne Pearson Collection, 2005 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/318963 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
199339 | 199339 | 2007.345.1 | 0 | 1 | 318964 | Arts of Africa, Oceania, and the Americas 10 | Dog figure 13554 | Reclining Dog | Colima 4453 | 200 B.C.–A.D. 300 | -175 | 325 | Ceramic 161 | H. 10 3/4 x W. 14 5/8 in. (27.3 x 37.1 cm) | Gift of Joanne P. Pearson, in memory of Andrall E. Pearson, 2007 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/318964 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
199364 | 199364 | 2007.345.3 | 0 | 1 | 318997 | Arts of Africa, Oceania, and the Americas 10 | Male figure 13132 | Seated Figure with Vessel | Colima 4453 | 200 B.C.–A.D. 300 | -175 | 325 | Ceramic 161 | H. 19 1/8 x W. 13 in. (48.6 x 33 cm) | Gift of Joanne P. Pearson, in memory of Andrall E. Pearson, 2007 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/318997 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
199365 | 199365 | 2007.345.4 | 0 | 1 | 318999 | Arts of Africa, Oceania, and the Americas 10 | Dog figure 13554 | Snarling Dog | Colima 4453 | 200 B.C.–A.D. 300 | -175 | 325 | Ceramic 161 | H. 15 1/2 x L. 16 1/4 in. (39.4 x 41.3 cm) | Gift of Joanne P. Pearson, in memory of Andrall E. Pearson, 2007 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/318999 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
199418 | 199418 | 2007.345.5 | 0 | 1 | 319065 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Turtle Vessel | Colima 4453 | 200 B.C.–A.D. 300 | -175 | 325 | Ceramic 161 | H. 7 3/4 x L. 13 5/8 in. (19.7 x 34.6 cm) | Gift of Joanne P. Pearson, in memory of Andrall E. Pearson, 2007 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/319065 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
199419 | 199419 | 2007.345.6 | 0 | 1 | 319066 | Arts of Africa, Oceania, and the Americas 10 | Vessel 3894 | Crayfish Vessel | Colima 4453 | 200 B.C.–A.D. 300 | -175 | 325 | Ceramic 161 | H. 6-3/4 x L. 12-3/8 in. (17.1 x 32.4) | Gift of Joanne P. Pearson, in memory of Andrall E. Pearson, 2007 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Containers 483 | http://www.metmuseum.org/art/collection/search/319066 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||||||
199679 | 199679 | 2007.345.7 | 0 | 1 | 319467 | Arts of Africa, Oceania, and the Americas 10 | Male figure 13132 | Standard Bearer (?) | Colima 4453 | 200 B.C.–A.D. 300 | -175 | 325 | Ceramic 161 | H.15 3/8 x W. 8 3/8 in. (39.1 x 21.3 cm) | Gift of Joanne P. Pearson, in memory of Andrall E. Pearson, 2007 | Colima 381 | Mexico 1 | Mesoamerica 34 | Ceramics-Sculpture 490 | http://www.metmuseum.org/art/collection/search/319467 | 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");