MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

29 rows where Classification = 93

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Nationality, Object Begin Date, Object End Date, Medium, Credit Line, City

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
17868 14.25.1397 0 1 22379 Arms and Armor 5 Wheellock rifle 1341 Wheellock Rifle German, Munich 128         Stock maker|Steel-chiseler 114   Hieronymus Borstorffer|Daniel Sadeler German, Munich, recorded 1597–1637|German, Munich, recorded 1602–1632   Borstorffer, Hieronymus|Sadeler, Daniel 2729 German|German 79 1597 |1602 1637 |1632 ca. 1610–30 1585 1655 Steel, gold, wood (ebony, fruitwood), ivory, horn 3661 L. 42 3/8 in. (107.6 cm); L. of barrel 30 7/8 in. (78.4 cm); Cal. .56 in. (14.2 mm); Wt. 8 lb. 13 oz. (4000 g) Gift of William H. Riggs, 1913   Munich 426                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
17877 14.25.1432a, b 0 1 22388 Arms and Armor 5 Pair of wheellock pistols 1319 Pair of Wheellock Pistols Dutch, Maastricht 209                           ca. 1655–65 1630 1690 Steel, brass, gold, ivory 3670 L. of 14.25.1432a: 22 1/2 in. (57.2 cm); L. of 14.25.1432b: 22 3/4 in. (57.8 cm); L. of each barrel 14 7/8 in. (37.8 cm); Cal. of each barrel .53 in. (13.5 mm); Wt. of each 2 lb. 3 oz. (992 g) Gift of William H. Riggs, 1913   Maastricht 455                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
18493 27.203 0 1 23015 Arms and Armor 5 Double-barreled flintlock shotgun 1789 Double-Barreled Flintlock Shotgun French, Paris 114         Gunsmith|Barrelsmith 97   François Pirmet|Jean Le Clerc French, Paris, recorded 1779–1818|French, Paris, recorded 1807–10   Pirmet, François|Le Clerc, Jean 2777 French|French 21 1779 |1807 1818 |1810 dated 1809 1809 1809 Steel, wood (walnut), silver, gold 3866 L. 48 in. (121.9 cm); L. of barrel 32 1/2 in. (82.6 cm); L. of lock 5 1/4 in. (13.3 cm); Cal. .59 in. (15.1 mm); Wt. 6 lb. 10 oz. (3000 g) Rogers Fund, 1927   Paris 27                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
19426 36.58a–e 0 1 23950 Arms and Armor 5 Double-barreled flintlock shotgun 1789 Double-Barreled Flintlock Shotgun French, Versailles 286         Gunsmith 96   Nicolas Noël Boutet French, Versailles and Paris, 1761–1833   Boutet, Nicholas-Noël 2822 French 2 1761 1833 dated 1801 1801 1801 Steel, wood (walnut, ebony), gold, silver 3997 L. 48 3/8 in. (122.9 cm); L. of barrel 33 in. (83.8 cm); Cal. .60 in. (15.2 mm); Wt. 7 lb. 6 oz. (3350 g) Rogers Fund, 1936   Versailles 492                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
19965 36.25.2227 0 1 24490 Arms and Armor 5 Flintlock blunderbuss 2158 Flintlock Blunderbuss Indian, Seringapatam 330                           dated Mauludi era 1222/A.D. 1793–94 1793 1794 Steel, wood, gold, silver 4187 L. 37 1/2 in. (95.3 cm); L. of barrel 21 1/8 in. (53.8 cm); Cal. 1.75 (53.8 cm) Wt. 6 lb. 4 oz. (2831 g) Bequest of George C. Stone, 1935   Seringapatam 500                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
19966 36.25.2231 0 0 24491 Arms and Armor 5 Matchlock gun to percussion conversion 2159 Matchlock Gun to Percussion Conversion Japanese 35                           ca. 1615–1868 1590 1900 Wood, brass 474 L. 41 1/2 in. (105.4 cm); L. of barrel 28 in. (71.1 cm); Cal. .60 in. (15.2 mm); Wt. 8 lb. 14.9 oz. (1216.2 g) Bequest of George C. Stone, 1935                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
20139 38.116a–k 0 1 24666 Arms and Armor 5 Flintlock rifle with case and bullet mould 2217 Flintlock Rifle with Case and Bullet Mould Made for Colonel Jacob Bates (1746–1836) American, Shrewsbury, Massachusetts 338         Gunsmith 96   Silas Allen Jr. American, Shrewsbury, Massachusetts, 1785–1868   Allen Silas 2860 American 1 1785 1868 ca. 1820 1795 1845 Steel, silver, brass, wood, silver wire 4282 Rifle (a); L. 55 3/4 in. (141.61 cm); L. of barrel 40 1/2 in. (102.87 cm); Cal. .51 in. (12.7 mm); Wt. 11 lb. 2 oz. (5046 g); bullet mould (c); L. 6 1/4 in. (15.9 cm); Wt. 5.6 oz. (158.8 g) Gift of Christian A. Zabriskie, 1938   Shrewsbury 503   Massachusetts 169               Firearms 93   Metropolitan Museum of Art, New York, NY 1
20157 42.50.7a–n 0 1 24684 Arms and Armor 5 Double-barreled flintlock shotgun with exchangeable percussion locks and barrels 2223 Double-Barreled Flintlock Shotgun with Exchangeable Percussion Locks and Barrels French, Versailles and Paris 342         Barrelsmith|Gunsmith|Lock maker|Retailer 138 Exchangeable percussion barrels by|Exchangeable percussion locks by|Exchangeable percussion locks and barrels originally sold by Léopold Bernard|Nicolas Noël Boutet|B. Montagnon|G. Zaoué French, Paris, active 1832–70|French, Versailles and Paris, 1761–1833|French, active ca. 1850|French, active 1857–61   Bernard, Léopold|Boutet, Nicholas-Noël|Montagnon, B.|Zaoué, G. 2864 French|French|French|French 95 1832 |1761 |1825 |1857 1870 |1833 |1875 |1861 ca. 1818–20; exchangeable percussion locks and barrels, dated 1860 1793 1860 Steel, gold, wood (walnut), silver, horn 4291 L. of gun 47 3/8 in. (120.3 cm); L. of double barrel 31 7/8 in. (81.0 cm); L. of percussion locks 5 in. (12.7 cm); L. of bullet pouch 7 1/4 in. (18.4 cm); L. of priming flask 6 5/8 in. (16.8 cm); L. of bullet mold 6 3/4 in. (17.1 cm); L. of ramrod extension 10 3/8 in. (26.4 cm); L. of hammer extractor 2 3/16 in. (5.6 cm); L. of brush for cleaning barrel 2 13/16 in. (7.1 cm); L. of bullet extractor 1 5/16 in. (3.3 cm); L. of screwdriver 6 in. (15.2 cm); L. of bullet extractor 3 1/8 in. (7.9 cm); L. of touch hole cleaner 3 3/16 in. (8.1 cm); Cal. .61 in. (15.5 mm); Wt. of gun 6 lbs. 15 oz. (3150 g); Wt. of double barrel 3 lbs. 8 oz. (1600 g); Wt. of percussion locks 5 oz. (150 g); Wt. of bullet pouch 2.5 oz. (71 g); Wt. of priming flask 4.6 oz. (131 g); Wt. of bullet mold 7 oz. (198 g) Gift of Stephen V. Grancsay, 1942   Versailles and Paris 507                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20162 42.50.8 0 1 24689 Arms and Armor 5 Wheellock rifle 1341 Wheellock Rifle German, Schwäbisch Gmünd 265         Maker 1   Johann Michael Maucher German, Schwäbisch Gmünd, 1645–1701   Maucher, Johann Michael 2866 German 10 1670 1701 ca. 1680–90 1655 1715 Steel, wood (cherry), ivory, mother-of-pearl 4294 L. 41 5/8 in. (105.7 cm); L. of barrel 30 13/16 in. (78.3 cm); L. of lock 7 1/8 in. (18.1 cm); Cal. .56 in. (14.2 mm); Wt. 7 lb. 11 oz. (3500 g) Gift of Stephen V. Grancsay, 1942   Schwäbisch Gmünd 482                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20251 46.105 0 1 24779 Arms and Armor 5 Snaphance flintlock pistol 2237 Snaphance Flintlock Pistol Made for Wilhelm, Duke of Kurland Scottish 41                           dated 1615 1615 1615 Steel, gold, silver, wood (brazilwood) 4316 L. 19 3/4 in. (50.2 cm); L. of barrel 12 1/2 in. (31.8 cm); Cal. .38 in. ( 9.7 mm); Wt. 2 lb. 5 oz. (1050 g) Gift of Mrs. Alexander McMillan Welch, in memory of Alexander McMillan Welch, 1946                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
20282 49.163.5 0 1 24811 Arms and Armor 5 Carbine 2247 Carbine with Flintlock alla Fiorentina Italian, Brescia 125         Steel-chiseler|Barrelsmith 142   Carlo Bottarelli|Giovanni Lazzarino Cominazzo Italian, Brescia, active ca. 1660–90|Italian, Brescia, active mid-17th century   Bottarelli, Carlo|Cominazzo, Giovanni Lazzarino 2893 Italian|Italian 93 1635 |1625 1715 |1675 ca. 1660–70 1635 1695 Steel, wood (walnut) 3526 L. 37 3/4 in. (95.9 cm) Gift of Alan Rutherfurd Stuyvesant, 1949   Brescia 423                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20340 1974.4 0 1 24869 Arms and Armor 5 Flintlock gun 2157 Flintlock Gun German 27         Designer 5 Decoration follows closely designs of the engraver De Lacollombe French, Paris, active ca. 1702–ca. 1736   Lacollombe, De 2906 French 2 1702 1736 ca. 1730–40 1705 1765 Steel, silver, wood (walnut) 4332 L. 56 3/8 in. (143.2 cm); L. of barrel 41 1/16 in. (104.3 cm); L. of lockplate 5 7/8 in. (14.9 cm), Cal. .62 in. (15.8 mm); Wt. 6 lb. 10 oz. (3005 g) Purchase, Bashford Dean Bequest, James Elwood Jones Jr. Gift, and Rogers and Fletcher Funds, 1974                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
20396 1987.274 0 1 24929 Arms and Armor 5 Flintlock gun 2157 Flintlock Gun French, Saint-Etienne 380         Steel-chiseler|Barrelsmith|Stock maker 149   Louis Jaley|Nicolas Carteron|Joseph Blachon French, Saint-Étienne 1696–1773|French, Saint-Étienne, recorded ca. 1733–63|French, Saint-Étienne, recorded ca. 1725–35   Jaley, Louis|Carteron, Nicolas|Blachon Joseph 2917 French|French|French 103 1696 |1708 |1700 1773 |1788 |1760 dated 1735 1735 1735 Steel, gold, wood, silver 4381 L. 57 1/2 in. (146.1 cm); L. of barrel 41 7/8 in. (106.5 cm); caliber .62 in. (15.5 cm) Harris Brisbane Dick and Rogers Funds, 1987   Saint-Etienne 525                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20397 1987.397 0 1 24930 Arms and Armor 5 Flintlock gun 2157 Gun with Flintlock a la moda Spanish, Madrid 228         Gunsmith 96   Gabriel de Algora Spanish, Madrid, documented 1733–died 1761   Algora, Gabriel de 2776 Spanish 76 1733 1761 dated 1744 1744 1744 Steel, gold, wood 3520 L. of barrel 38 3/4 in. (98.4 cm) Purchase, Gifts of George D. Pratt, Charles M. Schott Jr., and Bashford Dean, and Bashford Dean Memorial Collection, Funds from various donors, by exchange, 1987   Madrid 467                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20409 1990.114.1 0 1 24942 Arms and Armor 5 Flintlock gun 2157 Flintlock Gun French, Paris 114         Barrelsmith|Gunsmith 150   Le Faure|Mollier French, Paris, active ca. 1750–90|French, Paris, active ca. 1750   Le Faure|Mollier 2922 French|French 21 1725 |1725 1815 |1775 ca. 1750 1725 1775 Steel, gold, wood (walnut), silver 3859 L. 58 in. (147.3 cm) Purchase, Annie Laurie Aitken Charitable Trust Gift, 1990   Paris 27                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20410 1990.114.2 0 1 24943 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Made for Charles XI of Sweden (1655–1697) French, Paris 114         Gunsmith 96   Bertrand Piraube French, Paris, recorded ca. 1663–1725   Piraube, Bertrand 2923 French 2 1638 1750 dated 1676 1676 1676 Steel, gold, wood (walnut) 3881 L. 21 in. (53.3 cm) Purchase, Annie Laurie Aitken Charitable Trust Gift, 1990   Paris 27                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20413 1991.5 0 1 24946 Arms and Armor 5 Double-barreled percussion shotgun 2303 Double-Barreled Percussion Shotgun French, Paris 114         Barrelsmith|Gunsmith 150   Léopold Bernard|Louis Perrin French, Paris, active 1832–70|French, Paris, active 1823–65   Bernard, Léopold|Perrin Louis 2925 French|French 21 1832 |1823 1870 |1865 dated 1854 1854 1854 Steel, wood (walnut), silver 4389 L. 46 3/5 in. (118.4 cm); L. of barrel 29 1/8 in. (73.9 cm) Purchase, Rogers Fund, The Sulzberger Foundation Inc. Gift, Gifts of William H. Riggs, Bill and Joyce Anderson, Charles M. Schott Jr., Mr. and Mrs. Robert W. de Forest, William B. Osgood Field, Christian A. Zabriskie, Dr. Albert T. Weston, Henry Victor Burgy, and Bequest of Alan Rutherfurd Stuyvesant, by exchange, and The Collection of Giovanni P. Morosini, presented by his daughter Giulia, John Stoneacre Ellis Collection, Gift of Mrs. Ellis and Augustus Van Horne Ellis, and Bashford Dean Memorial Collection, funds from various donors, by exchange, 1991   Paris 27                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20419 1992.330.1, .2 0 1 24952 Arms and Armor 5 Pair of flintlock pistols 1316 Pair of Flintlock Pistols British, London 222         Gunsmith|Silversmith 152 Attributed to Samuel Brunn|Michael Barnett English, London, recorded 1795–1820|English, London, 1758–ca. 1823   Brunn, Samuel|Barnett, Michael 2927 British|British 9 1795 |1758 1820 |1850 hallmarked for 1800–1801 1800 1801 Steel, wood (walnut), silver, gold 3866 L. of each pistol 16 in. (40.6 cm); L. of each barrel 10 1/8 in. (25.7 cm); Cal. of each pistol .603 in. (15.3 mm) Purchase, Harris Brisbane Dick Fund and Gift of George D. Pratt, by exchange, 1992   London 14                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
20500 91.1.907 0 1 25037 Arms and Armor 5 Flintlock Gun 2321 Flintlock Gun Sri Lankan 407                           18th century 1701 1800 Iron, wood, ivory, silver 4437 L. 87 1/4 in. (221.6 cm); L. of barrel 73 3/4 in. (187.3 cm); Cal. .54 in. (13.7 mm); Wt. 11 lb. 2 oz. (5046 g) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
21035 10.99 0 0 25636 Arms and Armor 5 Flintlock rifle 1909 Flintlock Boar Rifle German 27                           mid-18th century 1725 1775 Steel, wood (walnut), bronze, brass, copper, silver, gold 4609 L. 44 in. (111.8 cm); L. of barrel 29 3/8 in. (74.6 cm); Cal. .562 in. (14.3 mm); Wt. 8 lb. 9.6 oz. (3900.9 g) Rogers Fund, 1910                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
21045 11.204.1a, b 0 0 25646 Arms and Armor 5 Pair of pistol barrels 2424 Pair of Pistol Barrels German, Munich 128                           1610–32 1610 1632 Steel 658 L. of each 11 1/4 in. (28.6 cm); Cal. of barrel (a) .49 in. (12.5 mm); Cal. of barrel (b) .49 in. (12.5 mm); Wt. of each 14.1 oz. (399.7 g) Rogers Fund, 1911   Munich 426                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
21723 1997.356 0 1 26554 Arms and Armor 5 Snaphaunce hunting rifle 2519 Snaphaunce Hunting Rifle Swedish, Stockholm 488         Stock maker 156 Signed by Jonas Schertiger the Younger Swedish, active 1715–died 1748   Schertiger, Jonas the Younger 2979 Swedish 31 1715 1748 dated 1722 1722 1722 Steel, wood (walnut), brass, horn 4766 L. 43 3/8 in. (117.8 cm) Purchase, Gifts of Prince Albrecht Radziwill and Charles M. Schott Jr., by exchange, and Rogers Fund, 1997   Stockholm 558                   Firearms 93   Metropolitan Museum of Art, New York, NY 1
21729 1998.464 0 0 26560 Arms and Armor 5 Breech-loading needlefire rifle 2521 Breech-Loading Needlefire Rifle German, Köthen 490         Gunsmith 96   R. Berger German, active ca. 1844–1870   Berger R. 2984 German 10 1844 1870 mid-19th century 1825 1875 Steel, wood, horn 4770 L. 46 1/4 in. (117.5 cm) Gift of Eric Vaule, in memory of Anne Lyman Vaule, 1998   Köthen 560   Saxony-Anhalt 208               Firearms 93   Metropolitan Museum of Art, New York, NY 1
21757 2002.560 0 1 26591 Arms and Armor 5 Hand cannon (chong) 2536 Hand Cannon (Chong) Chinese 10                           dated 1424 1424 1424 Bronze 23 L. 14 1/16 in. (35.7 cm); Cal. .59 in. (15 mm); Wt. 5 lb. 0.2 oz. (2273.6 g) Purchase, Arthur Ochs Sulzberger Gift, 2002                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
21759 2001.34 0 0 26593 Arms and Armor 5 Miniature votive musket 2538 Miniature Votive Musket Tibetan 309                           17th–19th century 1601 1900 Iron, gold, silver, wood, pigments, horn, leather 4789 L. with prong-rest extended 18 1/4 in. (46.4 cm); L. with prong-rest folded 14 1/8 in. (35.9 cm); L. of barrel 6 3/4 in. (17.1 cm); Cal. .28 in. (7 mm) Purchase, Arthur Ochs Sulzberger Gift, 2001                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
21765 2001.62 0 0 26599 Arms and Armor 5 Musket barrel 2543 Musket Barrel Tibetan 309                           18th–19th century 1701 1900 Iron, gold, silver 3614 L. 46 1/8 in. (117.2 cm); Cal. .65 in. (17 mm) Purchase, Arthur Ochs Sulzberger Gift, 2001                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
22564 51.141 0 0 27475 Arms and Armor 5 Model of wheellock rifle 2739 Model of Wheellock Rifle German 27                           ca. 1700 1700 1700 Steel, wood, ivory, mother-of-pearl, silver 5078 L. 5 1/4 in. (13.3 cm); L. of barrel 3 3/8 in. (8.6 cm); Cal. .13 in. (3.3 mm); Wt. 1 1/4 oz.. (35.4 g) Rogers Fund, 1951                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
22647 55.218 0 1 27558 Arms and Armor 5 Double-barreled shotgun 2765 Double-barreled Shotgun French 7         Barrelsmith|Gunsmith|Gunsmith 160   Antoine Giraud|Nicolas Bouillet|Jean François Brunon French, active ca. 1760–80|French, Paris, recorded 1776–1800|French, St. Etienne, born 1737–recorded until 1784   Giraud, Antoine|Bouillet, Nicolas|Brunon, Jean François 3022 French|French|French 103 1735 |1776 |1737 1805 |1800 |1784 dated 1784, converted to percussion locks ca. 1840–50 1784 1875 Steel, wood 82 L. of barrel 34 in. (86.4 cm); Cal. .58 in. (14.7 mm); Wt. 6 lb. 1 oz. (2750 g) Rogers Fund, 1955                       Firearms 93   Metropolitan Museum of Art, New York, NY 1
29081 29.156.1 0 0 34287 Arms and Armor 5 Falconet with laffette 3739 Falconet with Laffette Austrian 184                           1650 1650 1650 Bronze, wood (ash), iron, paint 6979 L. 102 1/2 in. (259.1 cm); L. of falconet 52 in. (132.1 cm); Cal. 1.5 in. (39 mm); Diam. of muzzle 2 3/4 in. (6.9 cm); Diam. of breech 4 1/2 in. (11.4 cm); Wt. of barrel 146 lb. (66.22 kg); L. of carriage 79 in. (200.7 cm); W. of carriage 43 in. (109.2 cm); Wt. of carriage 140 lb. (63.5 kg) Bashford Dean Memorial Collection, Gift of Edward S. Harkness, 1929                       Firearms 93   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 141.089ms · Data license: CC0 · Data source: metmuseum/openaccess