MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

20 rows where Classification = 52

✎ View and edit SQL

This data as json, CSV (advanced)

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

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
17467 17467 04.3.182 0 0 21969 Arms and Armor 5 Combined wheellock/matchlock gun 1343 Combined Wheellock/Matchlock Gun German, Suhl 132         Gunsmith 96 Attributed to Stephan Klett German, Suhl, recorded 1578–1612   Klett, Stephan 2692 German 10 1578 1612 ca. 1580 1555 1605 Steel, gold, silver, staghorn, wood 3531 L. 51 3/16 in. (130 cm); Cal. .57 in. (14.5 mm); L. of barrel 39 1/4 in. (99.7 cm); L. of lockplate 10 1/2 in. (26.7 cm); Wt. 11 lb. 8 oz. (5216 g) Rogers Fund, 1904   Suhl 429                   Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/21969 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17865 17865 14.25.1380 0 1 22376 Arms and Armor 5 Wheellock carbine 1529 Wheellock Carbine French 7                           ca. 1610–15 1585 1640 Steel, wood (beech), brass, gold, pigment, staghorn 3658 L. 38 3/8 in. (97.5 cm); Cal. .50 in. (12.7 mm); L. of barrel 24 7/16 in. (62.1 cm); L. of lockplate 5 7/8 in. (14.9 cm); L. of plug 2 1/2 in. (63.5 mm); Diam. near muzzle 13/16 in. (20.6 mm); Diam. near breech 1 in. (25.4 mm); Wt. 4 lb. 15 oz. (2240 g) Gift of William H. Riggs, 1913                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/22376 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17866 17866 14.25.1387 0 0 22377 Arms and Armor 5 Wheellock rifle 1341 Wheellock Rifle South German 189                           ca. 1610 1585 1635 Steel, wood, ivory 3659 L. 41 7/8 in. (106.4 cm); L. of barrel 31 7/8 in. (81 cm); Cal. .61 in. (15.5 mm); Wt. 7 lb. 8 oz. (3402 g) Gift of William H. Riggs, 1913                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/22377 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17980 17980 14.100.102 0 0 22493 Arms and Armor 5 Model gun 1581 Model Miniature Gun (Netsuke) Japanese 35                           18th century 1700 1799 Iron, wood 473 L. 2 1/16 in. (5.23 cm) Gift of Bashford Dean, 1914                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/22493 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17981 17981 14.100.103 0 0 22494 Arms and Armor 5 Model gun 1581 Miniature Model Gun Used as a Netsuke Japanese 35                           18th century 1701 1800 Iron, wood, brass, silver 3708 L. 2 3/8 in. (6.1 cm). Gift of Bashford Dean, 1914                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/22494 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20436 20436 2013.901 0 0 24970 Arms and Armor 5 Rifle 2317 Winchester Model 1894 Takedown Lever Action Rifle American, New Haven, Connecticut and New York 388         Manufacturer|Decorator 61   Winchester Repeating Arms Company|Tiffany & Co. American, New Haven, Connecticut, founded 1866|1837–present   Winchester Repeating Arms Company|Tiffany & Co. 2934 American 1 1866 |1837 9999 ca. 1895–1900 1870 1925 Steel, wood (Makassar ebony), silver 4404 L. 44 in. (111.8 cm); Cal. .30 in. (8 mm); Wt. 9 lb. 2 oz. (4139 g) Purchase, The Beatrice G. Warren and Leila W. Redstone Fund, 2013   New Haven|New York 529   Connecticut|New York 182               Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/24970 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22421 22421 1972.44 0 0 27325 Arms and Armor 5 Snaphaunce revolving gun 2703 Snaphaunce Revolving Gun German 27                           late 17th century 1650 1700 Steel, wood, brass, horn, bone, paint, lacquer 5033 L. 52 1/4 in. (132.7 cm); L. of barrel 34 7/16 in. (87.5 cm); Cal. .51 in. (13 mm); Wt. 9 lb. 4 oz. (4196 g) Bequest of William G. Renwick, 1972                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/27325 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23966 23966 43.82.1 0 0 28996 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun of Ali Pasha Algerian 590                           dated 1212 (A.D. 1798–99) 1798 1799 Woos, steel, silver, coral 5396 L. 72 3/4 in. (184.8 cm) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/28996 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23967 23967 43.82.2 0 0 28997 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun of Ali Pasha Algerian 590                           dated 1220 (A.D. 1805) 1805 1805 Steel, wood, silver 3496 L. 72 5/8 in. (184.5 cm); cal. 0.67 in. (17 mm) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/28997 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23968 23968 43.82.3 0 1 28998 Arms and Armor 5 Miquelet rifle 1918 Miquelet Rifle of Ali Pasha lock and stock, Algerian; barrel, European 678                           lock and stock, dated A.H. 1224/A.D. 1809–10; barrel, 18th century 1701 1810 Steel, wood, silver, copper alloy, textile 5397 L. 67 in. (170.3 cm); L. barrel 50 7/8 in. (129.2 cm); Cal. .70 in. (18.0 mm); Wt. 10 lb. 9 oz. (4800 g) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/28998 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23969 23969 43.82.4 0 0 28999 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun of Ali Pasha Algerian; barrel, French 679                           dated 1230 (A.D. 1814–15); barrel ca. 1815 1814 1840 Steel, wood, silver, leather 5398 L. 67 in. (170.2 cm); cal. 0.70 in (17.8 mm); Wt. 10 lb. 2 oz. (4593g) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/28999 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23970 23970 43.82.5 0 0 29000 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun of Ali Pasha Balkan 519                           late 18th–early 19th century 1750 1850 Steel, wood, silver, horn, brass, bone, mother-of-pearl, paste ivory, coral 5399 L. 66 1/2 in. (168.9 cm) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/29000 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23971 23971 43.82.6 0 0 29001 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun of Ali Pasha Balkan; lock, Italian 680                           first quarter of the 19th century 1801 1825 Steel, wood, silver, horn, brass, niello 5400 L. 64 7/8 in. (164.8 cm) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/29001 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23972 23972 43.82.7 0 1 29002 Arms and Armor 5 Miquelet rifle 1918 Miquelet Rifle barrel, probably Iranian; lock and stock, Turkish 681                           barrel dated A.H. 1151/A.D. 1738–39; lock dated A.H. 1240/A.D. 1824–25 1738 1825 Steel, wood, silver, gold, copper alloy, textile 5401 L. 61 5/8 in. (156.5 cm); L. barrel 47 3/8 in. (120.4 cm); Cal. .60 in. (15.0 mm); Wt. 11 lb. 3 oz. (5076 g) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/29002 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23973 23973 43.82.8 0 0 29003 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun of Ali Pasha Turkish 68                           early 19th century 1801 1850 Steel, wood, silver, gold 3451 L. 59 in. (149.9 cm) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/29003 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23974 23974 43.82.9 0 0 29004 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun of Ali Pasha Turkish 68                           late 18th–early 19th century 1750 1850 Steel, wood, silver, gold 3451 L. 46 5/8 in. (118.4 cm) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/29004 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
23975 23975 43.82.10 0 0 29005 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun of Ali Pasha Turkish 68                           barrel dated 1217 (A.D. 1802–3) 1803 1803 Steel, wood, silver, gold, bone, horn 5402 L. 47 1/8 in. (119.7 cm) Gift of Mrs. William E. S. Griswold, Mrs. William Sloane and John Sloane, 1943                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/29005 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
24514 24514 37.29.4 0 0 29554 Arms and Armor 5 Detonator gun 2909 Double-Barreled Side-by-Side Tube-Lock Shotgun with Case British, London 222         Barrelsmith|Gunsmith 150   Charles Lancaster|Joseph Manton British, d. 1847|British, Grantham, Lincolnshire 1766–1835 London   Lancaster, Charles|Manton Joseph 3056   1766 1847 |1835 ca. 1819–20 1814 1824 Steel, wood (walnut, mahogany), horn, brass, silver 5460 L. 43 5/8 in. (110.8 cm); L. of barrel 28 1/8 in. (71.4 cm); Cal. of left barrel .709 in. (18 mm); Cal. of right barrel .701 in. (17.8 mm); Wt. 7 lb. 2 oz. (3232 g) Gift of Charles M. Schott Jr., 1917   London 14                   Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/29554 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
24515 24515 37.29.5 0 0 29555 Arms and Armor 5 Needle gun 2910 Double Barrel Needle Gun German 27                           ca. 1840 1815 1865 Steel, wood (walnut), tortoise shell 5461 L. 48 in. (121.9 cm); L. of barrel 31 1/2 in. (80 cm); Cal. .658 in. (16.7 mm); Wt. 7 lb. 1 oz. (3200 g) Gift of Charles M. Schott Jr., 1917   Berlin 120                   Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/29555 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25358 25358 36.25.2233 0 0 30509 Arms and Armor 5 Gun 3035 Gun Philippine, Moro 526                           18th–19th century 1701 1900 Steel, wood 82 L. 2 ft. 6 in. (76.2 cm) Bequest of George C. Stone, 1935                       Firearms-Guns 52   http://www.metmuseum.org/art/collection/search/30509 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 167.748ms · Data license: CC0 · Data source: metmuseum/openaccess