Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Is Public Domain, Object Name, Title, Culture, Artist Nationality, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, Country, Classification, Artist Begin Date (date), Artist End Date (date)
| 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 ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 346871 | 346871 | 89.4.897 | 0 | 1 | 501508 | Musical Instruments 18 | Clarinet in A 15962 | Clarinet in A | Belgian 676 | Maker 1 | Probably by | Louis Auguste Giboreau | Belgian, Dreux 1820–1873 Liège | Giboreau 47713 | Belgian 20 | 1820 | 1873 | 19th century | 1801 | 1900 | Boxwood, brass, ivory, ebony 54322 | Total length 690 mm., Bell diam. 85 mm., Mouthpiece length 90 mm., Barrel length 72 mm., Upper body section length 226 mm., Lower body/ bell length 360 mm. | The Crosby Brown Collection of Musical Instruments, 1889 | Liege 570 | Belgium 576 | Aerophone-Reed Vibrated-single reed cylindrical 953 | http://www.metmuseum.org/art/collection/search/501508 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
| 346912 | 346912 | 89.4.941a, b | 0 | 1 | 501551 | Musical Instruments 18 | Double Bass and Bow 15996 | Double Bass and Bow | French 7 | Maker 1 | Probably by | Charles Plumerel | French, mid-19th century | Plumerel, Charles 47728 | 1800 | 1900 | mid to late 18th century | 1733 | 1800 | wood, brass 17235 | 89.4.491 a: Body length: 1125/1120 cm (top/back) (442.9/440.9 in.); Upper bouts: 530/520 cm (208.66/204.72 in.): Center bouts: 357/348 cm (140.55/137.01in.); Lower bouts: 658/645 cm (259.1/253.9in.); Rib heights: 156/200/197 cm (upper/center/tail) (61.4/78.7/77.6 in.); Max. Ht. arching 256 cm (100.8 in.); String length 1070 cm (421.26 in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Mirecourt 2179 | France 9 | Chordophone-Lute-bowed-unfretted 925 | http://www.metmuseum.org/art/collection/search/501551 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 347110 | 347110 | 89.4.1188 | 0 | 1 | 501759 | Musical Instruments 18 | Portative Organ 16086 | Portative Organ | Italian 36 | Maker 1 | Probably by | Leopoldo Franciolini | Italian, Florence 1844–1920 Florence | Franciolini, Leopoldo 47755 | Italian 6 | 1844 | 1920 | late 19th century | 1867 | 1900 | Wood, various materials 53943 | Total h. 61.3 cm, W. 59.7 cm, L. perpendicular to keyboard 41.6; 3-octave span 51.8 | The Crosby Brown Collection of Musical Instruments, 1889 | Florence 562 | Italy 14 | Aerophone-Organ 906 | http://www.metmuseum.org/art/collection/search/501759 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
| 349343 | 349343 | 1991.349.49a, b | 0 | 0 | 504119 | Musical Instruments 18 | Flute 5809 | Flute | Maker 1 | Probably by | Jean Francois Martin | French, La Couture 1794–1876 La Couture | Martin Jean Francois 48202 | French 2 | 1794 | 1876 | 1827–40 | 1800 | 1850 | Boxwood, ivory, silver 54853 | 630mm/555mm at a' 440; 623mm/548mm at a' 430; 611mm/536mm at a' 440 | Gift of Robert Alonzo Lehman, 1991 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/504119 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 349349 | 349349 | 1991.349.55 | 0 | 0 | 504125 | Musical Instruments 18 | Flute 5809 | Flute | Maker 1 | Probably by | Edward Riley | American (born England) 1769–1829 New York | later of New York | Riley Edward 48183 | 1769 | 1829-08-18 | 19th century | 1800 | 1899 | Boxwood, ivory, silver 54853 | 608mm/528mm | Gift of Robert Alonzo Lehman, 1991 | Aerophone-Blow Hole-side-blown flute (transverse) 941 | http://www.metmuseum.org/art/collection/search/504125 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 349944 | 349944 | 89.4.2417 | 0 | 0 | 504781 | Musical Instruments 18 | Sopranino Flugelhorn (Valve Bugle) in E-flat 17144 | Sopranino Flugelhorn (Valve Bugle) in E-flat | Italian 36 | Maker 1 | Probably by | Giuseppe Pelitti | Italian, Varese 1811–1865 Milan | Pelitti, Giuseppe 48149 | Italian 6 | 1811-07-31 | 1865-04-24 | ca. 1835 | 1835 | 1835 | Brass 12 | Overall: 13 x 30.4cm (5 1/8 x 11 15/16in.) | The Crosby Brown Collection of Musical Instruments, 1889 | Milan 420 | Italy 14 | Aerophone-Lip Vibrated-horn 912 | http://www.metmuseum.org/art/collection/search/504781 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||
| 350492 | 350492 | 89.4.2906 | 0 | 0 | 505414 | Musical Instruments 18 | Bass Sarrusophone 17375 | Bass Sarrusophone | French 7 | Maker 1 | Probably by | Gautrot-Marquet | French, Paris 1875–1884 | Gautrot-Marquet 47835 | French 2 | 1875 | 1884 | ca. 1856–89 | 1856 | 1889 | Brass 12 | Overall: 17.2 x 123.7cm (6 3/4 x 48 11/16in.) | The Crosby Brown Collection of Musical Instruments, 1889 | France 9 | Aerophone-Reed Vibrated-double reed 911 | http://www.metmuseum.org/art/collection/search/505414 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 |
JSON shape: default, array, newline-delimited
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");