musiccaps
2 rows where aspect_list contains "exciting" and audioset_ids contains "/m/01glhc"
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 |
---|---|---|---|---|---|---|---|---|---|---|
DUNOn71oGCw | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | 1 | 40 | 50 | 0 | 1 | ["/m/01b9nn", "/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/04szw", "/m/0fx80y"] | |
Nqb7nw58q08 | The song is an instrumental. The song is medium tempo with a groovy drumming rhythm, percussive bass line and cool electric guitar riff played repeatedly. The song is exciting and energetic. The song has smooth jazz or funk jazz roots. | ["electric guitar lead", "live performance", "live band", "guitar band", "exciting", "instrumental music", "adrenaline rush", "energetic", "electric guitar riff", "live audience", "entertaining", "funk jazz", "groovy drumming rhythm", "percussive bass line", "cymbals crashing", "improvisational music", "jazz funk", "smooth jazz", "groovy music", "medium fast tempo"] | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Psychedelic rock", "Progressive rock"] | 1 | 30 | 40 | 0 | 1 | ["/m/01glhc", "/m/02sgy", "/m/0342h", "/m/04rlf", "/m/05w3f", "/m/0dl5d"] |
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 );