musiccaps
1 row where aspect_list contains "piano accompaniment" and aspect_list contains "wind band repertoire"
This data as json, CSV (advanced)
aspect_list (array) 18 ✖
- celebratory 1
- cheerful 1
- classical music 1
- emphatic solos 1
- energetic 1
- energetic drumming 1
- enthusiastic 1
- fast tempo 1
- happy 1
- instrumental 1
- lively 1
- march like drum beat 1
- piano accompaniment · 1 ✖
- tenor sax 1
- western classical 1
- wind band repertoire · 1 ✖
- wind of provence 1
- youthful 1
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
0u4gY1bBUwQ | This music is a lively instrumental. The tempo is fast with a drum beat introduction, saxophone solo, piano solo, followed with lively harmony of the tenor sax and march like drumming. This piece is the song introduction. It is a lively, cheerful, happy, celebratory and youthful Western Classical. | ["instrumental", "fast tempo", "tenor sax", "energetic drumming", "wind of provence", "classical music", "western classical", "lively", "cheerful", "happy", "celebratory", "youthful", "emphatic solos", "piano accompaniment", "march like drum beat", "wind band repertoire", "lively", "energetic", "enthusiastic"] | ["Brass instrument", "Saxophone"] | 7 | 250 | 260 | 0 | 0 | ["/m/01kcd", "/m/06ncr"] |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [musiccaps] ( [ytid] TEXT PRIMARY KEY, [url] TEXT, [caption] TEXT, [aspect_list] TEXT, [audioset_names] TEXT, [author_id] TEXT, [start_s] TEXT, [end_s] TEXT, [is_balanced_subset] INTEGER, [is_audioset_eval] INTEGER, [audioset_ids] TEXT );