musiccaps
2 rows where aspect_list contains "claps" and audioset_ids = "["/m/02p0sh1", "/m/04rlf"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
5F8zpfwFKl0 | This is an Uzbek folk music piece. There is a female vocalist singing melodically. The main tune is being played by the garmon while the rhythmic background consists of the doors and the clapping of the dancers. There is a vibrant atmosphere in this piece. It could be used as an accompaniment piece for an Uzbek folk dance course. | ["uzbek folk music", "female vocal", "melodic singing", "garmon", "doira", "claps", "vibrant", "lively", "folk dance"] | ["Traditional music", "Music"] | 9 | 30 | 40 | 0 | 0 | ["/m/02p0sh1", "/m/04rlf"] | |
HS_ikHx4LIQ | The low quality recording features a hip hop song that consists bright, widely spread steel guitar melody, tinny muffled percussive elements, shimmering triangle, reverberant flute melody, claps, soft kick hits, mellow synth pad and groovy bass that glues everything together. It sounds kind of dull, but groovy, energetic and tropical - thanks to those flute and guitar melodies. | ["low quality", "hip hop", "tinny muffled percussive elements", "bright wide steel guitar melody", "shimmering triangle", "reverberant flute melody", "claps", "soft kick", "groovy bass", "mellow synth pad", "dull", "energetic", "tropical", "groovy"] | ["Traditional music", "Music"] | 4 | 190 | 200 | 1 | 1 | ["/m/02p0sh1", "/m/04rlf"] |
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 );