MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

14 rows where "Artist Begin Date" is on date -4708-11-11 and Department = 5 sorted by Artist Nationality

View and edit SQL

Suggested facets: Is Highlight, Is Public Domain, Object Name, Culture, Artist Role, Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist End Date, Object Begin Date, Object End Date, Medium, Credit Line, City, County, Classification

Department

  • Arms and Armor · 14

Artist Begin Date (date)

  • -4708-11-11 · 14
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
383914 19.53.82a–f 0 0 633417 Arms and Armor 5 Six-shot pepperbox detonator pistol with case and accessories 26618 Six-Barreled Pepperbox Disc Primer Pistol with Case and Accessories British, Birmingham 398         Gunsmith 96   Joseph Rock Cooper British, Birmingham 1814–1882 Warwickshire   Cooper, Joseph Rock 49371   1814 1882 ca. 1840–60 1835 1865 pistol: steel, silver, wood (walnut); case: wood (mahogany), brass, textile; powder flask: copper, gold, brass, steel; ram rod: brass, steel; bullet mold: steel; cylinder container: tin (?), lacquer 58196 Pistol (a); L. 8 in. (20.3 cm); L. of barrel 2 7/8 in. (7.3 cm); Cal. .35 in. (8.9 mm); Wt. 1 lb. 7 oz. (652 g); powder flask (b); H. 3 1/8 in. (7.9 cm); Wt. 3.4 oz. (96.4 g); ramrod (c); L. 4 1/4 in. (10.8 cm); Wt. 2.2 oz. (62.4 g); bullet mould (d); L. 4 7/16 in. (11.3 cm); Wt. 1.4 oz. (39.7 g); cylinder with contents (e); H. 1 5/8 in. (4.1 cm); Diam. 1 9/16 in. (4 cm); Wt. 2.8 oz. (79.4 g); case (f); H. 1 3/4 in. (4.5 cm); W. 10 1/8 in. (25.7 cm); D. 7 5/16 in. (18.6 cm); Wt. 1 lb. 2.4 oz. (521.6 g) Gift of Charles M. Schott Jr., 1917   Birmingham 86                   Firearms-Pistols 38   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

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