musiccaps
2 rows where aspect_list contains "bad audio quality", aspect_list contains "live audience" and aspect_list contains "performer"
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 |
---|---|---|---|---|---|---|---|---|---|---|
0NTzOtVmoiU | The song is an instrumental. The song is fast in tempo, with a bagpiper playing a Solo melody accompanied by a drum rhythm and people cheering and clapping wildly. The song is rousing in spirit and fervour. The song has a bad audio quality. | ["female bagpiper", "bagpipes playing", "live performance", "live audience", "crowds clapping", "crowds cheering", "drum playing percussively", "exciting solo", "passionate", "celtic music", "war cry", "victory march", "bad audio quality", "ambient crowd noise", "performer", "instrumental music", "exciting", "energetic", "enthusiastic", "groovy bass", "rhythm section", "medium fast tempo"] | ["Bagpipes", "Wind instrument, woodwind instrument"] | 1 | 60 | 70 | 0 | 0 | ["/m/0192l", "/m/085jw"] | |
cQX-WgT0ACQ | A guitarist is tuning his guitar making string noises, peg sounds and fretboard noises. The audio is very bad with a boomy low end. The conversation is engaging and keeps the crowds occupied as the guitarist gets ready for the next song. | ["guitarist talks", "tuning notes", "tuning pegs", "guitar master class", "guitar solo", "live concert", "live audience", "soloist", "random notes", "laughing", "bad audio quality", "engaging crowds", "performer", "famous guitarist", "tuning legs", "fretboard sounds", "no fixed tempo", "bad audio quality", "ambient crowd noises"] | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 1 | 20 | 30 | 0 | 0 | ["/m/01glhc", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] |
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 );