MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

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

✎ View and edit SQL

This data as json, CSV (advanced)

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

Department ✖

  • Arms and Armor · 12 ✖

Artist Begin Date (date) ✖

  • -4708-10-29 · 12 ✖
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
22701 22701 L.2004.41.36 0 0 27617 Arms and Armor 5 Doctor's sword (Chatō) 2792 Doctor's Sword (Chatō) Japanese 35         Maker 1 Inscribed Yoshiteru Japanese, active 19th century   Yoshiteru 3037   1801 1900 19th century 1801 1868 Wood, mother-of-pearl, silk 5148 L. 18 in. (45.7 cm); W. 1 3/4 in. (4.5 cm); Wt. 7.2 oz. (204.1 g) Lent by Etsuko O. Morris and John H. Morris Jr., 2004                       Swords 29   http://www.metmuseum.org/art/collection/search/27617 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
423242 423242 2015.695 0 1 702016 Arms and Armor 5 Shield (Dhál) 3329 Shield (Dhál) Indian, Gujarat 6993         Maker 1 Signed by Khooshal Dhunjee & Sons Indian, Ahmedabad, 19th century   Khooshal Dhunjee & Sons 54008   1801 1900 ca. 1875 1850 1900 Leather, brass, textile, pigment 60596 Diam. 16 15/16 in. (43 cm) Purchase, Arthur Ochs Sulzberger Bequest, 2015       Gujarat 311               Shields 39   http://www.metmuseum.org/art/collection/search/702016 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
19425 19425 35.81.4 0 1 23949 Arms and Armor 5 Percussion pistol with case 1994 Percussion Pistol with Case French, Paris 114         Gunsmith 96   Alfred Gauvain French, Paris 1801–1889 Paris   Gauvain, Alfred 2821 French 2 1801 1889 possibly 1844 1819 1869 Steel, wood (ebony), gold, wood, textile 3996 L. of pistol 16 7/8 in. (42.9 cm); Cal. .44 in. (11.2 mm); Wt. 3 lb. 4 oz. (1474 g) Bequest of Charles N. Daly, 1934   Paris 27                   Firearms-Pistols-Percussion 96   http://www.metmuseum.org/art/collection/search/23949 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18089 18089 15.120.1a–o 0 1 22606 Arms and Armor 5 Armor (Gusoku) 1373 Armor (Gusoku) Japanese 35         Armorer 98 Helmet and mask inscribed by Jo Michitaka Japanese, Edo period, active 19th century   Michitaka, Jo 2746 Japanese 74 1801 1900 19th century 1801 1900 Iron, lacquer, silk, gilt copper 3551   Gift of Harald de Raasloff, 1915                       Armor for Man 44   http://www.metmuseum.org/art/collection/search/22606 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
20135 20135 38.25.73a, b 0 1 24662 Arms and Armor 5 Sword-hilt collar and pommel (Fuchigashira) 2214 Sword-Hilt Collar and Pommel (Fuchigashira) Japanese 35         Fittings maker 127 Inscribed by Ishiguro Koreyoshi Japanese, active 19th century   Koreyoshi, Ishiguro 2859 Japanese 74 1801 1900 19th century 1801 1900 Gold, copper-gold alloy (shakudō), copper-silver alloy (shibuichi), copper 4278 L. of fuchi 1 1/2 in. (3.8 cm); W. of fuchi 7/8 in. (2.2 cm); L. of kashira 1 3/8 in. (3.5 cm); W. of kashira 5/8 in. (1.6 cm) Gift of Mrs. George A. Crocker (Elizabeth Masten), 1937                       Sword Furniture-Fuchi-Kashira 104   http://www.metmuseum.org/art/collection/search/24662 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
22057 22057 14.40.915 0 1 26913 Arms and Armor 5 Sword guard (Tsuba) 1287 Sword Guard (Tsuba) Japanese 35         Maker 1   Ishiguro Koreyoshi Japanese, active 19th century   Koreyoshi, Ishiguro 2859 Japanese 74 1801 1900 1840–60 1840 1860 Iron, gold, copper, silver, copper-silver alloy (shibuichi), copper-gold alloy (shakudō) 4898 H. 2 7/8 in. (7.3 cm); W. 2 3/4 in. (7 cm); thickness 5/16 in. (0.8 cm); Wt. 4.5 oz. (127.6 g) Bequest of Benjamin Altman, 1913                       Sword Furniture-Tsuba 32   http://www.metmuseum.org/art/collection/search/26913 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
29781 29781 17.208.11a, b 0 1 35006 Arms and Armor 5 Pair of sword-grip ornaments (Menuki) 2215 Pair of Sword-Grip Ornaments (Menuki) Japanese 35         Fittings maker 127 Inscribed by Osozuka Hisanori Japanese, Edo period, active 19th century   Hisanori, Osozuka 3116 Japanese 74 1801 1900 19th century 1801 1900 Gold, copper-gold alloy (shakudō) 4705 Menuki (a); L. 1 1/2 in. (3.8 cm); Wt. 0.4 oz. (11.3 g); menuki (b); L. 1 1/8 in. (2.9 cm); Wt. 0.3 oz. (8.5 g) Gift of a trustee of the Museum, 1917                       Sword Furniture-Menuki 130   http://www.metmuseum.org/art/collection/search/35006 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
29900 29900 2006.405 0 1 35134 Arms and Armor 5 Sword guard (Tsuba) 1287 Sword Guard (Tsuba) Japanese 35         Fittings maker 127 Inscribed by Yoshitane Japanese, 19th century   Yoshitane 3118 Japanese 74 1801 1900 mid-19th century 1825 1875 Iron, copper 3588 H. 3 1/4 in. (8.3 cm); W. 3 1/8 in. (7.9 cm); thickness 3/16 in. (0.5 cm); Wt. 5.4 oz. (153.1 g) Purchase, Gift of Thomas Mendenhall, by exchange, 2006                       Sword Furniture-Tsuba 32   http://www.metmuseum.org/art/collection/search/35134 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30317 30317 2012.528.2 0 1 35912 Arms and Armor 5 Sword guard (Tsuba) 1287 Sword Guard (Tsuba) Japanese 35         Decorator 33 Inscribed by Honjo Yoshitane Japanese, Edo period, 19th century   Yoshitane, Honjo 3151 Japanese 74 1801 1900 19th century 1801 1900 Iron, gold, copper 3400 H. 2 3/4 in. (7 cm); W. 2 11/16 in. (6.8 cm); thickness 3/16 in. (0.5 cm); Wt. 3.7 oz. (104.9 g) Gift of the Baber Family, in loving memory of Charles Chenault Baber, 2012                       Sword Furniture-Tsuba 32   http://www.metmuseum.org/art/collection/search/35912 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
30319 30319 2012.528.4 0 0 35914 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Fittings maker 127 Inscribed by Ishiguro Koretsune Japanese, Edo period, 19th century   Koretsune, Ishiguro 3153 Japanese 74 1801 1900 19th century 1801 1900 Copper-gold alloy (shakudō), gold 4307 L. 3 13/16 in. (9.7 cm); W. 9/16 in. (1.4 cm) Gift of the Baber Family, in loving memory of Charles Chenault Baber, 2012                       Sword Furniture-Kozuka 112   http://www.metmuseum.org/art/collection/search/35914 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
18861 18861 32.75.289 0 0 23384 Arms and Armor 5 Three-pronged spear 1921 Three-pronged Spear Iranian 153         Maker 1   Muhammad Hasan Iranian, Qajar period, 19th century   Hasan, Muhammad 2806 Iranian 92 1801 1900 19th century 1801 1900 Steel, gold, wood 3520   The Collection of Giovanni P. Morosini, presented by his daughter Giulia, 1932                       Shafted Weapons 35   http://www.metmuseum.org/art/collection/search/23384 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
26149 26149 36.25.1294a, b 0 1 31301 Arms and Armor 5 Saber with scabbard 1732 Saber with Scabbard Turkish, Ottoman 934         Bladesmith 100 Blade signed by Acem Oglu Turkish, active 19th century   Oglu, Acem 3070 Turkish 109 1801 1900 19th century 1801 1900 Steel, silver-gilt, gold, agate, wood, leather 6124 L. 37 1/8 in. (94.3 cm) Bequest of George C. Stone, 1935                       Swords 29   http://www.metmuseum.org/art/collection/search/31301 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 2579.847ms · Data license: CC0 · Data source: metmuseum/openaccess