MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

19 rows where Classification = 35 and Culture = 65

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line

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
20496 20496 96.5.142a–c 0 0 25033 Arms and Armor 5 Battle axe wtih sheath and stiletto 2342 Battle Axe with Sheath and Stiletto Persian 65                           18th century 1701 1800 Steel, leather, copper gilt, jewels 4435   John Stoneacre Ellis Collection, Gift of Mrs. Ellis and Augustus Van Horne Ellis, 1896                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/25033 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25554 25554 36.25.1993 0 0 30706 Arms and Armor 5 Spearhead (Sinan) 3079 Spearhead (Sinan) Persian 65                           16th century 1500 1599 Steel, gold 3497 L. 15 7/8 in. (40.3 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30706 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25556 25556 36.25.1995a–d 0 0 30708 Arms and Armor 5 Three javelins with quiver 3081 Three Javelins with Persian Quiver Persian 65                           18th–19th century 1701 1900 Wood, steel, silver, velvet 5849 Javelins (a–c); L. of each 35 in. (88.9 cm); Wt. of each 7.5 oz. (212.6 g); quiver (d); L. with javelins 37 1/4 in. (94.6 cm); L. without javelins 31 3/4 in. (80.6 cm); Wt. 14.4 oz. (408.2 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30708 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25566 25566 36.25.1905 0 0 30718 Arms and Armor 5 Mace 1328 Mace Persian 65                           18th–19th century 1701 1900 Iron, silver 749 L. 26 3/8 in. (67 cm); W. 1 1/2 in. (3.8 cm); Wt. 2 lb. 2.6 oz. (980.9 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30718 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25578 25578 36.25.1917 0 0 30730 Arms and Armor 5 Hammer 1701 Hammer Persian 65                           19th century 1801 1900 Iron, silver, leather 5670 L. 19 in. (48.3 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30730 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25594 25594 36.25.1933 0 0 30746 Arms and Armor 5 Spearhead 1690 Bident Spearhead Persian 65                           19th century 1801 1900 Steel, gold 3497 L. 23 in. (58.4 cm); W. 2 1/2 in. (6.4 cm); Wt. 1 lb. 4.7 oz. (586.8 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30746 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25595 25595 36.25.1934 0 0 30747 Arms and Armor 5 Spearhead 1690 Trident Spearhead Persian 65                           19th century 1801 1900 Steel, gold 3497 L. 20 5/8 in. (52.4 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30747 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25633 25633 36.25.1801 0 0 30785 Arms and Armor 5 Axe 2349 Axe Persian 65                           18th century 1701 1800 Steel, wood, leather, silver, gold 5865 L. 26 3//4 in. (67.9 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30785 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25699 25699 36.25.1875 0 0 30851 Arms and Armor 5 Mace 1328 Mace Persian 65                           18th century 1701 1800 Iron, silver, leather 5670 L. 26 1/2 in. (67.3 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30851 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25701 25701 36.25.1877 0 1 30853 Arms and Armor 5 Mace head with socket handle 3111 Mace Head with Socket Handle Persian 65                           16th century 1501 1600 Iron 13 H. 9 1/2 in. (24.1 cm); W. 2 1/4 in. (5.7 cm); Wt. 1 lb. 7 oz. (652 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30853 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25702 25702 36.25.1878 0 0 30854 Arms and Armor 5 Mace 1328 Mace Persian 65                           17th–18th century 1601 1800 Steel, brass 323 H. 21 in. (53.4 cm); W. 2 1/4 in. (6.7 cm); Wt. 2 lb. 0.5 oz. (921.4 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30854 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25703 25703 36.25.1879 0 0 30855 Arms and Armor 5 Mace 1328 Mace Persian 65                           18th–19th century 1701 1900 Iron, wood, reed, lacquer 5889 H. 20 in. (50.8 cm); W. 1 1/2 in. (3.8 cm); Wt. 12 oz. (340.2 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30855 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25705 25705 36.25.1881 0 0 30857 Arms and Armor 5 Mace 1328 Mace Persian 65                           19th century 1800 1899 Steel, silver 3508 L. 26 1/2 in. (67.3 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30857 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25712 25712 36.25.1891a, b 0 0 30864 Arms and Armor 5 Mace with stiletto 3112 Mace with Stiletto Persian 65                           19th century 1801 1900 Steel 658 L. 28 1/2 in. (72.4 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30864 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25713 25713 36.25.1892 0 0 30865 Arms and Armor 5 Mace 1328 Mace Persian 65                           18th–19th century 1701 1900 Steel, silver, gold 3810 L. 24 in. (61 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30865 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25715 25715 36.25.1894 0 1 30867 Arms and Armor 5 Mace 1328 Mace Persian 65                           17th century 1600 1699 Steel, silver, turquoise 5891 L. 28 3/8 in. (72.1 cm); W. 1 1/2 in. (3.8 cm); Wt. 2 lb. 2.8 oz. (986.6 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30867 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25717 25717 36.25.1896 0 0 30869 Arms and Armor 5 Mace 1328 Mace Persian 65                           18th–19th century 1701 1900 Steel, silver 3508 L. 28 1/2 in. (72.4 cm); W. 2 in. (5.1 cm); Wt. 2 lb. 6.6 oz. (1094.3 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30869 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25749 25749 36.25.1798 0 0 30901 Arms and Armor 5 Axe 2349 Axe Persian 65                           18th–19th century 1701 1900 Steel, wood, horn, ivory 5913 H. 22 1/2 in. (57.2 cm); W. 5 1/2 in. (14 cm); Wt. 2 lb. 0.8 oz. (929.9 g) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30901 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
25750 25750 36.25.1799 0 0 30902 Arms and Armor 5 Axe head 2416 Axe Head Persian 65                           late 17th century 1650 1700 Iron, brass 16 L. 5 1/4 in. (13.3 cm) Bequest of George C. Stone, 1935                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/30902 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 138.458ms · Data license: CC0 · Data source: metmuseum/openaccess