MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

3 rows where Artist Prefix = "Assisted by" and Medium = 25

View and edit SQL

Suggested facets: Artist Nationality

Artist Prefix

  • Assisted by · 3
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
348648 1988.424.6 0 0 503355 Musical Instruments 18 Baritone Violin 16630 Baritone Violin American 1         Maker|Maker 6 Assisted by Carleen M. Hutchins|Rafael Bronstein Springfield, Massachusetts, 1911–2007 Wolfeboro, New Hampshire   Hutchins Carleen M.|Bronstein Rafael 47936 American 1 1911 2007 1985 1985 1985 Wood 25 String length 74.1 cm (29-1/4 in.); Body length 86.6 cm (34-1/4 in.); Upper bouts 41.5 cm (16-1/2); Center bouts 28.4 cm (11-1/4 in.); Lower bouts 53.1 cm (21-18 in.) Rib height 13.8 cm; (5-1/2 in.) Tailpiece length 30.1 cm (12 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

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 979.83ms · Data license: CC0 · Data source: metmuseum/openaccess