musiccaps
1 row where aspect_list contains "male singer", aspect_list contains "retro classic rock" and aspect_list contains "rock band"
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 |
---|---|---|---|---|---|---|---|---|---|---|
njFM8DvmPVU | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | 1 | 50 | 60 | 0 | 1 | ["/m/02mscn", "/m/0342h", "/m/03lty", "/m/04rlf", "/m/05w3f", "/m/06by7", "/m/074ft", "/m/0dl5d", "/m/0dls3"] |
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 );