musiccaps
3 rows where aspect_list contains "piano" and audioset_ids contains "/m/0b9m1"
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 |
---|---|---|---|---|---|---|---|---|---|---|
ESbtW0CUmp4 | This audio contains someone playing a gospel/jazz melody when a very loud drum comes in with a fill-in on the toms. This is an amateur recording and of poor audio-quality. This song may be playing in a gospel church. | ["amateur recording", "gospel", "piano", "drums", "jazzy", "slower to medium tempo"] | ["Music", "Keyboard (musical)", "Harmonic", "Inside, large room or hall"] | 6 | 0 | 10 | 0 | 0 | ["/m/04rlf", "/m/05148p4", "/m/0b9m1", "/t/dd00126"] | |
cf-IIqhveKw | This is an edited version of a pop music piece. The song is in minor key which gives it a melancholic aura. There is a male vocalist singing emotionally in a sigh-like manner accompanied with a piano tune and atmospheric strings in the background. However, due to the artificially added gain, the piece is too loud and the audio is distorted. | ["pop music", "male vocal", "sigh-like singing", "melancholic", "piano", "strings", "loud", "distorted", "emotional"] | ["Music", "Harmonic"] | 9 | 370 | 380 | 0 | 1 | ["/m/04rlf", "/m/0b9m1"] | |
d1nz5tZckSA | Trio recorded live in a concert hall with a loud upright bass, piano and acoustic guitar playing a solo. Jazz feel and chord progression with no drums. Heartfelt performance. | ["loud upright bass", "acoustic guitar solo", "jazz chord progression", "piano", "no drums", "instrumental", "trio", "concert hall", "live", "heartfelt"] | ["Music", "Harmonic", "Inside, large room or hall"] | 8 | 280 | 290 | 1 | 1 | ["/m/04rlf", "/m/0b9m1", "/t/dd00126"] |
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 );