musiccaps
2 rows where aspect_list contains "repetitive percussive element" and author_id = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|
VV-DgnPPhSo | The low quality recording features a cover of traditional folk song and it consists of reverberant, passionate female vocal singing over repetitive percussive instrument and plucked strings melody. It sounds passionate, cultural and emotional. | ["low quality", "noisy", "cover", "reverberant passionate female vocal", "traditional folk", "repetitive percussive element", "plucked strings melody", "passionate", "emotional", "cultural"] | ["Singing", "Carnatic music", "Music", "Classical music", "/t/dd00004"] | 4 | 220 | 230 | 1 | 1 | ["/m/015lz1", "/m/015vgc", "/m/04rlf", "/m/0ggq0m", "/t/dd00004"] | |
laVgKAcv8XA | The low quality recording features a synth wave disco instrumental that consists of punchy "4 on the floor" kick patter, reverberant snare hits, shimmering hi hats, widely spread high pitched synth lead, groovy synth bass and repetitive percussive element. It is noisy, but also energetic and groovy- like something you would hear in a disco club. | ["low quality", "synth wave disco", "muffled snare", "punchy \"4 on the floor\" kick pattern", "wide high pitched synth", "groovy synth bass", "repetitive percussive element", "shimmering hi hats", "energetic", "groovy", "noisy"] | ["Disco", "Music"] | 4 | 30 | 40 | 0 | 1 | ["/m/026z9", "/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 );