MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

63 rows where Medium = 24

View and edit SQL

Suggested facets: Is Public Domain, Department, Culture, Object Date, Object Begin Date, Object End Date, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
122 19.171.2 0 1 130 American Decorative Arts 1 Frame 15 Frame American 1         Maker 1   Stanford White American, New York 1853–1906 New York   White, Stanford 19 American 1 1853 1906 1870–1900 1870 1900 Wood, gilt 24 83 x 58 1/2 in. (210.8 x 148.6 cm) Gift of Edward D. Adams, 1919                       Frames 7   Metropolitan Museum of Art, New York, NY 1
3565 26.174.1 0 1 3806 American Decorative Arts 1 Frame 15 Frame                             1830–70 1830 1870 Wood, gilt 24 24 7/8 x 20 11/16 x 1 in. (63.2 x 52.5 x 2.5 cm) Sight: 22 1/16 x 17 13/16 in. (56 x 45.2 cm) Gift of Robert Fridenberg, 1926                       Frames 7   Metropolitan Museum of Art, New York, NY 1
3566 26.174.2 0 1 3807 American Decorative Arts 1 Frame 15 Frame                             1830–70 1830 1870 Wood, gilt 24 22 1/8 x 18 3/8 in. (56.2 x 46.7 cm) Gift of Robert Fridenberg, 1926                       Frames 7   Metropolitan Museum of Art, New York, NY 1
3567 26.174.3 0 1 3808 American Decorative Arts 1 Frame 15 Frame                             1830–70 1830 1870 Wood, gilt 24 21 3/4 x 19 3/4 in. (55.2 x 50.2 cm) Gift of Robert Fridenberg, 1926                       Frames 7   Metropolitan Museum of Art, New York, NY 1
4512 47.103.14 0 1 4861 American Decorative Arts 1 Looking glass 484 Looking Glass                             ca. 1830 1827 1830 Wood, gilt 24 40 1/2 x 20 1/4 in. (102.9 x 51.4 cm) Gift of Mrs. J. Insley Blair, 1947                       Furniture 4   Metropolitan Museum of Art, New York, NY 1
101851 07.225.93a, b 0 1 189373 European Sculpture and Decorative Arts 3 Overdoor 7169 Overdoor (Dessus de porte) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 15 × 71 in. (38.1 × 180.3 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
101857 07.225.99 0 1 189379 European Sculpture and Decorative Arts 3 Ceiling medallion 7172 Ceiling medallion French 7                           late 17th–early 18th century 1685 1715 Wood, gilt 24 38 5/8 × 33 1/8 in. (98.1 × 84.1 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
101931 07.225.178a, b 0 1 189455 European Sculpture and Decorative Arts 3 Console supports 7188 Pair of console supports French 7                           early 18th century 1700 1715 Wood, gilt 24 each: 17 3/4 × 15 3/4 in. (45.1 × 40 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
101964 07.225.222 0 1 189488 European Sculpture and Decorative Arts 3 Bedstead leg 7200 Bedstead leg French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 40 × 5 1/8 in. (101.6 × 13 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
101968 07.225.226a, b 0 1 189492 European Sculpture and Decorative Arts 3 Garlands 7202 Pair of garlands French 7                           18th century 1700 1799 Wood, gilt 24 Length (each): 45 1/4 in. (114.9 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
101970 07.225.228 0 1 189494 European Sculpture and Decorative Arts 3 Plinth 7196 Plinth French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 9 1/8 × 35 1/2 in. (23.2 × 90.2 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
101992 07.225.245a, b 0 1 189516 European Sculpture and Decorative Arts 3 Pilaster capitals  7208 Pair of pilaster capitals French 7                           18th century 1700 1799 Wood, gilt 24 Overall (each): 9 × 19 in. (22.9 × 48.3 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
101996 07.225.249 0 1 189520 European Sculpture and Decorative Arts 3 Plinth 7196 Plinth French 7                           18th century 1700 1799 Wood, gilt 24 Height: 12 1/2 in. (31.8 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
101997 07.225.250 0 1 189521 European Sculpture and Decorative Arts 3 Pedestal 684 Pedestal French 7                           third quarter 18th century 1750 1775 Wood, gilt 24 8 3/4 × 9 7/8 in. (22.2 × 25.1 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
102027 07.225.319a, b 0 1 189558 European Sculpture and Decorative Arts 3 Garlands 7202 Pair of garlands French 7                           18th century 1700 1799 Wood, gilt 24 Overall (.319a): 8 × 1 1/2 in. (20.3 × 3.8 cm); Overall (.319b): 7 × 1 1/2 in. (17.8 × 3.8 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102028 07.225.320a–c 0 1 189559 European Sculpture and Decorative Arts 3 Garlands 7202 Set of garlands French 7                           18th century 1700 1799 Wood, gilt 24 Overall (.320a): 7 1/4 × 3 1/2 in. (18.4 × 8.9 cm); Overall (.320b): 10 × 2 in. (25.4 × 5.1 cm); Overall (.220c): 9 × 2 3/4 in. (22.9 × 7 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102029 07.225.321 0 1 189560 European Sculpture and Decorative Arts 3 Ornament 656 Ornament (Culot) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 6 3/8 × 8 1/4 in. (16.2 × 21 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102038 07.225.330 0 1 189569 European Sculpture and Decorative Arts 3 Wreath detail 7216 Myrtle wreath detail French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 8 7/8 × 5 1/2 in. (22.5 × 14 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102051 07.225.333.11 0 1 189582 European Sculpture and Decorative Arts 3 Wreath fragment 7217 Wreath fragment French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 14 1/2 × 2 1/2 in. (36.8 × 6.4 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102055 07.225.334 0 0 189586 European Sculpture and Decorative Arts 3 Garland 7219 Garland French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 18 1/4 × 3 1/2 in. (46.4 × 8.9 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102056 07.225.335 0 1 189587 European Sculpture and Decorative Arts 3 Garland 7219 Garland French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 11 1/4 × 3 in. (28.6 × 7.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102057 07.225.336 0 1 189588 European Sculpture and Decorative Arts 3 Knot of ribbon 7220 Knot of ribbon French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 10 1/4 × 4 in. (26 × 10.2 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102059 07.225.338 0 0 189590 European Sculpture and Decorative Arts 3 Trophy detail 7222 Trophy detail French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 8 1/2 × 11 1/4 in. (21.6 × 28.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102060 07.225.339 0 1 189591 European Sculpture and Decorative Arts 3 Wreath 7213 Wreath French 7                           18th century 1700 1799 Wood, gilt 24 Diameter: 7 in. (17.8 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102061 07.225.340 0 1 189592 European Sculpture and Decorative Arts 3 Trophy 7170 Trophy French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 11 1/2 × 8 1/2 in. (29.2 × 21.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102065 07.225.344 0 1 189596 European Sculpture and Decorative Arts 3 Garland 7219 Garland (detail of fronton) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 27 1/2 × 8 1/2 in. (69.9 × 21.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102070 07.225.349 0 1 189601 European Sculpture and Decorative Arts 3 Frame ornament 7226 Ornament from the top of a frame French 7                           18th century 1700 1799 Wood, gilt 24 12 × 8 1/2 in. (30.5 × 21.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
102071 07.225.350 0 1 189602 European Sculpture and Decorative Arts 3 Trophy 7170 Trophy French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 15 1/2 × 10 1/2 in. (39.4 × 26.7 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102072 07.225.351 0 1 189603 European Sculpture and Decorative Arts 3 Ornament 656 Ornament French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 26 × 6 1/2 in. (66 × 16.5 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102073 07.225.352 0 1 189604 European Sculpture and Decorative Arts 3 Trophy detail 7222 Trophy detail French 7                           late 17th–early 18th century 1685 1715 Wood, gilt 24 18 1/2 × 8 3/4 in. (47 × 22.2 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102074 07.225.353 0 1 189605 European Sculpture and Decorative Arts 3 Garland 7219 Garland French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 19 1/2 × 3 in. (49.5 × 7.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102075 07.225.354 0 1 189606 European Sculpture and Decorative Arts 3 Fronton detail 7227 Fronton ornament French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 8 1/4 × 12 1/2 in. (21 × 31.8 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102080 07.225.356 0 1 189611 European Sculpture and Decorative Arts 3 Molding fragment 7228 Molding fragment French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 20 1/4 × 4 1/2 in. (51.4 × 11.4 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102082 07.225.358a 0 1 189613 European Sculpture and Decorative Arts 3 Garland 7219 Garland (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 24 1/2 × 7 3/4 in. (62.2 × 19.7 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102083 07.225.358b 0 1 189614 European Sculpture and Decorative Arts 3 Garland 7219 Garland (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall (confirmed): 27 1/4 × 11 13/16 × 2 1/8 in. (69.2 × 30 × 5.4 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102084 07.225.358c 0 1 189615 European Sculpture and Decorative Arts 3 Garland 7219 Garland (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 28 3/8 × 12 3/16 × 2 3/4 in. (72.1 × 31 × 7 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102085 07.225.358d 0 1 189616 European Sculpture and Decorative Arts 3 Garland 7219 Garland (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 13 1/4 × 5 in. (33.7 × 12.7 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102086 07.225.358e 0 0 189617 European Sculpture and Decorative Arts 3 Garland 7219 Garland (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 12 × 3 1/2 in. (30.5 × 8.9 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102088 07.225.360a 0 1 189619 European Sculpture and Decorative Arts 3 Trophy 7170 Trophy (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 36 × 8 in. (91.4 × 20.3 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102089 07.225.360b 0 1 189620 European Sculpture and Decorative Arts 3 Trophy 7170 Trophy (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 26 × 7 in. (66 × 17.8 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102090 07.225.360c 0 1 189621 European Sculpture and Decorative Arts 3 Garland 7219 Garland (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 13 × 6 1/2 in. (33 × 16.5 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102091 07.225.360d 0 1 189622 European Sculpture and Decorative Arts 3 Garland 7219 Garland (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 11 × 5 1/2 in. (27.9 × 14 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102092 07.225.360e 0 1 189623 European Sculpture and Decorative Arts 3 Garland 7219 Garland (part of a set) French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 10 1/4 × 5 in. (26 × 12.7 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102095 07.225.363 0 1 189626 European Sculpture and Decorative Arts 3 Vase ornament 7230 Vase with flowers French 7                           18th century 1700 1799 Wood, gilt 24   Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102096 07.225.364 0 1 189627 European Sculpture and Decorative Arts 3 Console ornament 7231 Console ornament French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 9 × 11 1/2 in. (22.9 × 29.2 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
102098 07.225.366 0 1 189629 European Sculpture and Decorative Arts 3 Plinth 7196 Plinth detail French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 3 1/2 × 4 1/4 in. (8.9 × 10.8 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102099 07.225.367 0 1 189630 European Sculpture and Decorative Arts 3 Capital detail 7232 Capital detail French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 1 1/4 × 2 1/4 in. (3.2 × 5.7 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102101 07.225.369 0 1 189632 European Sculpture and Decorative Arts 3 Wall ornament 7233 Wall ornament French 7                           early 18th century 1700 1715 Wood, gilt 24 19 × 13 in. (48.3 × 33 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102103 07.225.370b 0 1 189634 European Sculpture and Decorative Arts 3 Trophy 7170 Trophy of musical instruments detail French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 20 × 11 1/2 in. (50.8 × 29.2 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102107 07.225.373a, b 0 1 189638 European Sculpture and Decorative Arts 3 Panels 5011 Pair of panels French 7                           early 18th century 1700 1715 Wood, gilt 24 8 1/2 × 7 1/4 in. (21.6 × 18.4 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102110 07.225.376 0 1 189641 European Sculpture and Decorative Arts 3 Vase ornament 7230 Vase ornament for console French 7                           18th century 1700 1799 Wood, gilt 24 Height: 16 in. (40.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102111 07.225.377a, b 0 1 189642 European Sculpture and Decorative Arts 3 Wall ornaments 7237 Pair of wall ornaments French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 16 1/2 × 8 1/2 in. (41.9 × 21.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102118 07.225.386 0 1 189649 European Sculpture and Decorative Arts 3 Balustrade fragment 7240 Balustrade fragment French 7                           late 17th–early 18th century 1685 1715 Wood, gilt 24 Height: 11 1/2 in. (29.2 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102119 07.225.387 0 1 189650 European Sculpture and Decorative Arts 3 Fragment 486 Fragment French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 36 × 3 in. (91.4 × 7.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102123 07.225.391 0 1 189654 European Sculpture and Decorative Arts 3 Table leg 7242 Table leg French 7                           18th century 1700 1799 Wood, gilt 24 Overall: 30 × 3 in. (76.2 × 7.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102126 07.225.398a–c 0 1 189657 European Sculpture and Decorative Arts 3 Supports (?) 7243 Set of three supports (?) French 7                           18th century 1700 1799 Wood, gilt 24 Diameter (each): 9 7/8 in. (25.1 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102153 07.225.427 0 1 189685 European Sculpture and Decorative Arts 3 Frame fragment, mirror top (?) 7249 Circular frame fragment (mirror top?) French 7                           18th century 1700 1799 Wood, gilt 24 Length: 42 in. (106.7 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102172 07.225.454 0 0 189706 European Sculpture and Decorative Arts 3 Garland 7219 Garland French 7                           18th century 1700 1799 Wood, gilt 24 18-1/2 x 3 in. (47.0 x 7.6 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102203 07.225.486 0 1 189738 European Sculpture and Decorative Arts 3 Table leg 7242 Table leg French 7                           18th century 1700 1799 Wood, gilt 24 Height: 31 1/2 in. (80 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
102206 07.225.489a, b 0 1 189741 European Sculpture and Decorative Arts 3 Bedposts 7258 Pair of bedposts French 7                           18th century 1700 1799 Wood, gilt 24 Length (each): 60 in. (152.4 cm) Gift of J. Pierpont Morgan, 1906                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
105023 14.33 0 1 192691 European Sculpture and Decorative Arts 3 Frame 15 Overdoor cresting Italian, Venice 122                           18th century 1700 1799 Wood, gilt 24 Overall (watercolor): 71 1/4 × 54 1/8 in. (181 × 137.5 cm) Rogers Fund, 1913                       Woodwork 185   Metropolitan Museum of Art, New York, NY 1
106681 18.70.35 0 1 194526 European Sculpture and Decorative Arts 3 Mirror 3984 Mirror Italian 36                           first half 16th century 1500 1550 Wood, gilt 24 Overall: 26 5/16 × 14 3/4 in. (66.9 × 37.5 cm) Rogers Fund, 1918                       Woodwork-Furniture 321   Metropolitan Museum of Art, New York, NY 1
120029 07.169.82 0 0 209208 European Sculpture and Decorative Arts 3 Frame 15 Frame possibly Italian 144                           18th–19th century 1700 1899 Wood, gilt 24 Overall: 9 × 8 in. (22.9 × 20.3 cm) Gift of Charles W. Woolsey, 1906-1907                       Woodwork 185   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 159.186ms · Data license: CC0 · Data source: metmuseum/openaccess