MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where "Artist End Date" is on date -4708-10-28 and Department = 18

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Highlight, Is Public Domain, Object Name, Title, Culture, Artist Begin Date, Medium, 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 Metadata Date Repository
345933 345933 89.2.158 0 0 500555 Musical Instruments 18 Pandurina 15407 Pandurina Italian 36         Maker 1 Signature possibly Plisbel Italian, Milan, 18th century   Plisbel 47633   1700 1800 1715 1715 1715 Wood, various materials 53943 L. 50.2 cm (19-3/4 in.); W. 15.9 cm (6-1/4 in.) Gift of Joseph W. Drexel, 1889   Milan 420     Italy 14             Chordophone-Lute-plucked-fretted 921   http://www.metmuseum.org/art/collection/search/500555 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
346236 346236 89.2.154 0 0 500864 Musical Instruments 18 Cavaco 15408 Cavaco Italian 36         Maker 1   Benedito Qualzatta Italian, 18th century   Qualzatta, Benedito 47654   1700 1800 1716 1716 1716 Gourd, ivory, wood, mother-of-pearl, tortoise shell 54073 L. 54.6 cm (21-1/2 in.); W. 14 cm (5-1/2 in.) Gift of Joseph W. Drexel, 1889         Italy 14             Chordophone-Lute-plucked-fretted 921   http://www.metmuseum.org/art/collection/search/500864 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
346989 346989 89.2.168 0 1 501633 Musical Instruments 18 Guitar 15412 Guitar Belgian 676         Maker 1   Guillaume Joseph Lekeu Belgian, Namur active late 18th century   Lekeu, Guillaume Joseph 47744 Belgian 20 1767 1800 1770 1770 1770 Various woods 51049   Gift of Joseph W. Drexel, 1889         Belgium 576             Chordophone-Lute-plucked-fretted 921   http://www.metmuseum.org/art/collection/search/501633 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347029 347029 89.4.1097 1 1 501675 Musical Instruments 18 Natural Trumpet in E-flat 16047 Natural Trumpet in D German 27         Maker 1   Andreas Naeplaesnigg Germany, active Jettingen ca. 1790   Naeplaesnigg, Andreas 47758 Germany 81 1780 1800 1790 1790 1790 Brass, colored rock 54368 Height (Perpendicular to bell): 26 7/16 in. (67.2 cm) Diameter (Of bell): 4 5/8 in. (11.7 cm) The Crosby Brown Collection of Musical Instruments, 1889   Jettingen 2189     Germany 16             Aerophone-Lip Vibrated-trumpet / trombone 931   http://www.metmuseum.org/art/collection/search/501675 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347137 347137 89.4.1226 0 1 501793 Musical Instruments 18 Harpsichord 8383 Harpsichord Italian 36         Maker 1   Giovanni Paolo Leoni Italian, active late 18th century   Leoni, Giovanni Paolo 47788 Italian 6 1750 1800 1773 1773 1773 Wood, various materials 53943 Inner instrument: L. 151.9 cm, W. 71.2 cm, D. 16.7 cm, 3-octave span 50.5 cm, Sounding lengths (lower choir, far plucking point): C/E 129.9 (13.3) c2 23.3 (6.8) c3 10.7 (4.3) (scaling is approximate because the bridge is coming unglued from the soundboard) The Crosby Brown Collection of Musical Instruments, 1889   Rome (?) 2200     Italy 14             Chordophone-Zither-plucked-harpsichord 923   http://www.metmuseum.org/art/collection/search/501793 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347691 347691 89.4.2204 0 1 502364 Musical Instruments 18 Trompe de Chasse in C 16306 Trompe de Chasse in C French 7         Maker 1   Joseph Raoux French, Paris ca. 1725–1800   Raoux, Joseph 47837 French 2 1725 1800 1759–69 1759 1769 Brass 12 Height (Perpendicular to bell): 12 1/2 in. (31.8 cm) Diameter (Of bell): 9 1/2 in. (24.1 cm) The Crosby Brown Collection of Musical Instruments, 1889   Paris 27     France 9             Aerophone-Lip Vibrated-horn 912   http://www.metmuseum.org/art/collection/search/502364 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
348496 348496 1981.480 0 1 503196 Musical Instruments 18 Viola d'Amore 15998 Viola d'Amore Italian 36         Maker 1   Joseph Gagliano Italian, Naples active 1770–1800 Naples   Gagliano, Joseph 47898 Italian (Naples) 3483 1770 1800 ca. 1780 1701 1800 Spruce, maple, ebony 54088 Body L. 35.7 cm (14-1/16 in.); Bowed string L. 48.7 (19-3/16 in.) Gift of H. H. Schambach, 1981   Naples 436     Italy 14             Chordophone-Lute-bowed-unfretted 925   http://www.metmuseum.org/art/collection/search/503196 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
348683 348683 1990.221 0 1 503391 Musical Instruments 18 Guitar 15412 Guitar Spanish 13         Maker 1   Benito Sanchez de Aguilera Spanish, Madrid, active 1790–1800   de Aguilera, Benito Sanchez 47953 Spanish 76 1790 1800 1797 1797 1797 Spruce or fir top, cypress back and ribs, mahogany neck, rosewood fingerboard and frets, ebony nut, gut strings 54849   Purchase, Clara Mertens Bequest, in memory of André Mertens, 1990   Madrid 467     Spain 5             Chordophone-Lute-plucked-fretted 921   http://www.metmuseum.org/art/collection/search/503391 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
348740 348740 1994.364 0 1 503457 Musical Instruments 18 Oboe 15393 Oboe Italian 36         Maker 1   Castel Italian? active second quarter 18th century to late 18th century   Castel 47984 Italian? 3505 1725 1800 ca. 1750 1745 1755 Wood, ivory, metal 54037 Length: app. 56.5 cm (22¼ in.) Purchase, Clara Mertens Bequest, in memory of André Mertens, 1994         Italy 14             Aerophone-Reed Vibrated-double reed 911   http://www.metmuseum.org/art/collection/search/503457 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 834.955ms · Data license: CC0 · Data source: metmuseum/openaccess