MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

13 rows where Is Public Domain = 1, Object End Date = 1900 and Object Name = 6840

View and edit SQL

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
346444 89.4.457 0 1 501075 Musical Instruments 18 Horn 6840 Horn Tanzanian (Zanzibar) 6229                           late 19th century 1850 1900 Ivory 148 L. 29.8 cm (11-3/4 in.) The Crosby Brown Collection of Musical Instruments, 1889       Zanzibar 888 Tanzania 95             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346445 89.4.458 0 1 501076 Musical Instruments 18 Horn 6840 Horn possibly Congolese 6230                           late 19th century 1850 1900 Horn 5092 L. 38.1 cm (15 in.); Diam. of large end 5.1 cm (2 in.) The Crosby Brown Collection of Musical Instruments, 1889         Democratic Republic of the Congo? 766             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346446 89.4.459 0 1 501077 Musical Instruments 18 Horn 6840 Horn Tanzanian 6231                           late 19th century 1850 1900 Horn 5092 L. 25.9 x Diam. narrow end 1.2 - 7.9 wider end (10 3/16 x 1/2 - 3 1/8) The Crosby Brown Collection of Musical Instruments, 1889       Zanzibar 888 Tanzania 95             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346447 89.4.461 0 1 501079 Musical Instruments 18 Horn 6840 Horn Mongo (Bakutu) people 6232         Maker 1   Bakutu     Bakutu 47667 West Coast Africa 3484     late 19th century 1850 1900 Ivory, snakeskin 54157 L. 50.8 cm (20 in.) The Crosby Brown Collection of Musical Instruments, 1889         Democratic Republic of the Congo 93             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346449 89.4.463 0 1 501081 Musical Instruments 18 Horn 6840 Horn Probably Igbo people 6234                           late 19th century 1850 1900 Ivory 148 Height: 21 5/8 in. (54.9 cm) Diameter: 2 1/16 in. (5.2 cm) The Crosby Brown Collection of Musical Instruments, 1889         Nigeria 83             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346450 89.4.464 0 1 501082 Musical Instruments 18 Horn 6840 Horn Probably Igbo people 6234                           late 19th century 1850 1900 Ivory 148 L. 65 x diam. 5.3 cm (25 5/8 x 2 1/8 in) The Crosby Brown Collection of Musical Instruments, 1889         Nigeria 83             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346451 89.4.465 0 1 501083 Musical Instruments 18 Horn 6840 Horn possibly Congolese 6230                           late 19th century 1850 1900 Ivory, leather, reptile skin 54158 L. 100.7 cm (39 5/8 in.); Diam. at narrow end ±3.2 cm (1 1/4 in) Oval wider end H. 13.7 x W. 12 cm (5 3/8 x 4 3/4 in) The Crosby Brown Collection of Musical Instruments, 1889         possibly Dem. Rep. of Congo 767             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346453 89.4.467 0 1 501085 Musical Instruments 18 Horn 6840 Horn Xhosa 6236                           late 19th century 1850 1900 Horn 5092 L. 91.4 cm (36 in.) The Crosby Brown Collection of Musical Instruments, 1889       Transkei 890 South Africa 77             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346454 89.4.468 0 1 501086 Musical Instruments 18 Horn 6840 Horn Mayumba 6237         Maker 1   Mayumba people Congo   Mayumba people 47668 Congo 3485     late 19th century 1850 1900 Wood 25 L. 63.5 cm (25 in.); Diam. of large end 9.8 cm (3-7/8 in.) The Crosby Brown Collection of Musical Instruments, 1889         Congo 768             Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
346455 89.4.469 0 1 501087 Musical Instruments 18 Horn 6840 Horn                             late 19th century 1850 1900 Ivory 148 L. 16.5 x Diam.162.6 cm (6 1/2 x 64in.) The Crosby Brown Collection of Musical Instruments, 1889                       Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
347062 89.4.1132 0 1 501708 Musical Instruments 18 Horn 6840 Horn possilby French 6377                           19th century 1801 1900 Wood, leather, ivory 54372 Length ca. 980 mm, Diam. of bell ca. 115 mm The Crosby Brown Collection of Musical Instruments, 1889         France? 797             Aerophone-Lip Vibrated-trumpet / trombone 931   Metropolitan Museum of Art, New York, NY 1
347068 89.4.1139 0 1 501715 Musical Instruments 18 Horn 6840 Horn                             late 19th century 1850 1900 ivory, metal 18117 L. 22 5/8 x Diam. Larger end-3 11/16 x 3 3/8; Smaller end 1 15/16 x 1 9/16 (57.5 x 9.3 x 8.5; 5 x 4 cm ) The Crosby Brown Collection of Musical Instruments, 1889                       Aerophone-Lip Vibrated-horn 912   Metropolitan Museum of Art, New York, NY 1
347069 89.4.1140 0 1 501716 Musical Instruments 18 Horn 6840 Horn French 7                           19th century 1801 1900 silver-plated copper 54375 L. 63.7 cm, Diam. of bell 18.7 cm. The Crosby Brown Collection of Musical Instruments, 1889         France 9             Aerophone-Lip Vibrated-horn 912   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 7544.347ms · Data license: CC0 · Data source: metmuseum/openaccess