MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where "Artist Begin Date" is on date -4708-10-29, Culture = 35 and Department = 5

View and edit SQL

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

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
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   Metropolitan Museum of Art, New York, NY 1
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   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 1879.401ms · Data license: CC0 · Data source: metmuseum/openaccess