MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

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

View and edit SQL

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

Department

  • Arms and Armor · 10

Artist Begin Date (date)

  • -4708-04-11 · 10
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
20338 1973.27.5 0 1 24867 Arms and Armor 5 Rapier 1321 Rapier German 27         Bladesmith 100   Meves Berns German, Solingen, active early 17th century   Berns, Meves 2905   1600 1700 ca. 1610–20 1585 1645 Steel, silver, copper 4351 L. 47 5/16 in. (120.2 cm); L. of blade 41 in. (104.1 cm); W. 8 11/16 in. (22.1 cm); Wt. 2 lb. 13 oz. (1275.7 g) Bequest of Col. Wickliffe P. Draper, 1972                       Swords 29   Metropolitan Museum of Art, New York, NY 1
22684 L.2004.41.37 0 0 27597 Arms and Armor 5 Sword guard (Tsuba) 1287 Sword Guard (Tsuba) Japanese 35         Fittings maker 127   Mino School Japanese, active 17th–19th century   Mino School 3027   1600 1900 late 17th–early 18th century 1650 1750 Copper-gold alloy (shakudō), gold 4307 H. 2 9/16 in. (6.5 cm); W. 2 5/16 in. (5.9 cm); thickness 3/16 in. (0.5 cm); Wt. 3.7 oz. (104.9 g) Lent by Etsuko O. Morris and John H. Morris Jr., 2004                       Sword Furniture-Tsuba 32   Metropolitan Museum of Art, New York, NY 1
405651 14.25.1191 0 1 662414 Arms and Armor 5 Rapier 1321 Rapier hilt, Italian; blade, German, Solingen 6928         Bladesmith 100 Blade by Clemens Hartkopf German, Solingen, active ca. 1625   Hartkopf, Clemens 51289   1600 1650 ca. 1625 1600 1650 Steel, silver, wood, copper alloy 59175 L. 49 1/2 in. (125.7 cm); L. of blade 43 in. (109.2 cm); W. 8 1/2 in. (21.6 cm); D. 5 in. (12.7 cm); Wt. 2 lb. 10 oz. (1190.7 g) Gift of William H. Riggs, 1913                       Swords 29   Metropolitan Museum of Art, New York, NY 1
19458 36.25.1752a–d 0 0 23982 Arms and Armor 5 Blade and mounting for a short sword (Wakizashi) 1294 Blade and Mounting for a Short Sword (Wakizashi) Japanese 35         Swordsmith 92 Blade inscribed by Masatoshi Japanese, active early 17th century   Masatoshi 2823 Japanese 74 1600 1650 blade, 17th century; mounting, 19th century 1600 1900 Steel, wood, lacquer, ray skin (samé), thread, copper-gold alloy (shakudō), dark red copper (hiirodō) 4015 L. 24 15/16 in. (63.4 cm); L. of cutting edge 12 5/8 in. (32.1 cm); D. of curvature 1/8 in. (0.3 cm) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
20193 45.24.58a–e 0 0 24721 Arms and Armor 5 Set of sword fittings (Mitokoromono) 2233 Set of Sword Fittings (Mitokoromono) Japanese 35         Fittings maker 127   Gotō Sakujō Japanese, 1600–1631, eighth-generation Gotō master   Gotō, Sakujō 2878 Japanese 74 1600 1631 early 17th century 1600 1650 Copper-gold alloy (shakudō), gold 4307 L. of hair dressing tool (kogai) (a) 8 5/16 in. (21.1 cm); L. of each grip ornament (menuki) (b, c) 1 7/16 in. (3.6 cm); L. of knife handle (kozuka) (d) 3 13/16 in. (9.7 cm) Rogers Fund, 1945                       Sword Furniture-Fittings, Sets of 132   Metropolitan Museum of Art, New York, NY 1
20206 45.24.43a–c 0 0 24734 Arms and Armor 5 Sword-grip ornaments (Menuki) with certificate of authenticity (Orikami) 2235 Sword-Grip Ornaments (Menuki) with Certificate of Authenticity (Orikami) Japanese 35         Fittings maker 127   Gotō Sakujō Japanese, 1600–1631, eighth-generation Gotō master   Gotō, Sakujō 2878 Japanese 74 1600 1631 early 17th century 1600 1650 Copper-gold alloy (shakudō), gold, copper-silver alloy (shibuichi) 4312 L. of grip ornament (a) 1 1/4 in. (3.2 cm); L. of grip ornament (b) 1 5/16 in. (3.3 cm) Rogers Fund, 1945                       Sword Furniture-Menuki 130   Metropolitan Museum of Art, New York, NY 1
20221 45.24.8 0 0 24749 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Fittings maker 127   Gotō Sakujō Japanese, 1600–1631, eighth-generation Gotō master   Gotō, Sakujō 2878 Japanese 74 1600 1631 early 17th century 1600 1650 Copper-gold alloy (shakudō), gold 4307 L. 3 13/16 in. (9.7 cm); W. 9/16 in. (1.4 cm) Rogers Fund, 1945                       Sword Furniture-Kozuka 112   Metropolitan Museum of Art, New York, NY 1
22687 2007.478.2a, b 0 1 27600 Arms and Armor 5 Blade for a sword (Katana) 1638 Blade for a Sword (Katana) Japanese 35         Swordsmith 92 Inscribed Etchū no kami Fujiwara Takahira Japanese, active early 17th century   Takahira, Etchū no kami Fujiwara 3029 Japanese 74 1600 1650 dated June 1622 1622 1622 Steel 658 L. 36 1/2 in. (92.8 cm); L. of cutting edge 28 1/16 in. (71.5 cm); D. of curvature 1 in. (1.5 cm) Gift of Etsuko O. Morris and John H. Morris Jr., in memory of Dr. Frederick M. Pedersen, 2007                       Sword Blades 70   Metropolitan Museum of Art, New York, NY 1
30264 45.24.28 0 0 35829 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Fittings maker 127   Gotō Sakujō Japanese, 1600–1631, eighth-generation Gotō master   Gotō, Sakujō 2878 Japanese 74 1600 1631 early 17th century 1600 1650 Copper-gold alloy (shakudō), gold, silver 4306 L. 3 13/16 in. (9.7 cm), W. 9/16 in. (1.4 cm) Rogers Fund, 1945                       Sword Furniture-Kozuka 112   Metropolitan Museum of Art, New York, NY 1
391630 45.24.8, .28, .43a–c, .58a–e 0 0 643599 Arms and Armor 5 Set of sword fittings (Mitokoromono) with two additional knife handles (Kozuka)  26637 Set of Sword Fittings (Mitokoromono) with Two Additional Knife Handles (Kozuka) and a Pair of Grip Ornaments (Menuki) Japanese 35         Fittings maker 127   Gotō Sakujō Japanese, 1600–1631, eighth-generation Gotō master   Gotō, Sakujō 2878 Japanese 74 1600 1631 early 17th century 1600 1650 Copper-gold alloy (shakudō), gold, silver 4306 knife handles (kozuka) (45.24.8, .28): L. of each 3 13/16 in. (9.7 cm); W. of each 9/16 in. (1.4 cm); grip ornaments (menuki) (45.24.43a, b): L. of grip ornament (menuki) (a) 1 1/4 in. (3.2 cm); L. of grip ornament (menuki) (b) 1 5/16 in. (3.3 cm); set of sword fittings (mitokoromono) (45.24.58a–e): L. of hair dressing tool (kogai) (a) 8 5/16 in. (21.1 cm); L. of each grip ornament (menuki) (b, c) 1 7/16 in. (3.6 cm); L. of knife handle (kozuka) (d) 3 13/16 in. (9.7 cm) Rogers Fund, 1945                       Sword Furniture 97   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 2169.987ms · Data license: CC0 · Data source: metmuseum/openaccess