MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

4 rows where "Artist End Date" is on date -4707-05-23 and Medium = 25

View and edit SQL

Suggested facets: Artist Role, Artist Display Name, Artist Alpha Sort

Artist End Date (date)

  • -4707-05-23 · 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
348644 1988.424.2 0 0 503351 Musical Instruments 18 Soprano Violin 16626 Soprano Violin American 1         Maker 1   Carleen M. Hutchins Springfield, Massachusetts, 1911–2007 Wolfeboro, New Hampshire   Hutchins Carleen M. 47933 American 1 1911 2007 1979 1979 1979 Wood 25 String length 28.6 cm (11-1/4 in.); Body length 31.7 cm (12-1/2); Upper bouts 15.5 cm (6-1/4 in.; Center bouts 10.6 cm (4-1/4 in.); Lower bouts 20 cm (8 in.); Rib height 2 cm (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
348645 1988.424.3 0 0 503352 Musical Instruments 18 Mezzo Violin 16627 Mezzo Violin American 1         Maker 1   Carleen M. Hutchins Springfield, Massachusetts, 1911–2007 Wolfeboro, New Hampshire   Hutchins Carleen M. 47933 American 1 1911 2007 1976 1976 1976 Wood 25 String length 33.8 cm (13-1/4 in.); Body length 38.3 cm (15-1/4 in.); Upper bouts 18 cm (7-1/4 in.) ; Center bouts 12.4 cm (5 in.) Lower bouts 23 cm;Rib height 2 cm (1 in.); Tailpiece length 12.3 cm (5 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
348845 2002.571.6 0 0 503564 Musical Instruments 18 Vertical Viola Top 16704 Vertical Viola Top           Maker 1   Carleen M. Hutchins Springfield, Massachusetts, 1911–2007 Wolfeboro, New Hampshire   Hutchins Carleen M. 47933 American 1 1911 2007 1998 1998 1998 Wood 25 Overall: 30.8 x 2.5 x 51.3cm (12 1/8 x 1 x 20 3/16in.) Gift of Carleen Maley Hutchins, 2002   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 2524.658ms · Data license: CC0 · Data source: metmuseum/openaccess