MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where "Artist Begin Date" is on date -4708-04-12 and Department = 5 sorted by Artist Nationality

View and edit SQL

Suggested facets: 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

Department

  • Arms and Armor · 9

Artist Begin Date (date)

  • -4708-04-12 · 9
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
17520 04.4.9a–l 0 1 22022 Arms and Armor 5 Armor (Gusoku) 1373 Armor (Gusoku) Japanese 35         Armorer 98 Inscribed by Yukinoshita Sadaiyé Japanese, active 17th century   Sadaiyé, Yukinoshita 2701 Japanese 74 1601 1700 17th century 1601 1700 Iron, lacquer, silk, gilt copper 3551 as mounted: H. 53 in. (134.6 cm); W. 32 in. (81.3 cm); D. 20 in. (50.8 cm) Rogers Fund, 1904                       Armor for Man 44   Metropolitan Museum of Art, New York, NY 1
18144 17.212.3 0 0 22664 Arms and Armor 5 Blade for a sword (Katana) 1638 Blade for a Sword (Katana) Japanese 35         Swordsmith 92 Blade inscribed by Kunisuke Japanese, active 17th century   Kunisuke 2750 Japanese 74 1601 1700 17th century 1601 1700 Steel 658 L. 37 9/16 in. (95.4 cm); L. cutting edge 28 7/16 in. (72.2 cm); D. of curveture 1/2 in. (1.2 cm) Rogers Fund, 1917                       Sword Blades 70   Metropolitan Museum of Art, New York, NY 1
18867 32.75.318 0 1 23390 Arms and Armor 5 Ceremonial arrowhead (Yanonē) 1924 Ceremonial Arrowhead (Yanonē) Japanese 35         Steel-chiseler 107   Umetada Yoshinobu Japanese, Edo period, 17th century   Yoshinobu, Umetada 2807 Japanese 74 1601 1700 17th century 1601 1700 Steel 658 L. 18 5/8 in. (47.3 cm); L. of head 6 3/4 in. (17.1 cm); W. 3 1/2 in. (8.9 cm); Wt. 6.9 oz. (195.6 g) The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Archery Equipment-Arrowheads 78   Metropolitan Museum of Art, New York, NY 1
19417 32.163.3–.4 0 0 23940 Arms and Armor 5 Pair of stirrups 1406 Pair of Stirrups Japanese 35         Decorator 33 Inscribed by Nagakuni Japanese, active 17th century   Nagakuni 2819 Japanese 74 1601 1700 17th century 1601 1700 Iron, lacquer, silver 3993 H. of each 9 3/4 in. (24.8 cm); L. of each 11 1/2 in. (29.2 cm); W. of each 5 1/4 in. (13.3 cm) Rogers Fund, 1932                       Equestrian Equipment-Stirrups 68   Metropolitan Museum of Art, New York, NY 1
19824 36.25.1672a–d 0 0 24349 Arms and Armor 5 Blade for a sword (Katana) 1638 Blade for a Sword (Katana) Japanese 35         Swordsmith 92 Blade inscribed by Mitsuhira Japanese, active 17th century   Mitsuhira 2832 Japanese 74 1601 1700 17th century 1601 1700 Steel 658 L. of blade 32 5/16 in. (82.1 cm); L. of cutting edge 24 9/16 in. (62.4 cm); D. of curvature 7/16 in. (1.06 cm) Bequest of George C. Stone, 1935                       Sword Blades 70   Metropolitan Museum of Art, New York, NY 1
20261 48.63.4 0 1 24790 Arms and Armor 5 Helmet (Hoshi-kabuto) 2239 Helmet (Hoshi-Kabuto) Japanese 35         Armorer 98 Inscribed by Iyehisa of Nara Japanese, Nara, active 17th century   Japanese, Nara Iyehisa of Nara 2890 Japanese 74 1601 1700 17th century 1601 1700 Iron, lacquer, gilt copper, copper-gold alloy (shakūdo), silver, silk, gilt leather 4323 H. 11 in. (27.9 cm); L. 15 1/2 in. (39.4 cm) Rogers Fund, 1948                       Helmets 37   Metropolitan Museum of Art, New York, NY 1
21202 13.112.1a–s 0 0 25821 Arms and Armor 5 Armor (Gusoku) 1373 Armor (Gusoku) Japanese 35         Armorer 98 Signed on the shoulder guards by Miochin Oye Ki Muneyasu Japanese, Tosa, active 17th century   Miochin Oye Ki Muneyasu 2975 Japanese 74 1601 1700 17th century 1601 1700 Iron, lacquer, silk 3615   Rogers Fund, 1913       Tosa province 198               Armor for Man 44   Metropolitan Museum of Art, New York, NY 1
22688 2007.478.3a–c 0 1 27601 Arms and Armor 5 Blade for a sword (Katana) 1638 Blade for a Sword (Katana) Japanese 35         Swordsmith 92 Blade inscribed by Iyonojō Munetsugu Japanese, active 17th century   Munetsugu, Iyonojō 3030 Japanese 74 1601 1700 early–mid-17th century 1601 1700 Steel 658 L. 41 in. (104.2 cm); L. of cutting edge 31 7/8 in. (80.8 cm); D. of curvature 9/16 in. (1.4 cm) Gift of Etsuko O. Morris and John H. Morris Jr., in memory of Dr. Frederick M. Pedersen, 2007       Saga Prefecture 104               Sword Blades 70   Metropolitan Museum of Art, New York, NY 1
386059 14.25.1176 0 0 635707 Arms and Armor 5 Cup-hilted rapier 1322 Cup-Hilted Rapier Spanish 13         Sword maker 95   Pedro de Velmonte Spanish, probably 17th century   Spanish, Toledo de Velmonte, Pedro 49507 Spanish 76 1601 1700 ca. 1650 1625 1675 Steel, velvet, copper alloy wire 58270 L. 49 3/4 in. (126.4 cm); L. of blade 44 3/4 in. (113.7 cm); W. 10 1/4 in. (26 cm); D. 4 7/8 in. (12.4 cm); Wt. 2 lb. 1 oz. (935.5 cm) Gift of William H. Riggs, 1913                       Swords 29   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 3558.113ms · Data license: CC0 · Data source: metmuseum/openaccess