MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

21 rows where Culture = 64 and Is Public Domain = 0

View and edit SQL

Suggested facets: Department, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, 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 Repository
12819 46.69.1 0 0 13964 American Decorative Arts 1 Rug 1034 Knotted Rug Caucasian 64                           1800–1900 1800 1900 Wool 2116 117 x 38 in. (297.2 x 96.5 cm) Bequest of Annie Kalish, 1946 Made in 1         Caucasus 17           Textiles 16   Metropolitan Museum of Art, New York, NY 1
12820 46.69.2 0 0 13965 American Decorative Arts 1 Rug 1034 Knotted Rug Caucasian 64                           1800–1900 1800 1900 Wool 2116 62 x 48 1/2 in. (157.5 x 123.2 cm) Bequest of Annie Kalish, 1946 Made in 1 Shirvan 332     Iran 59             Textiles 16   Metropolitan Museum of Art, New York, NY 1
12821 46.69.3 0 0 13966 American Decorative Arts 1 Rug 1034 Knotted Rug Caucasian 64                           1800–1900 1800 1900 Wool 2116 148 x 44 in. (375.9 x 111.8 cm) Bequest of Annie Kalish, 1946 Made in 1 Kuba or vicinity 333     Russia 60             Textiles 16   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
24947 36.25.3004a–j 0 0 30098 Arms and Armor 5 Cartridge case 2920 Cartridge Case Caucasian 64                           18th–19th century 1701 1900 Leather, steel, silk 5547 Cartridge case (a); H. 5 in. (12.7 cm); W. 9 3/4 in. (24.8 cm); Wt. 1 lb. 4.8 oz. (589.7 g); cartridges (b–j); H. of each 4 1/2 in. (11.4 cm); Diam. of each 7/8 in. (2.2 cm) Bequest of George C. Stone, 1935                       Firearms Accessories 92   Metropolitan Museum of Art, New York, NY 1
24967 36.25.2986 0 0 30118 Arms and Armor 5 Belt 2179 Belt Caucasian 64                           18th–19th century 1701 1900 Silk, silver, textile 5555 L. 111 in. (281.9 cm) Bequest of George C. Stone, 1935                       Miscellaneous 64   Metropolitan Museum of Art, New York, NY 1
25226 36.25.2446a–f 0 0 30377 Arms and Armor 5 Cartridge case 2920 Cartridge Case Caucasian 64                           18th–19th century 1701 1900 Leather, brass 5672 H. 5 1/4 in. (13.3 cm); W. 2 1/4 in. (5.7 cm); Wt. 3.9 oz. (110.6 g) Bequest of George C. Stone, 1935                       Firearms Accessories 92   Metropolitan Museum of Art, New York, NY 1
25323 36.25.2380 0 0 30474 Arms and Armor 5 Primer with cord 2988 Primer with Cord Caucasian 64                           18th–19th century 1701 1900 Horn, leather, silver, textile, chern 5725 L. 5 1/4 in. (13.3 cm); D. 1/2 in. (1.3 cm); Wt. 4.7 oz. (133.2 g) Bequest of George C. Stone, 1935                       Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
25359 36.25.2237 0 0 30510 Arms and Armor 5 Flintlock pistol 2301 Flintlock Pistol Caucasian 64                           18th–19th century 1701 1900 Steel, leather, silver, chern, gold 5748 L. 18 3/4 in. (47.6 cm); L. of barrel 13 9/16 in. (34.4 cm); Cal. .54 in (13.7 mm); Wt. 1 lb. 8 oz. (680.4 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Flintlock 41   Metropolitan Museum of Art, New York, NY 1
25361 36.25.2240 0 0 30512 Arms and Armor 5 Miquelet pistol 2163 Miquelet Pistol Caucasian 64                           18th century 1701 1800 Steel, silver, leather, chern 5750 L. 18 1/4 in. (46.4 cm); L. of barrel 13 1/4 in. (33.7 cm); Cal. .47 in (11.9 mm); Wt. 1 lb. 14.1 oz. (853.3 g) Bequest of George C. Stone, 1935                       Firearms-Pistols-Miquelet 127   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
25454 36.25.2165 0 0 30606 Arms and Armor 5 Miquelet gun 1919 Miquelet Gun Caucasian 64                           18th century 1701 1800 Wood, steel, gold, silver 5797 L. 43 1/2 in. (110.5 cm); L. of barrel 30 1/4 in. (76.8 cm); Cal. .62 in (15.7 mm); Wt. 5 lb. 14.7 oz. (2684.7 g) Bequest of George C. Stone, 1935                       Firearms-Guns-Miquelet 100   Metropolitan Museum of Art, New York, NY 1
25755 36.25.1605a, b 0 0 30907 Arms and Armor 5 Sword (Shashqa) with scabbard 3123 Sword (Shashqa) with Scabbard Caucasian 64                           Blade dated 1819–20, silver fittings dated 1879 1819 1879 Steel, silver, leather, niello, wood, possibly gold 5916 H. with scabbard 38 3/8 in. (97.5 cm); H. without scabbard 37 1/2 in. (95.3 cm); H. of blade 32 in. (81.3 cm); W. 2 1/8 in. (5.4 cm); Wt. 1 lb. 10.9 oz. (762.6 g); Wt. of scabbard 1 lb. 1 oz. (481.9 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
26005 36.25.1332a, b 0 0 31157 Arms and Armor 5 Sword (Quaddara) with scabbard 3197 Sword (Quaddara) with Scabbard Caucasian 64                           ca. 1850–75 1825 1900 Steel, horn, silver, leather, wood, copper alloy 6043 L. with scabbard 35 5/8 in. (90.5 cm); L. without scabbard 34 3/8 in. (87.3 cm); L. of blade 26 3/4 in. (67.9 cm); W. 2 3/8 in. (6 cm); Wt. 2 lb. 1.3 oz. (944 g); Wt. of scabbard 7.8 oz. (221.1 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
26009 36.25.1336a, b 0 0 31161 Arms and Armor 5 Sword (Yatagan) with scabbard 2903 Sword (Yatagan) with Scabbard Caucasian 64                           1712–13 1712 1713 Steel, silver 3508 H. with scabbard 28 in. (71.1 cm); H. without scabbard 26 1/2 in. (67.3 cm); W. 2 in. (5.1 cm); Wt. 1 lb. 3.1 oz. (541.5 g); Wt. of scabbard 1 lb. 2.1 oz. (513.1 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
26918 36.25.159a, b 0 0 32070 Arms and Armor 5 Pair of arm guards 2857 Pair of Arm Guards Caucasian 64                           18th–19th century 1701 1900 Steel, silver 3508   Bequest of George C. Stone, 1935                       Armor Parts 47   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
119757 1997.282.3 0 0 208826 European Sculpture and Decorative Arts 3 Belt 2179 Belt Caucasian 64                           18th–19th century 1700 1899 Silver and niello 23813 Length: 30 1/8 in. (76.5 cm) Bequest of Adrienne Minassian, 1997                       Metalwork-Silver 313   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 269.396ms · Data license: CC0 · Data source: metmuseum/openaccess