MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

9 rows where Classification = 908 and Medium = 5548 sorted by Title

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, Country

Classification ✖

  • Idiophone-Shaken-rattle · 9 ✖
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
347193 347193 89.4.1284 0 0 501850 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1800 1899 Clay 5548 H. 46 mm, W. 29 mm, D. 53 mm, Wt. 20 g The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/501850 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347944 347944 89.4.2062 0 0 502629 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           late 19th century 1866 1900 Clay 5548 H. 64 mm, W. 72 mm, D. 69 mm, Wt. 91 g The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/502629 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
347947 347947 89.4.2065 0 1 502632 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11 Pre-Columbian                         1200–1521 1200 1521 Clay 5548 Weight 79 g, Diamter 54 mm. The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1 Central Plateau Region 604           Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/502632 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
349721 349721 89.4.3460 0 1 504532 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Aztec 4364 Late Postclassic (Pre-Columbian)                         1200–1521 1200 1521 Clay 5548 Diameter: 1 11/16 in. (4.3 cm) Weight: 1.376 oz. (39 g) The Crosby Brown Collection of Musical Instruments, 1889   Mazapa 2341   Texcoco District 1016 Mexico 1             Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/504532 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
349722 349722 89.4.3464 0 0 504533 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H: 84 mm; D: 61 mm; W: 49 mm; Wt: 89 grams The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/504533 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
349724 349724 89.4.3465 0 0 504535 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H: 69 mm; W: 37 mm; D: 36 mm; Wt: 53 grams The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/504535 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
349725 349725 89.4.3466 0 0 504536 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H: 75 mm; W: 35 mm; D: 46 mm; Wt: 55 grams The Crosby Brown Collection of Musical Instruments, 1889         Mexico 1             Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/504536 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
349726 349726 89.4.3468 0 0 504537 Musical Instruments 18 Pottery Rattle 16117 Pottery Rattle Mexican 11                           19th century 1801 1900 Clay 5548 H: 79 mm; W: 48 mm; D: 62 mm; Wt: 50 grams The Crosby Brown Collection of Musical Instruments, 1889   Texcoco 2342     Mexico 1             Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/504537 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
349713 349713 89.4.2224 0 1 504522 Musical Instruments 18 Rattle 744 Rattle Panamanian 1994 Period VI                         800–1525 800 1525 Clay 5548 W. 53 mm x D. 44 mm x L. 173mm (2 1/16 x 1 3/4 x 6 13/16 in.); Weight: 210 grams The Crosby Brown Collection of Musical Instruments, 1889         Panama 115             Idiophone-Shaken-rattle 908   http://www.metmuseum.org/art/collection/search/504522 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 284.347ms · Data license: CC0 · Data source: metmuseum/openaccess