MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where Artist Nationality = 5 and Medium = 25

View and edit SQL

Suggested facets: Artist Role, Artist Prefix, Artist Begin Date, Artist End Date, Credit Line

Artist Nationality

  • American|American · 4
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
348643 1988.424.1 0 0 503350 Musical Instruments 18 Treble Violin 16625 Treble Violin American 1         Maker|Maker 6 Assisted by Carleen M. Hutchins|Carolyn Wilson Field Springfield, Massachusetts, 1911–2007 Wolfeboro, New Hampshire|American, New York 1926–   Hutchins Carleen M.|Field Carolyn 47932 American|American 5 1911 |1926 2007 |2026 1986 1986 1986 Wood 25 String length 22.3 cm (9 in.); Body length 28.9 cm (11-1/2 in.); Upper bouts 13.3 cm (5-1/4 in.); Center bouts 9 cm (4 in.); Lower bouts 16.3 cm (6-1/2 in.); Rib height 2cm (1 in.); Tailpiece length 9.8 cm (4 in.) Gift of Carleen M. and Morton A. Hutchins and the Harriet M. Bartlett Fund of the Catgut Acoustical Society, Inc., 1988   Montclair 2283   New Jersey 154 United States 3             Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
348646 1988.424.4 0 0 503353 Musical Instruments 18 Alto Violin 16628 Alto Violin American 1         Maker|Maker 6 Assisted by Carleen M. Hutchins|Reed Raphael Bernstein Springfield, Massachusetts, 1911–2007 Wolfeboro, New Hampshire|Philadelphia, born 1955   Hutchins Carleen M.|Bernstein Raphael 47934 American|American 5 1911 |1955 2007 |2055 1982 1982 1982 Wood 25 String length 42.2 cm (16-3/4 in.); Body length 52.5 cm (20-3/4 in); Upper bouts 24.4 cm (9-3/4 in.); Center bouts 16.7 cm (6-3/4 in.); Lower bouts 30.8 cm (12-1/4 in.); Rib height 4 cm (1-3/4 in.); Tailpiece length 18.5 cm (7-1/2 in.) Gift of Carleen M. and Morton A. Hutchins and the Harriet M. Bartlett Fund of the Catgut Acoustical Society, Inc., 1988   Montclair 2283   New Jersey 154 United States 3             Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
348649 1988.424.7 0 0 503356 Musical Instruments 18 Contrabass Violin 16631 Contrabass Violin American 1         Maker|Maker|Maker 29 Assisted by|Assisted by Carleen M. Hutchins|Donald Blatter|Thomas Coleman Springfield, Massachusetts, 1911–2007 Wolfeboro, New Hampshire|American, born Jersey City, New Jersey 1955   Hutchins Carleen M.|Blatter Donald|Coleman Thomas 47937 American|American 5 1911 |1955 2007 |2055 1985 1985 1985 Wood 25 String length 109.2 cm (43 in.); Body length 129.3 cm (51 in.); Upper bouts 62.7 cm (24-3/4in.); Center bouts 38 cm (15 in.); Lower bouts 79.2 cm (31-1/4 in.); Rib height 16.7 cm (6-3/4in.); Tailpiece length 43.8 cm (17-1/4 in.) Gift of Carleen M. and Morton A. Hutchins and the Harriet M. Bartlett Fund of the Catgut Acoustical Society, Inc., 1988   Montclair 2283   New Jersey 154 United States 3             Chordophone-Lute-bowed-unfretted 925   Metropolitan Museum of Art, New York, NY 1
348668 1989.343 0 0 503375 Musical Instruments 18 Small Bass Violin 16641 Small Bass Violin American 1         Maker|Maker|Maker 29 assisted by|assisted by Carleen M. Hutchins|Thomas P. McLoughlin|Diana Gannett Mizelle Springfield, Massachusetts, 1911–2007 Wolfeboro, New Hampshire|American, born Davenport, Iowa, 1947 1989.0 Hutchins Carleen M.|McLoughlin Thomas P.|Mizelle Diana G. 47945 American|American 5 1911 |1947 2007 |2047 1989 1989 1989 Wood 25 String length 105.3 cm (41-7/16 in.); Body length 104.4 cm (41-1/16 in.); Upper bouts 49.8 cm (19-5/8 in.); Center bouts 33.7 cm (13-1/4 in.); Lower bouts 64 cm (25-7/16 in.); Rib height 12.1 cm (4-3/4 in.);Tailpiece length 34.2 cm (13-7/16 in.) Gift of Carleen M. and Morton A. Hutchins and the Harriet M. Bartlett Fund of the Catgut Acoustical Society, Inc., 1989   Montclair 2283   New Jersey 154 United States 3             Chordophone-Lute-bowed-unfretted 925   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 2101.144ms · Data license: CC0 · Data source: metmuseum/openaccess