musiccaps
1 row where aspect_list contains "crowd clapping", aspect_list contains "passionate boy vocal" and aspect_list contains "reversed crash riser"
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 |
---|---|---|---|---|---|---|---|---|---|---|
pHj8U-3RHc4 | The low quality recording features a live performance of a pop song and it consists of a passionate boy vocal singing over wide synth melody, reversed crash riser, punchy kick and snare hits, shimmering hi hats, groovy synth bass and later sustained synth bass. There is some crowd noise and cheering sounds. It sounds addictive, energetic and exciting. | ["low quality", "pop", "live performance", "crowd cheering", "crowd clapping", "passionate boy vocal", "wide synth melody", "reversed crash riser", "punchy kick", "punchy bass", "sustained synth bass", "groovy synth bass", "shimmering hi hats", "energetic", "exciting", "addictive"] | ["Applause", "Music of Asia", "Music"] | 4 | 30 | 40 | 0 | 0 | ["/m/028ght", "/m/028sqc", "/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 );