MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

11 rows where Culture = 261

View and edit SQL

Suggested facets: Is Public Domain, Department, Object Name, Title, Object Date, Object Begin Date, Object End Date, Credit Line, Country, 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
18446 27.68.6, .7 0 0 22968 Arms and Armor 5 Pair of mail sleeves 1764 Pair of Mail Sleeves Probably German 261                           probably 14th to 15th century 1301 1499 Steel 658 27.68.6: L. 36 in. (91.44 cm); W. 2 3/4 in. (7.01 cm); 27.68.7: L. 39 in. (99.06 cm); W. 17 1/2 in. (44.45 cm) Rogers Fund, 1927                       Mail 63   Metropolitan Museum of Art, New York, NY 1
28526 14.25.1537 0 0 33715 Arms and Armor 5 Shirt of mail 2073 Shirt of Mail Probably German 261                           15th century 1450 1450 Steel, copper alloy (latten) 6837 H. 26 13/16 in. (68 cm); W. at chest, 22 13/16 in.; W. 43 11/16 in. (111 cm); Diam (outside) of collar links 15/32 in. (12.1 mm); Diam. (inside) of collar links 11/32 in. (8.1 mm); Diam. (outside) of solid links 3/8 in. (9.6 mm); Diam. (inside) of solid links 7/32 in. (5.7 mm); Diam. (outside) of body links 3/8 in. (10.0 mm); Diam. (inside) of body links 1/4 in. (6.8 mm); Diam. (outside) of sleeve links 5/16 in. (8.1 mm); Diam. (inside) of sleeve links 9/32 in. (6.9 mm) Gift of William H. Riggs, 1913                       Mail 63   Metropolitan Museum of Art, New York, NY 1
28530 14.25.1542a, b 0 0 33719 Arms and Armor 5 Coat of mail (with separate sleeves) 3591 Coat of Mail (With Separate Sleeves) Probably German 261                           15th century 1401 1500 Iron, copper alloy (latten) 6838 14.25.1542a (shirt): H. 25 3/16 in. (64 mm); W. 22 in. (56 mm); Diam. (outside) of collar links 13/32 in. (10.2 mm); Diam. (inside) of collar links 1/4 in. (6.6 mm); Diam. (outside) of body links 13/32 in. (10.2 mm); Diam. (inside) of body links 9/32 in. (7.1 mm) Gift of William H. Riggs, 1913                       Mail 63   Metropolitan Museum of Art, New York, NY 1
28534 14.25.1546 0 0 33723 Arms and Armor 5 Shirt of mail 2073 Shirt of Mail Probably German 261                           16th century 1501 1600 Steel, copper alloy (latten) 6833 Diam. (outside) of body links 3/8 in. (9.0 mm); Diam. (inside) of body links 7/32 in. (5.9 mm); Diam. (outside) of collar links 9/32 in. (9.0 mm); Diam. of link wire 1/32 in. (1.0 mm) Gift of William H. Riggs, 1913                       Mail 63   Metropolitan Museum of Art, New York, NY 1
28537 14.25.1552 0 0 33726 Arms and Armor 5 Shirt of mail 2073 Shirt of Mail Probably German 261                           16th century 1501 1600 Steel, copper alloy 3537 H. 25 5/8 in. (65.0 cm); W. 44 1/2 in. (113 cm); W. of chest, 22 13/16 in. (58 cm), Diam. (outside) of body links 13/32 in. (10.5 mm); Diam. (inside) of body links 9/32 in. (5.8 mm); Diam. (outside) of sleeve links 3/8 in. (9.9 mm); Diam. (inside) of sleeve links 5/16 in. (7.7mm) Gift of William H. Riggs, 1913                       Mail 63   Metropolitan Museum of Art, New York, NY 1
347404 89.4.1495 0 0 502070 Musical Instruments 18 Rufhorn 16198 Rufhorn Probably German 261                           late 18th or early 19th century 1767 1833 horn (cow?) 54473 Length 336 mm, Diameter of bell 32 mm The Crosby Brown Collection of Musical Instruments, 1889         Germany? 744             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
347405 89.4.1496 0 0 502071 Musical Instruments 18 Rufhorn 16198 Rufhorn Probably German 261                           late 18th or early 19th century 1767 1833 Horn (cow?) 54474 Length 251 mm, Diam. of bell 33 mm The Crosby Brown Collection of Musical Instruments, 1889         Germany? 744             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
347442 89.4.1533 0 0 502108 Musical Instruments 18 Dulcimer 16027 Dulcimer Probably German 261                           mid-19th century 1833 1867 Wood and various materials. 54355 Length--long edge/ short edge 92.2/ 43 cm, body width perpendicular to long edge 28.5 cm, Body depth ca. 6.7 cm, Diameter of rosettes 2.7 cm The Crosby Brown Collection of Musical Instruments, 1889         Germany? 744             Chordophone-Zither-struck-dulcimer 927   Metropolitan Museum of Art, New York, NY 1
347471 89.4.1563 0 0 502138 Musical Instruments 18 Racket 16230 Racket Probably German 261                           19th century 1801 1900 Wood, leather, brass 144 Length of cylinder 260 mm The Crosby Brown Collection of Musical Instruments, 1889         Germany? 744             Aerophone-Reed Vibrated-double reed 911   Metropolitan Museum of Art, New York, NY 1
349198 89.4.2205 0 1 503970 Musical Instruments 18 Horn in D 16873 Horn in D Probably German 261                           first half 18th century 1700 1749 Pottery 7419 L. standing on bell: 34.7 cm (13-3/4 in.); Diam. of bell:16 cm (6-3/8 in.) The Crosby Brown Collection of Musical Instruments, 1889         Germany (probably) 894             Aerophone-Lip Vibrated 1012   Metropolitan Museum of Art, New York, NY 1
350566 89.4.3162 0 1 505518 Musical Instruments 18 Gothic Harp 17407 Gothic Harp Probably German 261                           18th century 1700 1799 Wood, metal 6120 H. 55 11/16 x W. 10 13/16 in. (141.5 x 27.5 cm) The Crosby Brown Collection of Musical Instruments, 1889         Probably Germany 963             Chordophone-Harp 967   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 122.906ms · Data license: CC0 · Data source: metmuseum/openaccess