MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

35 rows where Classification = 48

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Culture, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, County

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
17458 17458 04.3.122 0 0 21960 Arms and Armor 5 Sword combined with agujeta flintlock six-shot revolver 1336 Sword Combined with Agujeta Flintlock Six-Shot Revolver Spanish 13                           ca. 1620–40 1595 1665 Steel, gold 3497 L. 32 1/8 in. (81.6 cm); Cal. .25 in. (6.4 mm); L. of barrel 5 7/8 in. (14.9 cm); Diam. at muzzle 3/8 in. (9.5 mm); Diam. at breech 7/16 in. (11.1 mm); L. of drum 2 3/8 in. (6.0 cm); Diam. of drum 1 1/4 in. (3.2 cm); L. of lock 3 1/2 in. (8.9 cm); L. of pistol 16 1/4 in. (41.3 cm); Wt. 1 lb. 12.2 oz. (800 g) Rogers Fund, 1904                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/21960 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17461 17461 04.3.158 0 1 21963 Arms and Armor 5 Hunting knife combined with wheellock pistol 1339 Hunting Knife Combined with Wheellock Pistol German, Munich 128         Etcher 104   Ambrosius Gemlich German, Munich and Landshut, active ca. 1520–50   Gemlich, Ambrosius 2688 German 10 1495 1575 blade ca. 1528–29, etched with a calendar for the years 1529–34; barrel dated 1540 or 1546 1528 1546 Steel, gold, staghorn, bronze 3525 L. 18 1/4 in. (46.4 cm); L. of barrel 12 3/8 in. (31.4 cm); L. of blade 13 1/4 in. (33.7 cm); Cal. .28 in. (7.1 mm) Rogers Fund, 1904   Munich 426                   Combination Weapons 48   http://www.metmuseum.org/art/collection/search/21963 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19379 19379 36.25.2916a, b 0 0 23902 Arms and Armor 5 Collapsible combination spear, dagger, and sword breaker (Jitte-shuriken) 1984 Collapsible Combination Spear, Dagger, and Sword Breaker (Jitte-shuriken) with Case Japanese 35         Blacksmith 128 Signed by Iye Saku Japanese, active ca. 18th–19th century   Iye Saku 2815 Japanese 74 1675 1925 ca. 18th–19th century 1675 1925 Steel, wood, cane 3983   Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/23902 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19951 19951 36.25.2108 0 0 24476 Arms and Armor 5 Combination pen case and pistol 2153 Combination Pen Case and Pistol Japanese 35                           19th century 1801 1900 Bronze 23 L. overall 7 4/5 in. (19.8 cm); L. of barrel 5 15/32 in. (13.9 cm); Bore 3 11/32 in. (8.51 cm); Wt. 11 1/5 oz. (318.5 g) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/24476 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19952 19952 36.25.2116a, b 0 0 24477 Arms and Armor 5 Combination dagger and pistol 2154 Combination Dagger and Pistol Japanese 35                           19th century 1801 1900   L. with scabbard 12 1/32 in. (30.61 cm); L. without 11 3/10 in. (28.7 cm); L. of barrel 4 3/4 in. (12.09 cm); L. of blade 6 31/32 in. (17.7 cm); Bore 3 1/10 in. (7.9 cm) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/24477 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19979 19979 36.25.2272a, b 0 0 24504 Arms and Armor 5 Combination pistol-dagger 2165 Combination Pistol-Dagger Japanese 35                           ca. 1615–1868 1590 1893 Steel 658 L.16 5/8 in. (42.2 cm); L. without scabbard 14 11/16 in. (37.3 cm); L. of barrel 8 1/4 in. (21.0 cm); Cal. 3 3/8 in. (8.5 cm); Wt. 14 oz. (402 g); Wt. without scabbard 11 oz. (332 g) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/24504 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20527 20527 04.3.39 0 0 25065 Arms and Armor 5 Mace with wheellock pistol 2348 Mace with Wheellock Pistol (with two other maces) French 7                           ca. 1550 1525 1575 Steel, silver, gold 3810 L. 24 1/2 in. (62.23 cm); greatest W. 4 in. (10.60 cm); barrel L. 16 1/8 in. (40.96 cm); Cal. .34 in. (8.63 mm); Wt. 3 lb. 6.5 oz. (1.55 kg) Rogers Fund, 1904                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/25065 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20537 20537 04.3.55 0 1 25075 Arms and Armor 5 Combination sword with Wheellock pistol 2353 Combination Sword with Wheellock Pistol German, Saxony 193                           ca. 1580 1555 1605 Steel, gold, iron wire 4455 L. 45 1/8 in. (114.62 cm); greatest W. 10 1/2 in. (26.7 cm); blade L. 40 1/2 in. (102.9 cm) ; barrel L. 10 5/8 in. (26.9 cm); Cal. .293 in. (7.44 mm); Wt. 3 lb. 8.4 oz. (1.6 kg) Rogers Fund, 1904       Saxony 127               Combination Weapons 48   http://www.metmuseum.org/art/collection/search/25075 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20548 20548 04.3.77 0 1 25086 Arms and Armor 5 Boar spear with double barrel wheellock pistol 2360 Boar Spear with Double Barrel Wheellock Pistol German 27                           late 16th century 1551 1600 Steel, wood 82 L. 89 3/4 in. (227.96 cm); L. of head 40 1/2 in. (102.9 cm); L. of barrel 12 in. (30.5 cm); W. 4 in. (10.2 cm); Cal. (a) .412 in. (10.47 mm); Cal. (b) .415 in. (10.54 mm); Wt. 9 lbs. 6 oz. (4252.4 g) Rogers Fund, 1904                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/25086 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20560 20560 2002.174a, b 0 1 25098 Arms and Armor 5 Combination axe-pistol 2361 Combination Axe-Pistol of Grand Duke Ferdinand I de' Medici (1549–1609) German 27                           ca. 1580 1555 1605 Steel, gold 3497 Length: 27 3/4 in. (70 cm) Purchase, Arthur Ochs Sulzberger Gift, 2002                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/25098 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22164 22164 14.25.451 0 1 27056 Arms and Armor 5 Boar spear with double barrel wheellock pistol 2360 Boar Spear with Double Barrel Wheellock Pistol German, Saxony 193                           ca. 1575 1550 1600 Steel, gold 3497 L. 77 in. (195.6 cm); L. of head 21 5/8 in. (43.97 cm); L. of barrel 9 9/16 in. (24.3 cm); Cal. (a) .406 in. (10.31 mm); Cal. (b) .412 in.(10.47 mm); Wt. 8 lbs. 1.3 oz. (3665.6 g) Gift of William H. Riggs, 1913       Saxony 127               Combination Weapons 48   http://www.metmuseum.org/art/collection/search/27056 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22951 22951 14.25.1147 0 0 27926 Arms and Armor 5 Combination sword and wheellock pistol 2860 Combination Sword and Wheellock Pistol German, Saxony 193                           ca. 1575 1550 1600 Steel, wood, shark skin 5248 L. 43 1/2 in. (110.5 cm); blade L. 37 1/2 in. (95.3 cm); barrel L. 10 1/2 in. 926.7 cm); Cal. .282 in. (7.16 mm); Wt. 3 lb. 5 oz. (1.5 kg) Gift of William H. Riggs, 1913       Saxony 127               Combination Weapons 48   http://www.metmuseum.org/art/collection/search/27926 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25406 25406 36.25.2105a, b 0 0 30558 Arms and Armor 5 Knife and flintlock pistol combined 3043 Knife and Flintlock Pistol Combined Turkish 68                           18th century 1701 1800 Steel, silver, wood (walnut), gold 5767 L. 18 3/4 in. (47.6 cm); blade L. 11 1/4 in. (28.6 cm) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30558 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25407 25407 36.25.2106a, b 0 0 30559 Arms and Armor 5 Ramrod for pistol with concealed knife 3044 Ramrod for Pistol with Concealed Knife Turkish 68                           19th century 1801 1900 Silver 2 L. 15 3/4 in. (40.0 cm) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30559 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25408 25408 36.25.2107a, b 0 0 30560 Arms and Armor 5 Combination poignard and pistol ramrod 3045 Combination Poignard and Pistol Ramrod Caucasian 64                           18th–19th century 1701 1900 Steel, silver, chern 5768   Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30560 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25409 25409 36.25.2109 0 0 30561 Arms and Armor 5 Combination pistol and pike head 3046 Combination Pistol and Pike Head Indian 67                           19th century 1801 1900 Steel, diamond 5769 L. overall 14 1/2 in. (36.8 cm); L. barrel 4 7/16 in. (11.3 cm); L. blade 4 15/16 in. (12.5 cm); bore 14 mm; wt. 399 g Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30561 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25410 25410 36.25.2110 0 0 30562 Arms and Armor 5 Combination pistol and pike head 3046 Combination Pistol and Pike Head Indian 67                           19th century 1801 1900 Steel, diamond 5769 L. 12 1/8 in. (30.8 cm) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30562 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25411 25411 36.25.2111 0 0 30563 Arms and Armor 5 Combination matchlock gun and axe 3047 Combination Matchlock Gun and Axe Indian 67                           19th century 1801 1900 Steel 658 L. overall 22 1/8 in. (55.9 cm); L. barrel 10 5/16 in. (26.2 cm); L. blade 10 in. (25.4 cm); Bore 15 mm, 12 mm; Wt. 1217 g Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30563 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25412 25412 36.25.2112 0 0 30564 Arms and Armor 5 Combination pistol and axe 3048 Combination Pistol and Axe Indian 67                           18th–19th century 1701 1900 Iron 13 L. overall 23 3/8 in. (59.4 cm); L. barrel 11 5/8 in. (29.5 cm); Bore 17 mm; Wt. 1756 g Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30564 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25413 25413 36.25.2113 0 0 30565 Arms and Armor 5 Combination mace (Sonta) and matchlock pistol 3049 Combination Mace (Sonta) and Matchlock Pistol Indian 67                           19th century 1801 1900 Iron 13 L. 28 1/9 in. (71.4 cm); barrel L.12 1/19 in. (30.6 cm); Bore 13/24 in. (13.7 mm); Wt. 2 lb. 4.6 oz. (1037 g) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30565 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25414 25414 36.25.2114 0 0 30566 Arms and Armor 5 Combination matchlock pistol and axe 3050 Combination Matchlock Pistol and Axe Indian 67                           19th century 1801 1900 Steel 658 L. 14 in. (35.6 cm); L. barrel 7 3/4 in. (19.7 cm); Bore 16 mm; Wt. 884 g Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30566 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25415 25415 36.25.2115 0 0 30567 Arms and Armor 5 Combination pistol and whip 3051 Combination Pistol and Whip Indian 67                           19th century 1801 1900 Steel, leather, linen, silk 5770 L. 46 1/2 in. (118.1 cm); Bore 14.5 mm; Wt. 634 g Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30567 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25416 25416 36.25.2117 0 0 30568 Arms and Armor 5 Combination sword (Talwar) and double pistols 3052 Combination Sword (Talwar) and Double Pistols Indian 67                           19th century 1801 1900 Steel, silver, gold 3810 L. overall 37 in. (94.0 cm); L. blade 32 in. (81.3 cm); L. of barrel 2 7/8 in. (7.3 cm); Bore 9 mm; Wt. 1203 g Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30568 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25417 25417 36.25.2118 0 0 30569 Arms and Armor 5 Combination axe and matchlock pistol 3053 Combination Axe and Matchlock Pistol Indian, south India 813                           16th–17th century 1501 1700 Steel 658 L. overall 33 in. (83.8 cm); L. of barrel 15 1/4 in. (38.7 cm); Bore 11 mm; Wt. 2006 g Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30569 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
25419 25419 36.25.2120 0 0 30571 Arms and Armor 5 Hand cannon 1422 Hand Cannon Cambodian 333                           19th century 1801 1900 Wood, unidentified metal 5771 L. overall 13 in. (33.0 cm) , barrels 3 3/4 in. (9.5 cm), bore 5/8 in. (1.6 cm) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30571 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25420 25420 36.25.2121 0 0 30572 Arms and Armor 5 Cannon (Lantaka) 2846 Cannon (Lantaka) Malayan 399                           18th–19th century 1701 1900 Bronze 23 L. 25 3/4 in. (65.4 cm); W. 5 in. (12.7 cm); Wt. 14 lb. 5.7 oz. (6511.9 g) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30572 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25421 25421 36.25.2122 0 0 30573 Arms and Armor 5 Cannon (Lantaka) 2846 Cannon (Lantaka) Malayan 399                           18th–19th century 1701 1900 Bronze 23 L. 34 in. (86.3 cm) Bequest of George C. Stone, 1935                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/30573 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28643 28643 14.25.1319 0 0 33835 Arms and Armor 5 Combination mace and wheellock pistol 3617 Combination Mace and Wheellock Pistol German (Saxon) 589                           ca. 1550 1525 1575 Steel, velvet 3636 L. 21 5/8 in. (54.9 cm); Cal. .37 in. (9.39 mm); Wt. 3 lb. 4 oz. (1.47 kg) Gift of William H. Riggs, 1913                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/33835 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28647 28647 14.25.1324 0 0 33839 Arms and Armor 5 Combination mace and wheellock pistol 3617 Combination Mace and Wheellock Pistol German 27                           16th century 1501 1600 Steel 658 L. 23 1/4 in. (59.1 cm); mace head L. 6 1/2 in. (16.5 cm); barrel L. 13 5/16 in. (33.8 cm); Cal. .453 in. (11.5 mm); Wt. 4 lb. 6.5 oz. (2 kg) Gift of William H. Riggs, 1913   Nurmeberg 676                   Combination Weapons 48   http://www.metmuseum.org/art/collection/search/33839 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28662 28662 14.25.1343 0 0 33854 Arms and Armor 5 Combination war hammer and matchlock pistol 3618 Combination War Hammer and Matchlock Pistol Italian 36                           16th century 1501 1600 Steel, leather 3500 L. 26 3/4 in. (67.9 cm); barrel L. 20 1/8 in. (51.1 cm); Cal. .616 in. (15.65 mm); Wt. 2 lb 10 oz. (1.2 kg) Gift of William H. Riggs, 1913                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/33854 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28664 28664 14.25.1346 0 0 33856 Arms and Armor 5 Combination wr hammer and wheellock pistol 3619 Combination War Hammer and Wheellock Pistol Italian 36                           1591 1591 1591 Steel, wood, brass 3791 L. 19 9/16in. (49.69 cm); barrel L. 13 3/8 in. (33.97 cm); Cal. .509 in. (12.93 mm); Wt. 3 lb. 15.5 oz. (1.8 kg) Gift of William H. Riggs, 1913                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/33856 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28669 28669 14.25.1359 0 0 33861 Arms and Armor 5 Combination battle axe and wheellock pistol 3621 Combination Battle Axe and Wheellock Pistol German 27                           16th century 1501 1600 Steel 658 L. 22 in. (55.88 cm); barrel L. 14 1/8 in. (35.88 cm); Cal. .458 in. (11.63 mm); Wt. 2 lb. 1.51 oz. (.95 kg) Gift of William H. Riggs, 1913                       Combination Weapons 48   http://www.metmuseum.org/art/collection/search/33861 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28869 28869 29.158.644 0 0 34068 Arms and Armor 5 Combination sword blade and pistol barrel 3664 Combination Sword Blade and Pistol Barrel German, Augsburg 126                           16th century 1501 1600 Steel 658 L. 36 1/4 in. (92.1 cm); L. of barrel 13 1/2 in. (34.3 cm); L. of blade 30 7/8 in. (78.4 cm); Cal. 23/64 in (9 mm) Bashford Dean Memorial Collection, Funds from various donors, 1929   Augsburg 424                   Combination Weapons 48   http://www.metmuseum.org/art/collection/search/34068 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30302 30302 14.25.1280 0 1 35887 Arms and Armor 5 Combination weapon 3866 Combination Dagger and Wheellock Pistol German, possibly Saxony 202                           ca. 1575–1600 1550 1625 Steel, wood 82 L. 18 15/16 in. (48.1 cm); L. of blade 13 13/16 in. (35.1 cm); L. of blade (without tip) 11 11/16 in. (29.7 cm); L. of quillons 4 1/4 in. (10.8 cm); Cal. .29 in. (7.4 mm); Wt. 1 lb. 11 oz. (765.4 g) Gift of William H. Riggs, 1913       possibly Saxony 128               Combination Weapons 48   http://www.metmuseum.org/art/collection/search/35887 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 131.029ms · Data license: CC0 · Data source: metmuseum/openaccess