MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Object Begin Date = 1801 and Object Name = 6840

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Date, Object End Date, Medium, Credit Line, Classification

Object Begin Date ✖

  • 1801 · 8 ✖
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 Metadata Date Repository
345914 345914 X.308 0 0 500534 Musical Instruments 18 Horn 6840 Horn                             19th century 1801 1900 Ivory 148 L. 13 1/4 in. Museum Accession                       Aerophone-Lip Vibrated-horn 912   http://www.metmuseum.org/art/collection/search/500534 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347062 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   http://www.metmuseum.org/art/collection/search/501708 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347069 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   http://www.metmuseum.org/art/collection/search/501716 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347077 347077 89.4.1152 0 1 501725 Musical Instruments 18 Horn 6840 Horn Dutch 4                           early 19th century 1801 1825 Wood, bark 54378 Length 1052 mm, Diam. of bell 70 mm at widest The Crosby Brown Collection of Musical Instruments, 1889   Netherlands 2193     Friesland 808             Aerophone-Lip Vibrated-horn 912   http://www.metmuseum.org/art/collection/search/501725 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347167 347167 89.4.1257 0 0 501823 Musical Instruments 18 Horn 6840 Horn Probably Mende people 6385                           19th century 1801 1900 Ivory tusk 54402 Height: 32 1/2 in. (82.6 cm) Diameter: 3 1/2 in. (8.9 cm) The Crosby Brown Collection of Musical Instruments, 1889         Probably Sierra Leone 812             Aerophone-Lip Vibrated-horn 912   http://www.metmuseum.org/art/collection/search/501823 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347645 347645 89.4.1771 0 0 502318 Musical Instruments 18 Horn 6840 Horn German? 6371                           19th century (?) 1801 1900 Horn, wood 4166 Length of tube without mouthpiece 552 mm, with mouthpiece 577 mm; Diameter of bell at widest 49 mm The Crosby Brown Collection of Musical Instruments, 1889         Germany? 744             Aerophone-Lip Vibrated-horn 912   http://www.metmuseum.org/art/collection/search/502318 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
350311 350311 89.4.2730 0 0 505205 Musical Instruments 18 Horn 6840 Horn Congolese 6193                           19th century 1801 1900 Ivory 148 L. 88.8 x Diam. 2.5 - ±97 (34 1/16 x diam. 1 x ±3 15/16 in) The Crosby Brown Collection of Musical Instruments, 1889         possibly Dem. Rep. Congo 953             Aerophone-Lip Vibrated-horn 912   http://www.metmuseum.org/art/collection/search/505205 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
350732 350732 89.4.3391 0 0 505713 Musical Instruments 18 Horn 6840 Horn Possibly Congolese 6756                           19th century 1801 1900 Ivory 148 L. 37 x Diam. 3 - ovoi H. 5.8 x W. ±4 cm (L. 14 9/16 x diam. 1 1/4 - ovoid H. 2 1/4 x W. ±1 1/2 in) The Crosby Brown Collection of Musical Instruments, 1889                       Aerophone-Lip Vibrated-horn 912   http://www.metmuseum.org/art/collection/search/505713 4/23/2018 8:00:01 AM 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 161.93ms · Data license: CC0 · Data source: metmuseum/openaccess