MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

44 rows where Medium = 473

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Department, Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Credit Line, Country, 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
1793 1793 23.111.1 0 1 1949 American Decorative Arts 1 Chandelier 207 Chandelier                             1670–1700 1670 1700 Iron, wood 473 H. 21 1/4 in. (54 cm) Rogers Fund, 1923                       Metal 1   http://www.metmuseum.org/art/collection/search/1949 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
1794 1794 23.111.2 0 1 1950 American Decorative Arts 1 Chandelier 207 Chandelier                             1770–1800 1770 1800 Iron, wood 473 H. 21 1/4 in. (54 cm) Rogers Fund, 1923                       Metal 1   http://www.metmuseum.org/art/collection/search/1950 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
2071 2071 53.205 0 1 2247 American Decorative Arts 1 Jack 264 Conestoga Wagon Jack American 1                           1784 1784 1784 Iron, wood 473 H. 34 1/2 in. (87.6 cm) Rogers Fund, 1953 Made in 1       United States 3             Metal 1   http://www.metmuseum.org/art/collection/search/2247 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
4457 4457 24.58.2a, b 0 1 4803 American Decorative Arts 1 Lock and key 586 Lock and Key                             1700–1730 1700 1730 Iron, wood 473 9 x 6 3/4 in. (22.9 x 17.1 cm) Gift of General William Barclay Parsons, 1924                       Metal 1   http://www.metmuseum.org/art/collection/search/4803 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
4458 4458 24.58.3a, b 0 1 4804 American Decorative Arts 1 Lock and key 586 Lock and Key                             1700–1730 1700 1730 Iron, wood 473 8 1/2 x 5 1/8 in. (21.6 x 13 cm) Gift of General William Barclay Parsons, 1924                       Metal 1   http://www.metmuseum.org/art/collection/search/4804 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
4459 4459 24.58.4a, b 0 1 4805 American Decorative Arts 1 Lock and key 586 Lock and Key                             1725–50 1725 1750 Iron, wood 473 9 x 5 1/8 in. (22.9 x 13 cm) Gift of General William Barclay Parsons, 1924                       Metal 1   http://www.metmuseum.org/art/collection/search/4805 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17980 17980 14.100.102 0 0 22493 Arms and Armor 5 Model gun 1581 Model Miniature Gun (Netsuke) Japanese 35                           18th century 1700 1799 Iron, wood 473 L. 2 1/16 in. (5.23 cm) Gift of Bashford Dean, 1914                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/22493 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18243 18243 21.140.1 0 0 22763 Arms and Armor 5 Chisel 1700 Chisel Japanese 35                           19th century 1801 1900 Iron, wood 473 L. 17 1/8 in. (43.5 cm); W 3 3/4 in. (9.53 cm) Received from George C. Stone, 1921, in exchange for 17.215.3                       Miscellaneous 64   http://www.metmuseum.org/art/collection/search/22763 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18244 18244 21.140.2 0 0 22764 Arms and Armor 5 Hammer 1701 Hammer Japanese 35                           19th century 1801 1900 Iron, wood 473 L. 12 1/2 in. (31.8 cm); W. 5 1/4 in. (13.3 cm) Received from George C. Stone, 1921, in exchange for 17.215.3                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/22764 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18507 18507 28.60.7 0 0 23029 Arms and Armor 5 Priest's Axe 1798 Non Military Axe Carried by Priest's in Mountainous Districts Japanese 35                           17th century 1601 1700 Iron, wood 473 L. 44 1/2 in. (113.0 cm) W. 9 1/2 in. (24.1 cm) Fletcher Fund, 1928                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/23029 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19894 19894 36.25.1837 0 0 24419 Arms and Armor 5 Pick 2119 Pick Japanese 35                           ca. 1615–1868 1590 1900 Iron, wood 473 L. Handle 23 7/8 (60.6) L. Blade 4 in (5.1 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/24419 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20061 20061 36.25.3000 0 0 24586 Arms and Armor 5 Morning star 1986 Morning Star Sleeve Tangler Japanese 35                           ca. 1615–1868 1590 1900 Iron, wood 473 L. 78 in. (198.1 cm) Bequest of George C. Stone, 1935                       Miscellaneous 64   http://www.metmuseum.org/art/collection/search/24586 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
21892 21892 14.25.319 0 1 26732 Arms and Armor 5 Staff weapon 2337 Staff Weapon Italian 36                           ca. 1600 1575 1625 Iron, wood 473 L. 8 ft. 8 1/4 in. (264.8 cm); L. of head 30 7/8 in. (78.4); W. 7 in. (17.8 cm); Wt. 3 lbs. 10 oz. (1640 g) Gift of William H. Riggs, 1913                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/26732 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22312 22312 1984.104.1 0 0 27205 Arms and Armor 5 Spear 1453 Spear African, Congo 558                           19th century 1801 1900 Iron, wood 473 L. 62 in. (157.5 cm); L. of head 20 3/4 in. (52.7 cm); W. 2 3/4 in. (7 cm); Wt. 2 lbs. 12.7 oz. (1267.2 g) Gift of Marc O. Rabun, 1984                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/27205 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22315 22315 1984.104.4 0 0 27208 Arms and Armor 5 Knife 141 Sickle African, Mangbetu 561                           19th century 1801 1900 Iron, wood 473 H. 17 1/2 in. (44.5 cm); W. 3 3/16 in. (8.1 cm); Wt. 1 lb. 14.8 oz. (873.2 g) Gift of Marc O. Rabun, 1984                       Knives 49   http://www.metmuseum.org/art/collection/search/27208 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22888 22888 48.84.10 0 1 27863 Arms and Armor 5 Halberd 1309 Halberd American 1                           18th century 1701 1800 Iron, wood 473 L. 89 1/2 in. (227.3 cm); L. of head 16 1/4 in. (41.3 cm); W. 9 9/16 in. (24.3 cm); Wt. 3 lbs. (1360.8 g) Rogers Fund, 1948                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/27863 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25418 25418 36.25.2119 0 0 30570 Arms and Armor 5 Combination axe and hand cannon 3054 Combination Axe and Hand Cannon Indian 67                           17th–19th century 1601 1900 Iron, wood 473 L. overall 26 5/8 in. (67.6 cm); L muzzle-breach plug 9 5/8 in. (24.4 cm); L. muzzle-rear wall 14 3/4 in. (37.5 cm); Bore 12.8 cm; Wt. 1492 g Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30570 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25651 25651 36.25.1819 0 0 30803 Arms and Armor 5 Axe 2349 Axe Indian, Orissa 857                           18th–19th century 1701 1900 Iron, wood 473 L. 20 1/2 in. (52.1 cm); L. of head 9 1/4 in. (23.5 cm); W. 8 5/8 in. (21.9 cm); Wt. 1 lb. 13 oz. (822.1 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30803 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25710 25710 36.25.1889 0 0 30862 Arms and Armor 5 Mace 1328 Mace Chinese 10                           18th–19th century 1701 1900 Iron, wood 473 L. 17 1/2 in. (44.45 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30862 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25711 25711 36.25.1890 0 0 30863 Arms and Armor 5 Mace 1328 Mace Chinese 10                           18th–19th century 1701 1900 Iron, wood 473 L. 17 3/4 in. (45.1 cm); W. 2 in. (5.1 cm); Wt. 1 lb. 6 oz. (623.7 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30863 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
26097 26097 36.25.1228a, b 0 0 31249 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Javanese 758                           16th–19th century 1501 1900 Iron, wood 473 L. with sheath 13 1/4 in. (33.7 cm); L. without sheath 12 1/4 in. (31.1 cm); L. of blade 10 in. (25.4 cm); W. 2 in. (5.1 cm); Wt. 3.1 oz. (87.9 g); Wt. of sheath 2 oz. (56.7 g) Bequest of George C. Stone, 1935       Jawa 262               Krisses 34   http://www.metmuseum.org/art/collection/search/31249 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
27101 27101 32.75.260 0 1 32256 Arms and Armor 5 Sword 379 Sword (Falcata) Iberian 1056                           5th to 1st century B.C. and later 0 0 Iron, wood 473 H. 20 15/16 in. (53.2 cm); H. of blade 17 in. (43.2 cm); W. 2 5/8 in. (6.7 cm); D. 13/16 in. (2.1 cm); Wt. 1 lb. 0.7 oz. (473.4 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Swords 29   http://www.metmuseum.org/art/collection/search/32256 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28866 28866 29.158.640 0 0 34065 Arms and Armor 5 Cannon 3055 Cannon French 7                           early 15th century; mounting modern 1401 1900 Iron, wood 473 L. 21 3/4 in. (55.3 cm); Cal. of muzzle 6 7/8 in. (173.1 mm); Cal. of explosion chamber 2.25 in. (57.1 mm); D. of mortar 7 1/2 in. (19.1 cm); Diam. of muzzle 9 1/2 in. (24.1 cm); Diam. of breech 5 1/4 in. (13.3 cm); Wt. 136 lb. (61.74 kg) Bashford Dean Memorial Collection, Funds from various donors, 1929                       Firearms-Cannon 153   http://www.metmuseum.org/art/collection/search/34065 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30306 30306 12.230.2 0 1 35892 Arms and Armor 5 Armorer's hammer 3859 Armorer's Hammer German or French 402                           18th–19th century 1701 1900 Iron, wood 473 H. 14 1/4 in. (36.2 cm); W. of head 5 1/2 in. (14 cm); Wt. 3 lb. 1.8 oz. (1411.8 g) Rogers Fund, 1912                       Miscellaneous 64   http://www.metmuseum.org/art/collection/search/35892 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30307 30307 12.230.32 0 1 35893 Arms and Armor 5 Armorer's hammer 3859 Armorer's Hammer German or French 402                           18th–19th century 1701 1900 Iron, wood 473 H. 12 in. (30.5 cm); W. of head 5 in. (12.7 cm); Wt. 14.9 oz. (422.4 g) Rogers Fund, 1912                       Miscellaneous 64   http://www.metmuseum.org/art/collection/search/35893 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30311 30311 12.230.98 0 1 35897 Arms and Armor 5 Armorer's hammer 3859 Armorer's Hammer German or French 402                           18th–19th century 1701 1900 Iron, wood 473 H. 12 5/8 in. (32.1 cm); W. of head. 10 1/4 in. (26 cm); Wt. 3 lb. 15.7 oz. (1805.9 g) Rogers Fund, 1912                       Miscellaneous 64   http://www.metmuseum.org/art/collection/search/35897 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
190801 190801 1976.409.2 0 0 309871 Arts of Africa, Oceania, and the Americas 10 Adze 3104 Ceremonial Adze Pende peoples (?) 4510                           20th century 1900 2000 Iron, wood 473 L. 20 5/8 in. (52.4 cm) Gift of Fred and Rita Richman, 1976         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/309871 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
190824 190824 1972.4.64 0 0 309894 Arts of Africa, Oceania, and the Americas 10 Knife 141 Ceremonial Knife Mambila peoples, Mfumte group 4524                           19th–20th century 1800 2000 Iron, wood 473 W x D: 4 x 20 1/4 in. (10.2 x 51.4 cm) Fletcher Fund, 1972         Cameroon 70 North Cameroon 64         Donga River 29 Metal-Implements 481   http://www.metmuseum.org/art/collection/search/309894 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
190829 190829 1972.4.69 0 0 309899 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Oku peoples 4528                           19th–20th century 1800 2000 Iron, wood 473 Height: 72 in. Fletcher Fund, 1972         Cameroon 70 Western Grassfields 59           Metal-Implements 481   http://www.metmuseum.org/art/collection/search/309899 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
191213 191213 1977.220.3 0 0 310289 Arts of Africa, Oceania, and the Americas 10 Gong 3991 Gong: Figurative Handle Cameroon 4613                           19th–20th century 1800 2000 Iron, wood 473 H x W: 18 1/4 x 5 3/8in. (46.4 x 13.7cm) Gift of Mr. and Mrs. Alan Bresler, Mr. and Mrs. Robert Bevill, Mr. and Mrs. Dale Ledbetter, and Mr. and Mrs. Gilbert Schulman, 1977       Grassfields 390 Cameroon 70             Metal-Musical Instruments 507   http://www.metmuseum.org/art/collection/search/310289 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
195068 195068 1981.421 0 0 314403 Arts of Africa, Oceania, and the Americas 10 Axe 2349 Ceremonial Axe (Khaandu) Yaka peoples 4515                           19th–20th century 1800 2000 Iron, wood 473 H. 10 3/8 x W. 2 x D. 7 1/2 in. (26.4 x 5.1 x 19.1cm) Gift of Mr. and Mrs. R. H. Smith, 1981         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/314403 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
195124 195124 1981.431.12 0 0 314459 Arts of Africa, Oceania, and the Americas 10 Knife 141 Ceremonial Knife Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 H x W: 8 1/4 x 27in. (21 x 68.6cm) Gift of Dr. and Mrs. Jeffrey S. Hammer in memory of Dr. Milton Gross, 1981         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/314459 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197102 197102 1990.337.1 0 0 316461 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 53-3/8 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316461 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197103 197103 1990.337.2 0 0 316462 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 56-1/8 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316462 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197104 197104 1990.337.3 0 0 316463 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 59-3/4 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316463 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197105 197105 1990.337.4 0 0 316464 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 50-3/4 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316464 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197106 197106 1990.337.5 0 0 316465 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 58-1/2 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316465 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197107 197107 1990.337.6 0 0 316466 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 57-1/2 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316466 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197108 197108 1990.337.7 0 0 316467 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 66-1/2 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316467 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197109 197109 1990.337.8 0 0 316468 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 70 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316468 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197110 197110 1990.337.9 0 0 316469 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 58-3/4 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316469 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
197111 197111 1990.337.10 0 0 316470 Arts of Africa, Oceania, and the Americas 10 Spear 1453 Spear Democratic Republic of Congo 4398                           19th–20th century 1800 2000 Iron, wood 473 Length 57-3/4 in. Gift of Drs. John and Nicole Dintenfass, 1990         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/316470 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
199711 199711 2011.11.10 0 0 319554 Arts of Africa, Oceania, and the Americas 10 Knife 141 Knife: Head (Namambele) Mangbetu peoples 4565                           19th–20th century 1801 1999 Iron, wood 473 H. 11 x W. 2 in. (27.9 x 5.1 cm) Gift of James J. Ross, 2011         Democratic Republic of the Congo 93             Metal-Implements 481   http://www.metmuseum.org/art/collection/search/319554 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
330480 330480 25.120.307 0 1 473934 The Cloisters 17 Window 34 Window Spanish 13                           17th century or later 1600 1850 Iron, wood 473 Overall: 19 x 14 1/2 in. (48.3 x 36.8 cm) The Cloisters Collection, 1925                       Metalwork-Iron 322   http://www.metmuseum.org/art/collection/search/473934 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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");
Powered by Datasette · Query took 130.346ms · Data license: CC0 · Data source: metmuseum/openaccess