musiccaps
3 rows where aspect_list contains "piano", aspect_list contains "saxophone" and audioset_ids contains "/m/01kcd"
This data as json, CSV (advanced)
ytid ▼ | url | caption | aspect_list | audioset_names | author_id | start_s | end_s | is_balanced_subset | is_audioset_eval | audioset_ids |
---|---|---|---|---|---|---|---|---|---|---|
IGyDtKAU1u8 | This is a jazz music piece. It is an instrumental piece. The saxophone and the trumpet are playing the melody. The piano, the electric guitar and the bass guitar are accompanying them in the background. The tempo is slow. The atmosphere is chill. This piece could be playing in the background at a coffee shop. | ["jazz music", "instrumental", "saxophone", "trumpet", "electric guitar", "piano", "bass guitar", "acoustic drums", "slow tempo", "chill"] | ["Brass instrument", "Saxophone", "Trombone"] | 9 | 550 | 560 | 0 | 0 | ["/m/01kcd", "/m/06ncr", "/m/07c6l"] | |
XpueyrkcMyQ | This is a jazz music piece. There is a trumpet and a saxophone playing the lead melody. The piano is playing the chords of the piece while the upright bass is playing a groovy bass line. The acoustic drums are playing a swing type beat for the rhythmic background. The atmosphere is groovy. This piece could be playing in the background at a coffee shop. | ["jazz", "instrumental", "trumpet", "saxophone", "upright bass", "piano", "acoustic drums", "groovy", "vibrant"] | ["Brass instrument", "Saxophone", "Trumpet"] | 9 | 280 | 290 | 0 | 0 | ["/m/01kcd", "/m/06ncr", "/m/07gql"] | |
ZHsAU90h8oc | This audio contains a jazz composition with a saxophone taking the lead-melody supported by a string section, a e-bass and a piano playing some notes along in a higher pitch. This song may be playing in a romantic restaurant. | ["jazz", "strings", "saxophone", "e-bass", "piano", "slow tempo", "melancholic"] | ["Brass instrument", "Saxophone"] | 6 | 130 | 140 | 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 );