MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Culture = 525

View and edit SQL

Suggested facets: Object Name, Title, Object Date, Object Begin Date, Medium, Dimensions, 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
21979 36.25.600 0 0 26823 Arms and Armor 5 Shield 1361 Shield Sumatran, Batak 525                           16th–19th century 1501 1900 Brass 12 Daim. 10.5 in. (26.7 cm) Bequest of George C. Stone, 1935       Sumatra 214               Shields 39   Metropolitan Museum of Art, New York, NY 1
21980 36.25.620 0 0 26824 Arms and Armor 5 Shield 1361 Shield Sumatran, Batak 525                           16th–19th century 1501 1900 Cane, brass 4874 Diam. 10.25 in. (26 cm) Bequest of George C. Stone, 1935       Sumatra 214               Shields 39   Metropolitan Museum of Art, New York, NY 1
25230 36.25.2452 0 0 30381 Arms and Armor 5 Pouch, primer, and flask 2998 Pouch Containing Chargers, Flask for Priming Powder and Bullet Flask Sumatran, Batak 525                           18th–19th century 1701 1900 Leather, bamboo, wood 5676 H. of pouch 6 1/2 in. (16.5 cm); W. of pouch 8 1/4 in. (21 cm); Wt. 1 lb. 1.5 oz. (496.1 g) Bequest of George C. Stone, 1935       Sumatra 214               Firearms Accessories 92   Metropolitan Museum of Art, New York, NY 1
25250 36.25.2480a–e 0 0 30401 Arms and Armor 5 Cartridge case 2920 Cartridge Case for Powder Chargers Sumatran, Batak 525                           18th–19th century 1701 1900 Leather 732 H. 9 in. (22.9 cm); W. 6 1/4 in. (15.9 cm); D. 3 in. (7.6 cm); Wt. including contents 10.4 oz. (294.8 g) Bequest of George C. Stone, 1935       Sumatra 214               Firearms Accessories 92   Metropolitan Museum of Art, New York, NY 1
25281 36.25.2332 0 0 30432 Arms and Armor 5 Priming flask 1418 Priming Flask Sumatran, Batak 525                           18th–19th century 1701 1900 Wood, brass 474 H. including chain 18 in. (45.7 cm); H. excluding chain 6 1/2 in. (16.5 cm); W. 1 1/2 in. (3.8 cm); D. 3/4 in. (1.9 cm); Wt. 2.6 oz. (73.7 g) Bequest of George C. Stone, 1935       Sumatra 214               Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
25294 36.25.2347 0 0 30445 Arms and Armor 5 Primer 1926 Primer Sumatran, Batak 525                           18th–19th century 1701 1900 Bamboo 3967 H. 5 1/4 in. (13.3 cm); Diam. 3/4 in. (1.9 cm); Wt. 0.4 oz. (11.3 g) Bequest of George C. Stone, 1935       Sumatra 214               Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
25305 36.25.2359 0 0 30456 Arms and Armor 5 Primer 1926 Primer Sumatran, Batak 525                           18th–19th century 1701 1900 Ebony, cord 5718 H. 4 1/2 in. (11.4 cm); W. 1 5/8 in. (4.1 cm); D. 1 3/4 in. (4.5 cm); Wt. 0.9 oz. (25.5 g) Bequest of George C. Stone, 1935       Sumatra 214               Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
25309 36.25.2363 0 0 30460 Arms and Armor 5 Priming Flask 3021 Priming Flask Sumatran, Batak 525                           18th–19th century 1701 1900 Ebony, textile 5721 H. 6 1/2 in. (16.5 cm); W. 1 3/4 in. (4.5 cm); D. 1 in. (2.5 cm); Wt. 1.6 oz. (45.4 g) Bequest of George C. Stone, 1935       Sumatra 214               Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
25310 36.25.2364 0 0 30461 Arms and Armor 5 Priming flask 1418 Priming Flask Sumatran, Batak 525                           18th–19th century 1701 1900 Horn 5092 L. 6 7/8 in. (17.5 cm); D. 1 1/2 in. (3.8 cm); Wt. 3 oz. (85 g) Bequest of George C. Stone, 1935       Sumatra 214               Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
25312 36.25.2366 0 0 30463 Arms and Armor 5 Bullet flask 3023 Bullet Carrier with Spring Jaws Sumatran, Batak 525                           18th–19th century 1701 1900 Horn 5092 L. 7 1/4 in. (18.4 cm); D. 1 5/8 in. (4.1 cm); Wt. 1.4 oz. (39.7 g) Bequest of George C. Stone, 1935       Sumatra 214               Firearms Accessories-Flasks & Primers 53   Metropolitan Museum of Art, New York, NY 1
26055 36.25.1384a, b 0 0 31207 Arms and Armor 5 Sword with scabbard 1325 Sword with Scabbard Sumatran, Batak 525                           18th–19th century 1701 1900 Steel, wood, ivory 3659 L. with scabbard 28 in. (71.1 cm); L. without scabbard 22 1/2 in. (57.2 cm); L. of blade 18 1/4 in. (46.3 cm); W. 3 in. (7.6 cm); Wt. 1 lb. 10.2 oz. (742.8 g); Wt. of scabbard 9.5 oz. (269.3 g) Bequest of George C. Stone, 1935       Sumatra 214               Swords 29   Metropolitan Museum of Art, New York, NY 1
26222 36.25.1175a, b 0 0 31374 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Sumatran, Batak 525                           16th–19th century 1501 1900 Steel, wood, silver, copper alloy 6161 L. with sheath 17 1/2 in. (44.5 cm); L. without sheath 16 1/4 in. (41.3 cm); L. of blade 12 5/8 in. (32.1 cm); W. 4 3/4 in. (12.1 cm); Wt. 9.1 oz. (258 g); Wt. of sheath 6 oz. (170.1 g) Bequest of George C. Stone, 1935       Sumatra 214               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26770 36.25.599 0 0 31922 Arms and Armor 5 Shield 1361 Shield Sumatran, Batak 525                           16th–19th century 1501 1900 Brass 12 Daim. 10.5 in. (26.7 cm) Bequest of George C. Stone, 1935       Sumatra 214               Shields 39   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 147.507ms · Data license: CC0 · Data source: metmuseum/openaccess