MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Culture = 566

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Object Date, Object Begin 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 Repository
22333 1978.54 0 0 27226 Arms and Armor 5 Sword (Mandu, parang ihlang) 2683 Sword (Mandu, Parang Ihlang) Dyak 566                           ca. 1900 1801 1900 Steel, wood, rattan, textile, beads, gutta-percha 4979 L. 29 3/8 in. (74.6 cm); Sword L. 26 7/16 in. (67.1 cm); Blade L. 20 3/4 in. (52.7 cm); Greatest W. of blade 1 1/2 in. (3.8 cm); Greatest thickness of blade 1/4 in. (0.6 cm); Wt. 1 lb. 15 oz. (863 g) Roger's Fund, 1978                       Swords-Hunting 108   Metropolitan Museum of Art, New York, NY 1
25898 36.25.1401a, b 0 1 31050 Arms and Armor 5 Sword (Parang pandit) with scabbard 3170 Sword (Parang Pandit) with Scabbard Dyak 566                           18th–19th century 1701 1900 Steel, wood, brass, silver, cane 5982 L. with scabbard 28 3/4 in. (73 cm); L. without scabbard 28 1/4 in. (71.8 cm); L. of blade 19 3/4 in. (50.2 cm); W. 3 1/2 in. (8.9 cm); Wt. 1 lb. 14.3 oz. (859 g); Wt. of scabbard 5.9 oz. (167.3 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
25949 36.25.1468a–c 0 0 31101 Arms and Armor 5 Sword (Mandau) with scabbard and small knife 3182 Sword (Mandau) with Scabbard and Small Knife Dyak 566                           18th–19th century 1701 1900 Horn, cane, rattan, beads 6015 L. without scabbard 28 1/8 in. (71.4 cm); W. 3 3/4 in. (9.5 cm); Wt. 1 lb. 11 oz. (765.4 g); Wt. of scabbard 17.7 oz. (501.8 g); small knife (c); L. 16 1/2 in. (41.9 cm); W. 1 in. (2.5 cm); Wt. 2.5 oz. (70.9 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
25950 36.25.1469a, b 0 0 31102 Arms and Armor 5 Sword (Mandau) with scabbard 3183 Sword (Mandau) with Scabbard Dyak 566                           18th–19th century 1701 1900 Tin, bone, hair, rattan 6016 L. with scabbard 25 7/8 in. (65.7 cm); L. of blade 19 3/4 in. (50.1 cm); W. 3 1/4 in. (8.3 cm); Wt. with scabbard 1 lb. 10.6 oz. (754.1 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
25951 36.25.1470a–c 0 0 31103 Arms and Armor 5 Sword (Mandau) with scabbard and knife 3184 Sword (Mandau) with Scabbard and Knife Dyak 566                           18th–19th century 1701 1900 Wood, horn, bone, hair, cane, wire 6017 L. without scabbard 31 1/4 in. (79.4 cm); W. 3 1/2 in. (8.9 cm); Wt. 2 lb. 1.6 oz. (952.5 g); Wt. of scabbard 14.1 oz. (399.7 g); knife (c); L. 17 3/4 in. (45.1 cm); W. 1 in. (2.5 cm); Wt. 3.6 oz. (102.1 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
25953 36.25.1472a, b 0 0 31105 Arms and Armor 5 Sword (Mandau) with scabbard 3183 Sword (Mandau) with Scabbard Dyak 566                           18th–19th century 1701 1900 Wood, bone, horn, cane 6019 L. with scabbard 26 1/4 in. (66.7 cm); L. without scabbard 25 3/4 in. (65.4 cm); L. of blade 21 in. (53.3 cm); W. 3 in. (7.6 cm); Wt. 1 lb. 6.4 oz. (635 g); Wt. of scabbard 4.7 oz. (133.2 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
26060 36.25.1390a, b 0 0 31212 Arms and Armor 5 Sword (Parang latok) with scabbard 3172 Sword (Parang Latok) with Scabbard Dyak 566                           18th–19th century 1701 1900 Wood, iron, rattan 6076 H. with scabbard 31 3/4 in. (80.6 cm); H. without scabbard 28 13/16 in. (73.2 cm); W. 4 in. (10.2 cm); Wt. 2 lb. 3 oz. (992.2 g); Wt. of scabbard 4.5 oz. (127.6 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
26063 36.25.1393a, b 0 1 31215 Arms and Armor 5 Sword with scabbard 1325 Sword with Scabbard Dyak 566                           18th–19th century 1701 1900 Wood, lead 6079 L. with scabbard 25 in. (63.5 cm); L. without scabbard 22 in. (55.9 cm); L. of blade 15 in. (38.1 cm); W. 3 in. (7.6 cm); Wt. 1 lb. 6.9 oz. (649.2 g); Wt. of scabbard 4.8 oz. (136.1 g) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
26557 36.25.729 0 1 31709 Arms and Armor 5 Dagger (Pisau raut) 3301 Dagger (Pisau Raut) Dyak 566                           18th–19th century 1701 1900 Steel, bone, wood, horn 6327 H. 17 1/2 in. (44.5 cm); W. 5/8 in. (1.6 cm); Wt. 3.4 oz. (96.4 g) Bequest of George C. Stone, 1935                       Knives 49   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 195.267ms · Data license: CC0 · Data source: metmuseum/openaccess