MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

16 rows where Culture = 64 and Object Begin Date = 1801

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Object 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 Metadata Date Repository
18860 18860 32.75.283 0 1 23383 Arms and Armor 5 Priming flask with baldric 1920 Priming Flask with Baldric Caucasian 64                           19th century 1801 1900 Silver, niello, textile 3944 L. of priming flask 7 in. (17.8 cm); L. of belt 37 1/4 in. (94.6 cm); W. of belt 3/4 in. (1.9 cm); Wt. of belt 2.6 oz. (73.7 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Firearms Accessories-Powder Horns 51   http://www.metmuseum.org/art/collection/search/23383 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19209 19209 36.25.2447a, b 0 0 23732 Arms and Armor 5 Cartridge cases 1928 Cartridge Cases Caucasian 64                           19th century 1801 1900 Wood, horn, silver, niello 3952 H. of each including chain 9 3/4 in. (24.8 cm); H. of each excluding chain 4 3/4 in. (12.1 cm); Diam. of each case 11/16 in. (1.7 cm); Wt. of each case set 2.6 oz. (73.7 g) Bequest of George C. Stone, 1935                       Firearms Accessories 92   http://www.metmuseum.org/art/collection/search/23732 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20465 20465 91.1.889 0 1 25000 Arms and Armor 5 Dagger (Qama) 2331 Dagger (Qama) Caucasian 64                           19th century 1801 1900 Steel, ivory, gold, silver 4126 L. 26 3/8 in. (67 cm); L. of blade 20 3/8 in. (51.8 cm); W. 2 1/8 in. (5.4 cm); D. 1 3/8 in. (3.5 cm); Wt. 1 lb. 10.5 oz. (751.3 g) Edward C. Moore Collection, Bequest of Edward C. Moore, 1891                       Daggers 33   http://www.metmuseum.org/art/collection/search/25000 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25360 25360 36.25.2238 0 1 30511 Arms and Armor 5 Miquelet pistol 2163 Miquelet Pistol Caucasian 64                           19th century; grip, dated A.H. 1268/A.D. 1851–2 1801 1900 Steel, silver, ivory, leather, chern 5749 L. 17 3/8 in. (44.1 cm); L. of barrel 12 1/4 in. (31.1 cm); Cal. .54 in (13.7 mm); Wt. 1 lb. 11.5 oz. (779.6 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Miquelet 127   http://www.metmuseum.org/art/collection/search/30511 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25452 25452 36.25.2163 0 0 30604 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun Caucasian 64                           19th century 1801 1900 Steel, wood, brass, ivory, gold, chern 5795 L. 58.5 in. (148.6 cm) Bequest of George C. Stone, 1935                       Firearms-Guns-Miquelet 100   http://www.metmuseum.org/art/collection/search/30604 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25850 25850 36.25.1551a, b 0 0 31002 Arms and Armor 5 Sword (Shashqa) with scabbard 3123 Sword (Shashqa) with Scabbard Caucasian 64                           19th century 1801 1900 Steel, silver, leather, wood 5256 H. with scabbard 39 3/4 in. (101 cm); H. without scabbard 37 in. (94 cm); H. of blade 30 1/4 in. (76.8 cm); W. 2 1/2 in. (6.4 cm); Wt. 1 lb. 8.4 oz. (691.7 g); Wt. of scabbard 15.6 oz. (442.3 g) Bequest of George C. Stone, 1935                       Swords 29   http://www.metmuseum.org/art/collection/search/31002 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25851 25851 36.25.1552a–c 0 0 31003 Arms and Armor 5 Sword (Shashqa) with scabbard and baldric 3160 Sword (Shashqa) with Scabbard and Baldric Caucasian 64                           19th century 1801 1900 Steel, gold, silver, leather 3511 H. with scabbard 40 1/8 in. (101.9 cm); H. without scabbard 36 1/4 in. (92.1 cm); H. of blade 30 3/4 in. (78.1 cm); W. 2 1/4 in. (5.7 cm); Wt. 1 lb. 2.4 oz. (521.6 g); Wt. of scabbard 1 lb. 2.2 oz. (516 g); Wt. of baldric (c) 4.2 oz. (119.1 g) Bequest of George C. Stone, 1935                       Swords 29   http://www.metmuseum.org/art/collection/search/31003 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25853 25853 36.25.1554a, b 0 1 31005 Arms and Armor 5 Sword with scabbard 1325 Sword with Scabbard Caucasian 64                           19th century 1801 1900 Steel, leather, silver, ivory, wood 5964 H. with scabbard 36 3/4 in. (93.3 cm); H. without scabbard 36 7/8 in. (93.7 cm); H. of blade 31 in. (78.7 cm); W. 2 in. (5.1 cm); Wt. 1 lb. 9.7 oz. (728.6 g); Wt. of scabbard 12.7 oz. (360 g) Bequest of George C. Stone, 1935                       Swords 29   http://www.metmuseum.org/art/collection/search/31005 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25854 25854 36.25.1555a, b 0 1 31006 Arms and Armor 5 Sword with scabbard 1325 Sword with Scabbard Caucasian 64                           19th century 1801 1900 Steel, textile, leather, silver 5965 H. with scabbard 39 3/8 in. (100 cm); H. without scabbard 33 3/4 in. (85.7 cm); H. of blade 28 3/4 in. (73 cm); W. 2 in. (5.1 cm); Wt. 1 lb. 1.8 oz. (504.6 g); Wt. of scabbard 8.7 oz. (246.6 g) Bequest of George C. Stone, 1935                       Swords 29   http://www.metmuseum.org/art/collection/search/31006 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
26363 26363 36.25.923a, b 0 1 31515 Arms and Armor 5 Dagger (Kindjal) with sheath 2326 Dagger (Kindjal) with Sheath Caucasian 64                           19th century 1801 1900 Steel, horn, silver, niello 6225 L. with sheath 21 13/16 in. (55.4 cm); L. without sheath 20 1/2 in. (51.4 cm); L. of blade 14 7/8 in. (37.8 cm); W. 2 1/8 in. (5.4 cm); Wt. 15.7 oz. (445.1 g); Wt. of sheath 13.9 oz. (394.1 g) Bequest of George C. Stone, 1935                       Daggers 33   http://www.metmuseum.org/art/collection/search/31515 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
26366 26366 36.25.926a, b 0 1 31518 Arms and Armor 5 Dagger (Kindjal) with sheath 2326 Dagger (Kindjal) with Sheath Caucasian 64                           19th century 1801 1900 Steel, silver, enamel 6228 L. with sheath 21 5/8 in. (54.9 cm); L. without sheath 20 1/2 in. (52.1 cm); L. of blade 15 1/2 in. (39.4 cm); W. 1 9/16 in. (3.4 cm); Wt. 15.4 oz. (436.6 g); Wt. of sheath 12.5 oz. (354.4 g) Bequest of George C. Stone, 1935                       Daggers 33   http://www.metmuseum.org/art/collection/search/31518 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
27116 27116 32.75.284 0 1 32271 Arms and Armor 5 Powder horn 1907 Powder Horn Caucasian 64                           19th century 1801 1900 Steel, silver, horn 4367 L. 6 9/16 in. (16.7 cm); D. 1/4 in. (0.6 cm); Wt. 6.4 oz. (181.4 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Firearms Accessories-Powder Horns 51   http://www.metmuseum.org/art/collection/search/32271 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
27117 27117 32.75.286 0 0 32272 Arms and Armor 5 Powder horn 1907 Powder Horn Caucasian 64                           19th century 1801 1900 Horn, steel 6211 L. 6 in. (15.2 cm); D. 1 in. (2.5 cm); Wt. 6.9 oz. (195.6 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Firearms Accessories-Powder Horns 51   http://www.metmuseum.org/art/collection/search/32272 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
27118 27118 32.75.287 0 1 32273 Arms and Armor 5 Powder charge container 3405 Powder Charge Container Caucasian 64                           19th century 1801 1900 Ivory, leather, textile, silver, niello 6544 H. 5 in. (12.7 cm); L. 7 1/2 in. (19.1 cm); Wt. 14.5 oz. (411.1 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Firearms Accessories 92   http://www.metmuseum.org/art/collection/search/32273 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
27127 27127 32.75.299a–c 0 1 32282 Arms and Armor 5 Sword with sheath 3409 Sword with Sheath Caucasian 64                           19th century 1801 1900 Steel, leather, gold 3643 H. with scabbard 39 7/8 in. (101.3 cm); H. without scabbard 37 5/8 in. (95.6 cm); W. 2 1/2 in. (6.4 cm); Wt. 1 lb. 10.6 oz. (754.1 g); Wt. of scabbard 7.9 oz. (224 g); Wt. of strap (c); 4.2 oz. (119.1 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Swords 29   http://www.metmuseum.org/art/collection/search/32282 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
27581 27581 26.35.9a, b 0 1 32745 Arms and Armor 5 Dagger with sheath 1733 Dagger with Sheath Caucasian 64                           early 19th century 1801 1850 Steel, silver, niello, gold 6687 L. with sheath 21 in. (53.3 cm); L. without sheath 19 15/16 in. (50.6 cm); L. of blade 15 in. (38.1 cm); W. 1 5/16 in. (3.3 cm); D. 1 1/16 in. (2.7 cm); Wt.13.5 oz. (382.7 g); Wt. of sheath 8.5 oz. (240.9 g) Bequest of Richard B. Seager, 1926                       Daggers 33   http://www.metmuseum.org/art/collection/search/32745 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 130.473ms · Data license: CC0 · Data source: metmuseum/openaccess