MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where County = 104

View and edit SQL

Suggested facets: Is Public Domain, Object Name, Title, Artist Role, Artist Prefix, Artist Nationality, Object Begin Date, Object End Date, Medium, 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
17385 91.2.49 0 0 21884 Arms and Armor 5 Blade and mounting for a short sword (Wakizashi) 1294 Blade and Mounting for a Short Sword (Wakizashi) Japanese 35                           blade, possibly 17th century; mounting 19th century 1601 1900 Steel, wood, lacquer, baleen, silver, copper-gold alloy (shakudō), gold, copper, pearl 3461 L. 28 1/8 in. (71.4 cm); L. of blade 23 7/8 in. (60.6 cm); L. of cutting edge 18 7/16 in. (46.9 cm); D. of curvature 3/4 in. (1.9 cm) Gift of Brayton Ives and W. T. Walters, 1891       Saga Prefecture 104               Swords 29   Metropolitan Museum of Art, New York, NY 1
19459 36.25.1751a, b 0 0 23983 Arms and Armor 5 Blade and mounting for a sword (Katana) 1284 Blade and Mounting for a Sword (Katana) Japanese 35         Swordsmith 92 Blade inscribed by Tadahiro (second generation) Japanese, active mid-17th century   Tadahiro (second generation) 2824 Japanese 74 1625 1675 blade, dated 1632; mounting, 19th century 1632 1900 Steel, wood, lacquer, ray skin (samé), thread, copper-gold alloy (shakudō), dark red copper (hiirodō) 4015 L. 38 in. (96.5 cm); L. of cutting edge 26 5/16 in. (66.9 cm); D. of curvature 11/16 in. (1.8 cm) Bequest of George C. Stone, 1935       Saga Prefecture 104               Swords 29   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
26439 36.25.1711a–c 0 0 31591 Arms and Armor 5 Blade and mounting for a short sword (Wakizashi) 1294 Blade and Mounting for a Short Sword (Wakizashi) Japanese 35                           blade, 17th century; mounting, 19th century 1601 1900 Steel, wood, lacquer, copper, silver, coral, turquoise, copper-silver alloy (shibuichi) 6271 L. 21 13/16 in. (55.4 cm); L. of the blade 20 5/8 in. (52.4 cm); L. of cutting edge 16 7/8 in. (42.9 cm); D. of curvature 1/4 in. (0.6 cm) Bequest of George C. Stone, 1935       Saga Prefecture 104               Swords 29   Metropolitan Museum of Art, New York, NY 1
30257 2012.36a–d 0 0 35817 Arms and Armor 5 Blade for a sword (Katana) 1638 Blade for a Sword (Katana) Japanese 35         Swordsmith|Steel-chiseler 179 Blade inscribed by|Decorated by Masahiro|Kokeguchi Senshu Japanese, Hizen 1607–1665|Japanese, born 1929   Masahiro|Kokeguchi, Senshu 3137 Japanese|Japanese 72 1607 |1929 1665 |2029 dated 1653; decorated 1980 and 2006 1653 2006 Steel 658 L. 33 3/4 in. (85.7 cm); L. of cutting edge 26 7/8 in. (68.1 cm); D. of curvature 5/8 in. (1.7 cm) Purchase, Gift of Brayton Ives and W. T. Walters, by exchange, 2012       Saga Prefecture 104               Sword Blades 70   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 114.553ms · Data license: CC0 · Data source: metmuseum/openaccess