MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

15 rows where "Artist Begin Date" is on date -4708-07-21 and Department = 5 sorted by Artist Nationality

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Culture, Artist Role, Artist Prefix, Artist Display Bio, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Classification

Department ✖

  • Arms and Armor · 15 ✖

Artist Begin Date (date) ✖

  • -4708-07-21 · 15 ✖
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
22695 22695 L.2004.41.28a–c 0 0 27609 Arms and Armor 5 Blade for a spear (Jumonji-yari) with sheath 2788 Blade for a Spear (Jūmonji-yari) with Sheath Japanese 35         Bladesmith 100 Blade inscribed by Munemichi Japanese, active 18th century   Munemichi 3033   1701 1800 dated August 1727 1727 1727 Steel, wood, lacquer, gold, copper 5144 H. with sheath 22 7/8 in. (58.1 cm); spear (a); H. 20 1/2 in. (52.1 cm); W. 6 in. (15.2 cm); Wt. 14.5 oz. (411.1 g); sheath (b); W. 7 1/2 in. (19.1 cm); Wt. 7.5 oz. (212.6 g); shaft (c); H. 78 in. (198 cm); Wt. 2 lb. 4.1 oz. (1023.4 g) Lent by Etsuko O. Morris and John H. Morris Jr., 2004                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/27609 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17930 17930 14.100.148 0 0 22441 Arms and Armor 5 Armor (Gusoku) 1373 Armor (Gusoku) Japanese 35         Armorer 98 Inscribed on the helmet by Myochin Ki Muneyuki Japanese, Tsugaru, active 18th century   Muneyuki, Myochin Ki of Tsugaru 2739 Japanese 74 1701 1800 18th century 1701 1800 Iron, leather, lacquer, silk, gilt copper 3688 H. 63 1/2 in. (161.3 cm) Gift of Bashford Dean, 1914                       Armor for Man 44   http://www.metmuseum.org/art/collection/search/22441 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
17978 17978 14.100.100 0 0 22491 Arms and Armor 5 Matchlock gun 1439 Matchlock Gun Japanese 35         Gunsmith 96 Inscribed by Kunitomō Katsumasa Japanese, Edo period, active 18th century   Katsumasa, Kunitomō 2740 Japanese 74 1701 1800 18th century 1701 1800 Iron, wood, silver, brass 3707 L. 54 in. (137.2 cm) Gift of Bashford Dean, 1914                       Firearms-Guns-Matchlock 79   http://www.metmuseum.org/art/collection/search/22491 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18005 18005 14.100.166 0 0 22518 Arms and Armor 5 Mask 1441 Mask Japanese 35         Armorer 98 Inscribed by Myōchin Muneakata Japanese, Edo period, 18th century   Muneakata, Myōchin 2742 Japanese 74 1701 1800 18th century 1701 1800 Iron, lacquer 3570 H. 9 in. (22.9 cm); W. 7 in. (17.8 cm) Gift of Bashford Dean, 1914                       Armor Parts-Masks 60   http://www.metmuseum.org/art/collection/search/22518 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18847 18847 32.75.239 0 0 23370 Arms and Armor 5 Matchlock gun 1439 Matchlock Gun Japanese 35         Gunsmith 96 Inscribed by Enamiya Sakubei Japanese, active 18th century   Sakubei, Enamiya 2805 Japanese 74 1701 1800 18th century 1701 1800 Iron, silver, wood, lacquer, brass 3936 L. 52 in. (132.1 cm); L. of barrel 40 5/16 in. (102.4 cm); Cal. .5 in. (13 mm); Wt. 6 lb. 8 oz. (2948 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Firearms-Guns-Matchlock 79   http://www.metmuseum.org/art/collection/search/23370 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19042 19042 32.75.494 0 0 23565 Arms and Armor 5 Arrowhead (Yanonē) 1613 Arrowhead (Yanonē) Japanese 35         Maker 1 Signed on the tang of the blade by Seijiro Japanese,18th century   Seijiro 2810 Japanese 74 1701 1800 16th–19th century 1501 1900 Steel 658 L. 10 3/4 in. (27.3 cm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Archery Equipment-Arrowheads 78   http://www.metmuseum.org/art/collection/search/23565 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19053 19053 32.75.506 0 0 23576 Arms and Armor 5 Arrowhead (Yanonē) 1613 Arrowhead (Yanonē) Japanese 35         Maker 1 Signed on the tang of the blade by Kane Yoshi(?) Japanese, 18th century   Yoshi(?), Kane 2811 Japanese 74 1701 1800 16th–19th century 1501 1900 Steel 658 L. 14 in. (35.6 cm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Archery Equipment-Arrowheads 78   http://www.metmuseum.org/art/collection/search/23576 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19109 19109 32.75.562 0 0 23632 Arms and Armor 5 Arrowhead (Yanonē) 1613 Arrowhead (Yanonē) Japanese 35         Maker 1 Signed by Korai Japanese, 18th century   Korai 2812 Japanese 74 1701 1800 16th–19th century 1501 1900 Steel 658 L. 8 3/8 in. (21.3 cm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Archery Equipment-Arrowheads 78   http://www.metmuseum.org/art/collection/search/23632 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19132 19132 32.75.586 0 0 23655 Arms and Armor 5 Arrowhead (Yanonē) 1613 Arrowhead (Yanonē) Japanese 35         Maker 1 Signed on the blade by Yoshitoshi Japanese, 18th century   Yoshitoshi 2813 Japanese 74 1701 1800 16th–19th century 1501 1900 Steel 658 L. 11 3/4 in. (29.9 cm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Archery Equipment-Arrowheads 78   http://www.metmuseum.org/art/collection/search/23655 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19200 19200 32.75.659 0 0 23723 Arms and Armor 5 Arrowhead (Yanonē) 1613 Arrowhead (Yanonē) Japanese 35         Maker 1 Signed Kanenobu Japanese, 18th century   Kanenobu 2814 Japanese 74 1701 1800 16th–19th century 1501 1900 Steel 658 L. 6 3/8 in. (16.2 cm) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Archery Equipment-Arrowheads 78   http://www.metmuseum.org/art/collection/search/23723 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19623 19623 36.25.265 0 1 24147 Arms and Armor 5 Mask with neck guard 2042 Mask with Neck Guard Japanese 35         Armorer 98 Inscribed by Myōchin Munemitsu Japanese, Edo period, 18th century   Munemitsu Myōchin 2826 Japanese 74 1701 1800 18th century 1701 1800 Iron, lacquer, gold, leather, textile (silk) 4082 H. 13 1/4 in. (33.7 cm); W. 9 in. (22.9 cm); D. 5 in. (12.7 cm) Bequest of George C. Stone, 1935                       Armor Parts-Masks 60   http://www.metmuseum.org/art/collection/search/24147 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20441 20441 2001.642 1 1 24975 Arms and Armor 5 Armor (Gusoku) 1373 Armor (Gusoku) Japanese, Toyohara, Eichizan province 389         Armorer 98 Helmet signed by Bamen Tomotsugu Japanese, Eichizan province, Toyohara, active 18th century   Bamen Tomotsugu 2935 Japanese 74 1701 1800 18th century 1701 1800 Iron, lacquer, copper-gold alloy (shakudō), silver, silk, horse hair, ivory 4407 as mounted, H. 58 5/8 in. (148.8 cm); W. 18 3/4 in. (47.6 cm) Gift of Etsuko O. Morris and John H. Morris Jr., in memory of Dr. Frederick M. Pedersen, 2001   Toyohara 530   Okinawa prefecture 184               Armor for Man 44   http://www.metmuseum.org/art/collection/search/24975 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
26949 26949 36.25.42a–p 0 0 32101 Arms and Armor 5 Armor (Gusoku) 1373 Armor (Gusoku) Japanese 35         Armorer 98 Helmet inscribed by Hōrai Narichika Japanese, probably Kaga province, active 18th century   Hōrai Narichika 3073 Japanese 74 1701 1800 18th century 1701 1800 Iron, lacquer, silk, gold, hair 6476   Bequest of George C. Stone, 1935                       Armor for Man 44   http://www.metmuseum.org/art/collection/search/32101 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
29247 29247 29.100.1042 0 1 34453 Arms and Armor 5 Sword guard (Tsuba) 1287 Sword Guard (Tsuba) Japanese 35         Fittings maker 127 Inscribed by Minayama Ōki Japanese, Kyoto, active 18th century   Minayama Ōki 3111 Japanese 74 1701 1800 18th century 1701 1800 Copper-gold alloy (shakudō), gold, copper 4264 H. 2 11/16 in. (6.8 cm); W. 2 7/16 in. (6.2 cm); thickness 1/4 in. (0.6 cm); Wt. 3.5 oz. (99.2 g) H. O. Havemeyer Collection, Bequest of Mrs. H. O. Havemeyer, 1929                       Sword Furniture-Tsuba 32   http://www.metmuseum.org/art/collection/search/34453 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
28915 28915 29.158.515a, b 0 1 34114 Arms and Armor 5 Rowel spurs 3672 Pair of Rowel Spurs Mexican 11         Maker 1 Inscribed by Manuel Casco Mexican, active 18th century   Casco, Manuel 3108 Mexican or Spanish 112 1701 1800 dated 1738 1738 1738 Iron 13 L. of each 13 1/4 in. (33.7 cm); spread of sides of each 2 3/4 in. (7 cm); Diam. of each rowel 7 1/4 in. (18.4 cm); Wt. of each 1 lb. 14 oz. (850.5 g) Bashford Dean Memorial Collection, Funds from various donors, 1929                       Equestrian Equipment-Spurs 94   http://www.metmuseum.org/art/collection/search/34114 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 3251.947ms · Data license: CC0 · Data source: metmuseum/openaccess