MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Department = 18, Is Public Domain = 0 and Medium = 161

View and edit SQL

Suggested facets: Object Name, Title, Culture, Object Date, Object Begin Date, Object End Date, 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 Repository
347055 89.4.1125 0 0 501701 Musical Instruments 18 Bell 64 Bell Italian 36                           late 19th century 1867 1900 Ceramic 161 H. 188 cm, Diam. 165 cm, Wt. 723 g The Crosby Brown Collection of Musical Instruments, 1889         Italy 14             Idiophone-Struck-bell-clapper 950   Metropolitan Museum of Art, New York, NY 1
348510 1982.171.5 0 0 503210 Musical Instruments 18 Hun 16565 Hun Korean 220                           ca. 1980 1970 1990 Ceramic 161 Max Diam. 10.1 cm (3-15/16 in.); H. 9.5 cm (3-3/4 in.) Gift of Korean Cultural Service, 1982         Korea 731             Aerophone-Blow Hole-vessel flute 918   Metropolitan Museum of Art, New York, NY 1
348662 1989.201 0 0 503369 Musical Instruments 18 Kimkim 16637 Kimkim American 1         Maker 1   Dr. Abbas Magaji Ahuwan Nigerian, born 1947   Ahuwan Abbas 47944 Nigerian 730 1947   1989 1989 1989 Ceramic 161 Height: 17 1/2 in. (44.5 cm) Diameter: 13 3/8 in. (34 cm) Rogers Fund, 1989   Freehold 360   New York 126 United States 3             Aerophone and Idiophone-flue blown / vessel rattle 966   Metropolitan Museum of Art, New York, NY 1
348663 1989.212 0 0 503370 Musical Instruments 18 Kimkim 16637 Kimkim American 1         Maker 1   Dr. Abbas Magaji Ahuwan Nigerian, born 1947   Ahuwan Abbas 47944 Nigerian 730 1947   1989 1989 1989 Ceramic 161 Height: 16 5/8 in. (42.3 cm) Diameter: 9 1/16 in. (23 cm) Gift of Dr. Abbas Magaji Ahuwan, 1989   Freehold, NY 2272     United States 3             Aerophone and Idiophone-flue blown / vessel rattle 966   Metropolitan Museum of Art, New York, NY 1
349379 1989.188 0 0 504156 Musical Instruments 18 Flügelhorn 16934 Flügelhorn French 7                           mid to late 19th century 1850 1900 Ceramic 161 L. 47.5 cm (18 1/2 in.); Bell Diam. 18.5 cm (7 1/4 in.) Purchase, Clara Mertens Bequest, in memory of André Mertens, 1989   Rouen? 2325     France 9             Aerophone-Lip Vibrated 1012   Metropolitan Museum of Art, New York, NY 1
349880 89.4.2333 0 0 504712 Musical Instruments 18 Rattle 744 Rattle Chinese 10                           19th century 1800 1899 Ceramic 161 H. 11.4cm (4 1/2in.) The Crosby Brown Collection of Musical Instruments, 1889         China 13             Idiophone-Shaken-rattle 908   Metropolitan Museum of Art, New York, NY 1
349881 89.4.2334 0 0 504713 Musical Instruments 18 Whistle 963 Whistle Chinese 10                           19th century 1800 1899 Ceramic 161 H. 5.1 x W. 3.8cm (2 x 1 1/2in.) The Crosby Brown Collection of Musical Instruments, 1889         China 13             Aerophone-Blow Hole-vessel flute 918   Metropolitan Museum of Art, New York, NY 1
349882 89.4.2335 0 0 504714 Musical Instruments 18 Whistle 963 Whistle Chinese 10                           19th century 1800 1899 Ceramic 161 Overall: 6.4 x 6.4cm (2 1/2 x 2 1/2in.) The Crosby Brown Collection of Musical Instruments, 1889         China 13             Aerophone-Blow Hole-vessel flute 918   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 526.386ms · Data license: CC0 · Data source: metmuseum/openaccess