musiccaps
2 rows where aspect_list contains "crowd cheering" and audioset_ids contains "/m/03qtwd"
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 |
---|---|---|---|---|---|---|---|---|---|---|
qtNTHnXOQew | The low quality recording features an electro song played live and it consists of at least a punchy snare and a boomy bass. There are some crowd cheering noises in the background. It sounds muffled, energetic, aggressive and distorted as the recording is very noisy and in mono. | ["low quality", "muffled", "electro", "aggressive", "punchy snare", "boomy bass", "distorted", "noisy", "mono", "crowd cheering", "energetic"] | ["Electronic music", "Crowd", "Music", "Whoop", "Yell"] | 4 | 40 | 50 | 0 | 0 | ["/m/02lkt", "/m/03qtwd", "/m/04rlf", "/m/07rwj3x", "/m/07sr1lc"] | |
qxWVr67g6yY | This is the live performance of a pop music piece. It is an amateur recording. There are male vocals singing melodically. An electric guitar strums a chord for the ending of a song while the sounds of the cymbals can be heard from the acoustic drums. The cheers of the crowd can be heard even more than the music itself. This recording could be sampled for use in beat-making. | ["pop music", "live performance", "amateur recording", "male vocals", "melodic singing", "electric guitar", "acoustic drums", "crowd cheering"] | ["Singing", "Crowd", "Music", "Pop music", "Bang"] | 9 | 200 | 210 | 0 | 0 | ["/m/015lz1", "/m/03qtwd", "/m/04rlf", "/m/064t9", "/m/07pws3f"] |
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 );