MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where "Artist Begin Date" is on date -4708-12-17 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 Name, Artist Display Bio, Artist Alpha Sort, Artist End Date, Object Date, Object End Date, Medium, Credit Line, Classification

Department

  • Arms and Armor · 9

Artist Begin Date (date)

  • -4708-12-17 · 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
418854 2015.491 0 0 693854 Arms and Armor 5 Photograph 997 Suraj Uddin Mending Chain Mail, Jaipur, 1926 Indian, Jaipur 852         Photography Studio 712 possibly by Gobindram and Oodeyram Indian, Jaipur, active late 19th–mid-20th century   Gobindram and Oodeyram 53232   1850 1975 1926 1926 1926 Probably gelatin silver print on mat board 60090 5 7/8 x 7 7/8 in. (15 x 20 cm); mat: 10 x 12 in. (25.4 x 30.5 cm) Purchase, 1926   Jaipur 1577                   Photographs 21   Metropolitan Museum of Art, New York, NY 1
418857 2015.492 0 0 693857 Arms and Armor 5 Photograph 997 Tools for Mending Chain Mail, Jaipur, 1926 Indian, Jaipur 852         Photography Studio 712 possibly by Gobindram and Oodeyram Indian, Jaipur, active late 19th–mid-20th century   Gobindram and Oodeyram 53232   1850 1975 1926 1926 1926 Probably gelatin silver print on mat board 60090 5 3/4 x 7 3/4 in. (14.6 x 17 cm); mat: 10 x 12 in. (25.4 x 30.5 cm) Purchase,1926   Jaipur 1577                   Photographs 21   Metropolitan Museum of Art, New York, NY 1
19853 36.25.1728a, b 0 0 24378 Arms and Armor 5 Blade and mounting for a sword (Katana) 1284 Blade and Mounting for a Sword (Katana) Japanese 35         Fittings maker 127 Fittings inscribed by Takagi Hidemune Japanese, active late 19th century   Hidemune, Takagi 2838 Japanese 74 1850 1900 blade, 16th century; mounting, 19th century 1501 1900 Steel, wood, lacquer, leather, gold, iron 4152 L. 32 18 in. (81.6 cm); L. of blade 28 1/4 in. (71.8 cm); L. of cutting edge 22 3/16 in. (56.4 cm); D. of curvature 3/8 in. (0.9 cm) Bequest of George C. Stone, 1935                       Swords 29   Metropolitan Museum of Art, New York, NY 1
20680 43.120.240 0 1 25244 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Maker 1   Hamano Haruchika Japanese, died ca.1850   Hamano Haruchika 2945 Japanese 74 1850 1850 19th century 1801 1900 Copper-silver alloy (shibuichi), gold, copper-gold alloy (shakudō) 4413 L. 3 13/16 in. (9.7 cm); W. 9/16 in. (1.4 cm); thickness 3/16 in. (0.5 cm); Wt. 1 oz. (28.3 g) Gift of Herman A. E. and Paul C. Jaehne, 1943                       Sword Furniture-Kozuka 112   Metropolitan Museum of Art, New York, NY 1
20686 43.120.253 0 1 25251 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Maker 1   Hamano Haruchika Japanese, died ca.1850   Hamano Haruchika 2945 Japanese 74 1850 1850 early 19th century 1801 1850 Copper-silver alloy (shibuichi), gold 4516 L. 3 13/16 in. (9.7 cm); W. 9/16 in. (1.4 cm); thickness 3/16 in. (0.5 cm); Wt. 1.1 oz. (31.2 g) Gift of Herman A. E. and Paul C. Jaehne, 1943                       Sword Furniture-Kozuka 112   Metropolitan Museum of Art, New York, NY 1
20718 43.120.385 0 1 25297 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Maker 1   Hamano Haruchika Japanese, died ca.1850   Hamano Haruchika 2945 Japanese 74 1850 1850 19th century 1801 1900 Copper-gold alloy (shakudō), iron, gold, silver, copper, brass 4544 L. 3 13/16 in. (9.7 cm); W. 9/16 in. (1.4 cm); thickness 3/16 in. (0.5 cm); Wt. 1.1 oz. (31.2 g) Gift of Herman A. E. and Paul C. Jaehne, 1943                       Sword Furniture-Kozuka 112   Metropolitan Museum of Art, New York, NY 1
20752 43.120.477 0 1 25339 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Maker 1   Hamano Haruchika Japanese, died ca.1850   Hamano Haruchika 2945 Japanese 74 1850 1850 late 18th–early 19th century 1750 1860 Copper-silver alloy (shibuichi), gold, silver 4517 L. 3 13/16 in. (9.7 cm); W. 9/16 in. (1.4 cm); thickness 3/16 in. (0.5 cm); Wt. 1.1 oz. (31.2 g) Gift of Herman A. E. and Paul C. Jaehne, 1943                       Sword Furniture-Kozuka 112   Metropolitan Museum of Art, New York, NY 1
21046 12.37.143 0 1 25647 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Maker 1   Akichika Oishi Japanese, active ca.1850   Oishi Akichika 2973 Japanese 74 1850 1850 late 18th–early 19th century 1800 1825 Copper-silver alloy (shibuichi), copper-gold alloy (shakudō), gold, copper 4510 L. 3 13/16 in. (9.7 cm); W. 9/16 in. (1.4 cm); thickness 1/4 in. (0.6 cm); Wt. 1.2 oz. (34 g) Rogers Fund, 1912                       Sword Furniture-Kozuka 112   Metropolitan Museum of Art, New York, NY 1
21401 36.120.237 0 1 26117 Arms and Armor 5 Knife handle (Kozuka) 1809 Knife Handle (Kozuka) Japanese 35         Maker 1   Hamano Haruchika Japanese, died ca.1850   Hamano Haruchika 2945 Japanese 74 1850 1850 19th century 1801 1900 Copper-silver alloy (shibuichi), gold, copper, copper-gold alloy (shakudō) 4549 L. 3 13/16 in. (9.7 cm); W. 9/16 in. (1.4 cm); thickness 1/4 in. (0.6 cm); Wt. 1.2 oz. (34 g) The Howard Mansfield Collection, Gift of Howard Mansfield, 1936                       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 2204.433ms · Data license: CC0 · Data source: metmuseum/openaccess