Data license: CC0 · Data source: metmuseum/openaccess
This data as json, CSV (advanced)
Suggested facets: Artist Display Name, Artist Display Bio, Artist Alpha Sort, Artist Begin Date, Object Date, Object Begin Date, Object End Date, Medium, Credit Line, City, 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 | Metadata Date | Repository |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 348567 | 348567 | 1986.351 | 0 | 0 | 503274 | Musical Instruments 18 | Tenor Trombone in B-flat 16585 | Tenor Trombone in B-flat | American 1 | Maker 1 | F.E. Olds & Son | American, Los Angeles 1910–1979 | Olds, F.E. 47918 | 1910 | 1979 | ca. 1914 | 1904 | 1924 | Brass 12 | Assembled L. (slide closed) 118.6 cm (46-13/16 in.); Bell Diam. 17.7 cm (6-15/16 in.) | Gift of Mrs. Harold H. Krechmer, in memory of her husband, Harold H. Krechmer, 1986 | Los Angeles 124 | California 405 | United States 3 | Aerophone-Lip Vibrated-trumpet / trombone 931 | http://www.metmuseum.org/art/collection/search/503274 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||
| 348951 | 348951 | 1980.544 | 0 | 0 | 503674 | Musical Instruments 18 | Guitar 15412 | Guitar | American 1 | Maker 1 | Bruce BecVar | born 1953 | BecVar Bruce 48066 | 1953 | 1973–74 | 1973 | 1974 | Ebony, koa, mahogany, rosewood, birdseye maple, benen, bone, wire, abalone, mother-of-pearl, ivory, ceramic, brass 54980 | Height: 39 1/8 in. (99.4 cm) Width: 17 5/16 in. (43.9 cm) Depth: 1 7/16 in. (3.7 cm) | Gift of Arthur N. BecVar, 1980 | Cotati 2305 | California 405 | United States 3 | Chordophone-Lute-plucked-fretted 921 | http://www.metmuseum.org/art/collection/search/503674 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 349520 | 349520 | 1981.137 | 0 | 0 | 504308 | Musical Instruments 18 | Double Tenor Ocarina 16982 | Double Tenor Ocarina | American 1 | Maker 1 | Alan Albright | Albright Alan 48264 | 20th century | 1900 | 1981 | Wood 25 | L.: 15.2 cm (6 in.) | Gift of Alan Albright, 1981 | San Francisco 194 | California 405 | United States 3 | Aerophone-Blow Hole-vessel flute 918 | http://www.metmuseum.org/art/collection/search/504308 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 349523 | 349523 | 1981.217.1 | 0 | 0 | 504311 | Musical Instruments 18 | Soprano Double Ocarina 16984 | Soprano Double Ocarina | American 1 | Maker 1 | Alan Albright | Albright Alan 48264 | 1981 | 1981 | 1981 | Wood 25 | Greater L.: 9.2 cm (3-5/8 in.); Greatest W.: 7.2 cm (2-7/8 in.); Greatest D.: 2.9 cm (1-1/9 in.) | Gift of Alan Albright, 1981 | San Francisco 194 | California 405 | United States 3 | Aerophone-Blow Hole-vessel flute 918 | http://www.metmuseum.org/art/collection/search/504311 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 349524 | 349524 | 1981.217.2 | 0 | 0 | 504312 | Musical Instruments 18 | Bass Double Ocarina 16985 | Bass Double Ocarina | American 1 | Maker 1 | Alan Albright | Albright Alan 48264 | 1981 | 1981 | 1981 | Wood 25 | Greatest L.: 24.5 cm (9-3/4 in.); Greatest W.: 14.5 cm (5-3/4 in.); Greatest D.: 6.2 cm (2-1/2 in.) | Gift of Alan Albright, 1981 | San Francisco 194 | California 405 | United States 3 | Aerophone-Blow Hole-vessel flute 918 | http://www.metmuseum.org/art/collection/search/504312 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 349525 | 349525 | 1981.217.3 | 0 | 0 | 504313 | Musical Instruments 18 | Alto Triple Ocarina 16986 | Alto Triple Ocarina | American 1 | Maker 1 | Alan Albright | Albright Alan 48264 | 1981 | 1981 | 1981 | Wood. 54048 | Greatest L. 16.7 cm (6-5/8 in.); Greatest W.: 11 cm (4-3/8 in.); Greatest D.: 4 cm (1-5/8 in.) | Gift of Alan Albright, 1981 | San Francisco 194 | California 405 | United States 3 | Aerophone-Blow Hole-vessel flute 918 | http://www.metmuseum.org/art/collection/search/504313 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||||
| 432743 | 432743 | 2016.412a, b | 0 | 0 | 718382 | Musical Instruments 18 | Electric Violin 16778 | Electric Violin | American 1 | Maker 1 | Rickenbacker International Corporation | American | Rickenbacker 55182 | 1932 | ca. 1938 | 1933 | 1943 | Aluminum, maple, ebony 61396 | Height: 23 1/2 in. (59.7 cm) Width (At widest): 5 in. (12.7 cm) | Purchase, Steve Miller Gift, 2016 | California 405 | United States 3 | Chordophone-Lute-bowed-unfretted 925 | http://www.metmuseum.org/art/collection/search/718382 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | ||||||||||||||||||
| 432768 | 432768 | 2016.413a–d | 0 | 0 | 718415 | Musical Instruments 18 | Electric Guitar 17542 | Electro Vibrola Spanish Electric Guitar | American 1 | Maker 1 | Rickenbacker International Corporation | American | Rickenbacker 55182 | 1932 | 1939 | 1939 | 1939 | Bakelite 52950 | Overall length 32-1/2 in. (82.6 cm); width 9-1/4 in. (23.5 cm) at lower bout; depth 3-1/4 in. (8.3 cm). Scale length 22-1/2 in. (572 mm). Width of nut 1-3/4 in. (44 mm) | Purchase, The Jonathan & Faye Kellerman Foundation Gift, 2016 | Los Angeles 124 | California 405 | United States 3 | Chordophone-Lute-plucked-fretted 921 | http://www.metmuseum.org/art/collection/search/718415 | 4/23/2018 8:00:01 AM | Metropolitan Museum of Art, New York, NY 1 | |||||||||||||||||
| 438477 | 438477 | 2016.557a–d | 0 | 0 | 729575 | Musical Instruments 18 | Lap Steel Electric Guitar 27112 | "Frying Pan" Electro Hawaiian Guitar | American 1 | Maker 1 | Rickenbacker International Corporation | American | Rickenbacker 55182 | 1932 | ca. 1934 | 1929 | 1939 | cast aluminum, gold enamel, bakelite 61719 | 28 3/4 × 7 × 1 5/8 in. (73 × 17.8 × 4.1 cm) | Purchase, Amati Gifts, 2016 | Los Angeles 124 | California 405 | United States 3 | Chordophone-Lute-plucked-fretted 921 | http://www.metmuseum.org/art/collection/search/729575 | 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");