MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

3,834 rows where Artist Role = 20 sorted by Geography Type

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Department, Artist Prefix, Artist Suffix, Artist Nationality, Geography Type, County, Country, Region

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 Repository
14909 1998.318a, b 0 0 16169 American Decorative Arts 1 Girandole candlesticks 1118 Pair of Girandole Candlesticks           Manufacturer 20 Manufactured by Deitz and Company     Deitz and Company 2346   1860   1855–60 1855 1860 Brass, marble, glass, iron 2532 16 1/8 x 6 7/8 x 3 3/8 in. (41 x 17.5 x 8.6 cm) Gift of Francesco C. Ribando, 1998                       Metal 1   Metropolitan Museum of Art, New York, NY 1
15491 2000.413.2a–f 0 0 16779 American Decorative Arts 1 Argand lamp 19 Argand Lamp           Manufacturer 20 Manufactured by J. B. Wilbor     Wilbor, J. B. 2396     9999 ca. 1835 1835 1835 Gilded brass, iron and glass 2665 Single arm: 19 x 11 1/2 x 6 1/4 in. (48.3 x 29.2 x 15.9 cm) Purchase, The Lucy Washington and Renwick Clifton Hurry Fund, 2000                       Metal 1   Metropolitan Museum of Art, New York, NY 1
15492 2000.413.3a–f 0 0 16780 American Decorative Arts 1 Argand lamp 19 Argand Lamp           Manufacturer 20 Manufactured by J. B. Wilbor     Wilbor, J. B. 2396     9999 ca. 1835 1835 1835 Gilded brass, iron and glass 2665 Single arm: 19 x 11 1/2 x 6 1/4 in. (48.3 x 29.2 x 15.9 cm) Purchase, The Lucy Washington and Renwick Clifton Hurry Fund, 2000                       Metal 1   Metropolitan Museum of Art, New York, NY 1
16650 2008.572.1 0 1 19995 American Decorative Arts 1 Card stand 1209 Card Stand American 1         Manufacturer 20 Manufactured by Bradley & Hubbard American, 1852–1940   Bradley & Hubbard 2580 American 1 1852 1940 1880–85 1880 1885 Brass, earthenware 2375 34 x 18 x 13 in. (86.4 x 45.7 x 33 cm) Gift of Dr. Alain and Ellen Roizen, 2008                       Furniture 4   Metropolitan Museum of Art, New York, NY 1
16692 2008.642.1 0 1 20176 American Decorative Arts 1 Double frame 1212 Candace Wheeler double frame American 1         Manufacturer 20 Manufactured by Associated Artists 1883–1907   Associated, Artists  2065   1883 1907 ca. 1880–1900 1880 1900 Silk velvet on cardboard, printed 3225 8 1/2 x 14 in. (21.6 x 35.6 cm) Gift of Robert Tuggle, 2008                       Textiles 16   Metropolitan Museum of Art, New York, NY 1
20265 48.125 0 1 24794 Arms and Armor 5 Percussion revolver 2242 Colt Dragoon Percussion Revolver, Third Model, serial no. 13096 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1853 1853 1853 Steel, brass, silver, wood (walnut) 4325 L. 14 3/4 in. (37.47 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .45 in. (11.4 mm) Purchase, Friends of Albert Foster Jr. Gifts, in his memory, 1948   Hartford 26   Connecticut 118               Firearms-Pistols-Percussion 96   Metropolitan Museum of Art, New York, NY 1
20306 55.206.1 0 1 24835 Arms and Armor 5 Percussion revolver 2242 Colt Paterson Percussion Revolver, No. 5, Holster Model, serial no. 528 American, Paterson, New Jersey 359         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1838–40 1813 1865 Steel, silver, ivory 4338 L. 16 3/4 in. (42.55 cm); L. of barrel 12 in. (30.48 cm); Cal. .40 in. (10.2 mm) Gift of John E. Parsons, 1955   Paterson 316   New Jersey 154               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20307 55.206.2 0 1 24836 Arms and Armor 5 Percussion revolver 2242 Colt Model 1861 Navy Percussion Revolver, serial no. 12240 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1863 1863 1863 Steel, brass, wood (walnut) 4339 L. 12 3/4 in. (32.39 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .36 in. (9.1 mm) Gift of John E. Parsons, 1955   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20309 56.167.1a–g 0 1 24838 Arms and Armor 5 Percussion revolver with case and accessories 2255 Colt Paterson Pocket Percussion Revolver, Fourth Ehlers Model, serial no. 152, with Case and Accessories American, Paterson, New Jersey 359         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1840–43 1815 1868 Steel, wood (walnut) 3526 Revolver (a); L. 6 1/2 in. (16.5 cm); L. of barrel 3 in. (7.6 cm); Cal. .28 in. (7.1 mm); bullet mould (b); L. 3 3/16 in. (8.1 cm); W. (when closed) 1 3/4 in. (4.5 cm); Wt. 2.2 oz. (62.4 g); primer (c); L. 3 11/16 in. (9.4 cm); Diam. 1 1/8 in. (2.8 cm); Wt. 3.3 oz. (93.6 g); cleaning rod (d); L. 4 5/8 in. (11.7 cm); Wt. 1.2 oz. (34 g); spanner-screwdriver (e); L. 2 5/8 in. (6.7 cm); W. 2 in. (5.1 cm); Wt. 0.9 oz. (25.5 g); case (f); H. 2 in. (5.1 cm); W. 10 in. (25.4 cm); D. 5 7/8 in. (14.9 cm); Wt. 1 lb. 0.8 oz. (476.3 g); key (g); L. 1 1/8 in. (2.8 cm) Gift of John E. Parsons, 1956   Paterson 316   New Jersey 154               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20310 56.167.2 0 1 24839 Arms and Armor 5 Percussion revolver 2242 Colt Dragoon Percussion Revolver, Third Model, serial no. 12403 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1852 1852 1852 Steel, brass, silver, wood (walnut) 4325 L. 14 in. (35.56 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .44 in. (11 mm) Gift of John E. Parsons, 1956   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20311 58.171.3 0 1 24840 Arms and Armor 5 Revolver 2256 Colt Model 1851 Navy Revolver with Thuer Conversion for Self-Contained Cartridges, Serial no. 27060 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1853; converted for cartidges, ca. 1868–71 1853 1896 Steel, brass, silver, ivory 4340 L. 13 in. (33.02 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .36 in. (9 mm) Gift of John E. Parsons, 1958   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20312 57.166.1 0 1 24841 Arms and Armor 5 Percussion revolver 2242 Colt Paterson Percussion Revolver, No. 5, Holster Model, serial no. 940 American, Paterson, New Jersey 359         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1840 1815 1865 Steel, silver, mother-of-pearl 3835 L. 14 in. (35.56 cm); L. of barrel 9 in. (22.86 cm); Cal. .40 in. (10 mm) Gift of John E. Parsons, 1957   Paterson 316   New Jersey 154               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20313 57.166.2a–e 0 1 24842 Arms and Armor 5 Percussion revolver with case and accessories 2255 Colt Model 1855 Pocket Percussion Revolver, Serial no. 4460, with Case and Accessories American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1855 1855 1855 Steel, wood (oak) 4171 L. 7 7/8 in. (19.99 cm); L. of barrel 3 1/2 in. (8.89 cm); Cal. .28 in. (7 mm); case 9 3/8 x 5 3/4 x 1 7/8 in. (23.8 x 14.61 x 4.75 cm); L. of spanner-screwdriver 3 1/4 in. (8.26 cm); greatest W. of spanner-screwdriver 1 3/8 in. (3.48 cm); L. of primer 4 5/8 in. (11.73 cm); greatest W. of primer 2 in. (5.08 cm); L. of bullet mould 4 3/8 in. (11.1 cm) Gift of John E. Parsons, 1957   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20317 59.143.1a–h 0 1 24846 Arms and Armor 5 Percussion revolver with case and accessories 2255 Colt Paterson Percussion Revolver, No. 3, Belt Model, Serial no. 156, with Case and Accessories American, Paterson, New Jersey 359         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1838 1813 1863 Steel, silver, brass, wood (walnut), copper, velvet 4342 Revolver (a); L. 9 5/8 in. (24.4 cm); L. of barrel 5 1/2 in. (14 cm); Cal. .34 in. (8 mm); extra cylinder (b); L. 1 1/4 in. (3.2 cm); Diam. 1 1/4 in. (3.2 cm); Wt. 4.2 oz. (119.1 g); combination patch, powder and ball cylinder (c); L. 5 3/8 in. (13.6 cm); Diam. 1 5/16 in. (3.3 cm); Wt. 12.2 oz. (345.9 g); bullet mould (d); L. 3 11/16 in. (9.4 cm); W. 1 1/4 in. (3.2 cm); Wt. 2.2 oz. (62.4 g); combination screwdriver and pricker (e); L. 4 11/16 in. (11.9 cm); Wt. 1.7 oz. (48.2 g); percussion cap box (f); L. 3 5/16 in. (8.4 cm); Diam. 1 13/16 in. (4.6 cm); Wt. 3.1 oz. (87.9 g); cleaning rod (g); L. 6 7/8 in. (17.5 cm); Wt. 1.1 oz. (31.2 g); case (h); H. 2 1/8 in. (5.4 cm); W. 10 3/8 in. (26.3 cm); D. 7 in. (17.8 cm); Wt. 2 lb. 3.3 oz. (1000.7 g) Gift of John E. Parsons, 1959   Paterson 316   New Jersey 154               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20319 59.143.4 0 1 24848 Arms and Armor 5 Revolver 2256 "Peacemaker" Colt Single-Action Army Revolver, serial no. 4519 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1874 1874 1874 Steel, iron, wood 3504 L.13 in. (33.02 cm); L. of barrel 7 1/2 in. (19.05 cm); Cal. .45 in. (11 mm) Gift of John E. Parsons, 1959   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20326 68.157.2 0 1 24855 Arms and Armor 5 Percussion revolver 2242 Colt Model 1851 Navy Percussion Revolver, serial no. 2 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1850 1850 1850 Steel, brass, silver, wood (walnut) 4325 L. of barrel 7 1/2 in. (19.05 cm); Cal. .38 in. (10 mm) Gift of John E. Parsons, 1968   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20361 1983.442a–o 0 1 24892 Arms and Armor 5 Percussion revolver with case and accessories 2255 Cased Colt Model 1860 Army Percussion Revolver, Serial no. 7569, with Accessories American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 1861 1861 1861 Steel, brass, silver, gold, wood (mahogany), textile 4366 L. 14 1/2 in. (36.83 cm); L. of barrel 8 in. (20.32 cm); Cal. .44 in. (11 mm) Gift of Mr. and Mrs. Jerry D. Berger, 1983   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
20427 1995.336 1 1 24960 Arms and Armor 5 Percussion revolver 2242 Colt Third Model Dragoon Percussion Revolver, Serial Number 12406 American, Hartford, Connecticut 350         Manufacturer 20   Samuel Colt American, Hartford, Connecticut 1814–1862   Colt, Samuel 2891 American 1 1814 1862 ca. 1853 1828 1878 Steel, brass, gold, wood (walnut) 4396 L. 14 in. (35.6 cm); L. of barrel 7 1/2 in. (19.1 cm); Cal. .44 in. (11.2 mm); case; H. 3 in. (7.6 cm); W. 16 3/16 in. (41.1 cm); D. 8 1/8 in. (20.6 cm); Wt. 3 lb. 9.8 oz. (224 g) Gift of George and Butonne Repaire, 1995   Hartford 26   Connecticut 118               Firearms-Pistols-Revolvers 133   Metropolitan Museum of Art, New York, NY 1
21003 07.102.7 0 1 25602 Arms and Armor 5 Electrotype 2328 Electrotype Reproduction of a 16th Century Italian Shield British, Birmingham 398         Manufacturer 20   Elkington & Co. British, Birmingham, 1829–1963   Elkington & Co. 2972 British 7 1829 1963 19th century 1800 1899 Copper, gold, silver 4078 Diam. 22 in. (55.9 cm) Rogers fund, 1907   Birmingham 86                   Metalwork-Electrotype 136   Metropolitan Museum of Art, New York, NY 1
30271 2012.105a, b 0 1 35845 Arms and Armor 5 Sword with scabbard 1325 Sword and Scabbard of Captain Richard French American, Chicopee, Massachusetts 1264         Manufacturer 20   Ames Manufacturing Company American, Chicopee, Massachusetts, 1829–1935   Ames Manufacturing Company 3139 American 1 1829 1935 1850 1825 1875 Gold, brass, steel 6709 L. 40 in. (101.6 cm); L. of blade 32 1/4 in. (81.9 cm) Purchase, Arthur Ochs Sulzberger Gift, 2012   Chicopee 698   Massachusetts 169               Swords 29   Metropolitan Museum of Art, New York, NY 1
30297 2013.493.3a, b 0 0 35881 Arms and Armor 5 Medal with case 3864 Legion of Honor, Republic of France French, Paris 114         Manufacturer 20   Arthus Bertrand et Béranger French, Paris, 1803–present   Arthus Bertrand et Béranger 3147 French 2 1803 2013 ca. 1910 1885 1935 Gold, silver, enamel, silk, leather, paper 7223 H. of medal with ribbon 4 in. (10.2 cm); case: 4 1/2 x 2 1/4 x 1 in. (11.4 x 5.7 x 2.5 cm) Gift of Dean K. Boorman, 2013   Paris 27                   Miscellaneous-Coins and Medals 155   Metropolitan Museum of Art, New York, NY 1
30315 2012.473 0 0 35909 Arms and Armor 5 Experimental helmet prototype 3870 American Helmet Model No. 8 American, Philadelphia 1265         Manufacturer 20   Ford Motor Company American, founded 1903   Ford Motor Company 3150 American 1 1903 2099 1918 1918 1918 Steel, leather, felt, canvas, bronze, pigment, sawdust 7226 H. 9 in. (22.9 cm); W. 10 1/2 in. (26.7 cm); D. 12 1/4 in. (31.1 cm); Wt. 3 lb. 10.5 oz. (1660 g) Rogers Fund, by exchange, 2012   Philadelphia 1   Pennsylvania 172               Helmets 37   Metropolitan Museum of Art, New York, NY 1
30347 2013.582 0 1 35957 Arms and Armor 5 Experimental helmet prototype 3870 American Helmet Model No. 5 American, Philadelphia 1265         Manufacturer 20   Hale & Kilburn Company American, Philadelphia, Pennsylvania 1873–1933 Indianapolis, Indiana   Hale & Kilburn Company 3155 American 1 1873 1933 1918 1918 1918 Steel, paint, leather, textile, string 7236 H. 6 1/2 in. (16.5 cm); W. 10 3/4 in. (27.3 cm); D. 12 5/8 in. (32.1 cm); Wt. 2 lb. 8 oz. (1130 g) Purchase, Gift of Bashford Dean, by exchange, 2013   Philadelphia 1   Pennsylvania 172               Helmets 37   Metropolitan Museum of Art, New York, NY 1
30348 2013.583 0 0 35958 Arms and Armor 5 Experimental helmet prototype 3870 American Helmet Model No. 7, Sentinel's Helmet American, Salem, Ohio 1270         Manufacturer 20   W. H. Mullins Co. American, Salem, Ohio 1872–1974   Mullins Co., W. H. 3156 American 1 1872 1974 1918 1918 1918 Steel, leather, textile, paint 7237 H. 12 in. (30.5 cm); W. 9 5/8 in. (24.4 cm); D. 12 in. (30.5 cm); Wt. 13 lb. 12.6 oz. (6254 g) Purchase, Bequest of Stephen V. Grancsay, Rogers Fund, Helmut Nickel Gift, and funds from various donors, by exchange, 2013   Salem 22   Ohio 351               Helmets 37   Metropolitan Museum of Art, New York, NY 1
66496 1996.197.1 0 0 79028 Costume Institute 8 Trousers 5475 Trousers American 1         Manufacturer 20   Wright & Ditson American, founded 1890   Wright & Ditson 5296 American 1 1890 9999 late 1910s 1915 1920 wool 15104   Gift of Richard Martin, 1996                           Metropolitan Museum of Art, New York, NY 1
68356 1993.517.47 0 0 81162 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Manufacturer 20   Danskin American, founded 1882   Danskin 5670 American 1 1882 2099 1970 1970 1970 nylon, Lycra, spandex 15571   Gift of Jane Holzer, 1993                           Metropolitan Museum of Art, New York, NY 1
68960 1990.181.2 0 0 81968 Costume Institute 8 Scarf 1153 Scarf British 6         Manufacturer 20   Jacqmar British   Jacqmar 5732 British 7 1936 1972 1944 1944 1944 cotton 3340   Gift of Mrs. Otis Guernsey, Jr., 1990                           Metropolitan Museum of Art, New York, NY 1
69517 2001.777 0 0 82999 Costume Institute 8 Brassiere 5909 Brassiere American 1         Manufacturer 20   Shirley of Hollywood American, founded 1948   Shirley of Hollywood 5791 American 1 1948 9999 2001 2001 2001 synthetic, silicone 15921   Gift of Shirley of Hollywood, 2001                           Metropolitan Museum of Art, New York, NY 1
69526 2001.576a, b 0 1 83042 Costume Institute 8 Shoes 5896 Shoes British 6         Manufacturer 20   E. Pattison British, 1800–1850   E. Pattison 5793 British 7 1800 1850 1806–15 1806 1815 (a, b) leather, silk 15927   Purchase, Gerson and Judith Leiber Foundation Gift, 2001                           Metropolitan Museum of Art, New York, NY 1
69536 2001.619.2a, b 0 0 83059 Costume Institute 8 Shoes 5896 Shoes American 1         Manufacturer 20   Pleaser American, founded 1993   Pleaser 5795 American 1 1993 9999 2001 2001 2001 plastic 15143   Gift of Harold Koda, 2001                           Metropolitan Museum of Art, New York, NY 1
69590 1974.336a, b 0 0 83185 Costume Institute 8 Hoops 6077 Hoops American 1         Manufacturer 20   Belle o' the Ball Hoop     Belle o' the Ball Hoop 5801       1950s 1950 1959 synthetic, cotton 15944   Gift of Inge Heckel, 1974                           Metropolitan Museum of Art, New York, NY 1
69668 2001.780.1a–c 0 0 83279 Costume Institute 8 Ski ensemble 5977 Ski ensemble American 1         Manufacturer 20   Snow Snug by Shawmut American   SnowSnug by Shawmut 5809 American 1     1935–45 1935 1945 wool 15104   Gift of Elizabeth E. Greenberg, 2001                           Metropolitan Museum of Art, New York, NY 1
69669 2001.780.2a, b 0 0 83280 Costume Institute 8 Ski ensemble 5977 Ski ensemble American 1         Manufacturer 20   Lanz of Salzburg     Lanz of Salzburg 5810       1935–45 1935 1945 wool 15104   Gift of Elizabeth E. Greenberg, 2001                           Metropolitan Museum of Art, New York, NY 1
69679 2001.705.1a–c 0 0 83290 Costume Institute 8 Bodysuit 5932 Bodysuit American 1         Manufacturer 20   Warner's American, founded 1902   Warner's 5812 American 1 1902 9999 ca. 1967 1962 1972 Nylon, Lycra, Spandex 15971   Gift of Elaine Lustig Cohen, 2001                           Metropolitan Museum of Art, New York, NY 1
69680 2001.705.2a–d 0 0 83291 Costume Institute 8 Bodysuit 5932 Bodysuit American 1         Manufacturer 20   Warner's American, founded 1902   Warner's 5812 American 1 1902 9999 ca. 1967 1962 1972 Nylon, Lycra, Spandex 15971   Gift of Elaine Lustig Cohen, 2001                           Metropolitan Museum of Art, New York, NY 1
69689 2001.708a, b 0 0 83300 Costume Institute 8 Sunglasses 5960 "Overthetop FMJ+ with Fire Lens" American 1         Manufacturer 20   Oakley American, founded 1975   Oakley Inc. 5814 American 1 1975 9999 2001 2001 2001 plastic, Plutonite® 15974   Gift of Oakley Inc., 2001                           Metropolitan Museum of Art, New York, NY 1
69789 1976.148.7a, b 0 0 83450 Costume Institute 8 Gloves 1054 Gloves French 7         Manufacturer 20   Alexandrine French   Alexandrine 5722 French 2     1925–35 1925 1935 leather 15128   Purchase, Irene Lewisohn Bequest, 1976                           Metropolitan Museum of Art, New York, NY 1
69938 C.I.37.44.5 0 0 83759 Costume Institute 8 Coat 4973 Coat French 7         Manufacturer 20   Dieulafait & E. Bouclier French   Bouclier 5849 French 2     late 19th–early 20th century 1863 1907 silk 15101   Gift of Miss Irene Lewisohn, 1937                           Metropolitan Museum of Art, New York, NY 1
69939 C.I.37.44.8 0 1 83760 Costume Institute 8 Mantle 6058 Mantle British 6         Manufacturer 20   Jay's of London British   Jay's of London 5850 British 7     ca. 1863 1863 1863 silk 15101   Gift of Miss Irene Lewisohn, 1937                           Metropolitan Museum of Art, New York, NY 1
70044 1991.63.4a–j 0 0 83875 Costume Institute 8 Fancy dress costume 5897 Fancy dress costume American 1         Manufacturer 20   Brooks Costume Company American   Brooks Costume Company 5862 American 1     1953 1953 1953 (a) acetate, rayon, nylon (b,c) silk (d) rayon (e, f) cotton (i) rayon (j) plastic 16106   Gift of Mr. Jean-François Daigre, 1991                           Metropolitan Museum of Art, New York, NY 1
70118 1979.416.54a, b 0 0 83968 Costume Institute 8 Evening shoes 5884 Evening shoes American 1         Manufacturer 20   Bob, Inc., N.Y. American   Bob, Inc., N.Y. 5878 American 1     1926–33 1926 1933 silk, leather, metal, glass 16135   Gift of Mrs. Lee Ault and Mrs. Ray Hill, in memory of Mrs. Charles R. Leonard, 1979                           Metropolitan Museum of Art, New York, NY 1
70145 1977.333.56 0 0 83997 Costume Institute 8 Jacket 4399 Jacket American 1         Manufacturer 20   Lee American, founded 1889   Lee 5451 American 1 1889 9999 late 1960s–early 1970s 1965 1975 cotton 3340   Gift of Serendipity 3 Denim Clothing Collection, 1977                           Metropolitan Museum of Art, New York, NY 1
70146 1977.333.62 0 0 83998 Costume Institute 8 Jeans 5905 Jeans American 1         Manufacturer 20   Seafarer Dungaree American   Seafarer Dungaree 5887 American 1     late 1960s–early 1970s 1965 1975 cotton, metal 15378   Gift of Serendipity 3 Denim Clothing Collection, 1977                           Metropolitan Museum of Art, New York, NY 1
70249 2002.163a, b 0 0 84167 Costume Institute 8 Sneakers 5957 "Shox R4" American 1         Manufacturer 20   Nike American, founded 1972   Nike 5432 American 1 1972 9999 2000 2000 2000 nylon, rubber, plastic 16176   Gift of Nike, Inc., 2002                           Metropolitan Museum of Art, New York, NY 1
70277 C.I.41.105.109 0 0 84204 Costume Institute 8 Necktie 5902 Necktie American 1         Manufacturer 20   Saks Fifth Avenue American, founded 1924   Saks Fifth Avenue 5336 American 1 1924 9999 1915–41 1915 1941 silk 15101   Gift of Mr. Carl Van Vechten, 1941                           Metropolitan Museum of Art, New York, NY 1
70295 1990.47.4 0 0 84224 Costume Institute 8 Fan 413 Fan American 1         Manufacturer 20   Shulton, Inc. American   Shulton, Inc. 5914 American 1     1939 1939 1939 paper 2859   Gift of Margaret Tasher Smith, 1990                           Metropolitan Museum of Art, New York, NY 1
70296 1990.181.1a, b 0 0 84225 Costume Institute 8 Dress 5877 Dress British 6         Manufacturer 20 Textile manufactured by Jacqmar British   Jacqmar 5732 British 7 1936 1972 ca. 1944 1944 1944 silk 15101   Gift of Mrs. Otis Guernsey, Jr., 1990                           Metropolitan Museum of Art, New York, NY 1
70297 1991.258 0 1 84226 Costume Institute 8 Fan 413 Fan American 1         Manufacturer 20   H.C.F. Koch American, 1890–1930   Koch H.C.F. 5915 American 1 1890 1930 ca. 1880 1875 1885 pasteboard, wood 16183   Gift of The Brooklyn Historical Society, 1991                           Metropolitan Museum of Art, New York, NY 1
70326 2002.198.12 0 0 84262 Costume Institute 8 Brassiere 5909 Brassiere American 1         Manufacturer 20   Maidenform American   Maidenform 5921 American 1     late 1940s 1945 1949 rayon, silk 15136   Gift of Molly Milbank, 2002                           Metropolitan Museum of Art, New York, NY 1
70397 1979.346.16 0 0 84341 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Manufacturer 20   Annette Kellerman American   Kellerman Annette 5931 American 1     1926–28 1926 1928 wool 15104   Gift of The New York Historical Society, 1979                           Metropolitan Museum of Art, New York, NY 1
70420 1972.247.11 0 0 84375 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Manufacturer 20   A. G. Spalding & Bros.     A. G. Spalding & Bros. 5290   1876   ca. 1920s 1915 1935 wool 15104   Gift of Mrs. Andrew E. Beer, 1972                           Metropolitan Museum of Art, New York, NY 1
70423 1974.238a–c 0 0 84381 Costume Institute 8 Suit 5876 Suit British 6         Manufacturer 20   Sullivan, Williams & Co., Ltd. British   Sullivan, Williams & Co., Ltd. 5935 British 7     1952 1952 1952 wool 15104   Gift of Cecil Beaton, 1974                           Metropolitan Museum of Art, New York, NY 1
70428 1979.59.10a–c 0 0 84386 Costume Institute 8 Suit 5876 Suit American 1         Manufacturer 20   Orser & Terrizzi American   Orser & Terrizzi 5936 American 1     ca. 1926 1921 1931 wool 15104   Gift of Stanley F. Waldman, President, The Manhattan Galleries, Inc., 1979                           Metropolitan Museum of Art, New York, NY 1
70432 1983.616.4a, b 0 0 84391 Costume Institute 8 Robe 4675 Robe French 7         Manufacturer 20   Charvet et Fils French   Charvet et Fils 5937 French 2     ca. 1925 1920 1930 flax, synthetics 16222   Gift of June Dorflinger Hardy, 1983                           Metropolitan Museum of Art, New York, NY 1
70471 C.I.51.15.3a, b 0 0 84441 Costume Institute 8 Coat 4973 Coat American 1         Manufacturer 20   G. Wildes Smith of Boston American   G. Wildes Smith of Boston 5939 American 1     1901–4 1901 1904 silk 15101   Gift of Mrs. Earl Rowe, 1951                           Metropolitan Museum of Art, New York, NY 1
70474 C.I.55.65a–c 0 0 84444 Costume Institute 8 Suit 5876 Suit French 7         Manufacturer 20   Frances & Co., Paris French   Frances & Co., Paris 5940 French 2     1902 1902 1902 wool, silk 15161   Gift of Miss Frances M. Dickenson, 1955                           Metropolitan Museum of Art, New York, NY 1
70526 1973.112a, b 0 1 84498 Costume Institute 8 Evening shoes 5884 Evening shoes French 7         Manufacturer 20   F. Pinet, Paris French, founded 1855   F. Pinet, Paris 5837 French 2 1855 1855 1926 1926 1926 silk 15101   Gift of Mrs. James A. Cole, 1973                           Metropolitan Museum of Art, New York, NY 1
70559 44.52.5 0 0 84531 Costume Institute 8 Shoes 5896 Shoes French 7         Manufacturer 20   Hellstern and Sons French   Hellstern and Sons 5944 French 2     1910 1910 1910 silk, glass 15346   Gift of Mrs. Edward A. Morrison, 1944                           Metropolitan Museum of Art, New York, NY 1
70560 44.52.6 0 0 84532 Costume Institute 8 Slippers 5749 Slippers French 7         Manufacturer 20   Hellstern and Sons French   Hellstern and Sons 5944 French 2     1910 1910 1910 silk, glass 15346   Gift of Mrs. Edward A. Morrison, 1944                           Metropolitan Museum of Art, New York, NY 1
70575 C.I.45.36.12a, b 0 0 84551 Costume Institute 8 Slippers 5749 Slippers French 7         Manufacturer 20   Hellstern and Sons French   Hellstern and Sons 5944 French 2     1911 1911 1911 silk, leather 15154   Gift of Mrs. George Kent, 1945                           Metropolitan Museum of Art, New York, NY 1
70578 C.I.50.105.1 0 0 84554 Costume Institute 8 Toque 6086 Toque American 1         Manufacturer 20   Stern Brothers American, founded New York, 1867   Stern Brothers 5945 American 1 1867 2001 ca. 1898 1895 1900 silk, cotton, glass 16095   Gift of Mrs. Phillip H. Gray, 1950                           Metropolitan Museum of Art, New York, NY 1
70674 2002.198.24a–c 0 0 84665 Costume Institute 8 Ski suit 6125 Ski suit Norwegian 596         Manufacturer 20   Molstad & Co. Norwegian   Molstad & Co. 5953 Norwegian 29     1940s 1940 1949 wool 15104   Gift of Molly Milbank, 2002                           Metropolitan Museum of Art, New York, NY 1
70676 C.I.59.12.1 0 0 84669 Costume Institute 8 Umbrella 6126 Umbrella British 6         Manufacturer 20   Briggs & Sons, London British   Briggs & Sons 5954 British 7     ca. 1938 1933 1943 silk, wood, bone, metal, crystal, diamonds 16271   Gift of Ann Payne Blumenthal, 1959                           Metropolitan Museum of Art, New York, NY 1
70677 C.I.59.12.3 0 0 84671 Costume Institute 8 Umbrella 6126 Umbrella British 6         Manufacturer 20   Briggs & Sons, London British   Briggs & Sons 5954 British 7     1938–40 1938 1940 silk, wood, rock-crystal, onyx, metal 16272   Gift of Ann Payne Blumenthal, 1959                           Metropolitan Museum of Art, New York, NY 1
70679 1978.472.1a, b 0 0 84674 Costume Institute 8 Riding Habit 6100 Riding habit British 6         Manufacturer 20   Robert Douglas Ltd. British   Robert Douglas Ltd. Robert 5955 British 7     1936 1936 1936 a,b) wool 16274   Gift of Mrs. C. Suydam Cutting, 1978                           Metropolitan Museum of Art, New York, NY 1
70714 C.I.52.24.9a, b 0 0 84712 Costume Institute 8 Pumps 5885 Pumps French 7         Manufacturer 20   Netch and Frater French   Netch and Frater 5960 Fench 195     1927–31 1927 1931 leather, metallic 16283   Gift of Mrs. Harrison Williams, 1952                           Metropolitan Museum of Art, New York, NY 1
70715 C.I.52.24.10a, b 0 0 84713 Costume Institute 8 Evening pumps 5900 Evening pumps French 7         Manufacturer 20   Netch and Frater French   Netch and Frater 5960 Fench 195     1930s 1930 1939 leather, silk 15481   Gift of Mrs. Harrison Williams, 1952                           Metropolitan Museum of Art, New York, NY 1
71039 C.I.41.58.1a, b 0 1 85393 Costume Institute 8 Dress 5877 Dress American 1         Manufacturer 20 Textile by James McCreary and Co., N.Y. American   McCreary James 5980 American 1     1876–78 1876 1878 silk 15101   Gift of the Misses Faith and Delia Leavens, 1941                           Metropolitan Museum of Art, New York, NY 1
71089 2002.529.1a, b 0 0 85493 Costume Institute 8 Hunting ensemble 6143 Hunting ensemble American 1         Manufacturer 20   Woolrich Woolen Mills American, founded 1830   Woolrich Woolen Mills 5984 American 1 1830 9999 1960–72 1960 1972 (a, b) wool 15852   Gift of Harold Koda, 2002                           Metropolitan Museum of Art, New York, NY 1
71157 1975.228.5 0 0 85582 Arts of Africa, Oceania, and the Americas 10 Wrap 1162 Wrap African 521         Manufacturer 20   Tasini, Tanzania     Tasini, Tanzania 5986   0 0 1971 1971 1971 cotton 3340 Length: 62 in. (157.5 cm) Gift of Arthur Englander, 1975         Tanzania or Kenya 96             Textiles 16   Metropolitan Museum of Art, New York, NY 1
71722 2000.169.2a–c 0 0 86404 Costume Institute 8 Corset 5923 Corset American 1         Manufacturer 20   The Sahlin Company American   Sahlin Company The 5993       1900–1912 1900 1912 cotton 3340   Gift of Richard Martin, 2000                           Metropolitan Museum of Art, New York, NY 1
71931 1977.115.32a, b 0 0 86720 Costume Institute 8 Boots 5898 Boots British 6         Manufacturer 20   The Chelsea Cobbler     Chelsea Cobbler The 6014       ca. 1970 1970 1970 leather 15128   Gift of Jane Holzer, 1977                           Metropolitan Museum of Art, New York, NY 1
72031 2002.449.9a, b 0 0 87004 Costume Institute 8 Morning suit 6061 Morning suit American 1         Manufacturer 20   Chipp New York New Haven American   Chipp New York New Haven 6022 American 1     ca. 1960 1955 1965 (a) wool, silk; (b) wool 15928   Gift of Mrs. William McCormick Blair, Jr., 2002                           Metropolitan Museum of Art, New York, NY 1
72032 2002.449.10a, b 0 0 87005 Costume Institute 8 Ensemble 5875 Ensemble American 1         Manufacturer 20   Chipp New York New Haven American   Chipp New York New Haven 6022 American 1     1961 1961 1961 (a) wool, silk; (b) silk 16540   Gift of Mrs. William McCormick Blair, Jr., 2002                           Metropolitan Museum of Art, New York, NY 1
72066 2003.133a, b 0 1 87377 Costume Institute 8 Corset 5923 Corset French 7         Manufacturer 20   La Sirene French   La Sirene 6034 French 2     mid-1880s 1880 1890 a,b) leather, metal, cotton, silk 16552   Purchase, Judith and Ira Sommer Gift, 2002                           Metropolitan Museum of Art, New York, NY 1
72265 2003.46 0 0 88207 Costume Institute 8 Evening dress 5874 Evening dress Austrian 184         Manufacturer 20   G & E Spitzer Austrian   G & E Spitzer 6063 Austrian 66     1910–12 1910 1912 silk, pearl, glass 16625   Purchase, Irene Lewisohn Bequest, 2003                           Metropolitan Museum of Art, New York, NY 1
72293 C.I.55.45.1a–e 0 1 88348 Costume Institute 8 Ensemble 5875 Ensemble American 1         Manufacturer 20   L. P. Hollander & Co., Boston     L. P. Hollander & Co., Boston 5766       1870s 1870 1879 (a) silk (b) wool, silk, leather (c) wool (d) silk, metal, feather (e) metal, leather, hair 16631   Gift of Mrs. J. Griswold Webb, 1955                           Metropolitan Museum of Art, New York, NY 1
72301 2003.360 0 0 88365 Costume Institute 8 Bodysuit 5932 Bodysuit French 7         Manufacturer 20   Chantelle French   Chantelle 6064 French 2     2003 2003 2003 nylon, polyurethane, spandex, cotton blend 16637   Gift of Chantelle, 2003                           Metropolitan Museum of Art, New York, NY 1
72505 1984.157.3a, b 0 0 90022 Costume Institute 8 Shoes 5896 Shoes Italian 36         Manufacturer 20   Shoe Biz Italian   Shoe Biz 6076 Italian 6     ca. 1968 1963 1973 leather, synthetic 15765   Gift of Anne H. Bass, 1984                           Metropolitan Museum of Art, New York, NY 1
72510 1989.333.3a, b 0 0 90035 Costume Institute 8 Pumps 5885 Pumps French 7         Manufacturer 20   Sidonie Larizzi French   Sidonie Larizzi 6078 French 2     1983–89 1983 1989 leather, silk 15481   Gift of Anne H. Bass, 1989                           Metropolitan Museum of Art, New York, NY 1
72537 1991.79a, b 0 0 90102 Costume Institute 8 Shoulder bag 6094 Shoulder bag Italian 36         Manufacturer 20   Bottega Veneta Italian, founded 1966   Bottega Veneta 5442 Italian 6 1966 9999 1991 1991 1991 silk 15101   Gift of Anne H. Bass, 1991                           Metropolitan Museum of Art, New York, NY 1
73058 1974.300.3 0 0 91096 Costume Institute 8 Waistcoat 1202 Waistcoat Austrian 184         Manufacturer 20   Lanz of Salzburg     Lanz of Salzburg 5810       ca. 1934 1929 1939 [no medium available] 15100   Gift of Cecil Beaton, 1974                           Metropolitan Museum of Art, New York, NY 1
73191 1991.63.18 0 0 91235 Costume Institute 8 Shirt 5887 Shirt American 1         Manufacturer 20   Jeans Best     Jeans Best 6095       1970–75 1970 1975 cotton 3340   Gift of Mr. Jean-François Daigre, 1991                           Metropolitan Museum of Art, New York, NY 1
73255 1994.154.1 0 0 91632 Costume Institute 8 Undershirt 5979 Undershirt American 1         Manufacturer 20   Realsilk American   Realsilk 6101 American 1     1940s 1940 1949 rayon 15114   Gift of Mrs. David S. Kapell, 1994                           Metropolitan Museum of Art, New York, NY 1
73256 1994.154.2 0 0 91633 Costume Institute 8 Undershirt 5979 Undershirt American 1         Manufacturer 20   Realsilk American   Realsilk 6101 American 1     1940s 1940 1949 rayon 15114   Gift of Mrs. David S. Kapell, 1994                           Metropolitan Museum of Art, New York, NY 1
73308 C.I.57.65.2a, b 0 0 91750 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Manufacturer 20   Gantner of California     Gantner of California 5550       1910–11 1910 1911 wool 15104   Gift of Gantner of California, 1957                           Metropolitan Museum of Art, New York, NY 1
73309 C.I.57.65.3 0 0 91751 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Manufacturer 20   Gantner of California     Gantner of California 5550       ca. 1925 1920 1930 wool 15104   Gift of Gantner of California, 1957                           Metropolitan Museum of Art, New York, NY 1
73374 1985.375.50 0 0 91817 Costume Institute 8 Ski trousers 6241 Ski trousers German 27         Manufacturer 20   Bogner of America German, founded 1936   Bogner of America 6107 German 10 1936 9999 ca. 1972 1967 1977 wool, nylon, lycra, spandex, metal 16771   Gift of Barbara and Gregory Reynolds, 1985                           Metropolitan Museum of Art, New York, NY 1
73473 1994.164.8a–d 0 0 91933 Costume Institute 8 Suit 5876 Suit British 6         Manufacturer 20   Henry Poole & Co. British, founded 1806   Henry Poole & Co. 6112 British 7 1806 2099 1968 1968 1968 wool 15104   Gift of Kay Kerr Uebel, 1994                           Metropolitan Museum of Art, New York, NY 1
73591 1985.375.49 0 1 92066 Costume Institute 8 Jacket 4399 Jacket American 1         Manufacturer 20   Levi-Strauss and Company American, founded ca. 1853   Levi Strauss and Company 6116   1853 9999 ca. 1968 1963 1973 leather, metal 15127   Gift of Barbara and Gregory Reynolds, 1985                           Metropolitan Museum of Art, New York, NY 1
73602 1976.368.8 0 0 92077 Costume Institute 8 Jacket 4399 Jacket American 1         Manufacturer 20   Abercrombie and Fitch Co.     Abercrombie and Fitch Co. 6091 American 1 1892 2050 1965–69 1965 1969 cotton 3340   Gift of David Conant Ford, 1976                           Metropolitan Museum of Art, New York, NY 1
73636 1991.63.11 0 0 92112 Costume Institute 8 Coat 4973 Coat French 7         Manufacturer 20   Chambert, Paris French   Chambert, Paris 6123 French 2     1972 1972 1972 fur 15347   Gift of Mr. Jean-François Daigre, 1991                           Metropolitan Museum of Art, New York, NY 1
73637 1972.158a–g 0 0 92113 Costume Institute 8 Athletic ensemble 6012 Athletic ensemble American 1         Manufacturer 20   Parachutes Incorporated     Parachutes Incorporated 6124       1972 1972 1972 cotton b) plastic d—g) leather 16787   Gift of Jacques André Istel, 1972                           Metropolitan Museum of Art, New York, NY 1
73707 1976.374.1 0 0 92185 Costume Institute 8 Trousers 5475 Trousers American 1         Manufacturer 20   Wrangler American, founded 1947   Wrangler 6131 American 1 1947 9999 1975 1975 1975 synthetic 15169   Gift of Mr. and Mrs. C.J. Vincente Minetti                           Metropolitan Museum of Art, New York, NY 1
73840 1973.218.5 0 0 92414 Costume Institute 8 Sandals 4088 Sandals American 1         Manufacturer 20   Bernardo Sandals American   Bernardo Sandals 6157 American 1     1949 1949 1949 leather 15128   Gift of Bernardo Sandals Inc., 1973                           Metropolitan Museum of Art, New York, NY 1
74231 1993.423.10a, b 0 0 94541 Costume Institute 8 Shoes 5896 Shoes American 1         Manufacturer 20   Seymour Troy Originals American   Seymour Troy Originals 5958 American 1     late 1930s 1935 1939 suede, synthetic 16958   Gift of Miriam W. Coletti, 1993                           Metropolitan Museum of Art, New York, NY 1
74503 1994.148a–c 0 0 94895 Costume Institute 8 Bathing suit 5913 Bathing suit American 1         Manufacturer 20   Franklin Simon & Co. American, founded 1902   Franklin Simon & Co. 5626 American 1 1902 9999 ca. 1919 1914 1924 silk 15101   Gift of Mary Elizabeth Abeles, 1994                           Metropolitan Museum of Art, New York, NY 1
74517 1994.164.4 0 0 94917 Costume Institute 8 Coat 4973 Coat British 6         Manufacturer 20   Henry Poole & Co. British, founded 1806   Henry Poole & Co. 6112 British 7 1806 2099 1955 1955 1955 wool 15104   Gift of Kay Kerr Uebel, 1994                           Metropolitan Museum of Art, New York, NY 1
74540 2003.315 0 0 94954 Costume Institute 8 Suit 5876 Suit Italian 36         Manufacturer 20   Dainese Italian, founded 1972   Dainese 6226 Italian 6 1972 9999 2002 2002 2002 leather, plastic/metal, synthetic 16996   Purchase, NAMSB Foundation Inc. Gift, 2003                           Metropolitan Museum of Art, New York, NY 1
74566 1991.163.1 0 0 95024 Costume Institute 8 Belt 2179 Belt American 1         Manufacturer 20   Phelps American, founded 1940   Phelps 5731 American 1 1940 9999 late 1940s 1945 1949 leather, silver 16343   Gift of Mrs. William O'Donoghue, 1991                           Metropolitan Museum of Art, New York, NY 1

Next page

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 1507.812ms · Data license: CC0 · Data source: metmuseum/openaccess