MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

26 rows where City = 621

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Culture, Object Date, Object Begin Date, Medium, County, 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
25620 36.25.1973 0 0 30772 Arms and Armor 5 Spear 1453 Spear Madurese 850                           18th–19th century 1701 1900 Wood, steel, copper, hair 5860 L. 79 1/2 in. (91.1 cm); L. of head 8 9/16 in. (21.7 cm); W. 1 1/4 in. (3.2 cm); Wt. 12.2 oz. (345.9 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
25624 36.25.1979 0 0 30776 Arms and Armor 5 Spear 1453 Spear Madurese 850                           18th–19th century 1701 1900 Silver, hair 5815 L. 92 in. (233.7 cm); L. of head 11 3/4 in. (29.8 cm); L. of ferrule 11 in. (27.9 cm); W. 1 1/4 in. (3.2 cm); Wt. 2 lbs. 9.6 oz. (1179.3 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
25626 36.25.1981 0 0 30778 Arms and Armor 5 Spear 1453 Spear Madura 851                           18th–19th century 1701 1900 Brass, hair 5863 L. 79 1/2 in. (201.9 cm); L. of head 11 9/16 in. (29.4 cm); W. 1 1/16 in. (2.7 cm); Wt. 1 lb. 13.4 oz. (833.5 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
25627 36.25.1982 0 0 30779 Arms and Armor 5 Spear 1453 Spear Madurese 850                           18th–19th century 1701 1900 Brass, hair 5863 L. 83 1/2 in. (212.1 cm); L. of head 8 in. (20.3 cm); W. 13/16 in. (2.1 cm); Wt. 1 lb. 1.1 oz. (507.5 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Shafted Weapons 35   Metropolitan Museum of Art, New York, NY 1
26085 36.25.1216a, b 0 1 31237 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Wood, silver 1266 L. with sheath 16 3/8 in. (41.6 cm); L. without sheath 12 5/8 in. (32.1 cm); L. of blade 9 1/4 in. (23.5 cm); W. 3 1/2 in. (8.9 cm); Wt. 4.3 oz. (121.9 g); Wt. of sheath 4.2 oz. (119.1 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26125 36.25.1262a, b 0 0 31277 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, tortoise shell, ivory, brass 6113 L. with sheath 19 1/2 in. (49.5 cm); L. without sheath 17 3/4 in. (45.1 cm); L. of blade 14 1/4 in. (36.2 cm); W. 3 in. (7.6 cm); Wt. 12.8 oz. (362.9 g); Wt. of sheath 7.2 oz. (204.1 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26126 36.25.1263a, b 0 0 31278 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, ivory, copper alloy 6114 L. with sheath 20 in. (50.8 cm); L. without sheath 17 3/4 in. (45.1 cm); W. 2 1/2 in. (6.4 cm); Wt. 9.4 oz. (266.5 g); Wt. of sheath 10.1 oz. (286.3 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26127 36.25.1264a, b 0 0 31279 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, ivory, brass 6021 L. with sheath 20 in. (50.8 cm); L. without sheath 19 1/4 in. (48.9 cm); W. 3 in. (7.6 cm); Wt. 12.2 oz. (345.9 g); Wt. of sheath 6.8 oz. (192.8 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26161 36.25.1108a, b 0 0 31313 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           18th–19th century 1701 1900 Steel, pelet wood (possibly kajoe), ivory, silver 6130 L. with sheath 19 15/16 in. (50.6 cm); L. without sheath 18 1/2 in. (47 cm); L. of blade 14 1/4 in. (36.1 cm); W. 3 1/4 in. (8.3 cm); Wt. 12.2 oz. (345.9 g); Wt. of sheath 4.4 oz. (124.7 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26162 36.25.1109a, b 0 0 31314 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           18th–19th century 1701 1900 Steel, pelet wood (possibly kajoe), ivory (elephant), copper alloy 6131 L. with sheath 20 in. (50.8 cm); L. without sheath 18 3/8 in. (46.7 cm); L. of blade 14 1/4 in. (36.1 cm); W. 3 in. (7.6 cm); Wt. 9.1 oz. (258 g); Wt. of sheath 6.1 oz. (172.9 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26163 36.25.1110a, b 0 1 31315 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           18th–19th century 1701 1900 Steel, ivory, wood, brass 6132 L. with sheath 20 1/4 in. (51.4 cm); L. without sheath 18 3/8 in. (46.7 cm); L. of blade 15 in. (38.1 cm); W. 3 3/4 in. (9.5 cm); Wt. 12 oz. (340.2 g); Wt. of sheath 4.8 oz. (136.1 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26169 36.25.1116a, b 0 1 31321 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, ivory, brass 6021 L. with sheath 19 1/2 in. (49.5 cm); L. without sheath 17 3/8 in. (44.1 cm); L. of blade 13 1/2 in. (34.2 cm); W. 3 in. (7.6 cm); Wt. 12.5 oz. (354.4 g); Wt. of sheath 7.8 oz. (221.1 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26173 36.25.1120a, b 0 0 31325 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Javanese, grip, Mardura, scabbard, Central Jawa 941                           16th–19th century 1501 1900 Steel, wood, pigment 4181 L. with sheath 21 in. (53.3 cm); L. without sheath 19 in. (48.3 cm); W. 3 in. (7.6 cm); Wt. 11.1 oz. (314.7 g); Wt. of sheath 5.4 oz. (153.1 g) Bequest of George C. Stone, 1935   Madura 621   Jawa|Jawa Tengah|Jawa Timur 296               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26177 36.25.1124a, b 0 0 31329 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, nickel silver 6141 L. with sheath 18 7/8 in. (47.9 cm); L. without sheath 17 1/4 in. (43.8 cm); L. of blade 13 5/8 in. (34.6 cm); W. 3 1/8 in. (7.9 cm); Wt. 10.4 oz. (294.8 g); Wt. of sheath 5.4 oz. (153.1 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26179 36.25.1126a, b 0 0 31331 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           18th–19th century 1701 1900 Steel, wood, ivory, silver, brass 6142 L. with sheath 19 1/4 in. (48.9 cm); L. without sheath 17 1/2 in. (44.5 cm); L. of blade 13 3/4 in. (34.9 cm); W. 3 1/4 in. (8.3 cm); Wt. 11.3 oz. (320.3 g); Wt. of sheath 5.7 oz. (161.6 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26198 36.25.1145a, b 0 0 31350 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, brass 3791 L. with sheath 19 3/4 in. (50.2 cm); L. without sheath 19 1/4 in. (48.9 cm); L. of blade 15 5/8 in. (39.7 cm); W. 3 in. (7.6 cm); Wt. 11.1 oz. (314.7 g); Wt. of sheath 7.5 oz. (212.6 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26202 36.25.1156a, b 0 1 31354 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Wood 25 L. with sheath 23 3/4 in. (60.3 cm); L. without sheath 23 in. (58.4 cm); L. of blade 18 3/4 in. (47.6 cm); W. 3 3/4 in. (9.5 cm); D. 2 1/4 in. (5.7 cm); Wt. 18.6 oz. (527.3 g); Wt. of sheath 6.5 oz. (184.3 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26212 36.25.1165a, b 0 0 31364 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Balinese, scabbard, Madurese 949                           16th–19th century 1501 1900 Steel, silver, bone, copper alloy 6157 L. with sheath 21 in. (53.5 cm); L. without sheath 18 1/8 in. (46 cm); L. of blade 14 1/8 in. (35.9 cm); W. 3 1/2 in. (8.9 cm); Wt. 10.4 oz. (294.8 g); Wt. of sheath 6.6 oz. (187.1 g) Bequest of George C. Stone, 1935   Madura 621   Bali|Jawa Timur 300               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26213 36.25.1166a, b 0 0 31365 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Wood 25 L. with sheath 20 3/4 in. (52.7 cm); L. without sheath 18 7/8 in. (47.9 cm); L. of blade 14 3/4 in. (37.5 cm); W. 3 1/2 in. (8.9 cm); D. 1 9/16 in. (4 cm); Wt. 10.7 oz. (303.3 g); Wt. of sheath 7.6 oz. (215.5 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26217 36.25.1170a, b 0 1 31369 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Ivory, silver 3798 L. with sheath 13 5/16 in. (33.8 cm); L. without sheath 13 in. (33 cm); L. of blade 10 3/8 in. (26.4 cm); W. 2 in. (5.1 cm); D. 1 in. (2.5 cm); Wt. 3.8 oz. (107.7 g); Wt. of sheath 2.7 oz. (76.5 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26225 36.25.1178a, b 0 0 31377 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Knife, Madurese, grip, Javanese, possibly Balinese 950                           16th–19th century 1501 1900 Steel, wood, silver, gold. polychromy 6162 L. with sheath 22 in. (55.9 cm); L. without sheath 20 3/8 in. (51.8 cm); W. 3 in. (7.6 cm); Wt. 14.2 oz. (402.6 g); Wt. of sheath 4.7 oz. (133.2 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur|Jawa|Bali 301               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26226 36.25.1179a, b 0 0 31378 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, polychromy, brass 6163 L. with sheath 20 3/4 in. (52.7 cm); L. without sheath 18 1/2 in. (47 cm); L. of blade 14 1/8 in. (35.9 cm); W. 3 3/8 in. (8.6 cm); Wt. 12.9 oz. (365.7 g); Wt. of sheath 7.6 oz. (215.5 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26229 36.25.1182a, b 0 0 31381 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Wood, steel, polychromy, copper alloy 6165 L. with sheath 21 in. (53.8 cm); L. without sheath 18 5/8 in. (47.3 cm); L. of blade 14 1/4 in. (36.2 cm); W. 3 1/2 in. (8.9 cm); Wt. 13 oz. (368.5 g); Wt. of sheath 5.4 oz. (153.1 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26231 36.25.1184a, b 0 0 31383 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, ivory, polychromy, brass 6166 L. with sheath 22 in. (55.9 cm); L. without sheath 17 1/2 in. (44.5 cm); L. of blade 13 3/4 in. (34.9 cm); W. 3 3/8 in. (8.6 cm); Wt. 7.1 oz. (201.3 g); Wt. of sheath 5.9 oz. (167.3 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26232 36.25.1185a, b 0 0 31384 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Madurese 850                           16th–19th century 1501 1900 Steel, wood, silver, brass, paste jewels 6167 L. with sheath 14 in. (35.6 cm); L. without sheath 11 3/4 in. (29.8 cm); L. of blade 9 in. (22.9 cm); W. 1 3/4 in. (4.5 cm); Wt. 2.5 oz. (70.9 g); Wt. of sheath 3.5 oz. (99.2 g) Bequest of George C. Stone, 1935   Madura 621   Jawa Timur 265               Krisses 34   Metropolitan Museum of Art, New York, NY 1
26238 36.25.1191a, b 0 0 31390 Arms and Armor 5 Kris with sheath 1298 Kris with Sheath Javanese; grip, Madruese 951                           16th–19th century 1501 1900 Brass 12 L. with sheath 18 1/2 in. (47 cm); L. without sheath 16 5/8 in. (42.2 cm); L. of blade 13 1/4 in. (33.7 cm); W. 2 15/16 in. (7.5 cm); D. 1 1/2 in. (3.8 cm); Wt. 7 oz. (198.4 g); Wt. of sheath 4.3 oz. (121.9 g) Bequest of George C. Stone, 1935   Madura 621   Jawa|Jawa Timur 302               Krisses 34   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 128.717ms · Data license: CC0 · Data source: metmuseum/openaccess